Table topp.deprecated.ssm_metadata Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
animal_id numeric 131089  √  null
animal_field_id text 2147483647  √  null
speciesname text 2147483647  √  null
sex numeric 131089  √  null
birthdate timestamp 29,6  √  null
event_id numeric 131089  √  null
deploy_id text 2147483647  √  null
topp_id numeric 131089  √  null
datebegin timestamp 29,6  √  null
dateend timestamp 29,6  √  null
workinggroup text 2147483647  √  null
investigatorid text 2147483647  √  null
taggingdate timestamp 29,6  √  null
taggingtimegmt timestamp 29,6  √  null
taggingtimelocal timestamp 29,6  √  null
departuredate timestamp 29,6  √  null
departuretime timestamp 29,6  √  null
gmtoffsetdeploy numeric 131089  √  null
tagsdeployed numeric 131089  √  null
deploy_loc_id text 2147483647  √  null
returndatelocal timestamp 29,6  √  null
returntimelocal timestamp 29,6  √  null
recoverydate timestamp 29,6  √  null
recoverytimegmt timestamp 29,6  √  null
recoverytimelocal timestamp 29,6  √  null
gmtoffsetrecovery numeric 131089  √  null
tagsrecovered numeric 131089  √  null
recover_loc_id text 2147483647  √  null
tagging_lat numeric 131089  √  null
tagging_lon numeric 131089  √  null
recovery_lat numeric 131089  √  null
recovery_lon numeric 131089  √  null
releasetotopp numeric 131089  √  null
ended text 2147483647  √  null
departuresightingtype_id text 2147483647  √  null
returnsightingtype_id text 2147483647  √  null
url text 2147483647  √  null

Table contained 218 rows at Wed Dec 27 13:21 PST 2017