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 |