DAY01
Tables (7)
Untitled (STUDENT)
- Key (STUDENT_ACCOUNT) — VARCHAR(20) — Primary key — NOT NULL
- Field (STUDENT_NAME) — VARCHAR(100) — NOT NULL
- Field (STUDENT_HP) — VARCHAR(20) — NOT NULL
- Field (STUDENT_AGE) — VARCHAR(5) — NOT NULL
- Field (STUDENT_GENDER) — VARCHAR(20) — NOT NULL
- Field (STUDENT_CURRICULUM) — VARCHAR(20) — NOT NULL
- Field (STUDENT_REGION) — VARCHAR(20) — NOT NULL
- Field (STUDENT_GROUP) — VARCHAR(20) — NOT NULL
- Key (GROUP_TEACHER_ID) — VARCHAR(20) — Foreign key → Untitled.Key — NOT NULL
Untitled (GROUP_INFO)
- Key (GROUP_TEACHER_ID) — VARCHAR(20) — Primary key — NOT NULL
- Field (GROUP_TEACHER_NAME) — VARCHAR(20)
- Field (GROUP_TEACHER_HP) — VARCHAR(20)
Untitled (GRADE)
- Key (STUDENT_ACCOUNT) — VARCHAR(20) — Foreign key → Untitled.Key — NOT NULL
- Key (GRADE_NUM) — VARCHAR(3) — NOT NULL
- Field (GRADE_SCORE) — VARCHAR(3)
Untitled (ALGORITHM)
- Key (STUDENT_ACCOUNT) — VARCHAR(20) — Foreign key → Untitled.Key — NOT NULL
- Field (ALGORITHM_GRADE) — VARCHAR(20)
- Field (ALGORITHM_ACQUISITION_DATE) — DATETIME
Untitled (ATTENDANCE)
- Key (STUDENT_ACCOUNT) — VARCHAR(20) — Foreign key → Untitled.Key — NOT NULL
- Field (ATTENDANCE_SIGN_IN) — DATETIME
- Field (ATTENDANCE_SIGN_OUT) — DATETIME
- Field (ATTENDANCE_DATE) — DATETIME
Untitled (STUDENT_INFO)
- Key (STUDENT_ACCOUNT) — VARCHAR(20) — Foreign key → Untitled.Key — NOT NULL
- Field (REG_USER) — VARCHAR(100)
- Field (REG_DT) — DATETIME
- Field (LAST_USER) — VARCHAR(20)
- Field (LAST_DT) — DATETIME
Untitled (PROJECT)
- Key (STUDENT_ACCOUNT) — VARCHAR(20) — Foreign key → Untitled.Key — NOT NULL
- Key (PROJECT_NAME) — VARCHAR(100) — NOT NULL
- Field (PROJECT_TEAM) — VARCHAR(3) — NOT NULL
- Field (PROJECT_SCORE) — VARCHAR(3)