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