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 | - |
| duplicate_number | To be filled by curators only | text | - | no | 10 |
| sender | sender unique name, link to users | integer | Click for list of sender ids | yes | 4 |
| curator | curator who entered data,link to users | integer | Click for list of curator ids | yes | 4 |
| date_entered | date first entered | date | - | yes | 10 |
| datestamp | date last modified | date | - | yes | 10 |
| taxonomic_designation | Taxonomic designation | text | - | yes | 50 |
| other_name1 | text | - | no | 30 | |
| other_name2 | text | - | no | 15 | |
| isolation_year | integer | - | no | 4 | |
| world_region | text | yes | - | ||
| country | 30 | text | - | yes | 20 |
| city | 30 | text | - | no | 20 |
| host | environment or host | text | - | yes | 30 |
| source | clinical site etc. | text | - | no | 100 |
| infection | kind of infection | text | - | no | 30 |
| source_lab | lab source of strain | text | - | no | 50 |
| resistance_info | Antimicrobial resistance pattern and/or mechanisms | text | - | no | 150 |
| virulence_info | Identified virulence genes | text | - | no | 150 |
| comments | Other comments | text | - | no | 150 |
| accession_number | text | - | no | 50 |