html sr parsing erd

Tables (9)

TB_AWARDS_HTML (수상경력 테이블)

  • Key (AWARDS_NO) — INT(11) — Primary key — NOT NULL
  • Key (CONTENTS_NO) — INT(11) — Foreign key → TB_CONTENTS_HTML.Key — NOT NULL
  • Field (SCHOOL_LEVEL) — INT(11)
  • Field (SEMESTER) — INT(11)
  • Field (AWARDS_NM) — VARCHAR(2000)
  • Field (GRADE) — VARCHAR(50)
  • Field (AWARDS_DATE) — VARCHAR(50)
  • Field (INSTITUTE) — VARCHAR(100)
  • Field (JOIN_TARGET) — VARCHAR(100)
  • Field (MM) — VARCHAR(2)
  • Field (DD) — VARCHAR(2)

TB_BASIC_HTML (기본정보 테이블)

  • Key (BASIC_NO) — INT(11) — Primary key — NOT NULL
  • Key (CONTENTS_NO) — INT(11) — Foreign key → TB_CONTENTS_HTML.Key — NOT NULL
  • Field2 (ISSUE_NO) — VARCHAR(200)
  • Field3 (ID_NUMBER) — VARCHAR(14)
  • Field (ADDRESS) — VARCHAR(200)

TB_COMMENT_HTML (행동특성 및 종합의견 테이블)

  • Key (COMMENTS_NO) — INT(11) — Primary key — NOT NULL
  • Key (CONTENTS_NO) — INT(11) — Foreign key → TB_CONTENTS_HTML.Key — NOT NULL
  • Field (SCHOOL_LEVEL) — INT(11)
  • Field (CONTENTS) — TEXT

TB_CONTENTS_HTML (생기부 MST 테이블)

  • Key (CONTENTS_NO) — INT(11) — Primary key — NOT NULL
  • Field (CONTENTS_CD) — INT(11)
  • Field (SCHOOL_CD) — INT(11)
  • INDEX (ACCOUNT_NO) — BIGINT(20)
  • Field (STATUS_CD) — INT(11)
  • Field (SCHOOL_RECORD_CD) — VARCHAR(3)

TB_COURSE_DETAIL_HTML (세부능력 및 특기사항)

  • Key (COURSE_DETAIL_NO) — INT(11) — Primary key — NOT NULL
  • Key (CONTENTS_NO) — INT(11) — Foreign key → TB_CONTENTS_HTML.Key — NOT NULL
  • Field (SCHOOL_LEVEL) — INT(11)
  • Field (SEMESTER) — INT(11)
  • Field (DETAIL_CONTENTS) — TEXT
  • Field (GROUP_KEY) — VARCHAR(100)

TB_COURSE_HTML (교과학습발달상황)

  • Key (COURSE_NO) — INT(11) — Primary key — NOT NULL
  • Key (CONTENTS_NO) — INT(11) — Foreign key → TB_CONTENTS_HTML.Key — NOT NULL
  • Field (SCHOOL_LEVEL) — INT(11)
  • Field (SEMESTER) — INT(11)
  • Field (COURSE) — VARCHAR(100)
  • Field (SUBJECT) — VARCHAR(100)
  • Field (UNIT) — VARCHAR(20)
  • Field (ACHIEVEMENT) — VARCHAR(20)
  • Field (STANDARD_DEVIATION) — VARCHAR(50)
  • Field (GRADE) — VARCHAR(20) — NOT NULL
  • Field (NOTE) — VARCHAR(100)
  • Field (GROUP_KEY) — VARCHAR(100)
  • Field (DISTRIBUTION_RATIO_BY_ACHIEVEMENT) — VARCHAR(40)

TB_EXPERIENCE_HTML (창의적 체험활동 테이블)

  • Key (EXPERIENCE_NO) — INT(11) — Primary key — NOT NULL
  • Key (CONTENTS_NO) — INT(11) — Foreign key → TB_CONTENTS_HTML.Key — NOT NULL
  • Field (SCHOOL_LEVEL) — INT(11)
  • Field (SEMESTER) — INT(11)
  • Field (AREA) — VARCHAR(50)
  • Field (HOUR) — INT(11)
  • Field (CONTENTS) — TEXT

TB_READING_HTML (독서활동상황 테이블)

  • Key (READING_NO) — INT(11) — Primary key — NOT NULL
  • Key (CONTENTS_NO) — INT(11) — Foreign key → TB_CONTENTS_HTML.Key — NOT NULL
  • Field (SCHOOL_LEVEL) — INT(11)
  • Field (SEMESTER) — INT(11)
  • Field (SUBJECT) — INT(11)
  • Field (CONTENTS) — TEXT

TB_SERVICE_HTML (봉사활동실적 테이블)

  • Key (SERVICE_NO) — INT(11) — Primary key — NOT NULL
  • Key (CONTENTS_NO) — INT(11) — Foreign key → TB_CONTENTS_HTML.Key — NOT NULL
  • Field (SCHOOL_LEVEL) — INT(11)
  • Field (SEMESTER) — INT(11)
  • Field (SERVICE_DATE) — VARCHAR(50)
  • Field (PLACE) — VARCHAR(100)
  • Field (CONTENTS) — VARCHAR(500)
  • Field (HOUR) — INT(11)
  • Field (SUM_HOUR) — INT(11)
  • Field (MM) — VARCHAR(2)
  • Field (DD) — VARCHAR(2)