생활기록부Table

테이블 (4)

TB_LIFE_RECORD (Untitled)

  • Key (ID) — 기본 키 — NOT NULL
  • 그룹계정 (ADMIN_ID)
  • 학생ID (USER_ID)
  • Field3 (USER_GENDER)
  • Field4 (USER_NAME)
  • Field5 (USER_EMAIL)
  • Field (HIGHSCHOOL_NAME)
  • Field (GRADE)
  • Field (TARGET_UNIV)
  • Field (APPLIE_TYPE)
  • Field (REG_DATE)
  • Field

TB_STUDENT_ACTIVITY (창의적 체험활동)

  • Key (ACTIVITY_ID) — 기본 키 — NOT NULL
  • Field (ADMIN_ID)
  • Field2 (USER_ID)
  • Field (ACTIVITY_GRADE)
  • Field (ACTIVITY_AREA)
  • Field (ACTIVITY_HOUR)
  • Field (ACTIVITY_DETAIL)

TB_STUDENT_AWARD (수상경력)

  • Key (AWARD_ID) — 기본 키 — NOT NULL
  • Field (ADMIN_ID)
  • Field (USER_ID)
  • Field (AWARDS_GRADE)
  • Field (AWARDS_TERM)
  • Field (AWARDS_NAME)
  • Field (AWARDS_LEVEL)
  • Field (AWARDS_RANKING)
  • Field (AWARDS_DATE)
  • Field (ISSUER)
  • Field (CATEGORY)
  • Field (NOTES)
  • Field

TB_STUDENT_CERT (자격증)

  • Key (CERT_ID) — 기본 키 — NOT NULL
  • Field (ADMIN_ID)
  • Field2 (USER_ID)
  • Field (CERT_TYPE)
  • Field (CERT_NAME)
  • Field (CERT_DATE)
  • Field (CERT_ISSUER)
  • Field (LICENSE_NO)
  • Field (SCORE_OR_LEVEL)
  • Field (EXPIRE_DATE)
  • Field (STATUS)
  • Field (NOTES)