Element Type Definition: RECORD

Oracle Designer Model, Release 6i
Element Type Definition

Element Type Name	RECORD
Short Name	REC
View Name	CI_RECORDS
Description	Definition of a record held in a file

Sub-type of	RELATION_DEFINITION
Versioning:	Structure of RECORD versionable object
Rules:	API Spec Uniqueness Criteria Deletion Rules
Descriptor:	RECORD_FILE_REFERENCE NAME
Used by:	Oracle Designer
Underlying table:	SDD_TAB
Changes:	Summary of changes to RECORD in Release 6i

Reference Properties
Name	Opt ?	Notes	Relationship	In Arc
RECORD_FILE_REFERENCE	N	Prompt: Record File	Must be within one and only one RECORD_FILE

Properties
Name	Datatype	Opt ?	Notes	Domain	Default Value
COLUMN_PREFIX	VARCHAR2(4)	Y	A prefix for the columns for this table. Prompt: Col. Prefix Uppercase
NAME	VARCHAR2(30)	N	The unique table name. Prompt: Name Uppercase Defined on TAB supertype
RECORD_FORMAT	VARCHAR2(16)	Y	The format for the record e.g. FIXED, VARIABLE. Prompt: Record Format Uppercase	TAB_RECORD_FORMAT Non-enforced	FIXED
RECORD_SIZE	NUMBER(10, 0)	Y	The length of the record. The maximum length if it is a variable length record. Prompt: Record Size Range: 0 to 9999999999
REMARK	VARCHAR2(2000)	Y	A brief comment about this table, view, snapshot or record Prompt: Comment Defined on TAB supertype
TABLE_TYPE	VARCHAR2(6)	Y	Sub-type discriminator. Internal property indicating whether the RELATION_DEFINITION is a TABLE_DEFINITION (TABLE), VIEW_DEFINITION (VIEW), RECORD (RECORD), or SNAPSHOT_DEFINITION (SNAP). Not displayed Uppercase System maintained Not updatable by user Defined on TAB supertype	TAB_TABLE_TYPE

Multi-line Text
Name	Text Type	Prompt
DESCRIPTION	CDIDSC	Description
NOTES	CDINOT	Notes

Other Properties
RECORD has the 20 user definable properties (USER_DEFINED_PROPERTY_0, _1, _2, _3 etc) for User Extensibility
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 RECORD:

Each ASSUMPTION_TO_TABLE must be a use for one and only one RELATION_DEFINITION
Each FOLDER_MEMBER must be of one and only one FOLDERED_ELEMENT
Each COLUMN must be of one and only one RELATION_DEFINITION (in arc)
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 JOIN_CONSTRAINT must be for joining to one and only one RELATION_DEFINITION
Each MODULE_DETAIL_TABLE_USAGE must be of one and only one RELATION_DEFINITION
Each CONSTRAINT must be placed on one and only one RELATION_DEFINITION
Each SET_MEMBER_ITEM must be of one and only one PRIMARY_ACCESS_ELEMENT (in arc)
Each TABLE_ENTITY must be by one and only one RELATION_DEFINITION
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 RELATION_SELECTION must be in one and only one RELATION_DEFINITION
Each RELATION_SELECTION must be of one and only one RELATION_DEFINITION

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