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 — 카테고리 이름