mmo-ref/eqemu-docs
1
0
Fork 0
mirror of https://github.com/EQEmu/eqemu-docs-v2.git synced 2026-08-08 17:45:09 -04:00
Code Issues Projects Releases Packages Wiki Activity Actions
eqemu-docs/docs/schema/grids/grid.md

1.3 KiB
Raw Permalink Blame History

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