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