db
Tables (6)
Attendance (CopyOfCopyOfCopyOfCopyOfUntitled2)
- attendance (Key) — not null — Primary key — NOT NULL
- class_id (Foreign Key) — not null — Primary key
- date (Field2) — not null
- status (Field3) — not null
Class (CopyOfCopyOfCopyOfUntitled2)
- student_id (Key) — not null — Primary key — NOT NULL
- teacher_id (Foreign Key) — not null — Primary key — NOT NULL
- attendance (Key2) — not null — Foreign key → Attendance.attendance — NOT NULL
- class_id (Foreign Key2) — not null — Foreign key → Attendance.class_id
- grade_id (Key3) — not null — Foreign key → Grade.grade_id — NOT NULL
- class_id (Foreign Key3) — not null — Foreign key → Grade.class_id — NOT NULL
- student_id (Field22) — not null — Foreign key → Grade.student_id
- teacher_id (Key4) — not null — Foreign key → Teacher.teacher_id — NOT NULL
- subject (Field) — not null
- time (Field2) — not null
Grade (CopyOfCopyOfCopyOfUntitled)
- grade_id (Key) — not null — Primary key — NOT NULL
- class_id (Foreign Key) — not null — Primary key — NOT NULL
- student_id (Field2) — not null — Primary key
- score (Field3) — not null
Student (Untitled)
- student_id (Key) — not null — Primary key — NOT NULL
- grade_id (Key2) — not null — Foreign key → Grade.grade_id — NOT NULL
- class_id (Foreign Key) — not null — Foreign key → Grade.class_id — NOT NULL
- student_id (Field22) — not null — Foreign key → Grade.student_id
- name (Field) — not null
- age (Field2) — not null
- gender (Field3) — not null
- parent_contact (Field4) — not null
StudentClass (CopyOfUntitled)
- student_id (Key) — not null — Primary key — NOT NULL
- class_id (Primary Key) — not null — Primary key
- student_id (Key2) — not null — Foreign key → Student.student_id — NOT NULL
- student_id (Key3) — not null — Foreign key → Class.student_id — NOT NULL
- teacher_id (Foreign Key) — not null — Foreign key → Class.teacher_id — NOT NULL
- attendance (Key22) — not null — Foreign key → Class.attendance — NOT NULL
- class_id (Foreign Key2) — not null — Foreign key → Class.class_id
- grade_id (Key23) — not null — Foreign key → Student.grade_id — NOT NULL
- class_id (Foreign Key3) — not null — Foreign key → Student.class_id — NOT NULL
- student_id (Field22) — not null — Foreign key → Student.student_id
- grade_id (Key32) — not null — Foreign key → Class.grade_id — NOT NULL
- class_id (Foreign Key32) — not null — Foreign key → Class.class_id — NOT NULL
- student_id (Field222) — not null — Foreign key → Class.student_id
- teacher_id (Key4) — not null — Foreign key → Class.teacher_id — NOT NULL
Teacher (CopyOfCopyOfUntitled)
- teacher_id (Key) — not null — Primary key — NOT NULL
- name (Field) — not null
- contact (Field2) — not null
- subject (Field3) — not null