day1
Tables (7)
ATTENDANCE
- STUDENT_ACCOUNT — varchar(20) — Foreign key → student.STUDENT_ACCOUNT — NOT NULL
- number — int — NOT NULL
- attendance — tinyint(1)
- SIGN_IN — datetime
- SIGN_OUT — datetime
- REG_USER — varchar(20)
- REG_DT — datetime
- LAST_USER — varchar(20)
- LAST_DT — datetime
Algorithm
- STUDENT_ACCOUNT — varchar(20) — Foreign key → student.STUDENT_ACCOUNT — NOT NULL
- ALGORITHM_GRADE — varchar(20)
- ALGORITHM_ACQUISITION_DATE — datetime
- REG_USER — varchar(20)
- REG_DT — datetime
- LAST_USER — varchar(20)
- LAST_DT — datetime
Exam
- STUDENT_ACCOUNT — varchar(20) — Foreign key → student.STUDENT_ACCOUNT — NOT NULL
- GRADE_FIRST_EXAM — varchar(3)
- GRADE_SECOND_EXAM — varchar(3)
- GRADE_THIRD_EXAM — varchar(3)
- REG_USER — varchar(20)
- REG_DT — datetime
- LAST_USER — varchar(20)
- LAST_DT — datetime
Project
- project_name — varchar(20) — Primary key — NOT NULL
- kind — varchar(20)
- domain — varchar(20)
- grade — varchar(3)
- team_id — int — Foreign key → Team.team_id — NOT NULL
- class — int — Foreign key → Team.class — NOT NULL
Team
- team_id — int — Primary key — NOT NULL
- class — int — Primary key — NOT NULL
- role — varchar(20)
- STUDENT_ACCOUNT — varchar(20) — Foreign key → student.STUDENT_ACCOUNT — NOT NULL
student
- STUDENT_ACCOUNT — varchar(20) — Primary key — NOT NULL
- STUDENT_NAME — varchar(100) — NOT NULL
- STUDENT_HP — varchar(20)
- STUDENT_AGE — varchar(5)
- STUDENT_GENDER — varchar(20)
- STUDENT_CURRICULUM — varchar(20)
- STUDENT_REGION — varchar(20)
- STUDENT_GROUP — varchar(20) — NOT NULL
- REG_USER — varchar(20)
- REG_DT — datetime
- LAST_USER — varchar(20)
- LAST_DT — datetime
- GROUP_TEACHER_ID — varchar(20) — Foreign key → teacher.GROUP_TEACHER_ID — NOT NULL
teacher
- GROUP_TEACHER_ID — varchar(20) — Primary key — NOT NULL
- GROUP_TEACHER_NAME — varchar(20) — NOT NULL
- GROUP_TEACHER_HP — varchar(20) — NOT NULL
- REG_USER — varchar(20)
- REG_DT — datetime
- LAST_USER — varchar(20)
- LAST_DT — datetime