self-online
Tables (10)
ATTENDANCE (Untitled8)
- ATTENDANCE_ID — INT — Primary key — NOT NULL
- ATTENDANCE_SIGNIN — DATE
- ATTENDANCE_SIGNOUT — DATE
- ATTENDANCED — INT
CURRICULUM (Untitled4)
- CURRICULUM_NUM — INT — Primary key — NOT NULL
EXAM (Untitled5)
- GRADE_EXAM_ID — INT — Primary key — NOT NULL
- GRADE_EXAM_NAME — VARCHAR(20)
- GRADE_EXAM_SCORE — INT
GROUP (Untitled3)
- GROUP_NUM — INT — Primary key — NOT NULL
PROJECT_TEAM (Untitled2)
- PROJECT_TEAM_ID — INT — Primary key — NOT NULL
- PROJECT_TEAM_NAME (PROJECT_TEAM__NAME) — VARCHAR(30)
- PROJECT_TEAM_GRADE — VARCHAR(10)
REGION (Untitled6)
- REGION — VARCHAR(20) — Primary key — NOT NULL
STUDENT (Untitled)
- STUDENT_ACCOUNT (Key) — VARCHAR(50) — Primary key — NOT NULL
- STUDENT_NAME (Field) — VARCHAR(50)
- STUDENT_HP (Field2) — VARCHAR(15)
- STUDENT_AGE (Field3) — INT
- STUDENT_GENDER (Field4) — VARCHAR(10)
- ALGORITHM_GRADE (Field5) — VARCHAR(10)
- ALGORITHM_ACQUISITION_DATE (Field6) — DATE
- REG_USER (Field7) — VARCHAR(50)
- REG_DT (Field8) — DATE
- LAST_USER (Field9) — VARCHAR(50)
- LAST_DT (Field10) — DATE
- PROJECT_TEAM_ID (Key2) — INT — Foreign key → PROJECT_TEAM.PROJECT_TEAM_ID — NOT NULL
- GROUP_NUM (Key3) — INT — Foreign key → GROUP.GROUP_NUM — NOT NULL
- REGION (Key4) — VARCHAR(20) — Foreign key → REGION.REGION — NOT NULL
- CURRICULUM_NUM (Key5) — INT — Foreign key → CURRICULUM.CURRICULUM_NUM — NOT NULL
- TEACHER_ID (Key6) — Foreign key → TEACHER.TEACHER_ID — NOT NULL
STUDENT_ATTENDANCE_BRIDGE (Untitled10)
- STUDENT_ACCOUNT (Key) — VARCHAR(50) — Foreign key → STUDENT.STUDENT_ACCOUNT — NOT NULL
- ATTENDANCE_ID (Key2) — INT — Foreign key → ATTENDANCE.ATTENDANCE_ID — NOT NULL
STUDENT_EXAM_BRIDGE (Untitled9)
- STUDENT_ACCOUNT — VARCHAR(50) — Foreign key → STUDENT.STUDENT_ACCOUNT — NOT NULL
- GRADE_EXAM_ID — INT — Foreign key → EXAM.GRADE_EXAM_ID — NOT NULL
TEACHER (Untitled7)
- TEACHER_ID — INT — Primary key — NOT NULL
- TEACHER_NAME — VARCHAR(30) — NOT NULL
- TEACHER_HP — VARCHAR(15)
- GROUP_NUM (Key2) — Foreign key → GROUP.GROUP_NUM — NOT NULL
- REGION (Key3) — Foreign key → REGION.REGION — NOT NULL
- CURRICULUM_NUM (Key4) — Foreign key → CURRICULUM.CURRICULUM_NUM — NOT NULL