Difference between revisions of "DiversityDescriptions Quiz (Artenquiz)"
From Diversity Workbench
(→Database: +Contribution, + Contributor) |
(→Database: gray tables (=unused by the quiz)) |
||
| Line 21: | Line 21: | ||
<tr><td>u=unique</td></tr> | <tr><td>u=unique</td></tr> | ||
<tr><td>ut_1=unique together</td></tr> | <tr><td>ut_1=unique together</td></tr> | ||
| + | <tr><td COLOR="gray"><font COLOR="gray">table not used</font></td></tr> | ||
</table>> | </table>> | ||
]; | ]; | ||
| Line 26: | Line 27: | ||
</graphviz> | </graphviz> | ||
| − | The following conventions and abbreviations have been used in the tables: Columns of primary key:<u>underlined</u> | + | The following conventions and abbreviations have been used in the tables: Columns of primary key:<u>underlined</u>. Categorical data are presented to a user in the quiz therefore some tables (in <span style="color:gray">gray</span>) are not used for the quiz. |
<graphviz caption='Scheme of Diversity Descriptions Quiz' alt='Diversity Descriptions Quiz' format='png'> | <graphviz caption='Scheme of Diversity Descriptions Quiz' alt='Diversity Descriptions Quiz' format='png'> | ||
| Line 53: | Line 54: | ||
]; | ]; | ||
BaseEntity [ | BaseEntity [ | ||
| − | URL="DescriptionsModel_v3.00.10#Table:_BaseEntity" | + | URL="DescriptionsModel_v3.00.10#Table:_BaseEntity" |
tooltip="The BaseEntity is used within the database to provide unique keys" | tooltip="The BaseEntity is used within the database to provide unique keys" | ||
| − | label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" > | + | label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0"> |
<tr><td BGCOLOR="lightblue" >BaseEntity</td></tr> | <tr><td BGCOLOR="lightblue" >BaseEntity</td></tr> | ||
<tr><td PORT="id">id</td></tr> | <tr><td PORT="id">id</td></tr> | ||
| Line 78: | Line 79: | ||
URL="DescriptionsModel_v3.00.10#Table:_CategoricalSamplingData" | URL="DescriptionsModel_v3.00.10#Table:_CategoricalSamplingData" | ||
tooltip="The categorical data recorded for a sampling event" | tooltip="The categorical data recorded for a sampling event" | ||
| − | label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" > | + | fontcolor="gray" |
| + | label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" COLOR="gray"> | ||
<tr><td BGCOLOR="#cee12c" colspan="2">CategoricalSamplingData</td></tr> | <tr><td BGCOLOR="#cee12c" colspan="2">CategoricalSamplingData</td></tr> | ||
<tr><td PORT="id">id</td><td></td></tr> | <tr><td PORT="id">id</td><td></td></tr> | ||
| Line 248: | Line 250: | ||
]; | ]; | ||
DescriptorMapping_Q2C [ | DescriptorMapping_Q2C [ | ||
| − | URL="DescriptionsModel_v3.00.10#Table:_DescriptorMapping_Q2C" | + | URL="DescriptionsModel_v3.00.10#Table:_DescriptorMapping_Q2C" fontcolor="gray" |
tooltip="Mapping of a quantitative descriptor to a categorical state" | tooltip="Mapping of a quantitative descriptor to a categorical state" | ||
| − | label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" > | + | label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" COLOR="gray"> |
<tr><td BGCOLOR="#e5c96a" colspan="1">DescriptorMapping_Q2C</td></tr> | <tr><td BGCOLOR="#e5c96a" colspan="1">DescriptorMapping_Q2C</td></tr> | ||
<tr><td PORT="id">id</td></tr> | <tr><td PORT="id">id</td></tr> | ||
| Line 477: | Line 479: | ||
URL="DescriptionsModel_v3.00.10#Table:_QuantitativeSamplingData" | URL="DescriptionsModel_v3.00.10#Table:_QuantitativeSamplingData" | ||
tooltip="The quantitative data recorded for a sampling event" | tooltip="The quantitative data recorded for a sampling event" | ||
| − | label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" > | + | fontcolor="gray" |
| + | label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" COLOR="gray"> | ||
<tr><td BGCOLOR="#cee12c" colspan="1">QuantitativeSamplingData</td></tr> | <tr><td BGCOLOR="#cee12c" colspan="1">QuantitativeSamplingData</td></tr> | ||
<tr><td PORT="id">id</td></tr> | <tr><td PORT="id">id</td></tr> | ||
| Line 491: | Line 494: | ||
QuantitativeSummaryData [ | QuantitativeSummaryData [ | ||
URL="DescriptionsModel_v3.00.10#Table:_QuantitativeSummaryData" | URL="DescriptionsModel_v3.00.10#Table:_QuantitativeSummaryData" | ||
| − | tooltip="The quantitative data recorded for a sampling event" | + | tooltip="The quantitative data recorded for a sampling event" fontcolor="gray" |
| − | label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" > | + | label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" COLOR="gray"> |
<tr><td BGCOLOR="#00c900" colspan="2">QuantitativeSummaryData</td></tr> | <tr><td BGCOLOR="#00c900" colspan="2">QuantitativeSummaryData</td></tr> | ||
<tr><td PORT="id">id</td><td></td></tr> | <tr><td PORT="id">id</td><td></td></tr> | ||
| Line 586: | Line 589: | ||
SamplingEvent [ | SamplingEvent [ | ||
URL="DescriptionsModel_v3.00.10#Table:_SamplingEvent" | URL="DescriptionsModel_v3.00.10#Table:_SamplingEvent" | ||
| − | tooltip="A sampling event may contain many sampling units" | + | tooltip="A sampling event may contain many sampling units" fontcolor="gray" |
| − | label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" > | + | label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" COLOR="gray"> |
<tr><td BGCOLOR="#cee12c" colspan="1">SamplingEvent</td></tr> | <tr><td BGCOLOR="#cee12c" colspan="1">SamplingEvent</td></tr> | ||
<tr><td PORT="id">id</td></tr> | <tr><td PORT="id">id</td></tr> | ||
| Line 605: | Line 608: | ||
SamplingUnit [ | SamplingUnit [ | ||
URL="DescriptionsModel_v3.00.10#Table:_SamplingUnit" | URL="DescriptionsModel_v3.00.10#Table:_SamplingUnit" | ||
| − | tooltip="Categorical data" | + | tooltip="Categorical data" fontcolor="gray" |
| − | label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" > | + | label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" COlOR="gray"> |
<tr><td BGCOLOR="#cee12c" colspan="1">SamplingUnit</td></tr> | <tr><td BGCOLOR="#cee12c" colspan="1">SamplingUnit</td></tr> | ||
<tr><td PORT="id">id</td></tr> | <tr><td PORT="id">id</td></tr> | ||
| Line 631: | Line 634: | ||
SpecimenProxy [ | SpecimenProxy [ | ||
URL="DescriptionsModel_v3.00.10#Table:_SpecimenProxy" | URL="DescriptionsModel_v3.00.10#Table:_SpecimenProxy" | ||
| − | tooltip="Specimens from collections; proxy for WB component" | + | tooltip="Specimens from collections; proxy for WB component" fontcolor="gray" |
| − | label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" > | + | label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" COLOR="gray"> |
<tr><td BGCOLOR="lightblue" colspan="1">SpecimenProxy</td></tr> | <tr><td BGCOLOR="lightblue" colspan="1">SpecimenProxy</td></tr> | ||
<tr><td PORT="id">id</td></tr> | <tr><td PORT="id">id</td></tr> | ||
| Line 641: | Line 644: | ||
]; | ]; | ||
StatisticalMeasure_Enum [ | StatisticalMeasure_Enum [ | ||
| − | URL="DescriptionsModel_v3.00.10#Table:_StatisticalMeasure_Enum" | + | URL="DescriptionsModel_v3.00.10#Table:_StatisticalMeasure_Enum" fontcolor="gray" |
tooltip="The statistical measures predefined according SDD 1.1 rev 5" | tooltip="The statistical measures predefined according SDD 1.1 rev 5" | ||
| − | label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" > | + | label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" COLOR="gray"> |
<tr><td BGCOLOR="#e5c96a" colspan="2">StatisticalMeasure_Enum</td></tr> | <tr><td BGCOLOR="#e5c96a" colspan="2">StatisticalMeasure_Enum</td></tr> | ||
<tr><td PORT="id">id</td><td PORT="id_e"></td></tr> | <tr><td PORT="id">id</td><td PORT="id_e"></td></tr> | ||
| Line 757: | Line 760: | ||
TextSamplingData [ | TextSamplingData [ | ||
URL="DescriptionsModel_v3.00.10#Table:_TextSamplingData" | URL="DescriptionsModel_v3.00.10#Table:_TextSamplingData" | ||
| − | tooltip="Free-form text data recorded for a sampling event" | + | tooltip="Free-form text data recorded for a sampling event" fontcolor="gray" |
| − | label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" > | + | label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" COLOR="gray"> |
<tr><td BGCOLOR="#cee12c" colspan="2">TextSamplingData</td></tr> | <tr><td BGCOLOR="#cee12c" colspan="2">TextSamplingData</td></tr> | ||
<tr><td PORT="id">id</td><td></td></tr> | <tr><td PORT="id">id</td><td></td></tr> | ||
Revision as of 09:57, 18 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).
Contents
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. Categorical data are presented to a user in the quiz therefore some tables (in gray) are not used for the quiz.
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) |
| 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) |
