form_field_value table

form_field_value Table (538)

Form field values saved in a searchable format

Name	Description	Type	Nullable
form_field_value_id	Primary key	PK	No
form_submission_id	The form submission this set of values belong to	FK form_submission	Yes
rank	The rank of this form field within the form	Int	Yes
label	The label of this form field	String(4000)	Yes
type	The type of this form field	String(4000)	Yes
sequence	The sequence of this form field	Int	Yes
string_value	The string value of this form field	String(4000)	Yes
int_value	The integer value of this form field	Int	Yes
double_value	The double value of this form field	Double	Yes
bool_value	The boolean value of this form field	Bool	Yes
datetime_value	The datetime value of this form field	DateTime	Yes
registered	Registered when	UtcDateTime	No
registered_associate_id	Registered by whom	FK associate	No
updated	Last updated when	UtcDateTime	No
updated_associate_id	Last updated by whom	FK associate	No
updatedCount	Number of updates made to this record	UShort	No

Table	Description
associate	Employees, resources and other users - except for External persons
form_submission	A form submission