booking.resource_attr_map

↑ booking schema

Cascading Deletes: Deleting rows from this table will cascade to: booking.resource_attr, booking.resource.

Deferrable Constraints: The following FK constraints are deferrable — they are checked at transaction end, not statement end: resource_attr_map_resource_attr_fkey, resource_attr_map_resource_fkey, resource_attr_map_value_fkey.

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('booking.resource_attr_map_id_seq'::regclass)

resource FK

integer

No

→ booking.resource(id)

resource_attr FK

integer

No

→ booking.resource_attr(id)

value FK

integer

No

→ booking.resource_attr_value(id)

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

resource_attr

booking.resource_attr(id)

CASCADE

NO ACTION

DEFERRED

resource_attr_map_resource_attr_fkey

resource

booking.resource(id)

CASCADE

NO ACTION

DEFERRED

resource_attr_map_resource_fkey

value

booking.resource_attr_value(id)

NO ACTION

NO ACTION

DEFERRED

resource_attr_map_value_fkey

Unique Constraints

  • bram_one_value_per_attr: (resource, resource_attr)

Indexes

Index Method Definition

resource_attr_map_pkey PK

btree

CREATE UNIQUE INDEX resource_attr_map_pkey ON booking.resource_attr_map USING btree (id)

bram_one_value_per_attr UNIQUE

btree

CREATE UNIQUE INDEX bram_one_value_per_attr ON booking.resource_attr_map USING btree (resource, resource_attr)
Previous
Next