mardi 3 février 2015

Which pattern or structure

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