Field Name	Description	1º Key	2º Index	Foreign Key	Paradox Field Type
	Section	Section of Institution (Vertebrates, Plants etc.)	*			Alpha, 3 characters
	SpecimenNo		*			Long Integer
	LocPrefix			*	Locality	Alpha, 2 characters
	LocalityNo	Locality where specimen was collected		*	Locality	Long Integer
	AccessionNo				Accession	Long Integer
	NoObjects					Alpha, 10 characters
	FieldNo					Alpha, 15 characters

	Field Name	Description	1º Key	Foreign Key	Paradox Field Type
	Section	Section of Institution (Vertebrates, Plants etc.)	*	Specimen	Alpha, 3 characters
	SpecimenNo	Specimen number	*	Specimen	Long Integer
	IndividualNo	Allows multiple taxa or individuals in a specimen number assigned (slides, slabs, bulk lots)	*		Short Integer
	TaxonNo	Specimen identification		Taxon	Long Integer
	IdentifiedBy	Person who identified specimen		Person	Long Integer
	TaxonModifier	Any modifiers to Taxon identification (e.g. cf., ?).			Alpha, 10 characters
	DateID	Date identified			Date

	Field Name	Description	1º Key	2º Index	Foreign Key	Paradox Field Type
	TaxonNo		*			Long Integer
	Taxon	Name of taxon		*		Alpha, 60 characters
	Rank				Rank	Alpha, 5 characters
	ReferenceNo	Original description			Reference	Long Integer
	ParentNo	Recursive key for hierarchical relationship				Long Integer
	TaxAncestry	Simplifies SQL queries for hierarchical searches		*		Alpha, 40 characters
	Date	Year taxon name established				Alpha, 4 characters
	Parens?	Whether or not parentheses are used in the name (in synonymies etc.)				Logical

	Field Name	Description	1º Key	Foreign Key	Paradox Field Type
	Rank		*		Alpha, 5 characters
	RankName				Alpha, 40 characters

	Field Name	Description	1º Key	Foreign Key	Paradox Field Type
	Section	Section of Institution (Vertebrates, Plants etc.)	*	Specimen	Alpha, 3 characters
	Specimen	Specimen number of type	*	Specimen	Long Integer
	TypeStatus	Status of type		TypeStatus	Alpha, 5 characters
	ReferenceNo	Where specimen was described		Reference	Long Integer

	Field Name	Description	1º Key	Foreign Key	Paradox Field Type
	TypeStatus		*		Alpha, 5 characters
	Type name				Alpha, 10 characters

	Field Name	Description	1º Key	Foreign Key	Paradox Field Type
	Section	Section of Institution (Vertebrates, Plants etc.)	*	Specimen ID	Alpha, 3 characters
	SpecimenNo	Specimen number of the specimen whose record was changed	*	Specimen ID	Long Integer
	ChangedDate	Date edited	*		Date
	ChangedBy	Person who edited the identification		Person	Long Integer