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