daily3

Tables (9)

class (CopyOfUntitled)

  • ID (Key2) — Foreign key → region.ID — NOT NULL
  • ID (Key22) — Foreign key → region.ID — NOT NULL
  • ID (Field)
  • REGEIONID (Field2)
  • CLASSNUMBER (Field3)
  • CONSULTANTID (Field4)
  • ID (Key) — Foreign key → student.ID — NOT NULL
  • ID (Key3) — Foreign key → student.ID — NOT NULL

coach (CopyOf.4)

  • ID (Key) — Primary key — NOT NULL
  • STATUS (Field)
  • TASK (Field2)
  • CLASSID (Field3)
  • ID (Key2) — Foreign key → consultant.ID — NOT NULL

cohort (.)

  • ID (Key) — Primary key — NOT NULL
  • STATUS (Field)

consultant (CopyOf.3)

  • ID (Key) — Primary key — NOT NULL
  • STATUS (Field)
  • TASK (Field2)
  • CLASSID (Field3)
  • ID (Key2) — Foreign key → coach.ID — NOT NULL

cource (3)

  • ID (Key) — Primary key — NOT NULL
  • NAME (Field)

graduation (2)

  • ID (Key) — Primary key — NOT NULL
  • NAME (Field)

major (1)

  • ID (Key) — Primary key — NOT NULL
  • STATUS (Field)

region (CopyOf.2)

  • ID (Key) — Primary key — NOT NULL
  • ID (Key2) — Foreign key → class.ID — NOT NULL
  • NAME (Field)

student (4)

  • ID (Key) — Primary key — NOT NULL
  • ID (Key3) — Foreign key → cohort.ID — NOT NULL
  • NAME (Field2)
  • STATUS (Field3)
  • GRADUATION (Field4)
  • CLASSID (Field6)
  • ID (Key2) — Foreign key → cohort.ID — NOT NULL