USER
Tables (5)
algorithm (Untitled4)
- id (Key) — not null — Primary key — NOT NULL
- STUDENT_ID (Key2) — not null — Foreign key → student.id — NOT NULL
- ALGORITHM_GRADE (Field) — default null
- ALGORITHM_ACQUISITION_DATE (Field2)
attendance (Untitled5)
- id (Key) — not null — Primary key — NOT NULL
- STUDENT_ID (Key2) — not null — Foreign key → student.id — NOT NULL
- ATTENDANCE (Field) — default null
- ATTENDANCE_SIGN_IN (Field2) — default null
- ATTENDANCE_SIGN_OUT (Field3) — default null
grade (Untitled2)
- id (Key) — not null — Primary key — NOT NULL
- STUDENT_ID (Key2) — not null — Foreign key → student.id — NOT NULL
- GRADE_FIRST_EXAM (Field) — default null
- GRADE_SECOND_EXAM (Field2) — default null
- GRADE_THIRD_EXAM (Field3) — default null
student (Untitled)
- id (Key) — not null — Primary key — NOT NULL
- teacher_id (Key2) — not null — Foreign key → teacher.id — NOT NULL
- STUDENT_ACCOUNT (Field) — not null
- STUDENT_NAME (Field2) — not null
- STUDENT_HP (Field3) — default null
- STUDENT_AGE (Field4) — default null
- STUDENT_GENDER (Field5) — default null
- STUDENT_CURRICULUM (Field6) — default null
- STUDENT_REGION (Field7) — default null
- STUDENT_GROUP (Field8) — not null
- REG_USER (Field9) — notnull
- REG_DT (Field10) — default null
- LAST_USER (Field11) — notnull
- LAST_DT (Field12) — default null
teacher (Untitled3)
- id (Key) — not null — Primary key — NOT NULL
- GROUP_TEACHER_ID (Field) — not null
- GROUP_TEACHER_NAME (Field2) — not null
- GROUP_TEACHER_HP (Field3) — not null