Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| institution_id | INT | 10 | 0 |
|
|
Primary id for this table. This uniquely identifies the row. |
||
| institution_code | VARCHAR | 255 | √ | null |
|
|
If there is a defined ISO code for the institute this should be used here. |
|
| institution_name | VARCHAR | 255 |
|
|
The institute name. |
|||
| institution_acronym | VARCHAR | 20 | √ | null |
|
|
If there is an acronym for the institute. |
|
| country_name | VARCHAR | 255 | √ |
|
|
Country name. |
||
| country_code2 | CHAR | 2 | √ |
|
|
ISO 2 Code for country. |
||
| country_code3 | CHAR | 3 | √ |
|
|
ISO 3 Code for country. |
||
| institution_contact | VARCHAR | 255 | √ | null |
|
|
The contact at the institute which should be used for correspondence. |
|
| institution_phone | VARCHAR | 255 | √ | null |
|
|
The telephone number for the institute. |
|
| institution_email | VARCHAR | 255 | √ | null |
|
|
The email address to contact the institute. |
|
| institution_address | MEDIUMTEXT | 16777215 | √ | null |
|
|
The postal address of the institute. |
|
| all_dataset_ids | JSON | 1073741824 | √ | null |
|
|
||
| trials_dataset_ids | JSON | 1073741824 | √ | null |
|
|
||
| genotype_dataset_ids | JSON | 1073741824 | √ | null |
|
|
||
| climate_dataset_ids | JSON | 1073741824 | √ | null |
|
|
||
| pedigree_dataset_ids | JSON | 1073741824 | √ | null |
|
|