Pet Database

EMPLOYMENT | NEWS | SITE MAP | ABOUT US | CONTACT US

DESIGN
HOSTING
SPECIALTIES
MARKETING

Field	Type	Null	Default	Extra	Action
uid	smallint(6)	No	0	auto_increment	Change	Drop	Primary	Index	Unique
founderNameFnd	char(30)	No			Change	Drop	Primary	Index	Unique
lastNameFnd	char(30)	Yes			Change	Drop	Primary	Index	Unique
streetFnd	char(50)	Yes			Change	Drop	Primary	Index	Unique
cityFnd	char(30)	Yes			Change	Drop	Primary	Index	Unique
countyFnd	char(30)	Yes			Change	Drop	Primary	Index	Unique
stateProvinceFnd	char(2)	Yes			Change	Drop	Primary	Index	Unique
countryFnd	char(15)	Yes			Change	Drop	Primary	Index	Unique
homePhoneFnd	char(14)	Yes			Change	Drop	Primary	Index	Unique
workPhoneFnd	char(14)	Yes			Change	Drop	Primary	Index	Unique
homeFaxFnd	char(14)	Yes			Change	Drop	Primary	Index	Unique
workFaxFnd	char(14)	Yes			Change	Drop	Primary	Index	Unique
cellPhoneFnd	char(14)	Yes			Change	Drop	Primary	Index	Unique
emailFnd	char(70)	Yes			Change	Drop	Primary	Index	Unique
petSpeciesFnd	char(20)	No			Change	Drop	Primary	Index	Unique
petDominantBreedFnd	char(20)	No			Change	Drop	Primary	Index	Unique
petColorFnd	char(20)	No			Change	Drop	Primary	Index	Unique
petSizeFnd	char(12)	Yes			Change	Drop	Primary	Index	Unique
petCharacteristicsFnd	char(150)	Yes			Change	Drop	Primary	Index	Unique
petMedConditionsFnd	char(150)	Yes			Change	Drop	Primary	Index	Unique
licenseLocFnd	char(30)	Yes			Change	Drop	Primary	Index	Unique
licenseNumFnd	char(11)	Yes			Change	Drop	Primary	Index	Unique
microchipIdFnd	char(20)	Yes			Change	Drop	Primary	Index	Unique
cb_microchipIdFnd	char(1)	Yes			Change	Drop	Primary	Index	Unique
tattooFnd	char(20)	Yes			Change	Drop	Primary	Index	Unique
commentsFnd	char(150)	Yes			Change	Drop	Primary	Index	Unique

Keyname	Unique	Field	Action
PRIMARY	Yes	uid	Drop