[
https://issues.apache.org/jira/browse/OFBIZ-1313?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12532530
]
David E. Jones commented on OFBIZ-1313:
---------------------------------------
Yeah, I kind of object to this... think it's a bad idea. Still, not a bad
enough idea that I'd say a hard no. Foreign keys are always nice to keep data
clean, and avoid things like somehow incorrect visitIds in the tracking code
table. Not that it's likely, but the whole point is to avoid problems or catch
them early.
Please hold off for a few days at least to allow others to comment...
This might actually have been better to start as a mailing list thread, but I'm
guessing you weren't expecting real objections.
> Remove some Visit-related foreign keys
> --------------------------------------
>
> Key: OFBIZ-1313
> URL: https://issues.apache.org/jira/browse/OFBIZ-1313
> Project: OFBiz
> Issue Type: Improvement
> Reporter: Si Chen
> Assignee: Si Chen
> Priority: Minor
>
> I would recommend that we remove the foreign keys to the Visit entity, so old
> Visit records can be safely deleted without affecting data in
> TrackingCodeVisit, which might be useful for statistical and reporting
> purposes. It should not affect the core entities. The visits would only no
> longer be available after some time has passed.
> If no one has any objections I'll take care of this.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
