DaaS Database Tables Changed: Ennov InSight 7.3
The following DaaS Database fields, columns or/and tables were added, modified, or removed in this release.
|
Field Name |
Fiel d Size |
Database Column Name |
Databas e Column Size |
Database Table Name |
| Default Flag | N/A | N/A | N/A | The APP_PRODFAM table is updated to display the new Default Flag field. If a product family is assigned to an application this field shows YES value. Otherwise, the value NO is shown. |
| N/A | N/A | N/A | N/A |
The ATTACHED_DOCUMENT_STATUS_ TYPE table is added. |
| N/A | N/A | N/A | N/A | The CTD_TYPE table is added. |
| N/A | N/A | N/A | N/A |
The PDS_BROAD_INDC_COUNTRY_ INTENDED_EFFECT_COMORBIDIT Y table is added. |
| N/A | N/A | N/A | N/A |
The SOURCE_OF_INFORMATION_TYPE table is added. |
| N/A | N/A | ATTACHED_DOCUMENT_TYPE_ID | N/A | The respective column is removed from ACTION_ATTACHMENT table. |
| N/A | N/A |
ATTACHED_DOCUMENT_STATUS_ TYPE_ID URL |
N/A | The respective columns are added to the ACTION_ATTACHMENT table. |
|
Field Name |
Fiel d Size |
Database Column Name |
Databas e Column Size |
Database Table Name |
| N/A | N/A |
COMPANY_NAME DELIMITER FIRST_NAME INITIALS LAST_NAME MIDDLE_NAME PREFIX SUFFIX UUID |
N/A | The respective columns are added to the APPLICANT_CONTACT table. |
| N/A | N/A | CTD_TYPE_ID | N/A | The respective columns are added to the APPLICANT_CONTACT_TYPE table. |
| N/A | N/A | CODESYSTEM_FOR_SDKEYWORDS | N/A | The respective columns are added APPLICATION table. |
| N/A | N/A | CODE | N/A | The respective column is added to the EVENT_PLAN_COUNTRY table. |
| N/A | N/A | QUANTITY_MEASURE_TYPE_ID | N/A | The respective column is added to the MANUFACTURED_ITEM table. |
| N/A | N/A |
DEVICE_CLASS_TYPE_ID DEVICE_DESCRIPTION DEVICE_INTENDED_USE DEVICE_LANGUAGE_TYPE_ID |
N/A | The respective columns are added to the PDS_MED_DEVICE_CHANGE table. |
|
Field Name |
Fiel d Size |
Database Column Name |
Databas e Column Size |
Database Table Name |
| N/A | N/A |
MI_QUANTITY_MEASURE_TYPE_I D PDS_MED_DEVICE_QTY_MEASURE _TYPE_ID PI_CONTAINER_QUANTITY_MEAS URE_TYPE_ID |
N/A |
The respective columns are added to the PDS_PACKSET_DETAIL_CHANGE table. |
| N/A | N/A | QUANTITY_MEASURE_TYPE_ID | N/A | The respective column is added to the PDS_PACKSIZE table. |
| N/A | N/A | QUANTITY_MEASURE_TYPE_ID | N/A | The respective column is added to the PDS_PACKSIZE_CHANGE table. |
| N/A | N/A |
CTD_TYPE_ID UUID |
N/A | The respective columns are added to the SEQUENCE table. |