self_online1
Tables (6)
January_Date
- STUDENT_ACCOUNT — varchar(20) — Foreign key → student.STUDENT_ACCOUNT — NOT NULL
- date — 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
Level
- 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)
- ALGORITHM_GRADE — varchar(20)
- ALGORITHM_ACQUISITION_DATE — datetime
- REG_USER — varchar(20)
- REG_DT — datetime
- LAST_USER — varchar(20)
- LAST_DT — datetime
Team
- TEAM_ID (team_id) — int — Primary key — NOT NULL
- TEAM_CLASS (team_class) — int — Primary key — NOT NULL
- TEAM_ROLE (team_role) — varchar(20)
- STUDENT_ACCOUNT — varchar(20) — Foreign key → student.STUDENT_ACCOUNT — NOT NULL
group_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
project
- PROJECT_ID (project_id) — varchar(20) — Primary key — NOT NULL
- PROJECT_KIND (project_kind) — varchar(20)
- PROJECT_DOMAIN (project_domain) — varchar(20)
- PROJECT_GRADE (project_grade) — varchar(3)
- Field
- TEAM_ID (team_id) — int — Foreign key → Team.TEAM_ID — NOT NULL
- TEAM_CLASS (team_class) — int — Foreign key → Team.TEAM_CLASS — 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 → group_teacher.GROUP_TEACHER_ID — NOT NULL
- Field