Actually, it's possible that
1) the original bill had been bootstrapped (together with a few patient-related
billed items, perhaps related to Kirk)
gnumed_v17=> select * from bill.bill ;
pk_audit | row_version | modified_when | modified_by | pk |
invoice_id | close_date | apply_vat |
fk_receiver_identity | fk_receiver_address | fk_doc
----------+-------------+-------------------------------+-------------+----+-----------------------------+-------------------------------+-----------+----------------------+---------------------+--------
1658952 | 0 | 2012-06-12 16:54:50.707435-07 | gm-dbo | 1 |
address@hidden | | t |
| |
and
2) that I had deleted those items via psql as part of cleaning out such "demo"
items and also cleaning out the reference table of billable items, and that I had deleted
the items without deleting the bill to which they were attached.
For me to have been able to do so, does a referential integrity attribute or
trigger warrant to be added to the table
bill.bill
??