Transparency

What We Store

Every table in our database, live from the database itself. No curated screenshots, no hand-waving — just the raw schema with plain-English explanations of what each table is for. New tables and columns appear here automatically as we ship them.

We do not store your IP address, with one exception.

The only IP addresses we store belong to invited playtesters, recorded when they sign the playtester agreement and when they download a test build (see Playtest Program below). For everyone else, no table holds an IP address. Cloudflare, our hosting provider, may log IP addresses at the network level per their own privacy policy, but we do not receive, read, or store them ourselves.

How this page works

This page runs the following SQL query directly against our live Cloudflare D1 (SQLite) database every time it loads. The results drive the table list below — there is no manually maintained list that could get out of date.

SELECT name, sql FROM sqlite_master WHERE type='table' ORDER BY name

sqlite_master is SQLite's built-in system catalogue — it stores the schema of every object in the database. Read the SQLite docs on sqlite_master →

What we hide and why

The following tables are excluded from the display below. We explain exactly why each one is hidden.

Auth Accounts

This table stores the OAuth tokens issued by Discord and Twitch when you log in. We hide it because exposing its column structure would provide a roadmap for targeting our authentication system — not because we are concealing anything about what data we hold. These tokens are used only to maintain your session and are never read or shared for any other purpose.

Playtest Program

Only for members invited to playtest an unreleased game, who must sign a playtester agreement and NDA first. When they sign, we store the signing record: their full name, email address, Lich Souls account, Discord username, city and state or country, date of birth, typed signature, which version of the agreement they signed and the exact time, plus their IP address and browser, so the signature holds up later. We also keep each version of the agreement text, a log of which test builds each tester downloaded (with the IP address), and the builds themselves. We list these tables here instead of showing them because the game is unannounced and the table names would reveal it. Only Lich Souls Gaming admins can see this data, and it is never sold or shared.

All tables (95)

Click any table to expand its columns. Column names are shown as-is from the database; the sanitised label is shown for readability.

Audit Trailaudit_trail

Column	Type	Notes
id	Number
actor_lsg_id	Text	Internal identifier
actor_name	Text
action	Text
target_type	Text
target_id	Text	Internal identifier
target_name	Text
changes	Text
metadata	Text
created_at	Number	Timestamp

Auth Usersauth_users

Internal authentication record created when you first sign in. Stores your name and email address if Discord provided one during OAuth, plus your avatar URL.

Column	Type	Notes
id	Text
name	Text
email	Text	Email address, if provided by your OAuth provider
email_verified	Number
image	Text

Averrion Bug Report Messagesaverrion_bug_report_messages

Column	Type	Notes
id	Number
report_id	Number	Internal identifier
author_id	Text	Internal identifier
body	Text
staff_only	Number
is_system	Number	Yes/no flag
created_at	Number	Timestamp

Averrion Bug Reportsaverrion_bug_reports

Column	Type	Notes
id	Number
requester_id	Text	Internal identifier
requester_discord_id	Text	Discord user identifier
category	Text
title	Text
platform	Text
game_version	Text
details	Text
steps	Text
status	Text
staff_id	Text	Internal identifier
claimed_at	Number	Timestamp
resolved_at	Number	Timestamp
staff_note	Text
created_at	Number	Timestamp

Call Sessionscall_sessions

Records of voice calls between members — who initiated, who received, when the call started and ended, and the final call status.

Column	Type	Notes
id	Text
room_name	Text
initiator_id	Text	Internal identifier
recipient_id	Text	Internal identifier
conversation_id	Number	Internal identifier
status	Text
created_at	Number	Timestamp
answered_at	Number	Timestamp
ended_at	Number	Timestamp

Grimoire Campaign Memberscampaign_members

Which players staff have added to each Prestige Encounters campaign, who added them, and when.

Column	Type	Notes
campaign_id	Number	Internal identifier
lsg_id	Text	Site user identifier
added_by	Text
added_at	Number	Timestamp

Grimoire Campaignscampaigns

Prestige Encounters campaigns created by staff: name, description, which one is live on stream, and when it was created or archived.

Column	Type	Notes
id	Number
slug	Text
name	Text
description	Text
is_live	Number	Yes/no flag
--	the
created_by	Text
--	lsg_id
or	'system'

Conversation Participantsconversation_participants

Tracks which members belong to each direct message conversation thread, and each participant's last-read position.

Column	Type	Notes
conversation_id	Number	Internal identifier
user_id	Text	Internal identifier
last_read_msg_id	Number	Internal identifier
joined_at	Number	Timestamp

Conversationsconversations

Metadata for direct message threads (creation time, last message timestamp). Does not store message content — that lives in Direct Messages.

