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