/* CSS Variables for Light Theme */
:root {
  --primary-color: #0d6efd;
  --secondary-color: #6c757d;
  --success-color: #198754;
  --danger-color: #dc3545;
  --warning-color: #ffc107;
  --info-color: #0dcaf0;
  
  --bg-primary: #ffffff;
  --bg-secondary: #f8f9fa;
  --bg-tertiary: #e9ecef;
  
  --text-primary: #212529;
  --text-secondary: #6c757d;
  --text-muted: #868e96;
  
  --border-color: #dee2e6;
  --shadow: 0 0.125rem 0.25rem rgba(0, 0, 0, 0.075);
  --shadow-lg: 0 1rem 3rem rgba(0, 0, 0, 0.175);
}

/* Dark Theme Variables */
[data-theme="dark"] {
  --primary-color: #4dabf7;
  --secondary-color: #868e96;
  --success-color: #51cf66;
  --danger-color: #ff6b6b;
  --warning-color: #ffd43b;
  --info-color: #74c0fc;
  
  --bg-primary: #212529;
  --bg-secondary: #343a40;
  --bg-tertiary: #495057;
  
  --text-primary: #f8f9fa;
  --text-secondary: #ced4da;
  --text-muted: #adb5bd;
  
  --border-color: #495057;
  --shadow: 0 0.125rem 0.25rem rgba(0, 0, 0, 0.3);
  --shadow-lg: 0 1rem 3rem rgba(0, 0, 0, 0.5);
}

/* RTL Support */
[dir="rtl"] {
  text-align: right;
}

[dir="rtl"] .navbar-brand {
  margin-right: 0;
  margin-left: 1rem;
}

[dir="rtl"] .me-2 {
  margin-right: 0 !important;
  margin-left: 0.5rem !important;
}

[dir="rtl"] .ms-2 {
  margin-left: 0 !important;
  margin-right: 0.5rem !important;
}

/* Base Styles */
body {
  font-family: 'Inter', sans-serif;
  background-color: var(--bg-secondary);
  color: var(--text-primary);
  transition: background-color 0.3s ease, color 0.3s ease;
}

/* Dark theme body styles */
[data-theme="dark"] body {
  background-color: var(--bg-primary);
}

[data-theme="dark"] .navbar-dark {
  background-color: var(--bg-tertiary) !important;
}

[data-theme="dark"] .card {
  background-color: var(--bg-secondary);
  border-color: var(--border-color);
  color: var(--text-primary);
}

[data-theme="dark"] .card-title,
[data-theme="dark"] .card-text,
[data-theme="dark"] .card-body,
[data-theme="dark"] .card h1,
[data-theme="dark"] .card h2,
[data-theme="dark"] .card h3,
[data-theme="dark"] .card h4,
[data-theme="dark"] .card h5,
[data-theme="dark"] .card h6,
[data-theme="dark"] .card p,
[data-theme="dark"] .card span,
[data-theme="dark"] .card div {
  color: var(--text-primary) !important;
}

[data-theme="dark"] .text-muted {
  color: var(--text-muted) !important;
}

[data-theme="dark"] .text-secondary {
  color: var(--text-secondary) !important;
}

[data-theme="dark"] small,
[data-theme="dark"] .small {
  color: var(--text-secondary) !important;
}

/* Structure Cards - Ensure proper text visibility */
[data-theme="dark"] .structure-card,
[data-theme="dark"] .report-card {
  color: var(--text-primary) !important;
}

[data-theme="dark"] .structure-card .card-title,
[data-theme="dark"] .report-card .card-title {
  color: var(--text-primary) !important;
}

[data-theme="dark"] .structure-card .badge,
[data-theme="dark"] .report-card .badge {
  background-color: var(--bg-tertiary) !important;
  color: var(--text-primary) !important;
}

/* Button groups and button styling */
[data-theme="dark"] .btn-group .btn {
  border-color: var(--border-color);
}

[data-theme="dark"] .btn-outline-primary {
  color: var(--primary-color);
  border-color: var(--primary-color);
}

[data-theme="dark"] .btn-outline-primary:hover {
  background-color: var(--primary-color);
  color: #ffffff;
}

[data-theme="dark"] .btn-outline-success {
  color: var(--success-color);
  border-color: var(--success-color);
}

[data-theme="dark"] .btn-outline-success:hover {
  background-color: var(--success-color);
  color: #ffffff;
}

[data-theme="dark"] .btn-outline-danger {
  color: var(--danger-color);
  border-color: var(--danger-color);
}

[data-theme="dark"] .btn-outline-danger:hover {
  background-color: var(--danger-color);
  color: #ffffff;
}

[data-theme="dark"] .btn-outline-secondary {
  color: var(--text-secondary);
  border-color: var(--border-color);
}

[data-theme="dark"] .btn-outline-secondary:hover {
  background-color: var(--bg-tertiary);
  color: var(--text-primary);
  border-color: var(--border-color);
}

/* General text elements in dark mode */
[data-theme="dark"] h1,
[data-theme="dark"] h2,
[data-theme="dark"] h3,
[data-theme="dark"] h4,
[data-theme="dark"] h5,
[data-theme="dark"] h6 {
  color: var(--text-primary) !important;
}

[data-theme="dark"] p,
[data-theme="dark"] span,
[data-theme="dark"] div:not(.btn):not(.badge) {
  color: var(--text-primary);
}

/* Badge styling for dark mode */
[data-theme="dark"] .badge {
  background-color: var(--bg-tertiary) !important;
  color: var(--text-primary) !important;
}

[data-theme="dark"] .badge.bg-primary {
  background-color: var(--primary-color) !important;
  color: #ffffff !important;
}

[data-theme="dark"] .badge.bg-secondary {
  background-color: var(--secondary-color) !important;
  color: #ffffff !important;
}

/* Ensure structure card stats are visible */
[data-theme="dark"] .structure-stats,
[data-theme="dark"] .report-stats {
  color: var(--text-primary) !important;
}

[data-theme="dark"] .structure-stats .text-muted,
[data-theme="dark"] .report-stats .text-muted {
  color: var(--text-secondary) !important;
}

[data-theme="dark"] .form-control,
[data-theme="dark"] .form-select {
  background-color: var(--bg-tertiary);
  border-color: var(--border-color);
  color: var(--text-primary);
}

