DBPrism CMS stores page elements in the following table
- The CMS_DOCS table stores rows of SYS.XMLTYPE(XMLSchema "http://www.dbprism.com.ar/xsd/document-v20.xsd" Element "document") STORAGE Object-relational TYPE "document". That is, documents of DBPrism CMS will be stored into object-relation format as is described below. DBPrism CMS uses Apache document-v20.dtd format.
- The CMS_RELATED table stores pages which is a related topic from other page. Related has from/to information which permites a mesh structure of the related pages.
- The ARCHIVED_CMS_DOCS table stores archiving information of the pages, every page modified is backupd into this table two provide recovery process.
- FAQ builder uses two tables, FAQ_SECTIONS and FAQ_TOPICS,
- News Builder uses two tables, NEWS_CATEGORIES and NEWS_ARTICLES.
- RSS Builder uses three tables, RSS_SITES, RSS_CHANNELS and RSS_ITEMS.
CMS data model
CMS_DATA schema tables
| TABLE of | SYS.XMLTYPE(XMLSchema "http://www.dbprism.com.ar/xsd/document-v20.xsd" Element "document") STORAGE Object-relational TYPE "document" |
The Object Types described below are automatically generated by the procedure DBMS_XMLSCHEMA.registerURI using the schema annotations of etc/document-v20-ann.xsd file. This file is a store optimized version of the Apache document-v20.xsd.
| Name | null? - type |
|---|---|
| SYS_XDBPD$ | XDB.XDB$RAW_LIST_T |
| id | VARCHAR2(4000 CHAR) |
| lang | VARCHAR2(4000 CHAR) |
| header | headerType |
| body | CLOB |
| footer | footerType |
| Name | null? - type |
|---|---|
| id | VARCHAR2(4000 CHAR) |
| lang | VARCHAR2(4000 CHAR) |
| title | VARCHAR2(4000 CHAR) |
| subtitle | VARCHAR2(4000 CHAR) |
| version | versionType |
| type | VARCHAR2(4000 CHAR) |
| authors | authorsType |
| notice | VARCHAR2(4000 CHAR) |
| abstract | VARCHAR2(4000 CHAR) |
| meta | metaList |
| Name | null? - type |
|---|---|
| SYS_XDBPD$ | XDB.XDB$RAW_LIST_T |
| SYS_XDBBODY$ | VARCHAR2(4000 CHAR) |
| id | VARCHAR2(4000 CHAR) |
| lang | VARCHAR2(4000 CHAR) |
| major | VARCHAR2(4000 CHAR) |
| minor | VARCHAR2(4000 CHAR) |
| fix | VARCHAR2(4000 CHAR) |
| tag | VARCHAR2(4000 CHAR) |
| Name | null? - type |
|---|---|
| SYS_XDBPD$ | XDB.XDB$RAW_LIST_T |
| id | VARCHAR2(4000 CHAR) |
| lang | VARCHAR2(4000 CHAR) |
| person | personList |
| personList | VARRAY(2147483647) OF personType |
|---|---|
| personType | is NOT FINAL |
| Name | null? - type |
| SYS_XDBPD$ | XDB.XDB$RAW_LIST_T |
| id | VARCHAR2(4000 CHAR) |
| lang | VARCHAR2(4000 CHAR) |
| name | VARCHAR2(4000 CHAR) |
| VARCHAR2(4000 CHAR) |
| metaList | VARRAY(2147483647) OF metaType |
|---|---|
| metaType | is NOT FINAL |
| Name | null? - type |
| SYS_XDBPD$ | XDB.XDB$RAW_LIST_T |
| SYS_XDBBODY$ | VARCHAR2(4000 CHAR) |
| name | VARCHAR2(4000 CHAR) |
| id | VARCHAR2(4000 CHAR) |
| lang | VARCHAR2(4000 CHAR) |
| footerType | is NOT FINAL |
|---|---|
| Name | null? - type |
| legal | VARCHAR2(4000 CHAR) |
| Name | null? - type |
|---|---|
| OWNER | VARCHAR2(30) |
| PAGE_FROM | NOT NULL VARCHAR2(3000) |
| PAGE_TO | NOT NULL VARCHAR2(3000) |
NEWS Data Model
| Name | null? - type |
|---|---|
| id | NOT NULL VARCHAR2(10) |
| lang | VARCHAR2(32) |
| tile | VARCHAR2(4000) |
| Name | null? - type |
|---|---|
| art_cat_id | VARCHAR2(10) |
| id | NOT NULL VARCHAR2(10) |
| lang | VARCHAR2(32) |
| url | VARCHAR2(4000) |
| headline_text | VARCHAR2(4000) |
| source | VARCHAR2(255) |
| media_type | VARCHAR2(255) |
| m_cluster | VARCHAR2(255) |
| tagline | VARCHAR2(255) |
| document_url | VARCHAR2(4000) |
| harvest_time | VARCHAR2(255) |
| access_registration | VARCHAR2(255) |
| access_status | VARCHAR2(255) |
FAQ Data Model
| Name | null? - type |
|---|---|
| section_id | NOT NULL NUMBER(10) |
| id | VARCHAR2(255) |
| lang | VARCHAR2(32) |
| title | VARCHAR2(4000) |
| owner | VARCHAR2(255) |
| created | DATE |
| modified | DATE |
| deleted | VARCHAR2(1) |
| created_by | VARCHAR2(255) |
| modified_by | VARCHAR2(255) |
FAQ_TOPICS
| topic_id | NOT NULL NUMBER(10) |
|---|---|
| id | VARCHAR2(255) |
| lang | VARCHAR2(32) |
| tp_section_id | NOT NULL NUMBER(10) |
| owner | VARCHAR2(255) |
| question | VARCHAR2(4000) |
| answer | VARCHAR2(4000) |
| created | DATE |
| modified | DATE |
| deleted | VARCHAR2(1) |
| created_by | VARCHAR2(255) |
| modified_by | VARCHAR2(255) |
This work is licensed under a
Creative Commons License
.
