Sigmah wiki

Remarks

A Textarea_Element corresponds to a textual field that can take either a number, a little or large string or a date (formatted by a string).

Name	Type	Not Null	Primary Key	Foreign Key	Remarks
:———	:———	:————-	:—————-	:—————-	:————
id_flexible_element	bigint	X	X	flexible\_element(id_flexible_element)	This is the primary key of the table and also a foreign key on the table flexible_element which is its parent table.
is_decimal	bool				It shows if the element is a decimal element (otherwise it means that it’s a textual element).
length	integer				This field represents the size of the string (if the element contains a string).
max_value	bigint				It represents the upper limit of the decimal value (if the element contains a decimal value)
min_value	bigint				It represents the lower limit of the decimal value (if the element contains a decimal value)
type	bpchar				It represents the type of data of the element (T for Text (or for little text), P for Paragraph (or large text), D for Date and N for Number.