학사관리시스템

테이블 (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