BDNA Data Platform 5.4 July 2017 (SQL Server)
TECHNOPEDIA_VERSIONS - Technopedia versions table(Private Data)

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_VERSIONS_ID numeric 20 TECHNOPEDIA_VERSIONS table's unique identifier(Private Data)
CREATE_DATE datetime 16,3  √  null The date when row was first created(Private Data)
LAST_MODIFIED_DATE datetime 16,3  √  null The date the Technopedia Version's entry was last modified(Private Data)
VERSION varchar 64  √  null Technopedia's version number(Private Data)
RELORDER numeric 24  √  null Technopedia releases' order, where 1 equals Release 2.0, and so on(Private Data)
RELDATE datetime 16,3  √  null Technopedia's release date(Private Data)
LEGAL varchar 4000  √  null Legal verbage (copyright information)(Private Data)
DELETE_REASON varchar 500  √  null
REPLACEMENT_ID numeric 20  √  null

Analyzed at Thu Jul 20 12:14 PDT 2017

Indexes:
Column(s) Type Sort Constraint Name Anomalies
TECHNOPEDIA_VERSIONS_ID Primary key Asc PK_TECHNOPEDIA_VERSIONS  
VERSION Must be unique Asc TECHN_VERSIONS_UNQ_IDX This unique column is also nullable
Confidential and Proprietary to BDNA