1,633
edits
Generic PersonCompany DEV: Difference between revisions
Jump to navigation
Jump to search
m
no edit summary
mNo edit summary |
mNo edit summary |
||
| (2 intermediate revisions by 2 users not shown) | |||
| Line 2: | Line 2: | ||
=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 13: | 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 22: | 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 30: | Line 30: | ||
[[Image:People1.png]] | [[Image:People1.png]] | ||
''''' | {{eyecatch|Warning|Image does '''not''' reflect the current layout!}} | ||
* To Fix: | * To Fix: | ||
| Line 132: | Line 132: | ||
====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 143: | 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 155: | 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 184: | Line 184: | ||
<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). | ||
| Line 267: | Line 267: | ||
=Top Level Agglomerates= | =Top Level Agglomerates= | ||
==Manga== | ==Manga== | ||
<tt>check [[ | <tt>check [[MangaDB DEV|MangaDB]]</tt> | ||
* like animenetries at AniDB | * like animenetries at AniDB | ||
* description | * description | ||
| Line 275: | 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 283: | 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) | ||
| Line 292: | Line 292: | ||
==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) | ||