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