TEST

Tables (5)

Atendances (Untitled4)

  • atendance_id (Key) — Primary key — NOT NULL
  • check_in (Field2) — Datetime
  • check_out (Field)
  • check_status (Field3)
  • student_id (Key2) — INT — Foreign key → students.student_id — NOT NULL
  • teacher_id (Key3) — Foreign key → Teachers.teacher_id — NOT NULL

Attitudes (Untitled)

  • attitude_id (Key) — Primary key — NOT NULL
  • attitude_desc (Field)
  • attitude_date (Field2)
  • student_id (Key2) — INT — Foreign key → students.student_id — NOT NULL
  • teacher_id (Key3) — Foreign key → Teachers.teacher_id — NOT NULL

Reports (Untitled2)

  • report_id (Key) — Primary key — NOT NULL
  • score (Field)
  • subject (Field2)
  • student_id (Key2) — INT — Foreign key → students.student_id — NOT NULL
  • teacher_id (Key3) — Foreign key → Teachers.teacher_id — NOT NULL

Teachers (Untitled3)

  • teacher_id (Key) — Primary key — NOT NULL
  • name (Field)
  • phone (Field2)
  • class (Field3)

students (sudent_table)

  • student_id (Key) — INT — Primary key — NOT NULL
  • name (Field) — varchar2
  • phone (Field2)
  • age (Field3)
  • gender (Field4)
  • addr (Field5)
  • phone2 (Field6)
  • consult (Field13)
  • status (Field15)
  • teacher_id (Key2) — Foreign key → Teachers.teacher_id — NOT NULL