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