booking.reservation_attr_value_map

↑ booking schema

Cascading Deletes: Deleting rows from this table will cascade to: booking.resource_attr_value, booking.reservation.

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

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('booking.reservation_attr_value_map_id_seq'::regclass)

reservation FK

integer

No

→ booking.reservation(id)

attr_value FK

integer

No

→ booking.resource_attr_value(id)

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

attr_value

booking.resource_attr_value(id)

CASCADE

NO ACTION

DEFERRED

reservation_attr_value_map_attr_value_fkey

reservation

booking.reservation(id)

CASCADE

NO ACTION

DEFERRED

reservation_attr_value_map_reservation_fkey

Unique Constraints

  • bravm_logical_key: (reservation, attr_value)

Indexes

Index Method Definition

reservation_attr_value_map_pkey PK

btree

CREATE UNIQUE INDEX reservation_attr_value_map_pkey ON booking.reservation_attr_value_map USING btree (id)

bravm_logical_key UNIQUE

btree

CREATE UNIQUE INDEX bravm_logical_key ON booking.reservation_attr_value_map USING btree (reservation, attr_value)
Previous
Next