Nintendo 3DS Central Database Statistics

[Tiger21820]

This topic will list all maximum IDs for each SQL database table! This list does not reflect the current number of rows for each table, only the highest ID that a table has! This topic will be updated periodically! Tables that are bolded red are unused, or disabled!

Updated: January 19, 2025, 07:10 (UTC -6)
Total Last Calculated: January 11, 2025, 08:45 (UTC -6)

Total Rows: 873591

Total Users: 198
Total Forums: 108
Total Topics: 1860
Total Posts: 11644
Total User Groups: 12
Total Attachments: 321
Total Private Messages: 1072
Total Private Message Folders: 56
Total Private Message Rules: 5
Total Drafts: 39
Total Bans: 1079
Total Warnings: 125
Total Reports: 44
Total Report Reasons: 13
Total Bots: 65
Total BBCodes: 101
Total Smilies: 523
Total Smiley Categories: 39
Total Forum Icons: 27
Total Censored Words: 38
Total Disallowed Usernames: 18
Total Profile Fields: 26
Total Ranks: 35
Total CAPTCHA Questions: 2
Total CAPTCHA Sortable Questions: 5
Total CAPTCHA Sortable Answers: 97775
Total File Extensions: 65
Total File Extension Groups: 10
Total Sites Defined: 6
Total Logs: 22670
Total Notifications: 32773
Total Notification Types: 64
Total Styles: 44
Total Languages: 14
Total Modules: 609
Total ACL Options: 387
Total Search Words: 187417
Total Permission Roles: 59
Total Teampages: 3
Total Topic Prefixes: 82
Total Knowledge Base Articles: 37
Total Knowledge Base Categories: 7
Total mChat Messages: 1597
Total mChat Logs: 319
Total Ultimate Point Logs: 611
Total Ultimate Point Bank Accounts: 45
Total Ultimate Point Lottery Tickets: 343908
Total Ultimate Point Lottery Logs: 5240
Total YouTube Video Gallery Videos: 667
Total YouTube Video Gallery Comments: 23
Total YouTube Video Gallery Categories: 21
Total DM Quotes: 289
Total DM Downloads: 29
Total DM Download Categories: 12
Total DM Partners: 6
Total DM Puzzles: 87
Total Ultimate Blogs: 21
Total Ultimate Blog Comments: 23
Total Ultimate Blog Categories: 5
Total Ultimate Blog Edits: 17
Total Ultimate Blog Reports: 32
Total Referrals: 71
Total Referral Contests: 32
Total Member Profile View Counters: 2394
Total Who Visited This Topic Counters: 14642
Total User Download Log Counters: 568
Total Hangman Words: 1654
Total MOT Hangman Words: 47109
Total MOT Hangman Fame Entries: 306
Total MOT Hangman Fame Months: 15
Total MOT Hangman Fame Years: 6
Total MOT Sudoku Classic Puzzles: 5072
Total MOT Sudoku Samurai Puzzles: 412
Total MOT Sudoku Ninja Puzzles: 143
Total MOT Sudoku Puzzle Packs: 204
Total MOT Sudoku Games: 271
Total MOT Sudoku Fame Entries: 202
Total MOT Sudoku Fame Months: 27
Total MOT Sudoku Fame Years: 21
Total FontAwesome Icons: 718
Total FontAwesome Icons (Obsolete Table): 585
Total Flags: 233
Total Ads: 15
Total Profile Flair: 87
Total Profile Flair Categories: 12
Total Profile Flair Notifications: 981
Total Auto-Groups: 1
Total Auto-Group Types: 5
Total Form Maker Forms: 20
Total User Map Layers: 6
Total User Map POIs: 79
Total Tour Destinations: 5
Total Tour Destination Categories: 27
Total Tour Destination Countries: 18
Total Tour Destination Regions: 27
Total Tour Destination WLAN Options: 20
Total Pastebin Entries: 31
Total Board Announcements: 5
Total Who Was Here Users: 171079
Total OXPUS Downloads: 69
Total OXPUS Download Categories: 11
Total OXPUS Download Comments: 12
Total OXPUS Download Fields: 2
Total OXPUS Download Images: 6
Total OXPUS Download Statistic Entries: 5872
Total OXPUS Download Favorites: 801
Total OXPUS Download Versions: 4
Total OXPUS Download Version Files: 4
Total OXPUS Download Bug Tracker Reports: 24
Total OXPUS Download Bug Histories: 98
Total Portal Modules: 38
Total RPG Character Presets (Unused): 1
Total RPG Groups: 2
Total RPG Races: 13
Total RPG Occupations: 23
Total RPG Occupation Classes: 8
Total RPG Weapons: 14
Total RPG Item Categories: 16
Total RPG Items: 127
Total RPG Inventory Items: 407
Total RPG Properties: 3
Total RPG Events: 10
Total RPG Weather Events: 3
Total Gallery Albums: 76
Total Gallery Images: 459
Total Gallery Comments: 41
Total Gallery Contests: 7
Total Gallery Watches: 750
Total Gallery Favorites (Unused): 3
Total Gallery Reports: 6
Total Gallery Logs: 160
Total Gallery Permissions: 521
Total Gallery Permission Roles: 39
Total Quizzes: 9
Total Quiz Categories: 12
Total Quiz Questions: 15
Total Quiz Statistic Entries: 177
Total Quiz Sessions: 111
Total Header Images: 2
Total F1 Races: 59
Total F1 Teams: 18
Total F1 Drivers: 98
Total F1 Bets: 362
Total F1 Results: 336
Total Calendar Listed Events: 10
Total Calendar Events: 6
Total Calendar Special Days: 10
Total Calendar Configurations: 26
Total Notes: 3
Total AI Labs Jobs (Extension Disabled): 109