Table qwat.qwat_od.subscriber
Table for subscriber. Inherits from node.

 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
id int4 10
subscriber_reference.fk_subscriber subscriber_reference_fk_subscriber R
network_element.id subscriber_id_fkey R
fk_subscriber_type int4 10
subscriber_type.id subscriber_fk_type R
fk_pipe int4 10  √  null
pipe.id subscriber_fk_pipe R
parcel varchar 12  √  null
flow_current numeric 8,2  √  null
flow_planned numeric 8,2  √  null

Table contained 1 484 rows at mar. mars 21 17:52 CET 2017

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc subscriber_pkey
fk_pipe Performance Asc fki_subscriber_fk_pipe
fk_subscriber_type Performance Asc fki_subscriber_fk_type

Close relationships  within of separation: