qs_player_handin_record¶
Info
This page was last generated 2023.07.15
Relationship Diagram(s)¶
Relationships¶
| Relationship Type | Local Key | Relates to Table | Foreign Key |
|---|---|---|---|
| One-to-One | char_id | character_data | id |
| One-to-One | npc_id | npc_types | id |
Schema¶
| Column | Data Type | Description |
|---|---|---|
| handin_id | int | Unique Handin Identifier |
| time | timestamp | Time Timestamp |
| quest_id | int | Quest Identifier |
| char_id | int | Character Identifier |
| char_pp | int | Character Platinum |
| char_gp | int | Character Gold |
| char_sp | int | Character Silver |
| char_cp | int | Character Copper |
| char_items | mediumint | Character Items Identifier |
| npc_id | int | NPC Type Identifier |
| npc_pp | int | NPC Platinum |
| npc_gp | int | NPC Gold |
| npc_sp | int | NPC Silver |
| npc_cp | int | NPC Copper |
| npc_items | mediumint | NPC Item Identifier |