test
Tables (9)
ATTENDANCE (Untitled6)
- ATTENDANCE_ID (Key) — VARCHAR(20) — Primary key — NOT NULL
- ATTENDACE_DATE (Field) — DATETIME
- ATTENDACE_SIGNIN (Field2) — DATETIME
- ATTENDANCE_SIGNOUT (Field3) — DATETIME
- Field4
CURRICULLUM (Untitled4)
- CURRI_ID (Key) — VARCHAR(20) — Primary key — NOT NULL
EXAM
- EXAM_ID (ID) — VARCHAR(20) — Primary key — NOT NULL
- FIRST_EXAM — VARCHAR(3)
- SECOND_EXAM — VARCHAR(3)
- THIRD_EXAM — VARCHAR(3)
GROUP (Untitled3)
- GROUP_ID (Key) — VARCPHAR(20) — Primary key — NOT NULL
PROJECT (Untitled)
- PROJECT_ID (Key) — VARCHAR(20) — Primary key — NOT NULL
- PROJECT_NAME (Field) — VARCHAR(20)
- PROJECT_GRADE (Field2) — VARCHAR(20)
REGION (Untitled5)
- REGION_ID (Key) — VARCHAR(20) — Primary key — NOT NULL
- REGION_NAME (Field) — VARCHAR(20)
STUDENT
- STUDENT_ACCOUNT (ACCOUNT) — VARCHAR(20) — Primary key — NOT NULL
- TEACHER_ID (ID) — VARCHAR(20) — Foreign key → TEACHER.TEACHER_ID — NOT NULL
- EXAM_ID (ID2) — VARCHAR(20) — Foreign key → EXAM.EXAM_ID — NOT NULL
- TEAM_ID (Key) — VARCHAR(20) — Foreign key → TEAM.TEAM_ID — NOT NULL
- PROJECT_ID (Key2) — VARCHAR(20) — Foreign key → TEAM.PROJECT_ID — NOT NULL
- GROUP_ID (Key3) — Foreign key → GROUP.GROUP_ID — NOT NULL
- CURRI_ID (Key4) — Foreign key → CURRICULLUM.CURRI_ID — NOT NULL
- REGION_ID (Key5) — VARCHAR(20) — Foreign key → REGION.REGION_ID — NOT NULL
- ATTENDANCE_ID (Key6) — VARCHAR(20) — Foreign key → ATTENDANCE.ATTENDANCE_ID — NOT NULL
- STUDENT_NAME (NAME) — VARCHAR(100)
- STUDENT_HP (HP) — VARCHAR(20)
- STUDENT_AGE (AGE) — VARCHAR(5)
- STUDENT_GENDER (GENDER) — VARCHAR(20)
- ALGORITHM_GRADE — VARCHAR(20)
- ALGORITHM_ACQUISITION_DATE — DATETIME
- REG_USER — VARCHAR(20)
- REG_DT (Field) — DATETIME
- LAST_USER (Field2) — VARCHAR(20)
- LAST_DT (Field3) — DATETIME
TEACHER
- TEACHER_ID (ID) — VARCHAR(20) — Primary key — NOT NULL
- TEACHER_NAME (NAME) — VARCHAR(20)
- TEACHER_HP (HP) — VARCHAR(20)
TEAM (Untitled2)
- TEAM_ID (Key) — VARCHAR(20) — Primary key — NOT NULL
- PROJECT_ID (Key2) — VARCHAR(20) — Foreign key → PROJECT.PROJECT_ID — NOT NULL
- TEAM_NAME (Field) — VARCHAR(20)