booking.resource_attr

↑ booking schema

Cascading Deletes: Deleting rows from this table will cascade to: booking.resource_type.

Deferrable Constraints: The following FK constraints are deferrable — they are checked at transaction end, not statement end: resource_attr_owner_fkey, resource_attr_resource_type_fkey.

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('booking.resource_attr_id_seq'::regclass)

owner FK

integer

No

→ actor.org_unit(id)

name

text

No

resource_type FK

integer

No

→ booking.resource_type(id)

required

boolean

No

false

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

owner

actor.org_unit(id)

NO ACTION

NO ACTION

DEFERRED

resource_attr_owner_fkey

resource_type

booking.resource_type(id)

CASCADE

NO ACTION

DEFERRED

resource_attr_resource_type_fkey

Unique Constraints

  • bra_name_once_per_type: (resource_type, name)

Indexes

Index Method Definition

resource_attr_pkey PK

btree

CREATE UNIQUE INDEX resource_attr_pkey ON booking.resource_attr USING btree (id)

bra_name_once_per_type UNIQUE

btree

CREATE UNIQUE INDEX bra_name_once_per_type ON booking.resource_attr USING btree (resource_type, name)

Referenced By

The following tables have foreign keys pointing to booking.resource_attr (2 referencing table(s)):

Table Referencing Column(s) Referenced Column(s) Constraint

booking.resource_attr_map

resource_attr

id

resource_attr_map_resource_attr_fkey

booking.resource_attr_value

attr

id

resource_attr_value_attr_fkey
Previous
Next