eqemu-docs/docs/schema/flagging/content_flags.md

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