mirror of
https://github.com/EQEmu/eqemu-docs-v2.git
synced 2026-08-08 17:45:09 -04:00
64 lines
2 KiB
Markdown
64 lines
2 KiB
Markdown
# spawnentry
|
|
|
|
## Relationships
|
|
|
|
```mermaid
|
|
erDiagram
|
|
spawnentry {
|
|
varchar content_flags
|
|
varchar content_flags_disabled
|
|
int npcID
|
|
int spawngroupID
|
|
}
|
|
content_flags {
|
|
varchar flag_name
|
|
}
|
|
spawngroup {
|
|
int id
|
|
}
|
|
npc_types {
|
|
intunsigned alt_currency_id
|
|
int id
|
|
int npc_faction_id
|
|
text name
|
|
intunsigned loottable_id
|
|
intunsigned merchant_id
|
|
intunsigned emoteid
|
|
intunsigned adventure_template_id
|
|
intunsigned armortint_id
|
|
intunsigned npc_spells_id
|
|
intunsigned npc_spells_effects_id
|
|
intunsigned trap_template
|
|
}
|
|
spawnentry ||--o{ content_flags : "One-to-One"
|
|
spawnentry ||--o{ content_flags : "One-to-One"
|
|
spawnentry ||--o{ spawngroup : "One-to-One"
|
|
spawnentry ||--o{ npc_types : "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 | spawngroupID | [spawngroup](../../schema/spawns/spawngroup.md) | id |
|
|
| One-to-One | npcID | [npc_types](../../schema/npcs/npc_types.md) | id |
|
|
|
|
|
|
## Schema
|
|
|
|
| Column | Data Type | Description |
|
|
| :--- | :--- | :--- |
|
|
| spawngroupID | int | [Unique Spawn Group Identifier](spawngroup.md) |
|
|
| npcID | int | [NPC Type Identifier](../../schema/npcs/npc_types.md) |
|
|
| chance | smallint | Chance: 0 = Never, 100 = Always |
|
|
| condition_value_filter | mediumint | Condition Value Filter |
|
|
| min_time | smallint | |
|
|
| max_time | smallint | |
|
|
| 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 |
|
|
|