NEW ERMS

테이블 (37)

### 첨부파일(미사용) (FEM001T)

  • ATTACH_DOCUM_ID — int — 기본 키 — NOT NULL
  • ATTACH_SEQ_NO — int — 기본 키 — NOT NULL
  • ATTACH_DOCUM_NM — varchar(255)
  • ATTACH_DOCUM_FG — varchar(1)
  • ATTACH_DOCUM_PATH — varchar(255)
  • ATTACH_DOCUM_EXPLA — varchar(1000)
  • ATTACH_SIZE — varchar(8)
  • ATTACH_STATE — varchar(1)
  • ATTACH_AUTH — char(1)
  • ATTACH_FG — char(1)
  • REQ_TP — varchar(20)
  • REGST_ID — varchar(20)
  • REGST_DT — varchar(14)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

FAQ관리 (FEF102T)

  • REQ_STD_ID — int — 기본 키 — NOT NULL
  • REGST_DT — varchar(14)
  • USE_FG — char(1)
  • STD_TITLE — varchar(255)
  • STD_CONTENT — varchar(max)
  • STD_TEXT_CONTENT — varchar(max)
  • VIEW_CNT — int
  • ADM_ID — varchar(20)
  • ORD — int
  • REQ_TP — varchar(20) — NOT NULL
  • ATTACH_DOCUM_ID — varchar(20)
  • REQ_ID — int
  • ANSWER_ID — int
  • BEST_FG — char(1)
  • BEST_ORD — int
  • REQ_FG — char(1)
  • REGST_DEPT — varchar(10)
  • QNA_USE_YN — char(1)
  • QNA_REQ_TP — varchar(20)
  • QNA_ORD — int
  • UPDATE_DT — varchar(14)
  • UPDATE_ADM_ID — varchar(20)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

FAQ통계 (FES102T)

  • REST_DT — varchar(8) — 기본 키 — NOT NULL
  • REQ_STD_ID — int — 기본 키 — NOT NULL
  • VIEW_CNT — int
  • TO_VIEW_CNT — int
  • REQ_TP — varchar(20)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

KBS 직원정보 (KBS_PERSON)

  • SEQ — int — 기본 키 — NOT NULL
  • EMPLOYEE_ID — varchar(20)
  • PPS_DEPARTMENT_CODE — varchar(50)
  • PPS_DEPARTMENT_NAME — varchar(50)
  • NAME_KOREAN — varchar(100)
  • EMAIL_ADDRESS — varchar(max)
  • RETIRE_YN — varchar(1)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

tb_datas

  • cd_classfier — varchar(5) — NOT NULL
  • code — varchar(5) — NOT NULL
  • cd_desc — varchar(100)
  • kepco_cd — varchar(5)
  • use_yn — char(1)
  • reg_date — char(8)
  • reg_emp_no — varchar(8)

tb_datas_temp

  • cd_classfier — varchar(5) — NOT NULL
  • code — varchar(5) — NOT NULL
  • cd_desc — varchar(100)
  • kepco_cd — varchar(5)
  • use_yn — char(1)
  • reg_date — char(8)
  • reg_emp_no — varchar(8)

공지사항관리 (FEE105T)

  • NOTICE_ID — int — 기본 키 — NOT NULL
  • NOTICE_GRP_ID — char(1)
  • ADM_ID — varchar(20)
  • POINT_FG — char(1)
  • START_DT — date
  • END_DT — date
  • NOTICE_TITLE — varchar(255)
  • NOTICE_CONTENT — varchar(max)
  • NOTICE_TEXT_CONTENT — varchar(max)
  • NOTICE_FG — char(1)
  • NOTICE_AUTH — char(3)
  • VIEW_CNT — int
  • ATTACH_DOCUM_ID — int
  • USE_YN — char(1)
  • REGST_DT — varchar(14)
  • UPDATE_DT — varchar(14)
  • UPDATE_ADM_ID — varchar(20)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

