BDNA Data Platform 5.4 July 2017 (Oracle)
TECHNOPEDIA_VERSIONS - Technopedia Versions 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_VERSIONS_ID number 18 TECHNOPEDIA_VERSIONS table unique identifier
CREATE_DATE date 7  √  null Date row was first created
LAST_MODIFIED_DATE date 7  √  null Date the Technopedia Version entry was last modified
VERSION varchar2 64  √  null Technopedia's version number
RELORDER number 22  √  null Technopedia releases order, where 1 equals Release 2.0, and so on
RELDATE date 7  √  null Technopedia release date
LEGAL varchar2 4000  √  null Legal verbiage (copyright information)

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