import { kysely } from "https://dotland.deno.dev/x/kysely_postgrs_js_dialect@v0.27.4/deps.ts";
const { CreateTableBuilder } = kysely;
Adds a foreign key constraint.
The constraint name can be anything you want, but it must be unique across the whole database.
Examples
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
optional
build: ForeignKeyConstraintBuilderCallbackReturns
CreateTableBuilder<TB, C>