db_info_field

A single custom field defined within a chapter (e.g. a textarea or datetime input), whose entered values are stored in .

Name	Description	Type	Additional information
id	Primary key	globally unique identifier
db_info_id	Foreign key of the chapter this field belongs to.	globally unique identifier
db_input_type_id	Foreign key of the constant defining this field's input type (e.g. textarea, datetime), controlling how it is rendered and validated.	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	Indicates a value must be filled in for this field before the form can be saved.	boolean
reference_db_info_field_id	Foreign key of another info field this field references (e.g. for computed/derived fields).	globally unique identifier
visible_on_app	Indicates whether this field is shown to technicians in the mobile app.	boolean
udf_name	When set, the name of the udf_ column (on the parent entity) this field's value is stored in, instead of a row in .	string	Max length: 20
archived	Indicates whether this field has been archived (no longer shown).	boolean
modified_dateutc	Readonly system field managed by database, filled with GetUtcDate when adding,updating	date

Odyssee Mobile