acq.provider_note

↑ acq schema

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

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('acq.provider_note_id_seq'::regclass)

provider FK

integer

No

→ acq.provider(id)

creator FK

integer

No

→ actor.usr(id)

editor FK

integer

No

→ actor.usr(id)

create_time

timestamp with time zone

No

now()

edit_time

timestamp with time zone

No

now()

value

text

No

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

creator

actor.usr(id)

NO ACTION

NO ACTION

DEFERRED

provider_note_creator_fkey

editor

actor.usr(id)

NO ACTION

NO ACTION

DEFERRED

provider_note_editor_fkey

provider

acq.provider(id)

NO ACTION

NO ACTION

DEFERRED

provider_note_provider_fkey

Indexes

Index Method Definition

provider_note_pkey PK

btree

CREATE UNIQUE INDEX provider_note_pkey ON acq.provider_note USING btree (id)

acq_pro_note_creator_idx

btree

CREATE INDEX acq_pro_note_creator_idx ON acq.provider_note USING btree (creator)

acq_pro_note_editor_idx

btree

CREATE INDEX acq_pro_note_editor_idx ON acq.provider_note USING btree (editor)

acq_pro_note_pro_idx

btree

CREATE INDEX acq_pro_note_pro_idx ON acq.provider_note USING btree (provider)
Previous
Next