[data-theme="dark"] .form-control:focus,
[data-theme="dark"] .form-select:focus {
  background-color: var(--bg-tertiary);
  border-color: var(--primary-color);
  color: var(--text-primary);
  box-shadow: 0 0 0 0.25rem rgba(13, 110, 253, 0.25);
}

[data-theme="dark"] .modal-content {
  background-color: var(--bg-secondary);
  color: var(--text-primary);
}

[data-theme="dark"] .dropdown-menu {
  background-color: var(--bg-secondary);
  border-color: var(--border-color);
}

[data-theme="dark"] .dropdown-item {
  color: var(--text-primary);
}

[data-theme="dark"] .dropdown-item:hover {
  background-color: var(--bg-tertiary);
}

/* Dropdown Menu Z-Index Fix */
.dropdown-menu {
  z-index: 1050 !important;
}

/* Structure Card Dropdown Specific Styling */
.structure-card .dropdown-menu {
  z-index: 1055 !important;
  box-shadow: 0 0.5rem 1rem rgba(0, 0, 0, 0.15);
  border: 1px solid var(--border-color);
}

/* Report Card Dropdown Specific Styling */
.report-card .dropdown-menu {
  z-index: 1055 !important;
}

[data-theme="dark"] .table {
  color: var(--text-primary);
}

[data-theme="dark"] .table-striped > tbody > tr:nth-of-type(odd) > td {
  background-color: var(--bg-tertiary);
}

/* Upload Area Styles */
.upload-area {
  border: 2px dashed var(--border-color);
  border-radius: 0.5rem;
  padding: 3rem;
  text-align: center;
  transition: all 0.3s ease;
  background-color: var(--bg-primary);
}

.upload-area:hover {
  border-color: var(--primary-color);
  background-color: var(--bg-secondary);
}

.upload-area.dragover {
  border-color: var(--primary-color);
  background-color: rgba(13, 110, 253, 0.1);
}

/* Card Styles */
.card {
  border: none;
  box-shadow: var(--shadow);
  transition: box-shadow 0.3s ease;
}

.card:hover {
  box-shadow: var(--shadow-lg);
}

/* Structure Card */
.structure-card {
  cursor: pointer;
  transition: transform 0.2s ease;
  position: relative;
}

.structure-card:hover {
  transform: translateY(-2px);
  z-index: 1;
}

.structure-info {
  background-color: var(--bg-secondary);
  border-radius: 0.375rem;
  padding: 1rem;
  margin-bottom: 1rem;
}

/* Upload Progress Overlay for Structure Cards */
.upload-progress-overlay {
  position: absolute;
  top: 0;
  left: 0;
  right: 0;
  bottom: 0;
  background: rgba(255, 255, 255, 0.98);
  display: flex;
  flex-direction: column;
  align-items: center;
  justify-content: center;
  z-index: 10;
  border-radius: 0.5rem;
  padding: 1.5rem;
}

[data-theme="dark"] .upload-progress-overlay {
  background: rgba(33, 37, 41, 0.98);
}

.upload-progress-content {
  text-align: center;
  width: 100%;
}

.upload-progress-structure-name {
  font-size: 1.25rem;
  font-weight: 600;
  color: var(--text-primary);
  margin-bottom: 1rem;
  text-align: center;
}

[data-theme="dark"] .upload-progress-structure-name {
  color: var(--text-primary);
}

.upload-progress-spinner {
  width: 50px;
  height: 50px;
  margin: 0 auto 1rem;
  border: 4px solid var(--border-color);
  border-top-color: var(--primary-color);
  border-radius: 50%;
  animation: spin 1s linear infinite;
}

@keyframes spin {
  to { transform: rotate(360deg); }
}

.upload-progress-bar-container {
  width: 100%;
  height: 30px;
  background-color: var(--bg-tertiary);
  border-radius: 15px;
  overflow: hidden;
  margin: 1rem 0;
  box-shadow: inset 0 2px 4px rgba(0,0,0,0.1);
}

.upload-progress-bar {
  height: 100%;
  background: linear-gradient(90deg, #0d6efd 0%, #0dcaf0 100%);
  border-radius: 15px;
  transition: width 0.3s ease;
  display: flex;
  align-items: center;
  justify-content: center;
  color: white;
  font-weight: 600;
  font-size: 0.875rem;
  box-shadow: 0 2px 4px rgba(13,110,253,0.3);
  min-width: 30px;
}

.upload-progress-bar.complete {
  background: linear-gradient(90deg, #198754 0%, #20c997 100%);
}

.upload-progress-bar.error {
  background: linear-gradient(90deg, #dc3545 0%, #fd7e14 100%);
}

.upload-progress-message {
  font-size: 0.95rem;
  color: var(--text-secondary);
  margin-top: 0.5rem;
  min-height: 1.5rem;
  font-weight: 500;
}

.upload-progress-stats {
  display: flex;
  justify-content: space-around;
  margin-top: 1rem;
  font-size: 0.875rem;
  gap: 1rem;
}

.upload-progress-stat {
  text-align: center;
  flex: 1;
}

.upload-progress-stat-value {
  font-weight: 600;
  font-size: 1.1rem;
  color: var(--primary-color);
}

.upload-progress-stat-label {
  color: var(--text-muted);
  font-size: 0.8rem;
  margin-top: 0.25rem;
}

/* Column Definition Table */
.column-definition {
  background-color: var(--bg-primary);
  border: 1px solid var(--border-color);
  border-radius: 0.375rem;
  padding: 0.75rem;
  margin-bottom: 0.5rem;
}

.column-type-badge {
  font-size: 0.75rem;
  padding: 0.25rem 0.5rem;
}

/* Loading Spinner */
.loading-spinner {
  position: fixed;
  top: 0;
  left: 0;
  width: 100%;
  height: 100%;
  background-color: rgba(0, 0, 0, 0.5);
  display: flex;
  justify-content: center;
  align-items: center;
  z-index: 9999;
}

/* Modern Confirmation Modal Styles */
#modern-confirm-modal .modal-content {
  border-radius: 16px;
  overflow: hidden;
  border: none;
  box-shadow: 0 20px 60px rgba(0, 0, 0, 0.2);
}

#modern-confirm-modal .modal-body {
  padding: 2rem !important;
}

.confirm-icon-container {
  width: 80px;
  height: 80px;
  display: flex;
  align-items: center;
  justify-content: center;
  border-radius: 50%;
  background: rgba(255, 193, 7, 0.1);
  border: 3px solid rgba(255, 193, 7, 0.2);
  transition: all 0.3s ease;
}

.confirm-icon-container.danger {
  background: rgba(220, 53, 69, 0.1);
  border-color: rgba(220, 53, 69, 0.2);
}

.confirm-icon-container.success {
  background: rgba(25, 135, 84, 0.1);
  border-color: rgba(25, 135, 84, 0.2);
}

.confirm-icon-container.info {
  background: rgba(13, 202, 240, 0.1);
  border-color: rgba(13, 202, 240, 0.2);
}

#modern-confirm-modal .confirm-icon-container i {
  font-size: 2.5rem;
  animation: pulse 2s infinite;
}

@keyframes pulse {
  0% { transform: scale(1); }
  50% { transform: scale(1.05); }
  100% { transform: scale(1); }
}

#modern-confirm-modal .modal-title {
  color: var(--text-primary);
  font-size: 1.25rem;
  font-weight: 600;
}

#modern-confirm-modal .btn {
  border-radius: 12px;
  font-weight: 500;
  padding: 0.75rem 2rem;
  transition: all 0.2s ease;
  border-width: 2px;
  min-width: 120px;
}

#modern-confirm-modal .btn:hover {
  transform: translateY(-2px);
  box-shadow: 0 8px 25px rgba(0, 0, 0, 0.15);
}

#modern-confirm-modal .btn:active {
  transform: translateY(0);
}

#modern-confirm-modal .btn-outline-secondary:hover {
  background-color: #6c757d;
  border-color: #6c757d;
  color: white;
}

#modern-confirm-modal .btn-primary {
  background: linear-gradient(135deg, #007bff 0%, #0056b3 100%);
  border-color: #007bff;
}

#modern-confirm-modal .btn-primary:hover {
  background: linear-gradient(135deg, #0056b3 0%, #004085 100%);
  border-color: #0056b3;
}

#modern-confirm-modal .btn-danger {
  background: linear-gradient(135deg, #dc3545 0%, #a71e2a 100%);
  border-color: #dc3545;
}

#modern-confirm-modal .btn-danger:hover {
  background: linear-gradient(135deg, #a71e2a 0%, #7a1a1a 100%);
  border-color: #a71e2a;
}

/* Animation for modal appearance */
#modern-confirm-modal.fade .modal-dialog {
  transform: translate(0, -50px) scale(0.9);
  transition: all 0.3s cubic-bezier(0.34, 1.56, 0.64, 1);
}

#modern-confirm-modal.show .modal-dialog {
  transform: translate(0, 0) scale(1);
}

/* Dark theme support for confirmation modal */
[data-theme="dark"] #modern-confirm-modal .modal-content {
  background-color: var(--bg-secondary);
  color: var(--text-primary);
  box-shadow: 0 20px 60px rgba(0, 0, 0, 0.5);
}

[data-theme="dark"] #modern-confirm-modal .text-muted {
  color: var(--text-secondary) !important;
}

[data-theme="dark"] .confirm-icon-container {
  background: rgba(255, 193, 7, 0.15);
  border-color: rgba(255, 193, 7, 0.3);
}

[data-theme="dark"] .confirm-icon-container.danger {
  background: rgba(220, 53, 69, 0.15);
  border-color: rgba(220, 53, 69, 0.3);
}

[data-theme="dark"] .confirm-icon-container.success {
  background: rgba(25, 135, 84, 0.15);
  border-color: rgba(25, 135, 84, 0.3);
}

[data-theme="dark"] .confirm-icon-container.info {
  background: rgba(13, 202, 240, 0.15);
  border-color: rgba(13, 202, 240, 0.3);
}

/* Match Score Badge */
.match-score {
  font-weight: 600;
  padding: 0.375rem 0.75rem;
  border-radius: 1rem;
  font-size: 0.875rem;
}

.match-score.perfect {
  background-color: var(--success-color);
  color: white;
}

.match-score.good {
  background-color: var(--warning-color);
  color: black;
}

.match-score.partial {
  background-color: var(--info-color);
  color: black;
}

/* Report Builder Styles */
.structure-relation-item {
  background-color: var(--bg-secondary);
  border: 1px solid var(--border-color);
  border-radius: 0.375rem;
  padding: 1rem;
  margin-bottom: 1rem;
}

.field-selector {
  max-height: 300px;
  overflow-y: auto;
  border: 1px solid var(--border-color);
  border-radius: 0.375rem;
  padding: 1rem;
}

/* Data Table Styles */
.data-table {
  max-height: 500px;
  overflow: auto;
}

.data-table table {
  font-size: 0.875rem;
}

/* Filter Panel */
.filter-panel {
  background-color: var(--bg-secondary);
  border-radius: 0.375rem;
  padding: 1.5rem;
  margin-bottom: 1.5rem;
}

/* Statistics Cards */
.stat-card {
  text-align: center;
  padding: 1.5rem;
  border-radius: 0.5rem;
  background: linear-gradient(135deg, var(--primary-color), var(--info-color));
  color: white;
  margin-bottom: 1rem;
}

.stat-number {
  font-size: 2rem;
  font-weight: 700;
  line-height: 1;
}

.stat-label {
  font-size: 0.875rem;
  opacity: 0.9;
  text-transform: uppercase;
  letter-spacing: 0.05em;
}

/* Responsive Design */
@media (max-width: 768px) {
  .upload-area {
    padding: 2rem 1rem;
  }
  
  .navbar-brand {
    font-size: 1.1rem;
  }
  
  .container-fluid {
    padding-left: 1rem;
    padding-right: 1rem;
  }
}

/* Animation Classes */
.fade-in {
  animation: fadeIn 0.3s ease-in;
}

@keyframes fadeIn {
  from { opacity: 0; transform: translateY(10px); }
  to { opacity: 1; transform: translateY(0); }
}

.slide-in {
  animation: slideIn 0.3s ease-out;
}

@keyframes slideIn {
  from { transform: translateX(-20px); opacity: 0; }
  to { transform: translateX(0); opacity: 1; }
}

