test

Tables (19)

ADMIN

  • ID (ADMIN_ID) — VARCHAR(20) — Foreign key → USER.ID — NOT NULL

ATTENDANCES

  • DAY_ID — VARCHAR(20) — Foreign key → ATTENDANCE_DAYS.DAY_ID — NOT NULL
  • ID (STUDENT_ID) — VARCHAR(20) — Foreign key → STUDENT.ID — NOT NULL
  • GROUP_NAME — VARCHAR(20) — Foreign key → STUDENT.GROUP_NAME — NOT NULL
  • SIGN_IN — DATETIME
  • SIGN_OUT — DATETIME
  • ATTENDANCE — TINYINT(1)

ATTENDANCE_DAYS

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

AUTHS

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

EXAM

  • EXAM_ID — VARCHAR(100) — Primary key — NOT NULL

EXAM_GRADE

  • EXAM_NAME — VARCHAR(100) — Foreign key → EXAM.EXAM_ID — NOT NULL
  • ID (STUDENT_ID) — VARCHAR(20) — Foreign key → STUDENT.ID — NOT NULL
  • GROUP_NAME — VARCHAR(20) — Foreign key → STUDENT.GROUP_NAME — NOT NULL
  • GRADE — VARCHAR(5)

GROUPS

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

GROUP_CATEGORY

  • GROUP_NAME — VARCHAR(20) — Primary key — NOT NULL
  • ID (TEACHER_ID) — VARCHAR(20) — Foreign key → TEACHER.ID — NOT NULL
  • REGION_ID — VARCHAR(20) — Foreign key → REGION.REGION_ID — NOT NULL
  • GROUP_ID — VARCHAR(20) — Foreign key → GROUPS.GROUP_ID — NOT NULL

LOG_IN_LOG

  • ID — VARCHAR(20) — Foreign key → USER.ID — NOT NULL
  • DATE — DATETIME

PARTICIPATION

  • TEAM_ID — VARCHAR(20) — Foreign key → TEAM.TEAM_ID — NOT NULL
  • ID (STUDENT_ID) — VARCHAR(20) — Foreign key → STUDENT.ID — NOT NULL
  • GROUP_NAME — VARCHAR(20) — Foreign key → STUDENT.GROUP_NAME — NOT NULL

PROJECT

  • PROJECT_ID — VARCHAR(20) — Primary key — NOT NULL
  • TEAM_ID — VARCHAR(20) — Foreign key → TEAM.TEAM_ID — NOT NULL
  • CATEGORY_ID — VARCHAR(20) — Foreign key → PROJECT_CATEGORY.CATEGORY_ID — NOT NULL

PROJECT_CATEGORY

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

PROJECT_GRADE

  • PROJECT_ID — VARCHAR(20) — Foreign key → PROJECT.PROJECT_ID — NOT NULL
  • GRADE — VARCHAR(20)

REG

  • ID (ADMIN_ID) — VARCHAR(20) — Foreign key → ADMIN.ID — NOT NULL
  • ID — VARCHAR(20) — Foreign key → USER.ID — NOT NULL
  • DATE — DATETIME

REGION

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

STUDENT

  • ID (STUDENT_ID) — VARCHAR(20) — Foreign key → USER.ID — NOT NULL
  • GROUP_NAME — VARCHAR(20) — Foreign key → GROUP_CATEGORY.GROUP_NAME — NOT NULL
  • AGE (STUDENT_AGE) — VARCHAR(5)
  • NAME (STUDENT_NAME) — VARCHAR(100)
  • HP (STUDENT_HP) — VARCHAR(20) — NOT NULL
  • GENDER (STUDENT_GENDER) — VARCHAR(20)
  • CURRICULUM (STUDENT_CURRICULUM) — VARCHAR(20)
  • REGION (STUDENT_REGION) — VARCHAR(20)
  • ALGORITHM_GRADE — VARCHAR(20)
  • ALGORITHM_ACQUISITION_DATE — VARCHAR(20)

TEACHER

  • ID (TEACHER_ID) — VARCHAR(20) — Foreign key → USER.ID — NOT NULL
  • NAME — VARCHAR(100)
  • HP — VARCHAR(20)

TEAM

  • TEAM_ID — VARCHAR(20) — Primary key — NOT NULL
  • NAME — VARCHAR(20)

USER

  • ID — VARCHAR(20) — Primary key — NOT NULL
  • AUTH — VARCHAR(20) — Foreign key → AUTHS.AUTH — NOT NULL