사이트
테이블 (17)
CarBrand
- brand_id — INT — 기본 키 — NOT NULL
- brandName — VARCHAR(100)
CarModel
- model_id — INT — 기본 키 — NOT NULL
- model_name — VARHCAR(100)
- brand_id — CHAR(4) — NOT NULL
- brand_id (brand_id2) — INT — 외래 키 → CarBrand.brand_id — NOT NULL
carKind
- car_id — INT — 기본 키 — NOT NULL
- car_kind — VARCHAR(100)
car_image
- image_id — INT — 기본 키 — NOT NULL
- url — VARCHAR(100)
- car_id — INT — NOT NULL
- is_main — TINYINT(1)
- car_id (car_id2) — VARCHAR(100) — 외래 키 → used_car.car_id — NOT NULL
car_option_detail
- option_id — INT — 기본 키 — NOT NULL
- option_name — VARCHAR(100)
dealer
- dealer_id — INT — 기본 키 — NOT NULL
- name — VARCHAR(100)
- number — VARCHAR(100)
- location — VARCHAR(100)
- url — VARCHAR(100)
driveMethod
- driveMethod_id — INT — 기본 키 — NOT NULL
- drive_method — VARCHAR(100)
fuel
- fuel_id — INT — 기본 키 — NOT NULL
- fuel_name — VARCHAR(100)
gear_kind
- gear_id — INT — 기본 키 — NOT NULL
- gear_name — VARCHAR(50)
insuranceHistory
- Key — INT — 기본 키 — NOT NULL
- count — INT
- car_id — VARCHAR(100) — 외래 키 → used_car.car_id — NOT NULL
- insurance_id — INT — 외래 키 → insuranceList.insurance_id — NOT NULL
insuranceList
- insurance_id — INT — 기본 키 — NOT NULL
- details — VARCHAR(100)
option
- car_id — VARCHAR(100) — 외래 키 → used_car.car_id — NOT NULL
- option_id — INT — 외래 키 → car_option_detail.option_id — NOT NULL
purchase
- purchase_id — INT — 기본 키 — NOT NULL
- purchase_time — DATETIME
- is_refund (Is_reFund) — DATETIME
- user_id — VARCHAR(100) — 외래 키 → user.user_id — NOT NULL
- car_id — VARCHAR(100) — 외래 키 → used_car.car_id — NOT NULL
refund
- refund_id — INT — 기본 키 — NOT NULL
- refund_time — DATETIME
- purchase_id — INT — 외래 키 → purchase.purchase_id — NOT NULL
storageList
- user_id — VARCHAR(100) — 외래 키 → user.user_id — NOT NULL
- car_id — VARCHAR(100) — 외래 키 → used_car.car_id — NOT NULL
used_car
- car_id — VARCHAR(100) — 기본 키 — NOT NULL
- car_number — VARCHAR(100)
- is_nativeCar — TINYINT(1) — NOT NULL
- cc — INT — NOT NULL
- year — INT — NOT NULL
- color — VARCHAR(100) — NOT NULL
- km — INT — NOT NULL
- seater — INT — NOT NULL
- reportNumber — VARCHAR(100) — NOT NULL
- is_seizure — TINYINT(1) — NOT NULL
- carIntro — TEXT — NOT NULL
- is_accident — TINYINT(1) — NOT NULL
- is_repair — TINYINT(1) — NOT NULL
- price — INT — NOT NULL
- is_soldout — TINYINT(1) — NOT NULL
- dealer_id — INT — 외래 키 → dealer.dealer_id — NOT NULL
- gear_id — INT — 외래 키 → gear_kind.gear_id — NOT NULL
- car_id (car_id2) — INT — 외래 키 → carKind.car_id — NOT NULL
- driveMethod_id — INT — 외래 키 → driveMethod.driveMethod_id — NOT NULL
- fuel_id — INT — 외래 키 → fuel.fuel_id — NOT NULL
- model_id — INT — 외래 키 → CarModel.model_id — NOT NULL
user
- user_id — VARCHAR(100) — 기본 키 — NOT NULL
- user_name — VARCHAR(100)
- email — VARCHAR(100)
- password — VARCHAR(100)
- phone — VARCHAR(100)
- address — VARCHAR(100)