Table Numbers

From Anime Characters Database Wiki
Jump to navigation Jump to search

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

characters[edit]

sex[edit]

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

eye_color[edit]

  • 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[edit]

  • 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[edit]

  • 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[edit]

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

refs[edit]

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[edit]

Non human ears.

  • 1 No
  • 2 Yes

otherchar[edit]

Type of character.

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

clonetype[edit]

  • 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[edit]

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

esbr[edit]

  • 0 Safe
  • 1 Questionable
  • 2 Adults Only

clothing[edit]

  • 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[edit]

Character tags are stored here. Assignments go in c_tags

tag_status[edit]

  • -1 Blocked
  • 0 Active

api_favs[edit]

type_id[edit]

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

publishers[edit]

cr[edit]

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

mt[edit]

  • 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[edit]

  • 0 Safe
  • 1 Questionable
  • 2 Adults Only

maiwaifu[edit]

status1[edit]

NTR Counter

status2[edit]

  • 0 NTR
  • 1 Claimed

status3[edit]

Current Time Held

status4[edit]

Total Time Held ( not including status3 )

status5[edit]

  • 0
  • 1 Favorite

status6[edit]

Happiness Meter

maiimouto[edit]

status1[edit]

NTR Counter

status2[edit]

  • 0 NTR
  • 1 Claimed

status3[edit]

Current Time Held

status4[edit]

Total Time Held ( not including status3 )

status5[edit]

  • 0
  • 1 Favorite

status6[edit]

Happiness Meter

extra_details[edit]

type_id[edit]

  • 1 Characters
  • 2 Source

status[edit]

  • 0

relations[edit]

special_type[edit]

  • 0

api_images[edit]

type_id[edit]

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

status[edit]

  • -1 Deleted
  • 0 Approved
  • 1 Pending Approval

nsfw[edit]

  • 0 Safe
  • 1 Questionable
  • 2 Adults Only

myints[edit]

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

sandbox[edit]

sandbox_extra1[edit]

  • 0 new
  • 1 Approved
  • 2 Rejected
  • 3 Deleted