CharDB DEV: Difference between revisions

From AniDB
Jump to navigation Jump to search
 
(22 intermediate revisions by 5 users not shown)
Line 1: Line 1:
{{TOCright}}
{{TOCright}}
=General=
=General=
this is the place to contribute ideas on a possible future addition of anime character/seiyu data to anidb.
this is the place to contribute ideas on a possible future addition of anime character/seiyu data to AniDB. They have been added though so this page don't matter lmao.


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


Directly related: [[Generic_PersonCompany_DEV]]
Directly related: [[Generic PersonCompany DEV]]


=Vision=
=Vision=
Line 14: Line 16:
==General==
==General==
* Normal users can only view character information
* 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
* Only advanced 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
* 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
* Creq handler (character) can grant/deny character creqs
Line 20: Line 22:


==Database==
==Database==
===Overview===
[[Image:Chardb_tables.png]]


===Generic Fields - Character===
===Generic Fields - Character===
Line 32: Line 37:
* age
* age
* death date
* death date
* height
* weight
* B/H/W
* nationality
* place of residence
* job
* workplace
* 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===
done in a category way
* gender
* gender
** male
** male
Line 37: Line 67:
** both
** both
** neither
** neither
* cupsize
** AA
** A
** B
** C
** D
** DD (or E)
** F
** G
* lifeform
* lifeform
** human
** human
** animal
** animal
*** cat
*** dog
*** elephant
*** mouse
*** pig
*** ...
** plant
** plant
** alien
** alien
Line 52: Line 97:
*** ...
*** ...
** ...
** ...
* height
* weight
* B/H/W
* cupsize
* hair color
* hair color
** main haircolor
** main haircolor
Line 66: Line 107:
** right  
** right  
* blood type
* blood type
* nationality
* place of residence
* job
* workplace
* school
* school
* grade/class
**gradeschool
* description (extra data goes here)
**highschool
 
**...
====Generic Fields - CharacterTitle====
* Accessories
<tt>copied from [[Generic_PersonCompany_DEV#Generic_Fields_-_PersonTitle|Generic Fields - PersonTitle]]</tt>
** glasses
* title - some title, like: phd, bsc, etc
** hat
* [name] - this is LASTNAME firstname for oriental names and firstname LASTNAME for western names
** magical staff
* firstname - also know as Personal names
** magical book
* lastname - also know as Family name
** stuffed animal
* lang - language of title
** ...
* type - type of title
* Signature Saying ("~dattebayo", "~desu", "~de arimasu", ...)
** 1 - Main title
** 2 - Alias
** 3 - Maiden name
** 4 - Nickname
* verified
 
====Accessories=====
List of accessories the characters has. Multiple selections possible
* glasses
* hat
* magical staff
* magical book
* stuffed animal
* ...


===Relations===
===Relations===
Line 104: Line 127:


====Relations - Character <-> Seiyuu====
====Relations - Character <-> Seiyuu====
* [[Generic_PersonCompany_DEV#Seiyuu|Seiyuu]] S (based on [[Generic_PersonCompany_DEV#Generic_Fields_-_Person|Person]] P) is seiyuu of character C in anime A
* [[Generic_PersonCompany_DEV#Seiyuu|Seiyuu]] S (based on [[Generic_PersonCompany_DEV#Generic_Fields_-_Person|Person]] P) is seiyuu of character C in anime A for language L
* [[Generic_PersonCompany_DEV#Seiyuu|Seiyuu]] S (based on [[Generic_PersonCompany_DEV#Generic_Fields_-_Person|Person]] P) is seiyuu of character C in anime A for episodes E
* [[Generic_PersonCompany_DEV#Seiyuu|Seiyuu]] S (based on [[Generic_PersonCompany_DEV#Generic_Fields_-_Person|Person]] P) is seiyuu of character C in anime A for episodes E for language L


====Relations - Character <-> Anime====
====Relations - Character <-> Anime====
Line 116: Line 139:
====Relations - Character <-> Character====
====Relations - Character <-> Character====
* Type of relation
* Type of relation
** family (unspecified)
** Family (unspecified)
** sibling of
** Sibling of
** child of / parent of
** Descendant of / Ascendant of (unspecified)
** grandchild of / grandparent of
** Child of / Parent of
** foster child of / foster parent of
** Grandchild of / Grandparent of
** best friend of
** Foster Child of / Foster Parent Of
** boyfriend of / girlfriend of
** Foster Grandchild of / Foster Grandparent Of
** married to
** Best friend of
** Friend of
** Ally of
** Companion/Sidekick of
** (Arch)Enemy of
** (Arch)Rival of
** Pet of / Owner 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====
====Relations - Character -> Award====
Line 130: Line 179:


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

Latest revision as of 00:03, 8 May 2024

General

this is the place to contribute ideas on a possible future addition of anime character/seiyu data to AniDB. They have been added though so this page don't matter lmao.

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 advanced 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

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
      • cat
      • dog
      • elephant
      • mouse
      • pig
      • ...
    • 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
    • ...
  • Signature Saying ("~dattebayo", "~desu", "~de arimasu", ...)

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 for language L
  • Seiyuu S (based on Person P) is seiyuu of character C in anime A for episodes E for language L

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
    • Pet of / Owner 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)