New types of relationships: inheritance, zero to

[victor_herguedas]

New types of relationships: inheritance, zero to…

[Thi_Nguyen]

Update March 2025: This feature was recently released. You can now test it by defining a relationship with and without nullability for the foreign key. For instance:

Table follows {
  following_user_id int [ref: > users.id] // optional relationship
  followed_user_id int [ref: > users.id, null] // optional relationship
}

Table posts {
  id int [pk]
  user_id int [ref: > users.id, not null] // mandatory relationship
}

Table users { 
  id int [pk]
}

The outcome will be as follows:

Upgrade for Database Relationships: Zero-to-One/Many Relationships, Colors and more!

Valentine’s Day taught us relationships can be rock-solid or a little… optional —and your database is no different! Our latest update lets you define optional or mandatory relationships, customize their colors, and add names to make your diagrams clearer and more meaningful. Optional or Mandatory Relationships (free plan) Using the nullable constraint on the foreign key, we can now automatically determine whether a relationship is optional (zero-to-one/many) or mandatory (one-to-o…