[OFBIZ-9671] Add missing foreign key constraints in entity definition

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Implemented
• Affects Version/s: Trunk
• Fix Version/s: Upcoming Branch
• Component/s: ALL COMPONENTS
• Assignee: Chandan Khandelwal
• Reporter: Chandan Khandelwal
• Created: 31/Aug/17 08:01
• Updated: 02/Oct/19 14:49
• Resolved: 02/Oct/19 14:49

Description

There are multiple entities which have missing foreign key constraints.

Example:
OrderItem.productFeatureId
OrderItem.shoppingListId
OrderItem.shoppingListItemSeqId
AgreementItem.currencyUomId
etc...

Issue Links

• relates to: OFBIZ-9647 Missing Relationship from OrderHeader to WebSite

Sub-Tasks

• Missing Relationship from OrderHeader to WebSite: Closed
• Missing foreign key constraint for fields userLoginId & userPrefGroupTypeId in UserPreference entity: Closed
• Missing FK constraints in OrderItem entity for ShoppingListItem: Closed