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