Quote:
Originally Posted by Sabardeyn
Hmm... I created a custom column #pseudonym in which I list any pen names the author released the story under.
|
I have one of those. The trouble is it breaks a good relational model.
(custom cols only link to Title)
Author-> Pseudo (1-M) (includes the real name in the list)
eg. Stephen King - Stephen King, Richard Bachman as well as any metadata variants of those
Pseudo is related to a Real name author, not part of a single book as it is now being managed by us
Title -> Pseudo or Title -> Real
In reality we ARE really working with the Pen name {authors}, since all the pen name can exist there. a new table: Realname (1-M) needs to link to all the pen names in {authors}
I sure can't code this.