Table webco_3.9.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 timestamp 29,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 varchar 2147483647  √  null
class varchar 2147483647  √  null
instance int8 19  √  null
log_text varchar 2147483647  √  null

Table contained 0 rows at Wed May 07 11:05 EDT 2014

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

Close relationships  within of separation: