tabling-cloning
Tables (8)
Favorite (관심매장)
- favorite_id (Key) — BIGINT — Primary key — NOT NULL
- client_id (회원번호) — BIGINT — Foreign key → User.client_id — NOT NULL
- store_id (매장_번호) — BIGINT — Foreign key → Store.store_id — NOT NULL
- create_datetime (생성일자) — DATETIME
- update_datetime (수정일자) — DATETIME
Reservation (예약)
- reservation_id (Key) — BIGINT — Primary key — NOT NULL
- client_id (회원번호) — BIGINT — Foreign key → User.client_id — NOT NULL
- store_id (Key2) — BIGINT — Foreign key → Store.store_id — NOT NULL
- datetime (예약시간) — DATETIME
- status (Field2) — tinyint
- description (기타)
- create_datetime (Field3) — DATETIME
- update_datetime (Field4) — DATETIME
Reservation Table Queue (줄서기)
- remote_reservation_id (Key) — BIGINT — Primary key — NOT NULL
- store_id (Key2) — BIGINT — Foreign key → Store.store_id — NOT NULL
- client_id (회원번호) — BIGINT — Foreign key → User.client_id — NOT NULL
- ticket_number (Field) — INTEGER
- status (Field3) — tinyint
- create_datetime (Field2) — DATETIME
- update_datetime (Field4) — DATETIME
ReservationTime (영업시간)
- id (Key) — Primary key — NOT NULL
- store_id (매장_번호) — BIGINT — Foreign key → Store.store_id — NOT NULL
- day\ (줄서기/예약) — tinyint
- status (Field) — tinyint
- start_time (Field2) — time
- end_time (Field3) — time
- create_datetime (Field4)
- update_datetime (Field5)
Review (댓글)
- review_id (Key) — BIGINT — Primary key — NOT NULL
- store_id (Key2) — BIGINT — Foreign key → Store.store_id — NOT NULL
- client_id (회원번호) — BIGINT — Foreign key → User.client_id — NOT NULL
- rating (Field) — tinyint
- comment (Field2) — VARCHAR
- status (Field5) — tinyint
- create_datetime (Field3) — DATETIME
- update_datetime (Field4) — DATETIME
Store (매장)
- store_id (매장_번호) — BIGINT — Primary key — NOT NULL
- name (이름) — VARCHAR
- address (주소) — VARCHAR
- district (지역구) — TINYINT
- phone_number (전화번호) — VARCHAR
- daily_code (Field2) — VARCHAR
- image (이미지) — VARCHAR
- reservation_table_queue_status (활성화/비활) — BIT
- reservation_status (Field5) — BIT
- food_type (Field7) — tinyint
- total_rating (평점) — TINYINT
- favorite_count (Field6) — int
- total_comment (댓글_갯수) — VARCHAR
- avg_wait_time (Field) — INTEGER
- description (소개) — VARCHAR
- create_datetime (생성일자) — DATETIME
- update_datetime (수정일자) — DATETIME
- Field8
User (회원)
- client_id (회원번호) — BIGINT — Primary key — NOT NULL
- email (이메일) — VARCHAR(100)
- name (이름) — VARCHAR(30)
- oauth_provider (oauth_제공자) — VARCHAR(3)
- oauth_token (oauth_토큰) — VARCHAR(50)
- phone_number (번호)
- authorization (권한) — TINYINT
- status (상태) — TINYINT
- penalty_count (노쇼_수) — INTEGER
- penalty_updated_datetime (Field) — DATETIME
- create_datetime (생성일자) — DATETIME
- update_datetime (수정일자) — DATETIME
multiple_owner_store (직원_매장)
- multiple_ownder_store_id (Key) — BIGINT — Primary key — NOT NULL
- store_id (Key3) — BIGINT — Foreign key → Store.store_id — NOT NULL
- client_id (회원번호) — BIGINT — Foreign key → User.client_id — NOT NULL
- create_datetime (Field) — DATETIME
- update_datetime (Field2) — DATETIME