키오스크

테이블 (4)

Member

  • id — Long — 기본 키 — NOT NULL
  • username — varchar(50) — NOT NULL
  • password — varchar(50) — NOT NULL
  • email — varchar(50)
  • Field4 (rolesList) — varchar(50)
  • Field5 (reserve_id) — Long
  • Field6 (review_id) — Long
  • Field7 (shop_id) — Long

Reserve

  • id — Long — 기본 키 — NOT NULL
  • member_id — Long — 외래 키 → Member.id — NOT NULL
  • reserve_date — DateTime
  • phone — Long
  • reserve_status — varchar(50)
  • arrive_status — varchar(50)
  • restaurant_id — Long — 외래 키 → Restaurant.id — NOT NULL

Restaurant

  • id — Long — 기본 키 — NOT NULL
  • id (member_id) — Long — 외래 키 → Member.id — NOT NULL
  • storename — varchar(50) — NOT NULL
  • location (loaction) — varchar(50) — NOT NULL
  • explanation — varchar(50)
  • star — Double
  • review_id — Long
  • reserve_id — Long

Review

  • id — Long — 기본 키 — NOT NULL
  • member_id — Long — 외래 키 → Member.id — NOT NULL
  • stars — varchar(50)
  • contents — varchar(50)
  • restaurant_id — Long — 외래 키 → Restaurant.id — NOT NULL