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