| Name | Description | Type | Additional information |
|---|---|---|---|
| id |
Primary key |
globally unique identifier | |
| db_info_id |
db_info_id |
globally unique identifier | |
| db_input_type_id |
Constant that refer to the kind of info field (like textarea, datetime) |
globally unique identifier | |
| sequence |
Order field, need to order by sequence asc |
integer | |
| title |
The label of the field |
string |
Max length: 100 |
| default_value |
Contains the value that should be used when no value exists |
string |
Max length: 255 |
| is_readonly |
Avoid user to edit the value using the UI |
boolean | |
| is_mandatory |
is_mandatory |
boolean | |
| reference_db_info_field_id | globally unique identifier | ||
| visible_on_app |
visible_on_app |
boolean | |
| udf_name |
To know the POI is stored on udf_ columns or on the dbinfodata table |
string |
Max length: 20 |
| archived | boolean | ||
| modified_dateutc |
Readonly system field managed by database, filled with GetUtcDate when adding,updating |
date |