Relation between business data and business case
| Primary Key | Name | Type | Length | Precision | Can Be Null | Default | References | Action | Hints | Comment |
|---|---|---|---|---|---|---|---|---|---|---|
| true | BusinessDataId | VARCHAR | 100 | false | References the business data that belongs to the business case. BusinessDataId is not referencing IWA_BusinessData because it might be possible in future to store business data in an database. Because it is not possible to have reference integrity checks database we decided by design to not reference IWA_BusinessData here. | |||||
| false | ObjectType | VARCHAR | 255 | false | Stores the object class. Redudant with IWA_BusinessData.ObjectType but if IWA_BusinessData is external needed for fast access | |||||
| false | BusinessCaseId | BIGINT | false | IWA_Case(CaseId) | ON DELETE CASCADE |
| Constraint | Name | Columns | Hints | Comment |
|---|---|---|---|---|
| UNIQUE | IWA_BusCsDt_BsCsIdAndObTypIdx | BusinessCaseId , ObjectType |
| Name | Columns | Hints | Comment |
|---|---|---|---|
| IWA_BusinessCaseData_BusinessCaseId | BusinessCaseId |
| Object | Strategy |
|---|---|
| IWA_BusinessCaseData | ALL_REMOVE_UNUSED |