serial.item_note

Cascading Deletes: Deleting rows from this table will cascade to: serial.item.

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

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('serial.item_note_id_seq'::regclass)
item FK	`integer`	No		→ serial.item(id)
creator FK	`integer`	No		→ actor.usr(id)
create_date	`timestamp with time zone`	Yes	now()
pub	`boolean`	No	false
alert	`boolean`	No	false
title	`text`	No
value	`text`	No

id PK

integer

nextval('serial.item_note_id_seq'::regclass)

item FK

integer

→ serial.item(id)

creator FK

integer

→ actor.usr(id)

create_date

timestamp with time zone

Yes

now()

pub

boolean

false

alert

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)	NO ACTION	NO ACTION	DEFERRED	`item_note_creator_fkey`
`item`	serial.item(id)	CASCADE	NO ACTION	DEFERRED	`item_note_item_fkey`

creator

actor.usr(id)

NO ACTION

DEFERRED

item_note_creator_fkey

item

serial.item(id)

CASCADE

NO ACTION

DEFERRED

item_note_item_fkey

Indexes

Index Method Definition

Index	Method	Definition
`item_note_pkey` PK	btree	`CREATE UNIQUE INDEX item_note_pkey ON serial.item_note USING btree (id)`
`serial_item_note_item_idx`	btree	`CREATE INDEX serial_item_note_item_idx ON serial.item_note USING btree (item)`

item_note_pkey PK

btree

CREATE UNIQUE INDEX item_note_pkey ON serial.item_note USING btree (id)

serial_item_note_item_idx

btree

CREATE INDEX serial_item_note_item_idx ON serial.item_note USING btree (item)