Difference between revisions of "CharDB DEV"

From AniDB
Jump to navigation Jump to search
Line 43: Line 43:
 
* workplace
 
* workplace
 
* description (extra data goes here)
 
* description (extra data goes here)
 +
 +
====Generic Fields - CharacterTitle====
 +
<tt>copied from [[Generic_PersonCompany_DEV#Generic_Fields_-_PersonTitle|Generic Fields - PersonTitle]]</tt>
 +
* 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
  
 
===Character Traits===
 
===Character Traits===
Line 96: Line 110:
 
** stuffed animal
 
** stuffed animal
 
** ...
 
** ...
 
====Generic Fields - CharacterTitle====
 
<tt>copied from [[Generic_PersonCompany_DEV#Generic_Fields_-_PersonTitle|Generic Fields - PersonTitle]]</tt>
 
* 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
 
  
 
===Relations===
 
===Relations===
Line 146: Line 146:
 
** Married to
 
** Married to
 
** Unknown Relation
 
** Unknown Relation
** evolves to
+
** Evolves to
** fusions to
+
** Fusions to
 
** ...
 
** ...
  

Revision as of 00:33, 25 January 2008

General

this is the place to contribute ideas on a possible future addition of anime character/seiyu data to anidb.

For other areas of active development on AniDB, check: Development

Directly related: Generic_PersonCompany_DEV

Vision

Data

Implementation

General

  • Normal users can only view character information
  • Only adv. users and higher userlevels can add/edit/delete characters and add/edit/delete relations through the creq system
  • Character maintainers can add/edit/delete characters and add/edit/delete relations without going through the creq system
  • Creq handler (character) can grant/deny character creqs
  • Mods are gods

Database

Overview

Chardb tables.png

Generic Fields - Character

parts copied from Generic Fields - Person

  • image
  • url (en)
  • url (jp)
  • url wiki (en)
  • url wiki (jp)
  • birth place
  • birth date
  • age
  • death date
  • height
  • weight
  • B/H/W
  • nationality
  • place of residence
  • job
  • workplace
  • description (extra data goes here)

Generic Fields - CharacterTitle

copied from 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

Character Traits

done in a category way

  • gender
    • male
    • female
    • both
    • neither
  • cupsize
    • AA
    • A
    • B
    • C
    • D
    • DD (or E)
    • F
    • G
  • lifeform
    • human
    • animal
    • plant
    • alien
    • stuffed animal
    • robot
    • juujin (human x animal)
      • catgirl
      • doggirl
      • foxgirl
      • ...
      • *boy
      • ...
    • ...
  • hair color
    • main haircolor
    • second haircolor
  • hair style
    • twin tails
    • ...
  • eye color
    • left
    • right
  • blood type
  • school
    • gradeschool
    • highschool
    • ...
  • Accessories
    • glasses
    • hat
    • magical staff
    • magical book
    • stuffed animal
    • ...

Relations

  • Character <-> Seiyuu
  • Character <-> Anime
  • Character <-> Character
  • Character -> Award

Relations - Character <-> Seiyuu

  • Seiyuu S (based on Person P) is seiyuu of character C in anime A
  • Seiyuu S (based on Person P) is seiyuu of character C in anime A for episodes E

Relations - Character <-> Anime

  • Role of character
    • Main character
    • Side character
    • Support character
    • ...

Relations - Character <-> Character

  • Type of relation
    • Family (unspecified)
    • Sibling of
    • Descendant of / Ascendant of (unspecified)
    • Child of / Parent of
    • Grandchild of / Grandparent of
    • Foster Child of / Foster Parent Of
    • Foster Grandchild of / Foster Grandparent Of
    • Best friend of
    • Friend of
    • Ally of
    • Companion/Sidekick of
    • (Arch)Enemy of
    • (Arch)Rival of
    • Boyfriend / Girlfriend of
    • Married to
    • Unknown Relation
    • Evolves to
    • Fusions to
    • ...

Problems with characters and character relations

Pokemon: Pokemon have different stages of evolution. Each evolution would need its own database entry and a relation "evolved form of" would be needed. A Pokemon should be shown with its evolved and pre-evolutionary forms on one page.

Digimon: Digimon are even worse than Pokemon. Not only can they evolve to a higher digitation but they can also combine/fuse with each other to create new Digimon.

Ranma 1/2: Ranma transforms into a girl, his dad into a panda, and so on. Each transformed should get its own character entry and a "same character as" relation. All characters linked by a "same character as" relations should be shown on one page.

Sailormoon / Wedding Peach: Basically the same situation as with Ranma 1/2. Each transformation should get its own character entry and a "same character as" relation should be set.

Relations - Character -> Award

  • List of awards (ARC Character Awards)