Subject Area Name
|
Definition
|
340 - Search
|
Tables that defined saved searches and help with query generation and results presentation.
|
|
ER Diagram Name
|
Physical Display Level
|
|
Logical
|
Column
|
|
Physical
|
Column
|
|
Physical Name
|
Entity/Table Name
|
Logical Only
|
Do Not Generate
|
Definition
|
|
|
app_user
|
Application User
|
|
false
|
A user authorized to use the FootPrints system. The user is either a Customer User or an Agent User. The application user holds the minimum information needed to identify the user and associate the user with a user profile, where user settings are stored. A contact is not necessarily an application user. An application user entry is required in order for the user to access any online functions.
|
|
|
Physical Name
|
Attribute/Column Name
|
Definition
|
Physical Data Type
|
|
|
pwd
|
Password
|
This space intentionally left blank.
|
varchar(255)
|
|
|
user_name
|
User Name
|
The name of the Application User.
|
nvarchar(4000)
|
|
|
cust_login_type_id
|
Customer Login Type Id
|
A Foreign Key to the Customer Login Type table.
|
int
|
|
|
app_user_id
|
Application User Id
|
The automatically generated primary key of the app_user table.
|
bigint
|
|
|
lic_type_id
|
License Type Id
|
A Foreign Key to the License Type table.
|
bigint
|
|
|
user_login
|
User Login
|
The login name used to access the Application. This may not be filled in if external application security is used.
|
nvarchar(4000)
|
|
|
email_addr
|
Email Address
|
An email address for the Application User.
|
nvarchar(4000)
|
|
|
delete_date
|
Delete Date
|
The value of a Application User, stored as a date.
|
datetime
|
|
defn
|
Definition
|
|
false
|
A definition holds the structural and behavioral information needed for an application element that is configuarable by the system designer and/or the end user at definition time. Current Footrpints uses a combination of directories, files, tables, and programming code to represent this information. The new FootPrints will provide all of the same information within the definition. The definition can be persisted in a structure that is isolated at the Instance Level. The data for the definition will be stored as Configuration Settings associated with the Definition Version. See the database views v_defn_ver_active, v_cntnr_item_field.
|
|
|
Physical Name
|
Attribute/Column Name
|
Definition
|
Physical Data Type
|
|
|
defn_id
|
Definition Id
|
The automatically generated primary key of the defn table.
|
bigint
|
|
|
defn_name
|
Definition Name
|
The name of the Definition.
|
nvarchar(4000)
|
|
|
dsble_date
|
Disabled Date
|
The date that this instance of Definition is logically deleted and disabled.
|
datetime
|
|
|
defn_guid
|
Definition GUID
|
A Global Unique IDentifier search key for the Definition, composed of letters and numbers. It is computed by the client and typically used in unstructured data.
|
varchar(50)
|
|
|
defn_type_name
|
Definition Type Name
|
The unique string identifier for an instance of Definition Type. This identifier must be kept in sync with programming code that uses an enumeration constant to identify particular values. A scan program is generally used to populate this table.
|
varchar(255)
|
|
|
defn_subtype_id
|
Definition Subtype Id
|
A Foreign Key to the Definition Subtype table.
|
int
|
|
|
tmpl_export_guid
|
Template Export GUID
|
The value of a Definition, stored as a string.
|
VARCHAR(50)
|
|
defn_ver
|
Definition Version
|
|
false
|
A version of a Definition with a version identifier that changes when data changes are made to the template. The definition version will suffice to store the current state of the FootPrints Configuration. A full copy of the definition tree is versioned when a container is published. See the database views v_defn_ver_active, v_cntnr_item_field.
|
|
|
Physical Name
|
Attribute/Column Name
|
Definition
|
Physical Data Type
|
|
|
defn_id
|
Definition Id
|
A Foreign Key to the Definition table.
|
bigint
|
|
|
defn_ver_id
|
Definition Version Id
|
The automatically generated primary key of the defn_ver table.
|
bigint
|
|
|
defn_ver_name
|
Definition Version Name
|
The name of the Definition Version.
|
nvarchar(4000)
|
|
|
defn_ver_status_id
|
Definition Version Status Id
|
A Foreign Key to the Definition Version Status table.
|
int
|
|
|
defn_ver_guid
|
Definition Version GUID
|
A Global Unique IDentifier search key for the Definition Version, composed of letters and numbers. It is computed by the client and typically used in unstructured data.
|
varchar(50)
|
|
logical_data_type
|
Logical Data Type
|
|
false
|
A reference table for logical data type. The logical type maps to the database type in DDL generation.
|
|
|
Physical Name
|
Attribute/Column Name
|
Definition
|
Physical Data Type
|
|
|
logical_data_type_name
|
Logical Data Type Name
|
The name of the Logical Data Type.
|
varchar(255)
|
|
|
logical_data_type_id
|
Logical Data Type Id
|
The automatically generated primary key of the logical_data_type table.
|
int
|
|
search_col
|
Search Column
|
|
false
|
The number and order of search result columns returned when the search is executed.
|
|
|
Physical Name
|
Attribute/Column Name
|
Definition
|
Physical Data Type
|
|
|
search_col_id
|
Search Column Id
|
The automatically generated primary key of the search_col table.
|
bigint
|
|
|
search_col_name
|
Search Column Name
|
The name of the Search Column.
|
varchar(255)
|
|
|
is_ascending_order
|
Is Ascending Order
|
Indicates if Is Ascending Order.
|
bit
|
|
|
search_view_id
|
Search View Id
|
A Foreign Key to the Search View table.
|
bigint
|
|
|
sequence
|
Sequence
|
The value of a Search Column stored as Long.
|
bigint
|
|
|
is_automatic
|
Is Automatic
|
Indicates if Is Automatic.
|
bit
|
|
search_cond
|
Search Condition
|
|
false
|
The set of logical search conditions for the query. This is rendered into the actual SQL or filtering code.
|
|
|
Physical Name
|
Attribute/Column Name
|
Definition
|
Physical Data Type
|
|
|
search_cond_id
|
Search Condition Id
|
The automatically generated primary key of the search_cond table.
|
bigint
|
|
|
parent
|
Parent
|
A Foreign Key to the Search Condition table. Parent search.
|
bigint
|
|
|
search_cond_cd
|
Search Condition Code
|
A well-known string identifier used as a code to identify the Search Condition.
|
varchar(255)
|
|
|
field_name
|
Field Name
|
Field name.
|
varchar(255)
|
|
|
cstr_val
|
Constraint Value
|
Constraint value
|
nvarchar(4000)
|
|
|
search_item_query_id
|
Search Item Query Id
|
A Foreign Key to the Search Item Query table.
|
bigint
|
|
|
search_cstr_type_id
|
Search Constraint Type Id
|
A Foreign Key to the Search Constraint Type table.
|
int
|
|
|
sequence
|
Sequence
|
sequence integer
|
bigint
|
|
|
search_cstr_type
|
Search Constraint Type
|
Constraint type
|
varchar(255)
|
|
|
depth
|
Depth
|
tree depth
|
bigint
|
|
|
defn_id
|
Definition Id
|
A Foreign Key to the Definition table.
|
bigint
|
|
|
field_type
|
Field Type
|
A Foreign Key to the Logical Data Type table.
|
int
|
|
|
is_journal
|
Is Journal
|
Indicates if Is Journal.
|
bit
|
|
|
search_query_id
|
Search Query Id
|
A Foreign Key to the Search Query table.
|
bigint
|
|
|
predicate
|
Predicate
|
Search Predicate
|
varchar(255)
|
|
|
cond_name
|
Condition Name
|
Name of condition
|
varchar(255)
|
|
search_cstr_type
|
Search Constraint Type
|
|
false
|
A lookup table for the various operators that can be used in a search condition. These are logical operators.
|
|
|
Physical Name
|
Attribute/Column Name
|
Definition
|
Physical Data Type
|
|
|
search_cstr_type_id
|
Search Constraint Type Id
|
The automatically generated primary key of the search_cstr_type table.
|
int
|
|
|
search_cstr_type_name
|
Search Constraint Type Name
|
The name of the Search Constraint Type.
|
varchar(255)
|
|
|
search_cstr_type_descr
|
Search Constraint Type Description
|
A descriptive name of the Search Constraint Type. This descriptive name may be localized.
|
varchar(512)
|
|
search_item_query
|
Search Item Query
|
|
false
|
Identifies the specific item definitions associated with the search query to aid in visibility and permissions.
|
|
|
Physical Name
|
Attribute/Column Name
|
Definition
|
Physical Data Type
|
|
|
search_item_query_id
|
Search Item Query Id
|
The automatically generated primary key of the search_item_query table.
|
bigint
|
|
|
search_item_query_name
|
Search Item Query Name
|
The name of the Search Item Query.
|
varchar(255)
|
|
|
search_query_id
|
Search Query Id
|
A Foreign Key to the Search Query table.
|
bigint
|
|
|
extl_mapping_defn_id
|
External Mapping Definition Id
|
A Foreign Key to the Definition table. External data source.
|
bigint
|
|
|
meta_id
|
Meta Id
|
A Foreign Key to the Definition Version table.
|
bigint
|
|
|
defn_id
|
Definition Id
|
A Foreign Key to the Definition table.
|
bigint
|
|
|
schema_name
|
Schema Name
|
Database schema name
|
varchar(255)
|
|
search_query
|
Search Query
|
|
false
|
The root table for saved searches. It names the search, and indicates the visibility in various parts of the application. The search is saved in an implementation neutral format so that it can be used in many different layers.
|
|
|
Physical Name
|
Attribute/Column Name
|
Definition
|
Physical Data Type
|
|
|
search_query_id
|
Search Query Id
|
The automatically generated primary key of the search_query table.
|
bigint
|
|
|
search_query_name
|
Search Query Name
|
The name of the Search Query.
|
varchar(255)
|
|
|
start_from_pos
|
Start From Position
|
Start From Position
|
bigint
|
|
|
limit_ct
|
Limit Count
|
query limit.
|
bigint
|
|
|
parent_name
|
Parent Name
|
Parent Name
|
varchar(255)
|
|
|
search_source
|
Search Source
|
Source
|
int
|
|
|
notes
|
Notes
|
User notes
|
varchar()
|
|
|
search_query_descr
|
Search Query Description
|
A descriptive name of the Search Query. This descriptive name may be localized.
|
varchar(1024)
|
|
|
tab
|
Tab
|
Tab name in UI
|
varchar(255)
|
|
|
query_type
|
Query Type
|
Advanced or Global or other type
|
varchar(255)
|
|
|
in_quick_searches
|
In Quick Searches
|
Indicates if In Quick Searches.
|
bit
|
|
|
in_search_analytics
|
In Search Analytics
|
Indicates if In Search Analytics.
|
bit
|
|
|
search_in_all
|
Search In All
|
Indicates if Search In All containers
|
bit
|
|
|
in_mobile
|
In Mobile
|
Indicates if In Mobile.
|
bit
|
|
search_view
|
Search View
|
|
false
|
The UI details of the default view of the saved search.
|
|
|
Physical Name
|
Attribute/Column Name
|
Definition
|
Physical Data Type
|
|
|
search_view_id
|
Search View Id
|
The automatically generated primary key of the search_view table.
|
bigint
|
|
|
search_view_name
|
Search View Name
|
The name of the Search View.
|
varchar(255)
|
|
|
create_date
|
Create Date
|
Create Date
|
datetime
|
|
|
is_shared
|
Is Shared
|
Indicates if Is Shared.
|
bit
|
|
|
search_query_id
|
Search Query Id
|
A Foreign Key to the Search Query table.
|
bigint
|
|
|
create_user
|
Create User
|
A Foreign Key to the Application User table.
|
bigint
|
|
|
is_dflt
|
Is Default
|
Indicates if Is Default.
|
bit
|
|
|
show_in_menu
|
Show In Menu
|
Indicates if Show In Menu.
|
bit
|
|
|
search_view_descr
|
Search View Description
|
A descriptive name of the Search View. This descriptive name may be localized.
|
varchar(512)
|
|
|
cxt
|
Context
|
Search Context
|
varchar(255)
|
|
|
update_user
|
Update User
|
A Foreign Key to the Application User table.
|
bigint
|
|
|
update_date
|
Update Date
|
Update Date
|
datetime
|