Footprints Data Model

Table
Table Name Search Item Query
Table Definition Identifies the specific item definitions associated with the search query to aid in visibility and permissions.

Attribute
Attribute Name Attribute Definition Logical Datatype Is Required
Search Item Query Id The automatically generated primary key of the search_item_query table. LONG Yes
Search Item Query Name The name of the Search Item Query. VARCHAR(255) No
Search Query Id A Foreign Key to the Search Query table. LONG No
External Mapping Definition Id A Foreign Key to the Definition table. External data source. LONG No
Meta Id A Foreign Key to the Definition Version table. LONG No
Definition Id A Foreign Key to the Definition table. LONG No
Schema Name Database schema name VARCHAR(255) No