test
Tables (7)
ALGORITHM
- GRADE — VARCHAR(3) — Primary key — NOT NULL
- ACQUISITION_DATE — DATETIME
ATTENDANCE
- DATE — DATETIME — Primary key — NOT NULL
- SIGN_IN — DATETIME
- SIGH_OUT — DATETIME
EXAM_GRADE
- ACCOUNT — VARCHAR(20) — Foreign key → STUDENT.ACCOUNT — NOT NULL
- FIRST_EXAM — VARCHAR(3)
- SECOND_EXAM — VARCHAR(3)
- THIRD_EXAM — VARCHAR(3)
GROUP_TEACHER
- ID — VARCHAR(20) — Primary key — NOT NULL
- NAME — VARCHAR(20)
- HP — VARCHAR(20)
REGION
- ID — INT — Primary key — NOT NULL
- NAME — VARCHAR(20)
- TEACHER_ID — VARCHAR(20) — Foreign key → GROUP_TEACHER.ID — NOT NULL
STUDENT
- ACCOUNT — VARCHAR(20) — Primary key — NOT NULL
- NAME — VARCHAR(100)
- HP — VARCHAR(20)
- AGE — VARCHAR(5)
- GENDER — VARCHAR(20)
- CURRICULUM — VARCHAR(20)
- REGION_ID — INT — Foreign key → REGION.ID — NOT NULL
- ALGORITHM_GRADE — VARCHAR(3) — Foreign key → ALGORITHM.GRADE — NOT NULL
- REG_USER — VARCHAR(20)
- REG_DT — DATETIME
- LAST_USER — VARCHAR(20)
- LAST_DT — DATETIME
STUDENT_ATTEND
- ACCOUNT — VARCHAR(20) — Foreign key → STUDENT.ACCOUNT — NOT NULL
- DATE — DATETIME — Foreign key → ATTENDANCE.DATE — NOT NULL