SCV Entity Properties
- Validate business properties specified by users against system properties specified in the Column Registry to prevent inclusion of system properties in entity definitions
- Prevent deletion of entity properties once the corresponding columns are created in the database
- Allow extending column data types as displayed in the table below:
From type\ To type NVARCHAR(y) INT BIGINT FLOAT DATETIME2(7) DATE NVARCHAR(x) x<y INT y>=20 ✓ ✓ BIGINT y>=40 ✓ FLOAT y>=40 DATETIME2(7) y>=40 ✓ DATE y>=10 ✓
Entity properties are used to create the business columns in the underlying SCV tables. When generating the SCV tables from entity definitions, business columns are created in the tables and several system generated columns are added, such as cycle_period_id, source and ID. The entity definitions are now validated against the list of system generated columns, preventing users to create the same columns as business columns. This in turn avoids synchronization errors where entity definitions remain build in progress.
In addition, after a table and the related columns have been created in the SCV database, it has not been possible to change in the database anymore. It is now possible to change the data type of the business properties, only if the conversion at the database level does not fail due to existing data in the column. Therefore, only a certain set of data type transitions are allowed, as listed in the table, such as increasing the length of a text column.
No additional changes are allowed in the UI to entity properties when the corresponding columns are already created in the SCV database.