quest_globals¶
Info
This page was last generated 2023.04.23
Relationship Diagram(s)¶
Relationships¶
| Relationship Type | Local Key | Relates to Table | Foreign Key |
|---|---|---|---|
| One-to-One | charid | character_data | id |
| Has-Many | name | item_tick | it_qglobal |
| Has-Many | name | merc_merchant_templates | qglobal |
| Has-Many | name | spell_globals | qglobal |
| One-to-One | npcid | npc_types | id |
| One-to-One | zoneid | zone | zoneidnumber |
Schema¶
| Column | Data Type | Description |
|---|---|---|
| charid | int | Character Identifier |
| npcid | int | NPC Type Identifier |
| zoneid | int | Zone Identifier |
| name | varchar | Name |
| value | varchar | Value |
| expdate | int | Expiration Date UNIX Timestamp |