Table //data/home/craft/ucsc-xena-server/spydb.PUBLIC.FIELD 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.FIELD_IDS)
CODE.FIELD_ID CONSTRAINT_1FA C
FEATURE.FIELD_ID CONSTRAINT_F0 C
FIELD_GENE.FIELD_ID CONSTRAINT_4 C
FIELD_POSITION.FIELD_ID CONSTRAINT_50 C
FIELD_SCORE.FIELD_ID CONSTRAINT_E0 C
DATASET_ID integer 10
DATASET.ID CONSTRAINT_3FC C
NAME varchar 255  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
DATASET_ID + NAME Must be unique Asc/Asc CONSTRAINT_INDEX_3
ID Must be unique Asc PRIMARY_KEY_3

Close relationships  within of separation: