I have a Database table that holds various types of the same entity. (Suppose I have a table named dbo.PERSONEL which holds data for Engineer, Constructor, Manager, Secretary etc.) But each spesific personel type uses only some and different properties of the table. (Engineer uses [ENGINEERING_TYPE] and [IS_OFF_FIELD] fields while Secretary uses [OFFICE_ID] and [DOES_USE_COMPUTER] fields but not the fields that Engineer uses).
How should I design my interfaces, classes etc. and is there a certain appropriate design pattern for SCRUD operations of such a design.
Regards.
Aucun commentaire:
Enregistrer un commentaire