Table Numbers

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, Maid
• 33, Waitress
• 24, White Lab Coat
• 2, School Uniform
• 6, Gothic / Black / Dark
• 29, Nurse
• 31, Nun
• 30, Priest
• 3, Casual Clothes
• 26, Shorts and T-Shirt
• 27, Pants and T-Shirt
• 28, Pants and Dress Shirt
• 35, Pants and Long Sleeve Shirt
• 32, Jeans and T-Shirt
• 11, Suit and Tie
• 34, Suit and no Tie
• 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, Pilot Suit
• 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 "Anime"
• 3 "Video Game"
• 4 "Visual Novel"
• 5 "Manga"
• 6 "Artist Original"
• 7 "Movie"
• 8 "OVA"
• 9 "Other"
• 10 "Franchise"
• 11 "Voice Works"
• 12 "ONA"
• 13 "Light Novel"
• 14 "Western Animation"
• 15 "Cartoon"
• 16 "Web Toon"
• 17 "Donghua"
• 18 "Reserved"
• 19 "Web Comic"
• 20 "VTuber"
• 21 "CGI"
• 22 "Animated TV Series"
• 23 "Animated Movie"
• 24 "Artist CG"
• 25 "Mobile Game"
• 26 "Manhwa"

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

sandbox

sandbox_extra1

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

myhomepage

hp_id

• 1 Moderation
• 2 Character Tags
• 3 Watching
• 4 Family Tree
• 5 Chatbox
• 6 #ACDB Help Lounge
• 7 PM
• 8 COTM
• 9 Missed Char
• 10 Reminders
• 11 Latest Characters
• 12 Latest Titles
• 13 Index Images
• 14 Episodes
• 16 Character Extra
• 17 Series Extra
• 18 Reports
• 19 Promotions
• 20 Sandbox
• 21 Uploads
• 22 Shiritori
• 23 Comments
• 24 Today's Bonus
• 25 Series Tags
• 26 Mod Forum
• 27 My Contributions
• 28 Birthdays
• 29 Thousands
• 100 TOC

slayers

gem_type

• 1: return "Fighter";
• 2: return "Wizard";
• 3: return "Rogue";
• 4: return "Cleric";
• 5: return "Cook";