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

FS_VERSIONS

Columns

NameTypeNullableDefault valueComment
VERSION_IDNUMBER(38)N  
FILE_IDNUMBER(38)N  
VERSION_CONTENTBLOBY  
VERSION_DESCRIPTIONVARCHAR2(500.0)Y  
CREATION_DATEDATEN  
AUTHOR_IDNUMBER(38)N  
CLIENT_FILE_NAMEVARCHAR2(500.0)Y  
FILE_TYPEVARCHAR2(100.0)Y  
FILE_EXTENSIONVARCHAR2(50.0)Y  
SUPERSEDED_BY_IDNUMBER(38)Y  
N_BYTESNUMBER(38)Y  
URLVARCHAR2(200.0)Y  

Primary key:

Constraint NameColumns
SYS_C002087853VERSION_ID

Check Constraints:

Constraint NameCheck Condition
SYS_C002087850"FILE_ID" IS NOT NULL
SYS_C002087851"CREATION_DATE" IS NOT NULL
SYS_C002087852"AUTHOR_ID" IS NOT NULL

Foreign Keys:

Constraint NameColumnsReferenced tableReferenced ConstraintOn Delete Rule
SYS_C002087854FILE_ID FS_FILES SYS_C002087846 NO ACTION
SYS_C002087855AUTHOR_ID USERS SYS_C002087135 NO ACTION
SYS_C002087856SUPERSEDED_BY_ID FS_VERSIONS SYS_C002087853 NO ACTION

Options:

OptionSettings
Index OrganizedNo
Generated by OracleNo
ClusteredNo
NestedNo
TemporaryNo

Indexes:

Index NameTypeUnuquenessColumns
FS_VERSIONS_BY_FILENORMALNONUNIQUEFILE_ID
SYS_C002087853NORMALUNIQUEVERSION_ID
SYS_IL0001976735C00003$$LOBUNIQUE 

Referenced by:

TableConstraint
FS_VERSIONS SYS_C002087856

Generated by OraSchemaDoc, (c) Aram Kananov, 2002