Table istsos.demo.proc_obs
Association table between Procedures, ObservedProperty and UnitOfMeasure.

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_pro serial 10  √  nextval('demo.prc_obs_id_pro_seq'::regclass)
measures.id_pro_fk measures_id_pro_fk_fkey R
id_prc_fk int4 10
procedures.id_prc proc_obs_id_prc_fk_fkey C
id_uom_fk int4 10
uoms.id_uom prc_obs_id_uom_fk_fkey R
id_opr_fk int4 10
observed_properties.id_opr prc_obs_id_opr_fk_fkey R
constr_pro varchar 2147483647  √  null

Table contained 4 rows at Mon Jul 13 17:15 CEST 2015

Indexes:
Column(s) Type Sort Constraint Name
id_pro Primary key Asc prc_obs_pkey
id_uom_fk + id_opr_fk + id_prc_fk Must be unique Asc/Asc/Asc proc_obs_id_uom_fk_key

Close relationships  within of separation: