organizations {
  id: UUID (Primary Key)
  name: TEXT
  avatar_url: TEXT
  created_at: TIMESTAMP
  updated_at: TIMESTAMP
  karma_api_url: TEXT
  karma_username: TEXT
  karma_password_encrypted: TEXT
}

org_members {
  org_id: UUID (FK → organizations.id)
  user_id: UUID (FK → auth.users.id)
  role: TEXT (OrgAdmin|Dispatcher|Analyst|Driver|ReadOnly)
  created_at: TIMESTAMP
  updated_at: TIMESTAMP
  PRIMARY KEY (org_id, user_id)
}

cars {
  car_id: BIGINT (Primary Key)
  device_id: BIGINT
  project_id: BIGINT (FK → projects.project_id)
  time_zone: TEXT
  car_number: TEXT
  license_plate: TEXT
  car_title: TEXT
  car_type: TEXT
  sub_type: TEXT
  car_year: TEXT
  car_color: TEXT
  sim_imsi: TEXT
  sim_phone: TEXT
  karma_video_data: TEXT
  fetch_timestamp: TIMESTAMP
  org_id: UUID (FK → organizations.id)
}

tag_assignments {
  id: BIGINT (Primary Key)
  date: DATE
  tag_number: INTEGER
  car_id: BIGINT (FK → cars.car_id)
  category: INTEGER (1-5)
  type: TEXT (corporativo|prepago)
  issued_at: DATE
  expires_at: DATE
  status: TEXT (Valido|Inhabilitado)
  created_at: TIMESTAMP
  updated_at: TIMESTAMP
  org_id: UUID (FK → organizations.id)
}

tolls {
  id: BIGINT (Primary Key)
  name: TEXT
  latitude: DECIMAL(10,8)
  longitude: DECIMAL(11,8)
  category_1: BIGINT
  category_2: BIGINT
  category_3: BIGINT
  category_4: BIGINT
  category_5: BIGINT
  image: TEXT
  org_id: UUID (FK → organizations.id)
}

toll_charges {
  id: BIGINT (Primary Key)
  date: TIMESTAMP
  amount: DOUBLE PRECISION
  tag: BIGINT
  station: TEXT
  type: TEXT
  matched_message_id: BIGINT
  is_duplicate: BOOLEAN
  duplicate_resolution: TEXT
  category_error: BOOLEAN
  expected_amount: DOUBLE PRECISION
  amount_difference: DOUBLE PRECISION
  tag_status_at_time: TEXT
  tag_status_error: BOOLEAN
  fraud_type: TEXT
  fraud_reasons: TEXT
  is_fraudulent: BOOLEAN
  fleet: TEXT
  validation_status: TEXT
  validation_details: TEXT
  matched_car_id: BIGINT (FK → cars.car_id)
  matched_license_plate: TEXT
  assignment_date_used: DATE
  distance_meters: DOUBLE PRECISION
  time_diff_minutes: DOUBLE PRECISION
  manual_revision_status: TEXT
  manual_revision_comment: TEXT
  created_at: TIMESTAMP
  updated_at: TIMESTAMP
  org_id: UUID (FK → organizations.id)
}

edata_telemetry {
  car_id: BIGINT (FK → cars.car_id)
  device_id: BIGINT
  car_number: TEXT
  message_id: BIGINT
  edt: TIMESTAMP
  edt_tz: TEXT
  pdt: TEXT
  speed_kph: DOUBLE PRECISION
  odometer_km: DOUBLE PRECISION
  latitude: DOUBLE PRECISION
  longitude: DOUBLE PRECISION
  fetch_timestamp: TIMESTAMP
  batch_number: BIGINT
  org_id: UUID (FK → organizations.id)
}