CMS

테이블 (3)

에셋 테이블 (FWK_CMS_ASSET)

  • ASSET_ID — VARCHAR2(50) — 기본 키 — NOT NULL
  • ASSET_NAME — VARCHAR2(50)
  • ASSET_CATEGORY — VARCHAR2(10)
  • ASSET_SUB_CATEGORY — VARCHAR2(10)
  • THUMBNAIL — VARCHAR2(300)
  • FILE_PATH — VARCHAR2(300)
  • CREATE_USER_ID — VARCHAR2(10)
  • CREATE_USER_NAME — VARCHAR2(10)
  • LAST_MODIFIER_ID — VARCHAR2(10)
  • LAST_MODIFIER_NAME (LAST_MODIFIER_NAMEN) — VARCHAR2(10)
  • APPROVER_ID — VARCHAR2(10)
  • APPROVER_NAME — VARCHAR2(10)
  • CREATE_DTIME — VARCHAR2(8)
  • CONFIRM_DTIME — VARCHAR2(8)
  • BEGINNING_DTIME — VARCHAR2(8)
  • EXPIRED_DTIME (EXPIRED_DTIMET) — VARCHAR2(8)
  • APPROVE_STATE — CHAR(10)
  • LAST_MODIFIED_DTIME — VARCHAR2(8)
  • ASSET_DESC — VARCHAR2(300)
  • ASSET_DESC_DETAIL — VARCHAR2(2000)
  • ASSET_TYPE — VARCHAR2(10)

에셋-페이지 매핑 테이블 (FWK_CMS_ASSET_PAGE_MAPPING_TABLE)

  • PAGE_ID — VARCHAR2(50) — 외래 키 → 페이지 테이블.PAGE_ID — NOT NULL
  • ASSET_ID (BASIC_ASSET_ID) — VARCHAR2(50) — 외래 키 → 에셋 테이블.ASSET_ID — NOT NULL

페이지 테이블 (FWK_CMS_PAGE)

  • PAGE_ID — VARCHAR2(50) — 기본 키 — NOT NULL
  • PAGE_NAME — VARCHAR2(50)
  • PAGE_CATEGORY — VARCHAR2(10)
  • OWNER_DEPT_CODE — VARCHAR2(10)
  • FILE_PATH — VARCHAR2(300)
  • CREATE_USER_ID — VARCHAR2(10)
  • CREATE_USER_NAME — VARCHAR2(10)
  • LAST_MODIFIER_ID — VARCHAR2(10)
  • LAST_MODIFIER_NAME (LAST_MODIFIER_NAMEN) — VARCHAR2(10)
  • APPROVER_ID — VARCHAR2(10)
  • APPROVER_NAME — VARCHAR2(10)
  • CREATE_DTIME — VARCHAR2(8)
  • CONFIRM_DTIME — VARCHAR2(8)
  • BEGINNING_DTIME — VARCHAR2(8)
  • EXPIRED_DTIME (EXPIRED_DTIMET) — VARCHAR2(8)
  • APPROVE_STATE — CHAR(10)
  • LAST_MODIFIED_DTIME — VARCHAR2(8)
  • PAGE_DESC — VARCHAR2(300)
  • PAGE_DESC_DETAIL — VARCHAR2(2000)
  • PARENT_PAGE_ID — VARCHAR2(50)