Database Inheritance Relationship

[juliomotol]

I want to implement a database inheritance relationship similar to this.

For my use case, I have a questions table with different types but they share some properties.

questions
- id
- text
- order

multiple_choice
- id
- is_options_randomized

multiple_choice_options
- text
- is_correct
- order

Further down the line, we will be adding more question types such as identification, true or false, enumeration, etc.

For now, what I've done is add polymorph columns on questions table and use that to determine the question type.

But my problem with this is by adding morphs to the Question model, it is now the child of MultipleChoice, but it should be the other way around.

A polymorphic relationship allows the child model to belong to more than one type of model using a single association.
-Laravel Docs on Polymorphic Relationships

What I aim to achieve is to allow the parent model to have more than one type of model association.

You may say I could just declare multiple relationships for the Question

public function multipleChoice() { ... }

public function identification() { ... }

public function trueOrFalse() { ... }

But only I want a question record to strictly have one type.

Any ideas to do this?