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