맛집
테이블 (9)
Store (Untitled2)
- sid — int — 기본 키 — NOT NULL
- sname — varchar
- image — varchar
- phone — varchar
- bhour — varchar
- tag — varchar
- score — double
- category — varchar
- menulist (menu_list) — int
- price — int
- sido — varchar
- gugun — varchar
- dong — varchar
- bunji — varchar
User (Untitled)
- uid — int — 기본 키 — NOT NULL
- email — varchar
- password — varchar
- sex — varchar
- age — date
card (Untitled8)
- cardid (Key) — int — 기본 키 — NOT NULL
- sex (Field) — varchar
- age (Field2) — date
- sido (Field3) — varchar
- gugun (Field4) — varchar
- dong (Field5) — varchar
- category (Field6) — int
- howmany (Field7) — int
- Field8
cardcategory (Untitled9)
- ccid (Key) — int — 기본 키 — NOT NULL
- canum (Field) — int
- category (Field2) — varchar
course (Untitled5)
- cid — int — 기본 키 — NOT NULL
- uid — int — 외래 키 → User.uid — NOT NULL
- course — varchar
- dtype — tinyint
- people — int
- isfinish — tinyint
enter (Untitled6)
- eid (Key) — int — 기본 키 — NOT NULL
- ename (Field) — varchar
- category (Field2) — varchar
- emenulist (Field3) — int
enterreview (Untitled7)
- erid (Key) — int — 기본 키 — NOT NULL
- uid — int — 외래 키 → User.uid — NOT NULL
- eid (Key2) — int — 외래 키 → enter.eid — NOT NULL
- score (Field) — double
- comment (Field2) — varchar
menu_list (Untitled3)
- mid — int — 기본 키 — NOT NULL
- sid — int — 외래 키 → Store.sid — NOT NULL
- menu — varchar
- price — int
storereview (Untitled4)
- rid — int — 기본 키 — NOT NULL
- sid — int — 외래 키 → Store.sid — NOT NULL
- uid — int — 외래 키 → User.uid — NOT NULL
- score — double
- comment — varchar