Table webco_4.3.3.public.wco_log 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
obj_oid int8 19
time_stamp timestamptz 35,6  √  null
org_oid int8 19  √  null
organization.obj_oid fkcwco_log_org_oid
loc_oid int8 19  √  null
location.obj_oid fkcwco_log_loc_oid
agent_oid int8 19  √  1
person.obj_oid fkcwco_log_agent_oid
responsible_agent_oid int8 19  √  1
person.obj_oid fkcwco_log_reps_agent_oid
ip_addr int8 19  √  null
action wcof_tag 2147483647  √  null
class varchar 2147483647  √  null
instance int8 19  √  null
log_text varchar 2147483647  √  null

Table contained 0 rows at Fri Sep 23 14:49 CDT 2016

Indexes:
Column(s) Type Sort Constraint Name
obj_oid Primary key Asc wco_log_pkey
action Performance Asc wco_log_action_idx
time_stamp Performance Asc wco_log_time_stamp_idx

Close relationships  within of separation: