External_System Attributes

Attribute/Logical Rolename	Domain	Datatype	NULL	Definition
External_System_ID	Identifier	BIGINT	NO
System_Name		VARCHAR(128)	NO
Owner		VARCHAR(128)	YES
System_URL		VARCHAR(1000)	YES
Version	Version	INTEGER	NO
Date_Created	Date_Created	TIMESTAMP/DATE	NO
Last_Updated	Last_Updated	DATETIME	YES
Modified_by	Modified_by	VARCHAR(40)	YES

External_System Keys

Key Name	Key Type	Keys
PK_External_System	PrimaryKey	External_System_ID

External_System Relationships

Parent Relationships:

Entity Name

Type

Cardinality

Business Name

VerbPhrase

InversePhrase

Foreign Keys

Is Supertype

Child Relationships:

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

External_System Check Constraints

Check Constraint Name

CheckConstraint

External_System Security Types

Name	Current Value

External_System Where Used - Model Usage

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

External_System Where Used - Submodel Usage

Model	Submodel Usage
Logical	Main Model
Logical	Project Information
Logical	RI hierarchy
BARD - MySQL (MySQL)	Main Model
BARD - MySQL (MySQL)	CAP
BARD - MySQL (MySQL)	Project Management
BARD_Dev (Oracle)	Main Model
BARD_Dev (Oracle)	Project Information
BARD_Dev (Oracle)	RI hierarchy