Description of database fields
Order columns by clicking their headings. Reset default order.
| field name | comments | data type | allowed values | required | maximum length (characters) |
|---|---|---|---|---|---|
| id | id - primary key | integer | - | yes | 6 |
| isolate | isolate name | text | - | yes | 20 |
| aliases | alternative names for isolate | text (multiple) | - | no | - |
| references | PubMed ids that link to publications that describe or include record | integer (multiple) | - | no | - |
| biosample | biosample id | text | - | no | 20 |
| duplicate_number | To be filled by curators only | text | - | no | 10 |
| refs | Enter semi-colon (;) separated list of PubMed ids of papers to associate with this item. | text | - | no | 50 |
| accession_number | text | - | no | 20 | |
| isolation_year | integer | - | no | 4 | |
| world_region | word region of isolation | text | yes | - | |
| country | country of isolation | text | - | yes | 20 |
| city | city of isolation | text | - | no | 20 |
| host | environment or host | text | - | yes | 30 |
| neonate | neonate : yes (patient younger than one year) or no (patient older than one year) | text | - | no | 3 |
| other_strain_info | informations about the strain | text | - | no | 50 |
| source | clinical site, etc. | text | - | yes | 50 |
| infection | type of infection | text | - | yes | 40 |
| other_infection_info | text | - | no | 70 | |
| MSSE_MRSE | methicillin-susceptible or -resistant | text | - | no | 25 |
| SCCmec_type | text | - | no | 20 | |
| other_resistance_info | text | - | no | 70 | |
| sender | user who sent data, links to users table | integer | Click for list of sender ids | yes | 4 |
| curator | curator who entered data, links to user table | integer | Click for list of curator ids | yes | 4 |
| date_entered | date first entered | date | - | yes | 10 |
| datestamp | date last modified | date | - | yes | 10 |