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)