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