eqemu-docs/docs/schema/spawns/spawn2.md

spawn2

Relationships

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

Relationship Type	Local Key	Relates to Table	Foreign Key
One-to-One	content_flags	content_flags	flag_name
One-to-One	content_flags_disabled	content_flags	flag_name
One-to-One	pathgrid	grid	id
One-to-One	spawngroupID	spawngroup	id
Has-Many	spawngroupID	spawnentry	spawngroupID
One-to-One	version	zone	version
One-to-One	zone	zone	short_name

Schema

Column	Data Type	Description
id	int	Unique Spawn2 Entry Identifier
spawngroupID	int	Unique Spawngroup Identifier
zone	varchar	Zone Short Name
version	smallint	Version
x	float	X Coordinate
y	float	Y Coordinate
z	float	Z Coordinate
heading	float	Heading Coordinate
respawntime	int	Respawn Time in Seconds
variance	int	Variance in Seconds
pathgrid	int	Path Grid Identifier
path_when_zone_idle	tinyint	Path When Zone Idle: 0 = False, 1 = True
_condition	mediumint	Condition
cond_value	mediumint	Condition Value
animation	tinyint	Animation
min_expansion	tinyint	Minimum Expansion
max_expansion	tinyint	Maximum Expansion
content_flags	varchar	Content Flags Required to be Enabled
content_flags_disabled	varchar	Content Flags Required to be Disabled