project

Tables (6)

Class (Untitled2)

  • ClassID (classid) — int(PK) — Primary key — NOT NULL
  • id (id2) — int(PK) — Foreign key → Consultant.id — NOT NULL
  • id (id3) — int(PK) — Foreign key → Coach.id — NOT NULL
  • Region (region) — text
  • ClassNumber (classnumber) — int
  • TrainingCourseID (training_course_id) — int

Coach (Untitled6)

  • id — int(PK) — Primary key — NOT NULL
  • WorkType (Field)

Consultant (Untitled5)

  • id — int(PK) — Primary key — NOT NULL
  • WorkType (Field)

Region (Untitled3)

  • id — int(PK) — Primary key — NOT NULL
  • id (id2) — int(PK) — Foreign key → Consultant.id — NOT NULL
  • id (id3) — int(PK) — Foreign key → Coach.id — NOT NULL
  • Region Name (Region_name) — text

Trainee (Untitled)

  • id — int(PK) — Primary key — NOT NULL
  • ClassID (classid2) — int — Foreign key → Class.ClassID — NOT NULL
  • id (id22) — int(PK) — Foreign key → Class.id — NOT NULL
  • id (id3) — int(PK) — Foreign key → Class.id — NOT NULL
  • Generation (generation) — int
  • MajorStatus (major_status) — text
  • Dropout (dropout) — boolean

TrainingCourse (Untitled4)

  • TrainingCourseID (Key) — int(PK) — Primary key — NOT NULL
  • id — int(PK) — Foreign key → Consultant.id — NOT NULL
  • id (id2) — int(PK) — Foreign key → Coach.id — NOT NULL
  • CourserName (Field) — text