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