답변 (FEM102T)

  • ANSWER_ID — int — 기본 키 — NOT NULL
  • REQ_ID — int — 외래 키 → 문의마스터.REQ_ID — NOT NULL
  • ADM_ID — varchar(20)
  • REQ_TP — varchar(20)
  • DUP_TP — char(1)
  • RVS_DT — varchar(14)
  • OPEN_DT — varchar(14)
  • ANSWER_DT — varchar(14)
  • ANSWER_TITLE — varchar(4000)
  • ANSWER_CONTENT — varchar(max)
  • STD_ANSWER_FG — char(1)
  • APPV_STATUS — varchar(2)
  • ATTACH_DOCUM_ID — int
  • FAQ_FG — char(1)
  • MID — int
  • TREAT_FG — varchar(50)
  • REFER — varchar(200)
  • SMS_ID — int
  • GROUP_CD — varchar(20)
  • STAT_REQ_TP — varchar(max)
  • STAT_REQ_TP_NM — varchar(max)
  • ANSWER_CHNN — char(3)
  • SEND_CHNN — char(3)
  • PROGRAM_CD — varchar(50)
  • PROGRAM_NM — varchar(50)
  • BROAD_DT — varchar(8)
  • BROAD_ST_TM — varchar(4)
  • BROAD_ED_TM — varchar(4)
  • BROAD_DAY_CD — varchar(7)
  • BROAD_DAY — varchar(7)
  • CHANNEL_CATE_CD — varchar(50)
  • CONTENT_CATE_CD — varchar(50)
  • AREA_GB_CD — varchar(50)
  • AREA_CATE_CD — varchar(50)
  • PROPEN_GB_CD — varchar(50)
  • ADDCD — char(10)
  • HOUSENO — char(60)
  • ACCTYPE — varchar(3)
  • CUSTOMID — varchar(20)
  • reanswer_yn — char(1)
  • voc_input_str — varchar(4)
  • POINT — int
  • POINT_REGST_DTM — varchar(14)
  • TOKEN — varchar(36)
  • ZIP_CODE — varchar(10)
  • ADDR — varchar(100)
  • ADDR2 — varchar(200)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

메일접수[문의접수/답변전송] (FEM109T)

  • REQ_ID — int — 기본 키 — NOT NULL
  • ANSWER_ID — int — 기본 키 — NOT NULL
  • SEQ — int — 기본 키 — NOT NULL
  • MAIL_TITLE — varchar(4000)
  • MAIL_CONTENT — varchar(max)
  • FR_EMAIL — varchar(50)
  • TO_EMAIL — varchar(50)
  • STATUS — varchar(4000)
  • REGST_ID — varchar(20)
  • REGST_DT — varchar(14)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

문의마스터 (FEM101T)

  • REQ_ID — int — 기본 키 — NOT NULL
  • CAER_ID — varchar(20) — NOT NULL
  • REQ_STATUS — char(1) — NOT NULL
  • VIEW_CNT — int
  • REQ_TP — varchar(20)
  • REQ_PATH — char(3)
  • OPEN_FG — char(1)
  • QUESTION_DT — varchar(14)
  • TREAT_EXPCT_DT — varchar(14)
  • REQ_TITLE — varchar(4000)
  • REQ_CONTENT — varchar(max)
  • CAER_FG — char(1)
  • RE_REQ_YN — char(1)
  • ATTACH_DOCUM_ID — int
  • OPEN_PASS — varchar(20)
  • BEFORE_REQ_ID — int
  • EMAIL — varchar(150)
  • REPLYREQUEST — char(1)
  • REGST_ID — varchar(20)
  • SUGGEST_BACK — varchar(4000)
  • SUGGEST_EFFECT — varchar(4000)
  • CELLULA — varchar(100)
  • ZIP_CODE — char(6)
  • ADDR1 — varchar(120)
  • ADDR2 — varchar(200)
  • CHANNEL — varchar(3)
  • TELNO — varchar(100)
  • GROUP_CD — varchar(20)
  • FAX_NO — varchar(14)
  • CAER_ATT — char(1)
  • DAY_ID — int
  • PROG_ID — varchar(30)
  • SYBASE_FG — char(1)
  • regst_dt — varchar(14)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

