Managing primary keys in a table
SchemaHero can manage simple or composite primary keys. To create a primary key:
apiVersion: schemas.schemahero.io/v1alpha4 kind: Table metadata: name: flights spec: database: my-database name: flights schema: postgres: primaryKey: [origin, destination] columns: - name: origin type: char(4) - name: destination type: char(4) - name: duration type: integer
In the above example, we are creating a table named "flights". This table has a composite primary key that includes the origin and the destination columns.