CafeTeria

Tables (6)

Cafe (Untitled)

  • 매장ID (id) — Long — Primary key — NOT NULL
  • 점주ID (id2) — Long — Foreign key → Partner.점주ID — NOT NULL
  • 예약ID (id3) — Long — Foreign key → Reservation.예약ID — NOT NULL
  • 리뷰ID (id4) — Long — Foreign key → review.리뷰ID — NOT NULL
  • 고객ID (id22) — Long — Foreign key → review.고객ID — NOT NULL
  • 매장이름 (cname) — String
  • 매장Email (email) — String
  • 매장설명 (description) — String
  • 매장주소 (address) — String
  • 매장번호 (phone) — String

Customer (Untitled3)

  • 고객ID (id) — Long — Primary key — NOT NULL
  • 고객Email (email) — String — Primary key
  • 고객PW (password) — String — Primary key
  • 고객번호 (phone) — String
  • 고객가입날짜 (customerDt) — LocalDateTime
  • 고객이름 (name) — String
  • 고객EmailCode (emailCode) — String

Partner (Untitled2)

  • 점주ID (id) — Long — Primary key — NOT NULL
  • 점주Email (email) — String — Primary key
  • 점주Password (password) — String
  • 파트너승인날짜 (verificationDt) — LocalDateTime
  • 점주승인코드 (verificationCode) — String
  • 파트너승인 (verify)

Reservation (Untitled4)

  • 예약ID (id) — Long — Primary key — NOT NULL
  • 고객ID (id2) — Long — Foreign key → Customer.고객ID — NOT NULL
  • 고객Email (email) — String — Foreign key → Customer.고객Email
  • 예약Time (reservaiton_time) — LocalDateTime
  • 예약status (reservation_Status) — boolean
  • 매장이름 (cname) — String

kiosk (Untitled6)

  • 키오스크ID (id) — Long — Primary key — NOT NULL
  • 리뷰ID (id2) — Long — Foreign key → review.리뷰ID — NOT NULL
  • 매장ID (id3) — Long — Foreign key → Cafe.매장ID — NOT NULL
  • 리뷰ID (id4) — Long — Foreign key → Cafe.리뷰ID — NOT NULL
  • 고객ID (id22) — Long — Foreign key → Cafe.고객ID — NOT NULL
  • Field

review (Untitled5)

  • 리뷰ID (id) — Long — Primary key — NOT NULL
  • 고객ID (id2) — Long — Foreign key → Customer.고객ID — NOT NULL
  • 리뷰내용 (content) — String
  • 평점 (rate) — int