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