self-online_day1
Tables (4)
ATTENDANCE (CopyOfUntitled)
- ACCOUNT — VARCHAR(20) — Foreign key → STUDENT.ACCOUNT — NOT NULL
- GROUP — VARCHAR(20) — Foreign key → STUDENT.GROUP — NOT NULL
- 1/1 — TINYINT(1)
- 1/1_SIGN_IN — DATETIME
- 1/1_SIGN_OUT — DATETIME — NOT NULL
- 1/2 — TINYINT(1)
- 1/2_SIGN_IN — DATETIME
- 1/2_SIGN_OUT — DATETIME
GRADE (CopyOfUntitled2)
- ACCOUNT — VARCHAR(20) — Foreign key → STUDENT.ACCOUNT — NOT NULL
- GROUP — VARCHAR(20) — Foreign key → STUDENT.GROUP — NOT NULL
- SECOND_EXAM — VARCHAR(3)
- THIRD_EXAM — VARCHAR(3)
- FIRST_EXAM — VARCHAR(3) — NOT NULL
- ALGORITHM_GRADE — VARCHAR(20)
- ALGORITHM_ACQUISITION_DATE — DATETIME
GROUP (Untitled2)
- GROUP — VARCHAR(20) — Primary key — NOT NULL
- TEACHER_NAME — VARCHAR(20)
- TEACHER_HP — VARCHAR(20)
- TEACHER_ID — VARCHAR(20) — NOT NULL
STUDENT (Untitled)
- ACCOUNT — VARCHAR(20) — Primary key — NOT NULL
- GROUP — VARCHAR(20) — Foreign key → GROUP.GROUP — NOT NULL
- NAME — VARCHAR(100)
- HP — VARCHAR(20)
- AGE — VARCAHR(5) — NOT NULL
- GENDER — VARCHAR(20)
- CURRICULUM — VARCHAR(20)
- REGION — VARCHAR(20)