lineitem_detail

57 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('acq.lineitem_detail_id_seq'::regclass)
claim.lineitem_detail claim_lineitem_detail_fkey R
lineitem int4 10 null
lineitem.id lineitem_detail_lineitem_fkey C
fund int4 10 √ null
fund.id lineitem_detail_fund_fkey R
fund_debit int4 10 √ null
fund_debit.id lineitem_detail_fund_debit_fkey R
eg_copy_id int8 19 √ null
barcode text 2147483647 √ null
cn_label text 2147483647 √ null
note text 2147483647 √ null
collection_code text 2147483647 √ null
circ_modifier text 2147483647 √ null
circ_modifier.code lineitem_detail_circ_modifier_fkey N
owning_lib int4 10 √ null
org_unit.id lineitem_detail_owning_lib_fkey N
location int4 10 √ null
copy_location.id lineitem_detail_location_fkey N
recv_time timestamptz 35,6 √ null
receiver int4 10 √ null
usr.id lineitem_detail_receiver_fkey R
cancel_reason int4 10 √ null
cancel_reason.id lineitem_detail_cancel_reason_fkey R

Indexes

Constraint Name Type Sort Column(s)
lineitem_detail_pkey Primary key Asc id
li_detail_li_idx Performance Asc lineitem
lineitem_detail_fund_debit_idx Performance Asc fund_debit

Relationships

Close relationships within degrees of separation