uxdesign
테이블 (4)
리뷰 (Review)
- review_id — int — 기본 키 — NOT NULL
- member_id — int — 외래 키 → 멤버.member_id — NOT NULL
- cafe_id (Key) — int — 외래 키 → 카페.cafe_id — NOT NULL
- upload_date — date — NOT NULL
- content — varchar(1000) — NOT NULL
메뉴 (Menu)
- menu_id — int — 기본 키 — NOT NULL
- cafe_id — int — 외래 키 → 카페.cafe_id — NOT NULL
- price — int — NOT NULL
멤버 (Member)
- member_id — int — 기본 키 — NOT NULL
- email — varchar(100) — NOT NULL
- password — varchar(100) — NOT NULL
카페 (Cafe)
- cafe_id — int — 기본 키 — NOT NULL
- volume — varchar(50) — NOT NULL
- totalSeat — int — NOT NULL
- remainSeat — int — NOT NULL
- totalMultitap — int — NOT NULL
- remainMultitap — int — NOT NULL
- address — varchar(100) — NOT NULL
- onpeningHours — varchar(500) — NOT NULL
- isOpen — varchar(100) — NOT NULL