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 |
| taxonomic_designation | Taxonomic designation | text | - | yes | 30 |
| isolate | strain name | text | - | yes | 50 |
| aliases | alternative names for isolate | text (multiple) | - | no | - |
| references | PubMed ids that link to publications that describe or include record | integer (multiple) | - | no | - |
| other_name | other strain name | text | - | no | 50 |
| PFGE_clone | using classification of Yagupsky et al. Pediatr Infect Dis J. 2009 | text | - | no | 20 |
| penicillinase | Yes or No or Unknown | text | - | no | 15 |
| isolation_year | yyyy or Unknown | text | - | no | 15 |
| country_of_isolation | text | - | yes | 50 | |
| city_or_region | text | - | no | 50 | |
| laboratory_source | Microbiologist | text | - | no | 100 |
| sample_origin | Blood, joint fluid, cardiac valve, oropharinx, bone or Unknown | text | - | yes | 50 |
| disease | arthritis, osteomyelitis, endocarditis, asymptomatical carriage... or unknown | text | - | yes | 50 |
| class_of_disease | OAI (osteoarticular infection), occult bacteremia, endocarditis, carriage, other...or unknown | text | - | yes | 50 |
| age_in_months | months | text | - | no | 20 |
| gender | M or F | text | - | no | 10 |
| comments_1 | Other info | text | - | no | 150 |
| comments_2 | Other info | text | - | no | 150 |
| accession_number | GenBank or EMBL or DDBJ | text | - | no | 50 |
| 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 |