사이트

테이블 (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)