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)