Today's Pick
Tables (9)
Answer (문의사항 답변)
- aid (Key) — Long — Primary key — NOT NULL
- title (Field) — String
- content (Field2) — String
- type (Field3) — String
- to (Field4) — String
- from (Field5) — String
- regdate (Field6) — Date
Eatery (식당)
- eid (Key) — Long — Primary key — NOT NULL
- name (Field) — String
- category (Field2) — String
- latitude (Field3) — Double
- longitude (Field4) — Double
- address (Field5) — String
- roadAddress (Field7) — String
- phone (Field8) — String
- url (Field6) — String
Favorites (즐겨찾기)
- fid (Key) — Long — Primary key — NOT NULL
- regdate (Field) — Date
- uid (Key2) — Long — Foreign key → User.uid — NOT NULL
- eid (Key3) — Long — Foreign key → Eatery.eid — NOT NULL
Inquiry (문의사항)
- qid (Key) — Long — Primary key — NOT NULL
- title (Field) — String
- content (Field2) — String
- type (Field3) — String
- to (Field4) — String
- from (Field5) — String
- regdate (Field6) — Date
- Field7
Interaction (사용자-음식점 상호작용)
- iid (Key) — Long — Primary key — NOT NULL
- feedback (Field) — int
- ratings (Field2) — int
- uid (Key2) — Long — Foreign key → User.uid — NOT NULL
- eid (Key3) — Long — Foreign key → Eatery.eid — NOT NULL
Menu (메뉴)
- mid (Key) — Long — Primary key — NOT NULL
- mname (Field) — String
- price (Field2) — int
- eid (Key2) — Long — Foreign key → Eatery.eid — NOT NULL
Notice (공지사항)
- nid (Key) — Long — Primary key — NOT NULL
- title (Field) — String
- content (Field2) — LONGTEXT
- regdate (Field3) — Date
- author (Field4) — String
- views (Field5) — int
Preference (선호도)
- pid (Key) — String — Primary key — NOT NULL
- uid (Key2) — Long — Foreign key → User.uid — NOT NULL
- taste (Field2) — String
- category (Field3) — String
- priceLevel (Field4) — int
- purpose (Field5) — String
User (사용자)
- uid (Key) — Long — Primary key — NOT NULL
- username (Field) — String
- email (Field2) — String
- password (Field3) — String
- role (Field4) — enum
- birthDate (Field5) — date