Review
Tables (4)
Member (멤버)
- 멤버ID (member_id) — NOTNULL — Primary key — NOT NULL
- 이메일 (email) — NOTNULL
- 패스워드 (password) — NOTNULL
- 권한 (authority) — NOTNOLL
Menu (메뉴)
- 메뉴ID (menu_id) — NOTNULL — Primary key — NOT NULL
- 레스토랑ID (restaurant_id) — NOTNULL — Foreign key → Restaurant.레스토랑ID — NOT NULL
- 메뉴이름 (name) — NOTNULL
- 가격 (price) — NOTNULL
- 생성일 (created_At) — NOTNULL
- 수정일 (modified_At) — NOTNULL
Restaurant (레스토랑)
- 레스토랑ID (restaurant_id) — NOTNULL — Primary key — NOT NULL
- 멤버ID (member_id) — NOTNULL — Foreign key → Member.멤버ID — NOT NULL
- 레스토랑 이름 (name) — NOTNULL
- 주소 (address) — NOTNULL
- 생성일 (created_At) — NOTNULL
- 수정일 (modified_At) — NOTNULL
Review (리뷰)
- 리뷰ID (review_id) — NOTNULL — Primary key — NOT NULL
- 멤버ID (member_id) — NOTNULL — Foreign key → Member.멤버ID — NOT NULL
- 레스토랑ID (restaurant_id) — NOTNULL — Foreign key → Restaurant.레스토랑ID — NOT NULL
- 리뷰내용 (content) — NOTNULL
- 점수 (socre) — NOTNULL
- 생성일 (createdAt) — NOTNULL