miniproject

Tables (5)

EGOALS

  • EGNUM — NUMBER
  • EGID — NVARCHAR2(10) — Foreign key → EMEMBER.EID
  • EXNUM — NUMBER — Foreign key → EXTYPES.EXNUM
  • ETEXTIME — NUMBER
  • ESDATE — DATE
  • EEDATE — DATE

EMEMBER

  • EID — NVARCHAR2(10)
  • EPW — NVARCHAR2(20)
  • ENAME — NVARCHAR2(5)
  • EAGE — NUMBER
  • EEMAIL — NVARCHAR2(30)
  • EPHONE — NVARCHAR2(20)
  • EHEIGHT — NUMBER
  • EWEIGHT — NUMBER

ERECORDS

  • ERNUM — NUMBER
  • ERID — NVARCHAR2(10) — Foreign key → EMEMBER.EID
  • EXNUM — NUMBER — Foreign key → EXTYPES.EXNUM
  • EDATE — DATE
  • ETIME — NUMBER
  • ECALORIES — NUMBER

EXTYPES

  • EXNUM — NUMBER
  • EXNAME — NVARCHAR2(20)
  • EXCATEGORY — NVARCHAR2(20)
  • EXCALORIES — NUMBER

MENU

  • EMNUM — NUMBER
  • EMID — NVARCHAR2(10) — Foreign key → EMEMBER.EID
  • EDATE — DATE
  • ECALORIES — NUMBER
  • EPROTEIN — NUMBER
  • ECARBOHYDRATES — NUMBER
  • EFATS — NUMBER