Targeted Environment
...
Version ---- (2021-01-28) (based on the dev branch)
Breaking change
N/A
MTOA Database – Release Note for Version (v1.13.0)
Schema Structure Changes
Table | Column | Comments |
|---|---|---|
YY201_SERVICE_REQUEST | SERVICE_REQUEST_ID, TC_SERVICE_CD | New AK to be used as FK by table YY213_SVC_REQUEST_REGULATED_ENTITY_VALUE |
TC227_SERVICE_REGULATED | SERVICE_REGULATED_ENTITY_ID_TYPE_ID | Drop column and PK |
TC_SERVICE_CD, REGULATED_ENTITY_ID_TYPE_CD | New PK | |
YY213_SVC_REQUEST_ | SERVICE_REGULATED_ENTITY_ID_TYPE_ID | Drop column and FK to TC227_SERVICE_REGULATED_ENTITY_ID_TYPE |
TC_SERVICE_CD, REGULATED_ENTITY_ID_TYPE_CD | New columns and FK to table TC227_SERVICE_REGULATED_ENTITY_ID_TYPE | |
SERVICE_REQUEST_ID, TC_SERVICE_CD, REGULATED_ENTITY_ID_TYPE_CD | New AK to enforce uniqueness per service request | |
SERVICE_REQUEST_ID, TC_SERVICE_CD | New FK to table YY201_SERVICE_REQUEST to make sure the regulated entities are for the same service. |
Data Changes
No data change in this release.
...