민주화ERD2

테이블 (98)

AW_ILJI

  • ITEM_ID — VARCHAR2(10)
  • MAIN_TITLE — VARCHAR2(100) — NOT NULL
  • SERIES_TITLE — VARCHAR2(100)
  • PUBLISHER — VARCHAR2(100)
  • DATEISSUED — VARCHAR2(50) — 출판일정보
  • ISBN — VARCHAR2(50)
  • REG_ID — VARCHAR2(30)
  • REG_DT — DATE
  • UPT_ID — VARCHAR2(30)
  • UPT_DT — DATE
  • PUB_DT — VARCHAR2(50)

AW_ILJI_ARTICLE

  • ARTICLE_ID — VARCHAR2(20)
  • DAY_ID — VARCHAR2(20)
  • CLASS1 — VARCHAR2(100)
  • CLASS2 — VARCHAR2(100)
  • CLASS3 — VARCHAR2(100)
  • ARTICLE_TITLE — NVARCHAR2(100) — NOT NULL
  • ARTICLE_CONTENTS — NCLOB
  • REG_ID — VARCHAR2(30)
  • REG_DT — DATE
  • UPT_ID — VARCHAR2(30)
  • UPT_DT — DATE — 수정일

AW_ILJI_DAY

  • DAY_ID — VARCHAR2(20)
  • YEAR_ID — VARCHAR2(20) — NOT NULL
  • MONTH_ID — VARCHAR2(20) — NOT NULL
  • DAY_VAL — NUMBER(2,0) — NOT NULL
  • YEAR_VAL — NUMBER(4,0) — NOT NULL
  • MONTH_VAL — NUMBER(2,0) — NOT NULL
  • REG_ID — VARCHAR2(30)
  • REG_DT — DATE
  • UPT_ID — VARCHAR2(30)
  • UPT_DT — DATE — 수정일
  • ITEM_ID — VARCHAR2(10)

AW_NEWS_LT

  • SEQ — NUMBER — 기본 키 — NOT NULL
  • TITLE — VARCHAR2(4000) — NOT NULL
  • CONTENTS (CONTENT) — CLOB
  • REG_ID — VARCHAR2(32) — NOT NULL
  • REG_DT — DATE — NOT NULL
  • MOD_ID — VARCHAR2(32)
  • MOD_DT — DATE

AW_NOTICE

  • SEQ — CHAR(32) — 기본 키 — NOT NULL
  • TITLE — VARCHAR2(4000) — NOT NULL
  • CONTENTS — CLOB
  • REG_ID — VARCHAR2(32) — NOT NULL
  • REG_DT — DATE — NOT NULL
  • MOD_ID — VARCHAR2(32)
  • MOD_DT — DATE

BOOKSTACK_INFO

  • BOOKSTACK_NO — VARCHAR2(2) — 기본 키 — NOT NULL
  • BOOKSTACK_NAME — VARCHAR2(32) — NOT NULL — 서가명
  • REG_ID — VARCHAR2(32) — NOT NULL — 등록자
  • REG_DT — VARCHAR2(10) — NOT NULL — 등록일
  • MOD_ID — VARCHAR2(32) — 수정자
  • MOD_DT — VARCHAR2(10) — 수정일

CLASSIFICATION_INFO

  • DEPTH_FIRST — VARCHAR2(128) — 기본 키 — NOT NULL
  • DEPTH_SECOND — VARCHAR2(128) — 기본 키 — NOT NULL
  • DEPTH_THIRD — VARCHAR2(128) — 기본 키 — NOT NULL
  • COLLECTION_ID — VARCHAR2(10) — 기본 키 — NOT NULL
  • CLASSIFICATION_ID — VARCHAR2(10) — NOT NULL

CODE_INFO

  • CODE_ID — VARCHAR2(32) — 기본 키 — NOT NULL
  • CODE_TYPE_ID — VARCHAR2(32) — NOT NULL
  • CODE_VALUE — VARCHAR2(32) — NOT NULL
  • CODE_NAME_KO — VARCHAR2(512) — NOT NULL
  • CODE_NAME_SOURCE — VARCHAR2(512)
  • CODE_PARENT — VARCHAR2(32)
  • CODE_SUB — VARCHAR2(32)
  • CODE_CIPHER — NUMBER(10,0)
  • CODE_ORDER — NUMBER(10,0) — NOT NULL
  • CODE_DESCRIPTION — VARCHAR2(512)
  • REGISTER — VARCHAR2(32)
  • REGISTED_DATE — VARCHAR2(16)
  • LEAF_YN — CHAR(1) — NOT NULL
  • ERASE_YN — CHAR(1) — NOT NULL

COLLECTION_INFO_FL

  • COLLECTION_ID — VARCHAR2(10) — 기본 키 — NOT NULL
  • REPRESENT_REGNO — VARCHAR2(10)
  • TITLE — VARCHAR2(1024) — NOT NULL
  • CONTENT — CLOB
  • KEYWORDS — VARCHAR2(2048)
  • CONTENT_URL — VARCHAR2(4000)
  • PARENT_REGNO — VARCHAR2(10) — NOT NULL
  • SORT_CLASS_TITLE — VARCHAR2(1024)
  • IS_OPEN — VARCHAR2(32) — NOT NULL
  • REG_ID — VARCHAR2(32)
  • REG_DT — VARCHAR2(10)
  • MOD_ID — VARCHAR2(32)
  • MOD_DT — VARCHAR2(10)

COLLECT_INFO

  • COLLECT_NO — VARCHAR2(9) — 기본 키 — NOT NULL
  • CONTACTLIST_ID — VARCHAR2(10) — NOT NULL
  • DONATOR — VARCHAR2(1024) — NOT NULL
  • COLLECT_DT — VARCHAR2(16) — NOT NULL
  • COLLECT_DIV — VARCHAR2(32) — NOT NULL
  • QUANTITY — VARCHAR2(1024)
  • COLLECT_DETAIL — VARCHAR2(4000)
  • COLLECT_COND — VARCHAR2(4000)
  • CONTRACT_DT — VARCHAR2(10)
  • CONTRACTOR — VARCHAR2(256)
  • COMPENSATION — VARCHAR2(64)
  • REG_SCHEDULE — VARCHAR2(32)
  • DISUSE_CONTENT — VARCHAR2(4000)
  • DOCUMENTS_YN — CHAR(1)
  • FILMS_YN — CHAR(1)
  • IMAGES_YN — CHAR(1)
  • MUSEUMS_YN — CHAR(1)
  • REG_ID — VARCHAR2(32) — NOT NULL
  • REG_DT — VARCHAR2(10) — NOT NULL
  • MOD_ID — VARCHAR2(32)
  • MOD_DT — VARCHAR2(10)
  • MANUSCRIPT_STS — VARCHAR2(32) — NOT NULL
  • DICTATION_YN — CHAR(1)

CONTACT_INFO

  • CONTACT_NO — VARCHAR2(10) — 기본 키 — NOT NULL
  • CONTACTLIST_ID — VARCHAR2(10) — NOT NULL
  • CONTACT_DT — VARCHAR2(10) — NOT NULL
  • CHARGE_NAME — VARCHAR2(1024) — NOT NULL
  • EXAM_NAME — VARCHAR2(1024) — NOT NULL
  • CONTACT_METHOD — VARCHAR2(32) — NOT NULL
  • CONTACT_PURPOSE — VARCHAR2(32) — NOT NULL
  • REG_ID — VARCHAR2(32) — NOT NULL
  • REG_DT — VARCHAR2(10) — NOT NULL
  • MOD_ID — VARCHAR2(32)
  • MOD_DT — VARCHAR2(10)
  • CONTACT_DETAIL — CLOB

CONTACT_LIST

  • CONTACTLIST_ID — VARCHAR2(10) — 기본 키 — NOT NULL
  • LEAD_NO — VARCHAR2(10) — 외래 키 → LEAD_INFO.LEAD_NO — NOT NULL
  • CONTACT_TITLE — VARCHAR2(1024) — NOT NULL
  • REG_ID — VARCHAR2(32) — NOT NULL
  • REG_DT — VARCHAR2(10) — NOT NULL
  • MOD_ID — VARCHAR2(32)
  • MOD_DT — VARCHAR2(10)

Copy Of NOTICE (CopyOfAW_NOTICE)

  • SEQ — CHAR(32) — 기본 키 — NOT NULL
  • TITLE — VARCHAR2(4000) — NOT NULL
  • CONTENTS — CLOB
  • REG_ID — VARCHAR2(32) — NOT NULL
  • REG_DT — DATE — NOT NULL
  • MOD_ID — VARCHAR2(32)
  • MOD_DT — DATE

DICTATION_FILE_LIST

  • FILE_ID — VARCHAR2(12) — 기본 키 — NOT NULL
  • REGNO — VARCHAR2(12) — 등록번호
  • CONT_FORMAT — VARCHAR2(10) — 파일형식
  • FILE_TYPE — VARCHAR2(32) — 파일유형
  • IS_OPEN — VARCHAR2(32) — 녹취문공개여부
  • BASE_DIR — VARCHAR2(1024) — 기본경로
  • REAL_NAME — VARCHAR2(1024) — 실제파일명
  • FILE_NAME — VARCHAR2(1024) — 파일명
  • CONT_PATH — VARCHAR2(1024) — 저장경로
  • REG_ID — VARCHAR2(32) — 등록자
  • REG_DT — VARCHAR2(10) — 등록일
  • MOD_ID — VARCHAR2(32) — 수정자
  • MOD_DT — VARCHAR2(10) — 수정일

DICTATION_INFO

  • REGNO — VARCHAR2(12) — 외래 키 — NOT NULL
  • DICTATOR — VARCHAR2(500) — 구술자
  • DICTATOR_SEX — VARCHAR2(2) — 구술자
  • INTERVIEWER — VARCHAR2(500) — 면담자
  • INTERVIEW_DT — VARCHAR2(300) — 면담일
  • INTERVIEW_COUNT — VARCHAR2(300) — 면답횟수
  • COLLECTION_AREA — VARCHAR2(4000) — 수집지역
  • INTERVIEW_PLACE — VARCHAR2(4000) — 면담장소
  • ACTIVITY_AGREEMENT — VARCHAR2(10) — 활용동의
  • MAJOR_FIGURE — VARCHAR2(4000) — 주요인물
  • MEDIA_INFO — VARCHAR2(4000) — 사료매체
  • REG_ID — VARCHAR2(32) — 등록자
  • REG_DT — VARCHAR2(10) — 등록일
  • MOD_ID — VARCHAR2(32) — 수정자
  • MOD_DT — VARCHAR2(10) — 수정일

DISUSE_BOX

  • BOX_REGNO — VARCHAR2(10) — 기본 키 — NOT NULL
  • MOBILECELL_ID — VARCHAR2(10)
  • DISUSE_ID — VARCHAR2(10) — 외래 키 → DISUSE_INFO.DISUSE_ID — NOT NULL
  • BOX_TYPE — VARCHAR2(32) — NOT NULL
  • CHECKOUT — VARCHAR2(32) — NOT NULL
  • CHECKIN_NAME — VARCHAR2(128)
  • CHECKIN_DT — VARCHAR2(10)
  • CHECKOUT_NAME — VARCHAR2(128)
  • CHECKOUT_DT — VARCHAR2(10)

DISUSE_FILE

  • DISUSEFILE_NO — VARCHAR2(10) — 기본 키 — NOT NULL
  • BOX_REGNO — VARCHAR2(10) — NOT NULL
  • DISUSEFILE_TITLE — VARCHAR2(1024) — NOT NULL
  • DISUSEFILE_REASON — VARCHAR2(32) — NOT NULL
  • DISUSEFILE_RESULT — VARCHAR2(32) — NOT NULL

DISUSE_INFO

  • DISUSE_ID — VARCHAR2(10) — 기본 키 — NOT NULL
  • COLLECT_NO — VARCHAR2(9) — NOT NULL
  • DISUSE_REASON — VARCHAR2(4000)
  • DISUSE_RIGHT — VARCHAR2(4000)
  • DISUSE_PLAN — VARCHAR2(4000)
  • ETC — VARCHAR2(4000)
  • REG_ID — VARCHAR2(32) — NOT NULL
  • REG_DT — VARCHAR2(10) — NOT NULL

DISUSE_ITEM

  • DISUSEITEM_NO — VARCHAR2(10) — 기본 키 — NOT NULL
  • DISUSEFILE_NO — VARCHAR2(10) — NOT NULL
  • LEAD_NO — VARCHAR2(10)
  • COLLECT_NO — VARCHAR2(9) — NOT NULL
  • DISUSEITEM_TITLE — VARCHAR2(1024) — NOT NULL
  • DISUSEITEM_REASON — VARCHAR2(32) — NOT NULL

DOCUMENT_FILE_LIST

  • FILE_NO — VARCHAR2(12) — 기본 키 — NOT NULL
  • DOCUMENT_NO — VARCHAR2(10) — 기본 키 — NOT NULL — 서식순번
  • BASE_DIR — VARCHAR2(1024) — 기본경로
  • FILE_NAME — VARCHAR2(1024) — 파일명
  • REAL_NAME — VARCHAR2(1024) — 실제파일명
  • CONT_PATH — VARCHAR2(1024) — 저장경로
  • REG_ID — VARCHAR2(32) — 등록자
  • REG_DT — VARCHAR2(10) — 등록일
  • MOD_ID — VARCHAR2(32) — 수정자
  • MOD_DT — VARCHAR2(10) — 수정일

