ScentQuest

Tables (3)

review

  • id — int — Primary key — NOT NULL
  • code — varchar(20) — Primary key — NOT NULL
  • name — varchar(10) — NOT NULL
  • star — enum(5) — NOT NULL
  • season — enum(4) — NOT NULL — 봄: 0, 여름: 1, 가을: 2, 겨울: 3
  • time — enum(4) — NOT NULL — 아침: 0, 점심: 1, 저녁: 3 밤: 4
  • rate — enum(4) — NOT NULL — 매우김: 0, 길다: 1, 보통: 2, 짧음: 3, 매우 짦은: 4
  • gender — enum(5) — NOT NULL — 여성: 0, 중성&여성: 1, 중성: 2, 중성&남성:3, 남성:4
  • price — enum(4) — NOT NULL — 매우 비쌈:0, 비쌈: 1, 보통: 2, 저렴한: 3

scent

  • id — BigInt — Primary key — NOT NULL
  • code — varchar(20) — Primary key — NOT NULL
  • brand — varchar(20) — NOT NULL
  • name — varchar(10) — NOT NULL
  • m_acc — varchar(20) — NOT NULL
  • description — varchar(200) — NOT NULL

user

  • id — BigInt — Primary key — NOT NULL
  • name — varchar(10) — NOT NULL
  • age — varchar(3) — NOT NULL
  • birth — varchar(10) — NOT NULL
  • brand — varchar(20) — NOT NULL
  • note — varchar(20) — NOT NULL
  • rate — varchar(50) — NOT NULL