Data types
All tables listing the attributes of entities contain a column "Java data type". The Java data type rather than the database data type is specified because depending on the used database, i.e., MySQL or Oracle, the database data type may vary. Hereafter, you find the default mappings between Java and database data types in nevisIDM.
| Java data type | Oracle data type | MySQL data type |
|---|---|---|
| Boolean | number(1,0) | bit |
| Date | date | datetime |
| Integer | number(10,0) | int |
| Long | number(19,0) | bigint |
| Short | number(5,0) | smallint |
| String | varchar2 | varchar, text |