day1
Tables (7)
ALGORITHM (Untitled4)
- STUDENT_ID (STUDENT_ID2) — INT — Foreign key → STUDENT.STUDENT_ID — NOT NULL
- GRADE — VARCHAR(20)
- ACQUISITION_DATE — DATETIME
ATTENDANCE (Untitled5)
- STUDENT_ID (STUDENT_ID2) — INT — Foreign key → STUDENT.STUDENT_ID — NOT NULL
- DAY — VARCHAR(20)
- CHECK — TINYINT(1)
- SIGN_IN — DATETIME
- SIGN_OUT — DATETIME
GRADE (Untitled3)
- STUDENT_ID (STUDENT_ID2) — INT — Foreign key → STUDENT.STUDENT_ID — NOT NULL
- FIRST_EXAM — INT
- SECOND_EXAM — INT
- THIRD_EXAM — INT
- FIRST_PROJECT — INT
REG (Untitled6)
- STUDENT_ID (STUDENT_ID2) — INT — Foreign key → STUDENT.STUDENT_ID — NOT NULL
- REG_USER — VARCHAR(20)
- REG_DT — DATETIME
- LAST_USER — VARCHAR(20)
- LAST_DT — DATETIME
STUDENT (Untitled)
- STUDENT_ID — INT — Primary key — NOT NULL
- ACCOUNT — VARCHAR(20)
- NAME — VARCHAR(100)
- HP — VARCHAR(20)
- AGE — INT
- GENDER — VARCHAR(20)
- CURRICULUM — INT
- REGION — VARCHAR(20)
- GROUP — INT
- TEAM_ID — INT — Foreign key → TEAM.TEAM_ID — NOT NULL
- TEACHER_ID — INT — Foreign key → TEACHER.TEACHER_ID — NOT NULL
TEACHER (Untitled2)
- TEACHER_ID — INT — Primary key — NOT NULL
- ACCOUNT — VARCHAR(20)
- NAME — VARCHAR(20)
- HP — VARCHAR(20)
TEAM (Untitled7)
- TEAM_ID — INT — Primary key — NOT NULL
- TITLE — VARCHAR(20)