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 으로도 될 수 있음