Field types
Some tooltip text!
• 1 minute to read
• 1 minute to read
The following is a list of all valid field types:
| Type | Description |
|---|---|
| TypeInteger | A natural number |
| TypeClob | A large text |
| TypeDate | A date in this format: yyyy-mm-dd |
| TypeDateTime | A datetime in this format: yyyy-mm-dd hh-mm-ss.xxx |
| TypeTime | A time in this format: hh-mm-ss.xxx |
| TypeBool | A boolean value |
| TypeVarchar | A string |
| TypeForeignKey | Always an integer, but indicating that the value is represented somewhere else |
| TypeFloat | A floating point value |
| TypeCustomerId | The ID of a customer |
| TypeCompanyId | The ID of a company |
| TypeRequestId | The ID of a request (ticket) |
| TypeUserId | The ID of a user |