347
edits
Generic PersonCompany DEV: Difference between revisions
no edit summary
Fahrenheit (talk | contribs) |
Fahrenheit (talk | contribs) No edit summary |
||
| Line 1: | Line 1: | ||
{{TOCright}} | {{TOCright}} | ||
=Generic | =Generic Tables= | ||
As the CharDB, OstDB, MangaDB and AniDB's producers all tend to include data about | As the CharDB, OstDB, MangaDB and AniDB's producers all tend to include data about individuals or companies it would be a good idea to extract the generic data for individuals and companies into two separate tables which are then used by all other parts. | ||
I.e. instead of having all the data inside the producer table, it would only include those | I.e. instead of having all the data inside the producer table, it would only include those data fields which are producer specific and would refer to a person or company table for the general data. | ||
The question is, which fields can be considered generic (and should thus be listed in the person/ | The question is, which fields can be considered generic (and should thus be listed in the person/company table) and which fields are specific. | ||
And also which relations should be possible between entries. | And also which relations should be possible between entries. | ||
| Line 12: | Line 12: | ||
* person<=>person relations? (married?) | * person<=>person relations? (married?) | ||
And multiplicities, i.e. has each producer only one person/company related to it, or multiple ones? | <s>And multiplicities, i.e. has each producer only one person/company related to it, or multiple ones?</s> - Each producer as only one entity assigned to it. Although one of those entities is Collaboration which can hold multiple companies and/or persons. | ||
Also, should names be a separate table (like anime titles) or are there only a small number of names we'd want to store per person/company? | <s>Also, should names be a separate table (like anime titles) or are there only a small number of names we'd want to store per person/company?</s> - Names have their own table for every Entity that have them. | ||
Is mangaka | Is mangaka sufficiently different from producers? Or should mangaka simply be stored/handled like producers? | ||
The concept of pseudonyms is still very unclear, what is the multiplicity? And are they also related to producers? Or persons? | The concept of pseudonyms is still very unclear, what is the multiplicity? And are they also related to producers? Or persons? | ||