po_item

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('acq.po_item_id_seq'::regclass)
invoice_item.po_item invoice_item_po_item_fkey R
purchase_order int4 10 √ null
purchase_order.id po_item_purchase_order_fkey N
fund_debit int4 10 √ null
fund_debit.id po_item_fund_debit_fkey R
inv_item_type text 2147483647 null
invoice_item_type.code po_item_inv_item_type_fkey R
title text 2147483647 √ null
author text 2147483647 √ null
note text 2147483647 √ null
estimated_cost numeric 8,2 √ null
fund int4 10 √ null
fund.id po_item_fund_fkey R
target int8 19 √ null

Indexes

Constraint Name Type Sort Column(s)
po_item_pkey Primary key Asc id
poi_fund_debit_idx Performance Asc fund_debit
poi_po_idx Performance Asc purchase_order

Relationships

Close relationships within degrees of separation