View topp.public.public_turtle_archival 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
eventid text 2147483647  √  null
tbltgarchivaldeployment_beachmarker text 2147483647  √  null
tbltgarchivaldeployment_beachname text 2147483647  √  null
tbltgarchivaldeployment_capcomments text 2147483647  √  null
tbltgarchivaldeployment_capcondition text 2147483647  √  null
tbltgarchivaldeployment_caplocation text 2147483647  √  null
tbltgarchivaldeployment_capmethod text 2147483647  √  null
tbltgarchivaldeployment_capvessel text 2147483647  √  null
tbltgarchivaldeployment_carpcondition text 2147483647  √  null
tbltgarchivaldeployment_clength text 2147483647  √  null
tbltgarchivaldeployment_clengthtype text 2147483647  √  null
tbltgarchivaldeployment_commonname text 2147483647  √  null
tbltgarchivaldeployment_cwidth text 2147483647  √  null
tbltgarchivaldeployment_cwidthtype text 2147483647  √  null
tbltgarchivaldeployment_daybetweennests text 2147483647  √  null
tbltgarchivaldeployment_dlatdeg text 2147483647  √  null
tbltgarchivaldeployment_dlatmin text 2147483647  √  null
tbltgarchivaldeployment_dlondeg text 2147483647  √  null
tbltgarchivaldeployment_dlonmin text 2147483647  √  null
tbltgarchivaldeployment_encounteractivity text 2147483647  √  null
tbltgarchivaldeployment_enddate text 2147483647  √  null
tbltgarchivaldeployment_endtime text 2147483647  √  null
tbltgarchivaldeployment_entwatertime text 2147483647  √  null
tbltgarchivaldeployment_envcomment text 2147483647  √  null
tbltgarchivaldeployment_ew text 2147483647  √  null
tbltgarchivaldeployment_gender text 2147483647  √  null
tbltgarchivaldeployment_gpsused text 2147483647  √  null
tbltgarchivaldeployment_handcomments text 2147483647  √  null
tbltgarchivaldeployment_handlingtime text 2147483647  √  null
tbltgarchivaldeployment_injuries text 2147483647  √  null
tbltgarchivaldeployment_leadtagger text 2147483647  √  null
tbltgarchivaldeployment_lpitnumber text 2147483647  √  null
tbltgarchivaldeployment_lpitposition text 2147483647  √  null
tbltgarchivaldeployment_lpittype text 2147483647  √  null
tbltgarchivaldeployment_mass text 2147483647  √  null
tbltgarchivaldeployment_masstype text 2147483647  √  null
tbltgarchivaldeployment_nestnumber text 2147483647  √  null
tbltgarchivaldeployment_neststatus text 2147483647  √  null
tbltgarchivaldeployment_nestzone text 2147483647  √  null
tbltgarchivaldeployment_ns text 2147483647  √  null
tbltgarchivaldeployment_prevtags text 2147483647  √  null
tbltgarchivaldeployment_releasecomments text 2147483647  √  null
tbltgarchivaldeployment_releaselocation text 2147483647  √  null
tbltgarchivaldeployment_rpitnumber text 2147483647  √  null
tbltgarchivaldeployment_rpitposition text 2147483647  √  null
tbltgarchivaldeployment_rpittype text 2147483647  √  null
tbltgarchivaldeployment_scarslocations text 2147483647  √  null
tbltgarchivaldeployment_seriesname text 2147483647  √  null
tbltgarchivaldeployment_species text 2147483647  √  null
tbltgarchivaldeployment_sst text 2147483647  √  null
tbltgarchivaldeployment_startdate text 2147483647  √  null
tbltgarchivaldeployment_starttime text 2147483647  √  null
tbltgarchivaldeployment_tag1attach text 2147483647  √  null
tbltgarchivaldeployment_tag1code text 2147483647  √  null
tbltgarchivaldeployment_tag1comment text 2147483647  √  null
tbltgarchivaldeployment_tag1position text 2147483647  √  null
tbltgarchivaldeployment_tag1progdate text 2147483647  √  null
tbltgarchivaldeployment_tag2attach text 2147483647  √  null
tbltgarchivaldeployment_tag2code text 2147483647  √  null
tbltgarchivaldeployment_tag2comment text 2147483647  √  null
tbltgarchivaldeployment_tag2position text 2147483647  √  null
tbltgarchivaldeployment_tag2progdate text 2147483647  √  null
tbltgarchivaldeployment_tag3attach text 2147483647  √  null
tbltgarchivaldeployment_tag3code text 2147483647  √  null
tbltgarchivaldeployment_tag3comment text 2147483647  √  null
tbltgarchivaldeployment_tag3position text 2147483647  √  null
tbltgarchivaldeployment_tag3progdate text 2147483647  √  null
tbltgarchivaldeployment_tagapplocation text 2147483647  √  null
tbltgarchivaldeployment_tagattachment text 2147483647  √  null
tbltgarchivaldeployment_tageventcomment text 2147483647  √  null
tbltgarchivaldeployment_tagteam text 2147483647  √  null
tbltgarchivaldeployment_tgadkey text 2147483647  √  null
tbltgarchivaldeployment_toppid text 2147483647  √  null
tbltgarchivaldeployment_trip2beach text 2147483647  √  null
tbltgarchivalrecovery_contact text 2147483647  √  null
tbltgarchivalrecovery_dlatdd text 2147483647  √  null
tbltgarchivalrecovery_dlondd text 2147483647  √  null
tbltgarchivalrecovery_obtainfrom text 2147483647  √  null
tbltgarchivalrecovery_paid text 2147483647  √  null
tbltgarchivalrecovery_paidby text 2147483647  √  null
tbltgarchivalrecovery_photos text 2147483647  √  null
tbltgarchivalrecovery_rdate text 2147483647  √  null
tbltgarchivalrecovery_recvcomment text 2147483647  √  null
tbltgarchivalrecovery_recvctag1 text 2147483647  √  null
tbltgarchivalrecovery_recvlat text 2147483647  √  null
tbltgarchivalrecovery_recvlon text 2147483647  √  null
tbltgarchivalrecovery_recvtags text 2147483647  √  null
tbltgarchivalrecovery_rlen text 2147483647  √  null
tbltgarchivalrecovery_rlentype text 2147483647  √  null
tbltgarchivalrecovery_rmass text 2147483647  √  null
tbltgarchivalrecovery_rmasstype text 2147483647  √  null
tbltgarchivalrecovery_rneststatus text 2147483647  √  null
tbltgarchivalrecovery_rsourcetype text 2147483647  √  null
tbltgarchivalrecovery_rspecies text 2147483647  √  null
tbltgarchivalrecovery_rtagcondition text 2147483647  √  null
tbltgarchivalrecovery_rtime text 2147483647  √  null
tbltgarchivalrecovery_rvesselename text 2147483647  √  null
tbltgarchivalrecovery_rwidth text 2147483647  √  null
tbltgarchivalrecovery_rwidthtype text 2147483647  √  null
tbltgarchivalrecovery_sn text 2147483647  √  null
tbltgarchivalrecovery_tag_functional text 2147483647  √  null
tbltgarchivalrecovery_tagreturned text 2147483647  √  null
tbltgarchivalfiles_calibrationfile text 2147483647  √  null
tbltgarchivalfiles_asisfile text 2147483647  √  null
tbltgarchivalfiles_clockfile text 2147483647  √  null
tbltgarchivalfiles_progbinfile text 2147483647  √  null
tbltgarchivalfiles_progjnlfile text 2147483647  √  null
tbltgarchivalfiles_project text 2147483647  √  null
tbltgarchivalfiles_recalibrationfile text 2147483647  √  null
tbltgarchivalfiles_recvbinfile text 2147483647  √  null
tbltgarchivalfiles_recvjnlfile text 2147483647  √  null
tbltgarchivalfiles_reverificationfile text 2147483647  √  null
tbltgarchivalfiles_calibrationurl text 2147483647  √  null
tbltgarchivalfiles_progbinurl text 2147483647  √  null
tbltgarchivalfiles_progjnlurl text 2147483647  √  null
tbltgarchivalfiles_recvbinurl text 2147483647  √  null

Analyzed at Wed Dec 27 13:25 PST 2017