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