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