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