/* Custom Scrollbar */
::-webkit-scrollbar {
  width: 8px;
}

::-webkit-scrollbar-track {
  background: var(--bg-secondary);
}

::-webkit-scrollbar-thumb {
  background: var(--border-color);
  border-radius: 4px;
}

::-webkit-scrollbar-thumb:hover {
  background: var(--text-muted);
}

/* Print Styles */
@media print {
  .navbar,
  .modal,
  .toast-container,
  .loading-spinner {
    display: none !important;
  }
  
  .card {
    box-shadow: none;
    border: 1px solid #000;
  }
}

/* Accessibility Improvements */
.sr-only {
  position: absolute;
  width: 1px;
  height: 1px;
  padding: 0;
  margin: -1px;
  overflow: hidden;
  clip: rect(0, 0, 0, 0);
  white-space: nowrap;
  border: 0;
}

.focus-visible {
  outline: 2px solid var(--primary-color);
  outline-offset: 2px;
}

/* High contrast mode support */
@media (prefers-contrast: high) {
  .card {
    border: 2px solid var(--text-primary);
  }
  
  .upload-area {
    border-width: 3px;
  }
}

/* Upload summary statistics */
.stat-item {
  padding: 0.5rem;
}

.stat-number {
  font-size: 1.5rem;
  font-weight: bold;
  margin-bottom: 0.25rem;
}

.stat-label {
  font-size: 0.875rem;
  color: var(--text-muted);
  text-transform: uppercase;
  letter-spacing: 0.5px;
}

.warning-item {
  padding: 0.25rem 0;
  border-bottom: 1px solid var(--border-color);
}

.warning-item:last-child {
  border-bottom: none;
}

/* Visual Relationship Builder Styles */
.visual-canvas {
  min-height: 400px;
  height: 500px;
  background-color: var(--bg-secondary);
  background-image: 
    linear-gradient(90deg, rgba(13, 110, 253, 0.15) 1px, transparent 1px),
    linear-gradient(rgba(13, 110, 253, 0.15) 1px, transparent 1px);
  background-size: 20px 20px;
  position: relative;
  overflow: auto;
  border-radius: 8px;
  min-width: 100%;
  border: 1px solid var(--border-color);
}

.structure-box {
  position: absolute;
  background: var(--bg-primary);
  border: 2px solid var(--primary-color);
  border-radius: 8px;
  box-shadow: var(--shadow-lg);
  min-width: 200px;
  cursor: move;
  z-index: 10;
}

.structure-box.dragging {
  opacity: 0.8;
  transform: scale(1.02);
  box-shadow: 0 10px 25px rgba(0, 0, 0, 0.2);
}

.structure-header {
  background: var(--primary-color);
  color: white;
  padding: 8px 12px;
  border-radius: 6px 6px 0 0;
  font-weight: 600;
  font-size: 14px;
  display: flex;
  justify-content: between;
  align-items: center;
}

.structure-header .drag-handle {
  cursor: move;
  margin-left: auto;
}

.structure-columns {
  padding: 0;
  max-height: 300px;
  overflow-y: auto;
}

.column-item {
  padding: 10px 12px;
  border-bottom: 1px solid var(--border-color);
  cursor: pointer;
  transition: all 0.2s ease;
  display: flex;
  align-items: center;
  position: relative;
  user-select: none;
  min-height: 40px;
}

.column-item:hover {
  background: var(--bg-secondary);
  transform: translateX(2px);
  box-shadow: 2px 0 4px rgba(0,0,0,0.1);
}

.column-item:last-child {
  border-bottom: none;
}

.column-item.connecting {
  background: rgba(13, 110, 253, 0.15);
  border-left: 4px solid var(--primary-color);
  box-shadow: inset 0 0 0 1px rgba(13, 110, 253, 0.3);
}

.column-item.connecting:hover {
  background: rgba(13, 110, 253, 0.25);
  transform: translateX(4px);
}

.column-item.source-column {
  background: rgba(25, 135, 84, 0.15);
  border-left: 4px solid var(--success-color);
  box-shadow: inset 0 0 0 1px rgba(25, 135, 84, 0.3);
}

.column-item.target-hover {
  background: rgba(255, 193, 7, 0.15);
  border-left: 4px solid var(--warning-color);
  box-shadow: inset 0 0 0 1px rgba(255, 193, 7, 0.3);
}

.column-item.connected {
  background: rgba(25, 135, 84, 0.1);
  border-left: 3px solid var(--success-color);
}

.column-content {
  display: flex;
  align-items: center;
  flex: 1;
}

.column-name {
  font-size: 13px;
  font-weight: 500;
  flex: 1;
}

.column-type {
  font-size: 11px;
  color: var(--text-secondary);
  background: var(--bg-tertiary);
  padding: 2px 6px;
  border-radius: 4px;
  margin-left: 8px;
}

.connection-indicator {
  opacity: 0.4;
  transition: all 0.2s ease;
  margin-right: 8px;
  color: var(--primary-color);
  font-size: 12px;
}

.column-item:hover .connection-indicator {
  opacity: 0.8;
  transform: scale(1.1);
}

.column-item.connecting .connection-indicator,
.column-item.source-column .connection-indicator {
  opacity: 1;
  color: var(--primary-color);
  animation: pulse 1.5s infinite;
}

@keyframes pulse {
  0%, 100% { opacity: 1; }
  50% { opacity: 0.5; }
}

.connection-point {
  width: 6px;
  height: 6px;
  border: 1px solid var(--primary-color);
  background: var(--bg-primary);
  border-radius: 50%;
  position: absolute;
  right: 8px;
  top: 50%;
  transform: translateY(-50%);
  opacity: 0.6;
  z-index: 1;
  pointer-events: none;
}

.column-item:hover .connection-point {
  opacity: 1;
  transform: translateY(-50%) scale(1.1);
}

.column-item.connecting .connection-point,
.column-item.source-column .connection-point {
  background: var(--primary-color);
  opacity: 1;
  transform: translateY(-50%) scale(1.2);
  box-shadow: 0 0 6px rgba(13, 110, 253, 0.4);
}

/* SVG Connections */
.connections-svg {
  position: absolute;
  top: 0;
  left: 0;
  width: 100%;
  height: 100%;
  pointer-events: none;
  z-index: 5;
}

