beam-automigrate icon indicating copy to clipboard operation
beam-automigrate copied to clipboard

Foreign key constraints with nullable references

Open TravisCardwell opened this issue 2 years ago • 0 comments

The current API does not provide a way to annotate a table with a foreign key constraint when the column is nullable. This type of constraint is very common, as it used for optional one-to-one relations (often marked as ? or 0|1 in database software).

I implemented new functions nullableForeignKeyOnPk and nullableForeignKeyOn to support this, and I will submit a pull request.


tc-develop Documentation

TravisCardwell avatar May 27 '22 04:05 TravisCardwell