Table istsos.demo.off_proc
Association table between Offerings and Procedures.

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_off_prc serial 10  √  nextval('demo.off_proc_id_opr_seq'::regclass)
id_off_fk int4 10
offerings.id_off off_proc_id_off_fk_fkey C
id_prc_fk int4 10
procedures.id_prc off_proc_id_prc_fk_fkey C

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

Indexes:
Column(s) Type Sort Constraint Name
id_off_prc Primary key Asc off_proc_pkey
id_off_fk + id_prc_fk Must be unique Asc/Asc off_proc_id_off_fk_key

Close relationships  within of separation: