md table list column

Database Table

Name	md_table_list_column
Prefix	lsc
Group Item	Table List Column
Initial Build	2006.02

Overview

Columns

Name	Description	Datatype	Notes
lsc_key	Unique Key	av_key
lsc_lsf_key	From Table	av_key
lsc_mdc_name	Column Name	nvarchar(128)
lsc_name_alias	Column Name Alias	nvarchar(50)
lsc_order	Order	av_integer
lsc_add_user	Add User	av_user
lsc_add_date	Add Date	av_date
lsc_change_user	Change User	av_user
lsc_change_date	Change Date	av_date
lsc_delete_flag	Delete Flag	av_delete_flag
lsc_entity_key	Entity Key	av_key

Parent Tables

Parent Table	Parent Key	Child Key	Join
md_table_list_from	lsf_key	lsc_lsf_key	lsc_lsf_key = lsf_key
md_column	mdc_name	lsc_mdc_name	lsc_mdc_name = mdc_name