Difference between revisions of "DiversityDescriptions Quiz (Artenquiz)"
From Diversity Workbench
(→Database) |
(→Database: TaxonQuiz: + scope_id) |
||
| Line 847: | Line 847: | ||
<tr><td PORT="taxon_id">taxon_id</td><td>ut_1</td></tr> | <tr><td PORT="taxon_id">taxon_id</td><td>ut_1</td></tr> | ||
<tr><td PORT="contributor_id">contributor_id</td><td>ut_1</td></tr> | <tr><td PORT="contributor_id">contributor_id</td><td>ut_1</td></tr> | ||
| + | <tr><td PORT="scope_id">scope_id</td><td>ut_1</td></tr> | ||
<tr><td PORT="points">points</td><td></td></tr> | <tr><td PORT="points">points</td><td></td></tr> | ||
<tr><td PORT="success">success</td><td></td></tr> | <tr><td PORT="success">success</td><td></td></tr> | ||
| Line 960: | Line 961: | ||
TranslationColumn_Enum:id_e:e -> Translation:column_id; | TranslationColumn_Enum:id_e:e -> Translation:column_id; | ||
UserProxy:LoginName -> ProjectUser:LoginName[label="UPDATE CASCADE\nDELETE CASCADE" fontsize=10 color="#CC0033" fontcolor="#CC0033"]; | UserProxy:LoginName -> ProjectUser:LoginName[label="UPDATE CASCADE\nDELETE CASCADE" fontsize=10 color="#CC0033" fontcolor="#CC0033"]; | ||
| − | TaxonProxy:id_e:e -> TaxonQuiz:taxon_id | + | TaxonProxy:id_e:e -> TaxonQuiz:taxon_id:w |
| − | Contributor:id_e:e -> TaxonQuiz:contributor_id | + | Contributor:id_e:e -> TaxonQuiz:contributor_id:w |
| + | OtherScope:id_e:e -> TaxonQuiz:scope_id:w | ||
Project:id_e:e -> TaxonQuiz:project_id:w[color="#CC0033" fontcolor="#CC0033"]; | Project:id_e:e -> TaxonQuiz:project_id:w[color="#CC0033" fontcolor="#CC0033"]; | ||
Resource:id -> ResourceWatchedTime:resource_id:w[label="DELETE CASCADE" fontsize=10 color="#000074" fontcolor="#000074"] | Resource:id -> ResourceWatchedTime:resource_id:w[label="DELETE CASCADE" fontsize=10 color="#000074" fontcolor="#000074"] | ||
| Line 998: | Line 1,000: | ||
User’s correctly answered taxa. | User’s correctly answered taxa. | ||
| − | : unique together = ('project_id', 'contributor_id', 'taxon_id') | + | : unique together = ('project_id', 'contributor_id', 'taxon_id', 'scope_id') |
{|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;" | ||
| Line 1,006: | Line 1,008: | ||
!Description | !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;" | ||
| − | |taxon_id | + | | taxon_id || int || Reference (foreign kex) to a taxon that has been answerd correctly |
| − | |int | + | |
| − | |Reference (foreign kex) to a taxon that has been answerd correctly | + | |
|- | |- | ||
| − | |project_id | + | | project_id || int || Reference (foreign key) to the project |
| − | |int | + | |
| − | |Reference (foreign key) to the project | + | |
|-style="background:WhiteSmoke;" | |-style="background:WhiteSmoke;" | ||
| − | |contributor_id | + | |contributor_id || int || |Reference (foreign key) to a contributor |
| − | |int | + | |
| − | |Reference (foreign key) to a contributor | + | |
|- | |- | ||
| − | | | + | | scope_id || int || Reference to a scope (default: 0) |
| − | |int | + | |
| − | | | + | |
|-style="background:WhiteSmoke;" | |-style="background:WhiteSmoke;" | ||
| − | | | + | | points || int || Points through scoring characters, already 3 added if success (default: 0) |
| − | | | + | |- |
| − | |Was the taxon answered correctly by the user? (default: 0) | + | | sucess || tinyint || Was the taxon answered correctly by the user? (default: 0) |
|} | |} | ||
Revision as of 12:54, 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: 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) |
