Enterprise Elements Database Schema

Tables, columns, and key relationships in the Elements schema.
Table	Relates to
CLASS class_id name prefix description type_id color_id symbol_id package_id	CLASS_ATTRIBUTE TYPE_DEFINITION COLOR SYMBOL PACKAGE
CLASS_ATTRIBUTE class_id attribute_id dusplay_name tool_tip position type_id display_rows	CLASS ATTRIBUTE TYPE_DEFINITION
ATTRIBUTE attribute_id type_id column_name column_type_id column_size state_machine_id list_id	CLASS_ATTRIBUTE TYPE_DEFINITION STATE_MACHINE LIST_OPTION
TYPE_DEFINITION type_id name category description display_name	ATTRIBUTE CLASS CLASS_ATTRIBUTE
COLOR color_id name r g b	CLASS
SYMBOL symbol_id description aspect_x aspect_y background_color_id foreground_color_id edge_count type_id file_name	COLOR TYPE_DEFINITION
DISCUSSION discussion_id parent_discussion_id user_id post_tm remark title status_id	STATUS DISCUSSION
STATUS status_id name state_machine_id color_id symbol_id	DISCUSSION STATE_MACHINE COLOR SYMBOL
STATE_MACHINE state_machine_id name type_id	TYPE_DEFINITION
STATE_MACHINE_TRANSITION state_machine_id start_status_id end_status_id transition_verb	STATE_MACHINE STATUS
TERMINOLOGY term suggestion full_word_only enabled type_id	TYPE_DEFINITION
TUPLE tuple_id type_id parent_id child_id name validation_dt	TYPE_DEFINITION
ELEMENT element_id description class_id	CLASS
ELEMENT_RELATION type_id parent_id child_id name validation_dt	ELEMENT TYPE_DEFINITION
ELEMENT_HISTORY history_id element_id class_id user_id modification_dt action description	ELEMENT CLASS
EMAIL email_id sent_tm from_address to_address
EMAIL_DETAIL recipient_id sender_id post_tm subject message html_message status_id priority email_id	STATUS EMAIL
LIST_OPTION list_id option_id description position active impact_weight color_id symbol_id key_synonym	COLOR SYMBOL
NAMED_TEXT text_id type_id label value edited_by	TYPE_DEFINITION
NAMED_TEXT_METADATA text_id column_name position column_group	NAMED_TEXT
PACKAGE package_id name description parent_package_id	PACKAGE
PARAMETER id parameter value type_id	TYPE_DEFINITION

Enterprise Elements Database Schema

CLASS

CLASS_ATTRIBUTE

ATTRIBUTE

TYPE_DEFINITION

COLOR

SYMBOL

DISCUSSION

STATUS

STATE_MACHINE

STATE_MACHINE_TRANSITION

TERMINOLOGY

TUPLE

ELEMENT

ELEMENT_RELATION

ELEMENT_HISTORY

EMAIL

EMAIL_DETAIL

LIST_OPTION

NAMED_TEXT

NAMED_TEXT_METADATA

PACKAGE

PARAMETER