haircut
Tables (4)
Customer
- Customer_id — Int — Primary key — NOT NULL
- 현재 머리 스타일 (hair_length) — boolean
- 만족도 (satisfaction) — Number
- 선택한 헤어 스타일 (selected_hairstyle) — varchar(55)
- 닉네임 (customer_name) — varchar(55)
Designer
- designer_id — Int — Primary key — NOT NULL
- 디자이너 명 (designer_name) — varchar(55)
- 직급 (designer_rank) — varchar(55)
- 총 시술 횟수 (total_count) — Int
- 평점 (rating) — numeric
Hairstyle_menu
- style_id — Int — Primary key — NOT NULL
- 머리 스타일 (hairstyle) — varchar(55)
- 가격 (cost) — Int
Payment
- payment_id — Int — Primary key — NOT NULL
- 날짜 (payment_date) — Date
- 가격 (amount) — Int
- designer_id — Int — Foreign key → Designer.designer_id — NOT NULL
- Customer_id — Int — Foreign key → Customer.Customer_id — NOT NULL
- style_id — Int — Foreign key → Hairstyle_menu.style_id — NOT NULL