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 |