self-online

Tables (10)

ATTENDANCE (Untitled8)

  • ATTENDANCE_ID — INT — Primary key — NOT NULL
  • ATTENDANCE_SIGNIN — DATE
  • ATTENDANCE_SIGNOUT — DATE
  • ATTENDANCED — INT

CURRICULUM (Untitled4)

  • CURRICULUM_NUM — INT — Primary key — NOT NULL

EXAM (Untitled5)

  • GRADE_EXAM_ID — INT — Primary key — NOT NULL
  • GRADE_EXAM_NAME — VARCHAR(20)
  • GRADE_EXAM_SCORE — INT

GROUP (Untitled3)

  • GROUP_NUM — INT — Primary key — NOT NULL

PROJECT_TEAM (Untitled2)

  • PROJECT_TEAM_ID — INT — Primary key — NOT NULL
  • PROJECT_TEAM_NAME (PROJECT_TEAM__NAME) — VARCHAR(30)
  • PROJECT_TEAM_GRADE — VARCHAR(10)

REGION (Untitled6)

  • REGION — VARCHAR(20) — Primary key — NOT NULL

STUDENT (Untitled)

  • STUDENT_ACCOUNT (Key) — VARCHAR(50) — Primary key — NOT NULL
  • STUDENT_NAME (Field) — VARCHAR(50)
  • STUDENT_HP (Field2) — VARCHAR(15)
  • STUDENT_AGE (Field3) — INT
  • STUDENT_GENDER (Field4) — VARCHAR(10)
  • ALGORITHM_GRADE (Field5) — VARCHAR(10)
  • ALGORITHM_ACQUISITION_DATE (Field6) — DATE
  • REG_USER (Field7) — VARCHAR(50)
  • REG_DT (Field8) — DATE
  • LAST_USER (Field9) — VARCHAR(50)
  • LAST_DT (Field10) — DATE
  • PROJECT_TEAM_ID (Key2) — INT — Foreign key → PROJECT_TEAM.PROJECT_TEAM_ID — NOT NULL
  • GROUP_NUM (Key3) — INT — Foreign key → GROUP.GROUP_NUM — NOT NULL
  • REGION (Key4) — VARCHAR(20) — Foreign key → REGION.REGION — NOT NULL
  • CURRICULUM_NUM (Key5) — INT — Foreign key → CURRICULUM.CURRICULUM_NUM — NOT NULL
  • TEACHER_ID (Key6) — Foreign key → TEACHER.TEACHER_ID — NOT NULL

STUDENT_ATTENDANCE_BRIDGE (Untitled10)

  • STUDENT_ACCOUNT (Key) — VARCHAR(50) — Foreign key → STUDENT.STUDENT_ACCOUNT — NOT NULL
  • ATTENDANCE_ID (Key2) — INT — Foreign key → ATTENDANCE.ATTENDANCE_ID — NOT NULL

STUDENT_EXAM_BRIDGE (Untitled9)

  • STUDENT_ACCOUNT — VARCHAR(50) — Foreign key → STUDENT.STUDENT_ACCOUNT — NOT NULL
  • GRADE_EXAM_ID — INT — Foreign key → EXAM.GRADE_EXAM_ID — NOT NULL

TEACHER (Untitled7)

  • TEACHER_ID — INT — Primary key — NOT NULL
  • TEACHER_NAME — VARCHAR(30) — NOT NULL
  • TEACHER_HP — VARCHAR(15)
  • GROUP_NUM (Key2) — Foreign key → GROUP.GROUP_NUM — NOT NULL
  • REGION (Key3) — Foreign key → REGION.REGION — NOT NULL
  • CURRICULUM_NUM (Key4) — Foreign key → CURRICULUM.CURRICULUM_NUM — NOT NULL