Is there any way I can set the childs' ReferenceOption.Cascade from the parent entity? The child tab...

# exposed

[ESchouten]

Is there any way I can set the childs' ReferenceOption.Cascade from the parent entity?
The child table is referenced from multiple tables, and I want to avoid optionally referencing each of the tables at the child level
Example:

object Person : UUIDTable() {
    val name = varchar("name", 255)
    val address = reference("address", Address)
}

object Company : UUIDTable() {
    val name = varchar("name", 255)
    val address = reference("address", Address)
}

object Address : UUIDTable() {
    val number = varchar("number", 255)
    val street = varchar("street", 255)
    val city = varchar("city", 255)
    val zipcode = varchar("zipcode", 255)
    val country = varchar("country", 255)
}

[tapac]

Do you want to delete Address when related Person or Company deleted?

[ESchouten]

@tapac Yes!

[tapac]

Afaik it's not possible from SQL side to declare such a relation between tables.

[ESchouten]

Would the best solution be to make address an abstract class and create PersonAddress and CompanyAddress with its references?

[tapac]

It should work if you declare person_id in PersonAddress but that means you have to create Person before address in your code.