md column

Database Table

Name md_column
Prefix mdc
Group Item Column
Initial Build 2006.02

Overview

Columns

Name Description Datatype Notes
mdc_key Unique Key uniqueidentifier  
mdc_name Column Name nvarchar(128)  
mdc_mdt_name Table Name nvarchar(128)  
mdc_table_name Actual Table Name nvarchar(128)  
mdc_description Column Description nvarchar(100)  
mdc_data_type Data Type nvarchar(50)  
mdc_nullable Nullable? av_flag  
mdc_width Width av_integer  
mdc_width_max Maximum Length av_integer  
mdc_readonly Read Only? av_flag  
mdc_readonlyedit Edit Read Only? av_flag  
mdc_not_editable Not Editable? av_flag  
mdc_hidden Hidden? av_flag  
mdc_required Required av_flag  
mdc_has_lookup Has Lookup av_flag  
mdc_autopostback Causes Post Back? av_flag  
mdc_input_mask Input Mask nvarchar(255)  
mdc_control_class Control Class nvarchar(50)  
mdc_value_from From Table nvarchar(250)  
mdc_value_column From Value Column nvarchar(128)  
mdc_value_text_column From Text Column nvarchar(128)  
mdc_value_where Value Where nvarchar(900)  
mdc_value_where_add Value Where for Add nvarchar(900)  
mdc_value_orderby Value Order By nvarchar(128)  
mdc_default_value Default Value nvarchar(300)  
mdc_validation_class Validation Class nvarchar(50)  
mdc_list_header List Header nvarchar(50)  
mdc_report_header1 Report Header 1 nvarchar(50)  
mdc_report_header2 Report Header 2 nvarchar(50)  
mdc_query_select_flag Query Select FLag? av_flag  
mdc_sort_order Order av_integer  
mdc_change_log_flag Log Changes av_flag  
mdc_add_user Add User av_user  
mdc_add_date Add Date av_date  
mdc_change_user Change User av_user  
mdc_change_date Change Date av_date  
mdc_delete_flag Delete Flag av_delete_flag  
mdc_entity_key Entity Key av_key  
mdc_disable_autocomplete_flag disable autocomplete av_flag Added in 2009.01.
mdc_enable_subform_lookup_flag Enable for subform lookup av_flag  

Child Tables

Child Table Parent Key Child Key Join
fw_change_log mdc_name log_mdc_name log_mdc_name = mdc_name
fw_change_log mdc_table_name log_mdc_table_name log_mdc_table_name = mdc_table_name
md_dynamic_search mdc_key sch_mdc_key sch_mdc_key = mdc_key
md_table_list_column mdc_name lsc_mdc_name lsc_mdc_name = mdc_name