ISAD_CLASS

  • REGNO — VARCHAR2(10) — 기본 키 — NOT NULL
  • BOX_REGNO — VARCHAR2(10)
  • COLLECT_NO — VARCHAR2(9) — 외래 키 → COLLECT_INFO.COLLECT_NO — NOT NULL
  • OLDBOX_REGNO — VARCHAR2(10) — 외래 키 → OLDBOX_INFO.OLDBOX_REGNO — NOT NULL
  • DUP_ITEMNO — VARCHAR2(10)
  • REFERENCE_CODE — VARCHAR2(128) — NOT NULL
  • TITLE — VARCHAR2(4000) — NOT NULL
  • LEVEL_NO — VARCHAR2(32) — NOT NULL
  • CLASS_FORM — VARCHAR2(1024)
  • CLASS_TYPE — VARCHAR2(32)
  • GRADE — VARCHAR2(32)
  • QUANTITY — VARCHAR2(1024)
  • DUP_QUANTITY — VARCHAR2(1024)
  • PRODUCT_START_DT — VARCHAR2(256)
  • CREATOR — VARCHAR2(4000)
  • RECORD_HISTORY — VARCHAR2(4000)
  • DISUSE_CONTENT — VARCHAR2(4000)
  • DISUSE_SCHEDULE — VARCHAR2(1024)
  • ACCRUALS — VARCHAR2(4000)
  • ARRANGE_SYSTEM — VARCHAR2(4000)
  • REPRODUCTION — VARCHAR2(4000)
  • LANGUAGE — VARCHAR2(32)
  • PHYSICAL_INFO — VARCHAR2(4000)
  • FINDING_AIDS — VARCHAR2(4000)
  • ORIGIN_LOCATION — VARCHAR2(3000)
  • COPY_LOCATION — VARCHAR2(3000)
  • NOTE — VARCHAR2(4000)
  • ARCHIVIST_NOTE — VARCHAR2(4000)
  • RULE — VARCHAR2(4000)
  • EVENT — VARCHAR2(1024)
  • ORGANIZATION — VARCHAR2(1024)
  • PERSON — VARCHAR2(1024)
  • PLACE — VARCHAR2(1024)
  • REGION — VARCHAR2(1024)
  • FIELDS — VARCHAR2(1024)
  • MEDIA_INFO — VARCHAR2(32)
  • MEDIA_COLOR — VARCHAR2(32)
  • MEDIA_SIZE — VARCHAR2(256)
  • MEDIA_QUALITY — VARCHAR2(256)
  • PARTITION_RULE — VARCHAR2(1024)
  • PLAY_TIME — VARCHAR2(128)
  • PRESERVATION — VARCHAR2(2048)
  • REPAIR — VARCHAR2(2048)
  • PROVENANCE — VARCHAR2(2048)
  • WORK_NOTE — VARCHAR2(4000)
  • KEYWORDS — VARCHAR2(2048)
  • IS_OPEN — VARCHAR2(32) — NOT NULL
  • PARENT_REGNO — VARCHAR2(10) — NOT NULL
  • SORT_CLASS_TITLE — VARCHAR2(1024) — NOT NULL
  • SORT_CREATOR — VARCHAR2(2048)
  • SORT_PRODUCT_START_DT — VARCHAR2(256)
  • MANUSCRIPT_STS — VARCHAR2(32)
  • IS_DEL — VARCHAR2(32) — NOT NULL
  • REG_ID — VARCHAR2(32) — NOT NULL
  • REG_DT — VARCHAR2(10) — NOT NULL
  • MOD_ID — VARCHAR2(32)
  • MOD_DT — VARCHAR2(10)
  • PRODUCT_END_DT — VARCHAR2(256)
  • SORT_PRODUCT_END_DT — VARCHAR2(256)
  • DEL_REASON — VARCHAR2(1024)
  • … +10

LEAD_INFO

  • LEAD_NO — VARCHAR2(10) — 기본 키 — NOT NULL
  • LEAD_NAME — VARCHAR2(1024) — NOT NULL
  • SORT_LEAD_NAME — VARCHAR2(1024) — NOT NULL
  • LEAD_TYPE — VARCHAR2(32) — NOT NULL
  • ADDRESS — VARCHAR2(1024)
  • CONTACT_INFO — VARCHAR2(1024)
  • ACTIVITY — CLOB
  • COLLECTION_INFO — VARCHAR2(4000)
  • REG_ID — VARCHAR2(32) — NOT NULL
  • REG_DT — VARCHAR2(10) — NOT NULL
  • MOD_ID — VARCHAR2(32)
  • MOD_DT — VARCHAR2(10)

LICENSE_MANAGE_FL

  • LICENSE_NO — VARCHAR2(10) — 기본 키 — NOT NULL
  • COLLECT_NO — VARCHAR2(9) — NOT NULL
  • LICENSE_TYPE — VARCHAR2(32) — NOT NULL
  • LICENSE_KIND — VARCHAR2(32) — NOT NULL
  • COMMITTER — VARCHAR2(1024)
  • LICENSE_NUMBER — VARCHAR2(32) — NOT NULL
  • ISSUE_DT — VARCHAR2(10) — NOT NULL
  • COMMIT_STARTDT — VARCHAR2(10)
  • COMMIT_ENDDT — VARCHAR2(10)
  • REG_ID — VARCHAR2(32) — NOT NULL
  • REG_DT — VARCHAR2(10) — NOT NULL

MEDIA_REQUEST

  • REQUEST_NO — VARCHAR2(10) — 기본 키 — NOT NULL
  • REGNO — VARCHAR2(10) — NOT NULL
  • REQUEST_TYPE — VARCHAR2(32) — NOT NULL
  • REQUEST_USERID — VARCHAR2(50)
  • REQUEST_NAME — VARCHAR2(128)
  • REQUEST_BIRTHDATE — VARCHAR2(20)
  • REQUEST_EMAIL — VARCHAR2(100)
  • REQUEST_PHONE — VARCHAR2(20)
  • REQUEST_GENDER — CHAR(1)
  • REQUEST_ZIPCODE — VARCHAR2(10)
  • REQUEST_SERIALNO — VARCHAR2(32)
  • OCCUPATION_NAME — VARCHAR2(32)
  • REQUEST_CAUSE — VARCHAR2(4000)
  • CONT_FORMAT — VARCHAR2(32)
  • PAGE_TOT — NUMBER(4,0)
  • REQUEST_DT — VARCHAR2(10)
  • MAKE_DT — VARCHAR2(10)
  • MAKE_USERID — VARCHAR2(32)
  • CLASS_FORM — VARCHAR2(32)
  • REQUEST_TITLE — VARCHAR2(300)
  • REQUEST_STAT — CHAR(4)
  • REQUEST_URL — VARCHAR2(1000)
  • REQUEST_RESULT — VARCHAR2(4000)
  • SESSIONS — VARCHAR2(50)

MEDIA_TYPE

  • MEDIA_TYPE_ID — VARCHAR2(12) — 기본 키 — NOT NULL
  • REGNO — VARCHAR2(10)
  • MEDIA_TYPE — VARCHAR2(32)
  • MEDIA_COLOR — VARCHAR2(32)
  • MEDIA_SIZE — VARCHAR2(256)
  • MEDIA_QUALITY — VARCHAR2(256)
  • PARTITION_RULE — VARCHAR2(1024)
  • PLAY_TIME — VARCHAR2(128)

MOBILERACK_INFO

  • MOBILERACK_NO — VARCHAR2(10) — 기본 키 — NOT NULL
  • BOOKSTACK_NO — VARCHAR2(2) — 외래 키 → BOOKSTACK_INFO.BOOKSTACK_NO — NOT NULL
  • SIZE_ROW — NUMBER(2,0) — NOT NULL — 단수
  • SIZE_COL — NUMBER(2,0) — NOT NULL — 열수
  • REG_ID — VARCHAR2(32) — NOT NULL — 등록자
  • REG_DT — VARCHAR2(10) — NOT NULL — 등록일
  • MOD_ID — VARCHAR2(32) — 수정자
  • MOD_DT — VARCHAR2(10) — 수정일
  • MOBILERACK_NAME — VARCHAR2(200) — 모빌렉명

