acq.lineitem_usr_attr_definition

↑ acq schema

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

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`bigint`	No	nextval('acq.lineitem_attr_definition_id_seq'::regclass)
code	`text`	No
description	`text`	No
remove	`text`	No	''::text
ident	`boolean`	No	false
usr FK	`integer`	No		→ actor.usr(id)

id PK

bigint

nextval('acq.lineitem_attr_definition_id_seq'::regclass)

code

text

description

text

remove

text

''::text

ident

boolean

false

usr FK

integer

→ actor.usr(id)

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`usr`	actor.usr(id)	NO ACTION	NO ACTION	DEFERRED	`lineitem_usr_attr_definition_usr_fkey`

usr

actor.usr(id)

NO ACTION

DEFERRED

lineitem_usr_attr_definition_usr_fkey

Indexes

Index Method Definition

Index	Method	Definition
`lineitem_usr_attr_definition_pkey` PK	btree	`CREATE UNIQUE INDEX lineitem_usr_attr_definition_pkey ON acq.lineitem_usr_attr_definition USING btree (id)`
`li_usr_attr_def_usr_idx`	btree	`CREATE INDEX li_usr_attr_def_usr_idx ON acq.lineitem_usr_attr_definition USING btree (usr)`

lineitem_usr_attr_definition_pkey PK

btree

CREATE UNIQUE INDEX lineitem_usr_attr_definition_pkey ON acq.lineitem_usr_attr_definition USING btree (id)

li_usr_attr_def_usr_idx

btree

CREATE INDEX li_usr_attr_def_usr_idx ON acq.lineitem_usr_attr_definition USING btree (usr)