Table istsos.demo.procedures
Stores the 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_prc serial 10  √  nextval('demo.procedures_id_prc_seq'::regclass)
cron_log.id_prc_fk cron_log_id_prc_fk_fkey C
event_time.id_prc_fk event_time_id_prc_fk_fkey C
off_proc.id_prc_fk off_proc_id_prc_fk_fkey C
proc_obs.id_prc_fk proc_obs_id_prc_fk_fkey C
name_prc varchar 30
desc_prc text 2147483647  √  null
stime_prc timestamptz 35,6  √  null
etime_prc timestamptz 35,6  √  null
time_res_prc int4 10  √  null
time_acq_prc int4 10  √  null
id_oty_fk int4 10  √  null
obs_type.id_oty procedures_id_oty_fk_fkey R
id_foi_fk int4 10  √  null
foi.id_foi procedures_id_foi_fk_fkey R
assignedid_prc varchar 32

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

Indexes:
Column(s) Type Sort Constraint Name
id_prc Primary key Asc procedures_pkey
assignedid_prc Must be unique Asc procedures_assignedid_prc_key

Close relationships  within of separation: