Relationships - One-to-One

Relationships: One-to-One

A relationship from one table/view to another can be created by defining a link between a column of the table/view to a column of the other table/view.

A one-to-one relationship between two tables can be established via a unique foreign key constraint and tracked using Hasura.

In this example, we'll be creating tables for owner and passport

These two tables are related via a one-to-one relationship. i.e.:

  • an owner can have one passport_info
  • a passport_info has one owner

ERD Diagram


  • This schema is installable through your Hasura Console
  • The schema sharing source code is available: https://github.com/hasura/schema-sharing/tree/main/postgres/relationships-one-to-one
  • The schema sharing source code was derived from the following tutorial: https://hasura.io/docs/latest/graphql/core/guides/data-modelling/one-to-one.html
Released: June 16, 2021
Developed by: Hasura
Category: Core Concepts

We’d love to connect with you at one of our many global events.

Event
HasuraCon 2021HasuraCon 2021Community call
Ready to get started?
Start for free on Hasura Cloud or you could contact our sales team for a detailed walk-through on how Hasura may benefit your business.
Get monthly product updates
Sign up for full access to our product and community highlights, new features, and occasional baby animal gifs! Oh, and we have a strict no-spam rule. ✌️