문의자 문의정보상세 (FEM106T)

  • REQ_TP — varchar(20) — 기본 키 — NOT NULL
  • REQ_ID — int — 외래 키 → 문의마스터.REQ_ID — NOT NULL
  • tel_no — varchar(30)
  • prog_nm — varchar(30)
  • page_url — varchar(50)
  • bad_user — varchar(20)
  • ad_site — varchar(50)
  • addr — varchar(100)
  • res_no — varchar(14)
  • ele_no — varchar(20)
  • addr2 — varchar(200)
  • tel_no1 — varchar(20)
  • tel_no2 — varchar(20)
  • com_nm — varchar(100)
  • name — varchar(30)
  • name_cu — varchar(30)
  • attach — varchar(255)
  • ZIP_CODE — varchar(10)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

민원인 코멘트 관리 (FEE113T)

  • CAER_ID — varchar(20) — 기본 키 — NOT NULL
  • SEQ_NO — int — 기본 키 — NOT NULL
  • COMM — varchar(255)
  • REGST_ID — varchar(20)
  • REGST_DT — varchar(14)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

민원인관리 (FEE104T)

  • 민원인아이디 (CAER_ID) — varchar(20) — 기본 키 — NOT NULL
  • CAER_FG — varchar(1) — NOT NULL
  • CAER_NM — varchar(100) — NOT NULL
  • PASSWD — varchar(20)
  • RESID — varchar(20)
  • EMAIL — varchar(150)
  • TELNO — varchar(100)
  • FAX_NO — varchar(14)
  • REGST_DT — varchar(14)
  • ADDR1 — varchar(200)
  • ZIP_CODE — varchar(6)
  • CELLULA — varchar(100)
  • ADDR2 — varchar(200)
  • SEQ — int — NOT NULL
  • birth_day — char(8)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

방송 정보 (BROADCAST_INFO)

  • INFO_ID — int — 기본 키 — NOT NULL
  • TITLE — varchar(100)
  • BROADCAST_DT — date — NOT NULL
  • VIEW_CNT — int
  • VIEW_YN — char(1)
  • REGST_ID — varchar(20)
  • REGST_DTM — varchar(14)
  • MODIFY_ID — varchar(20)
  • MODIFY_DTM — varchar(14)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

방송 정보 프로그램 항목 (BROADCAST_INFO_PROGRAM)

  • INFO_PRO_ID — int — 기본 키 — NOT NULL
  • INFO_ID — int — 외래 키 → 방송 정보.INFO_ID — NOT NULL
  • ORDER — int
  • PRO_CD — varchar(27)
  • PRO_NM — varchar(100)
  • CONTENT — text
  • TIME — varchar(12)
  • VIEW_YN — char(1)
  • REF_BROAD_SEQ — numeric(38, 0)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

방송 프로그램 이미지 관리 (BROADCAST_IMG)

  • IMG_ID — int — 기본 키 — NOT NULL
  • IMG_TITLE — varchar(100)
  • PRO_CD — varchar(27)
  • ATTACH_DOCUM_ID — int
  • REGST_ID — varchar(20)
  • REGST_DTM — varchar(14)
  • MODIFY_ID — varchar(20)
  • MODIFY_DTM — varchar(14)
  • USE_YN — varchar(1)
  • IMG_URL — varchar(200)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

배치 실행여부관리 (FEC106T)

  • DIST_YN — char(1) — NOT NULL
  • DIST_ING — char(1)
  • STAT_ING — char(1)
  • MAIL_ING — char(1)
  • KNSL_ING — char(1)

