Generic PersonCompany DEV: Difference between revisions

From AniDB
Jump to navigation Jump to search
Line 28: Line 28:


=Data Fields=
=Data Fields=
 
==Generic Fields==
==Generic Fields - Person==
===Generic Fields - Person===
* image
* image
* url (en)
* url (en)
Line 44: Line 44:
* description (extra data goes here)
* description (extra data goes here)


===Generic Fields - PersonTitle===
====Generic Fields - PersonTitle====
* title - some title, like: phd, bsc, etc
* title - some title, like: phd, bsc, etc
* [name] - this is LASTNAME firstname for oriental names and firstname LASTNAME for western names
* [name] - this is LASTNAME firstname for oriental names and firstname LASTNAME for western names
Line 57: Line 57:
* verified
* verified


==Generic Fields - Company==
===Generic Fields - Company===
* image
* image
* type - type of company
* type - type of company
Line 70: Line 70:
* description - (other stuff goes here)
* description - (other stuff goes here)


===Generic Fields - CompanyTitle===
====Generic Fields - CompanyTitle====
* name - name of the company
* name - name of the company
* lang - language of title
* lang - language of title
Line 79: Line 79:
* verified
* verified


==Producer==
==Specializations==
===Producer===
* start date - if different from underlying entity
* start date - if different from underlying entity
* 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 ui
* [ratings&co] - not implemented in the ui
===Seiyuu===
===Artist===
===Mangaka===


[[Category:Development]]
[[Category:Development]]

Revision as of 02:04, 12 January 2008

Generic Person/Company Tables

As the CharDB, OstDB, MangaDB and AniDB's producers all tend to include data about indivuduals 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 datafields 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/comapny 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?)

And multiplicities, i.e. has each producer only one person/company related to it, or multiple ones?

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?

Is mangaka sufficently 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

  • To Fix:

...

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

Specializations

Producer

  • 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

Artist

Mangaka