.connection-line {
  stroke: var(--primary-color);
  stroke-width: 2;
  fill: none;
  marker-end: url(#arrowhead);
  color: var(--primary-color);
}

.connection-line.temporary {
  stroke: var(--warning-color);
  stroke-dasharray: 5,5;
}

.connection-label {
  font-size: 11px;
  fill: var(--text-primary);
  font-weight: 600;
  text-anchor: middle;
}

.join-type-selector {
  position: absolute;
  background: var(--bg-primary);
  border: 1px solid var(--border-color);
  border-radius: 6px;
  padding: 8px;
  box-shadow: var(--shadow-lg);
  z-index: 100;
  min-width: 140px;
}

.join-type-option {
  display: block;
  width: 100%;
  padding: 4px 8px;
  border: none;
  background: none;
  text-align: left;
  border-radius: 4px;
  cursor: pointer;
  font-size: 12px;
}

.join-type-option:hover {
  background: var(--bg-secondary);
}

/* Relation Mode Toggle */
.btn-check:checked + .btn-outline-primary {
  background-color: var(--primary-color);
  border-color: var(--primary-color);
  color: white;
}

/* Canvas Actions */
.canvas-actions {
  position: absolute;
  top: 10px;
  right: 10px;
  display: flex;
  gap: 8px;
  z-index: 15;
}

.canvas-action-btn {
  background: var(--bg-primary);
  border: 1px solid var(--border-color);
  border-radius: 6px;
  padding: 8px 12px;
  font-size: 14px;
  cursor: pointer;
  transition: all 0.2s ease;
  box-shadow: var(--shadow);
}

.canvas-action-btn:hover {
  background: var(--bg-secondary);
  box-shadow: var(--shadow-lg);
  transform: translateY(-1px);
}

.canvas-action-btn:active {
  transform: translateY(0);
}

/* Canvas Content */
.canvas-content {
  position: relative;
  min-width: 100%;
  min-height: 100%;
}

/* Scroll indicators */
.visual-canvas::-webkit-scrollbar {
  width: 8px;
  height: 8px;
}

.visual-canvas::-webkit-scrollbar-track {
  background: var(--bg-tertiary);
  border-radius: 4px;
}

.visual-canvas::-webkit-scrollbar-thumb {
  background: var(--primary-color);
  border-radius: 4px;
}

.visual-canvas::-webkit-scrollbar-thumb:hover {
  background: var(--primary-color);
  opacity: 0.8;
}

.visual-canvas::-webkit-scrollbar-corner {
  background: var(--bg-tertiary);
}

/* Scroll hint overlay */
.scroll-hint {
  position: absolute;
  bottom: 20px;
  right: 20px;
  background: rgba(13, 110, 253, 0.9);
  color: white;
  padding: 8px 12px;
  border-radius: 6px;
  font-size: 12px;
  pointer-events: none;
  opacity: 0;
  transition: opacity 0.3s ease;
  z-index: 20;
}

.visual-canvas.show-scroll-hint .scroll-hint {
  opacity: 1;
}

/* Responsive */
@media (max-width: 768px) {
  .structure-box {
    min-width: 160px;
  }
  
  .visual-canvas {
    min-height: 300px;
  }
  
  .structure-header {
    font-size: 12px;
    padding: 6px 10px;
  }
  
  .column-item {
    padding: 8px 10px;
    min-height: 36px;
  }
  
  .connection-indicator {
    font-size: 11px;
  }
  
  .column-name {
    font-size: 12px;
  }
}

/* Dark theme adjustments */
[data-theme="dark"] .visual-canvas {
  background-color: var(--bg-secondary);
  background-image: 
    linear-gradient(90deg, rgba(77, 171, 247, 0.2) 1px, transparent 1px),
    linear-gradient(rgba(77, 171, 247, 0.2) 1px, transparent 1px);
  border-color: var(--border-color);
}

[data-theme="dark"] .canvas-content {
  background-color: var(--bg-secondary);
}

[data-theme="dark"] .connection-line {
  stroke: var(--primary-color);
  color: var(--primary-color);
}

[data-theme="dark"] .connection-line.temporary {
  stroke: var(--warning-color);
  color: var(--warning-color);
}

[data-theme="dark"] .connection-label {
  fill: var(--text-primary);
}

[data-theme="dark"] .structure-box {
  background: var(--bg-primary);
  border-color: var(--primary-color);
  box-shadow: 0 8px 25px rgba(0, 0, 0, 0.4);
}

[data-theme="dark"] .structure-header {
  background: var(--primary-color);
  color: white;
}

[data-theme="dark"] .column-item {
  border-bottom-color: var(--border-color);
}

[data-theme="dark"] .column-item:hover {
  background: var(--bg-secondary);
  box-shadow: 2px 0 4px rgba(255,255,255,0.1);
}

[data-theme="dark"] .column-item.connecting {
  background: rgba(77, 171, 247, 0.2);
  border-left-color: var(--primary-color);
  box-shadow: inset 0 0 0 1px rgba(77, 171, 247, 0.4);
}

[data-theme="dark"] .column-item.connecting:hover {
  background: rgba(77, 171, 247, 0.3);
}

[data-theme="dark"] .column-item.source-column {
  background: rgba(81, 207, 102, 0.2);
  border-left-color: var(--success-color);
  box-shadow: inset 0 0 0 1px rgba(81, 207, 102, 0.4);
}

[data-theme="dark"] .column-item.target-hover {
  background: rgba(255, 193, 7, 0.2);
  border-left-color: var(--warning-color);
  box-shadow: inset 0 0 0 1px rgba(255, 193, 7, 0.4);
}

[data-theme="dark"] .column-item.connected {
  background: rgba(81, 207, 102, 0.15);
  border-left-color: var(--success-color);
}

[data-theme="dark"] .connection-point {
  border-color: var(--primary-color);
  background: var(--bg-primary);
}

[data-theme="dark"] .connection-point:hover,
[data-theme="dark"] .connection-point.active {
  background: var(--primary-color);
}

[data-theme="dark"] .connection-indicator {
  color: var(--primary-color);
}

[data-theme="dark"] .column-item.connecting .connection-indicator,
[data-theme="dark"] .column-item.source-column .connection-indicator {
  color: var(--primary-color);
}

[data-theme="dark"] .join-type-selector {
  background: var(--bg-primary);
  border-color: var(--border-color);
  box-shadow: 0 8px 25px rgba(0, 0, 0, 0.4);
}

[data-theme="dark"] .join-type-option:hover {
  background: var(--bg-secondary);
}

[data-theme="dark"] .canvas-action-btn {
  background: var(--bg-primary);
  border-color: var(--border-color);
  color: var(--text-primary);
}

[data-theme="dark"] .canvas-action-btn:hover {
  background: var(--bg-secondary);
}

[data-theme="dark"] .scroll-hint {
  background: rgba(77, 171, 247, 0.9);
  color: white;
}

[data-theme="dark"] #visual-relations-container {
  background-color: var(--bg-secondary) !important;
  border-color: var(--border-color);
}

