self-online
Tables (12)
STUDENT
- STUDENT_ID (STUDENT_ACCOUNT) — VARCHAR(20) — Primary key — NOT NULL
- STUDENT_NAME — VARCHAR(100) — NOT NULL
- STUDENT_HP — VARCHAR(20) — NOT NULL
- STUDENT_AGE — INT — NOT NULL
- STUDENT_GENDER — VARCHAR(20) — NOT NULL
- STUDENT_CURRICULUM — VARCHAR(20) — NOT NULL
- STUDENT_REG — VARCHAR(40) — NOT NULL
- STUDENT_REG_DT — DATETIME — NOT NULL
- STUDENT_LAST — VARCHAR(40) — NOT NULL
- STUDENT_LAST_DT — DATETIME — NOT NULL
- Field (ALGORITHM_GRADE) — VARCHAR(4) — NOT NULL
- Field (ALGORITHM_ACQUISITION_DATE) — DATE
- Key (GROUP_ID) — INT — Foreign key → Untitled.Key — NOT NULL
TEACHER
- GROUP_TEACHER_ID (CLASS_TEACHER_ID) — VARCHAR(20) — Primary key — NOT NULL
- GROUP_TEACHER_ACCOUNT (CLASS_TEACHER_HP) — VARCHAR(20) — NOT NULL
- GROUP_TEACHER_NAME (CLASS_TEACHER_NAME) — VARCHAR(50) — NOT NULL
- Key (CLASS_ID) — VARCHAR(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (ATTENDANCE)
- Key2 (DATE) — DATE — Primary key — NOT NULL
- STUDENT_ID (STUDENT_ACCOUNT) — VARCHAR(20) — Foreign key → STUDENT.STUDENT_ID — NOT NULL
- Field (SIGN_IN) — DATETIME — NOT NULL
- Field (SIGN_OUT) — DATETIME — NOT NULL
- Field (ATTENDANCE) — BOOLEAN — NOT NULL
Untitled (EXAM)
- Key (EXAM_ID) — INT — Primary key — NOT NULL
- Field (EXAM_TITLE) — VARCHAR(100) — NOT NULL
Untitled (GRADE_EXAM)
- Key (EXAM_ID) — INT — Foreign key → Untitled.Key — NOT NULL
- STUDENT_ID (STUDENT_ACCOUNT) — VARCHAR(50) — Foreign key → STUDENT.STUDENT_ID — NOT NULL
- Field (EXAM_GRADE) — INT — NOT NULL
Untitled (PROJCET)
- Key (PROJECT_ID) — INT — Primary key — NOT NULL
- Field (PROJECT_NAME) — VARCHAR(50) — NOT NULL
Untitled (GRADE_PROJECT_INDIVISUAL)
- Key (PROJECT_ID) — INT — Foreign key → Untitled.Key — NOT NULL
- STUDENT_ID (STUDENT_ACCOUNT) — VARCHAR(50) — Foreign key → STUDENT.STUDENT_ID — NOT NULL
- Field (PROJECT_GRADE) — INT — NOT NULL
- Field (PEER_EVAL) — INT — NOT NULL
- Field (PEER_EVAL_DES) — VARCHAR(255) — NOT NULL
- Field (EVAL) — INT — NOT NULL
- Field (EVAL_DES) — VARCHAR(255) — NOT NULL
Untitled (GRADE_PROJECT)
- Key (PROJECT_ID) — INT — Foreign key → Untitled.Key — NOT NULL
- Field (FEATURE_GRADE) — INT — NOT NULL
- Field (UX_GRADE) — INT — NOT NULL
- Field (PRGM_GRADE) — INT — NOT NULL
Untitled (CLASS)
- Key (CLASS_ID) — VARCHAR(10) — Primary key — NOT NULL
- Key (REGION_ID) — VARCHAR(20) — Foreign key → Untitled.Key — NOT NULL
Untitled (REGION)
- Key (REGION_ID) — VARCHAR(20) — Primary key — NOT NULL
Untitled (GROUP)
- Key (GROUP_ID) — VARCHAR(10) — Primary key — NOT NULL
- Key (CLASS_ID) — VARCHAR(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (STUDENTS_PROJECTS)
- STUDENT_ID (STUDENT_ACCOUNT) — VARCHAR(20) — Foreign key → STUDENT.STUDENT_ID — NOT NULL
- Key (PROJECT_ID) — INT — Foreign key → Untitled.Key — NOT NULL