Table topp.deprecated.cases 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
toppid varchar 20
animalexcursions.toppid $1 R
conventionalrecoveries.toppid $2 R
conventionaltagging.toppid $2 R
encounters.toppid $1 R
mamvis_secs.toppid Implied Constraint R
mamvis_subset.toppid Implied Constraint R
mamvis_toppid.toppid Implied Constraint R
pdt_datetime.toppid Implied Constraint R
pdt_distinct.toppid Implied Constraint R
pdt_latlong.toppid Implied Constraint R
pdt_link_table.toppid Implied Constraint R
pdt_toppid.toppid Implied Constraint R
pdt_trimmed.toppid Implied Constraint R
pdt_vars.toppid Implied Constraint R
ptd_datetime.toppid Implied Constraint R
satdepsub.toppid Implied Constraint R
satellitelocation_backup.toppid Implied Constraint R
satellitelocation_debug.toppid Implied Constraint R
satellitelocation_fixed.toppid Implied Constraint R
satellitelocation_link_table.toppid Implied Constraint R
satellitelocation_subset.toppid Implied Constraint R
satellitelocationtest.toppid Implied Constraint R
satlocation.toppid Implied Constraint R
satpassed.toppid Implied Constraint R
spot_goodness_cache.toppid Implied Constraint R
spot_limits.toppid Implied Constraint R
tagevents.toppid $2 R
tagkits.toppid $2 R
tagmemos.toppid $3 R
temp_sal.toppid Implied Constraint R
time_latlong.toppid Implied Constraint R
tmp_abft.toppid Implied Constraint R
tmp_spot.toppid Implied Constraint R
tmp_spot2.toppid Implied Constraint R
tmp_spot3.toppid Implied Constraint R
tmp_spot4.toppid Implied Constraint R
tmp_spot5.toppid Implied Constraint R
tmp_spot6.toppid Implied Constraint R
tmp_spot7.toppid Implied Constraint R
tmp_spot8.toppid Implied Constraint R
tmp_spot9.toppid Implied Constraint R
tmp_spot91.toppid Implied Constraint R
tmpsatdeployments.toppid Implied Constraint R
projectid int4 10  √  null
projects.projectid $1 R
animalid varchar 40  √  null
animals.animalid $2 R
name varchar 80  √  null
speciescode varchar 2  √  null
species.speciescode $3 R
casecomment text 2147483647  √  null
ownerid int4 10  √  null
agents.agentid $4 R
contactid int4 10  √  null
agents.agentid $5 R
provisional bool 1  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
toppid Primary key Asc cases_pkey

Close relationships  within of separation: