adoption

The adoption table holds a row for each movement attached to an animal/owner.

Name	Type	Description
ID	INTEGER	A unique, incrementing number that identifies this record
AdoptionNumber	VARCHAR	A unique string identifying this movement (defaults to adoption.ID)
AnimalID	INTEGER	Link to the animal table
OwnerID	INTEGER	Link to the owner table
RetailerID	INTEGER	Link to the owner table for a retailer (0 for no retailer)
OriginalRetailerMovementID	INTEGER	Link to another movement in this table for an original movement to retailer that started this adoption
MovementDate	TIMESTAMP	The date the animal moved
MovementType	INTEGER	Link to the lksmovementtype table for the type of animal movement
ReturnDate	TIMESTAMP	The date the animal came back to the shelter from this movement (or null for not returned)
ReturnedReasonID	INTEGER	Link to the entryreason table for reason for return
InsuranceNumber	VARCHAR	If your shelter does short term insurance when adopting, the policy number
ReasonForReturn	VARCHAR	Free text, the reason the animal was returned
ReservationDate	TIMESTAMP	For reservation movements, the reservation date
Donation	FLOAT	A total of all donations attached to this movement
ReservationCancelledDate	TIMESTAMP	If this is a reservation and it has been cancelled, the date it was cancelled
Comments	VARCHAR	Movement comments
RecordVersion	INTEGER	Optimistic lock flag
CreatedBy	VARCHAR	User who created this record
CreatedDate	TIMESTAMP	Date this record was created
LastChangedBy	VARCHAR	User who last changed this record
LastChangedDate	TIMESTAMP	Date this record was last changed