Support table inheritance

[fwgreen]

I'm opening a separate issue from (#46) as it isn't clear to me if the lack of model inheritance precludes having table inheritance as a feature.

Let's say I have a table of galaxies:

+----+------------------------+-------------+
| id |          name          | GALAXY_TYPE |
+----+------------------------+-------------+
|  1 | M100                   | SPIRAL      |
|  2 | Large Magellanic Cloud | IRREGULAR   |
|  3 | M87                    | ELLIPTICAL  |
+----+------------------------+-------------+

Is it possible to implement table inheritance in Fluent without model inheritance?

[tanner0101]

@fwgreen hmm not sure what you mean by this one. Could you elaborate?

[fwgreen]

@tanner0101 I was hoping for a way to have Single Table Inheritance, similar to JPA or ActiveRecord, by somehow using the ORM to get around the issue of models needing to be final.

[tanner0101]

Hmm ok. I'm not very familiar with that. As long as the table looks like a normal one to the model everything should work fine. You can use custom SQL commands in the migrations to create whatever type of DB structure you want. If you find something in FluentKit that could be changed or added to make this easier let me know.