음식리뷰서비스

테이블 (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