dbptk-developer
dbptk-developer copied to clipboard
Review report phrasing
When a database from a DBMS is converted into SIARD, sometimes the report shows:
- Type conversion in import module: in `sakila.actor.actor_id` (format: schema.table.column) has original type `SMALLINT UNSIGNED` and was converted to the standard type `SMALLINT`
But types are not actually converted because both original type and inferred standard type are kept in SIARD. So, change phrasing to:
- Column `sakila.actor.actor_id` has type `SMALLINT UNSIGNED` which is not standard, the `SMALLINT` standard type was inferred
The following column data types are not standard and a standard data type was inferred:
+---------------------------------------------------------------------------+
| Schema | Table | Column | Original data type | Inferred standard type |
+---------------------------------------------------------------------------+
| sakila | actor | actor_id | SMALLINT UNSIGNED | SMALLINT |
| sakila | actor | first_name | VARCHAR | CHARACTER VARYING(45) |
+---------------------------------------------------------------------------+