uxdesign

테이블 (4)

리뷰 (Review)

  • review_id — int — 기본 키 — NOT NULL
  • member_id — int — 외래 키 → 멤버.member_id — NOT NULL
  • cafe_id (Key) — int — 외래 키 → 카페.cafe_id — NOT NULL
  • upload_date — date — NOT NULL
  • content — varchar(1000) — NOT NULL

메뉴 (Menu)

  • menu_id — int — 기본 키 — NOT NULL
  • cafe_id — int — 외래 키 → 카페.cafe_id — NOT NULL
  • price — int — NOT NULL

멤버 (Member)

  • member_id — int — 기본 키 — NOT NULL
  • email — varchar(100) — NOT NULL
  • password — varchar(100) — NOT NULL

카페 (Cafe)

  • cafe_id — int — 기본 키 — NOT NULL
  • volume — varchar(50) — NOT NULL
  • totalSeat — int — NOT NULL
  • remainSeat — int — NOT NULL
  • totalMultitap — int — NOT NULL
  • remainMultitap — int — NOT NULL
  • address — varchar(100) — NOT NULL
  • onpeningHours — varchar(500) — NOT NULL
  • isOpen — varchar(100) — NOT NULL