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

CONTENT_FILES

Columns

NameTypeNullableDefault valueComment
CONTENT_FILE_IDNUMBER(38)N  
SECTION_IDNUMBER(38)Y  
FILE_NAMEVARCHAR2(30.0)N  
FILE_TYPEVARCHAR2(100.0)N  
FILE_EXTENSIONVARCHAR2(50.0)Y  
PAGE_PRETTY_NAMEVARCHAR2(200.0)Y  
BODYCLOBY  
HTML_PCHAR(1.0)Y'f'  
BINARY_DATABLOBY  

Primary key:

Constraint NameColumns
SYS_C002087426CONTENT_FILE_ID

Check Constraints:

Constraint NameCheck Condition
SYS_C002087423"FILE_NAME" IS NOT NULL
SYS_C002087424"FILE_TYPE" IS NOT NULL
SYS_C002087425html_p in ('t','f')

Foreign Keys:

Constraint NameColumnsReferenced tableReferenced ConstraintOn Delete Rule
SYS_C002087427SECTION_ID CONTENT_SECTIONS SYS_C002087416 NO ACTION

Unique Keys:

Constraint nameColumns
CONTENT_FILE_NAMES_UNIQUESECTION_ID , FILE_NAME

Options:

OptionSettings
Index OrganizedNo
Generated by OracleNo
ClusteredNo
NestedNo
TemporaryNo

Indexes:

Index NameTypeUnuquenessColumns
CONTENT_FILE_NAMES_UNIQUENORMALUNIQUESECTION_ID , FILE_NAME
SYS_C002087426NORMALUNIQUECONTENT_FILE_ID
SYS_IL0001976449C00007$$LOBUNIQUE 
SYS_IL0001976449C00009$$LOBUNIQUE 

Generated by OraSchemaDoc, (c) Aram Kananov, 2002