Skip to content

content_flags

Relationships

erDiagram
    content_flags {
        varchar flag_name
    }
    doors {
        varchar content_flags
        varchar content_flags_disabled
        int dz_switch_id
        int keyitem
        varchar zone
        varchar dest_zone
        intunsigned dest_instance
        smallint version
    }
    fishing {
        varchar content_flags
        varchar content_flags_disabled
        int Itemid
        int zoneid
        int npc_id
    }
    forage {
        varchar content_flags
        varchar content_flags_disabled
        int Itemid
        int zoneid
    }
    global_loot {
        varchar content_flags
        varchar content_flags_disabled
        int loottable_id
        mediumtext zone
    }
    ground_spawns {
        varchar content_flags
        varchar content_flags_disabled
        intunsigned item
        smallint version
        intunsigned zoneid
    }
    content_flags ||--o{ doors : "Has-Many"
    content_flags ||--o{ doors : "Has-Many"
    content_flags ||--o{ fishing : "Has-Many"
    content_flags ||--o{ fishing : "Has-Many"
    content_flags ||--o{ forage : "Has-Many"
    content_flags ||--o{ forage : "Has-Many"
    content_flags ||--o{ global_loot : "Has-Many"
    content_flags ||--o{ global_loot : "Has-Many"
    content_flags ||--o{ ground_spawns : "Has-Many"
    content_flags ||--o{ ground_spawns : "Has-Many"


erDiagram
    content_flags {
        varchar flag_name
    }
    lootdrop {
        varchar content_flags
        varchar content_flags_disabled
        intunsigned id
    }
    loottable {
        varchar content_flags
        varchar content_flags_disabled
        intunsigned id
    }
    merchantlist {
        varchar content_flags
        varchar content_flags_disabled
        varchar bucket_name
        int item
        varchar merchant_id
        int merchantid
    }
    object {
        varchar content_flags
        varchar content_flags_disabled
        int itemid
        int id
        smallint version
        intunsigned zoneid
    }
    spawn2 {
        varchar content_flags
        varchar content_flags_disabled
        int pathgrid
        int id
        int spawngroupID
        smallint version
        varchar zone
    }
    content_flags ||--o{ lootdrop : "Has-Many"
    content_flags ||--o{ lootdrop : "Has-Many"
    content_flags ||--o{ loottable : "Has-Many"
    content_flags ||--o{ loottable : "Has-Many"
    content_flags ||--o{ merchantlist : "Has-Many"
    content_flags ||--o{ merchantlist : "Has-Many"
    content_flags ||--o{ object : "Has-Many"
    content_flags ||--o{ object : "Has-Many"
    content_flags ||--o{ spawn2 : "Has-Many"
    content_flags ||--o{ spawn2 : "Has-Many"


erDiagram
    content_flags {
        varchar flag_name
    }
    spawnentry {
        varchar content_flags
        varchar content_flags_disabled
        int npcID
        int spawngroupID
    }
    start_zones {
        varchar content_flags
        varchar content_flags_disabled
        int start_zone
        int zone_id
    }
    starting_items {
        varchar content_flags
        varchar content_flags_disabled
        varchar itemid
        varchar zone_id
        varchar zoneid
    }
    tradeskill_recipe {
        int id
        varchar content_flags
        varchar content_flags_disabled
    }
    traps {
        varchar content_flags
        varchar content_flags_disabled
        smallintunsigned version
        varchar zone
    }
    content_flags ||--o{ spawnentry : "Has-Many"
    content_flags ||--o{ spawnentry : "Has-Many"
    content_flags ||--o{ start_zones : "Has-Many"
    content_flags ||--o{ start_zones : "Has-Many"
    content_flags ||--o{ starting_items : "Has-Many"
    content_flags ||--o{ starting_items : "Has-Many"
    content_flags ||--o{ tradeskill_recipe : "Has-Many"
    content_flags ||--o{ tradeskill_recipe : "Has-Many"
    content_flags ||--o{ traps : "Has-Many"
    content_flags ||--o{ traps : "Has-Many"


erDiagram
    content_flags {
        varchar flag_name
    }
    zone {
        int zoneidnumber
        varchar short_name
        tinyintunsigned version
        varchar content_flags
        varchar content_flags_disabled
    }
    zone_points {
        varchar content_flags
        varchar content_flags_disabled
        intunsigned target_instance
        varchar zone
        intunsigned target_zone_id
        int version
    }
    content_flags ||--o{ zone : "Has-Many"
    content_flags ||--o{ zone : "Has-Many"
    content_flags ||--o{ zone_points : "Has-Many"
    content_flags ||--o{ zone_points : "Has-Many"
Relationship Type Local Key Relates to Table Foreign Key
Has-Many flag_name doors content_flags
Has-Many flag_name doors content_flags_disabled
Has-Many flag_name fishing content_flags
Has-Many flag_name fishing content_flags_disabled
Has-Many flag_name forage content_flags
Has-Many flag_name forage content_flags_disabled
Has-Many flag_name global_loot content_flags
Has-Many flag_name global_loot content_flags_disabled
Has-Many flag_name ground_spawns content_flags
Has-Many flag_name ground_spawns content_flags_disabled
Has-Many flag_name lootdrop content_flags
Has-Many flag_name lootdrop content_flags_disabled
Has-Many flag_name loottable content_flags
Has-Many flag_name loottable content_flags_disabled
Has-Many flag_name merchantlist content_flags
Has-Many flag_name merchantlist content_flags_disabled
Has-Many flag_name object content_flags
Has-Many flag_name object content_flags_disabled
Has-Many flag_name spawn2 content_flags
Has-Many flag_name spawn2 content_flags_disabled
Has-Many flag_name spawnentry content_flags
Has-Many flag_name spawnentry content_flags_disabled
Has-Many flag_name start_zones content_flags
Has-Many flag_name start_zones content_flags_disabled
Has-Many flag_name starting_items content_flags
Has-Many flag_name starting_items content_flags_disabled
Has-Many flag_name tradeskill_recipe content_flags
Has-Many flag_name tradeskill_recipe content_flags_disabled
Has-Many flag_name traps content_flags
Has-Many flag_name traps content_flags_disabled
Has-Many flag_name zone content_flags
Has-Many flag_name zone content_flags_disabled
Has-Many flag_name zone_points content_flags
Has-Many flag_name zone_points content_flags_disabled

Schema

Column Data Type Description
id int Unique Flag Identifier
flag_name varchar Flag Name
enabled tinyint Enabled: 0 = False, 1 = True
notes text Notes