/* Styles spécifiques pour la page SQL Joins */

/* Tables de données */
.data-table {
    width: 100%;
    border-collapse: collapse;
    background: var(--dark-card);
    border-radius: var(--radius-md);
    overflow: hidden;
    margin: 1.5rem 0;
}

.data-table thead {
    background: var(--dark-bg);
}

.data-table th {
    padding: 0.875rem;
    text-align: left;
    font-weight: 600;
    color: var(--text-primary);
    border-bottom: 2px solid var(--dark-border);
    font-size: 0.9rem;
}

.data-table td {
    padding: 0.75rem 0.875rem;
    border-bottom: 1px solid var(--dark-border);
    color: var(--text-secondary);
}

.data-table tbody tr:hover {
    background: rgba(79, 70, 229, 0.1);
}

.data-table tbody tr:last-child td {
    border-bottom: none;
}

.data-table.small {
    font-size: 0.85rem;
}

.data-table.small th,
.data-table.small td {
    padding: 0.5rem 0.625rem;
}

.null-value {
    color: var(--text-muted);
    font-style: italic;
    opacity: 0.6;
}

.highlight-row {
    background: rgba(245, 158, 11, 0.1);
    border-left: 3px solid var(--warning);
}

/* Tables showcase */
.tables-showcase {
    display: grid;
    grid-template-columns: repeat(auto-fit, minmax(280px, 1fr));
    gap: 1.5rem;
    margin: 2rem 0;
}

.table-preview {
    background: var(--dark-card);
    border: 1px solid var(--dark-border);
    border-radius: var(--radius-lg);
    padding: 1.5rem;
}

.table-preview h4 {
    color: var(--primary-color);
    margin-bottom: 1rem;
    font-size: 1.1rem;
    font-family: 'Fira Code', monospace;
}

/* Relations Grid */
.relations-grid {
    display: grid;
    grid-template-columns: repeat(auto-fit, minmax(280px, 1fr));
    gap: 2rem;
    margin: 2rem 0;
}

.relation-card {
    background: var(--dark-card);
    border: 2px solid var(--dark-border);
    border-radius: var(--radius-lg);
    padding: 2rem;
    text-align: center;
    transition: var(--transition);
}

.relation-card:hover {
    border-color: var(--primary-color);
    transform: translateY(-5px);
    box-shadow: var(--shadow-xl);
}

.relation-icon {
    font-size: 3rem;
    margin-bottom: 1rem;
}

.relation-card h3 {
    font-size: 1.3rem;
    margin-bottom: 0.75rem;
    color: var(--text-primary);
}

.relation-card p {
    color: var(--text-secondary);
    margin-bottom: 1.5rem;
    line-height: 1.6;
}

.relation-example {
    background: var(--dark-bg);
    padding: 1rem;
    border-radius: var(--radius-md);
    margin: 1rem 0;
    text-align: left;
}

.relation-example code {
    background: rgba(79, 70, 229, 0.2);
    padding: 0.2rem 0.5rem;
    border-radius: 3px;
    color: var(--primary-light);
}

.relation-diagram {
    background: var(--dark-bg);
    padding: 1rem;
    border-radius: var(--radius-md);
    font-family: 'Fira Code', monospace;
    font-size: 0.85rem;
    color: var(--text-muted);
}

/* Junction Table Showcase */
.junction-showcase {
    display: grid;
    grid-template-columns: 1fr auto 1fr;
    gap: 2rem;
    align-items: center;
    margin: 2rem 0;
    padding: 2rem;
    background: var(--dark-card);
    border: 1px solid var(--dark-border);
    border-radius: var(--radius-lg);
}

.junction-table,
.junction-middle {
    text-align: center;
}

.junction-middle {
    position: relative;
}

.junction-middle::before,
.junction-middle::after {
    content: '⟷';
    position: absolute;
    top: 50%;
    font-size: 2rem;
    color: var(--primary-color);
}

.junction-middle::before {
    left: -2.5rem;
}

.junction-middle::after {
    right: -2.5rem;
}

.junction-showcase h4 {
    color: var(--primary-color);
    margin-bottom: 1rem;
    font-family: 'Fira Code', monospace;
}

/* Join Header */
.join-header {
    text-align: center;
    margin: 2rem 0 3rem;
}

.join-badge {
    display: inline-block;
    padding: 0.75rem 1.5rem;
    border-radius: var(--radius-lg);
    font-weight: 700;
    font-size: 1.2rem;
    margin-bottom: 1rem;
    letter-spacing: 0.5px;
}

