SSAFY_Day1_ERD

테이블 (5)

Untitled (Group)

  • Key (`GROUP_ID`) — Long — 기본 키 — NOT NULL
  • Field (`GROUP_TEACHER_ID`) — varchar(20)
  • Field (`GROUP_TEACHER_NAME`) — varchar(20)
  • Field (`GROUP_TEACHER_HP`) — varchar(20)

Untitled (Grade)

  • Key (`GRADE_ID`) — Long — 기본 키 — NOT NULL
  • Field (`GRADE_FIRST_EXAM`) — varchar(3)
  • Field (`GRADE_SECOND_EXAM`) — varchar(3)
  • Field (`GRADE_THIRD_EXAM`) — varchar(3)
  • Field (`ALGORITHM_GRADE`) — varchar(20)
  • Field (`ALGORITHM_ACQUISITION_DATE`) — datetime
  • Field (`GRADE_FIRST_PROJECT`) — varchar(3)
  • Field (`GRADE_SECOND_PROJECT`) — varchar(3)
  • Field (`GRADE_THIRD_PROJECT`) — varchar(3)

Untitled (Attendance)

  • Key (`ATTENDANCE_ID`) — Long — 기본 키 — NOT NULL
  • Key (`USER_ID`) — Long — 외래 키 → 유저.Key — NOT NULL
  • Field (`ATTENDANCE_DATE`) — datetime
  • Field (`SIGN_IN`) — datetime
  • Field (`SIGN_OUT`) — datetime

Untitled (Reg)

  • Key (`REG_ID`) — Long — 기본 키 — NOT NULL
  • Field (`REG_USER`) — varchar(20)
  • Field (`REG_DT`) — datetime
  • Field (`LAST_USER`) — varchar(20)
  • Field (`LAST_DT`) — datetime

유저 (User)

  • Key (`USER_ID`) — Long — 기본 키 — NOT NULL
  • Key (`GROUP_ID`) — Long — 외래 키 → Untitled.Key — NOT NULL
  • Key (`GRADE_ID`) — Long — 외래 키 → Untitled.Key — NOT NULL
  • Key (`REG_ID`) — Long — 외래 키 → Untitled.Key — NOT NULL
  • Key (`STUDENT_ACCOUNT`) — varchar(20) — NOT NULL
  • Field (`STUDENT_NAME`) — varchar(100)
  • Field2 (`STUDENT_HP`) — varchar(20)
  • Field (`STUDENT_AGE`) — varchar(5)
  • Field2 (`STUDENT_GENDER`) — varchar(20)
  • Field (`STUDENT_CURRICULUM`) — varchar(20)
  • Field (`STUDENT_REGION`) — varchar(20)