erp

Tables (5)

Attendances (Untitled4)

  • 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

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
  • teach_id (Key4) — Foreign key → Teachers.teach_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
  • 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)
  • consult_check (Field14)
  • status (Field15)
  • teach_id (Key2) — Foreign key → Teachers.teach_id — NOT NULL

Teachers (Untitled3)

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