/

Foreign Keys

Managing foreign keys for a table


To define a foreign key on a table, use the foreignKeys field, as in this example:

apiVersion: schemas.schemahero.io/v1alpha4
kind: Table
metadata:
  name: users
spec:
  database: testdb
  name: projects
  schema:
    postgres:
      primaryKey: [id]
      foreignKeys:
        - columns:
            - id
          references:
            table: users
            columns:
              - id
      columns:
        - name: id
          type: integer
        - name: user_id
          type: integer

A well-formed foreignKeys field is an array of foreignKey objects:

columns: An array of the column names that are part of this table that have the foreign key contraint applied (the child columns).

references.table: The name of the parent table

references.columns: An array of the column names that exist in the parent table that are referenced.

Edit on GitHub