restaurant_table_reservation_service
테이블 (5)
고객 (customer)
- customer_id (고객ID) — BIGINT — 기본 키 — NOT NULL
- username (회원이메일) — VARCHAR(50)
- password (비밀번호) — VARCHAR(50)
- phone (전화번호) — VARCHAR(50)
- name (이름) — VARCHAR(10)
- roles (역할) — VARCHAR(50)
- created_at (생성시간) — TIMESTAMP
- modified_at (수정시간) — TIMESTAMP
리뷰 (review)
- review_id (리뷰ID) — BIGINT — 기본 키 — NOT NULL
- content (리뷰내용) — TEXT
- created_at (생성시간) — TIMESTAMP
- modified_at (수정시간) — TIMESTAMP
식당 (restaurant)
- restaurant_id (식당ID) — BIGINT — 기본 키 — NOT NULL
- name (식당명) — VARCHAR(50)
- position (위치) — VARCHAR(50)
- description (설명) — TEXT
- created_at (생성시간) — TIMESTAMP
- modified_at (수정시간) — TIMESTAMP
- manager_id (점장ID) — BIGINT — 외래 키 → 점장.manager_id — NOT NULL
예약정보 (reservation)
- reservation_id (예약정보ID) — BIGINT — 기본 키 — NOT NULL
- customer_id (고객ID) — BIGINT — 외래 키 → 고객.customer_id — NOT NULL
- restaurant_id (식당ID) — BIGINT — 외래 키 → 식당.restaurant_id — NOT NULL
- review_id (리뷰ID) — BIGINT — 외래 키 → 리뷰.review_id
- time (예약시각) — TIMESTAMP
- details (예약내용) — TEXT
- visit (방문완료처리여부) — TINYINT(1)
- created_at (생성시간) — TIMESTAMP
- modified_at (수정시간) — TIMESTAMP
점장 (manager)
- manager_id (점장ID) — BIGINT — 기본 키 — NOT NULL
- username (회원이메일) — VARCHAR(50)
- password (비밀번호) — VARCHAR(50)
- phone (전화번호) — VARCHAR(50)
- name (이름) — VARCHAR(10)
- roles (역할) — VARCHAR(50)
- created_at (생성시간) — TIMESTAMP
- modified_at (수정시간) — TIMESTAMP