ddd

Tables (7)

Classes (Untitled6)

  • Key — Primary key — NOT NULL
  • class_region (Field) — char — NOT NULL
  • class_name (Field2) — int — NOT NULL
  • Key3 — Foreign key → Regions.Key3 — NOT NULL

Projects (Untitled3)

  • Project_id (Key) — int — Primary key — NOT NULL
  • student_nums (Field) — int — NOT NULL
  • project_num (Field2) — int — NOT NULL
  • project_name (Field3) — char — NOT NULL
  • student_id (Key2) — int — Foreign key → Students.student_id — NOT NULL

Regions (Untitled5)

  • Key3 — Primary key — NOT NULL
  • region_name (Field) — char — NOT NULL
  • professor_id (Key) — int — Foreign key → professors.professor_id — NOT NULL
  • student_id (Key2) — int — Foreign key → Students.student_id — NOT NULL

Students (Untitled2)

  • student_id (Key) — int — Primary key — NOT NULL
  • professor_num (Field) — int
  • student_num (Field2) — int
  • student_name (Field3) — char — NOT NULL
  • student_phone (Field4) — int — NOT NULL
  • campus_region (Field5) — char — NOT NULL
  • project (Field6)
  • professor_id (Key2) — int — Foreign key → professors.professor_id — NOT NULL

Teams (Untitled7)

  • team_class (Field) — int — NOT NULL
  • team_name (Field2) — char — NOT NULL
  • Key — Foreign key → Classes.Key — NOT NULL

Training_aids (Untitled4)

  • training_aid_id (Key) — int — Primary key — NOT NULL
  • student_id (Field) — int — NOT NULL
  • training_aid_name (Field2) — char — NOT NULL
  • purchase_date (Field3) — date — NOT NULL
  • lend_date (Field4) — date — NOT NULL
  • lender_name (Field5) — char — NOT NULL
  • due_date (Field6) — date — NOT NULL
  • student_id (Key2) — int — Foreign key → Students.student_id — NOT NULL

professors (Untitled)

  • professor_id (Key) — int — Primary key — NOT NULL
  • professor_num (Field) — int — NOT NULL
  • professor_name (Field2) — char — NOT NULL
  • professor_phone (Field3) — int — NOT NULL
  • region (Field4) — char — NOT NULL