car
Tables (3)
car
- car_id — int — Primary key — NOT NULL — Auto Increment
- 모델명 (modelName) — varchar(50) — 모델명
- 생산년도 (productionYear) — Year — NOT NULL — 생산년도
- 제조사 (manufacturer) — varchar(30) — NOT NULL — 제조사
- 자동차상태 (vehicleStatus) — varchar(20) — NOT NULL — 자동차상태
car_category
- car_category_id — int — Primary key — NOT NULL — Auto increment
- category_id — int — Foreign key → category.category_id — NOT NULL — Auto increment
- car_id — int — Foreign key → car.car_id — NOT NULL — Auto Increment
category
- category_id — int — Primary key — NOT NULL — Auto increment
- category_name — varchar(30) — NOT NULL — 카테고리 이름