yummy_diary
Tables (7)
Menu (Menus)
- id — int — Primary key — NOT NULL
- store_id (store) — int — Foreign key → Store.id — NOT NULL
- name (Field) — char
- price — int
Post (Posts)
- id — int — Primary key — NOT NULL
- user id (user) — int — Foreign key → User.id — NOT NULL
- meal — char — choicce
- date — date
- menus — char
- party — char
- store id (store) — int — Foreign key → Store.id — NOT NULL — store, location 둘 중 하나만
- location — char — store, location 둘 중 하나만
- score — float — score 는 location 등록 때만 가능하게
Review (Reviews)
- id — int — Primary key — NOT NULL
- user id (writer) — int — Foreign key → User.id — NOT NULL
- store — int — Foreign key → Store.id — NOT NULL
- score (total_score) — int
- content — char
- date (reg_time) — datetime
Store (Stores)
- id — int — Primary key — NOT NULL
- name — char
- branch — char
- tel — char
- address — char
- latitude — float
- longtitude — float
- bhour (bhour_list) — char
Store-Tag (Stores-Tags)
- id — int — Primary key — NOT NULL
- store id (store) — int — Foreign key → Store.id — NOT NULL
- tag id (tag) — int — Foreign key → Tag.id — NOT NULL
Tag (Tags)
- id — int — Primary key — NOT NULL
- content — char
User (Accounts)
- id — int — Primary key — NOT NULL
- email — email
- birth_year — int
- gender — char
- password — char