[data-theme="dark"] #manual-relations-container {
  background-color: var(--bg-secondary);
  border-color: var(--border-color);
}

/* Ensure all visual builder elements follow theme */
[data-theme="dark"] .visual-canvas .text-muted {
  color: var(--text-secondary) !important;
}

[data-theme="dark"] .visual-canvas .btn-outline-secondary {
  color: var(--text-secondary);
  border-color: var(--border-color);
}

[data-theme="dark"] .visual-canvas .btn-outline-secondary:hover {
  background-color: var(--bg-tertiary);
  color: var(--text-primary);
}

/* Modern Notification System */
.notification-container {
  position: fixed;
  top: 20px;
  right: 20px;
  z-index: 9999;
  pointer-events: none;
  max-width: 400px;
}

.notification {
  display: flex;
  align-items: flex-start;
  gap: 12px;
  background: var(--bg-primary);
  border: 1px solid var(--border-color);
  border-radius: 12px;
  padding: 16px 20px;
  margin-bottom: 12px;
  box-shadow: 0 10px 40px rgba(0, 0, 0, 0.1);
  backdrop-filter: blur(10px);
  transform: translateX(100%);
  opacity: 0;
  animation: slideIn 0.3s ease-out forwards;
  pointer-events: auto;
  transition: all 0.3s ease;
  position: relative;
  overflow: hidden;
}

.notification.removing {
  animation: slideOut 0.3s ease-in forwards;
}

.notification::before {
  content: '';
  position: absolute;
  top: 0;
  left: 0;
  width: 4px;
  height: 100%;
}

.notification.success {
  border-left-color: var(--success-color);
}

.notification.success::before {
  background: var(--success-color);
}

.notification.error {
  border-left-color: var(--danger-color);
}

.notification.error::before {
  background: var(--danger-color);
}

.notification.warning {
  border-left-color: var(--warning-color);
}

.notification.warning::before {
  background: var(--warning-color);
}

.notification.info {
  border-left-color: var(--primary-color);
}

.notification.info::before {
  background: var(--primary-color);
}

.notification-icon {
  flex-shrink: 0;
  width: 24px;
  height: 24px;
  border-radius: 50%;
  display: flex;
  align-items: center;
  justify-content: center;
  font-size: 14px;
  color: white;
  margin-top: 2px;
}

.notification.success .notification-icon {
  background: var(--success-color);
}

.notification.error .notification-icon {
  background: var(--danger-color);
}

.notification.warning .notification-icon {
  background: var(--warning-color);
}

.notification.info .notification-icon {
  background: var(--primary-color);
}

.notification-content {
  flex: 1;
  min-width: 0;
}

.notification-title {
  font-weight: 600;
  font-size: 14px;
  color: var(--text-primary);
  margin-bottom: 4px;
  line-height: 1.4;
}

.notification-message {
  font-size: 13px;
  color: var(--text-secondary);
  line-height: 1.4;
  word-wrap: break-word;
}

.notification-close {
  flex-shrink: 0;
  background: none;
  border: none;
  color: var(--text-muted);
  cursor: pointer;
  padding: 0;
  width: 20px;
  height: 20px;
  display: flex;
  align-items: center;
  justify-content: center;
  border-radius: 4px;
  transition: all 0.2s ease;
  margin-top: 2px;
  font-size: 12px;
}

.notification-close:hover {
  background: var(--hover-color);
  color: var(--text-primary);
}

.notification-progress {
  position: absolute;
  bottom: 0;
  left: 0;
  height: 2px;
  background: rgba(255, 255, 255, 0.3);
  transition: width linear;
  border-radius: 0 0 12px 12px;
}

.notification.success .notification-progress {
  background: var(--success-color);
}

.notification.error .notification-progress {
  background: var(--danger-color);
}

.notification.warning .notification-progress {
  background: var(--warning-color);
}

.notification.info .notification-progress {
  background: var(--primary-color);
}

@keyframes slideIn {
  from {
    transform: translateX(100%);
    opacity: 0;
  }
  to {
    transform: translateX(0);
    opacity: 1;
  }
}

@keyframes slideOut {
  from {
    transform: translateX(0);
    opacity: 1;
  }
  to {
    transform: translateX(100%);
    opacity: 0;
  }
}

/* Dark theme notifications */
[data-theme="dark"] .notification {
  background: var(--bg-primary);
  border-color: var(--border-color);
  box-shadow: 0 10px 40px rgba(0, 0, 0, 0.3);
}

[data-theme="dark"] .notification-title {
  color: var(--text-primary);
}

[data-theme="dark"] .notification-message {
  color: var(--text-secondary);
}

[data-theme="dark"] .notification-close {
  color: var(--text-muted);
}

[data-theme="dark"] .notification-close:hover {
  background: var(--hover-color);
  color: var(--text-primary);
}

/* Mobile responsiveness */
@media (max-width: 768px) {
  .notification-container {
    left: 20px;
    right: 20px;
    max-width: none;
  }
  
  .notification {
    padding: 12px 16px;
  }
  
  .notification-title {
    font-size: 13px;
  }
  
  .notification-message {
    font-size: 12px;
  }
}

/* Dark theme support for Bootstrap alerts */
[data-theme="dark"] .alert {
  background-color: var(--bg-secondary);
  border-color: var(--border-color);
  color: var(--text-primary);
}

[data-theme="dark"] .alert-warning {
  background-color: rgba(255, 193, 7, 0.1);
  border-color: rgba(255, 193, 7, 0.3);
  color: var(--warning-color);
}

