Table 1.

Summary of the database schema used in Broadwick

Locations	Contains the id and (x-y or latitude-longitude) coordinates of each location
Populations	Contains the location id and a number of
	individuals at the location with a date.
LifeHistories	Contains the date and locations of each
	individuals birth and death.
Tests	Contains the date and results of a test on a
	given location, group or individual.
FullMovements	Contains an individual’s id and the date
	and id of the departure location and the date
	and id of the destination location.
DirectedMovements	Contains the id, date and direction of a
	movement (‘ON’ or ‘OFF’)
BatchedMovements	Contains the ids, dates of the ‘ON’
	and ‘OFF’ sides of the movement as
	well as the number of individuals moved.