erd
Tables (4)
department
- Key (department_id) — Primary key — NOT NULL
- (school_id) — Foreign key → school.school_id — NOT NULL
- Field (department_name)
school (school(院))
- (school_id) — Primary key — NOT NULL
- Field (school_name)
student
- Key (student_id) — Primary key — NOT NULL
- Key (department_id) — Foreign key → department.Key — NOT NULL
- (school_id) — Foreign key → department.school_id — NOT NULL
- Field (student_name)
teacher
- Key (teacher_id) — Primary key — NOT NULL
- Key (department_id) — Foreign key → department.Key — NOT NULL
- (school_id) — Foreign key → department.school_id — NOT NULL
- Field (teacher_name)