optReference
Creates a column with the specified name with an optional reference to the refColumn column with onDelete, onUpdate, and fkName options. onDelete and onUpdate options describe the behavior for how links between tables will be checked when deleting or changing corresponding columns' values. Such a relationship will be represented as a FOREIGN KEY constraint on table creation.
Parameters
Name of the column.
A column from another table which will be used as a "parent".
Optional ReferenceOption for cases when a linked row from a parent table will be deleted.
Optional ReferenceOption for cases when a value in a referenced column will be changed.
Optional foreign key constraint name.
Samples
org.jetbrains.exposed.sql.tests.shared.entities.EntityTests.PostsCreates a column with the specified name with an optional reference to the refColumn column with onDelete, onUpdate, and fkName options. onDelete and onUpdate options describe the behavior for how links between tables will be checked when deleting or changing corresponding columns' values. Such a relationship will be represented as a FOREIGN KEY constraint on table creation.
Parameters
Name of the column.
A column from another table which will be used as a "parent".
Optional ReferenceOption for cases when a linked row from a parent table will be deleted.
Optional ReferenceOption for cases when a value in a referenced column will be changed.
Samples
org.jetbrains.exposed.sql.tests.shared.entities.EntityTests.PostsCreates a column with the specified name with an optional reference to the id
column in foreign table with onDelete, onUpdate, and fkName options. onDelete and onUpdate options describe the behavior for how links between tables will be checked when deleting or changing corresponding columns' values. Such a relationship will be represented as a FOREIGN KEY constraint on table creation.
Parameters
Name of the column.
A table with an id
column which will be used as a "parent".
Optional ReferenceOption for cases when a linked row from a parent table will be deleted.
Optional ReferenceOption for cases when a value in a referenced column will be changed.
Optional foreign key constraint name.