Data types
All tables listing the attributes of entities contain a column "Java data type", instead of the database data type. This is because the database data type may vary depending on the used database, that is, Oracle, MariaDB or PostgreSQL. The following table shows the default mappings between Java and database data types in nevisIDM.
| Java data type | Oracle data type | MariaDB data type | PostgreSQL data type |
|---|---|---|---|
| Boolean | number(1,0) | bit | boolean |
| Date | date | datetime | timestamp(0) |
| Integer | number(10,0) | int | int |
| Long | number(19,0) | bigint | bigserial |
| Short | number(5,0) | smallint | smallint |
| String | varchar2 | varchar, text | varchar, text |