Sounds (table)

tblSounds, sound recordings


 * SoundID, integer, 4 bytes, identifier for the recording
 * TrueID, integer, 4 bytes, original SoundID for this recording content
 * FileID, integer, 4 bytes, = tblFiles.FileID
 * TaxonNameID, integer, 4 bytes, = tblTaxa.TaxonNameID of the species. When a species and subspecies have the same name, use the TaxonNameID of the subspecies.  If TaxonNameID = 0, this sound is not associated with any taxon.
 * Status, integer, 1 byte, 0 = normal, 1 = hidden
 * SoundTypeID, 4 bytes, 1 = calling, 2 = courtship, 3 = warning
 * Versions, integer, 1 byte, file types: 1 = .aif, 2 = .ra, 3 = both .aif and .ra.  This is obsolete.  Every (?) file is recorded as .aiff, .wav and .mp3.  The use of this field should be revised or eliminated.  Probably will be cast as bit0 = MP3, 1 = wav, 2 = aiff.
 * SexID, integer, 4 bytes, = tblSexes.SexID
 * Description, text, 300 characters maximum
 * SourceID, integer, 4 bytes, = tblSources.SourceID
 * SpecimenID, integer, 4 bytes, = tblSpecimens.SpecimenID
 * SoundMP3 - compressed audio version, type = OLE object, may be NULL
 * SoundWAV - Windows uncompressed audio version, type = OLE object, may be NULL
 * SoundAIF - Apple uncompressed audio version, type = OLE object, may be NULL
 * AccessCode, integer, 4 bytes
 * LastUpdate, smalldatetime, date and time row last updated
 * ModifiedBy, integer, 4 bytes, FileUserID of the signon that made the change
 * CreatedOn, smalldatetime, date and time row was created
 * CreatedBy, integer, 4 bytes, FileUserID of the signon that created the row