acq.lineitem_attr

Cascading Deletes: Deleting rows from this table will cascade to: acq.lineitem.

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

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`bigint`	No	nextval('acq.lineitem_attr_id_seq'::regclass)
definition	`bigint`	No
lineitem FK	`bigint`	No		→ acq.lineitem(id)
attr_type	`text`	No
attr_name	`text`	No
attr_value	`text`	No
order_ident	`boolean`	No	false

id PK

bigint

nextval('acq.lineitem_attr_id_seq'::regclass)

definition

bigint

lineitem FK

bigint

→ acq.lineitem(id)

attr_type

text

attr_name

text

attr_value

text

order_ident

boolean

false

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`lineitem`	acq.lineitem(id)	CASCADE	NO ACTION	DEFERRED	`lineitem_attr_lineitem_fkey`

lineitem

acq.lineitem(id)

CASCADE

NO ACTION

DEFERRED

lineitem_attr_lineitem_fkey

Indexes

Index Method Definition

Index	Method	Definition
`lineitem_attr_pkey` PK	btree	`CREATE UNIQUE INDEX lineitem_attr_pkey ON acq.lineitem_attr USING btree (id)`
`li_attr_definition_idx`	btree	`CREATE INDEX li_attr_definition_idx ON acq.lineitem_attr USING btree (definition)`
`li_attr_li_idx`	btree	`CREATE INDEX li_attr_li_idx ON acq.lineitem_attr USING btree (lineitem)`
`li_attr_value_idx`	btree	`CREATE INDEX li_attr_value_idx ON acq.lineitem_attr USING btree (attr_value)`

lineitem_attr_pkey PK

btree

CREATE UNIQUE INDEX lineitem_attr_pkey ON acq.lineitem_attr USING btree (id)

li_attr_definition_idx

btree

CREATE INDEX li_attr_definition_idx ON acq.lineitem_attr USING btree (definition)

li_attr_li_idx

btree

CREATE INDEX li_attr_li_idx ON acq.lineitem_attr USING btree (lineitem)

li_attr_value_idx

btree

CREATE INDEX li_attr_value_idx ON acq.lineitem_attr USING btree (attr_value)