Description of database fields

Order columns by clicking their headings. Reset default order.

field namecommentsdata typeallowed valuesrequiredmaximum length (characters)
idid - primary key integer - yes 6
taxonomic_designationTaxonomic designation text - yes 30
isolatestrain name text - yes 50
aliasesalternative names for isolatetext (multiple)-no-
referencesPubMed ids that link to publications that describe or include recordinteger (multiple)-no-
other_nameother strain name text - no 50
PFGE_cloneusing classification of Yagupsky et al. Pediatr Infect Dis J. 2009 text - no 20
penicillinaseYes or No or Unknown text - no 15
isolation_yearyyyy or Unknown text - no 15
country_of_isolation text - yes 50
city_or_region text - no 50
laboratory_sourceMicrobiologist text - no 100
sample_originBlood, joint fluid, cardiac valve, oropharinx, bone or Unknown text - yes 50
diseasearthritis, osteomyelitis, endocarditis, asymptomatical carriage... or unknown text - yes 50
class_of_diseaseOAI (osteoarticular infection), occult bacteremia, endocarditis, carriage, other...or unknown text - yes 50
age_in_monthsmonths text - no 20
genderM or F text - no 10
comments_1Other info text - no 150
comments_2Other info text - no 150
accession_numberGenBank or EMBL or DDBJ text - no 50
senderuser who sent data, links to users table integer Click for list of sender ids yes 4
curatorcurator who entered data, links to user table integer Click for list of curator ids yes 4
date_entereddate first entered date - yes 10
datestampdate last modified date - yes 10