> ## Documentation Index
> Fetch the complete documentation index at: https://doc.eazemyapi.com/llms.txt
> Use this file to discover all available pages before exploring further.

# 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:

```json theme={null}
{
  "name": "Dara Singh"
}
```

***

## NUMBER

The **NUMBER** type stores integer numbers.

Common uses:

* age
* quantity
* counts
* IDs

Example:

```
age: 38
```

Example API response:

```json theme={null}
{
  "age": 38
}
```

***

## PARAGRAPH

The **PARAGRAPH** type stores long text content.

Common uses:

* descriptions
* blog content
* notes
* comments

Example:

```json theme={null}
{
  "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:

```json theme={null}
{
  "rating": 4.8
}
```

***

## DATE

The **DATE** type stores a calendar date.

Common uses:

* birth date
* event date
* joining date

Example:

```json theme={null}
{
  "birth_date": "1988-05-12"
}
```

***

## DATETIME

The **DATETIME** type stores both date and time.

Common uses:

* created\_at
* updated\_at
* event timestamps

Example:

```json theme={null}
{
  "created_at": "2026-03-10T10:30:00Z"
}
```

***

## PASSWORD

The **PASSWORD** type stores secure password values.

Passwords are encrypted before being stored.

Example:

```json theme={null}
{
  "password": "********"
}
```

***

## EMAIL

The **EMAIL** type stores valid email addresses.

Common uses:

* user login
* account registration
* contact information

Example:

```json theme={null}
{
  "email": "dara@example.com"
}
```

***

## PHONE

The **PHONE** type stores phone numbers.

Example:

```json theme={null}
{
  "phone": "+91 9898989898"
}
```

***

## BOOLEAN

The **BOOLEAN** type stores true or false values.

Common uses:

* active status
* verification status
* feature flags

Example:

```json theme={null}
{
  "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

```json theme={null}
{
  "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

```bash theme={null}
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](/docs/database-schema)