mirror of
https://github.com/EQEmu/eqemu-docs-v2.git
synced 2026-08-08 17:45:09 -04:00
85 lines
2.8 KiB
Markdown
85 lines
2.8 KiB
Markdown
# spawn2
|
|
|
|
## Relationships
|
|
|
|
```mermaid
|
|
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](../../schema/flagging/content_flags.md) | flag_name |
|
|
| One-to-One | content_flags_disabled | [content_flags](../../schema/flagging/content_flags.md) | flag_name |
|
|
| One-to-One | pathgrid | [grid](../../schema/grids/grid.md) | id |
|
|
| One-to-One | spawngroupID | [spawngroup](../../schema/spawns/spawngroup.md) | id |
|
|
| Has-Many | spawngroupID | [spawnentry](../../schema/spawns/spawnentry.md) | spawngroupID |
|
|
| One-to-One | version | [zone](../../schema/zone/zone.md) | version |
|
|
| One-to-One | zone | [zone](../../schema/zone/zone.md) | short_name |
|
|
|
|
|
|
## Schema
|
|
|
|
| Column | Data Type | Description |
|
|
| :--- | :--- | :--- |
|
|
| id | int | Unique Spawn2 Entry Identifier |
|
|
| spawngroupID | int | [Unique Spawngroup Identifier](spawngroup.md) |
|
|
| zone | varchar | [Zone Short Name](../../../../server/zones/zone-list) |
|
|
| 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](../../schema/grids/grid.md) |
|
|
| path_when_zone_idle | tinyint | Path When Zone Idle: 0 = False, 1 = True |
|
|
| _condition | mediumint | Condition |
|
|
| cond_value | mediumint | Condition Value |
|
|
| animation | tinyint | [Animation](../../../../server/npc/npc-animation-types) |
|
|
| min_expansion | tinyint | [Minimum Expansion](../../../../server/operation/expansion-list) |
|
|
| max_expansion | tinyint | [Maximum Expansion](../../../../server/operation/expansion-list) |
|
|
| content_flags | varchar | Content Flags Required to be Enabled |
|
|
| content_flags_disabled | varchar | Content Flags Required to be Disabled |
|
|
|