form table

form Table (488)

A form which can be published on a webpage and submitted by visitors

Name	Description	Type	Nullable
form_id	Primary key	PK	No
name	The name of this form	String(4000)	Yes
description	Detailed description	String(4000)	Yes
config	The JSON-formatted config of this form	Clob	Yes
folder_id	The folder which this form belongs to. -1 indicates that the shipment is on the root	FK s_picture_folder	No
script_id	The CRMScript Macro which will be run when the form is submitted.	FK ejscript	No
response_shipment_id	The id of the s_shipment that is used to send the response mails	FK s_shipment	No
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
active	Indicates if this form is active and available for customers	Bool	Yes
expires	After this datetime, the form will become inactive	DateTime	Yes
maxSubmits	After this number of submits, the form will become inactive	Int	Yes
type	What kind of form is this? Indicates if this is a normal form or a template	Enum FormType	No
recipe	The JSON-formatted recipe of this form	Clob	Yes
group_id	The group which this form belongs to.	FK UserGroup	No
form_key	A short string used as unique id to access this form	String(32)	Yes
new_ticket	True if this form creates a new ticket	Bool	Yes

Table	Description
associate	Employees, resources and other users - except for External persons
ejscript	ejscript
email_flow_content_link	Links content to an email workflow
form_submission	A form submission
person	Persons
s_link	Links in messages to measure success rate of a campaign.
s_picture_folder	This table contains all picture folders
s_shipment	Contains info about one shipment. The addresses are stored in s_shipment_addr
UserGroup	Secondary user groups