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