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)