restaurant_reservation
테이블 (6)
고객 (CUSTOMER)
- customer_id (PK) — bigint — 기본 키 — NOT NULL
- name (Field) — varchar(100)
- email (Field2) — varchar(100)
- password (Field6) — varchar(255)
- phone_number (Field3) — varchar(30)
- role (Field7) — varchar(25)
- created_at (Field4) — TIMESTAMP
- updated_at (Field5) — TIMESTAMP
리뷰 (REVIEW)
- review_id (PK) — biging — 기본 키 — NOT NULL
- customer_id (FK1) — bigint — 외래 키 → 고객.customer_id — NOT NULL
- shop_id (FK2) — bigint — 외래 키 → 매장.shop_id — NOT NULL — 매장 고유 코드
- Field — varchar(255)
- score (Field2) — int
- created_at (Field3) — TIMESTAMP
- updated_at (Field4) — TIMESTAMP
매장 (SHOP)
- shop_id (PK) — bigint — 기본 키 — NOT NULL — 매장 고유 코드
- manager_id (FK) — bigint — 외래 키 → 점장.manager_id — NOT NULL
- name (Field) — varchar(255)
- phone_number (Field3) — varchar(25)
- description (Field4) — varchar(255)
- address (Field5) — varchar(100)
- status (Field8) — varchar(10)
- open_time (Field6) — TIMESTAMP
- close_time (Field7) — TIMESTAMP
- rest_day (Field11) — varchar(100)
- created_at (Field9) — date
- updated_at (Field10) — date
메뉴 (MENU)
- menu_id (PK) — bigint — 기본 키 — NOT NULL
- shop_id (FK) — bigint — 외래 키 → 매장.shop_id — NOT NULL — 매장 고유 코드
- name (Field) — varchar(100)
- price (Field2) — int
- description (Field3) — varchar(255)
- photo (Field4) — text
- created_at (Field5) — TIMESTAMP
- updated_at (Field6) — TIMESTAMP
예약 (RESERVATION)
- reservation_id (PK) — bigint — 기본 키 — NOT NULL
- customer_id (FK) — bigint — 외래 키 → 고객.customer_id — NOT NULL
- shop_id (FK2) — bigint — 외래 키 → 매장.shop_id — NOT NULL — 매장 고유 코드
- code (Field) — varchar(255)
- customer_name (Field2) — varchar(100)
- reservation_time (Field3) — TIMESTAMP
- reservation_status (Field4) — varchar(100)
점장 (MANAGER)
- manager_id (PK) — bigint — 기본 키 — NOT NULL
- name (Field) — varchar(100)
- email (Field2) — varchar(100)
- password (Field6) — varchar(255)
- phone_number (Field3) — varchar(30)
- role (Field7) — varchar(25)
- created_at (Field4) — TIMESTAMP
- updated_at (Field5) — TIMESTAMP
- partner (Field8) — char(4)