Table Inheritance pattern

[iluwatar]

Description

The Table Inheritance design pattern involves modeling a class hierarchy in a relational database. Each class in the hierarchy is mapped to its own table. The main elements of this pattern include:

• Class Hierarchy Representation: Each class in the hierarchy has its own table.
• Primary Key: All tables share a common primary key.
• Relationships: Tables are related through foreign keys representing the inheritance structure.

This pattern is particularly useful when different subclasses have distinct properties that need to be stored in separate tables, and it helps in organizing complex data models efficiently.

References

• Table Inheritance Pattern - Martin Fowler
• Java Design Patterns Contribution Guidelines
• Book

Acceptance Criteria

1. Implement the Table Inheritance pattern with a sample class hierarchy.
2. Ensure that each class in the hierarchy has its own table with a common primary key.
3. Write unit tests to verify the correct behavior of the pattern implementation, ensuring proper data retrieval across the hierarchy.

[ved-asole]

Hi @iluwatar, could you please assign this PR to me. I will take care of it.

[stale]

This issue has been automatically marked as stale because it has not had recent activity. The issue will be unassigned if no further activity occurs. Thank you for your contributions.

[HabibaMekay]

Hi @iluwatar, I am interested in working on the Table Inheritance design pattern. Could you please assign this task to me?

Thank you!

[Karim-Ashraf1]

Hi @iluwatar, I want to work on this issues I have some ideas for it could you please assign it to me ?