TEST
Tables (5)
Atendances (Untitled4)
- atendance_id (Key) — Primary key — NOT NULL
- check_in (Field2) — Datetime
- check_out (Field)
- check_status (Field3)
- student_id (Key2) — INT — Foreign key → students.student_id — NOT NULL
- teacher_id (Key3) — Foreign key → Teachers.teacher_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
- teacher_id (Key3) — Foreign key → Teachers.teacher_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
- teacher_id (Key3) — Foreign key → Teachers.teacher_id — NOT NULL
Teachers (Untitled3)
- teacher_id (Key) — Primary key — NOT NULL
- name (Field)
- phone (Field2)
- class (Field3)
students (sudent_table)
- student_id (Key) — INT — Primary key — NOT NULL
- name (Field) — varchar2
- phone (Field2)
- age (Field3)
- gender (Field4)
- addr (Field5)
- phone2 (Field6)
- consult (Field13)
- status (Field15)
- teacher_id (Key2) — Foreign key → Teachers.teacher_id — NOT NULL