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