Footprints Data Model

Table
Name app_ele
Comment The identity and name of an element in the application. An element can be one of many types, and can contain other elements. Example Application Elements include: a screen, a form, a dialog box, a text box, the Home Page, an Architecture Component.

Column
Name Datatype Comment Is PK Is FK
app_ele_id bigint The automatically generated primary key of the app_ele table. Yes No
app_ele_nmsp_id bigint A Foreign Key to the Application Element Namespace table. No Yes
app_ele_name VARCHAR(2000) The name of the Application Element. No No
is_intrnl_flag bit A boolean flag for indicating if the Application Element is defined internally by Engineering or by Partners or is defined by the customer. No No
intrnl_id int An alternate automatically generated key of the app_ele table. No No
app_ele_type_id int A Foreign Key to the Application Element Type table. No Yes
intrnl_id_type_id int A Foreign Key to the Internal Identifier Type table. No Yes