erp

Tables (6)

Attendances (Untitled6)

  • report_id (Key) — Primary key — NOT NULL
  • check_id (Field)
  • Field2
  • Field3

Attitude (Untitled2)

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

Classes (Untitled3)

  • class_id (Key) — Primary key — NOT NULL
  • name (Field)
  • position (Field2)
  • teach_id (Key3) — Foreign key → students.student_id — NOT NULL

Reports (Untitled4)

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

Teachers (Untitled5)

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

students (Untitled)

  • student_id (Key) — INT — Primary key — NOT NULL
  • name (Field)
  • phone (Field2)
  • age (Field3)
  • gender (Field4)
  • addr (Field5)
  • phone2 (Field6)
  • teacher (Field7)
  • attendance (Field8)
  • attend_check (Field9)
  • consult (Field10)
  • consult_check (Field11)
  • status (Field12)