Table topp.deprecated.tags 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
tagid int4 10
tagevents.tagid $1 R
tagmemos.tagid $1 R
timeseriesdata.tagid $3 R
conventionaltags.tagid Implied Constraint R
tagnumber varchar 80  √  null
tagmodelid int4 10  √  null
tagmodels.tagmodelid $1 R
statuscode int4 10  √  null
tagstatuscodes.statuscode $2 R
hardwareversion varchar 80  √  null
softwareversion varchar 80  √  null
location varchar 255  √  null
tagcomment varchar 255  √  null

Table contained 1,067 rows at Wed Dec 27 13:21 PST 2017

Indexes:
Column(s) Type Sort Constraint Name
tagid Primary key Asc tags_pkey

Close relationships  within of separation: