Element Type Definition: DATABASE

Oracle Designer Model, Release 6i
Element Type Definition

Element Type Name	DATABASE
Short Name	ODB
View Name	CI_DATABASES
Description	Definition of a database

Sub-type of	SHAREABLE_ELEMENT
Non-instantiable super-type of	NON_ORACLE_DATABASE
	ORACLE_DATABASE

	As this is a non-instantiable supertype, follow links (above) to its instantiable subtypes to find versioning information for each subtype, uniqueness criteria, API rules etc
Underlying table:	SDD_ODB
Changes:	Summary of changes to DATABASE in Release 6i

Reference Properties
Name	Opt ?	Notes	Relationship	In Arc
NODE_REFERENCE	Y	Prompt: Node	May be located at one and only one NODE

Properties
Name	Datatype	Opt ?	Notes	Domain	Default Value
COMPLETE_FLAG	VARCHAR2(1)	N	Indicates whether the definition of this database is complete and ready to be used by the generators Prompt: Complete ? Uppercase	YESNO	Y
CONNECT_STRING	VARCHAR2(80)	Y	*Connect string to be used to connect to this database by SQLNet** Prompt: Connect String
DATABASE_TYPE	VARCHAR2(3)	N	Sub-type discriminator. Internal property indicating whether the DATABASE is an ORACLE_DATABASE (ORC) or a NON_ORACLE_DATABASE (ANS) Not displayed Uppercase System maintained Not updatable by user	ODB_DATABASE_TYPE
LOCAL_NAME	VARCHAR2(8)	N	Name of the database Prompt: Local Name Uppercase System maintained: API provides a value only if left null by the user
NAME	VARCHAR2(40)	N	Name that uniquely identifies the database in a distributed environment Prompt: Name Uppercase
REMARK	VARCHAR2(240)	Y	A comment on the database. Prompt: Comment
TNS_ALIAS	VARCHAR2(40)	Y	*The alias for the TNS connection path, used by SQLNet v2** Prompt: TNS Alias

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

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 DATABASE:

Each FOLDER_MEMBER must be of one and only one FOLDERED_ELEMENT
Each DATABASE_USER must be on one and only one DATABASE
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 TABLESPACE must be part of one and only one DATABASE
Each SET_MEMBER_ITEM must be of one and only one PRIMARY_ACCESS_ELEMENT (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

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