test
Tables (11)
ALGORITHM
- ALGORITHM ID (ALGORITHM_ID) — int(11) — Primary key — NOT NULL
- STUDENT ID (STUDENT_ID) — int(11) — Foreign key → STUDENT.STUDENT ID — NOT NULL
- ALGORITHM GRADE (ALGORITHM_GRADE) — varchar(20)
- ALGORITHM ACQUISITION DATE (ALGORITHM_ACQUISITION_DATE) — datetime
ATTENDANCE DATE (ATTENDANCE)
- ATTENDANCE DATE (ATTENDANCE_DATE) — date — Primary key — NOT NULL
- STUDENT ID (STUDENT_ID) — int(11) — Foreign key → STUDENT.STUDENT ID — NOT NULL
- ATTENDANCE — tinyint(1)
- ATTENDANCE SIGN IN (ATTENDANCE_SIGN_IN) — datetime
- ATTENDANCE SIGN OUT (ATTENDANCE_SIGN_OUT) — datetime
GRADE
- GRADE ID (GRADE_ID) — int(11) — Primary key — NOT NULL
- STUDENT ID (STUDENT_ID) — int(11) — Foreign key → STUDENT.STUDENT ID — NOT NULL
- GRADE FIRST EXAM (GRADE_FIRST_EXAM) — varchar(3)
- GRADE SECOND EXAM (GRADE_SECOND_EXAM) — varchar(3)
- GRADE THIRD EXAM (GRADE_THIRD_EXAM) — varchar(3)
GROUP TEACHER (GROUP_TEACHER)
- Key (GROUP_TEACHER_ID) — int(11) — Primary key — NOT NULL
- Key (CLASS_ID) — int(11) — Foreign key → STUDENT_GROUP.Key — NOT NULL
- GROUP TEACHER ACCOUNT (GROUP_TEACHER_ACCOUNT) — varchar(20)
- GROUP TEACHER NAME (GROUP_TEACHER_NAME) — varchar(20) — NOT NULL
- GROUP TEACHER HP (GROUP_TEACHER_HP) — varchar(20) — NOT NULL
LAST
- LAST ID (LAST_ID) — int(11) — Primary key — NOT NULL
- STUDENT ID (STUDENT_ID) — int(11) — Foreign key → STUDENT.STUDENT ID — NOT NULL
- LAST USER (LAST_USER) — varchar(20)
- LAST DT (LAST_DT) — datetime
PROJECT
- PROJECT ID (PROJECT_ID) — int(11) — Primary key — NOT NULL
- PROJECT NAME (PROJECT_NAME) — varchar(100) — NOT NULL
- PROJECT DOMAIN (PROJECT_DOMAIN) — varchar(20) — NOT NULL
- PROJECT DATE (PROJECT_DATE) — datetime
- PROJECT GRADE (PROJECT_GRADE) — varchar(3)
REG
- REG ID (REG_ID) — int(11) — Primary key — NOT NULL
- STUDENT ID (STUDENT_ID) — int(11) — Foreign key → STUDENT.STUDENT ID — NOT NULL
- REG USER (REG_USER) — varchar(20)
- REG DT (REG_DT) — datetime
STUDENT
- STUDENT ID (STUDENT_ID) — int(11) — Primary key — NOT NULL
- STUDENT ACCOUNT (STUDENT_ACCOUNT) — varchar(20) — NOT NULL
- STUDENT NAME (STUDENT_NAME) — varchar(100) — NOT NULL
- STUDENT HP (STUDENT_HP) — varchar(20) — NOT NULL
- STUDENT AGE (STUDENT_AGE) — varchar(5) — NOT NULL
- STUDENT GENDER (STUDENT_GENDER) — varchar(5) — NOT NULL
- Key (CLASS_ID) — int(11) — Foreign key → STUDENT_GROUP.Key — NOT NULL
STUDENT_GROUP (CLASS)
- Key (CLASS_ID) — int(11) — Primary key — NOT NULL
- Field (STUDENT_REGION) — varchar(20) — NOT NULL
- Field (STUDENT_GROUP) — varchar(5) — NOT NULL
- Field (STUDENT_CURRICULUM) — varchar(5) — NOT NULL
TEAM
- TEAM ID (TEAM_ID) — int(11) — Primary key — NOT NULL
- PROJECT ID (PROJECT_ID) — int(11) — Foreign key → PROJECT.PROJECT ID — NOT NULL
- TEAM NAME (TEAM_NAME) — varchar(20) — NOT NULL
Untitled (TEAM_MEMBER)
- TEAM ID (TEAM_ID) — int(11) — Foreign key → TEAM.TEAM ID — NOT NULL
- STUDENT ID (STUDENT_ID) — int(11) — Foreign key → STUDENT.STUDENT ID — NOT NULL
- PROJECT ID (PROJECT_ID) — int(11) — Foreign key → TEAM.PROJECT ID — NOT NULL