Is it possible to create a custom relationship type?

Hello I would like to have a custom relationship type between 2 tables. For example an “extends” relationship if one table extends another table. I know in most common database system there is no such thing, but it would be great for a low code development environment, which uses this kind of relationship.