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)