Element Type Definition: PRIMARY_ACCESS

Oracle Designer Model, Release 6i
Element Type Definition

Element Type Name	PRIMARY_ACCESS_FILE
Short Name	FILES
View Name	CI_PRIMARY_ACCESS_FILES
Description	A file stored in the database, that is downloadable to the file system

Sub-type of	SHAREABLE_ELEMENT
Versioning:	Structure of PRIMARY_ACCESS_FILE versionable object
Rules:	API Spec Uniqueness Criteria Deletion Rules
Descriptor:	NAME
Used by:	Oracle Designer JDeveloper Enterprise Edition Core Repository
Underlying table:	SDD_FILES

Reference Properties
Name	Opt ?	Notes	Relationship	In Arc

Properties
Name	Datatype	Opt ?	Notes	Domain	Default Value
COMPRESSED_CONTENTS	BLOB	Y	The serialized delta table object. Stores the file in its compressed form, according to the COMPRESSION_METHOD indicated on SDD_OBJECT_VERSIONS Not displayed System maintained Not updatable by user	APICONVERT_BLOB
CONTENTS_BLOB	BLOB	Y	File contents, for large binary Not displayed System maintained Not updatable by user	APICONVERT_BLOB
CONTENTS_CLOB	CLOB	Y	File contents, for large ascii Not displayed System maintained Not updatable by user	APICONVERT_CLOB
CRC	VARCHAR2(20)	Y	CRC32 signature of the file binary object Not displayed System maintained Not updatable by user
FILE_SIZE	NUMBER(10, 0)	Y	Size of the file in bytes Prompt: Size System maintained Not updatable by user
KIND	VARCHAR2(1)	N	Discriminator property indicating the nature of the file stored Prompt: Kind Uppercase System maintained Not updatable by user	FILE_KIND	U
NAME	VARCHAR2(256)	N	Name of the file Prompt: Name
OS_PRIVILEGES	NUMBER(38, 0)	Y	Operating system privileges, expressed as a bit mask Prompt: Privileges System maintained Not updatable by user
OS_TIMESTAMP	DATE	Y	Operating system timestamp Prompt: OS Timestamp System maintained Not updatable by user
OWNER	VARCHAR2(32)	Y	Operating system file owner Prompt: Owner System maintained Not updatable by user
SHORT_DESCRIPTION	VARCHAR2(240)	Y	Short description of the file Prompt: Short Description
TEXT_FORMAT	VARCHAR2(1)	N	Text format of the file, if known Not displayed Uppercase	TEXT_FORMAT	N

Multi-line Text
Name	Text Type	Prompt
DESCRIPTION	CDIDSC	Description

Other Properties
The following 'standard' properties are also inherited by all element types: ID IRID IVID ELEMENT_TYPE_NAME DATE_CREATED CREATED_BY DATE_CHANGED CHANGED_BY NUMBER_OF_TIMES_MODIFIED TYPES

Other element types that reference PRIMARY_ACCESS_FILE:

Each ACTOR may be iconized using one and only one PRIMARY_ACCESS_FILE
Each ACTIVITY_DEFINITION may be iconized using one and only one PRIMARY_ACCESS_FILE
Each ACTIVITY_DEFINITION may be invoking the execution of one and only one PRIMARY_ACCESS_FILE
Each ACTIVITY_DEFINITION may be using the mapping file of one and only one PRIMARY_ACCESS_FILE
Each FOLDER_MEMBER must be of one and only one FOLDERED_ELEMENT
Each ASSOCIATION may be iconized using one and only one PRIMARY_ACCESS_FILE
Each BUSINESS_OBJECT may be iconized using one and only one PRIMARY_ACCESS_FILE
Each CONTAINER_DEFINITION must be stored in one and only one PRIMARY_ACCESS_FILE
Each CLASSIFIER may be iconized using one and only one PRIMARY_ACCESS_FILE
Each DIAGRAM_ELEMENT_USAGE must be for one and only one CIELEMENT (in arc)
Each DOCUMENT_ATTACHMENT must be from one and only one ACCESS_CONTROLLED_ELEMENT (in arc)
Each FILE_USAGE must be a usage of one and only one PRIMARY_ACCESS_FILE
Each FILE_SECTION must be stored in one and only one PRIMARY_ACCESS_FILE
Each ORGANIZATION_UNIT may be iconized using one and only one PRIMARY_ACCESS_FILE
Each OBJECT_STATE may be iconized using one and only one PRIMARY_ACCESS_FILE
Each PACKAGE may be iconized using one and only one PRIMARY_ACCESS_FILE
Each SET_MEMBER_ITEM must be of one and only one PRIMARY_ACCESS_ELEMENT (in arc)
Each STEREOTYPE may be iconized using one and only one PRIMARY_ACCESS_FILE
Each EXTENDED_STRUCTURE_ELEMENT must be part of one and only one ACCESS_CONTROLLED_ELEMENT (in arc)
Each EXTENDED_STRUCTURE_ELEMENT must be use of one and only one ACCESS_CONTROLLED_ELEMENT
Each USE_CASE may be iconized using one and only one PRIMARY_ACCESS_FILE

Note:

All properties are displayed and updatable by the user unless indicated otherwise

All reference properties are displayed and transferable unless indicated otherwise

All domains are enforced unless indicated otherwise

All properties and reference properties are defined on this element type unless indicated as inherited from a supertype