SchemaSpy Analysis of //inside/home/craft/cavm/spydb.PUBLIC - Columns | Generated by SchemaSpy |
Generated by SchemaSpy on Tue Oct 21 16:39 PDT 2014 |
| ||||||
|
//inside/home/craft/cavm/spydb.PUBLIC contains 49 columns - click on heading to sort:
Table | Column | Type | Size | Nulls | Auto | Default | Comments |
---|---|---|---|---|---|---|---|
FIELD_POSITION | STRAND | char | 1 | √ | null | ||
FIELD_POSITION | BIN | integer | 10 | √ | null | ||
FIELD_POSITION | CHROMEND | integer | 10 | ||||
FIELD_POSITION | CHROMSTART | integer | 10 | ||||
DATASET_SOURCE | DATASET_ID | integer | 10 | ||||
FIELD | DATASET_ID | integer | 10 | ||||
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_SCORE | I | integer | 10 | ||||
CODE | ID | integer | 10 | √ | (NEXT VALUE FOR PUBLIC.SYSTEM_SEQUENCE_9B596CBE_57BF_46BD_BA90_F491F3A2FB8B) | ||
COHORTS | ID | integer | 10 | √ | (NEXT VALUE FOR PUBLIC.SYSTEM_SEQUENCE_A9953DE4_A872_45A9_A22D_34BAC85940E7) | ||
DATASET | ID | integer | 10 | √ | (NEXT VALUE FOR PUBLIC.SYSTEM_SEQUENCE_A3802A2F_2773_4406_872C_05BA05756E88) | ||
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_1F49691B_3BB0_4943_8207_B7AC65EA2EEB) | ||
CODE | ORDERING | integer | 10 | ||||
FIELD_GENE | ROW | integer | 10 | ||||
FIELD_POSITION | ROW | integer | 10 | ||||
DATASET | ROWS | integer | 10 | √ | null | ||
DATASET_SOURCE | SOURCE_ID | integer | 10 | ||||
FEATURE | PRIORITY | double | 17 | √ | NULL | ||
DATASET | STATUS | varchar | 20 | √ | null | ||
SOURCE | TIME | timestamp | 23,10 | ||||
SOURCE | HASH | varchar | 40 | ||||
FIELD_POSITION | CHROM | varchar | 255 | ||||
DATASET | DATASUBTYPE | varchar | 255 | √ | null | ||
FIELD_GENE | GENE | varchar | 255 | ||||
DATASET | GROUPTITLE | varchar | 255 | √ | null | ||
DATASET | LONGTITLE | varchar | 255 | √ | null | ||
FEATURE | LONGTITLE | varchar | 255 | √ | null | ||
FIELD | NAME | varchar | 255 | √ | null | ||
DATASET | PLATFORM | varchar | 255 | √ | null | ||
DATASET | PROBEMAP | varchar | 255 | √ | null | ||
DATASET | SECURITY | varchar | 255 | √ | null | ||
DATASET | SHORTTITLE | varchar | 255 | √ | null | ||
FEATURE | SHORTTITLE | varchar | 255 | √ | null | ||
DATASET | TYPE | varchar | 255 | √ | null | ||
FEATURE | VALUETYPE | varchar | 255 | ||||
FEATURE | VISIBILITY | varchar | 255 | √ | null | ||
DATASET | COHORT | varchar | 1000 | √ | null | ||
DATASET | NAME | varchar | 1000 | ||||
COHORTS | NAME | varchar | 2000 | ||||
SOURCE | NAME | varchar | 2000 | ||||
FIELD_SCORE | SCORES | varbinary | 4000 | ||||
CODE | VALUE | varchar | 16384 | ||||
DATASET | TEXT | varchar | 65535 | √ | null |