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)