Table //data/home/craft/ucsc-xena-server/spydb.PUBLIC.DATASET Generated by
SchemaSpy
Legend: SourceForge.net
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
ID integer 10  √  (NEXT VALUE FOR PUBLIC.SYSTEM_SEQUENCE_A7336E31_8008_48B8_A1C3_4A56F314D30F)
DATASET_SOURCE.DATASET_ID CONSTRAINT_5 C
FIELD.DATASET_ID CONSTRAINT_3FC C
NAME varchar 1000
DATASET.PROBEMAP CONSTRAINT_80D R
PROBEMAP varchar 1000  √  null
DATASET.NAME CONSTRAINT_80D R
SHORTTITLE varchar 255  √  null
LONGTITLE varchar 255  √  null
GROUPTITLE varchar 255  √  null
PLATFORM varchar 255  √  null
COHORT varchar 1000  √  null
SECURITY varchar 255  √  null
ROWS integer 10  √  null
STATUS varchar 20  √  null
TEXT varchar 65535  √  null
TYPE varchar 255  √  null
DATASUBTYPE varchar 255  √  null

Table contained 0 rows at Thu Oct 03 14:45 PDT 2019

Indexes:
Column(s) Type Sort Constraint Name
NAME Must be unique Asc CONSTRAINT_INDEX_8
PROBEMAP Performance Asc CONSTRAINT_INDEX_80
ID Must be unique Asc PRIMARY_KEY_8

Close relationships  within of separation: