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