Table test_seqware_meta_db.public.expense
Auxiliary table for tracking expenses (not used at OICR)

 Generated by
SchemaSpy
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
expense_id serial 10  √  nextval('expense_expense_id_seq'::regclass)
expense_attribute.expense_id expense_attribute_expense_id_fkey R
invoice_id int4 10
invoice.invoice_id invoice_id_fk R
workflow_run_id int4 10  √  null
agent text 2147483647  √  null
expense_type text 2147483647  √  null
description text 2147483647  √  null
price_per_unit numeric 131089  √  null
total_units numeric 131089  √  null
total_price numeric 131089  √  null
added_surcharge numeric 131089  √  null
sw_accession serial 10  √   √  nextval('sw_accession_seq'::regclass)
expense_finished_tstmp timestamp 29,6  √  null

Table contained 0 rows at Mon Mar 31 13:20 EDT 2014

Indexes:
Column(s) Type Sort Constraint Name
expense_id Primary key Asc expense_pkey

Close relationships  within of separation: