ticket_log

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
obj_oid int8 19 null
type wcof_tag 2147483647 √ null
summary varchar 2147483647 √ null
comment varchar 2147483647 √ null
date timestamptz 35,6 √ null
expense money 2147483647 √ null
time_worked interval 49,6 √ null
ticket_oid int8 19 √ null
ticket.obj_oid fkcticket_log_ticket_oidC
agent_oid int8 19 √ 1
person.obj_oid fkcticket_log_agent_oid
expense_type_oid int8 19 √ null
ticket_expense_type.obj_oid fkcticket_log_expense_type_oidN
work_type_oid int8 19 √ null
ticket_work_type.obj_oid fkcticket_log_work_type_oidN

Indexes

Constraint Name Type Sort Column(s)
ticket_log_pkey Primary key Asc obj_oid
ticket_log_expense Performance Asc expense
ticket_log_ticket_oid Performance Asc ticket_oid
ticket_log_time_worked Performance Asc time_worked

Relationships

Close relationships within degrees of separation