학사관리시스템
테이블 (6)
반 (SSAFY_GROUP)
- STUDENT_GROUP — INT — 기본 키 — NOT NULL
- GROUP_TEACHER_ID (GTOUP_TEACHER_ID) — VARCHAR(20) — 외래 키 → 컨설턴트.TEACHER_ID — NOT NULL
- STUDENT_ACCOUNT — VARCHAR(20) — 외래 키 → 학생.STUDENT_ACCOUNT — NOT NULL — PK
컨설턴트 (SSAFY_CONSULTANT)
- TEACHER_ID — VARCHAR(20) — 기본 키 — NOT NULL
- STUDENT_GROUP — INT — 외래 키 → 반.STUDENT_GROUP — NOT NULL
- TEACHER_NAME — VARCHAR(20)
- TEACHER_HP — VARCHAR(20)
프로젝트 성적 (SSAFY_PROJECT)
- STUDENT_ACCOUNT (TEAM_LEADER) — VARCHAR(20) — 외래 키 → 학생.STUDENT_ACCOUNT — NOT NULL — PK
- STUDENT_ACCOUNT (TEAM_MEMBER1) — VARCHAR(20)
- STUDENT_ACCOUNT (TEAM_MEMBER2) — VARCHAR(20)
- STUDENT_ACCOUNT (TEAM_MEMBER3) — VARCHAR(20)
- STUDENT_ACCOUNT (TEAM_MEMBER4) — VARCHAR(20)
- PROJECT_GRADE — VARCHAR(20)
학생 (SSAFY_STUDENT)
- STUDENT_ACCOUNT — VARCHAR(20) — 기본 키 — NOT NULL — PK
- STUDENT_GROUP — INT — 외래 키 → 반.STUDENT_GROUP — NOT NULL
- STUDENT_NAME — VARCHAR(20)
- STUDENT_HP — VARCHAR(20)
- STUDENT_AGE — INT
- STUDENT_GENDER — VARCHAR(20)
- STUDENT_CURRICULLUM — VARCHAR(20)
- STUDENT_REGION — VARCHAR(20)
학생 과목 성적 (SSAFY_EAXM)
- STUDENT_ACCOUNT — VARCHAR(20) — 외래 키 → 학생.STUDENT_ACCOUNT — NOT NULL — PK
- GRADE_FIRST_EXAM — INT
- GRADE_SECOND_EXAM — INT
- GRADE_THIRD_EXAM — INT
- ALGORITHM_GRADE — VARCHAR(20)
- ALGORITHM_ACQUISITION_DATE — VARCHAR(20)
학생 출석정보 (ATTANCANCE)
- STUDENT_ACCOUNT — VARCHAR(20) — 외래 키 → 학생.STUDENT_ACCOUNT — NOT NULL — PK
- ATTANDANCE_DATE — VARCHAR(20)
- ATTANDANCE_TIME — VARCHAR(20)
- ATTANDANCE_INFO — VARCHAR(20)
- Field