Table topp.atn.event 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
event_id serial 10  √  nextval('atn.event_event_id_seq'::regclass)
deployment_id int4 10  √  null
deployment.deployment_id event_deployment_id R
multi_tag_serial int4 10  √  null
ptt int4 10  √  null
tag_manufacturer text 2147483647  √  null
tag_model text 2147483647  √  null
tag_serial_number text 2147483647  √  null
portal_username text 2147483647  √  null
testingnote text 2147483647  √  null

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

Indexes:
Column(s) Type Sort Constraint Name Anomalies
event_id Primary key Asc event_pkey  
deployment_id + multi_tag_serial Must be unique Asc/Asc event_deployment_id_multi_tag_serial_key These unique columns are also nullable

Close relationships: