Difference between revisions of "Table Numbers"
								
								Jump to navigation
				Jump to search
				
				
		
					
								
							
		 (→type_id)  | 
				|||
| (10 intermediate revisions by the same user not shown) | |||
| Line 90: | Line 90: | ||
===clonetype===  | ===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===  | ===role===  | ||
| + | *0 unsorted  | ||
| + | *1 "$LANGARRAY[EXTRAS]";  | ||
| + | *2 "$LANGARRAY[SUBCHAR]";  | ||
| + | *5 "Supporting";  | ||
| + | *7 "Main Character";  | ||
| + | *8 "Deuteragonist";  | ||
| + | *9 "Antagonist";  | ||
| + | *10 "Protagonist";  | ||
| + | |||
===esbr===  | ===esbr===  | ||
*0 Safe  | *0 Safe  | ||
| Line 97: | Line 114: | ||
===clothing===  | ===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 112: | Line 170: | ||
==publishers==  | ==publishers==  | ||
===cr===  | ===cr===  | ||
| + | *1 "E - Everyone"  | ||
| + | *2 "E10+ - Everyone ten and up"  | ||
| + | *3 "T - Teen"  | ||
| + | *4 "M - Mature"  | ||
| + | *5 "A - Adult"  | ||
===mt===  | ===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===  | ===eechi===  | ||
*0 Safe  | *0 Safe  | ||
| Line 120: | Line 207: | ||
==maiwaifu==  | ==maiwaifu==  | ||
===status1===  | ===status1===  | ||
| + | NTR Counter  | ||
===status2===  | ===status2===  | ||
| + | *0 NTR  | ||
| + | *1 Claimed  | ||
===status3===  | ===status3===  | ||
| + | Current Time Held  | ||
===status4===  | ===status4===  | ||
| + | Total Time Held ( not including status3 )  | ||
===status5===  | ===status5===  | ||
| + | *0  | ||
| + | *1 Favorite  | ||
===status6===  | ===status6===  | ||
| + | Happiness Meter  | ||
==maiimouto==  | ==maiimouto==  | ||
===status1===  | ===status1===  | ||
| + | NTR Counter  | ||
===status2===  | ===status2===  | ||
| + | *0 NTR  | ||
| + | *1 Claimed  | ||
===status3===  | ===status3===  | ||
| + | Current Time Held  | ||
===status4===  | ===status4===  | ||
| + | Total Time Held ( not including status3 )  | ||
===status5===  | ===status5===  | ||
| + | *0  | ||
| + | *1 Favorite  | ||
===status6===  | ===status6===  | ||
| + | Happiness Meter  | ||
==extra_details==  | ==extra_details==  | ||
| Line 140: | Line 243: | ||
===status===  | ===status===  | ||
| + | *0  | ||
==relations==  | ==relations==  | ||
===special_type===  | ===special_type===  | ||
| + | *0  | ||
==api_images==  | ==api_images==  | ||
| Line 152: | Line 257: | ||
*77  | *77  | ||
*99  | *99  | ||
| + | *111 verify character ( PROVE IT )  | ||
*127  | *127  | ||
| Line 163: | Line 269: | ||
*1 Questionable  | *1 Questionable  | ||
*2 Adults Only  | *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.
Contents
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