ACS3 Data Model

STATIC_PAGES

Name	Type	Nullable	Default value
PAGE_ID	NUMBER(38)	N
URL_STUB	VARCHAR2(400.0)	N
ORIGINAL_AUTHOR	NUMBER(38)	Y
PAGE_TITLE	VARCHAR2(4000.0)	Y
PAGE_BODY	CLOB	Y
DRAFT_P	CHAR(1.0)	Y	'f'
OBSOLETE_P	CHAR(1.0)	Y	'f'
MEMBERS_ONLY_P	CHAR(1.0)	Y	'f'
PRICE	NUMBER(38)	Y
COPYRIGHT_INFO	VARCHAR2(4000.0)	Y
ACCEPT_COMMENTS_P	CHAR(1.0)	Y	't'
ACCEPT_LINKS_P	CHAR(1.0)	Y	't'
INLINE_COMMENTS_P	CHAR(1.0)	Y	't'
INLINE_LINKS_P	CHAR(1.0)	Y	't'
INDEX_P	CHAR(1.0)	Y	't'
INDEX_DECISION_MADE_BY	VARCHAR2(30.0)	Y	'robot'
MENU_P	CHAR(1.0)	Y	't'
UPLINK	VARCHAR2(200.0)	Y
FILE_SIZE	NUMBER(38)	Y
LAST_UPDATED	DATE	Y
PUBLISH_DATE	DATE	Y

Constraint Name	Columns
SYS_C002087200	PAGE_ID

Constraint Name	Check Condition
SYS_C002087188	"PAGE_ID" IS NOT NULL
SYS_C002087189	"URL_STUB" IS NOT NULL
SYS_C002087190	draft_p in ('t','f')
SYS_C002087191	obsolete_p in ('t','f')
SYS_C002087192	members_only_p in ('t','f')
SYS_C002087193	accept_comments_p in ('t','f')
SYS_C002087194	accept_links_p in ('t','f')
SYS_C002087195	inline_comments_p in ('t','f')
SYS_C002087196	inline_links_p in ('t','f')
SYS_C002087197	index_p in ('t','f')
SYS_C002087198	index_decision_made_by in ('human', 'robot')
SYS_C002087199	menu_p in ('t','f')

Constraint Name	Columns	Referenced table	Referenced Constraint	On Delete Rule
SYS_C002087202	ORIGINAL_AUTHOR	USERS	SYS_C002087135	NO ACTION

Constraint name	Columns
SYS_C002087201	URL_STUB

Index Name	Type	Unuqueness	Columns
SYS_C002087200	NORMAL	UNIQUE	PAGE_ID
SYS_C002087201	NORMAL	UNIQUE	URL_STUB
SYS_IL0001976317C00005$$	LOB	UNIQUE

Generated by OraSchemaDoc, (c) Aram Kananov, 2002