db
Tables (5)
Attendance
- ATTENDANCE_PK — INT — Primary key
- STUDENT_PK — INTEGER — Foreign key → Student.STUDENT_PK
- ATTENDANCE — VARCHAR(20)
- ATTENDANCE_DATE — DATE
- ATTENDANCE_SIGN_IN — TIME
- ATTENDANCE_SIGN_OFF — TIME
- STUDENT_PK (STUDENT_PK2) — INT — Foreign key → Student.STUDENT_PK
Exam
- EXAM_PK — INT — Primary key
- STUDENT_PK — INTEGER — Foreign key → Student.STUDENT_PK
- TEST_SCORE — INTEGER
- TEST_ORDER — INTEGER
- STUDENT_PK (STUDENT_PK2) — INT — Foreign key → Student.STUDENT_PK
Project
- PROJECT — INT — Primary key
- STUDENT_PK — INTEGER — Foreign key → Student.STUDENT_PK
- PROJECT_SCORE — INTEGER
- PROJECT_ORDER — INTEGER
- STUDENT_PK (STUDENT_PK2) — INT — Foreign key → Student.STUDENT_PK
Student
- STUDENT_PK — INT — Primary key
- STUDENT_EMAIL — VARCHAR(50) — NOT NULL
- STUDENT_NAME — VARCHAR(6) — NOT NULL
- STUDENT_GENDER — VARCHAR(20)
- STUDENT_HP — VARCHAR(20)
- STUDENT_AGE — varchar(5)
- STUDENT_CURRICULUM — VARCHAR(20)
- STUDENT_REGION — VARCHAR(20)
- STUDENT_GROUP — VARCHAR(20)
- TEACHER_PK — INTEGER
- ALGORITHM_GRADE — VARCHAR(20)
- ALGORITHM_ACQUISITION_DATE — datetime
Teacher
- STUDENT_PK — INT — Foreign key → Student.STUDENT_PK
- TEACHER_PK — INT
- TEACHER_NAME — VARCHAR(20) — NOT NULL
- TEACHER_HP — VARCHAR(20) — NOT NULL