booking.resource_type

↑ booking schema

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

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('booking.resource_type_id_seq'::regclass)

name

text

No

elbow_room

interval

Yes

fine_interval

interval

Yes

fine_amount

numeric(8,2)

No

0

max_fine

numeric(8,2)

Yes

owner FK

integer

No

→ actor.org_unit(id)

catalog_item

boolean

No

false

transferable

boolean

No

false

record FK

bigint

Yes

→ biblio.record_entry(id)

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_type_owner_fkey

record

biblio.record_entry(id)

NO ACTION

NO ACTION

DEFERRED

resource_type_record_fkey

Unique Constraints

  • brt_name_and_record_once_per_owner: (owner, name, record)

Indexes

Index Method Definition

resource_type_pkey PK

btree

CREATE UNIQUE INDEX resource_type_pkey ON booking.resource_type USING btree (id)

brt_name_and_record_once_per_owner UNIQUE

btree

CREATE UNIQUE INDEX brt_name_and_record_once_per_owner ON booking.resource_type USING btree (owner, name, record)

Referenced By

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

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

booking.reservation

target_resource_type

id

reservation_target_resource_type_fkey

booking.resource

type

id

resource_type_fkey

booking.resource_attr

resource_type

id

resource_attr_resource_type_fkey
Previous
Next