Element Type Definition: TABLE

Oracle Designer Model, Release 6i
Element Type Definition

Element Type Name	TABLE_DEFINITION
Short Name	TBL
View Name	CI_TABLE_DEFINITIONS
Description	Definition of a relational or object table

	An object type table is distinguished by the fact that its
	relationship to ORACLE_OBJECT_TYPE is populated

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

Reference Properties
Name	Opt ?	Notes	Relationship	In Arc
CLUSTER_REFERENCE	Y	Prompt: Cluster	May be optimised for access by one and only one CLUSTER
ORACLE_OBJECT_TYPE_REFERENCE	Y	Prompt: Object Type	May be a type table of one and only one ORACLE_OBJECT_TYPE

Properties
Name	Datatype	Opt ?	Notes	Domain	Default Value
ALIAS	VARCHAR2(10)	Y	The unique alias for the table name. Prompt: Alias Uppercase
COLUMN_PREFIX	VARCHAR2(4)	Y	A prefix for the columns for this table. Prompt: Col. Prefix Uppercase
DATAWAREHOUSE_TYPE	VARCHAR2(10)	Y	Applicable in data warehouse applications only, classifying the table as a fact or a dimension Prompt: Data Warehouse Type Uppercase	DATAWAREHOUSE_TYPE
DISPLAY_TITLE	VARCHAR2(132)	Y	The title of this table to be used in screens, reports etc. Prompt: Display Title
INDEX_ONLY_FLAG	VARCHAR2(1)	N	Indicates whether this is to be an 'index only' table Prompt: Index-organized ? Uppercase	YESNO	N
INITIAL_NUMBER_OF_ROWS	NUMBER(38, 0)	Y	An estimate of the number of rows for the initial table load. Prompt: Start Rows Range: 0 to 999999999
JOURNAL_LOCATION	VARCHAR2(14)	N	Indicates where the journalling of the table should be performed (ie client or server), if at all Prompt: Journal Uppercase	JOURNAL_LOCATION	NONE
MAXIMUM_NUMBER_OF_ROWS	NUMBER(38, 0)	Y	An estimate of the maximum number of rows that this table will hold. Prompt: End Rows Range: 0 to 999999999
NAME	VARCHAR2(30)	N	The unique table name. Prompt: Name Uppercase Defined on TAB supertype
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
DELETE_TEXT	CGTDEL	Delete Code
DESCRIPTION	CDIDSC	Description
HELP	CDHELP	User/Help Text
INSERT_TEXT	CGTINS	Insert Code
LOCK_TEXT	CGTLCK	Lock Code
NOTES	CDINOT	Notes
UPDATE_TEXT	CGTUPD	Update Code

Other Properties
TABLE_DEFINITION 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 TABLE_DEFINITION:

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 MODULE_ARGUMENT may be defined by one and only one TABLE_DEFINITION (in arc)
Each COLUMN may be scoped by one and only one TABLE_DEFINITION
Each COLUMN must be of one and only one RELATION_DEFINITION (in arc)
Each COLUMN_QUALIFIED_ATTRIBUTE may be scoped by one and only one TABLE_DEFINITION
Each COLUMN_QUALIFIED_ATTRIBUTE must be within one and only one TABLE_DEFINITION
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 DATABASE_SYNONYM must be for one and only one TABLE_DEFINITION (in arc)
Each DATASTRUCTURE_ITEM may be defined by one and only one TABLE_DEFINITION (in arc)
Each JOIN_CONSTRAINT must be for joining to one and only one RELATION_DEFINITION
Each MAPPING_ELEMENT must be sourced from one and only one CIELEMENT (in arc)
Each MAPPING_ELEMENT must be targeted to one and only one CIELEMENT (in arc)
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 PROGRAM_DATUM may be defined by one and only one TABLE_DEFINITION (in arc)
Each PREFERENCE_SET_USAGE must be for one and only one CIELEMENT (in arc)
Each RELATION_INDEX must be to optimise access to one and only one TABLE_DEFINITION (in arc)
Each SET_MEMBER_ITEM must be of one and only one PRIMARY_ACCESS_ELEMENT (in arc)
Each SERVER_OBJECT_USAGE must be for generation of one and only one CIELEMENT (in arc)
Each TABLE_ENTITY must be by one and only one RELATION_DEFINITION
Each TABLE_IMPLEMENTATION must be an implementation of one and only one TABLE_DEFINITION
Each DATABASE_TRIGGER must be initiated by one and only one TABLE_DEFINITION (in arc)
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 USER_PREFERENCE must be for one and only one CIELEMENT (in arc)
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