민주화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개 테이블