DBPrism CMS stores page elements in the following tables
The PAGES table stores one row of structural information and other
metadata for each page. Each page is identified by a unique number
stored in the ID_PAGE column (which references the CN_ID_PAGE column
of the CONTENT table). Pages have PARENT foreign key to self, which
permits directory like structure.
The CONTENT table stores each version of a page's content in a
unique row identified by CN_ID_PAGE number and VERSION number, with
the actual content residing in a CLOB column. The CMS stores multiple
versions of a content block and uses a specified version to build a
page. The CONTENT table is linked to the PAGES table by ID number.
The RELATED table stores which pages is a related topic from other
page. Related has from/to information which permites
a mesh structure of the related pages.
FAQ builder uses two tables, FAQ_SECTIONS and FAQ_TOPICS,
News Builder uses two tables, NEWS_CATEGORIES and NEWS_ARTICLES.
Previous version of DB Prism CMS includes stylesheets
and templates tables, this version do not include these
tables because Cocoon2 architecture replace this responsabilities with
the sitemap.
CMS data model
PAGES
ID_PAGE
NOT NULL NUMBER(10)
parent
NUMBER(10)
name
VARCHAR2(255)
longname
VARCHAR2(4000)
created
DATE
modified
DATE
comments
VARCHAR2(4000)
meta
VARCHAR2(4000)
path
VARCHAR2(4000)
languaje
VARCHAR2(32)
deleted
VARCHAR2(1)
created_by
NUMBER(5)
modified_by
NUMBER(5)
status
VARCHAR2(255)
file_size
NUMBER(10)
current_version
NUMBER(6)
printable_version
VARCHAR2(1)
u_id|g_id
NUMBER(5)
u_{read|write|insert}
VARCHAR2(1)
g_{read|write|insert}
VARCHAR2(1)
o_{read|write|insert}
VARCHAR2(1)
CONTENT
cn_id_page
NOT NULL NUMBER(10)
version
NOT NULL NUMBER(6)
owner
VARCHAR2(255)
status
VARCHAR2(255)
source_file
VARCHAR2(4000)
file_size
NUMBER(10)
content
CLOB
created
DATE
modified
DATE
created_by
VARCHAR2(255)
modified_by
VARCHAR2(255)
RELATED
rl_id_page_from
NOT NULL NUMBER(10)
rl_id_page_to
NOT NULL NUMBER(10)
NEWS Data Model
NEWS_CATEGORIES
id
NOT NULL VARCHAR2(10)
lang
VARCHAR2(32)
tile
VARCHAR2(4000)
NEWS_ARTICLES
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
FAQ_SECTIONS
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)
Last Update: 2003-08-07 09:42:37.0|
webmaster@dbprism.com.ar
(C) 2003 - DBPrism ~ DBPrism CMS
| Marcelo F. Ochoa | TANDIL ~ Argentina
