Skip to main content
Version: v2.x

Quickstart Schema

This quickstart will help you work with the GraphQL Schema. We'll create a table called coupons and add some sample data to it. Then, we'll query for the data using the Hasura Console GUI and the API Explorer.

DOCS E-COMMERCE SAMPLE APP

You can use this quickstart with any project, but it pairs well with our docs e-commerce sample app, which you can deploy to Hasura Cloud with one click below. If you've already deployed the sample app, access your existing project.

Deploy to Hasura Cloud

Step 1: Navigate to the Data tab​

Once here, click the Create Table button at the top of the page:

Schema create table

Step 2: Enter the details​

On this page, we'll begin by naming the table: in the Table Name field, enter coupons. From there, we'll add all the necessary columns:

In the Columns section, we'll start with the Column Name field, enter id, with a data type of integer (auto-increment) and check the box for unique. Leave nullable unchecked as this is a required column and can't be null.

Then, we'll repeat the steps for the following columns:

  • amount (data type: integer)
  • code (data type: text)
  • description (data type: text)
  • start_date (data type: timestamp), defaulting to now()
  • end_date (data type: timestamp)
Schema create table

Step 3: Add a primary key​

In the Primary Key section, open the dropdown and select id from the list of columns. Then click, Add table.

Step 4: Test it out​

We should have received confirmation that our table was created successfully. Now, let's test it out by adding a new coupon on the Insert Row tab:

Schema create table

We can leave the id field blank, since it's auto-incrementing. Then, we'll add the following values:

  • amount: 50
  • code: HALFOFF
  • description: 50% off your next purchase
  • start_date: check the Default radio button
  • end_date: 2026-10-19 00:00:00

Upon clicking Save, we should receive confirmation of our new coupon. We can check its details by clicking the Browse Rows tab or by running a query in our API Explorer.

Recap​

What just happened? Well, you just modified your GraphQL API's schema! You can now query for coupons using the coupons table. You can also add new coupons using the insert_coupons mutation.

You can continue to customize this table and create relationships between it and other tables, such as products or orders to create a coupon system for your e-commerce store.

Loading...