toy-project

Tables (5)

member (Untitled)

  • id (Key) — Primary key — NOT NULL

memberGrade (Untitled2)

  • Key — Primary key — NOT NULL

review (리뷰)

  • ID (Key) — Primary key — NOT NULL
  • 회원ID (Field) — Long
  • 주문 ID (Field2) — Long
  • 가게 ID (Field3) — Long
  • 평점 (Field4) — Integer
  • 내용 (Field5) — String
  • 등록날짜 (Field6) — Time
  • 삭제날짜 (Field7) — Time
  • 삭제여부 (Field8) — Boolean
  • 상태 (Field9) — Enum

reviewMenu (리뷰 메뉴)

  • id (Key) — Primary key — NOT NULL
  • 메뉴 ID (Field2)
  • 리뷰 ID (Key2) — Foreign key → review.ID — NOT NULL

reviewimg (리뷰 이미지)

  • ID (Key) — Primary key — NOT NULL
  • 이미지경로 (Field2) — String
  • 리뷰 ID (Key2) — Foreign key → review.ID — NOT NULL