분류관리(분류항목 정보) (FEC101T)

  • REQ_TP — varchar(20) — 기본 키 — NOT NULL
  • REQ_TP_NM — varchar(255) — NOT NULL
  • REQ_TP_FG — char(1)
  • REQ_TP_EXPLAIN — varchar(1000)
  • REQ_TP_LOCATE — varchar(255)
  • FAQ_USE_YN — char(1)
  • REQ_TP_PATH — varchar(255)
  • FAQ_TP_ID — varchar(20)
  • SEQ_NO — int
  • UNDER_CD_YN — char(1)
  • IMG — varchar(400)
  • USE_YN — char(1)
  • REQ_ORDER — varchar(20)
  • OLD_REQ_TP — varchar(20)
  • MAIL_REQ_YN — char(1)
  • MAIL_ANSWER_YN — char(1)
  • MAIL_MOVE_YN — char(1)
  • REQ_TP_GB — char(1)
  • IMG_SIZE — varchar(8)
  • EXP_VIEW_YN — char(1)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

분류담당자관리 (FEC102T)

  • REQ_TP — varchar(20) — 기본 키 — NOT NULL
  • ADM_ID — varchar(20) — 기본 키 — NOT NULL
  • ADM_FG — char(1) — 기본 키 — NOT NULL
  • ADAPT_DT — varchar(14)
  • CNT_SH — int
  • REAL_CNT_SH — int
  • LIMIT_CNT — int
  • TREAT_PCNT — int
  • USE_YN — char(1)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

분배관리 (FEC103T)

  • 질의유형 (REQ_TP) — varchar(20) — 기본 키 — NOT NULL
  • DIST_METHOD — char(1)
  • TREAT_DUEDT — varchar(2)
  • HOL_IND_YN — char(1)
  • SAME_MIN — int
  • SAME_CAER_FG — char(1)
  • WORKING_FG — char(1)
  • WORKING_FR — varchar(4)
  • WORKING_TO — varchar(4)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

불량 사용자 관리 (BLACKLIST)

  • 사용자아이디 (CUSTOMER_ID) — varchar(20) — 기본 키 — NOT NULL
  • QNA_BLOCK_YN — char(1)
  • BOARD_BLOCK_YN — char(1)
  • COMMENT — varchar(4000) — archar(4000) NUL
  • REGST_ID — varchar(20)
  • REGST_DTM — varchar(14)
  • MODIFY_ID — varchar(20)
  • MODIFY_DTM — varchar(14)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

불량 사용자 관리 이력 (BLACKLIST_HIST)

  • 등록기록아이디 (HIST_ID) — int — 기본 키 — NOT NULL
  • 사용자아이디 (CUSTOMER_ID) — varchar(20) — 외래 키 → 불량 사용자 관리.사용자아이디 — NOT NULL
  • QNA_BLOCK_YN — char(1)
  • BOARD_BLOCK_YN — char(1)
  • COMMENT — varchar(4000) — archar(4000) NUL
  • REGST_ID — varchar(20)
  • REGST_DTM — varchar(14)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

수신료시스템민원접수내역 (VOC_APPEAL_TB)

  • APPEALNO — char(13) — 기본 키 — NOT NULL
  • TALK_S_DATE — char(8)
  • TALK_S_TIME — char(6)
  • TALK_E_DATE — char(8)
  • TALK_E_TIME — char(6)
  • TALK_TIME — int
  • ACCEPT_DATE — char(8)
  • ACCEPT_TIME — char(6)
  • CUSTOMID — varchar(19)
  • CUSTOMER — varchar(20)
  • EMAIL — varchar(60)
  • ADDRCD — varchar(10)
  • ACCTYPE_R — varchar(4)
  • ACCTYPE_M — varchar(4)
  • ACCWAY — varchar(5)
  • DISTYPE_R — varchar(4)
  • DISTYPE_M — varchar(4)
  • DIS_STATUS — varchar(5)
  • DISPOSER — varchar(8)
  • DISPOSER_NM — varchar(20)
  • ACCKBS — varchar(4)
  • PRGCONTENT — varchar(200)
  • AREACD — char(1)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

