DiversityDescriptions Quiz (Artenquiz)

From Diversity Workbench
Revision as of 12:11, 13 August 2014 by Andreas Plank (Talk | contribs) (Created page with "DiversityDescriptions_Quiz (DD_Quiz) is a clone of DiversityDescriptions 3.00.10. July 17th, 2014 that is intended to work with the [http://biow...")

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

DiversityDescriptions_Quiz (DD_Quiz) is a clone of DiversityDescriptions 3.00.10. July 17th, 2014 that is intended to work with the Web-Framework Django to have a quiz for species descriptions in German. This project is presently under development. Additional tables see below.

Hover the mouse over a table to jump to the documentation (linked to DiversityDescriptions 3.00.10. July 17th, 2014).

Documentation

Database

Graph image creation requires permission to upload.

Graph image creation requires permission to upload.

Table: ResourceWatchedTime

The time a resource thumb was watched (=mouse hover)

Column Data type Description
id int Database-internal ID of this record (primary key)
resource_id int Reference (foreign key) to a resource
contributor_id int Reference (foreign key) to a contributor
watched_time int watched time in milliseconds

Table: TaxonQuiz

User’s correctly answered taxa.

unique together = ('project_id', 'contributor_id', 'taxon_id')
Column Data type Description
id int Database-internal ID of this record (primary key)
taxon_id int Reference (foreign kex) to a taxon that has been answerd correctly
project_id int Reference (foreign key) to the project
contributor_id int Reference (foreign key) to a contributor
points int Points through scoring characters, already 3 added if success (default: 0)
sucess tinyint Was the taxon answered correctly by the user? (default: 0)