키오스크
테이블 (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