erp

Tables (5)

Attendances

  • attend_id (Key) — Primary key — NOT NULL
  • check_in (Field)
  • check_out (Field2)
  • status (Field3)
  • student_id (Key2) — INT — Foreign key → Students.student_id — NOT NULL
  • teach_id (Key3) — Foreign key → Teachers.teach_id — NOT NULL

Attitundes (Attitudes)

  • attutude_id (Key2) — Primary key — NOT NULL
  • attitude_desc (Field)
  • attitude_date (Field2)
  • student_id (Key) — INT — Foreign key → Students.student_id — NOT NULL
  • teach_id (Key3) — Foreign key → Teachers.teach_id — NOT NULL

Reports

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

Students

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

Teachers

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