ㅁㄴㅇ

Tables (5)

Expense_Records

  • expense_id — BIGINT
  • vehicle_id — BIGINT — NOT NULL
  • expense_date — DATE — NOT NULL
  • category — ENUM('주유', '보험', '세금', '수리', '기타') — NOT NULL
  • amount — DECIMAL(10, 2) — NOT NULL
  • description — VARCHAR(255)

Maintenance_Logs

  • log_id — BIGINT
  • vehicle_id — BIGINT — NOT NULL
  • maintenance_date — DATE — NOT NULL
  • odometer — INT — NOT NULL — 정비 시점의 주행거리(km)
  • item — VARCHAR(100) — NOT NULL — 정비 항목 (e.g., 엔진오일 교환)
  • cost — DECIMAL(10, 2)
  • service_center — VARCHAR(100)
  • notes — TEXT

Reminders

  • reminder_id — BIGINT
  • vehicle_id — BIGINT — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • due_date — DATE — 목표 날짜 기준 알림
  • due_odometer — INT — 목표 주행거리 기준 알림
  • is_completed — BOOLEAN — NOT NULL
  • created_at — DATETIME

Users

  • user_id — BIGINT
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • created_at — DATETIME

Vehicles

  • vehicle_id — BIGINT
  • user_id — BIGINT — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • make — VARCHAR(50)
  • model — VARCHAR(50)
  • year — INT
  • vin — VARCHAR(17)
  • license_plate — VARCHAR(20) — NOT NULL
  • created_at — DATETIME