1,633
edits
Generic PersonCompany DEV: Difference between revisions
Jump to navigation
Jump to search
m
no edit summary
mNo edit summary |
|||
| (10 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
{{TOCright}} | {{TOCright}} | ||
=Concerns and Goals= | =Concerns and Goals= | ||
As the [[ | As the [[CharDB DEV|CharDB]], [[OstDB DEV|OstDB]], [[MangaDB DEV|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 data fields which are producer specific and would refer to a person or company table for the general data. | * 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. | ||
| Line 12: | Line 13: | ||
** person<=>person relations? (married?) | ** person<=>person relations? (married?) | ||
* <s>And multiplicities, i.e. has each producer only one person/company related to it, or multiple ones?</s> - ''Each producer | * <s>And multiplicities, i.e. has each producer only one person/company related to it, or multiple ones?</s> - ''Each producer has only one entity assigned to it. Although one of those entities is Collaboration which can hold multiple companies and/or persons.'' | ||
* <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 has titles.'' | * <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 has titles.'' | ||
| Line 21: | Line 22: | ||
* Also how are matching pseudonyms (they're not unique, are they?) handled? | * Also how are matching pseudonyms (they're not unique, are they?) handled? | ||
* Looking at [[ | * Looking at [[Generic PersonCompany DEV#Producer|Producer]], [[Generic PersonCompany DEV#Artist|Artist]], [[Generic PersonCompany DEV#Mangaka|Mangaka]] and [[Generic PersonCompany DEV#Seiyuu|Seiyuu]] we see that they are very similar the only thing changing are the names of the generic fields (like start date), so a question is should we either: | ||
*# have multiple modules for each specialization or should we keep it only under one module and differentiate with something like show=addentity&type=person[&edit=1] | *# have multiple modules for each specialization or should we keep it only under one module and differentiate with something like show=addentity&type=person[&edit=1] | ||
*# keep using the current way that is xvcl everything and make several modules for each specialization? | *# keep using the current way that is xvcl everything and make several modules for each specialization? | ||
| Line 29: | Line 30: | ||
[[Image:People1.png]] | [[Image:People1.png]] | ||
''''' | {{eyecatch|Warning|Image does '''not''' reflect the current layout!}} | ||
* To Fix: | * To Fix: | ||
| Line 128: | Line 129: | ||
* end date - if different from underlying entity | * end date - if different from underlying entity | ||
* description - producer specific information | * description - producer specific information | ||
* [ratings&co] - not implemented in the | * [ratings&co] - not implemented in the UI | ||
====Seiyuu==== | ====Seiyuu==== | ||
<tt>derived from [[ | <tt>derived from [[Generic PersonCompany DEV#Artist|Artist]]/[[OstDB DEV|OstDB]]</tt> | ||
* relid - entity id | * relid - entity id | ||
* typeid - type of entity | * typeid - type of entity | ||
| Line 142: | Line 143: | ||
====Artist==== | ====Artist==== | ||
<tt>derived from [[ | <tt>derived from [[OstDB DEV|OstDB]]</tt> | ||
* relid - entity id | * relid - entity id | ||
* typeid - type of entity | * typeid - type of entity | ||
| Line 154: | Line 155: | ||
====Mangaka==== | ====Mangaka==== | ||
<tt>derived from [[ | <tt>derived from [[Generic PersonCompany DEV#Artist|Artist]]/[[OstDB DEV|OstDB]]</tt> | ||
* relid - entity id | * relid - entity id | ||
* typeid - type of entity | * typeid - type of entity | ||
| Line 170: | Line 171: | ||
* Persons can have '''one''' ''maiden name'', made from [title] firstname lastname (lang defaults to transcription) | * Persons can have '''one''' ''maiden name'', made from [title] firstname lastname (lang defaults to transcription) | ||
* Persons can have '''multiple''' ''alias'', made from [title] firstname lastname (lang defaults to transcription) | * Persons can have '''multiple''' ''alias'', made from [title] firstname lastname (lang defaults to transcription) | ||
* Persons can have '''multiple''' '' | * Persons can have '''multiple''' ''nicknames'', made from lastname (lang defaults to transcription) | ||
* One can choose '''optional''' relations between persons and/or companies | * One can choose '''optional''' relations between persons and/or companies (not implemented in the UI). | ||
===Company=== | ===Company=== | ||
| Line 178: | Line 179: | ||
* Companies can have '''multiple''' ''synonyms'' (lang defaults to transcription) | * Companies can have '''multiple''' ''synonyms'' (lang defaults to transcription) | ||
* Companies can have '''multiple''' ''short names'' (lang defaults to transcription) | * Companies can have '''multiple''' ''short names'' (lang defaults to transcription) | ||
* One can choose '''optional''' relations between persons and/or companies | * One can choose '''optional''' relations between persons and/or companies (not implemented in the UI). | ||
===Collaboration=== | ===Collaboration=== | ||
<tt>Still very unspecified</tt> | <tt>Still very unspecified</tt> | ||
* Collaborations '''need''' a type (unspecified at the moment, see [[ | * Collaborations '''need''' a type (unspecified at the moment, see [[Generic PersonCompany DEV#Generic Fields - Collaboration|Collaboration]]) | ||
* Collaborations aren't limited to either companies or persons but can be a mix of both (unspecified at the moment) | * Collaborations aren't limited to either companies or persons but can be a mix of both (unspecified at the moment). | ||
===Producer=== | ===Producer=== | ||
| Line 228: | Line 229: | ||
**Company | **Company | ||
* parentid | * parentid | ||
** | **analogue to the guise system for character we use this here as well | ||
** let's say person A works under pseudonym B as a mangaka. then we add both persons and set the parentid for the child (the pseudonym) | ** let's say person A works under pseudonym B as a mangaka. then we add both persons and set the parentid for the child (the pseudonym) | ||
** that way we can credit the correct person while still being able to display both data entries under 1 entity | ** that way we can credit the correct person while still being able to display both data entries under 1 entity | ||
== | ==creatornametb== | ||
* name | * name | ||
* lang - language of title | * lang - language of title | ||
| Line 242: | Line 243: | ||
* verified | * verified | ||
== | ==creatorcreatorreltb== | ||
-- used for "silly" relations like "marriage", collaborations, etc. | -- used for "silly" relations like "marriage", collaborations, etc. | ||
* prelid | * prelid | ||
| Line 252: | Line 253: | ||
* next | * next | ||
== | ==creatorrelationtb== | ||
--defines the relation types | --defines the relation types | ||
*name | *name | ||
| Line 258: | Line 259: | ||
**relations should be filtered down by type | **relations should be filtered down by type | ||
**personlevel relations make not much sense for companies and vice versa | **personlevel relations make not much sense for companies and vice versa | ||
** see character system | ** see character system which works that way | ||
*description | *description | ||
== | ==creatortagtb== | ||
* tag system like used for character to add further non numerical data | * tag system like used for character to add further non numerical data | ||
=Top Level Agglomerates= | =Top Level Agglomerates= | ||
==Manga== | ==Manga== | ||
<tt>check [[ | <tt>check [[MangaDB DEV|MangaDB]]</tt> | ||
* like animenetries at | * like animenetries at AniDB | ||
* description | * description | ||
* genres/categories | * genres/categories | ||
| Line 274: | Line 275: | ||
==Character== | ==Character== | ||
<tt>check [[ | <tt>check [[CharDB DEV|CharDB]]</tt> | ||
* arbitrary number of titles (with language information) | * arbitrary number of titles (with language information) | ||
* picture | * picture | ||
| Line 282: | Line 283: | ||
==Song== | ==Song== | ||
<tt>check [[ | <tt>check [[OstDB DEV|OstDB]]</tt> | ||
* arbitrary number of titles (with language information) | * arbitrary number of titles (with language information) | ||
* length (in seconds) | * length (in seconds) | ||
* genre (?) | * genre (?) | ||
* artists(s) [relation] | * artists(s) [relation] | ||
* appearance in | * appearance in anime [relation] | ||
* .. | * ... | ||
==Collection== | ==Collection== | ||
<tt>check [[ | <tt>check [[OstDB DEV|OstDB]]</tt> | ||
* picture | * picture | ||
* arbitrary number of titles (with language information) | * arbitrary number of titles (with language information) | ||
| Line 305: | Line 306: | ||
[[Category:Development]] | [[Category:Development]] | ||
[[Category:CharDB]] | |||