diff options
| author | Kitzunu <24550914+Kitzunu@users.noreply.github.com> | 2021-05-01 12:28:47 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2021-05-01 12:28:47 +0200 |
| commit | 0bdf17876dc272627d6216931d6d57c0fdfe223c (patch) | |
| tree | 0d622e3706dd1f5a31a6fc1ee7c4c24500ddc034 | |
| parent | e12fb303c30fcbf83df7197b433beba44171d682 (diff) | |
| download | wiki-0bdf17876dc272627d6216931d6d57c0fdfe223c.tar.gz wiki-0bdf17876dc272627d6216931d6d57c0fdfe223c.tar.bz2 wiki-0bdf17876dc272627d6216931d6d57c0fdfe223c.zip | |
chore(docs): Add basic info of quest_tracker (#451)
| -rw-r--r-- | docs/quest_tracker.md | 59 |
1 files changed, 59 insertions, 0 deletions
diff --git a/docs/quest_tracker.md b/docs/quest_tracker.md new file mode 100644 index 0000000..77ac708 --- /dev/null +++ b/docs/quest_tracker.md @@ -0,0 +1,59 @@ +# quest_tracker + +[<-Back-to:Character](database-character.md) + +**The \`quest_tracker\` table** + +**Structure** + +| Field | Type | Attribute | Key | Null | Default | Extra | Comment +|:--- | :--- | :--- | :--- | :--- | :--- | :--- | :--- +|[id][1] | MEDIUMINT | UNSIGNED | | NO | 0 +|[character_guid][2] | INT | UNSIGNED | | NO | 0 +|[quest_accept_time][3] | DATETIME | | | NO +|[quest_complete_time][4] | DATETIME | | | YES | NULL +|[quest_abandon_time][5] | DATETIME | | | YES | NULL +|[completed_by_gm][6] | TINYINT | SIGNED | | NO | 0 +|[core_hash][7] | VARCHAR(120) | | | NO | 0 +|[core_revision][8] | VARCHAR(120) | | | NO | 0 + +[1]: #id +[2]: #character_guid +[3]: #quest_accept_time +[4]: #quest_complete_time +[5]: #quest_abandon_time +[6]: #completed_by_gm +[7]: #core_hash +[8]: #core_revision + +### id + +`field-no-description|1` + +### character_guid + +[characters.guid](characters#guid). + +### quest_accept_time + +When the quest was accepted. + +### quest_complete_time + +When the quest was completed. + +### quest_abandon_time + +When the quest was abandoned. + +### completed_by_gm + +`field-no-description|6` + +### core_hash + +`field-no-description|7` + +### core_revision + +`field-no-description|8` |