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