Footprints Data Model

Table
Name search_item_query
Comment
Identifies the specific item definitions associated with the search query to
aid in visibility and permissions.

Column
Name Datatype Comment Is PK Is FK
search_item_query_id bigint The automatically generated primary key of the search_item_query table. Yes No
search_item_query_name varchar(255) The name of the Search Item Query. No No
search_query_id bigint A Foreign Key to the Search Query table. No Yes
extl_mapping_defn_id bigint
A Foreign Key to the Definition table.  External data source.
No Yes
meta_id bigint A Foreign Key to the Definition Version table. No Yes
defn_id bigint A Foreign Key to the Definition table. No Yes
schema_name varchar(255) Database schema name No No