md dynamic search

Database Table

Name md_dynamic_search
Prefix sch
Group Item Dynamic Search
Initial Build 2006.02

Overview

Columns

Name Description Datatype Notes
sch_key Unique Key av_key  
sch_dyn_key Dynamic Form av_key  
sch_mdt_name Table nvarchar(128)  
sch_lsf_from_alias From Table Alias nvarchar(40)  
sch_mdc_key Table Column av_key  
sch_control_class Control Class nvarchar(50)  
sch_order Order av_integer  
sch_default_operator Default Operator nvarchar(50)  
sch_value_from Value From nvarchar(128)  
sch_value_column Value Column nvarchar(128)  
sch_value_text_column Value Text Column nvarchar(128)  
sch_value_where Value Where av_text  
sch_value_orderby Value Order By nvarchar(128)  
sch_autopostback Auto Postback? av_flag  
sch_default_value Search Field Default Value nvarchar(300)  
sch_description Search Field Description nvarchar(100)  
sch_add_user Add user av_user  
sch_add_date Add Date av_date  
sch_change_user Change User av_user  
sch_change_date Change Date av_date  
sch_delete_flag Delete Flag av_delete_flag  
sch_entity_key Entity Key av_key  

Parent Tables

Parent Table Parent Key Child Key Join
md_dynamic_form dyn_key sch_dyn_key sch_dyn_key = dyn_key
md_column mdc_key sch_mdc_key sch_mdc_key = mdc_key
md_table mdt_name sch_mdt_name sch_mdt_name = mdt_name