View topp.public.private_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_clength text 2147483647  √  null
tbltgarchivaldeployment_clengthtype text 2147483647  √  null
tbltgarchivaldeployment_cwidth text 2147483647  √  null
tbltgarchivaldeployment_cwidthtype 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_commonname 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_ew 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_gpsused text 2147483647  √  null
tbltgarchivaldeployment_gender text 2147483647  √  null
tbltgarchivaldeployment_handcomments text 2147483647  √  null
tbltgarchivaldeployment_handlingtime text 2147483647  √  null
tbltgarchivaldeployment_id1 text 2147483647  √  null
tbltgarchivaldeployment_injuries text 2147483647  √  null
tbltgarchivaldeployment_lpitnumber text 2147483647  √  null
tbltgarchivaldeployment_lpitposition text 2147483647  √  null
tbltgarchivaldeployment_lpittype text 2147483647  √  null
tbltgarchivaldeployment_leadtagger text 2147483647  √  null
tbltgarchivaldeployment_mass text 2147483647  √  null
tbltgarchivaldeployment_masstype text 2147483647  √  null
tbltgarchivaldeployment_ns text 2147483647  √  null
tbltgarchivaldeployment_nestnumber text 2147483647  √  null
tbltgarchivaldeployment_neststatus text 2147483647  √  null
tbltgarchivaldeployment_nestzone text 2147483647  √  null
tbltgarchivaldeployment_origtagid text 2147483647  √  null
tbltgarchivaldeployment_prevtags text 2147483647  √  null
tbltgarchivaldeployment_rpitnumber text 2147483647  √  null
tbltgarchivaldeployment_rpitposition text 2147483647  √  null
tbltgarchivaldeployment_rpittype text 2147483647  √  null
tbltgarchivaldeployment_releasecomments text 2147483647  √  null
tbltgarchivaldeployment_releaselocation text 2147483647  √  null
tbltgarchivaldeployment_sst text 2147483647  √  null
tbltgarchivaldeployment_scarslocations text 2147483647  √  null
tbltgarchivaldeployment_seriesname text 2147483647  √  null
tbltgarchivaldeployment_species 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_toppid text 2147483647  √  null
tbltgarchivaldeployment_trip2beach text 2147483647  √  null
tbltgarchivaldeployment_tgadkey text 2147483647  √  null
tbltgarchivaldeployment_adkey int4 10  √  null
tbltgarchivalrecovery_beachmarker text 2147483647  √  null
tbltgarchivalrecovery_contact text 2147483647  √  null
tbltgarchivalrecovery_dlatdd text 2147483647  √  null
tbltgarchivalrecovery_dlondd text 2147483647  √  null
tbltgarchivalrecovery_ew 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_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_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_recvbinfile text 2147483647  √  null
tbltgarchivalrecovery_recvctag1 text 2147483647  √  null
tbltgarchivalrecovery_recvcomment text 2147483647  √  null
tbltgarchivalrecovery_recvlat text 2147483647  √  null
tbltgarchivalrecovery_recvlon text 2147483647  √  null
tbltgarchivalrecovery_recvtags text 2147483647  √  null
tbltgarchivalrecovery_rewardaddress text 2147483647  √  null
tbltgarchivalrecovery_rewardperson text 2147483647  √  null
tbltgarchivalrecovery_rsourcetype text 2147483647  √  null
tbltgarchivalrecovery_sn text 2147483647  √  null
tbltgarchivalrecovery_sst text 2147483647  √  null
tbltgarchivalrecovery_tabkey text 2147483647  √  null
tbltgarchivalrecovery_tagreturned text 2147483647  √  null
tbltgarchivalrecovery_tag_functional text 2147483647  √  null
tbltgarchivalrecovery_toppid text 2147483647  √  null
tbltgarchivalrecovery_tgarkey text 2147483647  √  null
tbltgarchivalrecovery_arkey int4 10  √  null
tbltgarchivalfiles_asisfile text 2147483647  √  null
tbltgarchivalfiles_caldir text 2147483647  √  null
tbltgarchivalfiles_calibrationfile text 2147483647  √  null
tbltgarchivalfiles_clockdir text 2147483647  √  null
tbltgarchivalfiles_clockfile text 2147483647  √  null
tbltgarchivalfiles_emailfile1 text 2147483647  √  null
tbltgarchivalfiles_emailfile2 text 2147483647  √  null
tbltgarchivalfiles_emailfile3 text 2147483647  √  null
tbltgarchivalfiles_id1 text 2147483647  √  null
tbltgarchivalfiles_progbindir text 2147483647  √  null
tbltgarchivalfiles_progbinfile text 2147483647  √  null
tbltgarchivalfiles_progbinfile2 text 2147483647  √  null
tbltgarchivalfiles_progbinfile3 text 2147483647  √  null
tbltgarchivalfiles_progjnldir text 2147483647  √  null
tbltgarchivalfiles_progjnlfile text 2147483647  √  null
tbltgarchivalfiles_progjnlfile2 text 2147483647  √  null
tbltgarchivalfiles_progjnlfile3 text 2147483647  √  null
tbltgarchivalfiles_project text 2147483647  √  null
tbltgarchivalfiles_recalibrationfile text 2147483647  √  null
tbltgarchivalfiles_recvbindir text 2147483647  √  null
tbltgarchivalfiles_recvbinfile text 2147483647  √  null
tbltgarchivalfiles_recvjnldir text 2147483647  √  null
tbltgarchivalfiles_recvjnlfile text 2147483647  √  null
tbltgarchivalfiles_reverificationfile text 2147483647  √  null
tbltgarchivalfiles_tpbcfile text 2147483647  √  null
tbltgarchivalfiles_tpbdfile text 2147483647  √  null
tbltgarchivalfiles_tpbfile text 2147483647  √  null
tbltgarchivalfiles_tpbnfile text 2147483647  √  null
tbltgarchivalfiles_tpdir text 2147483647  √  null
tbltgarchivalfiles_tpsdfile text 2147483647  √  null
tbltgarchivalfiles_tpsffile text 2147483647  √  null
tbltgarchivalfiles_tpsjcfile text 2147483647  √  null
tbltgarchivalfiles_tpsjsfile text 2147483647  √  null
tbltgarchivalfiles_tpsmfile text 2147483647  √  null
tbltgarchivalfiles_tpstfile text 2147483647  √  null
tbltgarchivalfiles_tpwfile text 2147483647  √  null
tbltgarchivalfiles_tpfieldfile text 2147483647  √  null
tbltgarchivalfiles_tpfishfile text 2147483647  √  null
tbltgarchivalfiles_tagcode text 2147483647  √  null
tbltgarchivalfiles_taggingdate text 2147483647  √  null
tbltgarchivalfiles_taggingtime text 2147483647  √  null
tbltgarchivalfiles_toppid text 2147483647  √  null
tbltgarchivalfiles_pdfdeployrepdir text 2147483647  √  null
tbltgarchivalfiles_pdfdeployrepfile text 2147483647  √  null
tbltgarchivalfiles_pdfprogrepdir text 2147483647  √  null
tbltgarchivalfiles_pdfprogrepfile text 2147483647  √  null
tbltgarchivalfiles_pdfrecvrepdir text 2147483647  √  null
tbltgarchivalfiles_pdfrecvrepfile text 2147483647  √  null
tbltgarchivalfiles_tgafkey text 2147483647  √  null
tbltgarchivalfiles_afkey int4 10  √  null
turtle_archival_url_tgafkey text 2147483647  √  null
turtle_archival_url_calibrationurl text 2147483647  √  null
turtle_archival_url_progbinurl text 2147483647  √  null
turtle_archival_url_progjnlurl text 2147483647  √  null
turtle_archival_url_recvbinurl text 2147483647  √  null

Analyzed at Wed Dec 27 13:25 PST 2017