Difference between revisions of "DiversityDescriptions Quiz (Artenquiz)"

From Diversity Workbench
Jump to: navigation, search
(→‎Database: TaxonQuiz: + scope_id)
(→‎Database: +Contribution, + Contributor)
Line 122: Line 122:
 
   ];
 
   ];
 
   Contribution [
 
   Contribution [
−
     URL="DescriptionsModel_v3.00.10#Table:_Contribution"
+
     URL="#Table:_Contribution"
 
     tooltip="Multiple contributors may contribute in different roles"
 
     tooltip="Multiple contributors may contribute in different roles"
 
     label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
 
     label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
Line 135: Line 135:
 
   ];
 
   ];
 
   Contributor [
 
   Contributor [
−
     URL="DescriptionsModel_v3.00.10#Table:_Contributor"
+
     URL="#Table:_Contributor"
 
     tooltip="People contibuting to a work. Roles are recorded in Contribution"
 
     tooltip="People contibuting to a work. Roles are recorded in Contribution"
 
     label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
 
     label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
Line 573: Line 573:
  
 
   ResourceWatchedTime [
 
   ResourceWatchedTime [
−
     URL="Table:_ResourceWatchedTime"
+
     URL="#Table:_ResourceWatchedTime"
 
     tooltip="The time a resource thumb was watched (=mouse hover)"
 
     tooltip="The time a resource thumb was watched (=mouse hover)"
 
     label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
 
     label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
Line 839: Line 839:
  
 
   TaxonQuiz [
 
   TaxonQuiz [
−
     URL="Table:_TaxonQuiz"
+
     URL="#Table:_TaxonQuiz"
 
     tooltip="User’s correctly answered taxa"
 
     tooltip="User’s correctly answered taxa"
 
     label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
 
     label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
Line 969: Line 969:
 
}
 
}
 
</graphviz>
 
</graphviz>
 +
 +
 +
==== Table: Contribution ====
 +
 +
Multiple contributors may contribute in different roles
 +
{|border=1 cellpadding="5" style="margin:1em 1em 1em 0; background:#FFFFFF;border:1px #AAA solid; border-collapse:collapse; empty-cells:show;"
 +
|-style="text-align:left; background:#D3D3D3;"
 +
!Column !! Data type !! Description
 +
|-
 +
| <u>id</u> || int || Database-internal ID of this record (primary key)
 +
|-style="background:WhiteSmoke;"
 +
| object_id || int || Reference (foreign key) to a BaseEntity
 +
|-
 +
| contributor_id || int || Reference (foreign key) to a contributor
 +
|-style="background:WhiteSmoke;"
 +
| 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
 +
 +
{|border=1 cellpadding="5" style="margin:1em 1em 1em 0; background:#FFFFFF;border:1px #AAA solid; border-collapse:collapse; empty-cells:show;"
 +
|-style="text-align:left; background:#D3D3D3;"
 +
!Column !! Data type !! Description
 +
|-
 +
| <u>id</u> || int || Database-internal ID of this record (primary key)
 +
|-style="background:WhiteSmoke;"
 +
| avatar_uri || nvarchar (255) || Optional URI to an image representing the user (default: NULL)
 +
|-
 +
| email || nvarchar (255) || User’s email address (default: NULL)
 +
|-style="background:WhiteSmoke;"
 +
| 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)
 +
|-style="background:WhiteSmoke;"
 +
| 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====
 
====Table: ResourceWatchedTime====
Line 976: Line 1,018:
 
{|border=1 cellpadding="5" style="margin:1em 1em 1em 0; background:#FFFFFF;border:1px #AAA solid; border-collapse:collapse; empty-cells:show;"
 
{|border=1 cellpadding="5" style="margin:1em 1em 1em 0; background:#FFFFFF;border:1px #AAA solid; border-collapse:collapse; empty-cells:show;"
 
|-style="text-align:left; background:#D3D3D3;"
 
|-style="text-align:left; background:#D3D3D3;"
−
!Column
+
!Column !! Data type !! Description
−
!Data type
+
−
!Description
+
 
|-
 
|-
−
|<u>id</u>
+
| <u>id</u> || int || Database-internal ID of this record (primary key)
−
|int
+
−
|Database-internal ID of this record (primary key)
+
 
|-style="background:WhiteSmoke;"
 
|-style="background:WhiteSmoke;"
−
|resource_id
+
| resource_id || int || Reference (foreign key) to a resource
−
|int
+
−
|Reference (foreign key) to a resource
+
 
|-
 
|-
−
|contributor_id
+
| contributor_id || int || Reference (foreign key) to a contributor
−
|int
+
−
|Reference (foreign key) to a contributor
+
 
|-style="background:WhiteSmoke;"
 
|-style="background:WhiteSmoke;"
−
|watched_time
+
| watched_time || int || watched time in milliseconds
−
|int
+
−
|watched time in milliseconds
+
 
|}
 
|}
  

Revision as of 13:09, 14 August 2014

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.

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

Graph image creation requires permission to upload.


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)
Retrieved from "https://diversityworkbench.net/w/index.php?title=DiversityDescriptions_Quiz_(Artenquiz)&oldid=2506"