Column	Type	Notes
id	Number
name	Text
created_at	Number	Timestamp
last_msg_at	Number	Timestamp

D1 Migrationsd1_migrations

Column	Type	Notes
id	Number
name	Text
applied_at	TIMESTAMP	Timestamp

Direct Messagesdirect_messages

Your private message content, encrypted at rest using AES-256-GCM (Warden). Soft-deleted messages leave a tombstone so both sides see "This message was deleted." See our Privacy Policy for full encryption details.

Column	Type	Notes
id	Number
conversation_id	Number	Internal identifier
author_id	Text	Internal identifier
content	Text
image_key	Text
created_at	Number	Timestamp
deleted_at	Number	Timestamp
warded	Number	Yes/no flag

Dragonwilds Applicationsdragonwilds_applications

Column	Type	Notes
id	Number
applicant_id	Text	Internal identifier
reviewer_id	Text	Internal identifier
character_name	Text
discord_username	Text
experience	Text
playstyles	Text
play_times	Text
referral	Text
about	Text
rules_accepted	Number
status	Text
review_note	Text
reviewed_at	Number	Timestamp
created_at	Number	Timestamp

Dragonwilds Configdragonwilds_config

Column	Type	Notes
id	Number
password	Text
updated_by	Text
updated_at	Number	Timestamp

Event Rsvpsevent_rsvps

Column	Type	Notes
event_id	Number	Internal identifier
lsg_id	Text	Site user identifier
name	Text
status	Text
created_at	Number	Timestamp

Eventsevents

Column	Type	Notes
id	Number
title	Text
description	Text
community	Text
starts_at	Number	Timestamp
ends_at	Number	Timestamp
location	Text
created_by	Text
created_by_name	Text
discord_event_id	Text	Internal identifier
discord_event_url	Text
created_at	Number	Timestamp

Friendshipsfriendships

Friend connections between members, including pending requests, accepted friendships, and blocks.

Column	Type	Notes
requester_id	Text	Internal identifier
addressee_id	Text	Internal identifier
status	Text
created_at	Number	Timestamp

Game High Scoresgame_high_scores

Column	Type	Notes
id	Number
game_id	Text	Internal identifier
lsg_id	Text	Site user identifier
score	Number
floor_reached	Number
kills	Number
gold	Number
hero_level	Number
difficulty	Text
achieved_at	Number	Timestamp
UNIQUE(game_id,	lsg_id,

Homebrew Dayshomebrew_days

Column	Type	Notes
id	Number
lsg_id	Text	Site user identifier
seed	Number
day	Number
earned	Number
tips	Number
drinks	Number
plates	Number
rooms	Number
storm_outs	Number
miscasts	Number
cleaned	Number
reputation	Number
chaos_peak	Number
ended_early	Number
secrets	Number
quests_returned	Number
loot	Number
heart_lost	Text
created_at	Number	Timestamp

Homebrew Runshomebrew_runs

Column	Type	Notes
id	Number
lsg_id	Text	Site user identifier
seed	Number
days_survived	Number
total_earned	Number
best_rep	Number
ending	Text
trophies	Number
upgrades	Number
created_at	Number	Timestamp

Lichforge Auth Codeslichforge_auth_codes

Column	Type	Notes
code_hash	Text
lsg_id	Text	Site user identifier
client_id	Text	Internal identifier
redirect_uri	Text
code_challenge	Text
created_at	Number	Timestamp
expires_at	Number	Timestamp

Lichforge Device Codeslichforge_device_codes

Column	Type	Notes
device_hash	Text
user_code	Text
client_id	Text	Internal identifier
client_label	Text
lsg_id	Text	Site user identifier
status	Text
created_at	Number	Timestamp
expires_at	Number	Timestamp
last_poll_at	Number	Timestamp

Lichforge Sessionslichforge_sessions

Column	Type	Notes
id	Text
token_hash	Text
lsg_id	Text	Site user identifier
client_id	Text	Internal identifier
client_label	Text
created_at	Number	Timestamp
last_used_at	Number	Timestamp
expires_at	Number	Timestamp
revoked_at	Number	Timestamp

Modsmod_members

The site mods roster: names, handles, titles, teams, and profile images shown on the Mods page.

Column	Type	Notes
id	Number
name	Text
handle	Text
title	Text
bio	Text
image_url	Text
team	Text
sort_order	Number
is_active	Number	Yes/no flag
created_at	Number	Timestamp

Notificationsnotifications

In-site notifications delivered to your inbox — friend requests, wall activity, reactions, and similar events.

Column	Type	Notes
id	Number
user_id	Text	Internal identifier
actor_id	Text	Internal identifier
type	Text
data	Text
read_at	Number	Timestamp
created_at	Number	Timestamp

Overwatch Applicationsow_applications

Applications to join the LSG Overwatch competitive team, including availability, role preference, and SR history.

Column	Type	Notes
id	Number
applicant_id	Text	Internal identifier
name	Text
username	Text
desired_role	Text
plays_on_pc	Number	Yes/no flag
available_mondays	Number	Yes/no flag
available_tuesdays	Number	Yes/no flag
sr_tank	Number
sr_dps	Number
sr_support	Number
hero_main	Text
peak_sr	Number
peak_season	Text
is_18_or_older	Number	Yes/no flag
status	Text
reviewer_id	Text	Internal identifier
reviewed_at	Number	Timestamp
review_note	Text
created_at	Number	Timestamp

Overwatch Rosterow_roster

Current LSG Overwatch competitive team members, their roles, and roster slot assignments.

Column	Type	Notes
id	Number
slot_number	Number
username	Text
status	Text
roles	Text
is_captain	Number	Yes/no flag
is_vice_captain	Number	Yes/no flag
added_at	Number	Timestamp

Pe Character Attackspe_character_attacks

Column	Type	Notes
id	Number
character_id	Number	Internal identifier
name	Text
attack_bonus	Number
damage_dice	Text
damage_type	Text
mastery_property	Text
range	Text
notes	Text
sort_order	Number
action_type	Text
damage_parts	Text
versatile	Number
versatile_damage_parts	Text
thrown	Number
thrown_range	Text
weapon_properties	Text
weapon_range_type	Text
is_active	Number	Yes/no flag
favorite	Number
quick_description	Text
weapon_category	Text
is_pact_weapon	Number	Yes/no flag
manual_override	Number
linked_ammo_item_id	Number	Internal identifier

Pe Character Classespe_character_classes

Column	Type	Notes
id	Number
character_id	Number	Internal identifier
class_name	Text
class_level	Number
class_description	Text
subclass	Text
subclass_description	Text
sort_order	Number
subclasses	Text
class_id	Number	Internal identifier
class_choices	Text

Pe Character Effectspe_character_effects

Column	Type	Notes
id	Number
character_id	Number	Internal identifier
name	Text
description	Text
source_type	Text
source_id	Number	Internal identifier
is_toggleable	Number	Yes/no flag
is_active	Number	Yes/no flag
auto_managed	Number
modifiers	Text
sort_order	Number
favorite	Number
quick_description	Text
show_on_active	Number
is_permanent	Number	Yes/no flag
source_class_item_id	Number	Internal identifier
granted_at_level	Number

Pe Character Featurespe_character_features

Column	Type	Notes
id	Number
character_id	Number	Internal identifier
name	Text
source	Text
description	Text
sort_order	Number
uses_max	Number
uses_used	Number
recharge	Text
roll_dice	Text
feature_type	Text
is_active	Number	Yes/no flag
linked_resource_id	Number	Internal identifier
resource_cost	Number
damage_parts	Text
is_heal	Number	Yes/no flag
resource_mode	Text
heal_as_temp	Number
favorite	Number
quick_description	Text
targetable	Number
roll_groups	Text
source_class_item_id	Number	Internal identifier
granted_at_level	Number

Pe Character Inventorype_character_inventory

Column	Type	Notes
id	Number
character_id	Number	Internal identifier
name	Text
quantity	Number
weight	Decimal
equipped	Number
description	Text
sort_order	Number
item_type	Text
requires_attunement	Number
attuned	Number
ac_bonus	Number
attack_bonus	Number
damage_parts	Text
mastery_property	Text
weapon_range	Text
heal_dice	Text
linked_attack_id	Number	Internal identifier
weapon_properties	Text
linked_effect_id	Number	Internal identifier
equippable	Number
modifiers	Text
uses_max	Number
uses_used	Number
recharge	Text
recharge_dice	Text
weapon_category	Text
armor_category	Text
weapon_range_type	Text
favorite	Number
quick_description	Text
is_pact_weapon	Number	Yes/no flag
stealth_disadvantage	Number
versatile	Number
versatile_damage_parts	Text
thrown	Number
thrown_range	Text
sub_category	Text
focus_type	Text
focus_classes	Text
is_magical	Number	Yes/no flag
is_container	Number	Yes/no flag
rarity	Text
value	Decimal
modifier_to_hit	Number
modifier_attack_damage	Number
modifier_spell_damage	Number
heal_flat	Number
heal_mode	Text
heal_as_temp	Number
show_on_active	Number
modifier_spell_to_hit	Number
resistances	Text
save_dc	Number
attunement_classes	Text
deals_damage	Number
container_id	Number	Internal identifier
carry_weight_exempt	Number
modifier_scope	Text
save_ability	Text
modifier_to_hit_global	Number
modifier_attack_damage_global	Number

Pe Character Resourcespe_character_resources

Column	Type	Notes
id	Number
character_id	Number	Internal identifier
name	Text
max	Number
used	Number
recharge	Text
sort_order	Number
max_source	Text
max_source_class	Text
max_source_multiplier	Number
source_class_item_id	Number	Internal identifier
granted_at_level	Number

Pe Character Spellspe_character_spells

Column	Type	Notes
id	Number
character_id	Number	Internal identifier
name	Text
level	Number
school	Text
casting_time	Text
range	Text
components	Text
duration	Text
description	Text
prepared	Number
always_prepared	Number
sort_order	Number
damage	Text
damage_type	Text
save_ability	Text
is_attack	Number	Yes/no flag
action_type	Text
damage_parts	Text
is_ritual	Number	Yes/no flag
concentration	Number
action_types	Text
aoe_size	Text
aoe_shape	Text
save_dc_override	Number
is_heal	Number	Yes/no flag
heal_flat	Number
extra_damage_parts	Text
extra_damage_label	Text
higher_level_dice	Text
add_spellcasting_mod	Number
linked_resource_id	Number	Internal identifier
resource_cost	Number
extra_damage_groups	Text
heal_as_temp	Number
favorite	Number
quick_description	Text
scales_with_level	Number
level_scaling	Text
heal_mode	Text
linked_item_id	Number	Internal identifier
spell_classes	Text
multi_damage_types	Text
linked_item_charge_cost	Number

Pe Dm Settingspe_dm_settings

Column	Type	Notes
key	Text
value	Text

Pe Fund Transactionspe_fund_transactions

Column	Type	Notes
id	Number
currency	Text
amount	Number
reason	Text
actor_lsg_id	Text	Internal identifier
actor_name	Text
created_at	Number	Timestamp
pool	Text
campaign_id	Number	Internal identifier

Pe Heal Requestspe_heal_requests

Column	Type	Notes
id	Number
target_character_id	Number	Internal identifier
source_character_id	Number	Internal identifier
source_name	Text
rolled_amount	Number
status	Text
resolved_amount	Number
requested_by	Text
resolved_by	Text
created_at	Number	Timestamp
resolved_at	Number	Timestamp
is_temp	Number	Yes/no flag

Pe Initiative Entriespe_initiative_entries

Column	Type	Notes
id	Number
character_id	Number	Internal identifier
display_name	Text
is_npc	Number	Yes/no flag
initiative_value	Number
sort_order	Number
created_at	Number	Timestamp
campaign_id	Number	Internal identifier

Pe Initiative Statepe_initiative_state

Column	Type	Notes
campaign_id	Number	Internal identifier
round	Number
current_entry_id	Number	Internal identifier
turn_started_at	Number	Timestamp

Pe Party Fundspe_party_funds

Column	Type	Notes
campaign_id	Number	Internal identifier
cp	Number
sp	Number
ep	Number
gp	Number
pp	Number
keep_cp	Number
keep_sp	Number
keep_ep	Number
keep_gp	Number
keep_pp	Number
party_storage	Text
keep_storage	Text

Prestige Encounters Questionspe_questions

Application questions used in the Prestige Encounters D&D campaign intake form.

Column	Type	Notes
id	Number
name	Text
target_name	Text
question	Text
reviewed	Number	Yes/no flag
created_at	Number	Timestamp

Pe Repositorype_repository

Column	Type	Notes
id	Number
kind	Text
name	Text
name_norm	Text
data	Text
created_by	Text
created_at	Number	Timestamp
status	Text
locked	Number

Pe Roll Logpe_roll_log

Column	Type	Notes
id	Number
character_id	Number	Internal identifier
character_name	Text
roll_type	Text
label	Text
expression	Text
breakdown	Text
total	Number
is_whisper	Number	Yes/no flag
actor_lsg_id	Text	Internal identifier
created_at	Number	Timestamp
campaign_id	Number	Internal identifier

Pe Stream Seatspe_stream_seats

Column	Type	Notes
seat	Number
character_id	Number	Internal identifier

Pe Table Chatpe_table_chat

Column	Type	Notes
id	Number
sender_lsg_id	Text	Internal identifier
sender_name	Text
sender_is_dm	Number
character_id	Number	Internal identifier
body	Text
whisper	Text
recipient_lsg_id	Text	Internal identifier
recipient_name	Text
created_at	Number	Timestamp
campaign_id	Number	Internal identifier

Pe Unclaimed Itemspe_unclaimed_items

Column	Type	Notes
id	Number
name	Text
category	Text
location	Text
description	Text
quantity	Number
weight	Decimal
sort_order	Number
created_at	Number	Timestamp
campaign_id	Number	Internal identifier

Postsposts

Community posts and news articles published on the site — developer updates, clan news, and announcements.

Column	Type	Notes
id	Number
slug	Text
type	Text
title	Text
date	Text
author	Text
author_handle	Text
tags	Text
excerpt	Text
content	Text
is_published	Number	Yes/no flag
created_at	Number	Timestamp
updated_at	Number	Timestamp
thumbs_up	Text
thumbs_down	Text
community	Text

Prestige Charactersprestige_characters

Column	Type	Notes
id	Number
character_name	Text
race	Text
total_level	Number
class_levels	Text
nat_20s	Number
nat_1s	Number
kills	Number
incapacitated	Number
deaths	Number
current_health	Number
max_health	Number
temp_hp	Number
status_effects	Text
player_notes	Text
active	Number
character_image_url	Text
sequence	Number
disease_summary	Text
discordId	Text
str_score	Number
dex_score	Number
con_score	Number
int_score	Number
wis_score	Number
cha_score	Number
description	Text
campaign_id	Number	Internal identifier
share_health	Number
ac	Number
initiative_bonus	Number
speed	Number
proficiency_bonus	Number
hit_dice	Text
alignment	Text
background	Text
size	Text
languages	Text
skill_proficiencies	Text
save_proficiencies	Text
spell_slots	Text
spellcasting_ability	Text
ac_base	Number
ac_armor	Number
ac_shield	Number
ac_other	Number
cp	Number
sp	Number
ep	Number
gp	Number
pp	Number
senses	Text
weapon_proficiencies	Text
armor_proficiencies	Text
tool_proficiencies	Text
damage_resistances	Text
damage_vulnerabilities	Text
damage_immunities	Text
condition_immunities	Text
inspiration	Number
swim_speed	Number
fly_speed	Number
climb_speed	Number
hit_dice_pool	Text
death_save_successes	Number
death_save_failures	Number
deceased	Number
spell_slot_refresh	Text
other_senses	Text
languages_list	Text
weapon_proficiencies_list	Text
armor_proficiencies_list	Text
tool_proficiencies_list	Text
species_description	Text
background_description	Text
appearance	Text
gender	Text
eye_color	Text
height	Text
faith	Text
hair_color	Text
skin_color	Text
age	Text
weight	Text
attunement_slots	Number
max_prepared_spells	Number
max_prepared_cantrips	Number
hide_unarmed_strike	Number
background_id	Number	Internal identifier
background_choices	Text
species_id	Number	Internal identifier
species_choices	Text
max_known_spells	Number
max_known_cantrips	Number
pronouns	Text
player_name	Text
hidden_from_players	Number
owner_lsg_id	Text	Internal identifier
origin_character_id	Number	Internal identifier

Profile Cosmetic Ownedprofile_cosmetic_owned

Column	Type	Notes
lsg_id	Text	Site user identifier
cosmetic_key	Text
acquired_at	Number	Timestamp

Profile Slug Historyprofile_slug_history

A log of previous profile URL slugs you have used. Retained so others cannot immediately claim your old username after you change it.

Column	Type	Notes
old_slug	Text
lsg_id	Text	Site user identifier
changed_at	Number	Timestamp

Profile Visitsprofile_visits

Column	Type	Notes
profile_lsg_id	Text	Internal identifier
visitor_hash	Text
visit_day	Number

Raffle Drawsraffle_draws

Column	Type	Notes
id	Number
prize_id	Number	Internal identifier
draw_number	Number
winner_lsg_id	Text	Internal identifier
drawn_by	Text
drawn_at	Number	Timestamp

Raffle Entriesraffle_entries

Column	Type	Notes
id	Number
prize_id	Number	Internal identifier
lsg_id	Text	Site user identifier
tickets	Number
created_at	Number	Timestamp

Raffle Eventsraffle_events

Column	Type	Notes
id	Number
slug	Text
title	Text
description	Text
drawing_at	Number	Timestamp
status	Text
created_by	Text
created_at	Number	Timestamp
updated_at	Number	Timestamp

Raffle Prizesraffle_prizes

Column	Type	Notes
id	Number
event_id	Number	Internal identifier
name	Text
quantity	Number
us_only	Number
sort_order	Number
created_at	Number	Timestamp

Rolesroles

Column	Type	Notes
id	Number
name	Text
display_name	Text
description	Text
color	Number
discord_role_id	Text	Internal identifier
sort_order	Number
created_at	Number	Timestamp
updated_at	Number	Timestamp
category	Text

Rs3 Clan Application Draftsrs3_clan_application_drafts

Column	Type	Notes
lsg_id	Text	Site user identifier
discord_id	Text	Discord user identifier
rsn	Text
requested_rank	Text
weapon_tier	Text
armor_tier	Text
stat_primary	Number
stat_defence	Number
stat_constitution	Number
stat_herblore	Number
stat_prayer	Number
stat_summoning	Number
stat_invention	Number
completed_milestones	Text
prereq_points	Number
bossing_points	Number
proof_urls	Text
updated_at	Number	Timestamp

Rs3 Clan Applicationsrs3_clan_applications

Column	Type	Notes
id	Number
lsg_id	Text	Site user identifier
discord_id	Text	Discord user identifier
rsn	Text
requested_rank	Text
weapon_tier	Text
armor_tier	Text
stat_primary	Number
stat_defence	Number
stat_constitution	Number
stat_herblore	Number
stat_prayer	Number
stat_summoning	Number
stat_invention	Number
completed_milestones	Text
prereq_points	Number
bossing_points	Number
proof_urls	Text
approved	Number
review_reason	Text
reviewed_by	Text
reviewed_at	Number	Timestamp
submitted_at	Number	Timestamp

Rs3 Mentor Request Messagesrs3_mentor_request_messages

Column	Type	Notes
id	Number
request_id	Number	Internal identifier
author_id	Text	Internal identifier
body	Text
staff_only	Number
is_system	Number	Yes/no flag
created_at	Number	Timestamp

Rs3 Mentor Requestsrs3_mentor_requests

Column	Type	Notes
id	Number
requester_id	Text	Internal identifier
requester_discord_id	Text	Discord user identifier
rsn	Text
category	Text
topic	Text
experience	Text
details	Text
availability	Text
status	Text
mentor_id	Text	Internal identifier
claimed_at	Number	Timestamp
resolved_at	Number	Timestamp
staff_note	Text
created_at	Number	Timestamp

Rs3 Monthly Xp Baseliners3_monthly_xp_baseline

Column	Type	Notes
player_name	Text
month_key	Text
baseline_xp	Number
captured_at	Number	Timestamp

Rs3 Pvm Bossesrs3_pvm_bosses

Column	Type	Notes
id	Number
slug	Text
name	Text
updated_at	Number	Timestamp
image_id	Text	Internal identifier

Rs3 Pvm Kill Timesrs3_pvm_kill_times

Column	Type	Notes
id	Number
boss_id	Number	Internal identifier
rank	Number
player_name	Text
kill_time	Text
updated_at	Number	Timestamp
UNIQUE(boss_id,	rank)

Rs3 Pvm Loadout Hotspotsrs3_pvm_loadout_hotspots

Column	Type	Notes
id	Number
loadout_id	Number	Internal identifier
x_pct	Decimal
y_pct	Decimal
label	Text
sort_order	Number

Rs3 Pvm Loadoutsrs3_pvm_loadouts

Column	Type	Notes
id	Number
boss_id	Number	Internal identifier
role_name	Text
sort_order	Number
min_gear	Text
min_levels	Text
inventory_setup	Text
image_id	Text	Internal identifier
updated_at	Number	Timestamp
UNIQUE(boss_id,	role_name)

Rs3 Pvm Mentorsrs3_pvm_mentors

Column	Type	Notes
id	Number
name	Text
title	Text
specialties	Text
discord_tag	Text
sort_order	Number
created_at	Number	Timestamp
updated_at	Number	Timestamp

RS3 Staff Applicationsrs3_staff_applications

Applications submitted to join the Undead Legion RS3 clan staff team.

Column	Type	Notes
id	Number
applicant_id	Text	Internal identifier
reviewer_id	Text	Internal identifier
rsn	Text
applied_role	Text
why_fit	Text
how_fulfill	Text
clan_improve	Text
status	Text
reviewed_at	Number	Timestamp
review_note	Text
created_at	Number	Timestamp

Scheduleschedule

The weekly stream schedule shown on the Schedule page — show name, day of week, time, description, and theme.

Column	Type	Notes
id	Number
day_of_week	Number
title	Text
time	Text
description	Text
tags	Text
theme	Text
updated_at	Number	Timestamp

Shop Fulfillment Requestsshop_fulfillment_requests

Column	Type	Notes
id	Number
requester_id	Text	Internal identifier
item_key	Text
kind	Text
is_usa	Number	Yes/no flag
full_name	Text
address_line1	Text
address_line2	Text
city	Text
state	Text
postal_code	Text
email	Text	Email address, if provided by your OAuth provider
lore_request	Text
status	Text
staff_id	Text	Internal identifier
staff_note	Text
claimed_at	Number	Timestamp
resolved_at	Number	Timestamp
created_at	Number	Timestamp

Sea of Thieves Applicationssot_applications

Applications to join the LSG Sea of Thieves guild, including gamertag, role preference, and playstyle.

Column	Type	Notes
id	Number
applicant_id	Text	Internal identifier
reviewer_id	Text	Internal identifier
gamertag	Text
discord_username	Text
age_confirmed	Number	Yes/no flag
role_preference	Text
owns_captained_ship	Number	Yes/no flag
playstyle	Text
status	Text
reviewed_at	Number	Timestamp
review_note	Text
created_at	Number	Timestamp
role_preferences	Text
region	Text
ship_preference	Text
pvp_rating	Number
internet_acknowledged	Number
rep_gold_hoarder	Number
rep_reapers_bones	Number
rep_merchant_alliance	Number
rep_order_of_souls	Number
rep_athenas_fortune	Number
rep_hunters_call	Number
rep_guardians_fortune	Number
rep_servants_flame	Number

Sea of Thieves Guild Configsot_guild_config

Guild-level configuration for the LSG Sea of Thieves guild (distinction level, max level, etc.).

Column	Type	Notes
key	Text
value	Text

Sea of Thieves Guild Memberssot_guild_members

Current LSG SoT guild members, their roster slots, roles, and ship assignments.

Column	Type	Notes
id	Number
slot_number	Number
gamertag	Text
role	Text
ship_name	Text
ship_type	Text
added_at	Number	Timestamp

Soul Purchasessoul_purchases

An audit log of every purchase made through the Souls shop — which item, how many souls were spent, and when.

Column	Type	Notes
id	Number
lsg_id	Text	Site user identifier
item_key	Text
souls_spent	Number
purchased_at	Number	Timestamp

Sqlite Sequencesqlite_sequence

Column	Type	Notes
name	Any
seq	Any

Studfinders Nightsstudfinders_nights

Column	Type	Notes
id	Number
lsg_id	Text	Site user identifier
seed	Number
night	Number
served	Number
perfect	Number
walkouts	Number
wrong	Number
sales	Number
tips	Number
best_streak	Number
cleaned	Number
groups	Number
bonus	Number
finished	Number
grade	Text
theme	Text
created_at	Number	Timestamp

Studfinders Runsstudfinders_runs

Column	Type	Notes
id	Number
lsg_id	Text	Site user identifier
seed	Number
nights_completed	Number
total_tips	Number
strikes	Number
perks	Number
created_at	Number	Timestamp

Tower Flame Messagestower_flame_messages

Column	Type	Notes
id	Number
run_id	Text	Internal identifier
lsg_id	Text	Site user identifier
class_id	Text	Internal identifier
message	Text
read_at	Number	Timestamp
created_at	Number	Timestamp

Tower Runstower_runs

Column	Type	Notes
id	Text
lsg_id	Text	Site user identifier
class_id	Text	Internal identifier
mode	Text
cycle	Number
seed	Number
started_at	Number	Timestamp
finished_at	Number	Timestamp
status	Text
reject_reason	Text
floor	Number
kills	Number
collected	Number
game_time	Decimal
reached_time	Decimal
ending	Text
path	Text
stats	Text
paused_ms	Number

Tower Savestower_saves

Column	Type	Notes
lsg_id	Text	Site user identifier
run_id	Text	Internal identifier
floor	Number
lives	Number
mid_floor	Number
--	1
--	RunSave
--	the
used	to
server	clock

User Profilesuser_profiles

Your profile: display name, bio, pronouns, timezone, in-game usernames, linked accounts, appearance settings, and privacy preferences.

Column	Type	Notes
lsg_id	Text	Site user identifier
discord_id	Text	Discord user identifier
display_name	Text
bio	Text
avatar_url	Text
banner_url	Text
pronouns	Text
timezone	Text
rs3_rsn	Text
minecraft_ign	Text
social_links	Text
favorite_games	Text
pinned_character_id	Number	Internal identifier
showcase_character_ids	Text
accent_color	Text
looking_for	Text
game_igns	Text
is_public	Number	Yes/no flag
created_at	Number	Timestamp
last_seen_at	Number	Timestamp
twitch_id	Text	Internal identifier
twitch_login	Text
privacy_settings	Text
account_restrictions	Text
last_active_at	Number	Timestamp
custom_slug	Text
discord_avatar_url	Text
is_verified	Number	Yes/no flag
verified_at	Number	Timestamp
verified_by	Text
slug_changed_at	Number	Timestamp
soul_unlocks	Text
grimble_welcomed	Number
raffle_tickets	Number
profile_cosmetics	Text
visitor_count	Number
minecraft_id	Text	Internal identifier
minecraft_name	Text

User Reportsuser_reports

Reports submitted against members for rule violations. Visible to staff only — regular members cannot read reports.

Column	Type	Notes
id	Number
reporter_id	Text	Internal identifier
reported_id	Text	Internal identifier
resolved_by	Text
reason	Text
description	Text
image_key	Text
status	Text
created_at	Number	Timestamp
resolved_at	Number	Timestamp
resolution_note	Text

User Rolesuser_roles

Column	Type	Notes
lsg_id	Text	Site user identifier
role_id	Number	Internal identifier
granted_by	Text
--	lsg_id

Wall Commentswall_comments

Comments left on profile wall posts.

Column	Type	Notes
id	Number
post_id	Number	Internal identifier
author_id	Text	Internal identifier
content	Text
created_at	Number	Timestamp

Wall Postswall_posts

Posts left on a member's public profile wall.

Column	Type	Notes
id	Number
subject_id	Text	Internal identifier
author_id	Text	Internal identifier
content	Text
created_at	Number	Timestamp

Wall Reactionswall_reactions

Emoji reactions left on profile wall posts.

Column	Type	Notes
post_id	Number	Internal identifier
user_id	Text	Internal identifier
emoji	Text

Wiki Articleswiki_articles

Individual wiki article pages: title, content, which wiki they belong to, and authorship metadata.

Column	Type	Notes
id	Number
slug	Text
category_id	Number	Internal identifier
title	Text
excerpt	Text
cover_image_url	Text
current_revision_id	Number	Internal identifier
created_by	Text
is_published	Number	Yes/no flag
is_deleted	Number	Yes/no flag
created_at	Number	Timestamp
updated_at	Number	Timestamp
parent_id	Number	Internal identifier
is_stub	Number	Yes/no flag
is_locked	Number	Yes/no flag
is_featured	Number	Yes/no flag
search_text	Text
wiki_id	Number	Internal identifier

Wiki Categorieswiki_categories

Category groupings used to organise articles within a wiki.

Column	Type	Notes
id	Number
slug	Text
name	Text
description	Text
icon	Text
--	lucide
created_at	Number	Timestamp
wiki_id	Number	Internal identifier

Wiki Commentswiki_comments

Comments left by members on wiki article pages.

Column	Type	Notes
id	Number
article_id	Number	Internal identifier
parent_id	Number	Internal identifier
content	Text
author_id	Text	Internal identifier
is_deleted	Number	Yes/no flag
created_at	Number	Timestamp
updated_at	Number	Timestamp

Wiki Linkswiki_links

Tracked internal links between wiki articles, powering "What links here" and backlink features.

Column	Type	Notes
source_article_id	Number	Internal identifier
target_article_slug	Text

Wiki Redirectswiki_redirects

Redirect rules that forward old article URLs to current titles after a rename.

Column	Type	Notes
from_slug	Text
to_slug	Text
created_by	Text
created_at	Number	Timestamp
wiki_id	Number	Internal identifier

Wiki Revisionswiki_revisions

Full revision history of every edit made to wiki articles — what changed, who changed it, and when.

Column	Type	Notes
id	Number
article_id	Number	Internal identifier
content	Text
edited_by	Text
edit_summary	Text
created_at	Number	Timestamp

Wiki Session Articleswiki_session_articles

Links between wiki articles and D&D campaign session logs.

Column	Type	Notes
session_id	Number	Internal identifier
article_id	Number	Internal identifier

Wiki Sessionswiki_sessions

D&D campaign session metadata stored alongside a wiki (session number, date, summary).

Column	Type	Notes
id	Number
campaign	Number
number	Number
title	Text
date	Text
summary	Text
content	Text
dm_notes	Text
created_by	Text
is_published	Number	Yes/no flag
created_at	Number	Timestamp
updated_at	Number	Timestamp
wiki_id	Number	Internal identifier
UNIQUE(campaign,	number)

Wiki Suggestionswiki_suggestions

Proposed edits submitted by members for wiki articles, awaiting review by an editor.

Column	Type	Notes
id	Number
article_id	Number	Internal identifier
suggested_content	Text
status	Text
suggested_by	Text
reviewed_by	Text
reviewed_at	Number	Timestamp
reviewer_note	Text
created_at	Number	Timestamp

Wiki Watcheswiki_watches

Your wiki watchlist — articles you have subscribed to for change notifications.

Column	Type	Notes
user_id	Text	Internal identifier
article_id	Number	Internal identifier
created_at	Number	Timestamp

Wikiswikis

Metadata for each community wiki instance: name, description, and which community it belongs to.

Column	Type	Notes
id	Number
slug	Text
name	Text
description	Text
community_slug	Text
is_public	Number	Yes/no flag
created_at	Number	Timestamp

Questions about how specific data is used? Read our Privacy Policy for the full picture, or ask a staff member in our Discord server.