d-care-old-erd
Tables (41)
ARTICLE_INFO
- id — int(11) — Primary key — NOT NULL
- CUSTOMER_ID — Foreign key → CUSTOMER.id — NOT NULL
- ELASTICSEARCH_DOC_ID — varchar(256) — 해당 기사의 Elasticsearch 도뮤먼트 ID
- ARTICLE_TENDENCY — varchar(5) — 사이트 성향 - 공통코드:00700
- ARTICLE_DISTRIBUTION — varchar(5) — 선택안함|명예훼손|19|저작권침해|유해정보 - 공통코드:00100
- ARTICLE_TYPE — varchar(5) — 미선택|이미지|텍스트|동영상 - 공통코드:00200
- DELETE_METHOD — varchar(5) — 삭제방법 미선택|사이트내신고탭|관리자이메일|DMCA|Privacy Guard - 공통코드:00300
- ACTION_STATUS — varchar(5) — 상태 삭제전|삭제중|삭제완료|미삭제 - 공통코드:00400
- PAGE_IGNORE_FLAG — char(1) — NOT NULL — 기사 제외 플래그 - 관련기사아님 = 'Y', 관련기사 맞음 = 'N'
- DEST_URL — varchar(2048) — 기사가 링크된 상대방 사이트
- FULL_SCREEN_CAPTURE — varchar(2048) — 전체화면 캡쳐정보
- ORG_URL — varchar(4096) — 동영상 등의 원본 유알엘
- ISFILTERED — char(1) — 필터링 된 데이터:Y, 일반 데이터 : N
- COMMENT — '메모' — 메모
- MODIFY_DATE
COMMENT_CHECK_INFO_YOUTUBE
- id — int(11) — Primary key — NOT NULL
- MAIN_ID — int(11) — Foreign key → DOCUMENT_MAIN.id — NOT NULL
- WebPageTitle — varchar(2048)
- ArticleSubscription — varchar(8192)
- DestUrl — varchar(2048)
- NEW_PageCreationDate — datetime
- OLD_PageCreationDate — datetime
- LastModifyUserIdx — int(11)
- LastModifyDateTime — datetime
- DUP_YN — char(1)
- EXISTS_YN — char(1)
COMMON_CODE
- PRECODE — varchar(5) — NOT NULL
- CODE — varchar(5) — NOT NULL
- NAME — varchar(50) — NOT NULL
- SORT_ORDER — int(11) — NOT NULL — 코드순서
- undefined — varchar(255)
CRAWLER_KEYWORDS
- id — int(11) — Primary key — NOT NULL
- CUSTOMER_ID — Foreign key → CUSTOMER.id — NOT NULL
- KEYWORD — varchar(128) — NOT NULL
- ISVALID — char(2)
- ISCRAWED — char(2)
- COLLECTFROM — datetime
- CREATE_DT — datetime
- CRAWLING_SCHEDULE_IDX — int(11) — NOT NULL
CRAWLER_KEYWORD_SUB
- id — int(11) — Primary key — NOT NULL
- craw_id — int(11) — NOT NULL — crawler_keywords 테이블의 id
- community_code — varchar(16) — NOT NULL
- board_name — varchar(128)
- board_url — varchar(256) — NOT NULL
CRAWLING_SCHEDULE
- idx — int(11) — Primary key — NOT NULL
- CUSTOMER_ID — Foreign key → CUSTOMER.id — NOT NULL
- PageSiteName — varchar(256) — NOT NULL
- BASE_URL — varchar(2048) — NOT NULL
- CRAWLING_KIND — char(2) — NOT NULL
- CRAWLING_EVENT_KIND — char(2) — NOT NULL
- START_DT — datetime — NOT NULL
- END_DT — datetime
- START_BASE_DT — datetime
- END_BASE_DT — datetime
- UrlContentType — char(1) — NOT NULL
- COMMON_COMMENT — longtext
- COMMENT — longtext
- PROCESS_STATUS — char(1) — NOT NULL
- CRAWLING_START_DT — datetime
- CRAWLING_END_DT — datetime
- LAST_MODIFY_USER_IDX — int(11) — NOT NULL
- LAST_MODIFY_DT — datetime — NOT NULL
- SVC_IDX — int(11)
- SVC_CPU_ID — varchar(50)
- CRAWLING_EVENT_TERM_START_DT — datetime
- CRAWLING_EVENT_TERM_END_DT — datetime
- CRAWLING_EVENT_TERM_LAST_DT — datetime
- WEEKEND_ALL — char(1) — NOT NULL
CRAWLING_SVC
- SVC_CPU_ID — varchar(50) — Primary key — NOT NULL
- SCHEDULE_CNT — int(11) — NOT NULL
CUSTOMER
- id — Primary key — NOT NULL
- COMPANY_IDX — int(11) — Foreign key → CUSTOMER_COMPANY.ID — NOT NULL
- CUSTOMER_ID — varchar(10) — NOT NULL
- CUSTOMER_NICKNAME — varchar(50)
- CUSTOMER_NAME — varchar(50)
- CUSTTOMER_S_ID — varchar(50)
- CONTRACT_DATE_S — date
- CONTRACT_DATE_E — date
- CONTRACT_STATUS — char(5) — NOT NULL
- TELEPHONE — varchar(20)
- EMAIL — varchar(64)
- BIRTHDAY — date
- BROADCAST_START — date
- CUSTOMER_ID_CARD — varchar(256)
- CRAW_GROUP — char(2)
- CRAW_YN — char(1) — NOT NULL
- REPORTING_YN — char(1) — NOT NULL
- DELETE_YN — char(1) — NOT NULL
- COMMENT — '회사인덱스' — 회사인덱스
- ADULT_AUTH
- CUSTOMER_KIND1 — char(2) — NOT NULL
- CUSTOMER_KIND2 — char(2) — NOT NULL
- CreateDate — date
CUSTOMER_COMPANY
- ID — int(11) — Primary key — NOT NULL
- COMPANY_NAME — varchar(50) — NOT NULL
- COMMENT — varchar(256)
CUSTOMER_MONTH_INFO (월별 고객 정보)
- ID — int(11) — Primary key — NOT NULL
- CUSTOMER_ID — Foreign key → CUSTOMER.id — NOT NULL
- YEAR_MONTH — char(7) — NOT NULL
- REPORT_YN — char(1) — NOT NULL
- MONTH_COMMENT — text
CUSTOMER_WD_INFO (고객위임장정보)
- ID — int(11) — Primary key — NOT NULL
- CUSTOMER_IDX — Foreign key → CUSTOMER.id — NOT NULL
- SITE_IDX — int(11) — Foreign key → SITE_INFO.id — NOT NULL
- USER_IDX — int(11) — Foreign key → USER_INFO.ID — NOT NULL
- COMPANY_DESIGNATION_YN — char(1) — NOT NULL
- USER_KIND — char(1)
- COMPANY_IDX — int(11) — NOT NULL
- ST_DT — datetime
- ED_DT — datetime
- DELETE_YN — char(1) — NOT NULL
- ETC — text
- SITE_KEYWORD — char(2)
- USER_DELETEME_YN — char(1) — NOT NULL
- IMG_IDX — int(11)
- USE_YN — char(1) — NOT NULL
CUSTOMER_WT_TOP_SELECT (위임장 우선선택(대표위임장))
- ID — int(11) — Primary key — NOT NULL
- WT_IDX — int(11) — Foreign key → CUSTOMER_WD_INFO.ID — NOT NULL
- CUSTOMER_IDX
- SITE_IDX
- USER_IDX
DELETE_URL
- ID — int(11) — Primary key — NOT NULL
- CUSTOMER_ID — Foreign key → CUSTOMER.id — NOT NULL
- DestURL — varchar(2048) — NOT NULL
DOCUMENT_EXCEPT_COUNT
- CUSTOMER_ID — Foreign key → CUSTOMER.id — NOT NULL
- COUNT — bigint(20) — NOT NULL
DOCUMENT_MAIN
- id — int(11) — Primary key — NOT NULL
- ClientKey — Foreign key → CUSTOMER.id — NOT NULL
- REPORT_MASTER_ID — int(11) — Foreign key → REPORT_MASTER_INFO.ID — NOT NULL
- SearchEngine — varchar(16)
- SearchKeyword — varchar(128)
- WebPageTitle — varchar(2048)
- ArticleSubscription — varchar(8192)
- DestUrl — varchar(2048)
- UrlContentType — char(1) — NOT NULL
- PageCreationDate — datetime
- CrawleringDate — datetime
- PageSiteName — varchar(128)
- CommunityName — varchar(128)
- RejectedData — varchar(2) — NOT NULL
- ACTION_STATUS — varchar(5) — NOT NULL
- REPORTED_DATA — char(1) — NOT NULL
- REPORTED_DATE — datetime
- Collection_method — char(1) — NOT NULL
- Collection_method_M_YN — char(1) — NOT NULL
- URL_OPEN_YN — char(1) — NOT NULL
- LastModifyUserIdx — int(11)
- LastModifyDateTime — datetime
- Comment — longtext
- AlertStartDateTime — datetime
- AlertEndDateTime — datetime
- AlertAvgDateYN — char(1) — NOT NULL
- DEL_EXCEPT_YN — char(1) — NOT NULL
- COPY_ORG_ID — int(11) — NOT NULL
- LAST_REPORT_NUM — int(11) — NOT NULL
- CHANNEL_NAME — varchar(50)
- WRITE_NM — varchar(30)
- VIEW_NUM — int(11) — NOT NULL
- RECOMMEND_NUM — int(11) — NOT NULL
- REPLY_NUM — int(11) — NOT NULL
- CRAWLING_SCHEDULE_IDX — int(11)
DOCUMENT_MAIN_150000
- id — int(11) — Primary key — NOT NULL
- SearchEngine — varchar(16)
- SearchKeyword — varchar(128)
- ClientKey — varchar(10)
- WebPageTitle — varchar(2048)
- ArticleSubscription — varchar(8192)
- DestUrl — varchar(2048)
- UrlContentType — char(1) — NOT NULL
- PageCreationDate — datetime
- CrawleringDate — datetime
- PageSiteName — varchar(128)
- CommunityName — varchar(128)
- RejectedData — varchar(2) — NOT NULL
- ACTION_STATUS — varchar(5) — NOT NULL
- REPORTED_DATA — char(1) — NOT NULL
- REPORTED_DATE — datetime
- Collection_method — char(1) — NOT NULL
- Collection_method_M_YN — char(1) — NOT NULL
- URL_OPEN_YN — char(1) — NOT NULL
- LastModifyUserIdx — int(11)
- LastModifyDateTime — datetime
- Comment — longtext
- AlertStartDateTime — datetime
- AlertEndDateTime — datetime
- AlertAvgDateYN — char(1) — NOT NULL
- REPORT_MASTER_ID — int(11)
- DEL_EXCEPT_YN — char(1) — NOT NULL
- COPY_ORG_ID — int(11) — NOT NULL
- LAST_REPORT_NUM — int(11) — NOT NULL
- CHANNEL_NAME — varchar(50)
- WRITE_NM — varchar(30)
- VIEW_NUM — int(11) — NOT NULL
- RECOMMEND_NUM — int(11)
- REPLY_NUM — int(11)
DOCUMENT_REPORT_LOG
- PROGRASS_NUM — int(11) — Primary key — NOT NULL
- MAIN_ID — int(11) — Foreign key → DOCUMENT_MAIN.id — NOT NULL
- CUSTOMER_ID — Foreign key → CUSTOMER.id — NOT NULL
- START_DT — datetime — NOT NULL
- END_DT — datetime
- RE_START_DT — datetime
- RE_START_CLOSE_STATUS — char(2)
- PROCESS_KIND — varchar(10) — NOT NULL
- PROCESS_TYPE — varchar(10) — NOT NULL
- CONNECT_ACCOUNT — varchar(100)
- REFER_REASON — varchar(2) — NOT NULL
- REFER_COMMENT — varchar(60) — NOT NULL
- COMMENT — text — NOT NULL
- USE_FILES — text — NOT NULL
- CREATE_DT — datetime — NOT NULL
- CREATE_USER_IDX — int(11) — NOT NULL
- MODIFY_DT — datetime
- MODIFY_USER_IDX — int(11)
- DELETE_YN — char(1) — NOT NULL
DOCUMENT_SUB_REPORT
- REPORT_NUM — int(11) — Primary key — NOT NULL
- id — int(11) — Foreign key → DOCUMENT_MAIN.id — NOT NULL
- Writer — varchar(50)
- URL_KIND_TAG_KEYWORD — varchar(40) — NOT NULL
- EXPRESSION — text
- CALLING_CONTENTS — text
- CALLING_CONTENTS_SAMPLE_ID — int(11)
EMAIL_SENDER_NAVER_WORK
- CUSTOMER_ID — Foreign key → CUSTOMER.id — NOT NULL
- USER_IDX — int(11) — Foreign key → USER_INFO.ID — NOT NULL
- SENDER_NAME — varchar(50) — NOT NULL
IMAGE_UPLOADS
- id — int(11) — Primary key — NOT NULL
- TARGET_ID — Foreign key → CUSTOMER.id — NOT NULL
- IMAGE_DIST_ID — char(5)
- ORG_FILE_NAME — varchar(300)
- IMAGE_S3_URL — varchar(2048)
- IMAGE_COMMENT — varchar(256)
- DELETE_YN — char(1) — NOT NULL
- FIRST_IMAGE — char(1) — NOT NULL
- LAST_MODIFY_DATETIME — datetime
- LAST_MODIFY_USER_IDX — int(11)
MEMO_INFO
- id — int(10) — Primary key — NOT NULL
- KIND — varchar(5) — NOT NULL
- TITLE — varchar(100) — NOT NULL
- CONTENT — mediumtext
- LAST_MODIFY_USER_IDX — int(11) — NOT NULL
- LAST_MODIFY_DATETIME — datetime — NOT NULL
NATIONINFO
- id — int(11) — Primary key — NOT NULL
- IPADDRESS — varchar(15) — NOT NULL
- NATION_CODE — varchar(10) — NOT NULL
- NATION_FULLNAME — varchar(30) — NOT NULL
OPTION_CONFIG
- CONFIG_IDX — int(11) — Primary key — NOT NULL
- CONFIG_TYPE — int(11) — Primary key — NOT NULL
- USER_IDX — int(11) — Foreign key → USER_INFO.ID — NOT NULL
- CONFIG_TEXT — text
- ETC — varchar(50)
REPORT_CALLING_CONTENTS
- id — int(10) — Primary key — NOT NULL
- CUSTOMER_ID — Foreign key → CUSTOMER.id — NOT NULL
- KEYWORD_MODE — int(10) — NOT NULL
- KEYWORD — varchar(50) — NOT NULL
- SAMPLE_CONTENTS — text — NOT NULL
REPORT_MASTER_INFO
- ID — int(11) — Primary key — NOT NULL
- CUSTOMER_IDX — Foreign key → CUSTOMER.id — NOT NULL
- CUSTOMER_ID — varchar(11) — NOT NULL
- SITE_INFO_IDX — int(11) — Foreign key → SITE_INFO.id — NOT NULL
- RCC_IDX — int(10) — Foreign key → REPORT_CALLING_CONTENTS.id — NOT NULL
- COMMENT — text
- CreateUserIdx — int(11) — NOT NULL
- CreateDateTime — datetime — NOT NULL
- LastModifyUserIdx — int(11) — NOT NULL
- LastModifyDateTime — datetime — NOT NULL
- REPORTING_YN — char(1) — NOT NULL
- REPORTING_DT — datetime
REPORT_SITE_INFO
- ID — int(11) — Primary key — NOT NULL
- KR_NAME — varchar(50)
- H_DOMAIN — varchar(256) — NOT NULL
- REPORT_TYPE — char(2) — NOT NULL
- REPORT_SITE_WT_YN — char(1) — NOT NULL
SITE_DISTRIBUTION
- id — int(11) — Primary key — NOT NULL
- SITE_DISTRIBUTION_ID — char(4) — NOT NULL
- SITE_DISTRIBUTION_NAME_EN — varchar(32) — NOT NULL
- SITE_DISTRIBUTION_NAME_KO — varchar(32) — NOT NULL
SITE_INFO
- id — int(11) — Primary key — NOT NULL
- SITE_ID — varchar(50)
- MATCH_KEY — varchar(256) — NOT NULL
- ROOT_URL — varchar(256) — NOT NULL
- SITENAME_EN — varchar(64)
- SITENAME_KR — varchar(64)
- SITE_DISTRIBUTION_ID — varchar(5)
- SITE_IMAGE_HOR_PATH — varchar(256)
- SITE_IMAGE_RET_PATH — varchar(256)
- ALERT_URL — varchar(4096)
- ALERT_EMAIL — varchar(1024)
- CONTACT — varchar(64)
- SITE_LOCATION — varchar(8)
- COMMENT — mediumtext
- ALERT_SMOOTH_YN — char(1) — NOT NULL
- DUP_PERMIT_YN — char(1) — NOT NULL
- REPORT_TYPE — char(2)
- REPORT_TYPE_ETC — text
- REPORT_SITE_WT_YN — char(1) — NOT NULL
- EMAIL_TEMPLATE — char(2) — NOT NULL
- WT_SITE — char(2) — NOT NULL
- WT_USER — char(2) — NOT NULL
- WT_INCLUDE_YN — char(1) — NOT NULL
- ALERT_LANGUAGE — char(2) — NOT NULL
- SITE_PW — varchar(50)
- DEL_R_CNT — int(11)
SITE_INFO_DESCRIPTION
- id — int(11) — Primary key — NOT NULL
- SITE_ID — int(11) — Foreign key → SITE_INFO.id — NOT NULL
- USER_ID — int(11) — Foreign key → USER_INFO.ID — NOT NULL
- DATE — date
- SITE_DESCRIPTION — varchar(1024)
SITE_LINK_INFO
- ROOT_URL — varchar(256) — NOT NULL
- LINK_URL — varchar(256) — NOT NULL
- COMMENT — varchar(1024) — NOT NULL
SITE_LINK_LIST
- SITE_IDX — int(11) — Foreign key → SITE_INFO.id — NOT NULL
- LINK_IDX (LINK_IDX2) — int(11) — Foreign key → SITE_LINK_NAME.LINK_IDX — NOT NULL
SITE_LINK_NAME
- LINK_IDX — int(11) — Primary key — NOT NULL
- LINK_NAME — varchar(1024) — NOT NULL
- COMMENT — varchar(1024) — NOT NULL
SITE_L_DOMAIN_RXP
- SITE_IDX — int(11) — Foreign key → SITE_INFO.id — NOT NULL
- SITE_RXP — varchar(1024) — NOT NULL
SITE_TRANS
- L_DOMAIN — varchar(256) — Primary key — NOT NULL
- H_DOMAIN — varchar(256) — NOT NULL
- H_DOMAIN_KEYWORD — varchar(256)
USER_CUSTOMER_REL
- USER_IDX — int(11) — Foreign key → USER_INFO.ID — NOT NULL
- CUSTOMER_ID — Foreign key → CUSTOMER.id — NOT NULL
USER_CUSTOMER_SITE_CONNECT_REL (작업자 접속정보)
- CONNECT_IDX — Primary key — NOT NULL
- WD_IDX — int(11) — Foreign key → CUSTOMER_WD_INFO.ID — NOT NULL
- CUR_SITE_USE — char(1) — NOT NULL
- CUR_EMAIL_USE — char(1) — NOT NULL
- USER_IDX (Field)
- SITE_ID (Field2)
- CUSTOMER_ID (Field3)
USER_HOTKEY_CONDITIONS
- id — int(11) — Primary key — NOT NULL
- USER_IDX — int(11) — Foreign key → USER_INFO.ID — NOT NULL
- HOTKEY_LIST — text — NOT NULL
USER_INFO
- ID — int(11) — Primary key — NOT NULL
- USER_ID — varchar(10) — NOT NULL
- PASSWORD — varchar(150) — NOT NULL
- NAME — varchar(30) — NOT NULL
- LOGIN_FAIL_CNT — int(11) — NOT NULL
- USER_TYPE — char(2) — NOT NULL
- STATUS — char(2) — NOT NULL
- MAIN_DATA_CHK_YN — char(1) — NOT NULL
- LAST_CONNECT_DATETIME — datetime
- DELETE_YN — char(1) — NOT NULL
- TEL1 — varchar(5)
- TEL2 — varchar(5)
- BIRTH_DAY — varchar(8)
- ALL_CUSTOMER — char(1) — NOT NULL
USER_MAINDATA_CONDITIONS
- id — int(11) — Primary key — NOT NULL — 인덱스
- USER_IDX — int(11) — Foreign key → USER_INFO.ID — NOT NULL
- CONDITION_NAME — varchar(100) — NOT NULL — 조회조건리스트명
- CONDITION_LIST — text — NOT NULL — 조회조건리스트
USER_SITE_CONNECT_INFO
- ID — int(11) — Primary key — NOT NULL
- USER_IDX — int(11) — Foreign key → USER_INFO.ID — NOT NULL
- SITE_IDX — int(11) — Foreign key → SITE_INFO.id — NOT NULL
- USE_TEXT — varchar(100) — NOT NULL
- USER_KIND — char(1) — NOT NULL
- USER_COMPANY_IDX — int(11) — NOT NULL
- CONNECT_TYPE — int(11) — NOT NULL
- SITE_ID — varchar(100) — NOT NULL
- SITE_PW — varchar(100) — NOT NULL
- ALERT_EMAIL_YN — char(1) — NOT NULL
- SCRAPING_YN — char(1) — NOT NULL
- ETC — text
- SITE_KEYWORD — char(2)
- SITE_OPTION — char(2)
YOUTUBE_CHANNEL_INFO
- id — int(11) — Primary key — NOT NULL
- CHANNEL_NAME — varchar(200) — NOT NULL
- CHANNEL_KIND — varchar(5) — NOT NULL
- COMMENT — text — NOT NULL