Main Tables Views Indexes Constraints Triggers Procedures Functions Packages Sanity check Index

ACS3 Data Model

Description Columns Primary key Check Constraints Foreign keys Unique Keys Options Indexes Referenced by Triggers

STATIC_PAGES

Columns

NameTypeNullableDefault valueComment
PAGE_IDNUMBER(38)N  
URL_STUBVARCHAR2(400.0)N  
ORIGINAL_AUTHORNUMBER(38)Y  
PAGE_TITLEVARCHAR2(4000.0)Y  
PAGE_BODYCLOBY  
DRAFT_PCHAR(1.0)Y'f'  
OBSOLETE_PCHAR(1.0)Y'f'  
MEMBERS_ONLY_PCHAR(1.0)Y'f'  
PRICENUMBER(38)Y  
COPYRIGHT_INFOVARCHAR2(4000.0)Y  
ACCEPT_COMMENTS_PCHAR(1.0)Y't'  
ACCEPT_LINKS_PCHAR(1.0)Y't'  
INLINE_COMMENTS_PCHAR(1.0)Y't'  
INLINE_LINKS_PCHAR(1.0)Y't'  
INDEX_PCHAR(1.0)Y't'  
INDEX_DECISION_MADE_BYVARCHAR2(30.0)Y'robot'  
MENU_PCHAR(1.0)Y't'  
UPLINKVARCHAR2(200.0)Y  
FILE_SIZENUMBER(38)Y  
LAST_UPDATEDDATEY  
PUBLISH_DATEDATEY  

Primary key:

Constraint NameColumns
SYS_C002087200PAGE_ID

Check Constraints:

Constraint NameCheck Condition
SYS_C002087188"PAGE_ID" IS NOT NULL
SYS_C002087189"URL_STUB" IS NOT NULL
SYS_C002087190draft_p in ('t','f')
SYS_C002087191obsolete_p in ('t','f')
SYS_C002087192members_only_p in ('t','f')
SYS_C002087193accept_comments_p in ('t','f')
SYS_C002087194accept_links_p in ('t','f')
SYS_C002087195inline_comments_p in ('t','f')
SYS_C002087196inline_links_p in ('t','f')
SYS_C002087197index_p in ('t','f')
SYS_C002087198index_decision_made_by in ('human', 'robot')
SYS_C002087199menu_p in ('t','f')

Foreign Keys:

Constraint NameColumnsReferenced tableReferenced ConstraintOn Delete Rule
SYS_C002087202ORIGINAL_AUTHOR USERS SYS_C002087135 NO ACTION

Unique Keys:

Constraint nameColumns
SYS_C002087201URL_STUB

Options:

OptionSettings
Index OrganizedNo
Generated by OracleNo
ClusteredNo
NestedNo
TemporaryNo

Indexes:

Index NameTypeUnuquenessColumns
SYS_C002087200NORMALUNIQUEPAGE_ID
SYS_C002087201NORMALUNIQUEURL_STUB
SYS_IL0001976317C00005$$LOBUNIQUE 

Referenced by:

TableConstraint
STATIC_PAGE_AUTHORS SYS_C002087207
COMMENTS SYS_C002087224
LINKS SYS_C002087233
LINK_KILL_PATTERNS SYS_C002087239
USER_CONTENT_MAP SYS_C002087246


Generated by OraSchemaDoc, (c) Aram Kananov, 2002