대전_2반_서현택_Day01_DB프로젝트
테이블 (4)
Untitled (STUDENT)
- Key (STUDENT_ACCOUNT) — 기본 키 — NOT NULL
- Key (STUDENT_REGION) — 외래 키 → Untitled.Key — NOT NULL
- Field (STUDENT_NAME)
- Field (STUDENT_HP)
- Field (STUDENT_AGE)
- Field (STUDENT_GENDER)
- Field (STUDENT_CURRICULUM)
- Field (GRADE_FIRST_EXAM)
- Field (GRADE_SECOND_EXAM)
- Field (GRADE_THIRD_EXAM)
- Field (ALGORITHM_GRADE)
- Field (ALGORITHM_ACQUISTION_DATE)
- Field (ATTENDANCE_1/N)
- Field (ATTENDANCE_1/N_SIGN_IN)
- Field (ATTENDANCE_1/N_SIGN_OUT)
- Field (REG_USER)
- Field (REG_DT)
- Field (LAST_USER)
- Field (LAST_DT)
Untitled (REGION)
- Key (STUDENT_REGION) — 기본 키 — NOT NULL
- Field (STUDENT_GROUP)
Untitled (TEACHER)
- Key (GROUP_TEACHER_ID) — 기본 키 — NOT NULL
- Key (STUDENT_REGION) — 외래 키 → Untitled.Key — NOT NULL
- Field (GROUP_TEACHER_NAME)
- Field (GROUP_TEACHER_HP)
Untitled (PROJECT)
- Key (PROJECT_ID) — 기본 키 — NOT NULL
- Key (STUDENT_ACCOUNT) — 외래 키 → Untitled.Key — NOT NULL
- Key (STUDENT_REGION) — 외래 키 → Untitled.Key — NOT NULL
- Field (PROJECT_NAME)
- Field (PROJECT_GRADE)