Home>Organisms>Staphylococcus pseudintermedius>Staphylococcus pseudintermedius isolates>Plugins>Description of database fields

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	-
MSSP_MRSP	methicillin-susceptible or -resistant	text	MSSP MRSP	yes	-
country	country where strain was isolated	text	Afghanistan Albania Algeria Andorra Angola Antigua & Barbuda Argentina Armenia Australia Austria Azerbaijan Bahamas Bahrain Bangladesh Barbados Belarus Belgium Belize Benin Bhutan Bolivia Bosnia & Herzegovina Botswana Brazil Brunei Bulgaria Burkina Faso Burma Burundi Cambodia Cameroon Canada Cape Verde Central African Republic Chad Chile China Colombia Comoros Congo [DRC] Costa Rica Croatia Cuba Cyprus Czech Republic Denmark Djibouti Dominica Dominican Republic East Timor Ecuador Egypt El Salvador Equatorial Guinea Eritrea Estonia Ethiopia Fiji Finland France Gabon Georgia Germany Ghana Greece Grenada Guadeloupe Guatemala Guinea Guinea Bissau Guyana Haiti Honduras Hungary Iceland India Indonesia Iran Iraq Ireland Isle of Man Israel Italy Ivory Coast Jamaica Japan Jordan Kazakhstan Kenya Kiribati Kuwait Kyrgyzstan Laos Latvia Lebanon Lesotho Liberia Libya Liechtenstein Lithuania Luxembourg Macedonia Madagascar Malawi Malaysia Maldives Mali Malta Marshall Islands Martinique Mauritania Mauritius Mayotte Mexico Micronesia Moldavia Moldova Monaco Mongolia Montenegro Morocco Mozambique Namibia Nauru Nepal New Caledonia New Zealand Nicaragua Niger Nigeria North Korea Norway Oman Pakistan Palau Palestinian territories Panama Papua New Guinea Paraguay Peru Philippines Poland Portugal Qatar Reunion Romania Russia Rwanda Samoa San Marino Saudi Arabia Senegal Serbia Seychelles Sierra Leone Singapore Slovakia Slovenia Solomon Islands Somalia South Africa South Korea Spain Sri Lanka St. Kitts & Nevis St. Lucia Sudan Suriname Swaziland Sweden Switzerland Syria Tahiti Taiwan Tajikistan Tanzania Thailand The Gambia The Netherlands Togo Tonga Trinidad & Tobago Tunisia Turkey Turkmenistan Tuvalu UK USA Uganda Ukraine United Arab Emirates Uruguay Uzbekistan Vanuatu Vatican City Venezuela Vietnam Yemen Zambia Zimbabwe Unknown	yes	-
region	region/city etc inside country	text	-	no	30
year	year of isolation	integer	min: 1900; max: 2023	expected	4
host	please put other hosts in comments field	text	dog cat horse cattle human rodent other	yes	-
age_yr	age in years	integer	min: 0; max: 120	no	-
age_mth	month part of age (0-11) for patients under 1 year old	integer	min: 0; max: 11	no	-
sex	sex of patient/carrier	text	male female	no	-
disease	please put other diseases in comments field	text	healthy carrier pyodermia septicaemia fistula bone infection otitis hepatitis arthritis synovitis peritonitis gingivitis sinusitis urinary tract respiratory tract wound wound after surgery environment (unspecified/other)	yes	-
source	biological source of sample	text	blood cerebrospinal fluid throat swab nasal swab ear swab rectal swab skin mouth wound secretion urine catheter joint fluid bone sputum other	no	-
epidemiology		text	carrier hospital-acquired community-acquired bites other	no	-
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