TEST
Tables (18)
APAC_DAILY_HOT_BOOK_TBL
- RANK_DATE — VARCHAR2
- EA_ISBN — VARCHAR2
- HOT_COUNT — NUMBER
- MANAGE_CODE — VARCHAR2
- RECORD_DATE — DATE
- SPECIES_KEY — NUMBER
- SHELF_LOC_CODE — CHAR
- REC_KEY — NUMBER
APAC_MAPPING_TBL
- MAC — VARCHAR2 — Primary key — NOT NULL
- IP — VARCHAR2
- MANAGE_CODE — CHAR
- OPERATION_MODE — VARCHAR2
- SEARCH_LIST_TYPE — CHAR
- CALLNO_PRINT_USE_YN — CHAR
- SHELF_LOC_CODE — CHAR
- BEST_BOOK_COUNT_PER_PAGE — NUMBER
- NEW_BOOK_COUNT_PER_PAGE — NUMBER
- DATA_SEARCH_TYPE — CHAR
- PORT — NUMBER
- CONNECTION_MODE — CHAR
- MN_USER_TBL_ID — VARCHAR2
- PRINT_NAME — VARCHAR2
- RECEIPT_TOTAL_WIDTH — NUMBER
- RECEIPT_LEFT_WIDTH — NUMBER
- RECEIPT_TOP_HEIGHT — NUMBER
- SEARCH_TYPE_BOOK — VARCHAR2
- SEARCH_EX_LIB — VARCHAR2
- USER_JOIN_YN — CHAR
- LOGIN_YN — CHAR
- CHILD_CERTIFY_USE_YN — CHAR
- VERSION — VARCHAR2
- ILL_TRANS_YN — CHAR
- CODE_LOCATION_IMAGE_YN — CHAR
- REQUEST_INSERT_YN — CHAR
- ER100_LOGIN_USE_YN — CHAR
- ER100_LOGIN_MODE — VARCHAR2
APAC_NEW_BOOK_TBL
- EA_ISBN — VARCHAR2
- REC_KEY — NUMBER — NOT NULL
- SPECIES_KEY — NUMBER — NOT NULL
- TITLE — VARCHAR2
- MANAGE_CODE — CHAR
- SHELF_LOC_CODE — CHAR
- SHELF_DATE — DATE
APAC_SEARCH_WORD
- ORG_SEARCH_WORD — VARCHAR2 — NOT NULL
- IDX_SEARCH_WORD — VARCHAR2 — NOT NULL
- SEARCH_COUNT — NUMBER — NOT NULL
- INDEXED_FLAG — CHAR — NOT NULL
BO_BOOK_TBL
- REC_KEY — NUMBER — Primary key — NOT NULL
- ACQ_KEY — NUMBER
- SPECIES_KEY — NUMBER — NOT NULL
- DUP_SPECIES_KEY — NUMBER
- ACCESSION_REC_KEY — NUMBER
- REPRESENT_BOOK_YN — CHAR
- BOOK_APPENDIX_FLAG — CHAR
- WORKING_STATUS — CHAR
- PREV_WORKING_STATUS — CHAR
- REG_NO — CHAR
- ACQ_CODE — CHAR
- ACQ_YEAR — CHAR
- SEQ_NO — NUMBER
- SERIAL_NO — NUMBER
- MANAGE_CODE — CHAR
- MEDIA_CODE — CHAR
- USE_LIMIT_CODE — CHAR
- USE_OBJECT_CODE — CHAR
- REG_CODE — VARCHAR2
- VOL_SORT_NO — NUMBER
- AUTHOR — VARCHAR2
- VOL — VARCHAR2
- VOL_INDEX — VARCHAR2
- VOL_TITLE — VARCHAR2
- VOL_TITLE_INDEX — VARCHAR2
- PUBLISH_YEAR — VARCHAR2
- PUBLISH_DATE — DATE
- PAGE — VARCHAR2
- PHYSICAL_PROPERTY — VARCHAR2
- BOOK_SIZE — VARCHAR2
- ACCOMP_MAT — VARCHAR2
- PRICE — NUMBER
- PRICE_CHARACTER — VARCHAR2
- PRICE_OTHER_INFO — VARCHAR2
- EA_ISBN — VARCHAR2
- EA_ADD_CODE — VARCHAR2
- EA_INVALID_ISBN — VARCHAR2
- EXTRA_ISBN — VARCHAR2
- EXTRA_ADD_CODE — VARCHAR2
- EXTRA_INVALID_ISBN — VARCHAR2
- SEPARATE_SHELF_CODE — VARCHAR2
- CLASS_NO_TYPE — CHAR
- CLASS_NO — VARCHAR2
- BOOK_CODE — VARCHAR2
- VOL_CODE — VARCHAR2
- COPY_CODE — VARCHAR2
- LABEL_TYPE — CHAR
- DELIVERY_YN — CHAR
- INPUT_DATE — DATE
- CHECKIN_DATE — DATE
- REG_TRANSFER_DATE — DATE
- REG_DATE — DATE
- CAT_TRANSFER_DATE — DATE
- CAT_COMPLETE_DATE — DATE
- LOC_TRANSFER_DATE — DATE
- SHELF_DATE — DATE
- SHELF_LOC_CODE — CHAR
- SHELF_CHANGE_DATE — DATE
- SHELF_CHANGE_BEFORE_LOC — CHAR
- SHELF_WORKER — VARCHAR2
- … +23
BO_FURNISH_TBL
- REC_KEY — NUMBER — Primary key — NOT NULL
- MANAGE_CODE — CHAR
- ACQ_CODE — CHAR
- ACQ_KEY — NUMBER
- APPLICANT_NAME — VARCHAR2
- IDX_APPLICANT_NAME — VARCHAR2
- CIVIL_NO — VARCHAR2
- ZIP_CODE — VARCHAR2
- ADDRESS — VARCHAR2
- TEL — VARCHAR2
- HANDPHONE — VARCHAR2
- EMAIL — VARCHAR2
- APPLICANT_DATE — DATE
- MAIL_SEND_DATE — DATE
- TITLE — VARCHAR2
- AUTHOR — VARCHAR2
- PUBLISHER — VARCHAR2
- PUBLISH_YEAR — VARCHAR2
- RECOM_OPINION — VARCHAR2
- FURNISH_DATE — DATE
- FURNISH_STATUS — CHAR
- CANCEL_REASON — VARCHAR2
- INDEX_TITLE — VARCHAR2
- INDEX_AUTHOR — VARCHAR2
- INDEX_PUBLISHER — VARCHAR2
- PRICE — NUMBER
- CURRENCY_CODE — CHAR
- EA_ISBN — VARCHAR2
- PRIORITY_YN — CHAR
- SMS_RECEIPT_YN — CHAR
- FIRST_WORK — VARCHAR2
- LAST_WORK — VARCHAR2
- APPLICANT_CLASS — CHAR
- APPLICANT_CODE — CHAR
- USER_NO — VARCHAR2
- RESERVATION_YN — CHAR
- CLASS_NO_TYPE — CHAR
- SUBJECT_CODE — CHAR
- REMARK — VARCHAR2
- BOOK_CNT — VARCHAR2
BO_SPECIES_TBL
- REC_KEY — NUMBER — Primary key — NOT NULL
- ACQ_YEAR — VARCHAR2
- WORK_CODE — CHAR
- CONTROL_NO — CHAR
- CONTROL_MAT_CODE — CHAR
- MAT_CODE — CHAR
- FORM_CODE — CHAR
- SUB_REG_CODE — CHAR
- MEDIA_CODE — CHAR
- USE_OBJ_CODE — CHAR
- USE_LIMIT_CODE — CHAR
- MANAGE_CODE — CHAR
- MARC — LONG
- LOC_FLAG — CHAR
- SUBJECT_CODE — CHAR
- CLASS_NO_TYPE — CHAR
- KDC_CLASS_NO — VARCHAR2
- KDC_CLASS_NO_VER — VARCHAR2
- DDC_CLASS_NO — VARCHAR2
- DDC_CLASS_NO_VER — VARCHAR2
- ECT_CLASS_NO — VARCHAR2
- SHELF_LOC_CODE — CHAR
- TOC_COMMON_KEY — NUMBER
- CENTER_UPLOAD_STATUS — CHAR
- REMARK — VARCHAR2
- WORKER — VARCHAR2
- INPUT_DATE — DATE
- DUP_FLAG — CHAR
- APPLY_YN — CHAR
- PRIORITY_YN — CHAR
- CATALOG_STATUS — CHAR
- USER_DEFINE_CODE1 — VARCHAR2
- USER_DEFINE_CODE2 — VARCHAR2
- USER_DEFINE_CODE3 — VARCHAR2
- FIRST_WORK — VARCHAR2
- LAST_WORK — VARCHAR2
CD_CODE_TBL
- REC_KEY — NUMBER — Primary key — NOT NULL
- CLASS — NUMBER
- CODE — VARCHAR2
- DESCRIPTION — VARCHAR2
- MAT_NAME — VARCHAR2
- LOAN_PERIOD — NUMBER
- POSTPONEMENT_PERIOD — NUMBER
- LOAN_BOOK_CNT — NUMBER
- PREENGAGE_BOOK_CNT — NUMBER
- LOAN_YN — CHAR
- REGISTER — VARCHAR2
- NON_LOAN_BOOK_CNT — NUMBER
- RESERVATION_EXPIRE_DAY — NUMBER
- USEOBJCODE — VARCHAR2
- ADDRESS — VARCHAR2
- TEL — VARCHAR2
- FAX — VARCHAR2
- EMAIL — VARCHAR2
- REMARK — VARCHAR2
- DEPART — VARCHAR2
- CHERK — VARCHAR2
- PRESIDENT — VARCHAR2
- ZIP_CODE — VARCHAR2
- LIB_CODE — VARCHAR2
- FIRST_WORK — VARCHAR2
- LAST_WORK — VARCHAR2
- UNITY_LOAN_BOOK_CNT — NUMBER
- TL_LOAN_BOOK_CNT — NUMBER
- OTHER_LOAN_BOOK_CNT — NUMBER
- PREENGAGE_CANCEL_LIMIT_COUNT — NUMBER
- PREENGAGE_CANCEL_LIMIT_PERIOD — NUMBER
- TOTAL_PREENGAGE_BOOK_CNT — NUMBER
- NEED_CERTIFY_YN — CHAR
- LILL_YN — CHAR
CD_INDIVIDUAL_CLASS_TBL
- REC_KEY — NUMBER — NOT NULL
- CODE — VARCHAR2
- DESCRIPTION — VARCHAR2
- LOAN_BOOK_CNT — NUMBER
- MANAGE_CODE — CHAR
- FIRST_WORK — VARCHAR2
- LAST_WORK — VARCHAR2
- RESERVE_BOOK_CNT — NUMBER
- LOAN_PERIOD — NUMBER
CO_LOAN_USER_TBL
- REC_KEY — NUMBER — Primary key — NOT NULL
- USER_NO — VARCHAR2
- USER_ID — VARCHAR2
- PASSWORD — VARCHAR2
- FID_KEY — NUMBER
- NAME — VARCHAR2
- IDX_USER_NAME — VARCHAR2
- BIRTHDAY — DATE
- BIRTHDAY_TYPE — CHAR
- CIVIL_NO — VARCHAR2
- H_ADDR1 — VARCHAR2
- W_ADDR1 — VARCHAR2
- H_ZIPCODE — VARCHAR2
- W_ZIPCODE — VARCHAR2
- H_PHONE — VARCHAR2
- W_PHONE — VARCHAR2
- EXCHANGE_NO — VARCHAR2
- DEPARTMENT_NAME — VARCHAR2
- CLASS_NAME — VARCHAR2
- HANDPHONE — VARCHAR2
- IDX_HANDPHONE — VARCHAR2
- E_MAIL — VARCHAR2
- REG_DATE — DATE
- REMOVE_DATE — DATE
- USER_CLASS — CHAR
- INFERIOR_REASON — VARCHAR2
- MEMBER_CLASS — CHAR
- SCHOOL — VARCHAR2
- GRADE — VARCHAR2
- CLASS — VARCHAR2
- CLASS_NO — VARCHAR2
- USER_POSITION_CODE — VARCHAR2
- USER_CLASS_CODE — VARCHAR2
- MAIL_SEND_AREA — CHAR
- LOAN_COUNT — NUMBER
- RESERVATION_COUNT — NUMBER
- DELAY_COUNT — NUMBER
- DELAYDAY_COUNT — NUMBER
- LOAN_STOP_DATE — DATE
- LAST_LOAN_DATE — DATE
- LAST_MODIFY_DATE — DATE
- REMARK — VARCHAR2
- REISSUE_CNT — NUMBER
- LOAN_STOP_SET_DATE — DATE
- NEW_USER_MAIL_DATE — DATE
- CENTER_UPLOAD_CHECK — CHAR
- SHELF_LOC_CODE — CHAR
- USER_PICTURE — BLOB
- USER_PICTURE_TYPE — CHAR
- LOST_USER_CARD — CHAR
- SMS_USE_YN — CHAR
- MONETA_INFORM_PHONE_NUM — VARCHAR2
- MONETA_INFORM_DATE — DATE
- CARD_PASSWORD — VARCHAR2
- USER_DEFINE_CODE1 — VARCHAR2
- USER_DEFINE_CODE2 — VARCHAR2
- USER_DEFINE_CODE3 — VARCHAR2
- FIRST_WORK — VARCHAR2
- LAST_WORK — VARCHAR2
- CHECKING — CHAR
- … +65
CO_UTIL_LOCK_TBL
- REC_KEY — NUMBER — Primary key — NOT NULL
- UTIL_CODE — VARCHAR2
- UTIL_DESC — VARCHAR2
- USE_YN — CHAR
ESL_MANAGE_TBL
- REC_KEY — NUMBER — Primary key — NOT NULL
- GROUP_1 — VARCHAR2
- GROUP_2 — VARCHAR2
- GROUP_3 — VARCHAR2
- GROUP_4 — VARCHAR2
- GROUP_5 — VARCHAR2
- CLASS_ALIAS — VARCHAR2
- CLASS_DESC — VARCHAR2
- VALUE_NAME — VARCHAR2
- VALUE_1 — VARCHAR2
- VALUE_2 — VARCHAR2
- VALUE_3 — VARCHAR2
- FIRST_WORK — VARCHAR2
- LAST_WORK — VARCHAR2
- SYS_SETUP_YN — CHAR
- MANAGE_CODE — CHAR
- VALUE_4 — VARCHAR2
IDX_BO_TBL
- REC_KEY — NUMBER — Primary key — NOT NULL
- WORK_CODE — CHAR
- REG_CODE — VARCHAR2
- MAT_CODE — CHAR
- FORM_CODE — CHAR
- MEDIA_CODE — CHAR
- USE_OBJ_CODE — CHAR
- USE_LIMIT_CODE — VARCHAR2
- MANAGE_CODE — VARCHAR2
- SUB_REG_CODE — CHAR
- IDX_TITLE — VARCHAR2
- IDX_KEYWORD — VARCHAR2
- IDX_AUTHOR — VARCHAR2
- IDX_PUBLISHER — VARCHAR2
- IDX_SUBJECT — VARCHAR2
- IDX_ITITLE — VARCHAR2
- IDX_IPUBLISHER — VARCHAR2
- IDX_IPUB_YEAR — VARCHAR2
- IDX_ALL_ITEM — VARCHAR2
- IDX_VOL — VARCHAR2
- IDX_VOL_TITLE — VARCHAR2
- IDX_ICS — VARCHAR2
- IDX_STANDARDNO — VARCHAR2
- IDX_PLACE — VARCHAR2
- IDX_HOLD_PLACE — VARCHAR2
- IDX_SE_SHELF_CODE — VARCHAR2
- TITLE_INFO — VARCHAR2
- AUTHOR_INFO — VARCHAR2
- PUB_INFO — VARCHAR2
- PUB_YEAR_INFO — VARCHAR2
- PLACE_INFO — VARCHAR2
- MAIN_PLACE_INFO — VARCHAR2
- EDIT_INFO — VARCHAR2
- ICS_INFO — VARCHAR2
- STANDARDNO_INFO — VARCHAR2
- TITLE — VARCHAR2
- AUTHOR — VARCHAR2
- PUBLISHER — VARCHAR2
- PUB_YEAR — VARCHAR2
- ST_CODE — VARCHAR2
- ST_ISSN — VARCHAR2
- ST_STRN — VARCHAR2
- ST_RNSTRN — VARCHAR2
- ST_CBN — VARCHAR2
- ST_CAN — VARCHAR2
- SE_SHELF_CODE — VARCHAR2
- CLASS_NO_TYPE — CHAR
- CLASS_NO — VARCHAR2
- BOOK_CODE — VARCHAR2
- VOL_CODE — VARCHAR2
- VOL_CODE_DISP — VARCHAR2
- CONTROL_NO — VARCHAR2
- KDCP_CLASS — VARCHAR2
- KDC_CLASS — VARCHAR2
- DDC_CLASS — VARCHAR2
- CEC_CLASS — VARCHAR2
- CWC_CLASS — VARCHAR2
- COC_CLASS — VARCHAR2
- UDC_CLASS — VARCHAR2
- NDC_CLASS — VARCHAR2
- … +26
ILL_MANAGE_TBL
- REC_KEY — NUMBER — NOT NULL
- CLASS_ALIAS — VARCHAR2
- CLASS_DESC — VARCHAR2
- VALUE_NAME — VARCHAR2
- VALUE_1 — VARCHAR2
- VALUE_TYPE — VARCHAR2
- FIRST_WORK — VARCHAR2
- LAST_WORK — VARCHAR2
- SYS_SETUP_YN — CHAR
- MANAGE_CODE — CHAR
- LIB_CODE — CHAR
ILL_TRANS_TBL
- TRANS_NO — VARCHAR2 — Primary key — NOT NULL
- STATE — CHAR
- USER_NO — VARCHAR2
- LOAN_KEY — NUMBER
- APL_LIBCODE — CHAR
- RETURN_LIBCODE — CHAR
- GIVE_LIBCODE — CHAR
- APL_DIV — CHAR
- APL_DATE — DATE
- APL_CONTENT — VARCHAR2
- APL_USER_CONTENT — VARCHAR2
- APLREQ_DATE — DATE
- APLREQ_USERID — VARCHAR2
- APLREQ_CANCEL — CHAR
- APLREQ_CONTENT — VARCHAR2
- GIVE_DATE — DATE
- GIVE_USERID — VARCHAR2
- GIVE_CANCEL — CHAR
- GIVE_CONTENT — VARCHAR2
- TAKE_DATE — DATE
- TAKE_USERID — VARCHAR2
- RETURN_PLAN_DATE — DATE
- RETURN_DATE — DATE
- RETURN_USERID — VARCHAR2
- END_DIV — CHAR
- END_DATE — DATE
- END_USERID — VARCHAR2
- END_CONTENT — VARCHAR2
- REG_NO — CHAR
- CALL_NO — VARCHAR2
- TITLE_INFO — VARCHAR2
- AUTHOR_INFO — VARCHAR2
- PUBLISHER_INFO — VARCHAR2
- PUB_YEAR_INFO — VARCHAR2
- PUBLISH_FORM_CODE — CHAR
- VOL_INFO — VARCHAR2
- FIRST_WORK — VARCHAR2
- LAST_WORK — VARCHAR2
- BOOK_KEY — NUMBER
- USER_KEY — NUMBER
- WORKNO — CHAR
- LS_LOAN_DATE — DATE
- LS_RETURN_DATE — DATE
- LOAN_DATE — DATE
- BOOK_APPENDIX_FLAG — CHAR
- MOTHER_KEY — NUMBER
- SPECIES_KEY — NUMBER
- PARENT_TRANS_NO — NUMBER
KL_LOCAL_TEMP_INFO_TBL
- REC_KEY — NUMBER — NOT NULL
- REQUEST_FRAME — VARCHAR2
- RESULT_FRAME — VARCHAR2
- RECORD_DATE — DATE
- UPLOAD_TRY_CNT — NUMBER
- UPLOAD_FAIL_REASON_CODE — CHAR
- FIRST_WORK — VARCHAR2
- LAST_WORK — VARCHAR2
- STATUS — CHAR
LS_WORK_T01
- REC_KEY — NUMBER — Primary key — NOT NULL
- PUBLISH_FORM_CODE — CHAR
- BOOK_KEY — NUMBER — NOT NULL
- USER_KEY — NUMBER — NOT NULL
- LOAN_KEY — NUMBER
- LOAN_TYPE_CODE — CHAR
- RETURN_TYPE_CODE — CHAR
- LOAN_DATE — DATE
- RETURN_PLAN_DATE — DATE
- RESERVATION_DATE — DATE
- RESERVATION_EXPIRE_DATE — DATE
- RETURN_DATE — DATE
- STATUS — CHAR
- SHELF_LOC_CODE — VARCHAR2
- ARREAR — NUMBER
- REPARATION — NUMBER
- CLASS_NO_TYPE — CHAR
- CLASS_NO — VARCHAR2
- MANAGE_CODE — VARCHAR2
- REG_CODE — VARCHAR2
- MEMBER_CLASS — CHAR
- SPECIES_KEY — NUMBER
- SEPARATE_SHELF_CODE — VARCHAR2
- REG_NO — CHAR
- TITLE — VARCHAR2
- AUTHOR — VARCHAR2
- PUBLISHER — VARCHAR2
- CALL_NO — VARCHAR2
- DELAY_CNT — NUMBER
- RESERVE_CANCEL_DATE — DATE
- DELAY_RETURN_DATE — DATE
- PRE_RETURN_PLAN_DATE — DATE
- SELF_RETURN_STATION — VARCHAR2
- SELF_RETURN_DOOR — VARCHAR2
- SELF_LOAN_STATION — VARCHAR2
- LOAN_MANAGE_CODE — CHAR
- RETURN_MANAGE_CODE — CHAR
- VOL_INFO — NUMBER
- RECEIPT_LOAN_KEY — NUMBER
- RECEIPT_RETURN_KEY — NUMBER
- RECEIPT_PRINT_LOAN_YN — CHAR
- RECEIPT_PRINT_RETURN_YN — CHAR
- NIGHT_RESERVATION_LOAN — CHAR
- UNMANNED_RESERVATION_LOAN — CHAR
- RESERVATION_CANCEL_TYPE — CHAR
- PREENGAGE_CANCEL_LIMIT_COUNT — NUMBER
- PREENGAGE_CANCEL_LIMIT_PERIOD — NUMBER
- USER_CLASS_CODE — VARCHAR2
- USER_POSITION_CODE — VARCHAR2
- REQUEST_LIB_CODE — CHAR
- FIRST_WORK — VARCHAR2
- LAST_WORK — VARCHAR2
- L_DEVICE — VARCHAR2
- R_DEVICE — VARCHAR2
- L_WORKER — VARCHAR2
- R_WORKER — VARCHAR2
- NIGHT_RESERVATION_SMS_SEND_YN — CHAR
- PAYMENT_DATE — DATE
- PAYMENTS — NUMBER
- ACCEPTER_KEY — NUMBER
- … +18
MN_LIBINFO2_TBL
- REC_KEY — NUMBER — Primary key — NOT NULL
- MANAGE_CODE — CHAR
- LIB_NAME — VARCHAR2
- LIB_DIRECTOR_NAME — VARCHAR2
- LIB_CODE — CHAR
- LIB_ZIP_CODE — VARCHAR2
- LIB_ADDRESS — VARCHAR2
- LIB_TEL — VARCHAR2
- LIB_FAX — VARCHAR2
- LIB_URL — VARCHAR2
- LIB_EMAIL — VARCHAR2
- FIRST_WORK — VARCHAR2
- LAST_WORK — VARCHAR2
- SMS_LIB_NAME — VARCHAR2
- SMS_CALLBACK_PHONE — VARCHAR2
- SELF — CHAR
- PROGRAM_TYPE — VARCHAR2
- DISPERSION_ILL_USE — CHAR
- DISPERSION_REGION — CHAR
- MID_CONN_INFO — VARCHAR2
- PUB_LIB_YN — CHAR
- PUB_LIB_KEY — VARCHAR2
- DISPERSION_REGION_ALIAS — VARCHAR2