Could you collapse the three "bonus" tables into one with a entity class id?
ClaimantID
EntityTypeID (I,G,F) FK 3 row table.
etc.?
Albert
On 10/24/2013 5:36 PM, Bruce A. Chitiea wrote:
All:
Members of three entity classes have lodged claims against an estate in a
lawsuit:
- Individual Persons
- Investor Groups ('Intervenors') who have purchased the claims of
Individual Persons
- Faceless, Heartless, Greedy, Bloated Bureaucracies
Data for each of these entities lives in a table unique to its class:
- PERSON
- INTERVENOR
- FHGBB
I need to 'flatten' class members into a common entity: CLAIMANT
Would this be a legitimate way to do it in one table, or am I buying into
massive AND/OR logic headaches down the road?
CLAIMANT
- PK - ClaimantID
- FK - PersonID ... to the PERSON class table
- FK - IntervenorID ... to the INTERVENOR class table
- FK - FHGBBID ... to the FHGBB class table
- FK - ClmntClassID ... to the CLMNTCLASS Lookup table
Any better way?
Help! I'm hostage to probate lawyers! (not the most exciting bunch, lemme
tell you).
Bruce
