self-online

Tables (12)

STUDENT

  • STUDENT_ID (STUDENT_ACCOUNT) — VARCHAR(20) — Primary key — NOT NULL
  • STUDENT_NAME — VARCHAR(100) — NOT NULL
  • STUDENT_HP — VARCHAR(20) — NOT NULL
  • STUDENT_AGE — INT — NOT NULL
  • STUDENT_GENDER — VARCHAR(20) — NOT NULL
  • STUDENT_CURRICULUM — VARCHAR(20) — NOT NULL
  • STUDENT_REG — VARCHAR(40) — NOT NULL
  • STUDENT_REG_DT — DATETIME — NOT NULL
  • STUDENT_LAST — VARCHAR(40) — NOT NULL
  • STUDENT_LAST_DT — DATETIME — NOT NULL
  • Field (ALGORITHM_GRADE) — VARCHAR(4) — NOT NULL
  • Field (ALGORITHM_ACQUISITION_DATE) — DATE
  • Key (GROUP_ID) — INT — Foreign key → Untitled.Key — NOT NULL

TEACHER

  • GROUP_TEACHER_ID (CLASS_TEACHER_ID) — VARCHAR(20) — Primary key — NOT NULL
  • GROUP_TEACHER_ACCOUNT (CLASS_TEACHER_HP) — VARCHAR(20) — NOT NULL
  • GROUP_TEACHER_NAME (CLASS_TEACHER_NAME) — VARCHAR(50) — NOT NULL
  • Key (CLASS_ID) — VARCHAR(10) — Foreign key → Untitled.Key — NOT NULL

Untitled (ATTENDANCE)

  • Key2 (DATE) — DATE — Primary key — NOT NULL
  • STUDENT_ID (STUDENT_ACCOUNT) — VARCHAR(20) — Foreign key → STUDENT.STUDENT_ID — NOT NULL
  • Field (SIGN_IN) — DATETIME — NOT NULL
  • Field (SIGN_OUT) — DATETIME — NOT NULL
  • Field (ATTENDANCE) — BOOLEAN — NOT NULL

Untitled (EXAM)

  • Key (EXAM_ID) — INT — Primary key — NOT NULL
  • Field (EXAM_TITLE) — VARCHAR(100) — NOT NULL

Untitled (GRADE_EXAM)

  • Key (EXAM_ID) — INT — Foreign key → Untitled.Key — NOT NULL
  • STUDENT_ID (STUDENT_ACCOUNT) — VARCHAR(50) — Foreign key → STUDENT.STUDENT_ID — NOT NULL
  • Field (EXAM_GRADE) — INT — NOT NULL

Untitled (PROJCET)

  • Key (PROJECT_ID) — INT — Primary key — NOT NULL
  • Field (PROJECT_NAME) — VARCHAR(50) — NOT NULL

Untitled (GRADE_PROJECT_INDIVISUAL)

  • Key (PROJECT_ID) — INT — Foreign key → Untitled.Key — NOT NULL
  • STUDENT_ID (STUDENT_ACCOUNT) — VARCHAR(50) — Foreign key → STUDENT.STUDENT_ID — NOT NULL
  • Field (PROJECT_GRADE) — INT — NOT NULL
  • Field (PEER_EVAL) — INT — NOT NULL
  • Field (PEER_EVAL_DES) — VARCHAR(255) — NOT NULL
  • Field (EVAL) — INT — NOT NULL
  • Field (EVAL_DES) — VARCHAR(255) — NOT NULL

Untitled (GRADE_PROJECT)

  • Key (PROJECT_ID) — INT — Foreign key → Untitled.Key — NOT NULL
  • Field (FEATURE_GRADE) — INT — NOT NULL
  • Field (UX_GRADE) — INT — NOT NULL
  • Field (PRGM_GRADE) — INT — NOT NULL

Untitled (CLASS)

  • Key (CLASS_ID) — VARCHAR(10) — Primary key — NOT NULL
  • Key (REGION_ID) — VARCHAR(20) — Foreign key → Untitled.Key — NOT NULL

Untitled (REGION)

  • Key (REGION_ID) — VARCHAR(20) — Primary key — NOT NULL

Untitled (GROUP)

  • Key (GROUP_ID) — VARCHAR(10) — Primary key — NOT NULL
  • Key (CLASS_ID) — VARCHAR(10) — Foreign key → Untitled.Key — NOT NULL

Untitled (STUDENTS_PROJECTS)

  • STUDENT_ID (STUDENT_ACCOUNT) — VARCHAR(20) — Foreign key → STUDENT.STUDENT_ID — NOT NULL
  • Key (PROJECT_ID) — INT — Foreign key → Untitled.Key — NOT NULL