Review

Tables (4)

Member (멤버)

  • 멤버ID (member_id) — NOTNULL — Primary key — NOT NULL
  • 이메일 (email) — NOTNULL
  • 패스워드 (password) — NOTNULL
  • 권한 (authority) — NOTNOLL

Menu (메뉴)

  • 메뉴ID (menu_id) — NOTNULL — Primary key — NOT NULL
  • 레스토랑ID (restaurant_id) — NOTNULL — Foreign key → Restaurant.레스토랑ID — NOT NULL
  • 메뉴이름 (name) — NOTNULL
  • 가격 (price) — NOTNULL
  • 생성일 (created_At) — NOTNULL
  • 수정일 (modified_At) — NOTNULL

Restaurant (레스토랑)

  • 레스토랑ID (restaurant_id) — NOTNULL — Primary key — NOT NULL
  • 멤버ID (member_id) — NOTNULL — Foreign key → Member.멤버ID — NOT NULL
  • 레스토랑 이름 (name) — NOTNULL
  • 주소 (address) — NOTNULL
  • 생성일 (created_At) — NOTNULL
  • 수정일 (modified_At) — NOTNULL

Review (리뷰)

  • 리뷰ID (review_id) — NOTNULL — Primary key — NOT NULL
  • 멤버ID (member_id) — NOTNULL — Foreign key → Member.멤버ID — NOT NULL
  • 레스토랑ID (restaurant_id) — NOTNULL — Foreign key → Restaurant.레스토랑ID — NOT NULL
  • 리뷰내용 (content) — NOTNULL
  • 점수 (socre) — NOTNULL
  • 생성일 (createdAt) — NOTNULL