DB_Project

Tables (8)

ALGORITHM

  • ALGORITHM_ID — INT(11) — Primary key — NOT NULL
  • ALGORITHM_ACQUISITION_DATE — DATETIME
  • ALGORITHM_GRADE — VARCHAR(20)
  • STUDENT_ID (STUDENT_ID2) — INT(11) — Foreign key → STUDENT.STUDENT_ID — NOT NULL

ATTENDANCE

  • ATTENDANCE_DATE — DATE — Primary key — NOT NULL
  • STUDENT_ID — INT(11) — Foreign key → STUDENT.STUDENT_ID — NOT NULL
  • ATTENDANCE — BOOLEAN
  • SIGN_IN — DATETIME
  • SIGN_OUT — DATETIME

GRADE

  • GRADE_ID — INT(11) — Primary key — NOT NULL
  • SCORE — INT(11)
  • SEQUENCE — INT(11)
  • STUDENT_ID — INT(11) — Foreign key → STUDENT.STUDENT_ID — NOT NULL

GROUP_TEACHER

  • TEACHER_ID — VARCHAR(20) — Primary key — NOT NULL
  • TEACHER_NAME — VARCHAR(100)
  • TEACHER_HP — VARCHAR(20)

PROJECT

  • PROJECT_ID — INT(11) — Primary key — NOT NULL
  • DOMAIN — VARCHAR(100)
  • DESCRIPTION — LONGTEXT
  • SEQUENCE — INT(11)

PROJECT_SCORE

  • PROJECT_ID — INT(11) — Foreign key → PROJECT_TEAM.PROJECT_TEAM_ID — NOT NULL
  • STUDENT_ID — INT(11) — Foreign key → STUDENT.STUDENT_ID — NOT NULL
  • PROJECT_SCORE (PROJCET_SCORE) — INT(11)

PROJECT_TEAM

  • PROJECT_TEAM_ID — INT(11) — Primary key — NOT NULL
  • TEAM_NAME — VARCHAR(100)
  • PROJECT_ID — INT(11) — Foreign key → PROJECT.PROJECT_ID — NOT NULL

STUDENT

  • STUDENT_ID — INT(11) — Primary key — NOT NULL
  • ACCOUNT — VARCHAR(20) — NOT NULL
  • NAME — VARCHAR(100) — NOT NULL
  • HP — VARCHAR(20)
  • AGE — VARCHAR(5)
  • GENDER — VARCHAR(20)
  • CURRICULUM — VARCHAR(20)
  • REGION — VARCHAR(20)
  • REG_USER — VARCHAR(20)
  • REG_DT — DATETIME
  • LAST_USER — VARCHAR(20)
  • LAST_DT — DATETIME
  • PROJECT_TEAM_ID — INT(11) — Foreign key → PROJECT_TEAM.PROJECT_TEAM_ID — NOT NULL
  • TEACHER_ID (TEACHER_ID2) — VARCHAR(20) — Foreign key → GROUP_TEACHER.TEACHER_ID — NOT NULL