Field Types

Field Types in MySQL

• Text
  A text field can hold any string, such as names, addresses, or descriptions.

Hello
Rebaz

• Integer
  An integer field stores whole numbers, such as 3, 42, or 100.

1
100
1000

• Table Reference
  This field type links to a record in another table. It's useful for maintaining relationships between tables.

• Enum
  An enum allows you to store a specific set of values, like a multiple-choice field.

Red
Blue
Green
Orange

• Timestamp
  Timestamps in MySQL store the number of seconds since the Unix epoch, useful for time-based data.

1733762528000

• Date
  A simple date field, typically used for storing birth dates or other date-based values.

• Boolean
  A boolean field stores TRUE or FALSE values.

• Decimal
  This type stores numbers with decimal points, ideal for representing money or measurements.

• Email
  An email field stores email addresses, ensuring proper formatting.

• Password
  A password field stores encrypted passwords for security.

• JSON
  JSON fields allow you to store structured, hierarchical data like arrays or objects.

{
  "name": "Classic Chocolate Chip Cookies",
  "prepTime": 15,
  "ingredients": [
    {"item": "flour", "amount": 2.25, "unit": "cups"},
    {"item": "chocolate chips", "amount": 2, "unit": "cups"}
  ]
}

• Geography
  For geographical data, MySQL supports spatial data types like points, paths, and polygons.

{
  "type": "point",
  "data": {
    "lat": 39.391205,
    "lng": 128.233455
  }
}

TODO:

• Document all types