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 |