car
Tables (13)
board
- id — bigint(20) — Primary key — NOT NULL
- createdDate — datetime(6)
- modifyDate — datetime(6)
- content — text — NOT NULL
- likes — int(11) — NOT NULL
- title — varchar(100) — NOT NULL
- viewCount — int(11) — NOT NULL
- writer — varchar(255) — Foreign key → user.username
- bno — bigint(20) — NOT NULL
- replyCount — int(11) — NOT NULL
brand
- brand — varchar(255) — Primary key — NOT NULL
car
- cid — int(11) — Primary key — NOT NULL
- capacity — int(11) — NOT NULL
- cost — int(11) — NOT NULL
- frontSuspension — varchar(255)
- frontThread — int(11) — NOT NULL
- fuel_efficiency — double — NOT NULL
- height — int(11) — NOT NULL
- imgurl — varchar(255)
- length — int(11) — NOT NULL
- name — varchar(255)
- rearSuspension — varchar(255)
- rearThread — int(11) — NOT NULL
- wheelBase — int(11) — NOT NULL
- width — int(11) — NOT NULL
- brand — varchar(255) — Foreign key → brand.brand
- engine — varchar(255) — Foreign key → engine.engine
- segment — int(11) — Foreign key → segment.sid
caroption
- copk — int(11) — Primary key — NOT NULL
- cost — int(11) — NOT NULL
- opt — bit(1) — NOT NULL
- car — int(11) — Foreign key → car.cid
- option — int(11) — Foreign key → option.opk
engine
- engine — varchar(255) — Primary key — NOT NULL
option
- opk — int(11) — Primary key — NOT NULL
- oexpl — varchar(255)
- oimg — varchar(255)
- oname — varchar(255)
reply
- rno — bigint(20) — Primary key — NOT NULL
- createdDate — datetime(6)
- modifyDate — datetime(6)
- text — varchar(255)
- board_id — bigint(20) — Foreign key → board.id
- user — varchar(255) — Foreign key → user.username
- board — bigint(20)
- parent — bigint(20) — Foreign key → reply.rno
review
- rid — int(11) — Primary key — NOT NULL
- content — varchar(255)
- cid — int(11) — Foreign key → car.cid
- username — varchar(255) — Foreign key → user.username
reviewgood
- rgid — int(11) — Primary key — NOT NULL
- rid — int(11) — Foreign key → review.rid
- username — varchar(255) — Foreign key → user.username
segment
- sid — int(11) — Primary key — NOT NULL
- segment — varchar(255)
store
- spk — int(11) — Primary key — NOT NULL
- car — int(11) — Foreign key → car.cid
- user — varchar(255) — Foreign key → user.username
storeoption
- sopk — int(11) — Primary key — NOT NULL
- opt — bit(1) — NOT NULL
- option — int(11) — Foreign key → option.opk
- store — int(11) — Foreign key → store.spk
user
- username — varchar(255) — Primary key — NOT NULL
- allowEmail — tinyint(1)
- allowSms — tinyint(1)
- createDate — datetime(6)
- createdDate — date
- email — varchar(255)
- exp — int(11) — NOT NULL
- nickname — varchar(255)
- password — varchar(255) — NOT NULL
- provider — varchar(255)
- providerId — varchar(255)
- role — varchar(255)
- sid — int(11)