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
isolateisolate name text - yes 20
aliasesalternative names for isolatetext (multiple)-no-
referencesPubMed ids that link to publications that describe or include recordinteger (multiple)-no-
biosamplebiosample id text - no 20
duplicate_numberTo be filled by curators only text - no 10
refsEnter semi-colon (;) separated list of PubMed ids of papers to associate with this item. text - no 50
accession_number text - no 20
isolation_year integer - no 4
world_regionword region of isolation text
North America
Central America and the Caribbean
South America
Middle East
Antartic region
yes -
countrycountry of isolation text - yes 20
citycity of isolation text - no 20
hostenvironment or host text - yes 30
neonateneonate : yes (patient younger than one year) or no (patient older than one year) text - no 3
other_strain_infoinformations about the strain text - no 50
sourceclinical site, etc. text - yes 50
infectiontype of infection text - yes 40
other_infection_info text - no 70
MSSE_MRSEmethicillin-susceptible or -resistant text - no 25
SCCmec_type text - no 20
other_resistance_info text - no 70
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