erp

Tables (5)

Attendances (Untitled5)

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

Attitudes (Untitled4)

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

Reports (Untitled3)

  • 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 (Untitled)

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

Teachers (Untitled2)

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