Project1_Excercise2_0923

Tables (4)

CLASS

  • FK (Class ID) — INT(20) — Primary key — NOT NULL
  • FK (Part ID) — INT(20) — Primary key — NOT NULL
  • FK (Class ID) — INT(20) — Foreign key → LEVEL.FK — NOT NULL
  • FK (Member ID) — INT(20) — Foreign key → LEVEL.FK — NOT NULL
  • FK (Sports Code) — INT(20) — Foreign key → LEVEL.FK — NOT NULL
  • Field (Activity Code) — INT(100)
  • Field (Start Time) — INT(100)
  • Field2 (End Time) — INT(100)
  • Field (Max Member No) — INT(100)
  • Field2 (Current Member No) — INT(100)

LEVEL

  • FK (Class ID) — INT(20) — Primary key — NOT NULL
  • FK (Member ID) — INT(20) — Primary key — NOT NULL
  • FK (Sports Code) — INT(20) — Primary key — NOT NULL
  • Field2 (Location) — CHAR(100)

MEMBER

  • PK (Member ID) — INT(20) — Primary key — NOT NULL
  • FK (Class ID) — INT(20) — Foreign key → LEVEL.FK — NOT NULL
  • FK (Member ID2) — INT(20) — Foreign key → LEVEL.FK — NOT NULL
  • FK (Sports Code) — INT(20) — Foreign key → LEVEL.FK — NOT NULL
  • Field (Member Name) — CHAR(100)
  • Field (Address) — CHAR(200)
  • Field (Age) — INT(20)

SPORTS

  • PK (Sports Code) — INT(20) — Primary key — NOT NULL
  • FK (Class ID) — INT(20) — Foreign key → LEVEL.FK — NOT NULL
  • FK (Member ID) — INT(20) — Foreign key → LEVEL.FK — NOT NULL
  • Field (Sports Description) — CHAR(100)