[data-theme="dark"] .alert-success {
  background-color: rgba(25, 135, 84, 0.1);
  border-color: rgba(25, 135, 84, 0.3);
  color: var(--success-color);
}

[data-theme="dark"] .alert-danger {
  background-color: rgba(220, 53, 69, 0.1);
  border-color: rgba(220, 53, 69, 0.3);
  color: var(--danger-color);
}

[data-theme="dark"] .alert-info {
  background-color: rgba(13, 202, 240, 0.1);
  border-color: rgba(13, 202, 240, 0.3);
  color: var(--info-color);
}

[data-theme="dark"] .alert-primary {
  background-color: rgba(13, 110, 253, 0.1);
  border-color: rgba(13, 110, 253, 0.3);
  color: var(--primary-color);
}

[data-theme="dark"] .alert-secondary {
  background-color: rgba(108, 117, 125, 0.1);
  border-color: rgba(108, 117, 125, 0.3);
  color: var(--secondary-color);
}

/* Ensure text in alerts respects dark theme */
[data-theme="dark"] .alert h1,
[data-theme="dark"] .alert h2,
[data-theme="dark"] .alert h3,
[data-theme="dark"] .alert h4,
[data-theme="dark"] .alert h5,
[data-theme="dark"] .alert h6 {
  color: inherit;
}

[data-theme="dark"] .alert p,
[data-theme="dark"] .alert ul,
[data-theme="dark"] .alert li,
[data-theme="dark"] .alert strong {
  color: inherit;
}

[data-theme="dark"] .alert .text-muted {
  color: var(--text-muted) !important;
}

[data-theme="dark"] .alert .small {
  color: var(--text-secondary);
}

/* Search highlight styling */
mark {
  background-color: #fff3cd;
  color: #856404;
  padding: 0.1em 0.2em;
  border-radius: 0.2em;
}

[data-theme="dark"] mark {
  background-color: rgba(255, 193, 7, 0.3);
  color: var(--warning-color);
}

/* Table search styling */
.table-responsive {
  border: 1px solid var(--border-color);
  border-radius: 0.375rem;
}

[data-theme="dark"] .table-responsive {
  border-color: var(--border-color);
}

/* Sticky table header */
.sticky-top {
  top: 0;
  z-index: 1020;
}

[data-theme="dark"] .table .sticky-top {
  background-color: var(--bg-tertiary) !important;
}

/* Search input group styling */
[data-theme="dark"] .input-group-text {
  background-color: var(--bg-tertiary);
  border-color: var(--border-color);
  color: var(--text-secondary);
}

[data-theme="dark"] .btn-outline-secondary {
  color: var(--text-secondary);
  border-color: var(--border-color);
  background-color: transparent;
}

[data-theme="dark"] .btn-outline-secondary:hover {
  background-color: var(--bg-tertiary);
  color: var(--text-primary);
  border-color: var(--border-color);
}

/* Dark theme support for raw data display */
[data-theme="dark"] .bg-light {
  background-color: var(--bg-secondary) !important;
  color: var(--text-primary) !important;
}

[data-theme="dark"] pre {
  background-color: var(--bg-tertiary) !important;
  border: 1px solid var(--border-color);
  color: var(--text-primary) !important;
}

[data-theme="dark"] pre code {
  background-color: transparent !important;
  color: var(--text-primary) !important;
}

/* Specific styling for record view modal raw data */
[data-theme="dark"] .modal-content pre.bg-light {
  background-color: var(--bg-tertiary) !important;
  border: 1px solid var(--border-color) !important;
  color: var(--text-primary) !important;
}

[data-theme="dark"] .modal-content pre.bg-light code {
  background-color: transparent !important;
  color: var(--text-primary) !important;
}

/* Dark theme for record details modal table */
[data-theme="dark"] .modal-content .table {
  color: var(--text-primary);
  border-color: var(--border-color);
}

[data-theme="dark"] .modal-content .table > :not(caption) > * > * {
  border-bottom-color: var(--border-color);
}

[data-theme="dark"] .modal-content .table-striped > tbody > tr:nth-of-type(odd) > td,
[data-theme="dark"] .modal-content .table-striped > tbody > tr:nth-of-type(odd) > th {
  background-color: rgba(255, 255, 255, 0.05);
}

[data-theme="dark"] .modal-content .table thead th {
  background-color: var(--bg-tertiary);
  border-color: var(--border-color);
  color: var(--text-primary);
}

[data-theme="dark"] .modal-content .table tbody td {
  border-color: var(--border-color);
}

/* Ensure NULL values and other text elements are visible in dark theme */
[data-theme="dark"] .modal-content .text-muted {
  color: var(--text-muted) !important;
}

[data-theme="dark"] .modal-content em.text-muted {
  color: var(--text-muted) !important;
}

/* Database object type styling */
.badge.bg-primary {
  background-color: var(--primary-color) !important;
}

.badge.bg-info {
  background-color: var(--info-color) !important;
}

[data-theme="dark"] .badge.bg-primary {
  background-color: var(--primary-color) !important;
  color: #ffffff !important;
}

[data-theme="dark"] .badge.bg-info {
  background-color: var(--info-color) !important;
  color: #000000 !important;
}

.text-primary {
  color: var(--primary-color) !important;
}

.text-info {
  color: var(--info-color) !important;
}

[data-theme="dark"] .text-primary {
  color: var(--primary-color) !important;
}

[data-theme="dark"] .text-info {
  color: var(--info-color) !important;
}

/* Database table row styling */
[data-theme="dark"] .table tbody tr[data-object-type="view"] {
  background-color: rgba(116, 192, 252, 0.05);
}

[data-theme="dark"] .table tbody tr[data-object-type="table"] {
  background-color: rgba(77, 171, 247, 0.05);
}

/* AI Analysis Modal Styles */
.ai-analysis-container {
  padding: 0;
}

.ai-analysis-container .metric-card {
  padding: 1.5rem;
  transition: transform 0.2s ease;
}

.ai-analysis-container .metric-card:hover {
  transform: translateY(-5px);
}

.ai-analysis-container .metric-card h3 {
  font-size: 2rem;
  font-weight: bold;
  color: var(--text-primary);
}

