acq.picklist

↑ acq schema

Deferrable Constraints: The following FK constraints are deferrable — they are checked at transaction end, not statement end: picklist_creator_fkey, picklist_editor_fkey, picklist_org_unit_fkey, picklist_owner_fkey.

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('acq.picklist_id_seq'::regclass)

owner FK

integer

No

→ actor.usr(id)

creator FK

integer

No

→ actor.usr(id)

editor FK

integer

No

→ actor.usr(id)

org_unit FK

integer

No

→ actor.org_unit(id)

name

text

No

create_time

timestamp with time zone

No

now()

edit_time

timestamp with time zone

No

now()

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

creator

actor.usr(id)

NO ACTION

NO ACTION

DEFERRED

picklist_creator_fkey

editor

actor.usr(id)

NO ACTION

NO ACTION

DEFERRED

picklist_editor_fkey

org_unit

actor.org_unit(id)

NO ACTION

NO ACTION

DEFERRED

picklist_org_unit_fkey

owner

actor.usr(id)

NO ACTION

NO ACTION

DEFERRED

picklist_owner_fkey

Unique Constraints

  • name_once_per_owner: (name, owner)

Indexes

Index Method Definition

picklist_pkey PK

btree

CREATE UNIQUE INDEX picklist_pkey ON acq.picklist USING btree (id)

name_once_per_owner UNIQUE

btree

CREATE UNIQUE INDEX name_once_per_owner ON acq.picklist USING btree (name, owner)

acq_picklist_creator_idx

btree

CREATE INDEX acq_picklist_creator_idx ON acq.picklist USING btree (creator)

acq_picklist_editor_idx

btree

CREATE INDEX acq_picklist_editor_idx ON acq.picklist USING btree (editor)

acq_picklist_owner_idx

btree

CREATE INDEX acq_picklist_owner_idx ON acq.picklist USING btree (owner)

Referenced By

The following tables have foreign keys pointing to acq.picklist (1 referencing table(s)):

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

acq.lineitem

picklist

id

lineitem_picklist_fkey
Previous
Next