Difference between revisions of "Table Numbers"

From Anime Characters Database Wiki
Jump to navigation Jump to search
(18 intermediate revisions by the same user not shown)
Line 89: Line 89:
 
*9, "Manga"
 
*9, "Manga"
  
 +
===clonetype===
 +
*0,"Select How to Handle Duplicate");
 +
*1,"Same Name, Different Traits");
 +
*2,"Same Traits, Different Name");
 +
*3,"Different Name and Different Traits");
 +
*4,"Same name and traits");
 +
*5,"Complete Duplicate");
 +
*6,"Updated Version");
 +
 +
===role===
 +
*0 unsorted
 +
*1 "$LANGARRAY[EXTRAS]";
 +
*2 "$LANGARRAY[SUBCHAR]";
 +
*5 "Supporting";
 +
*7 "Main Character";
 +
*8 "Deuteragonist";
 +
*9 "Antagonist";
 +
*10 "Protagonist";
 +
 +
===esbr===
 +
*0 Safe
 +
*1 Questionable
 +
*2 Adults Only
 +
 +
===clothing===
 +
*1, $LANGARRAY['MAID']);
 +
*33, $LANGARRAY['WAITRESS']);
 +
*24, $LANGARRAY['WHITELABCOAT']);
 +
*2, $LANGARRAY['SCHOOLUNI']);
 +
*6, $LANGARRAY['GOTHI']);
 +
*29, $LANGARRAY['NURSE']);
 +
*31, $LANGARRAY['NUN']);
 +
*30, "Preist");
 +
*3, $LANGARRAY['CASUALC']);
 +
*26, $LANGARRAY['SHORTSA']);
 +
*27, $LANGARRAY['PANTSANDT-']);
 +
*28, $LANGARRAY['PANTSANDDR']);
 +
*35, $LANGARRAY['PANTSANDLO']);
 +
*32, $LANGARRAY['JEANSANDT-SHIR']);
 +
*11, $LANGARRAY['SUITANDTIE']);
 +
*34, $LANGARRAY['SUITAND']);
 +
*4, "Swimsuit");
 +
*25, "Bikini");
 +
*5, "Mini Skirt");
 +
*22, "Skirt");
 +
*19, "Dress");
 +
*7, "Traditional");
 +
*8, "Japanese Kimono");
 +
*12, "Shrine Maiden");
 +
*13, "Chinese Dress");
 +
*14, "Martial Arts Uniform");
 +
*9, "Fantasy");
 +
*10, "Armor");
 +
*15, "Mage Clothing");
 +
*16, "Mechanic Clothes");
 +
*17, "Military Uniform");
 +
*18, $LANGARRAY['PIOL']);
 +
*20, "Jacket");
 +
*21, "Winter Jacket");
 +
*23, "Other");
 +
 +
==db_tags==
 +
Character tags are stored here. Assignments go in c_tags
 +
===tag_status===
 +
*-1 Blocked
 +
*0 Active
  
 
==api_favs==
 
==api_favs==
Line 101: Line 167:
 
*99 quotes
 
*99 quotes
 
*255
 
*255
 +
 +
==publishers==
 +
===cr===
 +
*1 "E - Everyone"
 +
*2 "E10+ - Everyone ten and up"
 +
*3 "T - Teen"
 +
*4 "M - Mature"
 +
*5 "A - Adult"
 +
===mt===
 +
*0 unknown
 +
*1 "H-Game"
 +
*2 $LANGARRAY['ANIME']
 +
*3 $LANGARRAY['VIDEOG']
 +
*4 $LANGARRAY['VISUALNOVEL']
 +
*5 $LANGARRAY['MANGA']
 +
*6 $LANGARRAY['ARTIS']
 +
*7 $LANGARRAY['MOVIE']
 +
*8 $LANGARRAY['OVA']
 +
*9 "Other"
 +
*10 "Franchise"
 +
*11 "Drama CD"
 +
*12 "ONA - Original Net Animation"
 +
*13 "Light Novel"
 +
*14 "Western Animation"
 +
*15 "Cartoon"
 +
*16 "Web Toon"
 +
*17 "Fusion (Live Action + CGI)"
 +
*18 "Live Action + CGI"
 +
*19 "Web Comic"
 +
*20 "Blended (Cell and; Live Action)"
 +
*21 "CGI"
 +
*22 "Animated TV Series"
 +
*23 "Animated Movie"
 +
===eechi===
 +
*0 Safe
 +
*1 Questionable
 +
*2 Adults Only
 +
 +
==maiwaifu==
 +
===status1===
 +
NTR Counter
 +
===status2===
 +
*0 NTR
 +
*1 Claimed
 +
===status3===
 +
Current Time Held
 +
===status4===
 +
Total Time Held ( not including status3 )
 +
===status5===
 +
*0
 +
*1 Favorite
 +
===status6===
 +
Happiness Meter
 +
 +
==maiimouto==
 +
===status1===
 +
NTR Counter
 +
===status2===
 +
*0 NTR
 +
*1 Claimed
 +
===status3===
 +
Current Time Held
 +
===status4===
 +
Total Time Held ( not including status3 )
 +
===status5===
 +
*0
 +
*1 Favorite
 +
===status6===
 +
Happiness Meter
 +
 +
==extra_details==
 +
===type_id===
 +
*1 Characters
 +
*2 Source
 +
 +
===status===
 +
*0
 +
 +
==relations==
 +
===special_type===
 +
*0
 +
 +
==api_images==
 +
===type_id===
 +
*1 characters
 +
*2 source
 +
*3
 +
*72
 +
*77
 +
*99
 +
*111 verify character ( PROVE IT )
 +
*127
 +
 +
===status===
 +
*-1 Deleted
 +
*0 Approved
 +
*1 Pending Approval
 +
 +
===nsfw===
 +
*0 Safe
 +
*1 Questionable
 +
*2 Adults Only
 +
 +
==myints==
 +
*0 = lounge
 +
*1 = fav chars
 +
*2 = fav series
 +
*3 = fav va's
 +
*4 = channel_id
 +
*9 Front Page Preferences

Revision as of 04:25, 10 November 2021

Much of our table data uses numbers with special meanings. I will identify those here.

characters

sex

  • 1 Male
  • 2 Female
  • 3 UNKNOWN/AMBIGUOUS
  • 4 Androgynous
  • 5 None
  • 6 Many

eye_color

  • 1 Black
  • 3 Blue
  • 4 Brown
  • 5 Green
  • 6 Gray
  • 7 Orange
  • 8 Purple
  • 9 Red
  • 10 White
  • 11 Yellow
  • 12 Pink
  • 14 Blue-Green
  • 20 Not Visible

hair_color

  • 1 Black
  • 2 Blonde/Yellow
  • 3 Blue
  • 4 Brown
  • 5 Green
  • 6 Gray
  • 7 Orange
  • 8 Purple
  • 9 Red
  • 10 White
  • 11 Yellow
  • 12 Pink
  • 13 Maroon
  • 14 Blue-Green
  • 20 Not Visible

hair_length

  • 1 No Hair
  • 2 To Ears
  • 3 To neck
  • 4 To Shoulders
  • 5 To Chest
  • 6 To Waist
  • 7 Past Waist
  • 8 Hair up

age

  • 1 Child
  • 3 Teen
  • 4 Adult
  • 5 Senior
  • 6 Ageless

refs

Rarely used as a secondary hair color.

  • 1 "Fuchsia"
  • 2, "Light Purple/Pink"
  • 3, "Yellow"
  • 4, "Strawberry Blonde"
  • 5, "Platinum Blonde"
  • 6, "Copper"
  • 7, "Solid Black"
  • 8, "Gray Black"
  • 9, "Blue Black"
  • 10, "Brown Black"
  • 11, "Very Red Pink"

mimikko

Non human ears.

  • 1 No
  • 2 Yes

otherchar

Type of character.

  • 0, "Normal"
  • 1, "Animal"
  • 2, "Non-Human"
  • 3, "In Armor"
  • 4, "Other"
  • 5, "Game / Not Anime-Style Animation"
  • 9, "Manga"

clonetype

  • 0,"Select How to Handle Duplicate");
  • 1,"Same Name, Different Traits");
  • 2,"Same Traits, Different Name");
  • 3,"Different Name and Different Traits");
  • 4,"Same name and traits");
  • 5,"Complete Duplicate");
  • 6,"Updated Version");

role

  • 0 unsorted
  • 1 "$LANGARRAY[EXTRAS]";
  • 2 "$LANGARRAY[SUBCHAR]";
  • 5 "Supporting";
  • 7 "Main Character";
  • 8 "Deuteragonist";
  • 9 "Antagonist";
  • 10 "Protagonist";

esbr

  • 0 Safe
  • 1 Questionable
  • 2 Adults Only

clothing

  • 1, $LANGARRAY['MAID']);
  • 33, $LANGARRAY['WAITRESS']);
  • 24, $LANGARRAY['WHITELABCOAT']);
  • 2, $LANGARRAY['SCHOOLUNI']);
  • 6, $LANGARRAY['GOTHI']);
  • 29, $LANGARRAY['NURSE']);
  • 31, $LANGARRAY['NUN']);
  • 30, "Preist");
  • 3, $LANGARRAY['CASUALC']);
  • 26, $LANGARRAY['SHORTSA']);
  • 27, $LANGARRAY['PANTSANDT-']);
  • 28, $LANGARRAY['PANTSANDDR']);
  • 35, $LANGARRAY['PANTSANDLO']);
  • 32, $LANGARRAY['JEANSANDT-SHIR']);
  • 11, $LANGARRAY['SUITANDTIE']);
  • 34, $LANGARRAY['SUITAND']);
  • 4, "Swimsuit");
  • 25, "Bikini");
  • 5, "Mini Skirt");
  • 22, "Skirt");
  • 19, "Dress");
  • 7, "Traditional");
  • 8, "Japanese Kimono");
  • 12, "Shrine Maiden");
  • 13, "Chinese Dress");
  • 14, "Martial Arts Uniform");
  • 9, "Fantasy");
  • 10, "Armor");
  • 15, "Mage Clothing");
  • 16, "Mechanic Clothes");
  • 17, "Military Uniform");
  • 18, $LANGARRAY['PIOL']);
  • 20, "Jacket");
  • 21, "Winter Jacket");
  • 23, "Other");

db_tags

Character tags are stored here. Assignments go in c_tags

tag_status

  • -1 Blocked
  • 0 Active

api_favs

type_id

  • 1 characters
  • 2 series
  • 3 va
  • 9 Guild images
  • 11 images
  • 12
  • 98 ninbu
  • 99 quotes
  • 255

publishers

cr

  • 1 "E - Everyone"
  • 2 "E10+ - Everyone ten and up"
  • 3 "T - Teen"
  • 4 "M - Mature"
  • 5 "A - Adult"

mt

  • 0 unknown
  • 1 "H-Game"
  • 2 $LANGARRAY['ANIME']
  • 3 $LANGARRAY['VIDEOG']
  • 4 $LANGARRAY['VISUALNOVEL']
  • 5 $LANGARRAY['MANGA']
  • 6 $LANGARRAY['ARTIS']
  • 7 $LANGARRAY['MOVIE']
  • 8 $LANGARRAY['OVA']
  • 9 "Other"
  • 10 "Franchise"
  • 11 "Drama CD"
  • 12 "ONA - Original Net Animation"
  • 13 "Light Novel"
  • 14 "Western Animation"
  • 15 "Cartoon"
  • 16 "Web Toon"
  • 17 "Fusion (Live Action + CGI)"
  • 18 "Live Action + CGI"
  • 19 "Web Comic"
  • 20 "Blended (Cell and; Live Action)"
  • 21 "CGI"
  • 22 "Animated TV Series"
  • 23 "Animated Movie"

eechi

  • 0 Safe
  • 1 Questionable
  • 2 Adults Only

maiwaifu

status1

NTR Counter

status2

  • 0 NTR
  • 1 Claimed

status3

Current Time Held

status4

Total Time Held ( not including status3 )

status5

  • 0
  • 1 Favorite

status6

Happiness Meter

maiimouto

status1

NTR Counter

status2

  • 0 NTR
  • 1 Claimed

status3

Current Time Held

status4

Total Time Held ( not including status3 )

status5

  • 0
  • 1 Favorite

status6

Happiness Meter

extra_details

type_id

  • 1 Characters
  • 2 Source

status

  • 0

relations

special_type

  • 0

api_images

type_id

  • 1 characters
  • 2 source
  • 3
  • 72
  • 77
  • 99
  • 111 verify character ( PROVE IT )
  • 127

status

  • -1 Deleted
  • 0 Approved
  • 1 Pending Approval

nsfw

  • 0 Safe
  • 1 Questionable
  • 2 Adults Only

myints

  • 0 = lounge
  • 1 = fav chars
  • 2 = fav series
  • 3 = fav va's
  • 4 = channel_id
  • 9 Front Page Preferences