민주화ERD
테이블 (91)
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) — 기본 키 — 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)
AMS_CLASSFORM
- REGNO — VARCHAR2(128)
- DATA_TYPE — VARCHAR2(128)
- DATA_TYPE_NAME — VARCHAR2(128)
- DATA_DETAIL — VARCHAR2(128)
- DATA_DETAIL_NAME — VARCHAR2(128)
- CLASS_FORM — VARCHAR2(128)
- CLASS_TYPE — VARCHAR2(128)
ARCH_CONTENTS
- TITLE — VARCHAR2(4000)
- CONTENT — CLOB
- URL — VARCHAR2(4000)
- IMG_URL — VARCHAR2(4000)
- REGNO — VARCHAR2(20)
ARCH_PEOPLE
- P_NAME — VARCHAR2(100)
- TITLE — VARCHAR2(4000)
- CONTENT — CLOB
- FIL_URL — VARCHAR2(4000)
- IMG_URL — VARCHAR2(4000)
- REGNO — VARCHAR2(20)
AW_ACCOUNT_CLOSE
- SEQ — NUMBER
- USER_UUID — CHAR(32)
- USER_EMAIL — VARCHAR2(200)
- CONTENT — VARCHAR2(4000)
- REG_DT — DATE
AW_CATEGORY
- SEQ — NUMBER
- 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
- CATE_SEQ — NUMBER
- ITEM_SEQ — VARCHAR2(200)
- ITEM_TYPE — CHAR(2)
AW_CONTENTS
- SEQ — NUMBER
- 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
- P_SEQ — VARCHAR2(20)
- 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 — 기본 키 — 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 — 기본 키 — 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_FILE_INFO_TEMP
- 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_INQURY_INFO
- SEQ — NUMBER — 기본 키 — 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_INQURY_INFO_TEST
- SEQ — NUMBER — 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)
AW_INTEREST_ISAD
- SEQ — NUMBER
- USER_UUID — CHAR(32)
- REGNO — VARCHAR2(8)
- REG_DT — DATE
AW_LIBRARY_INFO
- SEQ — NUMBER — 기본 키 — 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_MAIN_BAK
- 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)
AW_MAIN_TEMP
- 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
- SEQ — NUMBER
- 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 — 기본 키 — 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 — 기본 키 — 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
- SEQ — NUMBER
- 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
- REQ_SEQ — NUMBER
- REQ_TYPE — CHAR(2)
- REGNO — VARCHAR2(8)
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 — 기본 키 — 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
- SEQ — NUMBER
- P_SEQ — NUMBER
- 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
- SEQ — NUMBER
- 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) — 기본 키 — 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)
BOOKSTACK_INFO_20150718
- 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_REFERENCE
- DEPTH_FIRST — VARCHAR2(128) — 기본 키 — NOT NULL
- CLASSIFICATION_CODE_ID — VARCHAR2(10) — NOT NULL
- DEPTH_SECOND — VARCHAR2(128)
- DEPTH_THIRD — VARCHAR2(128)
CLASS_FORM
- CLASS_FORM_ID — VARCHAR2(12) — 기본 키 — NOT NULL
- REGNO — VARCHAR2(10) — NOT NULL
- CLASS_FORM — VARCHAR2(32)
CLASS_FORM_BAK
- CLASS_FORM_ID — VARCHAR2(12) — NOT NULL
- REGNO — VARCHAR2(10) — NOT NULL
- CLASS_FORM — VARCHAR2(32) — NOT NULL
CLASS_FORM_TEMP
- CLASS_FORM_ID — VARCHAR2(12)
- REGNO — VARCHAR2(10)
- CLASS_FORM — VARCHAR2(32)
CLASS_TYPE
- CLASS_TYPE_ID — VARCHAR2(12) — 기본 키 — NOT NULL
- REGNO — VARCHAR2(10) — NOT NULL
- CLASS_TYPE — VARCHAR2(32)
CLASS_TYPE_BAK
- CLASS_TYPE_ID — VARCHAR2(12) — NOT NULL
- REGNO — VARCHAR2(10) — NOT NULL
- CLASS_TYPE — VARCHAR2(32) — NOT NULL
CLASS_TYPE_TEMP
- CLASS_TYPE_ID — VARCHAR2(12)
- REGNO — VARCHAR2(10)
- CLASS_TYPE — VARCHAR2(32)
CODE_TYPE
- CODE_TYPE_ID — VARCHAR2(32) — 기본 키 — 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)
DOCUMENT_INFO
- DOCUMENT_NO — VARCHAR2(10) — 기본 키 — NOT NULL
- TITLE — VARCHAR2(500) — 제목
- CONTENT — CLOB — 내용
- REG_ID — VARCHAR2(32) — 등록자
- REG_DT — VARCHAR2(10) — 등록일
- MOD_ID — VARCHAR2(32) — 수정자
- MOD_DT — VARCHAR2(10) — 수정일
DUPITEM_INFO
- DUP_ITEMNO — VARCHAR2(10) — 기본 키 — NOT NULL
- DUPITEM_NOTE — VARCHAR2(4000) — NOT NULL
- REG_DT — VARCHAR2(10) — NOT NULL
- REG_ID — VARCHAR2(32) — NOT NULL
- MOD_DT — VARCHAR2(10)
- MOD_ID — VARCHAR2(32)
ISAD_CLASS_BACK_20140406
- REGNO — VARCHAR2(10) — NOT NULL
- BOX_REGNO — VARCHAR2(10)
- COLLECT_NO — VARCHAR2(9) — NOT NULL
- DUP_ITEMNO — VARCHAR2(10)
- OLDBOX_REGNO — 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)
- … +1
ISAD_CLASS_BACK_20210421
- REGNO — VARCHAR2(10) — NOT NULL
- BOX_REGNO — VARCHAR2(10)
- COLLECT_NO — VARCHAR2(9) — NOT NULL
- DUP_ITEMNO — VARCHAR2(10)
- OLDBOX_REGNO — 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
ISAD_CLASS_BACK_20220623
- REGNO — VARCHAR2(10) — NOT NULL
- BOX_REGNO — VARCHAR2(10)
- COLLECT_NO — VARCHAR2(9) — NOT NULL
- DUP_ITEMNO — VARCHAR2(10)
- OLDBOX_REGNO — 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
ISAD_CLASS_BACK_20221229
- REGNO — VARCHAR2(10) — NOT NULL
- BOX_REGNO — VARCHAR2(10)
- COLLECT_NO — VARCHAR2(9) — NOT NULL
- DUP_ITEMNO — VARCHAR2(10)
- OLDBOX_REGNO — 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
ISAD_CLASS_BACK_20230104
- REGNO — VARCHAR2(10) — NOT NULL
- BOX_REGNO — VARCHAR2(10)
- COLLECT_NO — VARCHAR2(9) — NOT NULL
- DUP_ITEMNO — VARCHAR2(10)
- OLDBOX_REGNO — 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
ISAD_CLASS_BACK_20231205
- REGNO — VARCHAR2(10) — NOT NULL
- BOX_REGNO — VARCHAR2(10)
- COLLECT_NO — VARCHAR2(9) — NOT NULL
- DUP_ITEMNO — VARCHAR2(10)
- OLDBOX_REGNO — 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
ISAD_CLASS_CHTW
- REGNO — VARCHAR2(255)
- BOX_REGNO — VARCHAR2(255)
- COLLECT_NO — VARCHAR2(255)
- DUP_ITEMNO — VARCHAR2(255)
- OLDBOX_REGNO — VARCHAR2(255)
- REFERENCE_CODE — VARCHAR2(255)
- TITLE — VARCHAR2(255)
- LEVEL_NO — VARCHAR2(255)
- CLASS_FORM — VARCHAR2(255)
- CLASS_TYPE — VARCHAR2(255)
- GRADE — VARCHAR2(255)
- QUANTITY — NUMBER(*,0)
- DUP_QUANTITY — NUMBER(*,0)
- PRODUCT_START_DT — NUMBER(*,0)
- CREATOR — VARCHAR2(255)
- RECORD_HISTORY — VARCHAR2(255)
- DISUSE_CONTENT — VARCHAR2(255)
- DISUSE_SCHEDULE — VARCHAR2(255)
- ACCRUALS — VARCHAR2(255)
- ARRANGE_SYSTEM — VARCHAR2(255)
- REPRODUCTION — VARCHAR2(255)
- LANGUAGE — VARCHAR2(255)
- PHYSICAL_INFO — VARCHAR2(255)
- FINDING_AIDS — VARCHAR2(255)
- ORIGIN_LOCATION — VARCHAR2(255)
- COPY_LOCATION — VARCHAR2(255)
- NOTE — VARCHAR2(255)
- ARCHIVIST_NOTE — VARCHAR2(255)
- RULE — VARCHAR2(255)
- EVENT — VARCHAR2(255)
- ORGANIZATION — VARCHAR2(255)
- PERSON — VARCHAR2(255)
- PLACE — VARCHAR2(255)
- REGION — VARCHAR2(255)
- FIELDS — VARCHAR2(255)
- MEDIA_INFO — VARCHAR2(255)
- MEDIA_COLOR — VARCHAR2(255)
- MEDIA_SIZE — VARCHAR2(255)
- MEDIA_QUALITY — VARCHAR2(255)
- PARTITION_RULE — VARCHAR2(255)
- PLAY_TIME — VARCHAR2(255)
- PRESERVATION — VARCHAR2(255)
- REPAIR — VARCHAR2(255)
- PROVENANCE — VARCHAR2(255)
- WORK_NOTE — VARCHAR2(255)
- KEYWORDS — VARCHAR2(255)
- IS_OPEN — VARCHAR2(255)
- PARENT_REGNO — VARCHAR2(255)
- SORT_CLASS_TITLE — VARCHAR2(255)
- SORT_CREATOR — VARCHAR2(255)
- SORT_PRODUCT_START_DT — NUMBER(*,0)
- MANUSCRIPT_STS — VARCHAR2(255)
- IS_DEL — VARCHAR2(255)
- REG_ID — VARCHAR2(255)
- REG_DT — NUMBER(*,0)
- MOD_ID — VARCHAR2(255)
- MOD_DT — VARCHAR2(255)
- PRODUCT_END_DT — VARCHAR2(255)
- SORT_PRODUCT_END_DT — VARCHAR2(255)
- DEL_REASON — VARCHAR2(255)
- … +10
ISAD_TMP_FL
- REGNO — VARCHAR2(10)
- TITLE — VARCHAR2(4000)
- CREATOR — VARCHAR2(2048)
- DONOR — VARCHAR2(2048)
- CREATE_DT — VARCHAR2(48)
- DOCTYPE — VARCHAR2(128)
- XIF — VARCHAR2(10)
- NUM — NUMBER(10,0)
ISAD_UPDATE_LOG
- REGNO — VARCHAR2(10)
- ACTION — CHAR(1)
- ISSUEDATE — DATE
- IS_OPEN — VARCHAR2(32)
- IS_DEL — VARCHAR2(32)
KDEMO_ATCH
- ATCH_CD — CHAR(4) — 기본 키 — NOT NULL
- DATA_ID — NUMBER — 기본 키 — NOT NULL
- ATCH_NM — VARCHAR2(600)
- ATCH_PATH — VARCHAR2(1000)
- REG_DT — CHAR(17) — NOT NULL
- ATCH_ID — NUMBER(15,5)
KDEMO_BBS
- BBS_ID — NUMBER — 기본 키 — NOT NULL
- BBS_KIND_ID — NUMBER — NOT NULL
- BBS_SEQ — VARCHAR2(100) — NOT NULL
- BBS_NTC_YN — CHAR(1) — NOT NULL
- BBS_SCRT_YN — CHAR(1) — NOT NULL
- BBS_DEL_YN — CHAR(1) — NOT NULL
- BBS_HTML_YN — CHAR(1) — NOT NULL
- BBS_TITLE — VARCHAR2(300) — NOT NULL
- BBS_CNTS — CLOB — NOT NULL
- BBS_CNT — NUMBER — NOT NULL
- BBS_PW — VARCHAR2(30)
- BBS_IP — VARCHAR2(20)
- REG_ID — VARCHAR2(10) — NOT NULL
- REG_NM — VARCHAR2(60) — NOT NULL
- REG_DT — CHAR(17) — NOT NULL
- LST_REG_ID — VARCHAR2(10) — NOT NULL
- LST_REG_NM — VARCHAR2(60) — NOT NULL
- LST_REG_DT — CHAR(17) — NOT NULL
KDEMO_BBS_ATCH
- BBS_ID — NUMBER — 기본 키 — NOT NULL
- BBS_ATCH_ID — NUMBER — 기본 키 — NOT NULL
- BBS_ATCH_CD — CHAR(4) — NOT NULL
- BBS_ATCH_NM — VARCHAR2(300)
- BBS_ATCH_PATH — VARCHAR2(600)
- BBS_ATCH_SIZE — NUMBER
- BBS_ATCH_S_PATH — VARCHAR2(600)
- REG_ID — VARCHAR2(10) — NOT NULL
- REG_NM — VARCHAR2(60) — NOT NULL
- REG_DT — CHAR(17) — NOT NULL
KDEMO_BBS_RPLY
- BBS_ID — NUMBER — 기본 키 — NOT NULL
- BBS_KIND_ID — NUMBER — 기본 키 — NOT NULL
- BBS_RPLY_ID — NUMBER — 기본 키 — NOT NULL
- BBS_RPLY_CNTS — VARCHAR2(1500) — NOT NULL
- BBS_RPLY_PW — VARCHAR2(30)
- REG_ID — VARCHAR2(10) — NOT NULL
- REG_NM — VARCHAR2(60) — NOT NULL
- REG_DT — CHAR(17) — NOT NULL
- LST_REG_ID — VARCHAR2(10) — NOT NULL
- LST_REG_NM — VARCHAR2(60) — NOT NULL
- LST_REG_DT — CHAR(17) — NOT NULL
KDEMO_CONTENTS
- CON_MONTH — CHAR(2) — 기본 키 — NOT NULL
- CON_ID — NUMBER — 기본 키 — NOT NULL
- CON_TITLE — VARCHAR2(300)
- CON_NOTE — CLOB
- CON_URL — VARCHAR2(600)
- CON_OPEN — CHAR(4) — NOT NULL
- REG_ID — VARCHAR2(60)
- REG_DT — CHAR(17) — NOT NULL
KDEMO_FRONT
- FRONT_CD — CHAR(4) — 기본 키 — NOT NULL
- FRONT_ID — NUMBER — 기본 키 — NOT NULL
- FRONT_TITLE — VARCHAR2(300)
- FRONT_NOTE — VARCHAR2(4000)
- FRONT_OPEN — CHAR(4) — NOT NULL
- FRONT_URL — VARCHAR2(300)
- FRONT_FRAME — VARCHAR2(300)
- REG_DT — CHAR(17) — NOT NULL
- FRONT_ORDER — NUMBER(15,5)
KDEMO_OPENAPI
- API_NO — NUMBER — 기본 키 — NOT NULL
- API_REQ_NAME — VARCHAR2(200) — NOT NULL
- API_REQ_EMAIL — VARCHAR2(50)
- API_REQ_PHONE — VARCHAR2(100)
- API_REQ_ORG — VARCHAR2(200)
- API_REQ_MSG — VARCHAR2(2000)
- API_KEY — VARCHAR2(100)
- API_STAT — VARCHAR2(2) — NOT NULL
- API_REG_DT — VARCHAR2(8)
KDEMO_PHOTO
- PHOTO_ID — NUMBER — 기본 키 — NOT NULL
- PHOTO_TITLE — VARCHAR2(300)
- PHOTO_OPEN — CHAR(4) — NOT NULL
- REG_DT — CHAR(17) — NOT NULL
- PHOTO_ORDER — NUMBER
- REGNO — VARCHAR2(10)
KDEMO_SUPP_CODE
- CODE_KIND_CD — CHAR(4) — 기본 키 — NOT NULL
- CODE_CD — CHAR(4) — 기본 키 — NOT NULL
- CODE_NM — VARCHAR2(300) — NOT NULL
- CODE_USE_CD — CHAR(4) — NOT NULL
- CODE_ORDER — NUMBER(15,5)
KDEMO_SUPP_RPLY
- SUPP_ID — NUMBER — 기본 키 — NOT NULL
- SUPP_KIND_CD — CHAR(4) — 기본 키 — NOT NULL
- SUPP_RPLY_ID — NUMBER — 기본 키 — NOT NULL
- SUPP_RPLY_CNTS — VARCHAR2(1500) — NOT NULL
- SUPP_RPLY_PW — VARCHAR2(30) — NOT NULL
- REG_ID — VARCHAR2(10) — NOT NULL
- REG_NM — VARCHAR2(60) — NOT NULL
- REG_DT — CHAR(17) — NOT NULL
- LST_REG_ID — VARCHAR2(10) — NOT NULL
- LST_REG_NM — VARCHAR2(60) — NOT NULL
- LST_REG_DT — CHAR(17) — NOT NULL
- SUPP_RPLY_EMAIL — VARCHAR2(300)
LANGUAGE
- LANGUAGE_ID — VARCHAR2(12) — 기본 키 — NOT NULL
- REGNO — VARCHAR2(10)
- LANGUAGE — VARCHAR2(32)
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)
LEAD_INFO_X
- 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)
- COLLECTION_INFO — VARCHAR2(4000)
- REG_ID — VARCHAR2(32) — NOT NULL
- REG_DT — VARCHAR2(10) — NOT NULL
- MOD_ID — VARCHAR2(32)
- MOD_DT — VARCHAR2(10)
- ACTIVITY — CLOB
MEDIA_INFO
- REGNO — VARCHAR2(10) — 기본 키 — 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)
MOBILERACK_INFO_20150718
- MOBILERACK_NO — VARCHAR2(10) — NOT NULL
- BOOKSTACK_NO — VARCHAR2(2) — 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_20150718
- 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
MYARCHIVES
- USERID — VARCHAR2(150) — NOT NULL — 사용자
- REGNO — VARCHAR2(10) — NOT NULL — ISAD_CLASS의
- CREATEDATE — CHAR(8) — NOT NULL — 등록일
NEWMEDIA_CONF
- ROOT_PATH — VARCHAR2(1024)
- VOL_DIR — VARCHAR2(1024)
- THUMB_PATH — VARCHAR2(1024)
NOTICE_FL
- NOTICE_ID — VARCHAR2(32) — NOT NULL
- WRITER — VARCHAR2(32)
- TITLE — VARCHAR2(1024)
- CONTENTS — VARCHAR2(2048)
- WRITED_DATE — VARCHAR2(32)
- VISIT — NUMBER
- NOTICE_YN — CHAR(1)
- ERASE_YN — CHAR(1)
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)
외 11개 테이블