MOBILE_CELL

  • MOBILECELL_ID — VARCHAR2(10) — 기본 키 — NOT NULL
  • MOBILERACK_NO — VARCHAR2(10) — NOT NULL — 모빌렉번호
  • ROW_NO — NUMBER(2,0) — NOT NULL — 단
  • COL_NO — NUMBER(2,0) — NOT NULL — 열

NEWMEDIA_INFO

  • REGNO — VARCHAR2(10) — 외래 키 — NOT NULL
  • CONT_FORMAT — VARCHAR2(32) — NOT NULL
  • PAGE_TOT — NUMBER — NOT NULL
  • BASE_DIR — VARCHAR2(1024) — NOT NULL
  • FILE_NAME — VARCHAR2(1024) — NOT NULL
  • CONT_PATH — VARCHAR2(1024) — NOT NULL
  • CONT_WID — NUMBER — NOT NULL
  • CONT_HEI — NUMBER — NOT NULL
  • REG_ID — VARCHAR2(32) — NOT NULL
  • REG_DT — VARCHAR2(10) — NOT NULL

OLDBOX_INFO

  • OLDBOX_REGNO — VARCHAR2(10) — 기본 키 — NOT NULL
  • OBTAIN_NO — VARCHAR2(9) — NOT NULL
  • GIVE_NAME — VARCHAR2(1024)
  • GIVE_DT — VARCHAR2(14) — NOT NULL
  • ARCH_DIV — VARCHAR2(256)
  • LIB_DIV — VARCHAR2(256)
  • LIB_NO — VARCHAR2(5)
  • MOBILERACK_NO — VARCHAR2(10) — NOT NULL
  • BOX_TXT — VARCHAR2(4000)
  • MUCH_TXT — VARCHAR2(4000)
  • NOTE_TXT — VARCHAR2(4000)
  • JOB_TXT — VARCHAR2(4000)
  • DISUSE_STS — VARCHAR2(5)
  • REG_ID — VARCHAR2(256) — NOT NULL
  • REG_DT — VARCHAR2(10) — NOT NULL
  • MOD_ID — VARCHAR2(256)
  • MOD_DT — VARCHAR2(10)

QUERY_PARAMETER

  • PARAMETER_ID — VARCHAR2(10) — 기본 키 — NOT NULL
  • QUERY_ID — VARCHAR2(10)
  • PARAMETER_TYPE — VARCHAR2(128)
  • PARAMETER_ORDER — VARCHAR2(10)
  • COMPONENT_TYPE — VARCHAR2(30)
  • PARAMETE_NAME — VARCHAR2(128)
  • SUB_QUERY — VARCHAR2(4000)

READ_FILE_LIST

  • FILE_SEQ — VARCHAR2(12) — 기본 키 — NOT NULL
  • READ_NO — VARCHAR2(12) — 외래 키 → READ_INFO.READ_NO — NOT NULL
  • CONT_FORMAT — VARCHAR2(32) — 파일형식
  • BASE_DIR — VARCHAR2(1024) — 기본경로
  • FILE_NAME — VARCHAR2(1024) — 파일명
  • REAL_NAME — VARCHAR2(1024) — 실제파일명
  • CONT_PATH — VARCHAR2(1024) — 저장경로
  • REG_ID — VARCHAR2(32) — 등록자
  • REG_DT — VARCHAR2(10) — 등록일
  • MOD_ID — VARCHAR2(32) — 수정자
  • MOD_DT — VARCHAR2(10) — 수정일

READ_INFO

  • READ_NO — VARCHAR2(12) — 기본 키 — NOT NULL
  • READ_TYPE — VARCHAR2(32) — 열람구분
  • TITLE — VARCHAR2(500) — 제목
  • APPLICATION_DT — VARCHAR2(10) — 신청일자
  • APPLICANT_TYPE — VARCHAR2(32) — 신청자구분
  • APPLICANT — VARCHAR2(500) — 신청자명
  • MANAGER — VARCHAR2(500) — 담당자명
  • BLONG — VARCHAR2(1000) — 소속
  • ADDRESS — VARCHAR2(1000) — 주소
  • PHONE — VARCHAR2(20) — 연락처
  • READ_REASON — VARCHAR2(4000) — 열람목적
  • RENTAL_REASON — VARCHAR2(4000) — 대여목적
  • READ_DT — VARCHAR2(10) — 열람일
  • RENTAL_START_DT — VARCHAR2(10) — 대여시작일
  • RENTAL_END_DT — VARCHAR2(10) — 대여만기일
  • EXPORT_DT — VARCHAR2(10) — 반출일
  • IMPORT_DT — VARCHAR2(10) — 반입일
  • REG_ID — VARCHAR2(32) — 등록자
  • REG_DT — VARCHAR2(10) — 등록일
  • MOD_ID — VARCHAR2(32) — 수정자
  • MOD_DT — VARCHAR2(10) — 수정일

READ_LIST

  • REGNO — VARCHAR2(10) — 외래 키 → ISAD_CLASS.REGNO — NOT NULL — 사료등록번호
  • READ_NO — VARCHAR2(12) — 외래 키 → READ_INFO.READ_NO — NOT NULL
  • REG_ID — VARCHAR2(32) — 등록자
  • REG_DT — VARCHAR2(10) — 등록일
  • MOD_ID — VARCHAR2(32) — 수정자
  • MOD_DT — VARCHAR2(10) — 수정일

REFERENCE_URL_FL

  • URL_ID — VARCHAR2(10) — 기본 키 — NOT NULL
  • COLLECTION_ID — VARCHAR2(10)
  • URL_TITLE — VARCHAR2(1024)
  • REFERENCE_URL — VARCHAR2(4000)

RELATION_ISAD_FL

  • RELATION_ID — VARCHAR2(10) — 기본 키 — NOT NULL
  • COLLECTION_ID — VARCHAR2(10) — 외래 키 → COLLECTION_INFO_FL.COLLECTION_ID — NOT NULL
  • REGNO — VARCHAR2(10) — 외래 키 → ISAD_CLASS.REGNO — NOT NULL
  • RELATION_TYPE — VARCHAR2(10) — NOT NULL
  • PRIMARY_ISAD — CHAR(1)

ROLEGROUP_LIST_FL

  • ROLEGROUP_ID — VARCHAR2(10) — 기본 키 — NOT NULL
  • GROUP_ID — VARCHAR2(10)
  • ROLE_ID — VARCHAR2(10)

SRCH_CATEGORY_RANKING_KEYWORD

  • COLLECTION_ID — VARCHAR2(32) — 기본 키 — NOT NULL
  • PROFILE_ID — VARCHAR2(32) — 기본 키 — NOT NULL
  • KEYWORD — VARCHAR2(50) — 기본 키 — NOT NULL
  • CATEGORIES — NUMBER(10,0)
  • REG_DATE — TIMESTAMP
  • APPLY — CHAR(1) — NOT NULL

SRCH_CATEGORY_UPDATE_SETTING

  • CATUPDATE_ID — VARCHAR2(32) — 기본 키 — NOT NULL
  • COLLECTION_ID — VARCHAR2(32) — 기본 키 — NOT NULL
  • FIELD — VARCHAR2(32) — 기본 키 — NOT NULL
  • START_DATE — TIMESTAMP — NOT NULL
  • END_DATE — TIMESTAMP
  • PERIOD — NUMBER(19,0) — NOT NULL
  • ENABLE — CHAR(1) — NOT NULL