.ai-analysis-container .metric-card small {
  font-size: 0.875rem;
  text-transform: uppercase;
  letter-spacing: 0.5px;
}

.ai-analysis-container .insights-list li {
  padding: 0.75rem;
  border-left: 3px solid var(--success-color);
  background-color: var(--bg-tertiary);
  border-radius: 0.25rem;
  margin-bottom: 0.5rem;
}

.ai-analysis-container .insights-list li:hover {
  background-color: var(--bg-secondary);
  box-shadow: var(--shadow);
}

.bg-gradient-success {
  background: linear-gradient(135deg, var(--success-color) 0%, #20c997 100%);
}

/* Chart containers */
.ai-analysis-container canvas {
  max-height: 400px;
}

/* Recommendation cards */
.ai-analysis-container .card.border-warning .card-body ul li {
  padding: 0.5rem 0;
  border-bottom: 1px solid var(--border-color);
}

.ai-analysis-container .card.border-warning .card-body ul li:last-child {
  border-bottom: none;
}

/* Dark theme adjustments for AI Analysis */
[data-theme="dark"] .ai-analysis-container .metric-card {
  background-color: var(--bg-tertiary);
  border-radius: 0.5rem;
}

[data-theme="dark"] .ai-analysis-container .insights-list li {
  border-left-color: var(--success-color);
  background-color: var(--bg-tertiary);
}

[data-theme="dark"] .bg-gradient-success {
  background: linear-gradient(135deg, #51cf66 0%, #20c997 100%);
}

/* Responsive adjustments */
@media (max-width: 768px) {
  .ai-analysis-container .metric-card h3 {
    font-size: 1.5rem;
  }
  
  .ai-analysis-container canvas {
    max-height: 250px;
  }
}

/* AG Grid Dark Mode Styles */
[data-theme="dark"] #grid-viewer-modal .modal-body {
  background-color: var(--bg-primary);
}

[data-theme="dark"] #grid-viewer-modal .modal-footer {
  background-color: var(--bg-secondary);
  border-top-color: var(--border-color);
}

[data-theme="dark"] #ag-grid-container {
  background-color: var(--bg-primary);
}

/* Ensure AG Grid alpine-dark theme is properly rendered */
[data-theme="dark"] .ag-theme-alpine-dark {
  --ag-background-color: #212529;
  --ag-header-background-color: #343a40;
  --ag-odd-row-background-color: #2a2e32;
  --ag-row-hover-color: #343a40;
  --ag-border-color: #495057;
  --ag-secondary-border-color: #495057;
}
/* Select2 Dark Mode Styles */
[data-theme='dark'] .select2-container--bootstrap-5 .select2-dropdown {
  background-color: var(--bg-secondary);
  border-color: var(--border-color);
  color: var(--text-primary);
  z-index: 9999 !important; /* Ensure dropdown is above modal */
}

[data-theme='dark'] .select2-container--bootstrap-5 .select2-dropdown .select2-search__field {
  background-color: var(--bg-tertiary);
  border-color: var(--border-color);
  color: var(--text-primary);
}

[data-theme='dark'] .select2-container--bootstrap-5 .select2-dropdown .select2-search__field:focus {
  border-color: var(--primary-color);
  background-color: var(--bg-primary);
  outline: none;
}

[data-theme='dark'] .select2-container--bootstrap-5 .select2-results__option {
  background-color: var(--bg-secondary);
  color: var(--text-primary);
}

[data-theme='dark'] .select2-container--bootstrap-5 .select2-results__option--highlighted {
  background-color: var(--primary-color);
  color: #ffffff;
}

[data-theme='dark'] .select2-container--bootstrap-5 .select2-results__option[aria-selected='true'] {
  background-color: var(--bg-tertiary);
  color: var(--text-primary);
}

[data-theme='dark'] .select2-container--bootstrap-5 .select2-results__group {
  background-color: var(--bg-tertiary);
  color: var(--text-secondary);
  font-weight: bold;
  padding: 6px 12px;
}

[data-theme='dark'] .select2-container--bootstrap-5 .select2-selection {
  background-color: var(--bg-secondary);
  border-color: var(--border-color);
  color: var(--text-primary);
  cursor: pointer;
}

[data-theme='dark'] .select2-container--bootstrap-5.select2-container--focus .select2-selection {
  border-color: var(--primary-color);
  box-shadow: 0 0 0 0.25rem rgba(77, 171, 247, 0.25);
}

[data-theme='dark'] .select2-container--bootstrap-5 .select2-selection__rendered {
  color: var(--text-primary);
}

[data-theme='dark'] .select2-container--bootstrap-5 .select2-selection__placeholder {
  color: var(--text-muted);
}

[data-theme='dark'] .select2-container--bootstrap-5 .select2-selection__clear {
  color: var(--text-secondary);
}

[data-theme='dark'] .select2-container--bootstrap-5 .select2-selection__clear:hover {
  color: var(--danger-color);
}

[data-theme='dark'] .select2-container--bootstrap-5 .select2-selection__arrow b {
  border-color: var(--text-secondary) transparent transparent transparent;
}

[data-theme='dark'] .select2-container--bootstrap-5.select2-container--open .select2-selection__arrow b {
  border-color: transparent transparent var(--text-secondary) transparent;
}

/* Select2 scrollbar for dark mode */
[data-theme='dark'] .select2-results__options::-webkit-scrollbar {
  width: 8px;
}

[data-theme='dark'] .select2-results__options::-webkit-scrollbar-track {
  background: var(--bg-tertiary);
}

[data-theme='dark'] .select2-results__options::-webkit-scrollbar-thumb {
  background: var(--border-color);
  border-radius: 4px;
}

[data-theme='dark'] .select2-results__options::-webkit-scrollbar-thumb:hover {
  background: var(--text-muted);
}

/* Light mode Select2 styles - ensure dropdown is above modal */
.select2-container--bootstrap-5 .select2-dropdown {
  z-index: 9999 !important;
}

.select2-container--bootstrap-5 .select2-selection {
  cursor: pointer;
}

.select2-container--bootstrap-5 .select2-dropdown .select2-search__field:focus {
  outline: none;
}

/* Additional z-index override for dropdowns in modals */
.select2-dropdown-above-modal {
  z-index: 10000 !important;
}

.select2-container--open {
  z-index: 10000 !important;
}