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