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

USERS_FILES

Columns

NameTypeNullableDefault valueComment
FILE_IDNUMBER(38)N  
FILENAMEVARCHAR2(255.0)N  
DIRECTORY_PCHAR(1.0)Y'f' 
FILE_PRETTY_NAMEVARCHAR2(500.0)N  
MANAGED_PCHAR(1.0)Y'f'  
MODIFYABLE_PCHAR(1.0)Y't'  
FILE_SIZENUMBER(38)N  
CONTENT_TYPENUMBER(38)Y  
OWNER_IDNUMBER(38)N  
PARENT_IDNUMBER(38)Y  

Primary key:

Constraint NameColumns
SYS_C002088317FILE_ID

Check Constraints:

Constraint NameCheck Condition
SYS_C002088310"FILENAME" IS NOT NULL
SYS_C002088311"FILE_PRETTY_NAME" IS NOT NULL
SYS_C002088312"FILE_SIZE" IS NOT NULL
SYS_C002088313"OWNER_ID" IS NOT NULL
SYS_C002088315managed_p in ('t','f')
SYS_C002088316modifyable_p in ('t','f')
USERS_DIR_CKdirectory_p in ('t','f')

Foreign Keys:

Constraint NameColumnsReferenced tableReferenced ConstraintOn Delete Rule
SYS_C002088318CONTENT_TYPE USERS_CONTENT_TYPES SYS_C002088306 NO ACTION
SYS_C002088319OWNER_ID USERS SYS_C002087135 NO ACTION
SYS_C002088320PARENT_ID USERS_FILES SYS_C002088317 NO ACTION

Options:

OptionSettings
Index OrganizedNo
Generated by OracleNo
ClusteredNo
NestedNo
TemporaryNo

Indexes:

Index NameTypeUnuquenessColumns
SYS_C002088317NORMALUNIQUEFILE_ID
USERS_FILES_IDX1NORMALNONUNIQUEFILE_ID , PARENT_ID
USERS_FILES_IDX2NORMALNONUNIQUEPARENT_ID , FILE_ID
USERS_FILES_IDX3NORMALNONUNIQUEOWNER_ID

Referenced by:

TableConstraint
USERS_FILES SYS_C002088320
USERS_FILES_ACCESS_LOG SYS_C002088325


Generated by OraSchemaDoc, (c) Aram Kananov, 2002