Skip to content

grid

Relationships

erDiagram
    grid {
        int id
        int zoneid
    }
    grid_entries {
        int gridid
        varchar grid_id
        int zoneid
    }
    spawn2 {
        varchar content_flags
        varchar content_flags_disabled
        int pathgrid
        int id
        int spawngroupID
        smallint version
        varchar zone
    }
    zone {
        int zoneidnumber
        varchar short_name
        tinyintunsigned version
        varchar content_flags
        varchar content_flags_disabled
    }
    grid ||--o{ grid_entries : "Has-Many"
    grid ||--o{ spawn2 : "Has-Many"
    grid ||--o{ zone : "One-to-One"

Relationship Type Local Key Relates to Table Foreign Key
Has-Many id grid_entries gridid
Has-Many id spawn2 pathgrid
One-to-One zoneid zone zoneidnumber

Schema

Column Data Type Description
id int Unique Grid Identifier
zoneid int Zone Identifier
type int Wander Type
type2 int Pause Type