.join-inner {
    background: linear-gradient(135deg, #4f46e5, #6366f1);
    color: white;
}

.join-left {
    background: linear-gradient(135deg, #f59e0b, #fbbf24);
    color: white;
}

.join-right {
    background: linear-gradient(135deg, #10b981, #34d399);
    color: white;
}

.join-full {
    background: linear-gradient(135deg, #8b5cf6, #a78bfa);
    color: white;
}

.join-cross {
    background: linear-gradient(135deg, #ef4444, #f87171);
    color: white;
}

.join-description {
    font-size: 1.1rem;
    color: var(--text-secondary);
    max-width: 600px;
    margin: 0 auto;
}

/* Venn Diagrams */
.visual-diagram {
    margin: 2rem 0;
    text-align: center;
}

.visual-diagram h3 {
    margin-bottom: 1.5rem;
    color: var(--primary-color);
}

.venn-container {
    background: var(--dark-card);
    border: 1px solid var(--dark-border);
    border-radius: var(--radius-lg);
    padding: 2rem;
}

.venn-diagram {
    max-width: 400px;
    margin: 0 auto;
    display: block;
}

.venn-legend {
    margin-top: 1rem;
    color: var(--text-muted);
    font-size: 0.9rem;
}

/* Tables Comparison */
.tables-comparison {
    display: flex;
    gap: 2rem;
    justify-content: center;
    align-items: flex-start;
    margin: 2rem 0;
    flex-wrap: wrap;
}

.tables-comparison > div {
    background: var(--dark-card);
    border: 1px solid var(--dark-border);
    border-radius: var(--radius-lg);
    padding: 1.5rem;
}

.tables-comparison h4 {
    color: var(--primary-color);
    margin-bottom: 1rem;
    font-family: 'Fira Code', monospace;
    text-align: center;
}

/* Result Box */
.result-box {
    background: var(--dark-card);
    border: 2px solid var(--success);
    border-radius: var(--radius-lg);
    padding: 2rem;
    margin: 2rem 0;
}

.result-box h4 {
    color: var(--success);
    margin-bottom: 1.5rem;
    font-size: 1.2rem;
}

.result-box ul {
    margin-left: 1.5rem;
    color: var(--text-secondary);
}

.result-box li {
    margin-bottom: 0.5rem;
}

.result-note {
    margin-top: 1rem;
    padding: 0.75rem;
    background: rgba(245, 158, 11, 0.1);
    border-left: 3px solid var(--warning);
    border-radius: var(--radius-md);
    color: var(--warning);
    font-weight: 500;
}

/* Use Case Box */
.use-case-box {
    background: rgba(79, 70, 229, 0.1);
    border: 1px solid var(--primary-color);
    border-radius: var(--radius-lg);
    padding: 1.5rem;
    margin: 2rem 0;
}

.use-case-box h3 {
    color: var(--primary-color);
    margin-bottom: 1rem;
}

.use-case-box ul {
    margin-left: 1.5rem;
    color: var(--text-secondary);
}

.use-case-box li {
    margin-bottom: 0.5rem;
}

/* Optimization Grid */
.optimization-grid {
    display: grid;
    grid-template-columns: repeat(auto-fit, minmax(280px, 1fr));
    gap: 1.5rem;
    margin: 2rem 0;
}

.optimization-card {
    background: var(--dark-card);
    border: 1px solid var(--dark-border);
    border-radius: var(--radius-lg);
    padding: 2rem;
    transition: var(--transition);
}

.optimization-card:hover {
    border-color: var(--primary-color);
    transform: translateY(-3px);
    box-shadow: var(--shadow-lg);
}

.optimization-icon {
    font-size: 2.5rem;
    margin-bottom: 1rem;
    text-align: center;
}

.optimization-card h3 {
    font-size: 1.2rem;
    margin-bottom: 1rem;
    color: var(--text-primary);
}

.optimization-card p {
    color: var(--text-secondary);
    margin-bottom: 1rem;
    line-height: 1.6;
}

.optimization-card .code-block {
    margin-top: 1rem;
}

.optimization-card .code-block pre {
    padding: 0.75rem;
}

/* SQL Code specifics */
code.language-sql {
    color: #a6e3a1;
}

.language-sql .keyword {
    color: #89b4fa;
    font-weight: 600;
}

.language-sql .string {
    color: #f9e2af;
}

.language-sql .comment {
    color: #6c7086;
    font-style: italic;
}

/* Interactive hover on tables */
.data-table tbody tr {
    transition: var(--transition);
}

.data-table tbody tr td:first-child {
    font-weight: 500;
}

/* Responsive adjustments */
@media (max-width: 768px) {
    .tables-showcase {
        grid-template-columns: 1fr;
    }
    
    .relations-grid {
        grid-template-columns: 1fr;
    }
    
    .junction-showcase {
        grid-template-columns: 1fr;
        gap: 1rem;
    }
    
    .junction-middle::before,
    .junction-middle::after {
        display: none;
    }
    
    .optimization-grid {
        grid-template-columns: 1fr;
    }
    
    .tables-comparison {
        flex-direction: column;
    }
}

/* Animation for result boxes */
@keyframes slideInFromBottom {
    from {
        opacity: 0;
        transform: translateY(20px);
    }
    to {
        opacity: 1;
        transform: translateY(0);
    }
}

.result-box {
    animation: slideInFromBottom 0.5s ease-out;
}

/* Special styling for SQL comments in code */
.code-block .token.comment {
    color: #6c7086;
}

.code-block .token.keyword {
    color: #89b4fa;
    font-weight: 600;
}

.code-block .token.string {
    color: #f9e2af;
}

.code-block .token.number {
    color: #fab387;
}

/* Enhanced table preview */
.table-preview:hover {
    box-shadow: var(--shadow-lg);
    border-color: var(--primary-color);
}

/* Code comparison layout */
.code-comparison {
    display: grid;
    grid-template-columns: 1fr 1fr;
    gap: 1rem;
    margin: 2rem 0;
}

.code-comparison .code-block {
    margin: 0;
}

@media (max-width: 768px) {
    .code-comparison {
        grid-template-columns: 1fr;
    }
}