CAR CENTER

Tables (4)

Payment (Untitled2)

  • payment_id (Key) — int — Primary key — NOT NULL
  • service_id (Key2) — int — Foreign key → ServiceHistory.service_id — NOT NULL
  • amount (Field) — decimal(10,2)
  • payment_date (Field2) — atetime
  • payment_method (Field3) — varchar(20)

ServiceHistory (Untitled)

  • service_id (Key) — int — Primary key — NOT NULL
  • vehicle_id (Key2) — int — Foreign key → Vehicle.vehicle_id — NOT NULL
  • service_date (Field) — datetime
  • description (Field2) — text
  • cost (Field3) — decimal(10,2)
  • parts_used (Field4) — text

USER (회원)

  • user_id (Key) — INT — Primary key — NOT NULL
  • name — varchar(50)
  • phone — varchar(20)
  • email — varchar(50)
  • address — text
  • reg_date — datetime
  • birthday — date
  • insurance — text

Vehicle (차량)

  • vehicle_id (Key) — int — Primary key — NOT NULL
  • user_id (Key2) — INT — Foreign key → USER.user_id — NOT NULL
  • plate_number — varchar(20)
  • brand — varchar(30)
  • model — varchar(30)
  • year — int
  • last_service_date (last_serivce_date) — datetime