From 0bdf17876dc272627d6216931d6d57c0fdfe223c Mon Sep 17 00:00:00 2001 From: Kitzunu <24550914+Kitzunu@users.noreply.github.com> Date: Sat, 1 May 2021 12:28:47 +0200 Subject: chore(docs): Add basic info of quest_tracker (#451) --- docs/quest_tracker.md | 59 +++++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 59 insertions(+) create mode 100644 docs/quest_tracker.md (limited to 'docs') 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` -- cgit