organization

1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
obj_oid int8 19 null
account_credit.organization_oid fkacct_cred_orgC
account_debit.organization_oid fkacct_deb_orgC
authset_delegation.org_oid fkcauthset_delegation_org_oidC
checkout_center.org_oid checkout_center_org_oid_fkeyC
email_template.organization_oid email_template_organization_oid_fkeyC
email_template_set.organization_oid email_template_set_organization_oid_fkeyC
hold.organization_oid fkchold_organization_oidC
inventory.organization_oid inventory_organization_oid_fkeyC
invoice.org_oid fkcinvoice_org_oidC
location.organization_oid fklocation_org_oidC
maintenance_type.organization_oid fkmainttype_org_oidR
patron_custom_data.organization_oid patron_custom_data_organization_oid_fkeyC
person_role.organization_oid fkcapability_organization_oidC
resource_type.org_oid fkcresource_type_org_oidC
sched_employee.organization_oid sched_employee_organization_oid_fkeyC
sched_staffed_location.org_oid sched_staffed_location_org_oid_fkeyC
task.organization_oid task_organization_oid_fkeyC
task_profile.organization_oid task_profile_organization_oid_fkeyC
task_type.organization_oid task_type_organization_oid_fkeyC
tax_rate.organization_oid fk_taxrates_organization_oidC
ticket.organization_oid fkticket_org_oidR
ticket_assignment_rule.organization_oid tar_org_oidC
vendor.organization_oid fkmainttype_org_oidR
wco_application.default_org_oid fkapp_default_org_oidR
wco_group.organization_oid fkcwco_group_organization_oidC
wco_log.org_oid fkcwco_log_org_oid
name varchar 2147483647 √ null
admin_id int8 19 √ null
person.obj_oid fkcorg_admin_idN
restricted bool 1 √ null
suppress_autopayment bool 1 √ null
due_days interval 49,6 √ null
hold_days interval 49,6 √ null
cc_reporting_patron bool 1 √ null
honor_external_holds _int4 10 ARRAY[]::integer[]
honor_external_fines _int4 10 ARRAY[]::integer[]
honor_external_lates _int4 10 ARRAY[]::integer[]
messaging_from_address varchar 2147483647 √ null
reply_to_address varchar 2147483647 √ null
fine_account varchar 2147483647 √ null
taxable_invoices wcof_tag 2147483647 √ null
constrain_account_codes bool 1 √ null
street varchar 2147483647 √ null
street2 varchar 2147483647 √ null
city varchar 2147483647 √ null
state varchar 2147483647 √ null
country varchar 2147483647 √ null
postal_code varchar 2147483647 √ null
timezone varchar 2147483647 √ null
locale varchar 2147483647 √ null
default_allocation_times wcof_default_allocation_times 2147483647 √ null
email_template_set_oid int8 19 √ null
email_template_set.obj_oid organization_email_template_set_oid_fkeyN

Indexes

Constraint Name Type Sort Column(s)
organization_pkey Primary key Asc obj_oid

Relationships

Close relationships within degrees of separation