kysely.CreateTableBuilder | /deps.ts | kysely_postgrs_js_dialect@v0.27.3

method kysely.CreateTableBuilder.prototype.addForeignKeyConstraint

import { kysely } from "https://dotland.deno.dev/x/kysely_postgrs_js_dialect@v0.27.3/deps.ts";
const { CreateTableBuilder } = kysely;

addForeignKeyConstraint(

constraintName: string,

columns: C[],

targetTable: string,

targetColumns: string[],

Adds a foreign key constraint.

The constraint name can be anything you want, but it must be unique across the whole database.

addForeignKeyConstraint(
  'owner_id_foreign',
  ['owner_id'],
  'person',
  ['id'],
)

Add constraint for multiple columns:

addForeignKeyConstraint(
  'owner_id_foreign',
  ['owner_id1', 'owner_id2'],
  'person',
  ['id1', 'id2'],
  (cb) => cb.onDelete('cascade')
)

Parameters

constraintName: string

columns: C[]

targetTable: string

targetColumns: string[]

optional