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 | primary key | integer | - | yes | 5 |
| 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 | - |
| country | country where strain was isolated | text | yes | - | |
| region | text | - | no | 30 | |
| year | year of isolation | integer | min: 1900; max: 2023 | no | 4 |
| anat_source | biological source | text |
blood
other sterile site oropharynx (including sputum/BAL) vagina faeces urine other superficial source animal |
no | - |
| age_yr | age of patient | integer | - | no | 3 |
| age_mth | age of patient if less than 1 year old | integer | - | no | 2 |
| sex | sex of patient/carrier | text |
male
female |
no | - |
| main_underlying_disease | text |
haematological malignancy
cancer HIV solid tumour major surgery solid organ transplantation diabetes other |
no | - | |
| central_venous_catheter | CVC status | text |
present
absent |
no | - |
| amphoB | amphotericin B MIC (ug/ml) | text | - | no | 12 |
| flucytosine | flucytosine MIC (ug/ml) | text | - | no | 12 |
| fluconazole | fluconazole MIC (ug/ml) | text | - | no | 12 |
| itraconazole | itraconazole MIC (ug/ml) | text | - | no | 12 |
| miconazole | miconazole MIC (ug/ml) | text | - | no | 12 |
| posaconazole | posaconazole MIC (ug/ml) | text | - | no | 12 |
| voriconazole | voriconazole MIC (ug/ml) | text | - | no | 12 |
| anidulafungin | anidulafungin MIC (ug/ml) | text | - | no | 12 |
| caspofungin | caspofungin MIC (ug/ml) | text | - | no | 12 |
| micafungin | micafungin MIC (ug/ml) | text | - | no | 12 |
| comments | text | - | no | 255 | |
| 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 |