[OPEN-ILS-DEV] Deleting Rows in tables

[Dan Pearl]

action_trigger.event_output is referred to by action_trigger.event

This should not pose a problem, of course, if the referring event is deleted along with the event_output.

 

 

 

From: open-ils-dev-bounces at list.georgialibraries.org [mailto:open-ils-dev-bounces at list.georgialibraries.org] On Behalf Of Tim Spindler
Sent: Friday, October 31, 2014 2:22 PM
To: Evergreen Development Discussion List
Subject: [OPEN-ILS-DEV] Deleting Rows in tables

 

I asked this originally in IRC but I thought I would bring it here since I need to be more wordy.  We are looking at sending a retention period for records in the following tables

acq.edi_message

action.aged_circulation  -  we would update the count extend_reporter.legacy_circ_count table (we also have extend_reporter.legacy_last_checkout that would be updated so we don't lose that 
information)

action.aged_holds

action_trigger.event_output

actor.usr_activity  


 

Other than losing certain reporting data and some potentially auditing information, I have not found critical dependencies that would break relationships but I want to be certain. 

Are others aware of problems I might not be considering if we deleted rows from these tables?


-- 

Tim Spindler
tjspindler at gmail.com

 

P   Go Green - Save a tree! Please don't print this e-mail unless it's really necessary.

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-dev/attachments/20141031/fb4c7eb4/attachment.htm>