department

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
obj_oid int8 19 null
account.department_oid fkcdepartment_oidC
department_code.department_oid fkcdepartment_code_department_oidC
inventory_item.inventoried_assigned_department_oid inventory_item_inventoried_assigned_department_oid_fkeyN
resource.assigned_department_oid fkcres_departmentN
name varchar 2147483647 null
billing_contact_oid int8 19 √ null
person.obj_oid fkcdepartment_billing_contact_oidN
street varchar 2147483647 √ null
street2 varchar 2147483647 √ null
city varchar 2147483647 √ null
state varchar 2147483647 √ null
postal_code varchar 2147483647 √ null
country varchar 2147483647 √ null
email varchar 2147483647 √ null
telephone varchar 2147483647 √ null
fax varchar 2147483647 √ null
tax_exempt_number varchar 2147483647 √ null
origin varchar 2147483647 null
deleted bool 1 √ null

Indexes

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

Relationships

Close relationships within degrees of separation