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