ticket

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
obj_oid int8 19 null
maintenance_event.ticket_oid kmaintevent_ticket_oidR
ticket_log.ticket_oid fkcticket_log_ticket_oidC
name varchar 2147483647 null
organization_oid int8 19 null
organization.obj_oid fkticket_org_oidR
state wcof_tag 2147483647 √ null
type_oid int8 19 null
ticket_type.obj_oid fkticket_type_oidR
resolution_oid int8 19 √ null
ticket_resolution.obj_oid fkticket_resolution_oidR
priority_oid int8 19 null
ticket_priority.obj_oid fkticket_priority_oidR
severity_oid int8 19 null
ticket_severity.obj_oid fkticket_severity_oidR
problem_type_oid int8 19 null
ticket_problem_type.obj_oid fkticket_problem_type_oidR
remedy_type_oid int8 19 √ null
ticket_remedy_type.obj_oid fkticket_remedy_type_oidR
summary varchar 2147483647 √ null
open_date timestamptz 35,6 √ null
est_close_date timestamptz 35,6 √ null
close_date timestamptz 35,6 √ null
patron_oid int8 19 √ null
person.obj_oid fkticket_patronN
agent_oid int8 19 √ 1
person.obj_oid fkticket_agent
responsible_op_oid int8 19 √ 1
person.obj_oid fkticket_responsible_op
resource_oid int8 19 √ null
resource.obj_oid fkticket_resN
repair_price money 2147483647 √ null
repair_warranty_labor varchar 2147483647 √ null
repair_warranty_parts varchar 2147483647 √ null
date_sent_out timestamptz 35,6 √ null
date_returned timestamptz 35,6 √ null
vendor_oid int8 19 √ null
vendor.obj_oid fkticket_vendor_oidN
purchase_order varchar 2147483647 √ null
location_oid int8 19 √ null
resource.obj_oid fkticket_locationN
location_note varchar 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
ticket_pkey Primary key Asc obj_oid
ticket_name_key Must be unique Asc name
ticket_name_unique_idx Performance Asc name

Relationships

Close relationships within degrees of separation