diff options
Diffstat (limited to 'docs/quest_tracker.md')
| -rw-r--r-- | docs/quest_tracker.md | 58 |
1 files changed, 30 insertions, 28 deletions
diff --git a/docs/quest_tracker.md b/docs/quest_tracker.md index 77ac708..a38e174 100644 --- a/docs/quest_tracker.md +++ b/docs/quest_tracker.md @@ -1,59 +1,61 @@ -# quest_tracker +# quest\_tracker [<-Back-to:Character](database-character.md) -**The \`quest_tracker\` table** +**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 +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +| ----------------------- | ------------ | ---------- | --- | ---- | ------- | ----- | ------- | +|[id][1] | MEDIUMINT | UNSIGNED | | NO | 0 | | | +|[character_guid][2] | INT | UNSIGNED | | NO | 0 | | | +|[quest_accept_time][3] | DATETIME | SIGNED | | NO | | | | +|[quest_complete_time][4] | DATETIME | SIGNED | | YES | | | | +|[quest_abandon_time][5] | DATETIME | SIGNED | | YES | | | | +|[completed_by_gm][6] | TINYINT | SIGNED | | NO | 0 | | | +|[core_hash][7] | VARCHAR(120) | SIGNED | | NO | 0 | | | +|[core_revision][8] | VARCHAR(120) | SIGNED | | 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 +[2]: #characterguid +[3]: #questaccepttime +[4]: #questcompletetime +[5]: #questabandontime +[6]: #completedbygm +[7]: #corehash +[8]: #corerevision + +**Description of the fields** ### id `field-no-description|1` -### character_guid +### character\_guid -[characters.guid](characters#guid). +See [characters.guid](characters#guid). -### quest_accept_time +### quest\_accept\_time When the quest was accepted. -### quest_complete_time +### quest\_complete\_time When the quest was completed. -### quest_abandon_time +### quest\_abandon\_time When the quest was abandoned. -### completed_by_gm +### completed\_by\_gm `field-no-description|6` -### core_hash +### core\_hash `field-no-description|7` -### core_revision +### core\_revision -`field-no-description|8` +`field-no-description|8`
\ No newline at end of file |