erp

Tables (5)

Attendances

  • attend_id — Primary key — NOT NULL
  • check_in
  • check_out
  • status
  • teach_id — Foreign key → Teachers.teach_id — NOT NULL
  • student_id — INT — Foreign key → Students.student_id — NOT NULL

Attitudes

  • attitude_id — Primary key — NOT NULL
  • attitude_desc
  • attitude_date
  • student_id — INT — Foreign key → Students.student_id — NOT NULL
  • teach_id — Foreign key → Teachers.teach_id — NOT NULL

Reports

  • report_id — Primary key — NOT NULL
  • score
  • subject
  • student_id — INT — Foreign key → Students.student_id — NOT NULL
  • teach_id — Foreign key → Teachers.teach_id — NOT NULL

Students (학생)

  • student_id — INT — Primary key — NOT NULL
  • name
  • phone
  • age
  • gender
  • addr
  • phone2
  • consult
  • status
  • teach_id — Foreign key → Teachers.teach_id — NOT NULL

Teachers

  • teach_id — Primary key — NOT NULL
  • name
  • phone
  • class