TEST

Tables (5)

Costumer

  • costum_phone — VARCHAR(11) — Primary key — NOT NULL
  • costum_name — VARCHAR(11)
  • costum_type — VARCHAR(11)
  • costum_visit_cnt — INT(11)
  • costum_blacklist — CHAR(1)

Designer

  • dj_id — INT(11) — Primary key — NOT NULL
  • dj_name — VARCHAR(255)
  • dj_image — VARCHAR(255)
  • dj_cando — INT(11)

History

  • his_id — INT(11) — Primary key — NOT NULL
  • RES_ID — INT(11) — Foreign key → Reservaion.RES_ID — NOT NULL
  • result — VARCHAR(11)

PriceHair (pricehair)

  • Item_ID — INT(11) — Primary key — NOT NULL
  • item_name — VARCHAR(255)
  • item_price — INT(11)

Reservaion

  • RES_ID — INT(11) — Primary key — NOT NULL
  • Date — DATE
  • Time — TIME
  • Field
  • Item_ID — INT(11) — Foreign key → PriceHair.Item_ID — NOT NULL
  • dj_id — INT(11) — Foreign key → Designer.dj_id — NOT NULL
  • costum_phone — VARCHAR(11) — Foreign key → Costumer.costum_phone — NOT NULL