amsdb

Tables (96)

ACCESS_LOG

  • USER_UUID — CHAR(32)
  • REGNO — VARCHAR2(20) — NOT NULL
  • URL — VARCHAR2(100) — NOT NULL
  • REG_DT — DATE

ADMIN_USER_INFO

  • USER_UUID — CHAR(32) — Primary key — NOT NULL
  • USER_ID — VARCHAR2(100) — NOT NULL
  • USER_NAME — VARCHAR2(200) — NOT NULL
  • USER_PASSWD — VARCHAR2(200) — NOT NULL
  • USER_ROLE — VARCHAR2(20) — NOT NULL
  • USER_REGDATE — DATE — NOT NULL
  • USER_MAIL — VARCHAR2(200)

AW_ACCOUNT_CLOSE

  • SEQ — NUMBER
  • USER_UUID — CHAR(32)
  • USER_EMAIL — VARCHAR2(200)
  • CONTENT — VARCHAR2(4000)
  • REG_DT — DATE

AW_CATEGORY

  • Key (SEQ) — NUMBER — Primary key — NOT NULL
  • P_SEQ — NUMBER
  • NAME — VARCHAR2(200)
  • SORT — VARCHAR2(4)
  • REG_ID — VARCHAR2(30)
  • REG_DT — DATE
  • MOD_ID — VARCHAR2(30)
  • MOD_DT — DATE

AW_CATEGORY_ITEM

  • Key (CATE_SEQ) — NUMBER — Foreign key → AW_CATEGORY.Key — NOT NULL
  • ITEM_SEQ (ITEM_TYPE) — CHAR(2) — NOT NULL
  • Key (ITEM_SEQ) — VARCHAR2(200) — Foreign key → AW_CONTENTS.Key — NOT NULL

AW_CONTENTS

  • Key (SEQ) — NUMBER — Primary key — NOT NULL
  • TITLE — VARCHAR2(200)
  • CATE — VARCHAR2(10)
  • DSP_YN — CHAR(1)
  • REG_ID — VARCHAR2(30)
  • REG_DT — VARCHAR2(30)
  • MOD_ID — VARCHAR2(30)
  • MOD_DT — VARCHAR2(30)
  • FILE_SEQ_1 — NUMBER
  • FILE_SEQ_2 — NUMBER
  • FILE_SEQ_3 — NUMBER
  • V_CNT — NUMBER

AW_CONTENTS_DETAIL

  • SEQ — NUMBER — NOT NULL
  • Key (P_SEQ) — VARCHAR2(20) — Foreign key → AW_CONTENTS.Key — NOT NULL
  • TYPE — CHAR(1)
  • R_SEQ — VARCHAR2(20)
  • CONTENT — CLOB
  • LINK — VARCHAR2(200)
  • F_SEQ — NUMBER
  • EXPLANATION — VARCHAR2(400)
  • SORT — VARCHAR2(4)
  • REG_ID — VARCHAR2(30)
  • REG_DT — VARCHAR2(30)
  • MOD_ID — VARCHAR2(30)
  • MOD_DT — VARCHAR2(30)
  • EUSE_YN — CHAR(1)

AW_DONATION_INFO

  • SEQ — NUMBER — Primary key — NOT NULL
  • TITLE — VARCHAR2(400)
  • CONTENTS — CLOB
  • DONATOR — VARCHAR2(200)
  • IMGURL — VARCHAR2(200)
  • DONATED_CNT — NUMBER
  • DONATED_DATE — DATE
  • READ_CNT — NUMBER
  • REG_DATE — DATE
  • USE_YN — CHAR(1)

AW_DOWNLOAD_ISAD

  • SEQ — NUMBER
  • USER_UUID — CHAR(32)
  • REGNO — VARCHAR2(8)
  • REG_DT — DATE

AW_ERROR_INFO

  • SEQ — NUMBER — Primary key — NOT NULL
  • TITLE — VARCHAR2(200)
  • CONTENTS — VARCHAR2(600)
  • REG_DATE — DATE
  • RES_STAT — CHAR(1)
  • URL — VARCHAR2(500)

