asset.call_number_note

Cascading Deletes: Deleting rows from this table will cascade to: asset.call_number.

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

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`bigint`	No	nextval('asset.call_number_note_id_seq'::regclass)
call_number FK	`bigint`	No		→ asset.call_number(id)
creator FK	`bigint`	No		→ actor.usr(id)
create_date	`timestamp with time zone`	Yes	now()
pub	`boolean`	No	false
title	`text`	No
value	`text`	No

id PK

bigint

nextval('asset.call_number_note_id_seq'::regclass)

call_number FK

bigint

→ asset.call_number(id)

creator FK

bigint

→ actor.usr(id)

create_date

timestamp with time zone

Yes

now()

pub

boolean

false

title

text

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
`creator`	actor.usr(id)	SET NULL	NO ACTION	DEFERRED	`asset_call_number_note_creator_fkey`
`call_number`	asset.call_number(id)	CASCADE	NO ACTION	DEFERRED	`asset_call_number_note_record_fkey`

creator

actor.usr(id)

SET NULL

NO ACTION

DEFERRED

asset_call_number_note_creator_fkey

call_number

asset.call_number(id)

CASCADE

NO ACTION

DEFERRED

asset_call_number_note_record_fkey

Indexes

Index Method Definition

Index	Method	Definition
`call_number_note_pkey` PK	btree	`CREATE UNIQUE INDEX call_number_note_pkey ON asset.call_number_note USING btree (id)`
`asset_call_number_note_creator_idx`	btree	`CREATE INDEX asset_call_number_note_creator_idx ON asset.call_number_note USING btree (creator)`

call_number_note_pkey PK

btree

CREATE UNIQUE INDEX call_number_note_pkey ON asset.call_number_note USING btree (id)

asset_call_number_note_creator_idx

btree

CREATE INDEX asset_call_number_note_creator_idx ON asset.call_number_note USING btree (creator)