Select the Entity then press enter -it’ll bring out the “Entity Specification” window.
Within the “Entity Specification” window, select the “Columns” tab, then add the data type you want.
Use the “bit” data type for boolean values. For the datetime data type, since that data type is missing in Visual Paradigm, you could temporarily use the timestamp data type then convert it to datetime when you’re going to generate the sql. Make a note of it so you don’t forget!
A little caution regarding the difference between datetime and timestamp
Although both the timestamp and datetime data types store the values with the same formatting: “YYYY-MM-DD HH:MM:SS”, they both differ on the data range, the data size and the way the DBMSes retrieve and store those data types. Usually DBMSes will convert the timestamp data to the clients timezone before sending it to the client, whereas regarding the datetime data type, they don’t (ex:MySQL). Oracle handles this differently, they have 3 timestamp types, so it varies. Becareful and don’t forget