예약

테이블 (12)

Category (Untitled9)

  • Key — 기본 키 — NOT NULL
  • Key (Key2) — 기본 키 — NOT NULL
  • description (Field)
  • shop_name (Field2)
  • (Key22) — 외래 키 → Service.category_id — NOT NULL

Customer (Untitled3)

  • id (Key) — 기본 키 — NOT NULL
  • reservation_id_list (Key2) — 외래 키 → User.ID — NOT NULL
  • shop_id_list(관심_shop) (Field)
  • reservation_id_list (Field3)
  • card_information (Field2)

Holiday (Untitled7)

  • Key — 기본 키 — NOT NULL
  • ID (Key22) — 외래 키 → Manager.shop_id — NOT NULL
  • Key (Key2) — 외래 키 → Shop.Key — NOT NULL
  • customer_id (Key23) — 외래 키 → Shop.customer_id — NOT NULL
  • service_id_list (Key232) — 외래 키 → Shop.service_id_list — NOT NULL
  • manager_id_list (Key3) — 외래 키 → Shop.manager_id_list — NOT NULL
  • category_id_list (Key4) — 외래 키 → Shop.category_id_list — NOT NULL
  • Date (Field)
  • Reason (Field2)
  • Start_time (Field6)
  • End_time (Field3)

Manager (Untitled)

  • id (Key) — 기본 키 — NOT NULL
  • shop_id (Key2) — 외래 키 → User.ID — NOT NULL
  • service_id_list (Field2)
  • career (Field)
  • work_time (Field3)

Reservation

  • id (Key) — 기본 키 — NOT NULL
  • manager_id (Key22) — 외래 키 → Manager.shop_id — NOT NULL
  • customer_id (Key23) — 외래 키 → Customer.reservation_id_list — NOT NULL
  • shop_id (Key4) — 외래 키 → Shop.Key — NOT NULL
  • service_id (Key24) — 외래 키 — NOT NULL
  • state (Field)
  • date (Field8)
  • start_time (Field2)
  • end_time (Field7)
  • price (Field5)
  • num_of_user (Field6)
  • user_request (Field3)
  • 결제 시간 (Field4)
  • 결제취소정책 (Field9)
  • 영수증번호 (Field10)

Rieview (Untitled5)

  • Key — 기본 키 — NOT NULL
  • ID (Key22) — 외래 키 → Customer.reservation_id_list — NOT NULL
  • comment (Field)
  • date (Field2)
  • photos (Field3)
  • rate (Field7)

Service (Untitled8)

  • Key — 기본 키 — NOT NULL
  • category_id (Key2) — 기본 키 — NOT NULL
  • manager_id (Key22) — 외래 키 → Manager.shop_id — NOT NULL
  • 추가서비스 (Field5) — LIST
  • description (Field)
  • time (Field2)
  • price (Field3)
  • phtos (Field4)

Shop (Untitled6)

  • Key — 기본 키 — NOT NULL
  • customer_id (Key2) — 외래 키 → Customer.id — NOT NULL
  • service_id_list (Key23) — 외래 키 → Customer.reservation_id_list — NOT NULL
  • manager_id_list (Key3) — 외래 키 → Manager.id — NOT NULL
  • category_id_list (Key4) — 외래 키 → Category.Key — NOT NULL
  • state (Field)
  • name (Field2)
  • description (Field8)
  • latitude (Field3)
  • gratitude (Field4)
  • address (Field5)
  • shop_url(홈페이지 주소) (Field6)
  • photos (Field13)
  • 사업자등록번호 (Field14)
  • on_sale_time(영업시간) (Field7)
  • average_rank (Field10)
  • total_rank_sum (Field11)
  • num_of_review (Field12)

User (Untitled2)

  • ID (Key) — 기본 키 — NOT NULL
  • role (Field)
  • name (Field2)
  • phone_number (Field3)
  • password (Field4)
  • state (Field5)
  • gender (Field6)
  • birthdate (Field7)

closing_time (Untitled11)

    vacation (Untitled10)

      회원권 (Untitled4)