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