reserve
Tables (4)
member
- partner_member_id (id) — Long — Primary key — NOT NULL — Auto-Increasement
- member_name (owner_name) — varchar
- phone_number — varchar
- gender — varchar
- role — varchar
reserve
- reserve_id (id) — Long — Primary key — NOT NULL
- store_id (id3) — Long — Foreign key → store.store_id — NOT NULL
- partner_member_id (id2) — Long — Foreign key → member.partner_member_id — NOT NULL — Auto-Increasement
- reserved_date — timestamp(LocalDateTime)
- reserve_status (status) — varchar
- review — varchar — CBLOB 일 가능성 있음
review
- review_id (id) — Long — Primary key — NOT NULL
- store_id (id2) — Long — Foreign key → store.store_id — NOT NULL
- partner_member_id (id3) — Long — Foreign key → member.partner_member_id — NOT NULL — Auto-Increasement
- rating — INTEGER
- review_text — varchar — CBLOB 으로 변경 가능성 존재
store
- store_id (id) — Long — Primary key — NOT NULL
- partner_member_id (id2) — Long — Foreign key → member.partner_member_id — NOT NULL — Auto-Increasement
- store_name — varchar
- legion — varchar
- city — varchar
- street — varchar
- zipcode — varchar
- description — varchar — CBLOB 으로도 될 수 있음