lineitem

111 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('acq.lineitem_id_seq'::regclass)
distribution_formula_application.lineitem distribution_formula_application_lineitem_fkey C
invoice_entry.lineitem invoice_entry_lineitem_fkey N
lineitem_attr.lineitem lineitem_attr_lineitem_fkey C
lineitem_detail.lineitem lineitem_detail_lineitem_fkey C
lineitem_note.lineitem lineitem_note_lineitem_fkey C
shipment_notification_entry.lineitem shipment_notification_entry_lineitem_fkey N
user_request.lineitem user_request_lineitem_fkey C
creator int4 10 null
usr.id lineitem_creator_fkey R
editor int4 10 null
usr.id lineitem_editor_fkey R
selector int4 10 null
usr.id lineitem_selector_fkey R
provider int4 10 √ null
provider.id lineitem_provider_fkey R
purchase_order int4 10 √ null
purchase_order.id lineitem_purchase_order_fkey R
picklist int4 10 √ null
picklist.id lineitem_picklist_fkey R
expected_recv_time timestamptz 35,6 √ null
create_time timestamptz 35,6 now()
edit_time timestamptz 35,6 now()
marc text 2147483647 null
eg_bib_id int8 19 √ null
record_entry.id lineitem_eg_bib_id_fkey R
source_label text 2147483647 √ null
state text 2147483647 'new'::text
cancel_reason int4 10 √ null
cancel_reason.id lineitem_cancel_reason_fkey R
estimated_unit_price numeric 0 √ null
claim_policy int4 10 √ null
claim_policy.id lineitem_claim_policy_fkey R
queued_record int8 19 √ null
queued_bib_record.id lineitem_queued_record_fkey N

Indexes

Constraint Name Type Sort Column(s)
lineitem_pkey Primary key Asc id
li_creator_idx Performance Asc creator
li_editor_idx Performance Asc editor
li_pl_idx Performance Asc picklist
li_po_idx Performance Asc purchase_order
li_queued_record_idx Performance Asc queued_record
li_selector_idx Performance Asc selector

Check Constraints

Constraint Name Constraint
picklist_or_po (((picklist IS NOT NULL) OR (purchase_order IS NOT NULL)))

Relationships

Close relationships within degrees of separation