Homework
Tables (6)
Aerobic
- ID — NOT NULL — Foreign key → Member.ID
- TimeStamp — AUTO_INCREMENT — Foreign key → Member.TimeStamp — NOT NULL
- Name — NOT NULL
- RunningTime — NULLABLE
Brackfast
- ID — NOT NULL — Foreign key → Member.ID
- TimeStamp — AUTO_INCREMENT — Foreign key → Member.TimeStamp — NOT NULL
- Food — NOT NULL
Dinner
- ID — NOT NULL — Foreign key → Member.ID
- TimeStamp — AUTO_INCREMENT — Foreign key → Member.TimeStamp — NOT NULL
- Food — NOT NULL
Lunch
- ID — NOT NULL — Foreign key → Member.ID
- TimeStamp — AUTO_INCREMENT — Foreign key → Member.TimeStamp — NOT NULL
- Food — NOT NULL
Member (Untitled)
- ID — NOT NULL — Primary key
- TimeStamp — AUTO_INCREMENT — Primary key — NOT NULL
- Name — NOT NULL
WorkingOut
- ID — NOT NULL — Foreign key → Member.ID
- TimeStamp — AUTO_INCREMENT — Foreign key → Member.TimeStamp — NOT NULL
- Name — NOT NULL
- Count — NULLABLE
- Set — NULLABLE