location

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
obj_oid int8 19 null
location.parent_location_oid fklocation_parent_oidN
name varchar 2147483647 null
organization_oid int8 19 null
organization.obj_oid fklocation_org_oidC
parent_location_oid int8 19 null
location.obj_oid fklocation_parent_oidN
building varchar 2147483647 √ null
room varchar 2147483647 √ 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
telephone varchar 2147483647 √ null
resource_oid int8 19 √ null
resource.obj_oid fklocation_rsrc_oidC

Indexes

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

Relationships

Close relationships within degrees of separation