Generic PersonCompany DEV: Difference between revisions

m
no edit summary
mNo edit summary
 
Line 2: Line 2:


=Concerns and Goals=
=Concerns and Goals=
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.
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 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 [[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:
* 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]]


'''''Warning: Image doesn't reflect the current layout.'''''
{{eyecatch|Warning|Image does '''not''' reflect the current layout!}}


* To Fix:
* To Fix:
Line 132: Line 132:


====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
* typeid - type of entity
* typeid - type of entity
Line 143: Line 143:


====Artist====
====Artist====
<tt>derived from [[OstDB_DEV | OstDB]]</tt>
<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 [[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
* 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 [[Generic PersonCompany DEV#Generic_Fields - Collaboration|Collaboration]])
* 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 [[MangaDB_DEV|MangaDB]]</tt>
<tt>check [[MangaDB DEV|MangaDB]]</tt>
* like animenetries at AniDB
* like animenetries at AniDB
* description
* description
Line 275: Line 275:


==Character==
==Character==
<tt>check [[CharDB_DEV|CharDB]]</tt>
<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 [[OstDB_DEV|OstDB]]</tt>
<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 [[OstDB_DEV|OstDB]]</tt>
<tt>check [[OstDB DEV|OstDB]]</tt>
* picture
* picture
* arbitrary number of titles (with language information)
* arbitrary number of titles (with language information)
1,633

edits

MediaWiki spam blocked by CleanTalk.
MediaWiki spam blocked by CleanTalk.