kbsHair

Tables (5)

costumer

  • costumer_Phone — int(11) — Primary key — NOT NULL
  • costumer_name — varchar(11)
  • costum_type — varchar(11)
  • costum_visit_cnt (costum_visti_cnt) — int(11)
  • costum_blacklist — char(1)

designer (desinger)

  • dj_ID — int(11) — Primary key — NOT NULL
  • dj_name — varchar(255)
  • dj_image — varchar(255)
  • dj_able — varchar(255)

history

  • his_ID — Primary key — NOT NULL
  • result — varchar(11)
  • res_ID — int(11) — Foreign key → reservaion.res_ID — NOT NULL

priceHair

  • item_ID — int(11) — Primary key — NOT NULL
  • item_name — varchar(255)
  • item_price

reservaion

  • res_ID — int(11) — Primary key — NOT NULL
  • date — date
  • time — time
  • item_ID — int(11) — Foreign key → priceHair.item_ID — NOT NULL
  • dj_ID — int(11) — Foreign key → designer.dj_ID — NOT NULL
  • costumer_Phone — int(11) — Foreign key → costumer.costumer_Phone — NOT NULL