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_name | VARCHAR | 255 |
|
|
The institute name. |
|||
| institution_acronym | VARCHAR | 20 | √ | null |
|
|
If there is an acronym for the institute. |
|
| institution_address | MEDIUMTEXT | 16777215 | √ | null |
|
|
The postal address of the institute. |
|
| institution_email | VARCHAR | 255 | √ | null |
|
|
The email address to contact the institute. |
|
| 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. |
|
| country_id | INT | 10 | √ | 0 |
|
|
Primary id for this table. This uniquely identifies the row. |
|
| country_name | VARCHAR | 255 | √ |
|
|
Country name. |
||
| country_code | CHAR | 2 | √ |
|
|
ISO 2 Code for country. |