Table webco_4.7.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
checkout_center_oid int8 19  √  null
checkout_center.obj_oid fkcwco_log_cc_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 Thu Feb 14 09:20 CST 2019

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

Close relationships  within of separation: