BDNA Data Platform 5.4 July 2017 (Oracle)
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 number 18
CREATE_DATE date 7  √  null
LAST_MODIFIED_DATE date 7  √  null
TECHNOPEDIA_OBJECT_ID number 18  √  null
TECHNOPEDIA_OBJECTS.TECHNOPEDIA_OBJECT_ID TECH_TABS_META_TECH_OBJ R
OWNER varchar2 30
TABLE_NAME varchar2 30
COLUMN_NAME varchar2 30
DATA_TYPE varchar2 106  √  null
DATA_LENGTH number 38  √  null
DATA_PRECISION number 38  √  null
NULLABLE varchar2 1  √  null
DATA_DEFAULT varchar2 100  √  null
COLUMN_ORDER number 38  √  null
DISPLAY_ORDER number 38  √  null
IS_IN_DEFAULT_VIEW varchar2 1  √  null
TABLE_ORDER number 38  √  null
ACTIVE varchar2 1  √  null
VERSION varchar2 5
ALIAS_NAME varchar2 30  √  null
COMMENTS varchar2 4000  √  null
DISPLAY_LABEL varchar2 100  √  null
IS_VISIBLE varchar2 1  √  null
SECTION varchar2 100  √  null
ISEDITABLE number 1  √  null
ISREQUIRED number 1  √  null

Analyzed at Thu Jul 20 12:13 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