BDNA Data Platform 5.4 July 2017 (SQL Server)
TECHNOPEDIA_TABS_METADATA_VW - Internal Technopedia view

Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
TECHNOPEDIA_TABS_METADATA_ID numeric 20
OWNER nvarchar 60  √  null
TABLE_NAME nvarchar 60  √  null
COLUMN_NAME nvarchar 60  √  null
COLUMN_LABEL nvarchar 200  √  null
DATA_TYPE nvarchar 212  √  null
DATA_LENGTH numeric 20  √  null
DATA_PRECISION numeric 20  √  null
NULLABLE nvarchar 2  √  null
DATA_DEFAULT nvarchar 200  √  null
TABLE_ORDER numeric 20  √  null
COLUMN_ORDER numeric 20  √  null
DISPLAY_ORDER numeric 20  √  null
IS_IN_DEFAULT_VIEW nvarchar 2  √  null
ACTIVE nvarchar 2  √  null
VERSION nvarchar 10  √  null
COMMENTS varchar 4000  √  null
IS_VISIBLE nvarchar 2  √  null
IS_PRIVATE varchar 1
SECTION varchar 100  √  null
ISEDITABLE numeric 3  √  null
ISREQUIRED numeric 3  √  null

Analyzed at Thu Jul 20 12:14 PDT 2017

View Definition:
CREATE VIEW TECHNOPEDIA_TABS_METADATA_VW AS SELECT TECH.TECHNOPEDIA_TABS_METADATA_ID, TECH.OWNER, TECH.TABLE_NAME, TECH.COLUMN_NAME, TECH.COLUMN_LABEL, TECH.DATA_TYPE, TECH.DATA_LENGTH, TECH.DATA_PRECISION, TECH.NULLABLE, TECH.DATA_DEFAULT, TECH.TABLE_ORDER, TECH.COLUMN_ORDER, COALESCE(TECHNOPEDIA_UI_META.DISPLAY_ORDER,TECH.DISPLAY_ORDER) DISPLAY_ORDER, COALESCE(TECHNOPEDIA_UI_META.IS_IN_DEFAULT_VIEW,TECH.IS_IN_DEFAULT_VIEW) IS_IN_DEFAULT_VIEW, TECH.ACTIVE, TECH.VERSION, TECH.COMMENTS, TECH.IS_VISIBLE, TECH.IS_PRIVATE, TECH.SECTION, TECH.ISEDITABLE, TECH.ISREQUIRED FROM ( select TECHNOPEDIA_TABS_METADATA_ID, CAST(OWNER AS NVARCHAR(30)) OWNER, CAST((case when substring(TABLE_NAME,1,4) ='TCAT' then substring(TABLE_NAME,2,len(TABLE_NAME)) else TABLE_NAME end) AS NVARCHAR(30)) TABLE_NAME, CAST(COLUMN_NAME AS NVARCHAR(30)) COLUMN_NAME, CAST(DISPLAY_LABEL AS NVARCHAR(100)) COLUMN_LABEL, CAST(DATA_TYPE AS NVARCHAR(106)) DATA_TYPE, DATA_LENGTH, DATA_PRECISION, CAST(NULLABLE AS NVARCHAR(1)) NULLABLE, CAST(DATA_DEFAULT AS NVARCHAR(100)) DATA_DEFAULT, TABLE_ORDER, COLUMN_ORDER, DISPLAY_ORDER AS DISPLAY_ORDER, CAST(IS_IN_DEFAULT_VIEW AS NVARCHAR(1)) IS_IN_DEFAULT_VIEW, CAST(ACTIVE AS NVARCHAR(1)) ACTIVE, CAST(VERSION AS NVARCHAR(5)) VERSION, COMMENTS, CAST(IS_VISIBLE AS NVARCHAR(1)) IS_VISIBLE, 'N' IS_PRIVATE, SECTION, ISEDITABLE, ISREQUIRED FROM TECHNOPEDIA_TABS_METADATA UNION SELECT TPC_TABS_METADATA_ID, OWNER, TABLE_NAME, COLUMN_NAME, DISPLAY_LABEL AS COLUMN_LABEL, DATA_TYPE, DATA_LENGTH, DATA_PRECISION, NULLABLE, DATA_DEFAULT, TABLE_ORDER, COLUMN_ORDER, DISPLAY_ORDER, IS_IN_DEFAULT_VIEW, ACTIVE, VERSION, COMMENTS, IS_VISIBLE, 'Y' IS_PRIVATE, SECTION, ISEDITABLE, ISREQUIRED FROM TPC_TABS_METADATA ) TECH LEFT JOIN TECHNOPEDIA_UI_META ON TECHNOPEDIA_UI_META.TECHNOPEDIA_TABS_METADATA_ID = TECH.TECHNOPEDIA_TABS_METADATA_ID
 
Possibly Referenced Tables/Views:

Confidential and Proprietary to BDNA