View source for Generic PersonCompany DEV

{{TOCright}}
=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.

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/company table) and which fields are specific.

And also which relations should be possible between entries.
* person<=>company relations? (works/ed for?)
* company<=>company relations?
* 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 as 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.''

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?
Also how are matching pseudonyms (they're not unique, are they?) handled?

=The big picture=
[[Image:People1.png]]

'''''Warning: Image doesn't reflect the current layout.'''''

* To Fix:
** Add missing Collaboration and CollaborationEntities tables
** Add missing PersonTitle table
** Decide if we actually need the Pseudonym table

=Data Fields=
==Generic Fields==
===Generic Fields - Person===
* image
* url (en)
* url (jp)
* url wiki (en)
* url wiki (jp)
* birth place
* birth date
* death date
* gender
* blood type
* nationality
* place of residence
* description (extra data goes here)

====Generic Fields - PersonTitle====
* title - some title, like: phd, bsc, etc
* [name] - this is LASTNAME firstname for oriental names and firstname LASTNAME for western names
* firstname - also know as Personal names
* lastname - also know as Family name
* lang - language of title
* type - type of title
** 1 - Main title
** 2 - Alias 
** 3 - Maiden name
** 4 - Nickname
* verified

===Generic Fields - Company===
* image
* type - type of company
** 1 - Company
** 2 - Organization
* url (en)
* url (jp)
* wiki (en)
* wiki (jp)
* date founded
* date closed down
* description - other stuff goes here

====Generic Fields - CompanyTitle====
* name - name of the company
* lang - language of title
* type - type of title
** 1 - Main title
** 2 - Synonyms
** 3 - Short
* verified

===Generic Fields - Collaboration===
* type - collaboration type
** 1 - Joint work
** 2 - Band
** 3 - ... ?
* url (en)
* url (jp)
* wiki (en)
* wiki (jp)
* start date
* end date
* description - other stuff goes here

====Generic Fields - CollaborationEntities====
* type - type of entity
** 1 - company
** 2 - person
* relid - entity id
* titleid - titles used by the entity

==Specializations==
===Producer===
* relid - entity id
* typeid - type of entity
** 1 - company
** 2 - person
** 3 - collaboration
* titleid - titles used by the entity
* start date - if different from underlying entity
* end date - if different from underlying entity
* description - producer specific information
* [ratings&co] - not implemented in the ui

===Seiyuu===
(unspecified at the moment)

===Artist===
<tt>copied from [[OstDB_DEV | OstDB]]</tt>
* relid - entity id
* typeid - type of entity
** 1 - person
** 2 - collaboration (allows to make bands)
* titleid - titles used by the entity
* debut on - Start of career 
* retired on - End of career
* description - Some artist specific info
* [ratings&co] - not implemented in the ui

===Mangaka===
<tt>derived from [[Generic_PersonCompany_DEV#Artist |Artist]]/[[OstDB_DEV |OstDB]]</tt>
* relid - entity id
* typeid - type of entity
** 1 - person
** 2 - collaboration (allows us to have several persons working under the same penname)
* titleid - titles used by the entity
* debut on - Start of career 
* retired on - End of career
* description - Some mangaka specific info
* [ratings&co] - not implemented in the ui

=System=
This details a bit of what is done and what we are aiming at

==Generic==

===Person===
* Persons '''need''' one ''main title'', 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''' ''nickanmes'', made from lastname (lang defaults to transcription)
* One can choose '''optional''' relations between persons and/or companies. (not implemented in the ui)

===Company===
* Companies can either be of type Company or Organization
* Companies '''need''' one ''main title'' (lang defaults to transcription)
* Companies can have '''multiple''' ''synonyms'' (lang defaults to transcription)
* Companies can have '''multiple''' ''short names'' (lang defaults to transcription)
* One can choose '''optional''' relations between persons and/or companies. (not implemented in the ui)

===Collaboration===
<tt>Still very unspecified</tt>

* 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)

==Specializations==
===Producer===

* One can make a Producer either from a Person, a Company entry or a Collaboration entry.
* One chooses from the related entry which names should the producer be known as.

===Seiyuu===
<tt>still very unspecified at the moment</tt>

* One can make a Seiyuu either from a Person or a Collaboration entry (?).
* One chooses from the related entry which names should the Seiyuu be known as.

===Mangaka===
<tt>still very unspecified at the moment</tt>

* One can make a Mangaka either from a Person or a Collaboration entry.
* One chooses from the related entry which names should the Mangaka be known as.

===Artist===
<tt>still very unspecified at the moment</tt>

* One can make a Artist either from a Person or a Collaboration entry.
* One chooses from the related entry which names should the Artist be known as.

[[Category:Development]]