3,699
edits
Generic PersonCompany DEV: Difference between revisions
2nd way simpler implementation suggestion
Fahrenheit (talk | contribs) (→Artist) |
(2nd way simpler implementation suggestion) |
||
| Line 25: | Line 25: | ||
*# 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? | ||
=The big picture= | =Suggestion 1= | ||
==The big picture== | |||
[[Image:People1.png]] | [[Image:People1.png]] | ||
| Line 35: | Line 36: | ||
** Decide if we actually need the Pseudonym table | ** Decide if we actually need the Pseudonym table | ||
=Data Fields= | ==Data Fields== | ||
==Generic Fields== | ===Generic Fields=== | ||
===Generic Fields - Person=== | ====Generic Fields - Person==== | ||
* image | * image | ||
* url (en) | * url (en) | ||
| Line 65: | Line 66: | ||
* verified | * verified | ||
===Generic Fields - Company=== | ====Generic Fields - Company==== | ||
* image | * image | ||
* type - type of company | * type - type of company | ||
| Line 87: | Line 88: | ||
* verified | * verified | ||
===Generic Fields - Collaboration=== | ====Generic Fields - Collaboration==== | ||
* type - collaboration type | * type - collaboration type | ||
** 1 - Joint work | ** 1 - Joint work | ||
| Line 116: | Line 117: | ||
* verified | * verified | ||
==Specializations== | ===Specializations=== | ||
===Producer=== | ====Producer==== | ||
* relid - entity id | * relid - entity id | ||
* typeid - type of entity | * typeid - type of entity | ||
| Line 129: | Line 130: | ||
* [ratings&co] - not implemented in the ui | * [ratings&co] - not implemented in the ui | ||
===Seiyuu=== | ====Seiyuu==== | ||
<tt>derived from [[Generic_PersonCompany_DEV#Artist |Artist]]/[[OstDB_DEV |OstDB]]</tt> | <tt>derived from [[Generic_PersonCompany_DEV#Artist |Artist]]/[[OstDB_DEV |OstDB]]</tt> | ||
* relid - entity id | * relid - entity id | ||
| Line 140: | Line 141: | ||
* [ratings&co] - not implemented in the ui | * [ratings&co] - not implemented in the ui | ||
===Artist=== | ====Artist==== | ||
<tt>derived from [[OstDB_DEV | OstDB]]</tt> | <tt>derived from [[OstDB_DEV | OstDB]]</tt> | ||
* relid - entity id | * relid - entity id | ||
| Line 152: | Line 153: | ||
* [ratings&co] - not implemented in the ui | * [ratings&co] - not implemented in the ui | ||
===Mangaka=== | ====Mangaka==== | ||
<tt>derived from [[Generic_PersonCompany_DEV#Artist |Artist]]/[[OstDB_DEV |OstDB]]</tt> | <tt>derived from [[Generic_PersonCompany_DEV#Artist |Artist]]/[[OstDB_DEV |OstDB]]</tt> | ||
* relid - entity id | * relid - entity id | ||
| Line 164: | Line 165: | ||
* [ratings&co] - not implemented in the ui | * [ratings&co] - not implemented in the ui | ||
== | ==further notes== | ||
===Person=== | ===Person=== | ||
* Persons '''need''' one ''main title'', made from [title] firstname lastname (lang defaults to transcription) | * Persons '''need''' one ''main title'', made from [title] firstname lastname (lang defaults to transcription) | ||
| Line 226: | Line 186: | ||
* 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 262: | Line 221: | ||
===Collection=== | ===Collection=== | ||
<tt>check [[OstDB_DEV|OstDB]]</tt> | <tt>check [[OstDB_DEV|OstDB]]</tt> | ||
=Suggestion 2= | |||
==Producerntb== | |||
* image | |||
* url (en) | |||
* url (jp) | |||
* url wiki (en) | |||
* url wiki (jp) | |||
* birth date | |||
* death date | |||
* description | |||
* role[] - relevant for in which system the entity will be shown/used (filter) | |||
** Mangaka | |||
** Artist | |||
** Anime Producer | |||
** Seiyuu | |||
* type | |||
**Person | |||
**Company | |||
* parentid | |||
**analog 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) | |||
** that way we can credit the correct person while still being able to display both data entries under 1 entity | |||
==Producernametb== | |||
* name | |||
* lang - language of title | |||
* type - type of title | |||
** 1 - Main title | |||
** 2 - Alias | |||
** 3 - Maiden name | |||
** 4 - Nickname | |||
* verified | |||
==Producerproducerreltb== | |||
-- used for "silly" relations like "marriage", collaborations, etc. | |||
* prelid | |||
**married | |||
**works for | |||
**works with | |||
**... | |||
* producerid | |||
* next | |||
==Producerrelationtb== | |||
--defines the relation types | |||
*name | |||
*restriction | |||
**relations should be filtered down by type | |||
**personlevel relations make not much sense for companies and vice versa | |||
** see character system whcih works that way | |||
*description | |||
==Producertagtb== | |||
* tag system like used for character to add further non numerical data | |||
=Top Level Agglomerates= | |||
==Manga== | |||
<tt>check [[MangaDB_DEV|MangaDB]]</tt> | |||
* like animenetries at anidb | |||
* description | |||
* genres/categories | |||
* mangaka(s) [relation] | |||
* picture | |||
==Character== | |||
<tt>check [[CharDB_DEV|CharDB]]</tt> | |||
* arbitrary number of titles (with language information) | |||
* picture | |||
* description | |||
* seiyuu [relation] | |||
* appearance in episodes [relation] | |||
==Song== | |||
<tt>check [[OstDB_DEV|OstDB]]</tt> | |||
* arbitrary number of titles (with language information) | |||
* length (in seconds) | |||
* genre (?) | |||
* artists(s) [relation] | |||
* appearance in animes [relation] | |||
* .. | |||
==Collection== | |||
<tt>check [[OstDB_DEV|OstDB]]</tt> | |||
* picture | |||
* arbitrary number of titles (with language information) | |||
* number of tracks | |||
* release date | |||
* genre (?) | |||
* artist(s) [relation] | |||
* anime(s) [relation] | |||
* ... | |||
=System= | |||
This details a bit of what is done and what we are aiming at | |||
[[Category:Development]] | [[Category:Development]] | ||