erp
Tables (7)
Attendances (Untitled2)
- attend_id (Key) — Primary key — NOT NULL
- check_in (Field)
- check_out (Field2)
- status (Field3)
- student_code (student_id) — INT — Foreign key → Students.student_code — NOT NULL
- teach_id (Key2) — Foreign key → Teachers.teach_id — NOT NULL
Attitudes
- attitude_id (Key) — Primary key — NOT NULL
- attitude_desc (Field)
- attitude_date (Field2)
- student_id (Field3)
- student_code (student_id) — INT — Foreign key → Students.student_code — NOT NULL
- teach_id (Key2) — Foreign key → Teachers.teach_id — NOT NULL
Classes (Untitled3)
- class_id (Key) — Primary key — NOT NULL
- name (Field)
- position (Field2)
Reports
- report_id — Primary key — NOT NULL
- score
- subject
- student_code (student_id) — INT — Foreign key → Students.student_code — NOT NULL
- teach_id (Key) — Foreign key → Teachers.teach_id — NOT NULL
Students
- student_code (student_id) — INT — Primary key — NOT NULL
- name (Field)
- phone (Field2)
- age (Field3)
- gender (Field4)
- addr (Field5)
- phone2 (Field6)
- attitude (Field7)
- score (Field8)
- subject (Field9)
- teacher (Field10)
- attendance (Field11)
- attend_check (Field12)
- consult (Field13)
- consult_check (Field14)
- status (Field15)
- class_id (Key) — Foreign key → Classes.class_id — NOT NULL
- teach_id (Key2) — Foreign key → Teachers.teach_id — NOT NULL
Teachers (Untitled)
- teach_id (Key) — Primary key — NOT NULL
- name (Field)
- phone (Field2)