Stage_tree Attributes

Attribute/Logical Rolename	Domain	Datatype	NULL	Definition
Node_ID	Identifier	BIGINT	NO
parent_node_ID	Identifier	BIGINT	YES
Stage_ID	Identifier	BIGINT	NO
Stage_status		VARCHAR(20)	NO
Stage		VARCHAR(128)	NO
is_leaf		CHAR(1)	NO
Description	Description	VARCHAR(1000)	YES
Full_Path		VARCHAR(3000)	YES

Stage_tree Keys

Key Name	Key Type	Keys
PK_Stage	PrimaryKey	Node_ID

Stage_tree Relationships

Parent Relationships:

Entity Name	Type	Cardinality	Business Name	VerbPhrase	InversePhrase	Foreign Keys	Is Supertype
Stage_tree	Non-Identifying	Zero or One to Zero or More				parent_node_ID	NO

Child Relationships:

Entity Name	Type	Cardinality	Business Name	VerbPhrase	InversePhrase	Foreign Keys	Is Subtype
Stage_tree	Non-Identifying	One To Zero or More					NO

Stage_tree Check Constraints

Check Constraint Name

CheckConstraint

Stage_tree Security Types

Name	Current Value

Stage_tree Where Used - Model Usage

Mapped Object	Is User Defined?	Denormalization Mappings	Description	Bound Attachments
Logical Stage_tree	NO
BARD - MySQL (MySQL) Does Not Exist	NO
BARD_Dev (Oracle) Stage_tree	NO
Current Production (Oracle) Does Not Exist	NO

Stage_tree Where Used - Submodel Usage

Model	Submodel Usage
Logical	Main Model
Logical	Dictionary
BARD_Dev (Oracle)	Main Model
BARD_Dev (Oracle)	Dictionary