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.
No table in this database contains an IP address column. 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 namesqlite_masteris 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 table is 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.
All tables (75)
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_usersInternal authentication record created when you first sign in. Stores your name and email address if Discord provided one during OAuth, plus your avatar URL.
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 | |
| Text | Email address, if provided by your OAuth provider | |
| email_verified | Number | |
| image | Text |
Call Sessionscall_sessionsRecords of voice calls between members — who initiated, who received, when the call started and ended, and the final call status.
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 |
Conversation Participantsconversation_participantsTracks which members belong to each direct message conversation thread, and each participant's last-read position.
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 |
ConversationsconversationsMetadata for direct message threads (creation time, last message timestamp). Does not store message content — that lives in Direct Messages.
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_messagesYour 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.
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 |
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 |
FriendshipsfriendshipsFriend connections between members, including pending requests, accepted friendships, and blocks.
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, |
Modsmod_membersThe site mods roster: names, handles, titles, teams, and profile images shown on the Mods page.
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 |
NotificationsnotificationsIn-site notifications delivered to your inbox — friend requests, wall activity, reactions, and similar events.
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_applicationsApplications to join the LSG Overwatch competitive team, including availability, role preference, and SR history.
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_rosterCurrent LSG Overwatch competitive team members, their roles, and roster slot assignments.
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 |
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 |
Pe Initiative Statepe_initiative_state
| Column | Type | Notes |
|---|---|---|
| id | Number | |
| round | Number | |
| current_entry_id | Number | Internal identifier |
Pe Party Fundspe_party_funds
| Column | Type | Notes |
|---|---|---|
| id | Number | |
| 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_questionsApplication questions used in the Prestige Encounters D&D campaign intake form.
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 |
Pe Stream Seatspe_stream_seats
| Column | Type | Notes |
|---|---|---|
| seat | Number | |
| character_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 |
PostspostsCommunity posts and news articles published on the site — developer updates, clan news, and announcements.
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 |
Profile Slug Historyprofile_slug_historyA log of previous profile URL slugs you have used. Retained so others cannot immediately claim your old username after you change it.
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 |
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_applicationsApplications submitted to join the Undead Legion RS3 clan staff team.
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 |
SchedulescheduleThe weekly stream schedule shown on the Schedule page — show name, day of week, time, description, and theme.
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 |
Sea of Thieves Applicationssot_applicationsApplications to join the LSG Sea of Thieves guild, including gamertag, role preference, and playstyle.
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_configGuild-level configuration for the LSG Sea of Thieves guild (distinction level, max level, etc.).
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_membersCurrent LSG SoT guild members, their roster slots, roles, and ship assignments.
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_purchasesAn audit log of every purchase made through the Souls shop — which item, how many souls were spent, and when.
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 |
User Profilesuser_profilesYour profile: display name, bio, pronouns, timezone, in-game usernames, linked accounts, appearance settings, and privacy preferences.
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 |
User Reportsuser_reportsReports submitted against members for rule violations. Visible to staff only — regular members cannot read 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_commentsComments left on profile wall posts.
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_postsPosts left on a member's public profile wall.
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_reactionsEmoji reactions left on profile wall posts.
Emoji reactions left on profile wall posts.
| Column | Type | Notes |
|---|---|---|
| post_id | Number | Internal identifier |
| user_id | Text | Internal identifier |
| emoji | Text |
Wiki Articleswiki_articlesIndividual wiki article pages: title, content, which wiki they belong to, and authorship metadata.
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_categoriesCategory groupings used to organise articles within a wiki.
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_commentsComments left by members on wiki article pages.
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_linksTracked internal links between wiki articles, powering "What links here" and backlink features.
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_redirectsRedirect rules that forward old article URLs to current titles after a rename.
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_revisionsFull revision history of every edit made to wiki articles — what changed, who changed it, and when.
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_articlesLinks between wiki articles and D&D campaign session logs.
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_sessionsD&D campaign session metadata stored alongside a wiki (session number, date, summary).
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_suggestionsProposed edits submitted by members for wiki articles, awaiting review by an editor.
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_watchesYour wiki watchlist — articles you have subscribed to for change notifications.
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 |
WikiswikisMetadata for each community wiki instance: name, description, and which community it belongs to.
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.