BDNA Data Platform 5.4 July 2017 (SQL Server)
TECHNOPEDIA_TABS_METADATA - Internal Technopedia table

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
CREATE_DATE date 20  √  null
LAST_MODIFIED_DATE date 20  √  null
TECHNOPEDIA_OBJECT_ID numeric 20  √  null
TECHNOPEDIA_OBJECTS.TECHNOPEDIA_OBJECT_ID TECH_TABS_META_TECH_OBJ R
OWNER varchar 30
TABLE_NAME varchar 30
COLUMN_NAME varchar 30
DATA_TYPE varchar 106  √  null
DATA_LENGTH int 4  √  null
DATA_PRECISION int 4  √  null
NULLABLE varchar 1  √  null
DATA_DEFAULT varchar 100  √  null
COLUMN_ORDER int 4  √  null
DISPLAY_ORDER int 4  √  null
IS_IN_DEFAULT_VIEW varchar 1  √  null
TABLE_ORDER int 4  √  null
ACTIVE varchar 1  √  null
VERSION varchar 5
ALIAS_NAME varchar 30  √  null
COMMENTS varchar 4000  √  null
DISPLAY_LABEL varchar 100  √  null
IS_VISIBLE varchar 1  √  null
SECTION varchar 100  √  null
ISEDITABLE numeric 3  √  null
ISREQUIRED numeric 3  √  null

Analyzed at Thu Jul 20 12:14 PDT 2017

Indexes:
Column(s) Type Sort Constraint Name
TECHNOPEDIA_TABS_METADATA_ID + OWNER + TABLE_NAME + COLUMN_NAME + VERSION Primary key Asc/Asc/Asc/Asc/Asc TECHNOPEDIA_TABS_METADATA_PK

Close relationships:
Confidential and Proprietary to BDNA