MOSO
Tables (5)
EATING_COMMENT (맛집 게시판 댓글)
- comment_id (Key) — number — Primary key — NOT NULL
- post_id (Key2) — number — Foreign key → EATING_POST.post_id — NOT NULL
- user_id (Key3) — number — Foreign key → USER.user_id — NOT NULL
- comment (Field) — text
- time (Field2) — datetime
EATING_POST (맛집 게시판)
- post_id (Key) — number — Primary key — NOT NULL
- user_id (Key2) — number — Foreign key → USER.user_id — NOT NULL
- name (Field) — text
- address (Field2) — text
- call (Field3) — text
- category (Field4) — text
- pricerange (Field5) — text
- parking (Field6) — boolean
- opentime (Field7) — text
- site (Field8) — text
- image (Field9) — image
MENU_POST (세부 메뉴)
- menu_id (Key) — number — Primary key — NOT NULL
- post_id (Key2) — number — Foreign key → EATING_POST.post_id — NOT NULL
- name (Field) — char
- image (Field2) — image
- price (Field3) — integer
- content (Field4) — text
REVIEW_POST (상세 리뷰)
- review_id (Key) — number — Primary key — NOT NULL
- post_id (Key2) — number — Foreign key → EATING_POST.post_id — NOT NULL
- user_id (Key3) — number — Foreign key → USER.user_id — NOT NULL
- image (Field) — image
- star (Field2) — integer
- content (Field3) — content
- title (Field4) — title
USER (유저)
- user_id (Key) — number — Primary key — NOT NULL
- username (Field) — char
- password (Field2) — char