Attribute mapping multiple inheritance
Posted: Wed 02 Jan 2019 22:17
Is there a way to build a Table-per-Type multiple inheritance (role like relationship) through attribute-mapping objects approach?
For example, let's suppose we have a base class TEmployee and subclasses which corresponds to two roles: TManager and TProjectLeader. One employee can be both an manager and a project leader or can be only a manager or can be just an employee. If an employee is deleted, related records in manager and project leader tables must be deleted. If a record of the role tables is deleted, the employee record must be preserved.
Regards
For example, let's suppose we have a base class TEmployee and subclasses which corresponds to two roles: TManager and TProjectLeader. One employee can be both an manager and a project leader or can be only a manager or can be just an employee. If an employee is deleted, related records in manager and project leader tables must be deleted. If a record of the role tables is deleted, the employee record must be preserved.
Regards