Day01_DB프로젝트
테이블 (8)
ALGORITHM
- STUDENT_PK — int — 외래 키 → STUDENT.STUDENT_PK — NOT NULL
- ALGORITHM_GRADE — varchar(20)
- ALGORITHM_ACQUISITION_DATE — datetime
ATTENDANCE
- STUDENT_PK — int — 외래 키 → STUDENT.STUDENT_PK — NOT NULL
- ATTENDANCE_NUMBERTH — int
- ATTENDANCE_SIGN_IN — datetime
- ATTENDANCE_SIGN_OUT — datetime
GRADE
- STUDENT_PK — int — 외래 키 → STUDENT.STUDENT_PK — NOT NULL
- GRADE_NUMBERTH — int
- GRADE_SCORE — varchar(3)
REGISTER
- STUDENT_PK — int — 외래 키 → STUDENT.STUDENT_PK — NOT NULL
- REG_USER — varchar(20)
- REG_DT — datetime
- LAST_USER — varchar(20)
- LAST_DT — datetime
STUDENT
- STUDENT_PK — int — 기본 키 — NOT NULL
- STUDENT_ACCOUNT — varchar(20) — NOT NULL
- STUDENT_NAME — varchar(100)
- STUDENT_HP — varchar(20)
- STUDENT_AGE — varchar(5)
- STUDENT_GENDER — varchar(20)
- STUDENT_CURRICULUM — varchar(20)
- STUDENT_REGION — varchar(20)
- STUDENT_GROUP — varchar(20) — NOT NULL
- TEACHER_PK — int — 외래 키 → TEACHER.TEACHER_PK — NOT NULL
STUDENT_TEAM
- STUDENT_PK — int — 외래 키 → STUDENT.STUDENT_PK — NOT NULL
- TEAM_PK — int — 외래 키 → TEAM.TEAM_PK — NOT NULL
TEACHER
- TEACHER_PK — int — 기본 키 — NOT NULL
- TEACHER_ID — varchar(20) — NOT NULL
- TEACHER_NAME — varchar(20) — NOT NULL
- TEACHER_HP — varchar(20) — NOT NULL
TEAM
- TEAM_PK — int — 기본 키 — NOT NULL
- TEAM_NAME — varchar(20) — NOT NULL
- TEAM_SUBJECT — varchar(20) — NOT NULL
- TEAM_GRADE — varchar(3) — NOT NULL
- TEAM_PROJECT_NO — varchar(3) — NOT NULL