Hair
Tables (4)
HAIR
- HAIR_CAT — VARCHAR2(10) — Primary key — NOT NULL
- HAIR_PRICE — NUMBER(10)
- HAIR_NAME — VARCHAR2(20)
- SalonNumber — NUMBER(30) — Foreign key → Salon.SalonNumber — NOT NULL
MEMBER
- MEM_ID — VARCHAR2(40) — Primary key — NOT NULL
- MEM_NAME — VARCHAR2(40)
- MEM_TEL — VARCHAR2(40)
- MEM_SSN — VARCHAR2(20)
- MEM_PASSWORD — VARCHAR2(80)
- MEM_ADDRESS — VARCHAR2(80)
- HAIR_CAT — VARCHAR2(10) — Foreign key → HAIR.HAIR_CAT — NOT NULL
Reservation
- REV_NUMBER — NUMBER(10) — Primary key — NOT NULL
- HAIR_NAME — VARCHAR2(20)
- HAIR_PRICE — NUMBER(10)
- MEM_ID — VARCHAR2(40) — Foreign key → MEMBER.MEM_ID — NOT NULL
- SalonNumber — NUMBER(30) — Foreign key → Salon.SalonNumber — NOT NULL
Salon
- SalonNumber — NUMBER(30) — Primary key — NOT NULL
- SalonName (Salon_Name) — VARCHAR(20)
- SalonAddress (Salon_Address) — VARCHAR(270)
- Salon_Telephone — VARCHAR(40)