test

Tables (9)

ATTENDANCE (Untitled6)

  • ATTENDANCE_ID (Key) — VARCHAR(20) — Primary key — NOT NULL
  • ATTENDACE_DATE (Field) — DATETIME
  • ATTENDACE_SIGNIN (Field2) — DATETIME
  • ATTENDANCE_SIGNOUT (Field3) — DATETIME
  • Field4

CURRICULLUM (Untitled4)

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

EXAM

  • EXAM_ID (ID) — VARCHAR(20) — Primary key — NOT NULL
  • FIRST_EXAM — VARCHAR(3)
  • SECOND_EXAM — VARCHAR(3)
  • THIRD_EXAM — VARCHAR(3)

GROUP (Untitled3)

  • GROUP_ID (Key) — VARCPHAR(20) — Primary key — NOT NULL

PROJECT (Untitled)

  • PROJECT_ID (Key) — VARCHAR(20) — Primary key — NOT NULL
  • PROJECT_NAME (Field) — VARCHAR(20)
  • PROJECT_GRADE (Field2) — VARCHAR(20)

REGION (Untitled5)

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

STUDENT

  • STUDENT_ACCOUNT (ACCOUNT) — VARCHAR(20) — Primary key — NOT NULL
  • TEACHER_ID (ID) — VARCHAR(20) — Foreign key → TEACHER.TEACHER_ID — NOT NULL
  • EXAM_ID (ID2) — VARCHAR(20) — Foreign key → EXAM.EXAM_ID — NOT NULL
  • TEAM_ID (Key) — VARCHAR(20) — Foreign key → TEAM.TEAM_ID — NOT NULL
  • PROJECT_ID (Key2) — VARCHAR(20) — Foreign key → TEAM.PROJECT_ID — NOT NULL
  • GROUP_ID (Key3) — Foreign key → GROUP.GROUP_ID — NOT NULL
  • CURRI_ID (Key4) — Foreign key → CURRICULLUM.CURRI_ID — NOT NULL
  • REGION_ID (Key5) — VARCHAR(20) — Foreign key → REGION.REGION_ID — NOT NULL
  • ATTENDANCE_ID (Key6) — VARCHAR(20) — Foreign key → ATTENDANCE.ATTENDANCE_ID — NOT NULL
  • STUDENT_NAME (NAME) — VARCHAR(100)
  • STUDENT_HP (HP) — VARCHAR(20)
  • STUDENT_AGE (AGE) — VARCHAR(5)
  • STUDENT_GENDER (GENDER) — VARCHAR(20)
  • ALGORITHM_GRADE — VARCHAR(20)
  • ALGORITHM_ACQUISITION_DATE — DATETIME
  • REG_USER — VARCHAR(20)
  • REG_DT (Field) — DATETIME
  • LAST_USER (Field2) — VARCHAR(20)
  • LAST_DT (Field3) — DATETIME

TEACHER

  • TEACHER_ID (ID) — VARCHAR(20) — Primary key — NOT NULL
  • TEACHER_NAME (NAME) — VARCHAR(20)
  • TEACHER_HP (HP) — VARCHAR(20)

TEAM (Untitled2)

  • TEAM_ID (Key) — VARCHAR(20) — Primary key — NOT NULL
  • PROJECT_ID (Key2) — VARCHAR(20) — Foreign key → PROJECT.PROJECT_ID — NOT NULL
  • TEAM_NAME (Field) — VARCHAR(20)