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 | - |
| in_vitro_isolated_strain | text |
yes
no |
yes | - | |
| country | country where strain was isolated | text | yes | - | |
| region | Region/city etc inside country | text | - | no | 30 |
| year | year of isolation | integer | min: 1900; max: 2023 | yes | 4 |
| host_species | text |
human
pig other |
yes | - | |
| age_yr_human | age in years | integer | - | no | - |
| age_month_human | age in months if less than 1 year old | integer | - | no | - |
| sex_human | sex of patient/carrier | text |
male
female |
no | - |
| human_disease | text |
dyspepsia
gastritis peptic ulcer gastric MALT lymphoma gastric adenocarcinoma other |
no | - | |
| origin_of_pig | text |
slaughterhouse
|
no | - | |
| age_month_pig | age in months of pig | integer | - | no | - |
| pig_disease | text |
gastritis
ulceration |
no | - | |
| source | text |
stomach
other |
yes | - | |
| comments | any other comments | text | - | no | 1000 |
| 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 |