SRCH_CLIENT

  • IP — VARCHAR2(15) — 기본 키 — NOT NULL
  • DESCRIPTION — VARCHAR2(255)
  • CREATED — TIMESTAMP
  • CREATOR — VARCHAR2(20)
  • LAST_UPDATED — TIMESTAMP
  • LAST_UPDATOR — VARCHAR2(20)

SRCH_COLLECTION_CATEGORY

  • COLLECTION_ID — VARCHAR2(32) — 기본 키 — NOT NULL
  • FIELD — VARCHAR2(32) — 기본 키 — NOT NULL
  • CATEGORY — VARCHAR2(255) — 기본 키 — NOT NULL

SRCH_COLLECTION_CATEGORYFIELD

  • COLLECTION_ID — VARCHAR2(32) — 기본 키 — NOT NULL
  • FIELD — VARCHAR2(32) — 기본 키 — NOT NULL

SRCH_COLLECTION_MONITOR

  • COLLECTION_ID — VARCHAR2(32) — 기본 키 — NOT NULL
  • COLLECTION_STATUS — CHAR(1) — NOT NULL
  • COLLECTION_STATUS_PRE — CHAR(1) — NOT NULL
  • LAST_MODIFIED_DATE — TIMESTAMP — NOT NULL

SRCH_DOCUMENT_RANKING

  • COLLECTION_ID — VARCHAR2(32) — 기본 키 — NOT NULL
  • PROFILE_ID — VARCHAR2(32) — 기본 키 — NOT NULL
  • KEYWORD — VARCHAR2(50) — 기본 키 — NOT NULL
  • DOC_ID — VARCHAR2(255) — 기본 키 — NOT NULL
  • TYPE — CHAR(1) — NOT NULL
  • RANK — NUMBER(10,0)
  • START_DATE — TIMESTAMP
  • END_DATE — TIMESTAMP
  • REG_DATE — TIMESTAMP
  • APPLY — CHAR(1) — NOT NULL

SRCH_DOCUMENT_RANKING_KEYWORD

  • COLLECTION_ID — VARCHAR2(32) — 기본 키 — NOT NULL
  • PROFILE_ID — VARCHAR2(32) — 기본 키 — NOT NULL
  • KEYWORD — VARCHAR2(50) — 기본 키 — NOT NULL
  • DOCUMENTS — NUMBER(10,0)
  • REG_DATE — TIMESTAMP
  • APPLY — CHAR(1) — NOT NULL

SRCH_ERROR_LOG

  • ERROR_ID — NUMBER(10,0) — 기본 키 — NOT NULL
  • SERVER_GROUP — NUMBER(10,0) — NOT NULL
  • SERVER_ID — NUMBER(10,0) — NOT NULL
  • SERVER_NAME — VARCHAR2(32) — NOT NULL
  • SERVER_IP — VARCHAR2(15) — NOT NULL
  • REPORTED_TIME — TIMESTAMP — NOT NULL
  • ERROR_LEVEL — NUMBER(1,0)
  • ERROR_MESSAGE — VARCHAR2(4000)
  • SERVICE_STACK — VARCHAR2(4000)
  • RAW_STACK — VARCHAR2(4000)

SRCH_FEEDBACK_FUNCTION

  • FUNCTION_ID — VARCHAR2(10) — 기본 키 — NOT NULL
  • FUNCTION_NAME — VARCHAR2(50)
  • DESCRIPTION — VARCHAR2(1000)

SRCH_FEEDBACK_KEYWORD

  • KEYWORD — VARCHAR2(50) — 기본 키 — NOT NULL
  • REG_DATE — TIMESTAMP
  • APPLY — CHAR(1) — NOT NULL

SRCH_FEEDBACK_STATISTICS_DAILY

  • COLLECTION_NAME — VARCHAR2(32) — 기본 키 — NOT NULL
  • PROFILE_NAME — VARCHAR2(32) — 기본 키 — NOT NULL
  • KEYWORD — VARCHAR2(50) — 기본 키 — NOT NULL
  • UNIT — NUMBER(15,0) — 기본 키 — NOT NULL
  • FUNCTION01_CNT — NUMBER(10,0)
  • FUNCTION02_CNT — NUMBER(10,0)
  • FUNCTION03_CNT — NUMBER(10,0)
  • FUNCTION04_CNT — NUMBER(10,0)
  • FUNCTION05_CNT — NUMBER(10,0)
  • FUNCTION06_CNT — NUMBER(10,0)
  • FUNCTION07_CNT — NUMBER(10,0)
  • FUNCTION08_CNT — NUMBER(10,0)
  • FUNCTION09_CNT — NUMBER(10,0)
  • FUNCTION10_CNT — NUMBER(10,0)
  • FUNCTION11_CNT — NUMBER(10,0)
  • FUNCTION12_CNT — NUMBER(10,0)
  • FUNCTION13_CNT — NUMBER(10,0)
  • FUNCTION14_CNT — NUMBER(10,0)
  • FUNCTION15_CNT — NUMBER(10,0)
  • FUNCTION16_CNT — NUMBER(10,0)
  • FUNCTION17_CNT — NUMBER(10,0)
  • FUNCTION18_CNT — NUMBER(10,0)
  • FUNCTION19_CNT — NUMBER(10,0)
  • FUNCTION20_CNT — NUMBER(10,0)
  • REG_DATE — TIMESTAMP

SRCH_FEEDBACK_STATISTICS_MONTH

  • COLLECTION_NAME — VARCHAR2(32) — 기본 키 — NOT NULL
  • PROFILE_NAME — VARCHAR2(32) — 기본 키 — NOT NULL
  • KEYWORD — VARCHAR2(50) — 기본 키 — NOT NULL
  • UNIT — NUMBER(15,0) — 기본 키 — NOT NULL
  • FUNCTION01_CNT — NUMBER(10,0)
  • FUNCTION02_CNT — NUMBER(10,0)
  • FUNCTION03_CNT — NUMBER(10,0)
  • FUNCTION04_CNT — NUMBER(10,0)
  • FUNCTION05_CNT — NUMBER(10,0)
  • FUNCTION06_CNT — NUMBER(10,0)
  • FUNCTION07_CNT — NUMBER(10,0)
  • FUNCTION08_CNT — NUMBER(10,0)
  • FUNCTION09_CNT — NUMBER(10,0)
  • FUNCTION10_CNT — NUMBER(10,0)
  • FUNCTION11_CNT — NUMBER(10,0)
  • FUNCTION12_CNT — NUMBER(10,0)
  • FUNCTION13_CNT — NUMBER(10,0)
  • FUNCTION14_CNT — NUMBER(10,0)
  • FUNCTION15_CNT — NUMBER(10,0)
  • FUNCTION16_CNT — NUMBER(10,0)
  • FUNCTION17_CNT — NUMBER(10,0)
  • FUNCTION18_CNT — NUMBER(10,0)
  • FUNCTION19_CNT — NUMBER(10,0)
  • FUNCTION20_CNT — NUMBER(10,0)
  • REG_DATE — TIMESTAMP

