booking.resource_attr_value

↑ booking schema

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

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('booking.resource_attr_value_id_seq'::regclass)
owner FK	`integer`	No		→ actor.org_unit(id)
attr FK	`integer`	No		→ booking.resource_attr(id)
valid_value	`text`	No

id PK

integer

nextval('booking.resource_attr_value_id_seq'::regclass)

owner FK

integer

→ actor.org_unit(id)

attr FK

integer

→ booking.resource_attr(id)

valid_value

text

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`attr`	booking.resource_attr(id)	NO ACTION	NO ACTION	DEFERRED	`resource_attr_value_attr_fkey`
`owner`	actor.org_unit(id)	NO ACTION	NO ACTION	DEFERRED	`resource_attr_value_owner_fkey`

attr

booking.resource_attr(id)

NO ACTION

DEFERRED

resource_attr_value_attr_fkey

owner

actor.org_unit(id)

NO ACTION

DEFERRED

resource_attr_value_owner_fkey

Unique Constraints

brav_logical_key: (owner, attr, valid_value)

Indexes

Index Method Definition

Index	Method	Definition
`resource_attr_value_pkey` PK	btree	`CREATE UNIQUE INDEX resource_attr_value_pkey ON booking.resource_attr_value USING btree (id)`
`brav_logical_key` UNIQUE	btree	`CREATE UNIQUE INDEX brav_logical_key ON booking.resource_attr_value USING btree (owner, attr, valid_value)`

resource_attr_value_pkey PK

btree

CREATE UNIQUE INDEX resource_attr_value_pkey ON booking.resource_attr_value USING btree (id)

brav_logical_key UNIQUE

btree

CREATE UNIQUE INDEX brav_logical_key ON booking.resource_attr_value USING btree (owner, attr, valid_value)

Referenced By

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

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

Table	Referencing Column(s)	Referenced Column(s)	Constraint
booking.reservation_attr_value_map	`attr_value`	`id`	`reservation_attr_value_map_attr_value_fkey`
booking.resource_attr_map	`value`	`id`	`resource_attr_map_value_fkey`

booking.reservation_attr_value_map

attr_value

id

reservation_attr_value_map_attr_value_fkey

booking.resource_attr_map

value

id

resource_attr_map_value_fkey