음식리뷰서비스
테이블 (7)
Comments (comment)
- comment_id (PK) — BIGINT — 기본 키 — NOT NULL
- user_id (PK2) — BIGINT — 외래 키 → Users.user_id — NOT NULL
- review_id (PK3) — BIGINT — 외래 키 → Reviews.review_id — NOT NULL
- receipts_id (Key) — BIGINT — 외래 키 → Reviews.receipts_id — NOT NULL
- content (내용) — VARCHAR
- create_at (생성날짜) — VARCHAR
- update_at (수정날짜) — VARCHAR
Likes (Like)
- Like_id (PK) — BIGINT — 기본 키 — NOT NULL
- user_id (PK2) — BIGINT — 외래 키 → Users.user_id — NOT NULL
- review_id (PK3) — BIGINT — 외래 키 → Reviews.review_id — NOT NULL
- receipts_id (Key) — BIGINT — 외래 키 → Reviews.receipts_id — NOT NULL
Notifications (Notification)
- notification_id (PK) — BIGINT — 기본 키 — NOT NULL
- user_id (FK) — BIGINT — 외래 키 → Users.user_id — NOT NULL
- type (타입) — VARCHAR
- create_at (생성날짜) — DATETIME
Receipts (Untitled)
- receipts_id (Key) — BIGINT — 기본 키 — NOT NULL
- user_id (PK) — BIGINT — 외래 키 → Users.user_id — NOT NULL
- restaurant_id (PK2) — BIGINT — 외래 키 → Restaurants.restaurant_id — NOT NULL
- image_url (Field) — VARCHAR
- extracted_text (Field2) — VARCHAR
- created_at (Field3) — DATETIME
- updated_at (Field4) — DATETIME
Restaurants (Restaurant)
- restaurant_id (PK) — BIGINT — 기본 키 — NOT NULL
- user_id (FK) — BIGINT — 외래 키 → Users.user_id — NOT NULL
- name (이름) — VARCHAR
- address (주소) — VARCHAR
- phone_number (전화번호) — VARCHAR
- category (업종) — VARCHAR
- max_capacity (최대인원) — BIGINT
- opening_hours (오픈시간) — VARCHAR
- max_reservation_limit (생성날짜) — BIGINT
- reservation_time_unit (수정날짜) — BIGINT
- is_open (Field2) — BOOLEAN
- created_at (Field) — DATETIME
- updated_at (Field3) — DATETIME
Reviews (Review)
- review_id (PK) — BIGINT — 기본 키 — NOT NULL
- user_id (PK2) — BIGINT — 외래 키 → Users.user_id — NOT NULL
- restaurant_id (PK3) — BIGINT — 외래 키 → Restaurants.restaurant_id — NOT NULL
- receipts_id (Key) — BIGINT — 외래 키 → Receipts.receipts_id — NOT NULL
- content (내용) — VARCHAR
- rating (평가) — VARCHAR
- image_url (사진) — VARCHAR
- verified (방문인증) — Boolean
- create_at (생성날짜) — DATETIME
- update_at (수정날짜) — DATETIME
Users (User)
- user_id (PK) — BIGINT — 기본 키 — NOT NULL
- email (이메일) — VARCHAR
- password (비밀번호) — VARCHAR
- role (역할(점주/일반)) — VARCHAR
- phone_number (전화번호) — VARCHAR
- create_at (생성날짜) — DATETIME
- update_at (수정날짜) — DATETIME