zb

Tables (5)

customer (손님)

  • customer_id (ID) — bigint — Primary key — NOT NULL
  • username (이름) — varchar(50)
  • password (비밀번호) — varchar(100)
  • activated (활성화 여부) — boolean
  • created_at (생성일자) — datetime
  • modified_at (수정일자) — datetime

manager (점장)

  • manager_id (ID) — bigint — Primary key — NOT NULL
  • username (이름) — varchar(50)
  • password (비밀번호) — varchar(100)
  • activated (활성화 여부) — boolean
  • created_at (생성일자) — datetime
  • modified_at (수정일자) — datetime

reservation (예약)

  • reservation_id (ID) — bigint — Primary key — NOT NULL
  • customer_id (손님ID) — bigint — Foreign key → customer.customer_id — NOT NULL
  • store_id (상점ID) — bigint — Foreign key → store.store_id — NOT NULL
  • reservation_time (예약 시간) — datetime
  • status (상태) — enum
  • created_at (생성일자) — datetime
  • modified_at (수정일자) — datetime

review (리뷰)

  • review_id (ID) — bigint — Primary key — NOT NULL
  • store_id (매장ID) — bigint — Foreign key → store.store_id — NOT NULL
  • customer_id (손님ID) — bigint — Foreign key → customer.customer_id — NOT NULL
  • reservation_id (예약ID) — bigint — Foreign key → reservation.reservation_id — NOT NULL
  • content (내용) — varchar(100)
  • rating (별점) — int
  • created_at (생성일자) — datetime
  • modified_at (수정일자) — datetime

store (상점)

  • store_id (ID) — bigint — Primary key — NOT NULL
  • manager_id (점장ID) — bigint — Foreign key → manager.manager_id — NOT NULL
  • store_name (이름) — varchar(50)
  • location (위치) — varchar(100)
  • description (설명) — varchar(100)
  • created_at (생성일자) — datetime
  • modified_at (수정일자) — datetime