Form Field

Represent data field in table of relation data base as form base. By reduce field type left only main type of table field. Make more easier to decide field type and Data modeling to save time in development.

• TEXT

  Declaration field to store value as string.
  in database will use field type Varchar(255) it mean for use please check requirement.

  • Not need more than 255 char.
  • You need to indexing this field.

  ---

• Long TEXT

  Declaration field to store value as string for any long text.
  in database will use field type MediumText.

  ---

• Number

  Declaration field to store value as number value will store as Integer.
  ! it will not store decimal.

  ---

• Float

  Declaration field to store value as number value will store as Float in database and save decimal by default.

  ---

• Boolean

  Declaration field to store value to boolean. in MariaDB database will save as 0,1

  ---

• DATE

  This data type represents a date range of “1000-01-01” to “9999-12-31,” and uses the “YYYY-MM-DD” date format.

  ---

• TIME

  This data type represents a time range of “-838:59:59.999999” to “838:59:59.999999.”

  ---

• DATETIME

  This data type represents the range “1000-01-01 00:00:00.000000” to “9999-12-31 23:59:59.999999.” It uses the “YYYY-MM-DD HH:MM:SS” format.

  ---