Create todos table

Now let's move on to creating the other model: todos

The todos table will have the following columns:

  • id (type integer;auto-increment),
  • title (type text),
  • is_completed (type boolean and default false)
  • is_public (type boolean and default false)
  • created_at (type timestamp and default now())
  • user_id (type text)

The columns are associated with properties of todo items.

Remember to set the id column to the primary key.

In the Hasura Console, head over to the DATA tab section and click on Create Table. Enter the values for creating the table as mentioned above.

Create table users

Once you are done, click on Add Table button to create the table.


Get Started with GraphQL Now

Hasura Cloud gives you a fully managed, production ready GraphQL API as a service to help you build modern apps faster.