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