과제1
테이블 (5)
ATTENDANCE (Untitled2)
- STUDENT_ACCOUNT (Key2) — varchar — 외래 키 → STUDENT.STUDENT_ACCOUNT — NOT NULL
- DATE (Key) — varchar(20) — 외래 키 → Date.DATE — NOT NULL
- ATTENDANCE (Field) — boolean
- ATTENDANCE_SIGN_IN (Field2) — varchar(50)
- ATTENDANCE_SIGN_OUT (Field3) — varchar(50)
Date (Untitled4)
- DATE (Key) — varchar(20) — 기본 키 — NOT NULL
GRADE (Untitled3)
- STUDENT_ACCOUNT (Key3) — varchar — 외래 키 → STUDENT.STUDENT_ACCOUNT — NOT NULL
- GRADE_FIRST_EXAM (N) — varchar
- GRADE_SECOND_EXAM (Field2) — varchar
- GRADE_THIRD_EXAM (Field3) — varchar
- ALGORITHM_GRADE (Field) — varchar
- GRADE_PROJECT (Field4) — varchar
- Field5
REGION (group)
- STUDENT_REGION (Key) — varchar — 기본 키 — NOT NULL
- GROUP_TEACHER_ID (Field) — varchar
- GROUP_TEACHER_NAME (Field2) — varchar
- GROUP_TEACHER_HP (Field3) — varchar
STUDENT (Untitled)
- STUDENT_ACCOUNT (Key) — varchar — 기본 키 — NOT NULL
- STUDENT_NAME (Field2) — varchar
- STUDENT_HP (Field3) — varchar
- STUDENT_AGE (Field4) — varchar
- STUDENT_GENDER (Field5) — varchar
- STUDENT_CURRICULUM (Field6) — varchar
- STUDENT_GROUP (Field) — varchar
- Field8
- STUDENT_REGION (Key3) — varchar — 외래 키 → REGION.STUDENT_REGION — NOT NULL