| SchemaSpy Analysis of //data/home/craft/ucsc-xena-server/spydb.PUBLIC - Columns | Generated by SchemaSpy |
| Generated by SchemaSpy on Thu Oct 03 14:45 PDT 2019 |
| ||||||
|
| |||||||
//data/home/craft/ucsc-xena-server/spydb.PUBLIC contains 49 columns - click on heading to sort:
| Table | Column | Type | Size | Nulls | Auto | Default | Comments |
|---|---|---|---|---|---|---|---|
| FIELD_POSITION | BIN | integer | 10 | √ | null | ||
| FIELD_POSITION | CHROM | varchar | 255 | ||||
| FIELD_POSITION | CHROMEND | integer | 10 | ||||
| FIELD_POSITION | CHROMSTART | integer | 10 | ||||
| DATASET | COHORT | varchar | 1000 | √ | null | ||
| DATASET_SOURCE | DATASET_ID | integer | 10 | ||||
| FIELD | DATASET_ID | integer | 10 | ||||
| DATASET | DATASUBTYPE | varchar | 255 | √ | null | ||
| CODE | FIELD_ID | integer | 10 | ||||
| FEATURE | FIELD_ID | integer | 10 | ||||
| FIELD_GENE | FIELD_ID | integer | 10 | ||||
| FIELD_POSITION | FIELD_ID | integer | 10 | ||||
| FIELD_SCORE | FIELD_ID | integer | 10 | ||||
| FIELD_GENE | GENE | varchar_ignorecase | 255 | ||||
| DATASET | GROUPTITLE | varchar | 255 | √ | null | ||
| SOURCE | HASH | varchar | 40 | ||||
| FIELD_SCORE | I | integer | 10 | ||||
| CODE | ID | integer | 10 | √ | (NEXT VALUE FOR PUBLIC.SYSTEM_SEQUENCE_A5E2844C_2882_4C8E_B562_63488C5AC9A1) | ||
| COHORTS | ID | integer | 10 | √ | (NEXT VALUE FOR PUBLIC.SYSTEM_SEQUENCE_304954FC_C7C4_4224_A5B9_316ECF1FE0F1) | ||
| DATASET | ID | integer | 10 | √ | (NEXT VALUE FOR PUBLIC.SYSTEM_SEQUENCE_A7336E31_8008_48B8_A1C3_4A56F314D30F) | ||
| FEATURE | ID | integer | 10 | (NEXT VALUE FOR PUBLIC.FEATURE_IDS) | |||
| FIELD | ID | integer | 10 | (NEXT VALUE FOR PUBLIC.FIELD_IDS) | |||
| SOURCE | ID | integer | 10 | √ | (NEXT VALUE FOR PUBLIC.SYSTEM_SEQUENCE_9442713A_8366_45CF_95C8_13CE024D6897) | ||
| DATASET | LONGTITLE | varchar | 255 | √ | null | ||
| FEATURE | LONGTITLE | varchar | 255 | √ | null | ||
| COHORTS | NAME | varchar | 2000 | ||||
| DATASET | NAME | varchar | 1000 | ||||
| FIELD | NAME | varchar | 255 | √ | null | ||
| SOURCE | NAME | varchar | 2000 | ||||
| CODE | ORDERING | integer | 10 | ||||
| DATASET | PLATFORM | varchar | 255 | √ | null | ||
| FEATURE | PRIORITY | double | 17 | √ | NULL | ||
| DATASET | PROBEMAP | varchar | 1000 | √ | null | ||
| FIELD_GENE | ROW | integer | 10 | ||||
| FIELD_POSITION | ROW | integer | 10 | ||||
| DATASET | ROWS | integer | 10 | √ | null | ||
| FIELD_SCORE | SCORES | varbinary | 4000 | ||||
| DATASET | SECURITY | varchar | 255 | √ | null | ||
| DATASET | SHORTTITLE | varchar | 255 | √ | null | ||
| FEATURE | SHORTTITLE | varchar | 255 | √ | null | ||
| DATASET_SOURCE | SOURCE_ID | integer | 10 | ||||
| DATASET | STATUS | varchar | 20 | √ | null | ||
| FIELD_POSITION | STRAND | char | 1 | √ | null | ||
| DATASET | TEXT | varchar | 65535 | √ | null | ||
| SOURCE | TIME | timestamp | 23,10 | ||||
| DATASET | TYPE | varchar | 255 | √ | null | ||
| CODE | VALUE | varchar | 16384 | ||||
| FEATURE | VALUETYPE | varchar | 255 | ||||
| FEATURE | VISIBILITY | varchar | 255 | √ | null |