media

The media table holds a row for each piece media attached to an animal, owner, etc.

Name	Type	Description
ID	INTEGER	A unique, incrementing number that identifies this record
MediaName	VARCHAR	The name of the file within the dbfs table - always [media.ID].extension
MediaNotes	VARCHAR	The notes accompanying the media file (used as description when publishing)
WebsitePhoto	INTEGER	1 if this is the preferred photo of an animal for use on the web
DocPhoto	INTEGER	1 if this is the preferred photo of an animal for use with generated documents
NewSinceLastPublish	INTEGER	1 if this media record was created after the last time a publish was done
UpdatedSinceLastPublish	INTEGER	1 if this media record was updated after the last time a publish was done
LastPublished	TIMESTAMP	The date this record was last published to the web
LastPublishedPF	TIMESTAMP	Date this record was last published to PetFinder.com
LastPublishedAP	TIMESTAMP	Date this record was last published to AdoptAPet.com
LastPublishedP911	TIMESTAMP	Date this record was last published to Pets911.com
LastPublishedRG	TIMESTAMP	Date this record was last published to RescueGroups PetAdoptionPortal.org
LinkID	INTEGER	The ID of the record in the table this media is linked to
LinkTypeID	INTEGER	Link to lksmedialink table to determine linked table
Date	TIMESTAMP	Date this record was created
RecordVersion	INTEGER	Optimistic lock flag