Table topp.deprecated.ptts 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
pttnumber int4 10
bak.pttnumber Implied Constraint R
baz.pttnumber Implied Constraint R
blah.pttnumber Implied Constraint R
decoded_files.pttnumber Implied Constraint R
deployments.pttnumber $3 R
fishprobs.pttnumber Implied Constraint R
foo_ptts.pttnumber Implied Constraint R
ggsatdeployments.pttnumber Implied Constraint R
glnsatdeployments.pttnumber Implied Constraint R
glsd.pttnumber Implied Constraint R
lsdexceptsm.pttnumber Implied Constraint R
mamvis_secs.pttnumber Implied Constraint R
mamvis_subset.pttnumber Implied Constraint R
mamvis_toppid.pttnumber Implied Constraint R
mola_diag.pttnumber Implied Constraint R
mola_prv.pttnumber Implied Constraint R
new_satdeployments.pttnumber Implied Constraint R
pdt.pttnumber Implied Constraint R
pdt_datetime1.pttnumber Implied Constraint R
pdt_toppid.pttnumber Implied Constraint R
pdttable.pttnumber Implied Constraint R
psatlongitude.pttnumber Implied Constraint R
pttevents.pttnumber $2 R
satdeployments_04sep07.pttnumber Implied Constraint R
satdeployments_10sep07.pttnumber Implied Constraint R
satdeployments_14aug07.pttnumber Implied Constraint R
satdeployments_save_broken.pttnumber Implied Constraint R
satdeploymentsnew.pttnumber Implied Constraint R
satdeploymentsorig.pttnumber Implied Constraint R
satdepsub.pttnumber Implied Constraint R
satdtest.pttnumber Implied Constraint R
shark_url_table.pttnumber Implied Constraint R
tad.pttnumber Implied Constraint R
tat.pttnumber Implied Constraint R
tat_datetime.pttnumber Implied Constraint R
tbltmsat_28aug07.pttnumber Implied Constraint R
temp.pttnumber Implied Constraint R
temp_2015.pttnumber Implied Constraint R
temp_2015_x.pttnumber Implied Constraint R
temp_2016.pttnumber Implied Constraint R
temp_2016_x.pttnumber Implied Constraint R
temp_argos_diag_with_lc_sorted.pttnumber Implied Constraint R
temp_backup_satdeployments.pttnumber Implied Constraint R
temp_cache.pttnumber Implied Constraint R
temp_cache_argos.pttnumber Implied Constraint R
temp_es15.pttnumber Implied Constraint R
temp_es16.pttnumber Implied Constraint R
temp_foo.pttnumber Implied Constraint R
temp_jeg.pttnumber Implied Constraint R
temp_new_deployments.pttnumber Implied Constraint R
temp_pttnumber.pttnumber Implied Constraint R
temp_white_shark.pttnumber Implied Constraint R
tmp_accumulator_satdeployments.pttnumber Implied Constraint R
tmp_can.pttnumber Implied Constraint R
tmpsatdeployments.pttnumber Implied Constraint R
transmissions.pttnumber $2 R
y.pttnumber Implied Constraint R
programnumber int4 10  √  null
argosnumber varchar 80  √  null
hexdecno varchar 80  √  null
idbitsize int4 10  √  null
repetitionperiod float4 8,8  √  null
allocation varchar 80  √  null
format varchar 255  √  null
tagid int4 10  √  null
conventionaltags.tagid Implied Constraint R
pttcomment varchar 255  √  null
allocationdate date 13  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
pttnumber Primary key Asc ptts_pkey

Close relationships  within of separation: