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