수신료티켓 (VOC_TICKET)

  • VOC_CHANNEL — char(1)
  • TICKET_ID — int — NOT NULL

이력관리 (FEM103T)

  • SEQ_NO — int — 기본 키 — NOT NULL
  • ANSWER_ID — int — 외래 키 → 답변.ANSWER_ID — NOT NULL
  • CHNG_TP — varchar(2)
  • WORKER — varchar(20)
  • RCVER — varchar(20)
  • BEFORE_REQ_TP — varchar(20)
  • CUR_REQ_TP — varchar(20)
  • RESN_CODE — char(1)
  • RESN_CONTENTS — varchar(4000)
  • ATTACH_DOCUM_ID — int
  • MID — int
  • REGST_DT — varchar(14)
  • OLD_RVS_DT — varchar(14)
  • CUR_GROUP_CD — varchar(20)
  • OLD_GROUP_CD — varchar(20)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

일일 상담 보고서 (DAILY_REPORT)

  • REPORT_ID — int — 기본 키 — NOT NULL
  • TITLE — varchar(100)
  • VIEW_CNT — int
  • CHECK_DT — date
  • START_TIME — varchar(4)
  • END_TIME — varchar(4)
  • CHECK_CNT — int
  • REGST_ID — varchar(20)
  • REGST_DTM — varchar(14)
  • MODIFY_ID — varchar(20)
  • MODIFY_DTM — varchar(14)
  • ATTACH_DOCUM_ID — int
  • VIEW_YN — char(1)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

