|
This entity is the record for the usage items. |
|
Name |
Code |
Class Name |
|
Reference |
|
Name |
Code |
|
Name |
|
|
Code |
|
|
Data Type |
integer |
|
Mandatory |
Yes |
|
A system generated identity. It is blind to the user. It also acts as a primary key for the UsageItemRecord table. |
|
Name |
|
|
Code |
|
|
Data Type |
char(50) |
|
Mandatory |
Yes |
|
The first reference key for the usage item. |
|
Name |
|
|
Code |
|
|
Data Type |
char(50) |
|
Mandatory |
Yes |
|
The second reference key for the usage item. |
|
Name |
|
|
Code |
|
|
Data Type |
char(50) |
|
Mandatory |
Yes |
|
The third reference key for the usage item. |
|
Name |
|
|
Code |
|
|
Data Type |
integer |
|
Mandatory |
No |
|
An integer value, i.e. a whole number. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
A double value, which may come in a form of a checkbox. The customer can create a questionnaire and have the option to either check or uncheck the box. |
|
Name |
|
|
Code |
|
|
Data Type |
char(100) |
|
Mandatory |
No |
|
A string value where it is a data type which includes letters, digits and special characters. It is a sequence of characters. |
|
Name |
|
|
Code |
|
|
Data Type |
date |
|
Mandatory |
No |
|
A date value, usually in the format: DD-MM-YYYY. |
|
Name |
|
|
Code |
|
|
Data Type |
timestamp |
|
Mandatory |
No |
|
To modify the date and time. |
|
|
|