Field types

When creating tables in EazeMyAPI, each field must have a data type. The data type defines what kind of data the field can store. Choosing the correct field type ensures:

Better data validation
Efficient database queries
Accurate API responses

Supported Field Types

EazeMyAPI supports the following field types.

TEXT

The TEXT type stores short text values. Common uses:

names
titles
usernames
city names

Example:

name: "Dara Singh"

Example API response:

{
  "name": "Dara Singh"
}

NUMBER

The NUMBER type stores integer numbers. Common uses:

age
quantity
counts
IDs

Example:

age: 38

Example API response:

{
  "age": 38
}

PARAGRAPH

The PARAGRAPH type stores long text content. Common uses:

descriptions
blog content
notes
comments

Example:

{
  "bio": "Dara Singh is a sample user created for demonstration purposes."
}

DECIMAL

The DECIMAL type stores numbers with decimal values. Common uses:

prices
ratings
percentages
measurements

Example:

{
  "rating": 4.8
}

DATE

The DATE type stores a calendar date. Common uses:

birth date
event date
joining date

Example:

{
  "birth_date": "1988-05-12"
}

DATETIME

The DATETIME type stores both date and time. Common uses:

created_at
updated_at
event timestamps

Example:

{
  "created_at": "2026-03-10T10:30:00Z"
}

PASSWORD

The PASSWORD type stores secure password values. Passwords are encrypted before being stored. Example:

{
  "password": "********"
}

EMAIL

The EMAIL type stores valid email addresses. Common uses:

user login
account registration
contact information

Example:

{
  "email": "dara@example.com"
}

PHONE

The PHONE type stores phone numbers. Example:

{
  "phone": "+91 9898989898"
}

BOOLEAN

The BOOLEAN type stores true or false values. Common uses:

active status
verification status
feature flags

Example:

{
  "is_active": true
}

Example Table

Example users table:

Field	Type
id	NUMBER
name	TEXT
email	EMAIL
phone	PHONE
bio	PARAGRAPH
is_active	BOOLEAN
created_at	DATETIME

Example Record

{
  "id": 1,
  "name": "Dara Singh",
  "email": "dara@example.com",
  "phone": "+91 9898989898",
  "bio": "Sample user for API demonstration",
  "is_active": true
}

Example API Request

After creating a table, EazeMyAPI automatically generates APIs.

Example Endpoint

https://api.eazemyapi.com/demo-project/users/v1/list

Example Request

curl https://api.eazemyapi.com/demo-project/users/v1/list \
  -H "X-API-SIGNATURE: your-secret-key"

Best Practices

When choosing field types:

Use TEXT for short text
Use PARAGRAPH for long content
Use NUMBER for integers
Use DECIMAL for prices or ratings
Use BOOLEAN for true/false values
Use DATETIME for timestamps

Correct field types make your APIs faster and easier to use.

Next Step

Learn how database schema works in EazeMyAPI. Database Schema

Introduction

Getting Started

Core Concepts

API

Guides

Supported Field Types

TEXT

NUMBER

PARAGRAPH

DECIMAL

DATE

DATETIME

PASSWORD

EMAIL

PHONE

BOOLEAN

Example Table

Example Record

Example API Request

Example Endpoint

Example Request

Best Practices

Next Step

​Supported Field Types

​TEXT

​NUMBER

​PARAGRAPH

​DECIMAL

​DATE

​DATETIME

​PASSWORD

​EMAIL

​PHONE

​BOOLEAN

​Example Table

​Example Record

​Example API Request

​Example Endpoint

​Example Request

​Best Practices

​Next Step

Supported Field Types

TEXT

NUMBER

PARAGRAPH

DECIMAL

DATE

DATETIME

PASSWORD

EMAIL

PHONE

BOOLEAN

Example Table

Example Record

Example API Request

Example Endpoint

Example Request

Best Practices

Next Step