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