authority.record_note

↑ authority schema

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

Columns

Column Type Nullable Default Notes

id PK

bigint

No

nextval('authority.record_note_id_seq'::regclass)

record FK

bigint

No

→ authority.record_entry(id)

value

text

No

creator

integer

No

1

editor

integer

No

1

create_date

timestamp with time zone

No

now()

edit_date

timestamp with time zone

No

now()

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

record

authority.record_entry(id)

NO ACTION

NO ACTION

DEFERRED

record_note_record_fkey

Indexes

Index Method Definition

record_note_pkey PK

btree

CREATE UNIQUE INDEX record_note_pkey ON authority.record_note USING btree (id)

authority_record_note_creator_idx

btree

CREATE INDEX authority_record_note_creator_idx ON authority.record_note USING btree (creator)

authority_record_note_editor_idx

btree

CREATE INDEX authority_record_note_editor_idx ON authority.record_note USING btree (editor)

authority_record_note_record_idx

btree

CREATE INDEX authority_record_note_record_idx ON authority.record_note USING btree (record)
Previous
Next