day_01
Tables (5)
ATTENDANCE
- ATTENDANCE_PK — Primary key — NOT NULL
- STUDENT_PK2 — INT — Foreign key → STUDENT_DETAIL.STUDENT_PK — NOT NULL
- REGION_PK2 — INT — Foreign key → STUDENT_DETAIL.REGION_PK2 — NOT NULL
- ATTENDANCE_SIGN_IN (Field8) — datetime
- ATTENDANCE_SIGN_OUT (Field9) — datetime
CURRI_PK (CURRICULUM)
- REGION_PK — INT — Foreign key → REGION.REGION_PK — NOT NULL
- CURRICULUM_PK — INT
GROUP_PK (GROUP)
- REGION_PK — INT — Foreign key → CURRI_PK.REGION_PK — NOT NULL
- Field (GROUP_PK) — INT
REGION
- REGION_PK — INT — Primary key — NOT NULL
- TEACHER_ID — varchar(20)
- TEACHER_NAME — CHAR(20)
- TEACHER_HP — CHAR(20)
STUDENT_DETAIL (STUDENT)
- STUDENT_PK — INT — Primary key — NOT NULL
- REGION_PK2 — INT — Foreign key → GROUP_PK.REGION_PK — NOT NULL
- ACCOUNT (Field) — CHAR(20)
- NAME (Field2) — CHAR(100)
- HP (Field3) — CHAR(20)
- AGE (Field4) — CHAR(5)
- GENDER (Field5) — CHAR(20)
- GRADE_FIRST_EXAM (Field6) — INT
- GRADE_SECOND_EXAM (Field7) — INT
- GRADE_THIRD_EXAM (Field8) — INT
- ALGORITHM_GRADE (Field10) — CHAR(20)
- ALGORITHM_ACQUISITION_DATE (Field9) — DATETIME
- REG_USER (Field11) — CHAR(20)
- LAST_USER (Field12) — CHAR(20)
- REG_DT (Field13) — DATETIME
- LAST_DT (Field14) — DATETIME