{
    "success": true,
    "data": {
        "name": "TMS REST API",
        "database": "tms",
        "list_query": {
            "limit": "1-200, default 50",
            "offset": "default 0",
            "filters": "exact match on the primary key or any field that is not write-only. Lists omit Deleted = 1 unless Deleted is set or include_deleted=1"
        },
        "nested": [
            "GET /deliveries/{id}/details",
            "GET /deliveries/{id}/tracking"
        ],
        "endpoints": [
            {
                "resource": "couriers",
                "table": "courier",
                "primary_key": "cou_id",
                "routes": [
                    "GET /couriers",
                    "GET /couriers/{id}",
                    "POST /couriers",
                    "PUT /couriers/{id}",
                    "PATCH /couriers/{id}",
                    "DELETE /couriers/{id}"
                ],
                "fields": [
                    {
                        "name": "Courier_Name",
                        "type": "string",
                        "required": true,
                        "max": 200
                    },
                    {
                        "name": "Input_By",
                        "type": "int",
                        "required": false,
                        "max": null
                    },
                    {
                        "name": "Input_Datetime",
                        "type": "datetime",
                        "required": false,
                        "max": null,
                        "nullable": true
                    },
                    {
                        "name": "Update_By",
                        "type": "int",
                        "required": false,
                        "max": null
                    },
                    {
                        "name": "Update_Datetime",
                        "type": "datetime",
                        "required": false,
                        "max": null,
                        "nullable": true
                    },
                    {
                        "name": "Deleted_By",
                        "type": "int",
                        "required": false,
                        "max": null
                    },
                    {
                        "name": "Deleted_Datetime",
                        "type": "datetime",
                        "required": false,
                        "max": null,
                        "nullable": true
                    },
                    {
                        "name": "Deleted",
                        "type": "int",
                        "required": false,
                        "max": null
                    }
                ]
            },
            {
                "resource": "vehicles",
                "table": "vehicle",
                "primary_key": "v_id",
                "routes": [
                    "GET /vehicles",
                    "GET /vehicles/{id}",
                    "POST /vehicles",
                    "PUT /vehicles/{id}",
                    "PATCH /vehicles/{id}",
                    "DELETE /vehicles/{id}"
                ],
                "fields": [
                    {
                        "name": "Registration",
                        "type": "string",
                        "required": true,
                        "max": 10
                    },
                    {
                        "name": "Input_By",
                        "type": "int",
                        "required": false,
                        "max": null
                    },
                    {
                        "name": "Input_Datetime",
                        "type": "datetime",
                        "required": false,
                        "max": null,
                        "nullable": true
                    },
                    {
                        "name": "Update_By",
                        "type": "int",
                        "required": false,
                        "max": null
                    },
                    {
                        "name": "Update_Datetime",
                        "type": "datetime",
                        "required": false,
                        "max": null,
                        "nullable": true
                    },
                    {
                        "name": "Deleted_By",
                        "type": "int",
                        "required": false,
                        "max": null
                    },
                    {
                        "name": "Deleted_Datetime",
                        "type": "datetime",
                        "required": false,
                        "max": null,
                        "nullable": true
                    },
                    {
                        "name": "Deleted",
                        "type": "int",
                        "required": false,
                        "max": null
                    }
                ]
            },
            {
                "resource": "locations",
                "table": "location",
                "primary_key": "loc_id",
                "routes": [
                    "GET /locations",
                    "GET /locations/{id}",
                    "POST /locations",
                    "PUT /locations/{id}",
                    "PATCH /locations/{id}",
                    "DELETE /locations/{id}"
                ],
                "fields": [
                    {
                        "name": "Location",
                        "type": "string",
                        "required": true,
                        "max": null
                    },
                    {
                        "name": "Input_By",
                        "type": "int",
                        "required": false,
                        "max": null
                    },
                    {
                        "name": "Input_Datetime",
                        "type": "datetime",
                        "required": false,
                        "max": null,
                        "nullable": true
                    },
                    {
                        "name": "Update_By",
                        "type": "int",
                        "required": false,
                        "max": null
                    },
                    {
                        "name": "Update_Datetime",
                        "type": "datetime",
                        "required": false,
                        "max": null,
                        "nullable": true
                    },
                    {
                        "name": "Deleted_By",
                        "type": "int",
                        "required": false,
                        "max": null
                    },
                    {
                        "name": "Deleted_Datetime",
                        "type": "datetime",
                        "required": false,
                        "max": null,
                        "nullable": true
                    },
                    {
                        "name": "Deleted",
                        "type": "int",
                        "required": false,
                        "max": null
                    }
                ]
            },
            {
                "resource": "deliveries",
                "table": "delivery_header",
                "primary_key": "dh_id",
                "routes": [
                    "GET /deliveries",
                    "GET /deliveries/{id}",
                    "POST /deliveries",
                    "PUT /deliveries/{id}",
                    "PATCH /deliveries/{id}",
                    "DELETE /deliveries/{id}"
                ],
                "fields": [
                    {
                        "name": "Delivery_ID",
                        "type": "string",
                        "required": true,
                        "max": 20
                    },
                    {
                        "name": "Tracking_ID",
                        "type": "string",
                        "required": true,
                        "max": 20
                    },
                    {
                        "name": "Vehicle_Number",
                        "type": "string",
                        "required": false,
                        "max": 10
                    },
                    {
                        "name": "Courier_ID",
                        "type": "string",
                        "required": false,
                        "max": 10
                    },
                    {
                        "name": "Customer_ID",
                        "type": "string",
                        "required": true,
                        "max": 20
                    },
                    {
                        "name": "SHIP_ADDRESS",
                        "type": "string",
                        "required": true,
                        "max": null
                    },
                    {
                        "name": "Postal_CD",
                        "type": "string",
                        "required": true,
                        "max": 6
                    },
                    {
                        "name": "Region",
                        "type": "string",
                        "required": true,
                        "max": 50
                    },
                    {
                        "name": "Total_Qty",
                        "type": "decimal",
                        "required": true,
                        "max": null
                    },
                    {
                        "name": "Total_Weight",
                        "type": "decimal",
                        "required": true,
                        "max": null
                    },
                    {
                        "name": "Total_Dimension",
                        "type": "decimal",
                        "required": true,
                        "max": null
                    },
                    {
                        "name": "ETA",
                        "type": "datetime",
                        "required": false,
                        "max": null,
                        "nullable": true
                    },
                    {
                        "name": "Pickup_Schedule",
                        "type": "datetime",
                        "required": true,
                        "max": null
                    },
                    {
                        "name": "Created_By",
                        "type": "string",
                        "required": true,
                        "max": 20
                    },
                    {
                        "name": "Last_Update_Date",
                        "type": "datetime",
                        "required": true,
                        "max": null
                    },
                    {
                        "name": "Last_Update_By",
                        "type": "string",
                        "required": true,
                        "max": 20
                    },
                    {
                        "name": "Delivery_Status",
                        "type": "string",
                        "required": true,
                        "max": 2
                    },
                    {
                        "name": "POD",
                        "type": "string",
                        "required": true,
                        "max": 50
                    },
                    {
                        "name": "Deleted_By",
                        "type": "int",
                        "required": false,
                        "max": null
                    },
                    {
                        "name": "Deleted_Datetime",
                        "type": "datetime",
                        "required": false,
                        "max": null,
                        "nullable": true
                    },
                    {
                        "name": "Deleted",
                        "type": "int",
                        "required": false,
                        "max": null
                    },
                    {
                        "name": "Create_Date",
                        "type": "datetime",
                        "required": false,
                        "readonly": true
                    }
                ]
            },
            {
                "resource": "delivery-details",
                "table": "delivery_detail",
                "primary_key": "dd_id",
                "routes": [
                    "GET /delivery-details",
                    "GET /delivery-details/{id}",
                    "POST /delivery-details",
                    "PUT /delivery-details/{id}",
                    "PATCH /delivery-details/{id}",
                    "DELETE /delivery-details/{id}"
                ],
                "fields": [
                    {
                        "name": "dh_id",
                        "type": "int",
                        "required": true,
                        "max": null
                    },
                    {
                        "name": "Item_ID",
                        "type": "string",
                        "required": true,
                        "max": 30
                    },
                    {
                        "name": "Item_Description",
                        "type": "string",
                        "required": true,
                        "max": null
                    },
                    {
                        "name": "Qty",
                        "type": "decimal",
                        "required": true,
                        "max": null
                    },
                    {
                        "name": "Weight",
                        "type": "decimal",
                        "required": true,
                        "max": null
                    },
                    {
                        "name": "Length",
                        "type": "decimal",
                        "required": true,
                        "max": null
                    },
                    {
                        "name": "Height",
                        "type": "decimal",
                        "required": true,
                        "max": null
                    },
                    {
                        "name": "Width",
                        "type": "decimal",
                        "required": true,
                        "max": null
                    },
                    {
                        "name": "Fragile",
                        "type": "string",
                        "required": true,
                        "max": 1
                    },
                    {
                        "name": "Flamable",
                        "type": "string",
                        "required": true,
                        "max": 1
                    }
                ]
            },
            {
                "resource": "tracking",
                "table": "tracking",
                "primary_key": "t_id",
                "routes": [
                    "GET /tracking",
                    "GET /tracking/{id}",
                    "POST /tracking",
                    "PUT /tracking/{id}",
                    "PATCH /tracking/{id}",
                    "DELETE /tracking/{id}"
                ],
                "fields": [
                    {
                        "name": "dh_id",
                        "type": "int",
                        "required": true,
                        "max": null
                    },
                    {
                        "name": "Track_type",
                        "type": "string",
                        "required": true,
                        "max": 15
                    },
                    {
                        "name": "loc_id",
                        "type": "int",
                        "required": true,
                        "max": null
                    },
                    {
                        "name": "Location",
                        "type": "string",
                        "required": true,
                        "max": 200
                    },
                    {
                        "name": "Create_By",
                        "type": "string",
                        "required": true,
                        "max": 20
                    },
                    {
                        "name": "Deleted_By",
                        "type": "int",
                        "required": false,
                        "max": null
                    },
                    {
                        "name": "Deleted_Datetime",
                        "type": "datetime",
                        "required": false,
                        "max": null,
                        "nullable": true
                    },
                    {
                        "name": "Deleted",
                        "type": "int",
                        "required": false,
                        "max": null
                    },
                    {
                        "name": "Create_Date",
                        "type": "datetime",
                        "required": false,
                        "readonly": true
                    }
                ]
            },
            {
                "resource": "customers",
                "table": "customer",
                "primary_key": "c_id",
                "routes": [
                    "GET /customers",
                    "GET /customers/{id}",
                    "POST /customers",
                    "PUT /customers/{id}",
                    "PATCH /customers/{id}",
                    "DELETE /customers/{id}"
                ],
                "fields": [
                    {
                        "name": "c_name",
                        "type": "string",
                        "required": true,
                        "max": 50
                    },
                    {
                        "name": "c_address",
                        "type": "string",
                        "required": true,
                        "max": null
                    },
                    {
                        "name": "c_telephone1",
                        "type": "string",
                        "required": true,
                        "max": 50
                    },
                    {
                        "name": "c_telephone2",
                        "type": "string",
                        "required": false,
                        "max": 50
                    },
                    {
                        "name": "c_email",
                        "type": "string",
                        "required": true,
                        "max": 50
                    },
                    {
                        "name": "c_postalcode",
                        "type": "string",
                        "required": true,
                        "max": 10
                    },
                    {
                        "name": "c_city",
                        "type": "string",
                        "required": true,
                        "max": 20
                    },
                    {
                        "name": "c_country",
                        "type": "string",
                        "required": true,
                        "max": 20
                    },
                    {
                        "name": "c_pic",
                        "type": "string",
                        "required": true,
                        "max": 20
                    },
                    {
                        "name": "c_deleted",
                        "type": "int",
                        "required": false,
                        "max": null
                    }
                ]
            },
            {
                "resource": "users",
                "table": "user",
                "primary_key": "uid",
                "routes": [
                    "GET /users",
                    "GET /users/{id}",
                    "POST /users",
                    "PUT /users/{id}",
                    "PATCH /users/{id}",
                    "DELETE /users/{id}"
                ],
                "fields": [
                    {
                        "name": "Name",
                        "type": "string",
                        "required": true,
                        "max": 50
                    },
                    {
                        "name": "Role",
                        "type": "string",
                        "required": true,
                        "max": 5
                    },
                    {
                        "name": "Password",
                        "type": "string",
                        "required": true,
                        "max": 100,
                        "writeOnly": true
                    },
                    {
                        "name": "Input_By",
                        "type": "int",
                        "required": false,
                        "max": null
                    },
                    {
                        "name": "Input_Datetime",
                        "type": "datetime",
                        "required": false,
                        "max": null,
                        "nullable": true
                    },
                    {
                        "name": "Update_By",
                        "type": "int",
                        "required": false,
                        "max": null
                    },
                    {
                        "name": "Update_Datetime",
                        "type": "datetime",
                        "required": false,
                        "max": null,
                        "nullable": true
                    },
                    {
                        "name": "Deleted_By",
                        "type": "int",
                        "required": false,
                        "max": null
                    },
                    {
                        "name": "Deleted_Datetime",
                        "type": "datetime",
                        "required": false,
                        "max": null,
                        "nullable": true
                    },
                    {
                        "name": "Deleted",
                        "type": "int",
                        "required": false,
                        "max": null
                    }
                ]
            }
        ]
    }
}