erp

Tables (6)

Attendances

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

Attitudes (Untitled2)

  • Attitude_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 (teacher_id) — 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

Students

  • Student_id (student_id) — INT — Primary key — NOT NULL
  • name (Field)
  • phone (Field2)
  • age (Field3)
  • gender (Field4)
  • addr (Field5)
  • phone2 (Field6)
  • attendance (Field11)
  • check (Field12)
  • consert (Field13)
  • stayters (Field14)
  • teach_id (teacher_id) — Foreign key → Teachers.teach_id — NOT NULL

Teachers

  • teach_id (teacher_id) — Primary key — NOT NULL
  • name
  • phone

Untitled (Classes)

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