SRCH_FEEDBACK_STATISTICS_WEEK

  • COLLECTION_NAME — VARCHAR2(32) — 기본 키 — NOT NULL
  • PROFILE_NAME — VARCHAR2(32) — 기본 키 — NOT NULL
  • KEYWORD — VARCHAR2(50) — 기본 키 — NOT NULL
  • UNIT — NUMBER(15,0) — 기본 키 — NOT NULL
  • FUNCTION01_CNT — NUMBER(10,0)
  • FUNCTION02_CNT — NUMBER(10,0)
  • FUNCTION03_CNT — NUMBER(10,0)
  • FUNCTION04_CNT — NUMBER(10,0)
  • FUNCTION05_CNT — NUMBER(10,0)
  • FUNCTION06_CNT — NUMBER(10,0)
  • FUNCTION07_CNT — NUMBER(10,0)
  • FUNCTION08_CNT — NUMBER(10,0)
  • FUNCTION09_CNT — NUMBER(10,0)
  • FUNCTION10_CNT — NUMBER(10,0)
  • FUNCTION11_CNT — NUMBER(10,0)
  • FUNCTION12_CNT — NUMBER(10,0)
  • FUNCTION13_CNT — NUMBER(10,0)
  • FUNCTION14_CNT — NUMBER(10,0)
  • FUNCTION15_CNT — NUMBER(10,0)
  • FUNCTION16_CNT — NUMBER(10,0)
  • FUNCTION17_CNT — NUMBER(10,0)
  • FUNCTION18_CNT — NUMBER(10,0)
  • FUNCTION19_CNT — NUMBER(10,0)
  • FUNCTION20_CNT — NUMBER(10,0)
  • REG_DATE — TIMESTAMP

SRCH_FEEDBACK_URL

  • URL — VARCHAR2(255) — 기본 키 — NOT NULL
  • REG_DATE — TIMESTAMP

SRCH_INDEX_JOB

  • JOB_ID — NUMBER(10,0) — 기본 키 — NOT NULL
  • ENABLE — CHAR(1)
  • JOB_TYPE — CHAR(1)
  • COLLECTION_ID — VARCHAR2(32)
  • INDEX_CYCLE — NUMBER(19,0)
  • START_DATE — TIMESTAMP
  • CREATED — TIMESTAMP — NOT NULL
  • LAST_UPDATED — TIMESTAMP — NOT NULL
  • EXECUTOR — VARCHAR2(20)
  • LIMIT_ENABLE — CHAR(1)
  • LIMIT_START — NUMBER(19,0)
  • LIMIT_END — NUMBER(19,0)

SRCH_INDEX_LOG

  • COLLECTION_ID — VARCHAR2(32) — 기본 키 — NOT NULL
  • INDEXING_TYPE — CHAR(1) — 기본 키 — NOT NULL
  • STARTED — TIMESTAMP — 기본 키 — NOT NULL
  • NANO_TIME — NUMBER(19,0) — 기본 키 — NOT NULL
  • EXECUTION_TYPE — CHAR(1) — NOT NULL
  • STATUS — CHAR(1) — NOT NULL
  • INSERT_COLLECTED — NUMBER(10,0) — NOT NULL
  • UPDATE_COLLECTED — NUMBER(10,0) — NOT NULL
  • DELETE_COLLECTED — NUMBER(10,0) — NOT NULL
  • INSERTED — NUMBER(10,0) — NOT NULL
  • UPDATED — NUMBER(10,0) — NOT NULL
  • DELETED — NUMBER(10,0) — NOT NULL
  • SERVICEABLE — NUMBER(10,0) — NOT NULL
  • TOTAL_INDEXED — NUMBER(10,0) — NOT NULL
  • ENDED — TIMESTAMP — NOT NULL
  • COLLECTION_STARTED — TIMESTAMP — NOT NULL
  • COLLECTION_ENDED — TIMESTAMP — NOT NULL
  • REPOSITORY_STARTED — TIMESTAMP — NOT NULL
  • REPOSITORY_ENDED — TIMESTAMP — NOT NULL
  • INDEXING_STARTED — TIMESTAMP — NOT NULL
  • INDEXING_ENDED — TIMESTAMP — NOT NULL

SRCH_JOB_LOG

  • JOB_ID — NUMBER(10,0) — 기본 키 — NOT NULL
  • JOB_DESCRIPTION — VARCHAR2(255)
  • JOB_STATUS — CHAR(1) — NOT NULL
  • JOB_ENABLE — CHAR(1) — NOT NULL
  • REQUEST_MESSAGE — BLOB
  • RESPONSE_CODE — CHAR(1)
  • RESPONSE_MESSAGE — VARCHAR2(1024)
  • CREATED — NUMBER(19,0) — NOT NULL
  • LAST_UPDATED — NUMBER(19,0) — NOT NULL
  • EXECUTOR — VARCHAR2(32)

SRCH_KEYWORD_PROFILE

  • COLLECTION_ID — VARCHAR2(32) — 기본 키 — NOT NULL
  • KEYWORD — VARCHAR2(50) — 기본 키 — NOT NULL
  • PROFILE_NAME — VARCHAR2(32) — NOT NULL
  • REG_DATE — TIMESTAMP
  • APPLY — CHAR(1) — NOT NULL

SRCH_MAX_FREQ_KEYWORD

  • COLLECTION_ID — VARCHAR2(32) — 기본 키 — NOT NULL
  • FIELD — VARCHAR2(32) — 기본 키 — NOT NULL
  • KEYWORD — VARCHAR2(255) — 기본 키 — NOT NULL
  • REGISTERED — TIMESTAMP — 기본 키 — NOT NULL
  • RANK — NUMBER(10,0) — NOT NULL
  • OCCURRED — NUMBER(10,0) — NOT NULL

SRCH_MEMBER

  • USER_ID — VARCHAR2(32) — 기본 키 — NOT NULL
  • NAME — VARCHAR2(32)
  • PASSWORD — VARCHAR2(160)
  • AUTH_SYSTEM_REPORT — CHAR(1)
  • AUTH_SERVER_MNG — CHAR(1)
  • AUTH_ERRORREPORT_MNG — CHAR(1)
  • AUTH_COLLECTION_REPORT — CHAR(1)
  • AUTH_COLLECTION_MNG — CHAR(1)
  • AUTH_INDEX_LOG — CHAR(1)
  • AUTH_SEARCH_REPORT — CHAR(1)
  • AUTH_POPKEYWORD_MNG — CHAR(1)
  • AUTH_SEARCH_LOG — CHAR(1)
  • AUTH_SEARCH_USABILITY — CHAR(1)
  • AUTH_SEARCHPROFILE_MNG — CHAR(1)
  • AUTH_QUERYSET_MNG — CHAR(1)
  • AUTH_KEYWORDPROFILEDIC_MNG — CHAR(1)
  • AUTH_TOTALDIC_MNG — CHAR(1)
  • AUTH_EQ_THESAURUSDIC_MNG — CHAR(1)
  • AUTH_QS_THESAURUSDIC_MNG — CHAR(1)
  • AUTH_STOPWORDDIC_MNG — CHAR(1)
  • AUTH_BANNEDWORDDIC_MNG — CHAR(1)
  • AUTH_USERDIC_MNG — CHAR(1)
  • AUTH_USERCNDIC_MNG — CHAR(1)
  • AUTH_USERCNSUBDIC_MNG — CHAR(1)
  • AUTH_REDIRECTDIC_MNG — CHAR(1)
  • AUTH_RECOMMENDDIC_MNG — CHAR(1)
  • AUTH_CATEGORYRANKDIC_MNG — CHAR(1)
  • AUTH_CATEGORYUPDATE — CHAR(1)
  • AUTH_DOCUMENTRANKDIC_MNG — CHAR(1)
  • AUTH_RECOMMENDSYSTEM_MNG — CHAR(1)
  • AUTH_RECOMMEND_DATA_VIEW — CHAR(1)
  • AUTH_LOGSETTING_MNG — CHAR(1)
  • AUTH_JOBLOG — CHAR(1)
  • AUTH_NOTICELOG — CHAR(1)
  • AUTH_JOBLIST_MNG — CHAR(1)
  • AUTH_ACCOUNT_MNG — CHAR(1)
  • AUTH_CONNECT_MNG — CHAR(1)
  • AUTH_MANAGERTOOL_MNG — CHAR(1)
  • COLLECTION_AUTHORITY — BLOB
  • DESCRIPTION — VARCHAR2(255)
  • CREATED — TIMESTAMP
  • UPDATED — TIMESTAMP
  • IS_CONNECTED — CHAR(1)
  • LOGIN_FAIL_CNT — NUMBER(10,0)
  • PASSWORD_UPDATED — TIMESTAMP

