Difference between revisions of "DiversityDescriptions Quiz (Artenquiz)"
From Diversity Workbench
(→New projects: scheme of tables) |
(→New projects: corrected links) |
||
| Line 1,345: | Line 1,345: | ||
<tr><td PORT="data_entry_note">data_entry_note</td></tr> | <tr><td PORT="data_entry_note">data_entry_note</td></tr> | ||
//CONSTRAINT [PK_Descriptor] PRIMARY KEY ([id]) | //CONSTRAINT [PK_Descriptor] PRIMARY KEY ([id]) | ||
| + | </table>> | ||
| + | ]; | ||
| + | DescriptorTree [ | ||
| + | URL="DescriptionsModel_v3.00.10#Table:_DescriptorTree" | ||
| + | tooltip="The root and definition of a descriptor tree" | ||
| + | label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" > | ||
| + | <tr><td BGCOLOR="#ef6a6a" colspan="2">DescriptorTree</td></tr> | ||
| + | <tr><td PORT="id">id</td><td PORT="id_e"></td></tr> | ||
| + | <tr><td PORT="is_complete">is_complete</td><td></td></tr> | ||
| + | <tr><td PORT="label">label</td><td>u</td></tr> | ||
| + | <tr><td PORT="type">type</td><td></td></tr> | ||
| + | <tr><td PORT="project_id">project_id</td><td PORT="project_id_e"></td></tr> | ||
| + | //CONSTRAINT [PK_DescriptorTree] PRIMARY KEY ([id]), | ||
| + | //CONSTRAINT [UQ_DescriptorTree_1] UNIQUE ([label]) | ||
| + | </table>> | ||
| + | ]; | ||
| + | DescriptorTreeNode [ | ||
| + | URL="DescriptionsModel_v3.00.10#Table:_DescriptorTreeNode" | ||
| + | tooltip="The descriptor tree nodes representing either nodes of the tree or descriptors ("leafes" of the tree)" | ||
| + | label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" > | ||
| + | <tr><td BGCOLOR="#ef6a6a" colspan="2">DescriptorTreeNode</td></tr> | ||
| + | <tr><td PORT="id">id</td><td PORT="id_e"></td></tr> | ||
| + | <tr><td PORT="parent_node_id">parent_node_id</td><td PORT="parent_node_id_e">ut_1</td></tr> | ||
| + | <tr><td PORT="label">label</td><td PORT="label_e">ut_1</td></tr> | ||
| + | <tr><td PORT="abbreviation">abbreviation</td><td PORT="abbreviation_e"></td></tr> | ||
| + | <tr><td PORT="display_order">display_order</td><td PORT="display_order_e"></td></tr> | ||
| + | <tr><td PORT="descriptortree_id">descriptortree_id</td><td PORT="descriptortree_id_e">ut_1</td></tr> | ||
| + | <tr><td PORT="descriptor_id">descriptor_id</td><td PORT="descriptor_id_e">ut_1</td></tr> | ||
| + | //CONSTRAINT [PK_DescriptorTreeNode] PRIMARY KEY ([id]), | ||
| + | //CONSTRAINT [UQ_DescriptorTreeNode_1] UNIQUE ([descriptortree_id],[parent_node_id],[descriptor_id],[label]) | ||
</table>> | </table>> | ||
]; | ]; | ||
| Line 1,366: | Line 1,396: | ||
BaseEntity:id:e -> Resource:id:w[color="#0069ba" fontcolor="#0069ba"]; | BaseEntity:id:e -> Resource:id:w[color="#0069ba" fontcolor="#0069ba"]; | ||
BaseEntity:id:e -> ResourceVariant_Enum:id:w[color="#0069ba" fontcolor="#0069ba"]; | BaseEntity:id:e -> ResourceVariant_Enum:id:w[color="#0069ba" fontcolor="#0069ba"]; | ||
| + | // CategoricalState | ||
| + | BaseEntity:id:e -> CategoricalState:id:w[color="#0069ba" fontcolor="#0069ba"]; | ||
CategoricalState:id_e:e -> Resource:state_id:w[label="DELETE SET NULL" fontsize=10 color="#AF7817" fontcolor="#AF7817"]; | CategoricalState:id_e:e -> Resource:state_id:w[label="DELETE SET NULL" fontsize=10 color="#AF7817" fontcolor="#AF7817"]; | ||
| + | BaseEntity:id:e -> Descriptor:id:w[color="#0069ba" fontcolor="#0069ba"]; | ||
| + | BaseEntity:id:e -> DescriptorTree:id:w[color="#0069ba" fontcolor="#0069ba"]; | ||
| + | |||
| + | Descriptor:id:e -> DescriptorTreeNode:descriptor_id:w[color="#AF7817" fontcolor="#AF7817"]; | ||
| + | BaseEntity:id:e -> DescriptorTreeNode:id:w[color="#0069ba" fontcolor="#0069ba"]; | ||
| + | DescriptorTree:id_e:e -> DescriptorTreeNode:descriptortree_id:w[color="#CC0033" fontcolor="#CC0033"]; | ||
| + | DescriptorTree:id_e:e -> Project:restricted_to_descriptortree_id[label="DELETE SET NULL" fontsize=10 color="#CC0033" fontcolor="#CC0033"]; | ||
| + | DescriptorTreeNode:id:w -> DescriptorTreeNode:parent_node_id:w[color="#CC0033" fontcolor="#CC0033"]; | ||
| + | |||
Descriptor:id:e -> Resource:descriptor_id:w[label="DELETE SET NULL" fontsize=10 color="#AF7817" fontcolor="#AF7817"]; | Descriptor:id:e -> Resource:descriptor_id:w[label="DELETE SET NULL" fontsize=10 color="#AF7817" fontcolor="#AF7817"]; | ||
Resource:id -> ResourceVariant:resource_id:w[label="DELETE CASCADE" fontsize=10 color="#000074" fontcolor="#000074"]; | Resource:id -> ResourceVariant:resource_id:w[label="DELETE CASCADE" fontsize=10 color="#000074" fontcolor="#000074"]; | ||
Revision as of 09:17, 25 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) |
New projects
Steps to enter data for anew project: Create a project (table: Project)
- Project.code is important: it is used as URL part and within the Django application as internal project identifier it should never be changed
- eventually create or associate scopes, like “female”, “male” (table: OtherScope, Project_AvailableScope)
Eventually create the taxa (table: TaxonProxy)
- associate taxa to the project (tables: TaxonSet, TaxonSet_Taxon)
- associate images of taxa (tables: Resource, ResourceVariant, BaseEntity.specific_rights_text should contain the corresponding picture’s author name like: “© Author Name”). A set of maximum of 16 thumbs will be displayed
- resource variants as ReourceVariant_Enum.code "tiny_sample" (=thumb 75×75px) and "best_quality" (max 500×500px displayed) should have corresponding urls in ResourceVariant.url
- eventually associate geographic area (table: GeographicAreaProxy, GeographicArea_Taxon)
Create character and character states (table Descriptor, CategoricalState), character tree (tables: DescriptorTree, DescriptorTreeNode)
- associate images to characters or character states (tables: Resource, ResourceVariant, BaseEntity.specific_rights_text should contain the corresponding picture’s author name like: “© Author Name”), size of images with maximal height 40px
Finally make a project publicly available: set the Project‘s tag (table: Tag)
- tag "Artenquiz" means it is a quiz
- tag "Public" means it will be publically available
- tag "Identification" make the project availabel for identification (URL: …/mobile_bestimmung/)
Graph image creation requires permission to upload.
