carming
Tables (9)
car_brand
- brand_id — String — Primary key — NOT NULL
- isKor — Boolean
- logoRes — String
- name — String
car_info
- car_id — Long — Primary key — NOT NULL
- carName_id — String — Foreign key → car_name.carName_id
- brand_id — String — Foreign key → car_name.brand_id — NOT NULL
- user_id — Long — Foreign key → user.user_id — NOT NULL
- resCarNo — String
- resFirstDate — String
- niceCarSz — String
- resSourceType — String
- resValidDistance — int
- whoCar — int
- moveCnt — int
- makerNm — String
- modelNm — String
- yearType — int
- fuel — String
- gearBox — String
- seatingCapacity — int
- resColor — String
- price — int
- content — String
- gradeNm — String
- brokenYn — char
- SoldYn — char
- buyerId — String
- address — String
car_name
- carName_id — String — Primary key
- brand_id — String — Foreign key → car_brand.brand_id — NOT NULL
- brand — String
- name — String
car_option
- option_id — Long — Primary key — NOT NULL
- car_id — Long — Foreign key → car_info.car_id — NOT NULL
- option — String
- carName_id — String — Foreign key → car_info.carName_id
- brand_id — String — Foreign key → car_info.brand_id — NOT NULL
chatRooms
- chatroom_id — String — Primary key — NOT NULL
- car_id — Long — Foreign key → car_info.car_id — NOT NULL
- user_id — Long — Foreign key → user.user_id — NOT NULL
- carName_id — String — Foreign key → car_info.carName_id
- brand_id — String — Foreign key → car_info.brand_id — NOT NULL
messages
- message_id — String — Primary key — NOT NULL
- chatroom_id — String — Foreign key → chatRooms.chatroom_id — NOT NULL
- car_id — Long — Foreign key → chatRooms.car_id — NOT NULL
- user_id — Long — Foreign key → chatRooms.user_id — NOT NULL
- carName_id — String — Foreign key → chatRooms.carName_id
- brand_id — String — Foreign key → chatRooms.brand_id — NOT NULL
- content — String
- timestamp — date
picture
- picture_id — Long — Primary key — NOT NULL
- car_id — Long — Foreign key → car_info.car_id — NOT NULL
- url — String
- carName_id — String — Foreign key → car_info.carName_id
- brand_id — String — Foreign key → car_info.brand_id — NOT NULL
reviews
- review_id — String — Primary key — NOT NULL
- user_id — Long — Foreign key → user.user_id — NOT NULL
- car_id — Long — Foreign key → car_info.car_id — NOT NULL
- carName_id — String — Foreign key → car_info.carName_id
- brand_id — String — Foreign key → car_info.brand_id — NOT NULL
- content — String
- rating — int
user
- user_id — Long — Primary key — NOT NULL
- id — String
- password — String
- name (username) — String
- nickname — String