DiversityDescriptions Quiz (Artenquiz)

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

The following conventions and abbreviations have been used in the tables: Columns of primary key:underlined

Table: Contribution

Multiple contributors may contribute in different roles

Column	Data type	Description
id	int	Database-internal ID of this record (primary key)
object_id	int	Reference (foreign key) to a BaseEntity
contributor_id	int	Reference (foreign key) to a contributor
role	nvarchar (255)	one of 'creator', 'contributor', 'editor', 'photographer'
timestamp	datetime	Time stamp of the contribution

Table: Contributor

People contibuting to a work. Roles are recorded in Contribution

Column	Data type	Description
id	int	Database-internal ID of this record (primary key)
avatar_uri	nvarchar (255)	Optional URI to an image representing the user (default: NULL)
email	nvarchar (255)	User’s email address (default: NULL)
linked_agent_uri	nvarchar (255)	Linking to agents managed in an external component (default: NULL)
real_name	nvarchar (255)	Optional name the user gave (full name) (default: NULL)
web_pseudonym	nvarchar (255)	Optional alternative name to display publicly on the web (default: NULL)

Note: in the Quiz all users/contributors are requested to input their full name.

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', 'scope_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
scope_id	int	Reference to a scope (default: 0)
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)