Quote:
|
Originally Posted by mikesouth
Aliases Table
puid INTEGER
alias VARCHAR puid+alias = Primary Key
|
The part of the regs about indexing by stage name, alias, etc is humorous because "trixie" could be a "stage name" or an "alias", etc.
By having it as you have it, the DOJ inquiry could be "show me all the records of a model that goes by the stage name of "trixie". Any alias match on "trixie" would pull up the PUID, which then could pull up the individual models info.
2257 Purists would probably argue that you have to have those exact fields defined, for which if you wanted to, you can include an extra column in the table that is TypeOfAlias varchar(20) where you could be specific.
Fight the Inquiries!