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 — =