Common Examples
- Users
- Products
- Orders
- Messages
How to Create a Table
Follow these steps to create a new table:- Open your Project Dashboard
- Click Create Table
- Enter a Table Name
- Add required Fields (Columns)
- Click Save
Example: Users Table
Below is a simple example of a Users table structure:| Field | Type | Description |
|---|---|---|
| id | Primary Key | Unique identifier |
| name | Text | User name |
| Text | User email | |
| password | Text | Encrypted password |
| created_at | Datetime | Record creation time |
What Happens After Creating a Table?
Once your table is saved, EazeMyAPI automatically:- Generates CRUD APIs
- Connects APIs to your database
- Enables authentication for requests
- Prepares your backend instantly
Best Practices
Follow these guidelines for better backend design:- Use clear and meaningful table names (e.g.,
users,orders) - Keep field names simple and consistent
- Avoid unnecessary or duplicate columns
- Use proper data types for each field
- Plan relationships between tables early (e.g., user_id in orders)