일일 상담 보고서 주요의견 (DAILY_REPORT_COMMENT)

  • COMMENT_ID — int — NOT NULL
  • ORDER — int
  • COMMENT — ADD — DD DEFAULT ((0)) FOR ORDER_TYPE varchar(25) NULL undefined CONSTRAINT DAILY_REPORT_undefined_PK PRIMARY KEY CLUSTERED (…
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

일일주요의견 (FEH102T)

  • ID — int — 기본 키 — NOT NULL
  • REGST_DT — varchar(14) — NOT NULL
  • USE_FG — char(1)
  • TITLE — varchar(255)
  • CONTENT — varchar(max)
  • REQ_CONTENT — varchar(max)
  • ANSWER_CONTENT — varchar(max)
  • VIEW_CNT — int
  • REGST_ID — varchar(20)
  • ATTACH_DOCUM_ID — varchar(20)
  • POINT_FG — varchar(3)
  • TP — varchar(3)
  • CHNN — varchar(20)
  • CHNN_CD — varchar(10)
  • PROG_NM — varchar(100)
  • PROG_TIME — varchar(4)
  • ADM_ID — varchar(20)
  • ANSWER_DT — varchar(14)
  • caer_id — nvarchar(20)
  • CAER_NM — varchar(20)
  • TEL_NO — varchar(20)
  • REFER — varchar(4000)
  • ETC — varchar(4000)
  • NO — varchar(40)
  • PROG_ID — varchar(30)
  • PROG_DAY — varchar(7)
  • LOC_NO — varchar(8)
  • CONN_ID — varchar(100)
  • AREA_GB_CD — varchar(2)
  • AREA_CATE_CD — varchar(2)
  • ADD_CNT — varchar(100)
  • MGR_PHONE_NO — varchar(20)
  • EMAIL — varchar(50)
  • LOCAL_NO — varchar(3)
  • INSERT_DT — varchar(14)
  • REPORT_YN — char(1)
  • PROG_END_TIME — varchar(4)
  • total_id — nvarchar(200)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

자료실(시청자상담백서쪽) (HP_DOWN_BOARD)

  • SEQ — int — 기본 키 — NOT NULL
  • TITLE — varchar(100)
  • RFILE — varchar(30)
  • CFILE — varchar(30)
  • DOWN_CNT — int
  • REGID — varchar(20)
  • REGDATE — date
  • DEL_YN — varchar(1)
  • DELDATE — date
  • ATTACH_DOCUM_ID — int
  • UPDATE_DT — varchar(14)
  • UPDATE_ADM_ID — varchar(20)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

자유게시판 (FEH103T)

  • BOARDNO — int — 기본 키 — NOT NULL
  • LEVELNO — int — 기본 키 — NOT NULL
  • SAMENO — int — 기본 키 — NOT NULL
  • BOARD_TITLE — varchar(2000)
  • BOARD_CONTENT — varchar(max)
  • REGST_ID — varchar(20) — NOT NULL
  • REGST_DT — varchar(14) — NOT NULL
  • USE_YN — char(1) — NOT NULL
  • ATTACH_DOCUM_ID — int
  • VIEW_CNT — int
  • MODIFY_DT — varchar(14)
  • DELETE_DT — varchar(14)
  • MODIFY_ID — varchar(14)
  • DELETE_ID — varchar(14)
  • ORDERNO — int
  • BOARD_CHNN — varchar(3)
  • BOARD_TP — varchar(3)
  • DAY_ID — int
  • PROGRAM_CD — varchar(50)
  • PROGRAM_NM — varchar(50)
  • BROAD_DT — varchar(8)
  • BROAD_ST_TM — varchar(4)
  • BROAD_ED_TM — varchar(4)
  • BROAD_DAY_CD — varchar(7)
  • BROAD_DAY — varchar(7)
  • CHANNEL_CATE_CD — varchar(50)
  • CONTENT_CATE_CD — varchar(50)
  • AREA_GB_CD — varchar(50)
  • AREA_CATE_CD — varchar(50)
  • PROPEN_GB_CD — varchar(50)
  • MOBILE_YN — char(1)
  • VIEW_YN — char(1)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

제작진답변 (FEH101T)

  • ID — int — 기본 키 — NOT NULL
  • REGST_DT — varchar(14)
  • USE_FG — char(1)
  • TITLE — varchar(255)
  • CONTENT — varchar(max)
  • TEXT_CONTENT — varchar(max)
  • VIEW_CNT — int
  • REGST_ID — varchar(20)
  • ATTACH_DOCUM_ID — varchar(20)
  • CUSTOMER_CONTENT — varchar(8000)
  • DEPT_NM — varchar(50)
  • UPDATE_DT — varchar(14)
  • UPDATE_ADM_ID — varchar(20)
  • ANSWER_TP — char(1)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

참고답변관리 (FEF101T)

  • STD_ANSWER_ID — int — 기본 키 — NOT NULL
  • REQ_TP — varchar(20)
  • ADM_ID — varchar(20)
  • REGST_DT — varchar(14)
  • REQ_TITLE — varchar(4000)
  • REQ_CONTENT — varchar(max)
  • ANSWER_TITLE — varchar(4000)
  • ANSWER_CONTENT — varchar(max)
  • ANSWER_TEXT_CONTENT — varchar(max)
  • VIEW_CNT — int
  • REFER_CNT — int
  • ANSWER_ID — int
  • VIEW_AUTH — char(1)
  • CNTL_WD — varchar(255)
  • USE_YN — char(1)
  • WD_TP — char(1)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

첨부파일정보 (ATTACHMENT)

  • 첨부파일아이디 (ATTACH_DOCUM_ID) — int — 기본 키 — NOT NULL
  • 첨부파일순번 (ATTACH_SEQ_NO) — int — 기본 키 — NOT NULL
  • ATTACH_DOCUM_NM — varchar(255)
  • ATTACH_DOCUM_MASK_NM — varchar(255)
  • ATTACH_DOCUM_PATH — varchar(255)
  • ATTACH_DOCUM_EXPLA — varchar(1000)
  • ATTACH_SIZE — int
  • REGST_ID — varchar(20)
  • REGST_DTM — varchar(14)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

템플릿 (FET101T)

  • TEMP_NO — int — 기본 키 — NOT NULL
  • TEMP_FG — char(1)
  • TEMP_TITLE — varchar(50)
  • CHANNEL — char(3)
  • USE_YN — char(1)
  • TEMP_EXPLAIN — varchar(100)
  • ATTACH_DOCUM_PATH — varchar(255)
  • USE_AUTH — char(1)
  • CONTENT — varchar(max)
  • USER_GRP — varchar(20)
  • REGST_ID — varchar(20)
  • REGST_DT — varchar(14)
  • UPDATE_DT — varchar(14)
  • UPDATE_ADM_ID — varchar(20)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

통계 (FES101T)

  • REST_DT — varchar(8) — 기본 키 — NOT NULL
  • ADM_ID — varchar(20) — 기본 키 — NOT NULL
  • REQ_TP — varchar(20) — 기본 키 — NOT NULL
  • USER_GRP — varchar(20) — 기본 키 — NOT NULL
  • FORWARD_CNT — int
  • QUESTION_CNT — int
  • RCVE_CNT — int
  • TREAT_CNT — int
  • TREAT_CNT_0 — int
  • TREAT_CNT_1 — int
  • TREAT_CNT_2 — int
  • TREAT_CNT_3 — int
  • TREAT_CNT_4 — int
  • TREAT_CNT_OVER — int
  • TREAT_CNT_5 — int
  • TOT_TREAT_CNT — int
  • TREAT_CNT_6 — int
  • TREAT_CNT_7 — int
  • RESERVE_CNT — int
  • TREAT_CNT_8 — int
  • RELAY_CNT — int
  • TREAT_CNT_9 — int
  • DEL_CNT — int
  • TREAT_CNT_10 — int
  • UNSET_CNT — int
  • INNER_CNT — int
  • UNSET_CNT_OVER — int
  • RETUSN_CNT — int
  • SATIS_CNT_1 — int
  • SATIS_CNT_2 — int
  • SATIS_CNT_3 — int
  • SATIS_CNT_4 — int
  • SATIS_CNT_5 — int
  • RETURN_CNT — int
  • GROUP_CD — int
  • QUESTION_AVG_TREAT_DT — decimal(12, 3)
  • RCVE_AVG_TREAT_DT — decimal(12, 3)
  • UNION_CNT — int
  • PHONE_CNT — int
  • NORMAL_CNT — int
  • TRANS_CNT — int
  • TRANS_RCVE_CNT — int
  • TRANS_SEND_CNT — int
  • TRANS_QUESTION_AVG_TREAT_DT — decimal(12, 3)
  • TRANS_RCVE_AVG_TREAT_DT — decimal(12, 3)
  • BATCH_CNT — int
  • MIX_CNT — int
  • REQ_CH_CNT — int
  • MIX_CNT_SUB — int
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

홈페이지 세션 (IAUDIENCE_SESSION)

  • PRIMARY_ID — char(36) — 기본 키 — NOT NULL
  • SESSION_ID — char(36) — NOT NULL
  • CREATION_TIME — bigint — NOT NULL
  • LAST_ACCESS_TIME — bigint — NOT NULL
  • MAX_INACTIVE_INTERVAL — int — NOT NULL
  • EXPIRY_TIME — bigint — NOT NULL
  • PRINCIPAL_NAME — varchar(100)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

홈페이지 세션 어트리뷰트 (IAUDIENCE_SESSION_ATTRIBUTES)

  • ATTRIBUTE_NAME — varchar(200) — 기본 키 — NOT NULL
  • SESSION_PRIMARY_ID — char(36) — 외래 키 → 홈페이지 세션.PRIMARY_ID — NOT NULL
  • ATTRIBUTE_BYTES — image — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =