Database-structure.md

PDKP Database Structure

Databases

• [guildDB] - Individual member data
• [dkpDB] - DKP History
• [pugDB] - Pug Member Data
• [settingsDB] - Addon Settings
• [testDB] - Development DB

GuildDB

The guild DB contains information regarding the individual members in the guild, things that can't be quickly queried via blizzard API.

Member

['guildDB'] = { -- table
    ['members'] = { -- table
        ['Neekio'] = { -- table
            ['total'] = 30 -- int, dkp total
            ['deleted'] = { -- table
            }
            ['entries'] = { -- table
            
            }
            ['lockouts'] = { -- table
                [2684] = { -- table, week number since UTC Epoch
                    ['resetsOn'] = 166, -- int, 
                    [651] = { -- int, bossID
                        ['bossName'] = 'Magtheridon', -- string, Boss Name
                        ['yday'] = 162, -- int, day of year
                        ['timestamp'] = 1623441373, -- int, UTC timestamp
                    }
                }
            }
        },
        ...
    },
    ['numOfMembers'] = 418 -- int
}

##


    PDKP.dbDefaults = {
        ['global'] = {
            ['db'] = {
                ['guild'] = {
                    ['members'] = {},
                    ['numOfMembers'] = 0
                },
                ['pug'] = {},
                ['officers'] = {},
                ['dkp'] = {
                    ['lastEdit'] = 0,
                    ['history'] = {},
                    ['old_entries']= {},
                },
                ['settings'] = {
                    ['minimapPos'] = 207,
                    ['debug'] = false,
                    ['ignore_from']={},
                    ['minimap']={},
                    ['sync'] = {
                    ['pvp'] = true,
                    ['raids'] = true,
                    ['dungeons'] = true
                    },
                    ['notifications'] = true,
                    ['debug'] = false,
                },
                ['test']={},
            }
        }
    }