md table

Database Table

Name	md_table
Prefix	mdt
Group Item	Table
Initial Build	2006.02

Overview

md_table stores the names and other information about the netFORUM database tables.

Columns

Name	Description	Datatype	Notes
mdt_key	Table	av_key
mdt_name	Table Name	nvarchar(128)
mdt_description	Table Description	nvarchar(100)
mdt_prefix	Table Prefix	nchar
mdt_key_column	Key Column Name	nvarchar(128)
mdt_email_column	e-mail column name	nvarchar(50)
mdt_fax_column	fax column name	nvarchar(50)
mdt_pref_comm_meth_column	Pref Comm Meth Column	nvarchar(50)
mdt_ignore_entity	Ignore Entities?	av_flag
mdt_cst_key_xref_column	customer key xref column	nvarchar(50)
mdt_add_user	Add User	av_user
mdt_add_date	Add Date	av_date
mdt_change_user	Change User	av_user
mdt_change_date	Change Date	av_date
mdt_delete_flag	Delete Flag	av_delete_flag
mdt_entity_key	Entity Key	av_key
mdt_logsql_flag	Log SQL	av_flag
mdt_address_column	Address Column	nvarchar(50)
mdt_phone_column	Phone Column	nvarchar(50)
mdt_code_column	Lookup Code Column	nvarchar(50)

Child Tables

Child Table	Parent Key	Child Key	Join
md_dynamic_search	mdt_name	sch_mdt_name	sch_mdt_name = mdt_name
md_table_list_table	mdt_name	lst_mdt_name	lst_mdt_name = mdt_name