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