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: [email protected] [mailto:[email protected]] 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 [email protected] P Go Green - Save a tree! Please don't print this e-mail unless it's really necessary.
