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