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