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