d

Tables (8)

BODY_TYPE_INFO

  • BODY_TYPE_ID — INT
  • BODY_TYPE_NAME — VARCHAR(30) — NOT NULL

BRAND_INFO

  • BRAND_ID — INT
  • BRAND_NAME — VARCHAR(30) — NOT NULL

CAR_INFO

  • CAR_ID — INT
  • CAR_FULL_NAME — VARCHAR(100)
  • CAR_MODEL — INT
  • CAR_BRAND — INT
  • CAR_BODY_TYPE — INT
  • CAR_FUEL_TYPE — INT
  • CAR_PRICE — INT
  • CAR_HORSEPOWER — INT
  • CAR_FUEL_EFFICIENCY — INT
  • CAR_MODEL_YEAR — INT
  • CAR_SIZE — INT
  • CAR_ENGINE_TYPE — varchar(40)
  • CAR_IMG_URL — VARCHAR(100)
  • # — FOREIGN

FUEL_TYPE_INFO

  • FUEL_TYPE_ID — INT
  • FUEL_TYPE_NAME — VARCHAR(30 NOT NULL — NOT NULL

MODEL_TYPE_INFO

  • MODEL_TYPE_ID — INT
  • MODEL_TYPE_NAME — VARCHAR(30) — NOT NULL

USER_INFO

  • USER_ID — INT
  • USER_AGE — INT — NOT NULL
  • USER_GENDER — VARCHAR(10) — NOT NULL
  • CAR_ID — INT — NOT NULL

car_review_info

  • review_id — int
  • car_id — int — NOT NULL
  • avg_score — float — NOT NULL
  • survey_people_count — int
  • graph_info — varchar(100)

comment_info

  • comment_id — int
  • review_id — int — NOT NULL
  • nickname — varchar(20) — NOT NULL
  • comment_avg_score — float
  • comment_text — varchar(200)
  • create_at — timestamp