200309_day01
Tables (5)
ATTENDANCE
- ATTENDANCE_DATE — datetime — Primary key
- ATTENDANCE_SIGN_IN — datetime
- ATTENDANCE_SIGN_OUT — datetime
- Field2 (ATTENDANCE_CHECK) — tinyint(1)
- STUDENT_ACCOUNT — varchar(20) — Foreign key → USER.STUDENT_ACCOUNT — NOT NULL
FIRST_PROJECT
- STUDENT_ACCOUNT — varchar(20) — Foreign key → USER.STUDENT_ACCOUNT — NOT NULL
- PROJECT_CLASS — integer — NOT NULL
- PROJECT_DOMAIN — varchar(20) — NOT NULL
- PROJECT_GROUP — integer — NOT NULL
- PROJECT_GRADE — integer
- PROJECT_TEACHER_ID — varchar(20) — NOT NULL
GRADE
- STUDENT_ACCOUNT — varchar(20) — Foreign key → USER.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
TEACHER
- TEACHER_ID — varchar(20) — Primary key — NOT NULL
- TEACHER_NAME — varchar(20) — NOT NULL
- TEACHER_HP — varchar(20)
- TEACHER_REGION — varchar(20) — NOT NULL
- TEACHER_GROUP — varchar(20) — NOT NULL
USER
- 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) — NOT NULL
- STUDENT_GROUP — varchar(20) — NOT NULL
- REG_USER — varchar(20)
- REG_DT — datetime
- LAST_USER — varchar(20)
- LAST_DT — datetime