Table of Contents

=Table textarea_element=

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).

Schema

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.

Diagram