SRCH_NOTICE_LOG

  • REPORT_ID — NUMBER(10,0) — 기본 키 — NOT NULL
  • DESCRIPTION — VARCHAR2(4000) — NOT NULL
  • REDIRECT — VARCHAR2(255) — NOT NULL
  • REPORTED_TIME — TIMESTAMP — NOT NULL

SRCH_PAGE_AUTHORITY

  • PAGE_NAME — VARCHAR2(50) — 기본 키 — NOT NULL
  • BUSINESS_ID — NUMBER(10,0)
  • AUTH_LEVEL — CHAR(1)
  • EXPLANATION — VARCHAR2(255)

SRCH_QUERY_LOG_FAIL

  • COLLECTION_ID — VARCHAR2(32) — 기본 키 — NOT NULL
  • PROFILE — VARCHAR2(32) — 기본 키 — NOT NULL
  • KEYWORDS — VARCHAR2(255) — 기본 키 — NOT NULL
  • REGISTERED — TIMESTAMP — 기본 키 — NOT NULL
  • REQUESTED — NUMBER — NOT NULL
  • DURATION — NUMBER(19,0) — NOT NULL

SRCH_QUERY_LOG_FULL

  • COLLECTION_ID — VARCHAR2(32) — NOT NULL
  • PROFILE — VARCHAR2(32) — NOT NULL
  • KEYWORDS — VARCHAR2(255) — NOT NULL
  • ANALYZED_RESULTS — VARCHAR2(255) — NOT NULL
  • USER_NAME — VARCHAR2(32)
  • EXTRA_DATA — VARCHAR2(255)
  • CACHED — CHAR(1) — NOT NULL
  • TOTAL_RESULT_SIZE — NUMBER(10,0) — NOT NULL
  • ERROR_CODE — NUMBER(10,0) — NOT NULL
  • RESPONSE_TIME — NUMBER(10,0) — NOT NULL
  • REGISTERED — TIMESTAMP — NOT NULL
  • NANO_TIME — NUMBER(19,0) — NOT NULL

SRCH_QUERY_LOG_POPULAR

  • COLLECTION_ID — VARCHAR2(32) — 기본 키 — NOT NULL
  • PROFILE — VARCHAR2(32) — 기본 키 — NOT NULL
  • KEYWORDS — VARCHAR2(255) — 기본 키 — NOT NULL
  • REGISTERED — TIMESTAMP — 기본 키 — NOT NULL
  • REQUESTED — NUMBER — NOT NULL
  • DURATION — NUMBER(19,0) — NOT NULL

SRCH_QUERY_LOG_STATS

  • COLLECTION_ID — VARCHAR2(32) — 기본 키 — NOT NULL
  • PROFILE — VARCHAR2(32) — 기본 키 — NOT NULL
  • SERVER — VARCHAR2(32) — 기본 키 — NOT NULL
  • REGISTERED — TIMESTAMP — 기본 키 — NOT NULL
  • REQUESTED — NUMBER — NOT NULL
  • RESPONSE_TIME — NUMBER(10,0) — NOT NULL
  • RESPONSE_TIME_0 — NUMBER(10,0) — NOT NULL
  • RESPONSE_TIME_1 — NUMBER(10,0) — NOT NULL
  • RESPONSE_TIME_2 — NUMBER(10,0) — NOT NULL
  • RESPONSE_TIME_3 — NUMBER(10,0) — NOT NULL
  • RESPONSE_TIME_4 — NUMBER(10,0) — NOT NULL
  • RESPONSE_TIME_5 — NUMBER(10,0) — NOT NULL
  • RESPONSE_TIME_6 — NUMBER(10,0) — NOT NULL
  • RESPONSE_TIME_7 — NUMBER(10,0) — NOT NULL
  • RESPONSE_TIME_8 — NUMBER(10,0) — NOT NULL
  • RESPONSE_TIME_9 — NUMBER(10,0) — NOT NULL
  • RESPONSE_TIME_10 — NUMBER(10,0) — NOT NULL
  • CACHE_HIT — NUMBER — NOT NULL
  • CACHE_REQUESTED — NUMBER — NOT NULL
  • DAYZ — NUMBER(10,0) — NOT NULL
  • HOURZ — NUMBER(10,0) — NOT NULL
  • MINUTEZ — NUMBER(10,0) — NOT NULL
  • DURATION — NUMBER(19,0) — NOT NULL

SRCH_RANKING_MODEL

  • COLLECTION_ID — VARCHAR2(32) — 기본 키 — NOT NULL
  • PROFILE_ID — VARCHAR2(32) — 기본 키 — NOT NULL
  • FIELD_ID — VARCHAR2(32) — 기본 키 — NOT NULL
  • FIELD_TYPE — CHAR(1) — 기본 키 — NOT NULL
  • WEIGHT — NUMBER(10,0)
  • ENABLE — CHAR(1) — NOT NULL

SRCH_RECOMMEND

  • COLLECTION_ID — VARCHAR2(32) — 기본 키 — NOT NULL
  • PROFILE_ID — VARCHAR2(32) — 기본 키 — NOT NULL
  • KEYWORD — VARCHAR2(50) — 기본 키 — NOT NULL
  • RECOMMEND_COUNT — NUMBER(10,0)
  • RECOMMEND_LIST — VARCHAR2(255)
  • REG_DATE — TIMESTAMP
  • APPLY — CHAR(1) — NOT NULL

SRCH_RECOMMEND_UPDATE_SETTING

  • UPDATE_ID — VARCHAR2(32) — 기본 키 — NOT NULL
  • COLLECTION_ID — VARCHAR2(32) — 기본 키 — NOT NULL
  • TYPE — CHAR(1) — NOT NULL
  • MAX_NEIGHBOR — NUMBER(10,0) — NOT NULL
  • MIN_CLK_CNT — NUMBER(10,0) — NOT NULL
  • START_DATE — TIMESTAMP — NOT NULL
  • PERIOD — NUMBER(19,0) — NOT NULL
  • ENABLE — CHAR(1) — NOT NULL

SRCH_REDIRECT

  • COLLECTION_ID — VARCHAR2(32) — 기본 키 — NOT NULL
  • PROFILE_ID — VARCHAR2(32) — 기본 키 — NOT NULL
  • THEME_TITLE — VARCHAR2(50) — 기본 키 — NOT NULL
  • KEYWORD — VARCHAR2(255) — NOT NULL
  • AUTHOR — VARCHAR2(32)
  • START_DATE — NUMBER(19,0)
  • END_DATE — NUMBER(19,0)
  • REDIRECT_URL — LONG
  • REG_DATE — TIMESTAMP
  • APPLY — CHAR(1) — NOT NULL

SRCH_SCHEDULE_TASK

  • TASK_NAME — VARCHAR2(50) — 기본 키 — NOT NULL
  • TASK_TYPE — CHAR(1)
  • TASK_CMD — VARCHAR2(255)
  • TASK_PARAM — VARCHAR2(255)
  • TASK_STATUS — CHAR(1)
  • SCHEDULE_START_DATE — TIMESTAMP
  • SCHEDULE_END_DATE — TIMESTAMP
  • SCHEDULE_PERIOD — NUMBER(19,0)
  • RESPONSE_CODE — CHAR(50)
  • USE_YN — CHAR(1)
  • RUN_START_TIME — TIMESTAMP
  • RUN_END_TIME — TIMESTAMP
  • CREATED — TIMESTAMP
  • UPDATED — TIMESTAMP

SRCH_SERVER_LOG

  • SERVER — VARCHAR2(32) — 기본 키 — NOT NULL
  • REGISTERED — TIMESTAMP — 기본 키 — NOT NULL
  • DENIAL — NUMBER — NOT NULL
  • ERRORS — NUMBER — NOT NULL
  • SPACE_USED — NUMBER — NOT NULL
  • SPACE_REMAIN — NUMBER — NOT NULL
  • CPU_USAGE — NUMBER — NOT NULL
  • MEMORY_USED — NUMBER — NOT NULL
  • SPACE_USED_BY_IR — NUMBER — NOT NULL
  • CPU_USAGE_BY_IR — NUMBER — NOT NULL
  • MEMORY_MAX_BY_IR — NUMBER — NOT NULL
  • MEMORY_TOTAL_BY_IR — NUMBER — NOT NULL
  • MEMORY_USED_BY_IR — NUMBER — NOT NULL
  • DISK_READ — NUMBER — NOT NULL
  • DISK_WRITE — NUMBER — NOT NULL
  • CONNECTIONS — NUMBER — NOT NULL
  • DAYZ — NUMBER(10,0) — NOT NULL
  • HOURZ — NUMBER(10,0) — NOT NULL
  • MINUTEZ — NUMBER(10,0) — NOT NULL

SRCH_STOPWORD

  • COLLECTION_ID — VARCHAR2(32) — 기본 키 — NOT NULL
  • PROFILE_ID — VARCHAR2(32) — 기본 키 — NOT NULL
  • FIELD — VARCHAR2(32) — 기본 키 — NOT NULL
  • KEYWORD — VARCHAR2(50) — 기본 키 — NOT NULL
  • REG_DATE — TIMESTAMP
  • APPLY — CHAR(1) — NOT NULL

SRCH_TEST_QUERY

  • COLLECTION_ID — VARCHAR2(32) — 기본 키 — NOT NULL
  • QUERY_ID — VARCHAR2(32) — 기본 키 — NOT NULL
  • TITLE — VARCHAR2(32)
  • SUMMARY — VARCHAR2(32)
  • THUMBNAIL — VARCHAR2(32)
  • DISPLAY_REMOVED — CHAR(1)
  • QUERY — BLOB
  • REG_DATE — TIMESTAMP

SRCH_THESAURUS

  • COLLECTION_ID — VARCHAR2(32) — 기본 키 — NOT NULL
  • PROFILE_ID — VARCHAR2(32) — 기본 키 — NOT NULL
  • THESAURUS_ID — CHAR(1) — 기본 키 — NOT NULL
  • KEYWORD — VARCHAR2(50) — 기본 키 — NOT NULL
  • THESAURUS_COUNT — NUMBER(10,0)
  • THESAURUS_LIST — VARCHAR2(255)
  • REG_DATE — TIMESTAMP
  • APPLY — CHAR(1) — NOT NULL

SRCH_TRENDS_DELETE

  • TRENDS_ID — VARCHAR2(32) — 기본 키 — NOT NULL
  • KEYWORD — VARCHAR2(255) — 기본 키 — NOT NULL

SRCH_TRENDS_KEYWORD

  • TRENDS_ID — VARCHAR2(32) — 기본 키 — NOT NULL
  • KEYWORD — VARCHAR2(255) — 기본 키 — NOT NULL
  • RANKING — NUMBER(10,0) — NOT NULL
  • PREV_RANK — NUMBER(10,0) — NOT NULL
  • REQUESTED — NUMBER(10,0) — NOT NULL
  • FIXED_YN — CHAR(1) — NOT NULL

SRCH_TRENDS_SETTING

  • TRENDS_ID — VARCHAR2(32) — 기본 키 — NOT NULL
  • TARGET — VARCHAR2(4000) — NOT NULL
  • CAPACITY — NUMBER(10,0) — NOT NULL
  • TERM — NUMBER(19,0) — NOT NULL
  • START_DATE — TIMESTAMP — NOT NULL
  • PERIOD — NUMBER(19,0) — NOT NULL
  • ENABLE — CHAR(1) — NOT NULL
  • USE_GLOBAL_DEL — CHAR(1) — NOT NULL

SRCH_USER_CNDIC

  • KEYWORD — VARCHAR2(50) — 기본 키 — NOT NULL
  • REG_DATE — TIMESTAMP
  • APPLY — CHAR(1) — NOT NULL

SRCH_USER_CNSUBDIC

  • KEYWORD — VARCHAR2(255) — 기본 키 — NOT NULL
  • CNSUBNOUN_COUNT — NUMBER(10,0) — NOT NULL
  • CNSUBNOUN_LIST — VARCHAR2(1000)
  • REG_DATE — TIMESTAMP
  • APPLY — CHAR(1) — NOT NULL

SRCH_USER_DIC

  • KEYWORD — VARCHAR2(50) — 기본 키 — NOT NULL
  • REG_DATE — TIMESTAMP
  • APPLY — CHAR(1) — NOT NULL

SRCH_WEB_MANAGER_PROPERTY

  • KEYY — VARCHAR2(255) — 기본 키 — NOT NULL
  • VALUEE — VARCHAR2(4000) — NOT NULL

STATISTIC

  • SEQ — NUMBER
  • FIRST_CATEGORY — VARCHAR2(200 CHAR)
  • SECOND_CATEGORY — VARCHAR2(200 CHAR) — 중분류
  • THIRD_CATEGORY — VARCHAR2(200 CHAR)
  • VALUE — VARCHAR2(200 CHAR)
  • REG_ID — VARCHAR2(200 CHAR)
  • REG_DT — DATE

외 18개 테이블