invoice_item

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('acq.invoice_item_id_seq'::regclass)
invoice int4 10 null
invoice.id invoice_item_invoice_fkey C
purchase_order int4 10 √ null
purchase_order.id invoice_item_purchase_order_fkey N
fund_debit int4 10 √ null
fund_debit.id invoice_item_fund_debit_fkey R
inv_item_type text 2147483647 null
invoice_item_type.code invoice_item_inv_item_type_fkey R
title text 2147483647 √ null
author text 2147483647 √ null
note text 2147483647 √ null
cost_billed numeric 8,2 √ null
actual_cost numeric 8,2 √ null
fund int4 10 √ null
fund.id invoice_item_fund_fkey R
amount_paid numeric 8,2 √ null
po_item int4 10 √ null
po_item.id invoice_item_po_item_fkey R
target int8 19 √ null

Indexes

Constraint Name Type Sort Column(s)
invoice_item_pkey Primary key Asc id
ii_fund_debit_idx Performance Asc fund_debit
ii_inv_idx Performance Asc invoice
ii_po_idx Performance Asc purchase_order
ii_poi_idx Performance Asc po_item

Relationships

Close relationships within degrees of separation