wco_log

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
obj_oid int8 19 null
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

Indexes

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

Relationships

Close relationships within degrees of separation