AW_FILE_INFO

  • SEQ — NUMBER
  • FILEPATH — VARCHAR2(200)
  • SAVE_FILENM — VARCHAR2(200)
  • FILENM — VARCHAR2(200)
  • TITLE — VARCHAR2(200)
  • F_SIZE — VARCHAR2(100)
  • EXTENSION — VARCHAR2(200)
  • REG_ID — VARCHAR2(30)
  • REG_DT — VARCHAR2(30)
  • MOD_ID — VARCHAR2(30)
  • MOD_DT — VARCHAR2(30)

AW_ILJI

  • Key (ITEM_ID) — VARCHAR2(10) — Primary key — NOT NULL
  • 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

  • Key (DAY_ID) — VARCHAR2(20) — Foreign key → AW_ILJI_DAY.Key — NOT NULL
  • ARTICLE_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

  • Key (DAY_ID) — VARCHAR2(20) — Primary key — NOT NULL
  • Key (ITEM_ID) — VARCHAR2(10) — Foreign key → AW_ILJI.Key — NOT NULL
  • 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 — 수정일

AW_INQURY_INFO

  • SEQ — NUMBER — Primary key — NOT NULL
  • EMAIL — VARCHAR2(200) — NOT NULL
  • VISIT_DATE — VARCHAR2(200)
  • VISIT_NUMBER — VARCHAR2(200)
  • CONTACT_NAME — VARCHAR2(200) — NOT NULL
  • CONTACT_PHONE — VARCHAR2(200) — NOT NULL
  • ETC — VARCHAR2(3000)
  • REGDATE — DATE — NOT NULL
  • INQUIRY_TYPE — VARCHAR2(50) — NOT NULL
  • RES_STAT — CHAR(1) — NOT NULL
  • ADDRESS — VARCHAR2(400)
  • TITLE — VARCHAR2(200)
  • CONTACT_PART — VARCHAR2(200)
  • API_KEY — VARCHAR2(100)
  • VISIT_WAY — VARCHAR2(200)

AW_INTEREST_ISAD

  • SEQ — NUMBER
  • USER_UUID — CHAR(32)
  • REGNO — VARCHAR2(8)
  • REG_DT — DATE

AW_LIBRARY_INFO

  • SEQ — NUMBER — Primary key — NOT NULL
  • NAME — VARCHAR2(50) — NOT NULL
  • SEX — VARCHAR2(10) — NOT NULL
  • PHONE — VARCHAR2(30) — NOT NULL
  • AGE — NUMBER — NOT NULL
  • MAIL — VARCHAR2(50) — NOT NULL
  • ADDRESS — VARCHAR2(200) — NOT NULL
  • REG_DT — DATE — NOT NULL
  • AGREE03 — CHAR(1)
  • AGREE — CHAR(1)
  • VISIT_WAY — VARCHAR2(200)

AW_LOG_INFO

  • SEQ — NUMBER
  • TYPE — CHAR(2)
  • R_SEQ — VARCHAR2(20)
  • REG_DT — DATE

AW_MAIN

  • FILE_SEQ_1 — NUMBER
  • FILE_SEQ_2 — NUMBER
  • FILE_SEQ_3 — NUMBER
  • TITLE_1 — VARCHAR2(4000)
  • TITLE_2 — VARCHAR2(4000)
  • TITLE_3 — VARCHAR2(4000)
  • CONTENTS_SEQ — NUMBER
  • REG_ID — VARCHAR2(30)
  • REG_DT — DATE
  • MOD_ID — VARCHAR2(30)
  • MOD_DT — DATE
  • LINK_1 — VARCHAR2(500)
  • LINK_2 — VARCHAR2(500)
  • LINK_3 — VARCHAR2(500)
  • USE_YN_1 — CHAR(1)
  • USE_YN_2 — CHAR(1)
  • USE_YN_3 — CHAR(1)
  • LOCATION_1 — VARCHAR2(25)
  • LOCATION_2 — VARCHAR2(25)
  • LOCATION_3 — VARCHAR2(25)

AW_ORAL

  • Key (SEQ) — NUMBER — Primary key — NOT NULL
  • ORAL_NM — VARCHAR2(60)
  • ORAL_PLACE — VARCHAR2(500)
  • ORAL_DT — VARCHAR2(500)
  • ORAL_HIST — VARCHAR2(4000)
  • TALK_NM — VARCHAR2(60)
  • CONTENT — CLOB
  • URL — VARCHAR2(500)
  • FILE_SEQ — NUMBER
  • FILE_SEQ_LIST — VARCHAR2(500)
  • DSP_YN — CHAR(1)
  • REG_ID — VARCHAR2(30)
  • REG_DT — DATE
  • MOD_ID — VARCHAR2(30)
  • MOD_DT — DATE
  • V_CNT — NUMBER

AW_PROP_INFO

  • SEQ — NUMBER — Primary key — NOT NULL
  • PROP_TYPE — VARCHAR2(200)
  • PROP_KEY — VARCHAR2(200)
  • PROP_VALUE — VARCHAR2(600)
  • REG_DATE — DATE
  • USE_YN — CHAR(1)
  • PROP_TEL — VARCHAR2(20)

AW_PUB_INFO

  • SEQ — NUMBER — Primary key — NOT NULL
  • TITLE — VARCHAR2(200)
  • CONTENTS — VARCHAR2(600)
  • FILEURL — VARCHAR2(200)
  • IMGURL — VARCHAR2(200)
  • REG_DATE — DATE
  • USE_YN — CHAR(1)

AW_RECEIPT_INFO

  • SEQ — NUMBER
  • USER_UUID — CHAR(32)
  • REQ_SEQ — NUMBER
  • REQ_TYPE — CHAR(2)
  • CORPORATE_NUMBER — VARCHAR2(30)
  • CORPORATE_NAME — VARCHAR2(200)
  • NAME — VARCHAR2(200)
  • ADDRESS — VARCHAR2(200)
  • CONTENT — VARCHAR2(1000)
  • AGREE — CHAR(1)
  • REG_DT — DATE

AW_REQUEST_CART

  • SEQ — NUMBER
  • USER_UUID — CHAR(32)
  • REQ_TYPE — CHAR(2)
  • REGNO — VARCHAR2(8)
  • REG_DT — DATE

AW_REQUEST_INFO

  • Key (SEQ) — NUMBER — Primary key — NOT NULL
  • USER_UUID — CHAR(32)
  • REQ_TYPE — CHAR(2)
  • NAME — VARCHAR2(200)
  • BIRTHDATE — VARCHAR2(8)
  • EMAIL — VARCHAR2(200)
  • PHONE — VARCHAR2(200)
  • CONTACT_NAME — VARCHAR2(400)
  • ADDRESS — VARCHAR2(400)
  • CONTENT — VARCHAR2(3000)
  • REDING_TYPE — CHAR(1)
  • AGREE — CHAR(1)
  • REG_DT — DATE
  • MOD_DT — DATE
  • RES_STAT — CHAR(1)
  • RECEIPT_STAT — CHAR(1)

AW_REQUEST_ISAD

  • Key (REQ_SEQ) — NUMBER — Foreign key → AW_REQUEST_INFO.Key — NOT NULL
  • REQ_TYPE — CHAR(2) — NOT NULL
  • REGNO — VARCHAR2(8) — NOT NULL

AW_SUBMAIN_CONTENTS

  • CONTENTS_SEQ — NUMBER
  • REG_ID — VARCHAR2(30)
  • REG_DT — DATE

AW_SUBMAIN_ORAL

  • ORAL_SEQ_1 — NUMBER
  • ORAL_SEQ_2 — NUMBER
  • ORAL_SEQ_3 — NUMBER
  • REG_ID — VARCHAR2(30)
  • REG_DT — DATE
  • MOD_ID — VARCHAR2(30)
  • MOD_DT — DATE

AW_TAG

  • ITEM_SEQ — VARCHAR2(200)
  • ITEM_TYPE — CHAR(2)
  • CONTENT — VARCHAR2(2000)
  • REG_ID — VARCHAR2(30)
  • REG_DT — DATE
  • MOD_ID — VARCHAR2(30)
  • MOD_DT — DATE

AW_TOUR_INFO

  • SEQ — NUMBER — Primary key — NOT NULL
  • TITLE — VARCHAR2(200)
  • CONTENTS — VARCHAR2(600)
  • TOURIST — VARCHAR2(200)
  • IMGURL — VARCHAR2(200)
  • TOUR_CNT — NUMBER
  • TOUR_DATE — DATE
  • REG_DATE — DATE
  • USE_YN — CHAR(1)

AW_TRANSCRIPTION_DETAIL

  • Key (SEQ) — NUMBER — Primary key — NOT NULL
  • Key (P_SEQ) — NUMBER — Foreign key → AW_TRANSCRIPTION_INFO.Key — NOT NULL
  • PAGE_NO — NUMBER
  • USER_UUID — CHAR(32)
  • STEP — CHAR(1)
  • CONTENT — CLOB
  • REG_ID — VARCHAR2(30)
  • REG_DT — DATE
  • MOD_ID — VARCHAR2(30)
  • MOD_DT — DATE
  • USER_NAME — VARCHAR2(30)

AW_TRANSCRIPTION_INFO

  • Key (SEQ) — NUMBER — Primary key — NOT NULL
  • REGNO — VARCHAR2(8)
  • DSP_YN — CHAR(1)
  • REG_ID — VARCHAR2(30)
  • REG_DT — DATE
  • MOD_ID — VARCHAR2(30)
  • MOD_DT — DATE

AW_USER_INFO

  • USER_UUID — CHAR(32) — Primary key — NOT NULL
  • USER_EMAIL — VARCHAR2(200)
  • USER_NAME — VARCHAR2(200)
  • USER_PASSWD — VARCHAR2(400)
  • USER_TYPE — CHAR(1) — NOT NULL
  • SNS_ID — VARCHAR2(200)
  • CERT_YN — CHAR(1) — NOT NULL
  • CERT_UUID — CHAR(32)
  • REGDATE — DATE — NOT NULL
  • AGREE01 — CHAR(1)
  • AGREE02 — CHAR(1)
  • USER_EMAIL2 — VARCHAR2(200)
  • AGREE03 — CHAR(1)

AW_WORD_INFO

  • SUBJECT — VARCHAR2(100)
  • CONTENT — VARCHAR2(200)
  • LINK — VARCHAR2(200)
  • REG_ID — VARCHAR2(30)
  • REG_DT — DATE
  • MOD_ID — VARCHAR2(30)
  • MOD_DT — DATE
  • SEQ — NUMBER

AW_WRITE_IP

  • SEQ — NUMBER
  • USER_UUID — CHAR(32)
  • IP_ADDRESS — VARCHAR2(30)
  • REG_DT — DATE

AW_YOUTUBELINK

  • SEQ — NUMBER
  • LINK — VARCHAR2(4000)
  • REG_ID — VARCHAR2(30)
  • REG_DT — DATE
  • TITLE — VARCHAR2(256)
  • CONTENT — VARCHAR2(4000)
  • USE_YN — CHAR(1)

CODE_INFO

  • CODE_ID — VARCHAR2(32) — Primary key — NOT NULL
  • CODE_TYPE_ID — VARCHAR2(32) — Foreign key → CODE_TYPE.CODE_TYPE_ID — 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

CODE_TYPE

  • CODE_TYPE_ID — VARCHAR2(32) — Primary key — NOT NULL
  • REGISTER — VARCHAR2(32)
  • CODE_TYPE_NAME_KO — VARCHAR2(128) — NOT NULL
  • CODE_TYPE_NAME_ENG — VARCHAR2(128)
  • CODE_TYPE_DESCRIPTION — VARCHAR2(512)
  • CODE_TYPE_PARENT — VARCHAR2(32)
  • REGISTED_DATE — VARCHAR2(16)
  • LEAF_YN — CHAR(1)
  • ERASE_YN — CHAR(1)

ISAD_CLASS (SERVICE_ISAD_CLASS)

  • REGNO — VARCHAR2(10) — Primary key — NOT NULL
  • CODE_ID (CLASS_FORM) — VARCHAR2(1024) — Foreign key → CODE_INFO.CODE_ID — NOT NULL
  • CODE_ID (CLASS_TYPE) — VARCHAR2(32) — Foreign key → CODE_INFO.CODE_ID — NOT NULL
  • REFERENCE_CODE — VARCHAR2(128) — NOT NULL
  • TITLE — VARCHAR2(4000) — NOT NULL
  • LEVEL_NO — VARCHAR2(32) — NOT NULL
  • 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)
  • CONTENT — CLOB
  • BOOKSTACK_NAME — VARCHAR2(32) — 서가구역명
  • MOBILERACK_NAME — VARCHAR2(200) — 모빌렉명
  • COL_NO — NUMBER(5,0) — 열번호
  • … +6

MEDIA_INFO

  • REGNO — VARCHAR2(10) — Primary key — NOT NULL
  • CONT_FORMAT — VARCHAR2(32) — NOT NULL
  • PAGE_TOT — NUMBER(16,0)
  • BASE_DIR — VARCHAR2(1024) — NOT NULL
  • FILE_NAME — VARCHAR2(1024) — NOT NULL
  • CONT_PATH — VARCHAR2(1024) — NOT NULL
  • CONT_WID — NUMBER(16,0) — NOT NULL
  • CONT_HEI — NUMBER(16,0) — NOT NULL
  • REG_ID — VARCHAR2(32) — NOT NULL
  • REG_DT — VARCHAR2(10) — NOT NULL
  • STORAGE_NO — VARCHAR2(1024)

NEWMEDIA_CONF

  • ROOT_PATH — VARCHAR2(1024)
  • VOL_DIR — VARCHAR2(1024)
  • THUMB_PATH — VARCHAR2(1024)

NEWMEDIA_INFO

  • REGNO — VARCHAR2(10) — Foreign key — 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

PHOTO_ARCHIVE_OLD

  • REGNO — VARCHAR2(10) — Primary key — NOT NULL — 등록번호
  • PARENT_REGNO — VARCHAR2(10) — 상위등록번호
  • DEPTH — NUMBER(*,0) — 계층레벨
  • LEVEL_NO — VARCHAR2(10) — 계층번호
  • DATA_REGNO — VARCHAR2(10) — 사료등록번호
  • MRG_NO — VARCHAR2(10) — MRG번호
  • BOX_NO — VARCHAR2(128) — 상자번호
  • FBOX_NO — VARCHAR2(128) — 파일상자번호
  • PARE_LVLNO — VARCHAR2(10) — 상위계층번호
  • LEAD_DIV — VARCHAR2(10) — 사료구분
  • LEAD_NO — VARCHAR2(12) — 리드번호
  • LEVEL_DIV — VARCHAR2(10) — 계층구분
  • LEVEL_CODE — VARCHAR2(10) — 계층코드
  • LEVEL_NAME — VARCHAR2(2000) — 계층표제
  • CHECK_ID — VARCHAR2(10) — 검수자
  • CHECK_DT — VARCHAR2(12) — 검수일
  • CHECK_FG — VARCHAR2(10) — 검수여부
  • SCRAP_FG — VARCHAR2(10) — 폐기구분(1
  • REG_ID — VARCHAR2(128) — 등록자
  • REG_DT — VARCHAR2(128) — 등록일
  • MOD_ID — VARCHAR2(128) — 수정자
  • MOD_DT — VARCHAR2(128) — 수정일
  • LINK_LVLNO — VARCHAR2(10) — 연결자료번호
  • FBOX_DT — VARCHAR2(12) — 파일박스분류일자
  • KEEP_FG — VARCHAR2(10) — 보존현황
  • SORT_NO — VARCHAR2(10) — 정렬순서
  • SCRAP_DETAIL — VARCHAR2(128) — 폐기사유
  • DSP_YN — CHAR(1)

PHOTO_ARCHIVE_OLD_DETAIL

  • REGNO — VARCHAR2(10) — NOT NULL
  • TITLE — VARCHAR2(200)
  • REFER_CODE — VARCHAR2(10)
  • CREATOR — VARCHAR2(30)
  • SOURCES — VARCHAR2(30)
  • CONTENT — CLOB
  • SYS_ARRANGE — VARCHAR2(500)
  • WRITER — VARCHAR2(30)
  • REG_DT — DATE
  • REG_ID — VARCHAR2(20)
  • MOD_DT — DATE
  • MOD_ID — VARCHAR2(20)

SATISFACTION_SURVEY

  • SEQ — NUMBER — NOT NULL
  • Q1 — VARCHAR2(500)
  • Q2 — VARCHAR2(500)
  • Q3 — VARCHAR2(100)
  • Q4 — VARCHAR2(500)
  • Q5 — VARCHAR2(500)
  • Q6 — VARCHAR2(500)
  • Q7 — VARCHAR2(100)
  • Q8 — VARCHAR2(2000)
  • REG_DT — DATE
  • NAME — VARCHAR2(50)
  • PHONE — VARCHAR2(50)
  • AGE — VARCHAR2(20)
  • OLDER_14YEARS — CHAR(1)
  • PROVIDE_AGREE — CHAR(1)
  • COLLECT_AGREE — CHAR(1)
  • IP — VARCHAR2(500)
  • Q9 — VARCHAR2(2000)
  • SEX — VARCHAR2(20)
  • Q10 — VARCHAR2(2000)
  • Q11 — VARCHAR2(100)
  • Q12 — VARCHAR2(100)
  • Q13 — VARCHAR2(2000)
  • Q14 — VARCHAR2(100)
  • Q15 — VARCHAR2(2000)
  • Q16 — VARCHAR2(500)
  • Q17 — VARCHAR2(500)
  • Q18 — VARCHAR2(500)

SRCH_BANNEDWORD

  • COLLECTION_ID — VARCHAR2(32) — Primary key — NOT NULL
  • PROFILE_ID — VARCHAR2(32) — Primary key — NOT NULL
  • KEYWORD — VARCHAR2(50) — Primary key — NOT NULL
  • REG_DATE — TIMESTAMP
  • APPLY — CHAR(1) — NOT NULL

SRCH_CANDIDATE_SET

  • COLLECTION_ID — VARCHAR2(32) — Primary key — NOT NULL
  • PROFILE — VARCHAR2(32) — Primary key — NOT NULL
  • INDEX_FIELD — VARCHAR2(32) — Primary key — NOT NULL
  • KEYWORDS — VARCHAR2(255) — Primary key — NOT NULL
  • USE_TYPE — CHAR(1) — Primary key — NOT NULL

SRCH_CATEGORY_RANKING

  • COLLECTION_ID — VARCHAR2(32) — Primary key — NOT NULL
  • PROFILE_ID — VARCHAR2(32) — Primary key — NOT NULL
  • KEYWORD — VARCHAR2(50) — Primary key — NOT NULL
  • FIELD — VARCHAR2(32) — Primary key — NOT NULL
  • CATEGORY — VARCHAR2(255) — Primary key — NOT NULL
  • CREATOR — CHAR(1) — Primary key — 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
  • USE_YN — CHAR(1) — NOT NULL

SRCH_CATEGORY_RANKING_KEYWORD

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

SRCH_CATEGORY_UPDATE_SETTING

  • CATUPDATE_ID — VARCHAR2(32) — Primary key — NOT NULL
  • COLLECTION_ID — VARCHAR2(32) — Primary key — NOT NULL
  • FIELD — VARCHAR2(32) — Primary key — 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) — Primary key — NOT NULL
  • DESCRIPTION — VARCHAR2(255)
  • CREATED — TIMESTAMP
  • CREATOR — VARCHAR2(20)
  • LAST_UPDATED — TIMESTAMP
  • LAST_UPDATOR — VARCHAR2(20)

SRCH_COLLECTION_CATEGORY

  • COLLECTION_ID — VARCHAR2(32) — Primary key — NOT NULL
  • FIELD — VARCHAR2(32) — Primary key — NOT NULL
  • CATEGORY — VARCHAR2(255) — Primary key — NOT NULL

SRCH_COLLECTION_CATEGORYFIELD

  • COLLECTION_ID — VARCHAR2(32) — Primary key — NOT NULL
  • FIELD — VARCHAR2(32) — Primary key — NOT NULL

SRCH_COLLECTION_MONITOR

  • COLLECTION_ID — VARCHAR2(32) — Primary key — 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) — Primary key — NOT NULL
  • PROFILE_ID — VARCHAR2(32) — Primary key — NOT NULL
  • KEYWORD — VARCHAR2(50) — Primary key — NOT NULL
  • DOC_ID — VARCHAR2(255) — Primary key — 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) — Primary key — NOT NULL
  • PROFILE_ID — VARCHAR2(32) — Primary key — NOT NULL
  • KEYWORD — VARCHAR2(50) — Primary key — NOT NULL
  • DOCUMENTS — NUMBER(10,0)
  • REG_DATE — TIMESTAMP
  • APPLY — CHAR(1) — NOT NULL

SRCH_ERROR_LOG

  • ERROR_ID — NUMBER(10,0) — Primary key — 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) — Primary key — NOT NULL
  • FUNCTION_NAME — VARCHAR2(50)
  • DESCRIPTION — VARCHAR2(1000)

SRCH_FEEDBACK_KEYWORD

  • KEYWORD — VARCHAR2(50) — Primary key — NOT NULL
  • REG_DATE — TIMESTAMP
  • APPLY — CHAR(1) — NOT NULL

SRCH_FEEDBACK_STATISTICS_DAILY

  • COLLECTION_NAME — VARCHAR2(32) — Primary key — NOT NULL
  • PROFILE_NAME — VARCHAR2(32) — Primary key — NOT NULL
  • KEYWORD — VARCHAR2(50) — Primary key — NOT NULL
  • UNIT — NUMBER(15,0) — Primary key — 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) — Primary key — NOT NULL
  • PROFILE_NAME — VARCHAR2(32) — Primary key — NOT NULL
  • KEYWORD — VARCHAR2(50) — Primary key — NOT NULL
  • UNIT — NUMBER(15,0) — Primary key — 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) — Primary key — NOT NULL
  • PROFILE_NAME — VARCHAR2(32) — Primary key — NOT NULL
  • KEYWORD — VARCHAR2(50) — Primary key — NOT NULL
  • UNIT — NUMBER(15,0) — Primary key — 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) — Primary key — NOT NULL
  • REG_DATE — TIMESTAMP

SRCH_INDEX_JOB

  • JOB_ID — NUMBER(10,0) — Primary key — 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) — Primary key — NOT NULL
  • INDEXING_TYPE — CHAR(1) — Primary key — NOT NULL
  • STARTED — TIMESTAMP — Primary key — NOT NULL
  • NANO_TIME — NUMBER(19,0) — Primary key — 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) — Primary key — 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) — Primary key — NOT NULL
  • KEYWORD — VARCHAR2(50) — Primary key — NOT NULL
  • PROFILE_NAME — VARCHAR2(32) — NOT NULL
  • REG_DATE — TIMESTAMP
  • APPLY — CHAR(1) — NOT NULL

SRCH_MAX_FREQ_KEYWORD

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

SRCH_MEMBER

  • USER_ID — VARCHAR2(32) — Primary key — 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) — Primary key — NOT NULL
  • DESCRIPTION — VARCHAR2(4000) — NOT NULL
  • REDIRECT — VARCHAR2(255) — NOT NULL
  • REPORTED_TIME — TIMESTAMP — NOT NULL

SRCH_PAGE_AUTHORITY

  • PAGE_NAME — VARCHAR2(50) — Primary key — NOT NULL
  • BUSINESS_ID — NUMBER(10,0)
  • AUTH_LEVEL — CHAR(1)
  • EXPLANATION — VARCHAR2(255)

SRCH_QUERY_LOG_FAIL

  • COLLECTION_ID — VARCHAR2(32) — Primary key — NOT NULL
  • PROFILE — VARCHAR2(32) — Primary key — NOT NULL
  • KEYWORDS — VARCHAR2(255) — Primary key — NOT NULL
  • REGISTERED — TIMESTAMP — Primary key — 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) — Primary key — NOT NULL
  • PROFILE — VARCHAR2(32) — Primary key — NOT NULL
  • KEYWORDS — VARCHAR2(255) — Primary key — NOT NULL
  • REGISTERED — TIMESTAMP — Primary key — NOT NULL
  • REQUESTED — NUMBER — NOT NULL
  • DURATION — NUMBER(19,0) — NOT NULL

SRCH_QUERY_LOG_STATS

  • COLLECTION_ID — VARCHAR2(32) — Primary key — NOT NULL
  • PROFILE — VARCHAR2(32) — Primary key — NOT NULL
  • SERVER — VARCHAR2(32) — Primary key — NOT NULL
  • REGISTERED — TIMESTAMP — Primary key — 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) — Primary key — NOT NULL
  • PROFILE_ID — VARCHAR2(32) — Primary key — NOT NULL
  • FIELD_ID — VARCHAR2(32) — Primary key — NOT NULL
  • FIELD_TYPE — CHAR(1) — Primary key — NOT NULL
  • WEIGHT — NUMBER(10,0)
  • ENABLE — CHAR(1) — NOT NULL

SRCH_RECOMMEND

  • COLLECTION_ID — VARCHAR2(32) — Primary key — NOT NULL
  • PROFILE_ID — VARCHAR2(32) — Primary key — NOT NULL
  • KEYWORD — VARCHAR2(50) — Primary key — 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) — Primary key — NOT NULL
  • COLLECTION_ID — VARCHAR2(32) — Primary key — 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) — Primary key — NOT NULL
  • PROFILE_ID — VARCHAR2(32) — Primary key — NOT NULL
  • THEME_TITLE — VARCHAR2(50) — Primary key — 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) — Primary key — 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

and 16 more tables