3,699
edits
mNo edit summary |
mNo edit summary |
||
(17 intermediate revisions by the same user not shown) | |||
Line 29: | Line 29: | ||
* Spoiler classification on global and local scale (anime only?) | * Spoiler classification on global and local scale (anime only?) | ||
* Limitation of certain groups to only allow a specific number of tags form it to be added (pick one or die) | * Limitation of certain groups to only allow a specific number of tags form it to be added (pick one or die) | ||
* Specification on tag level if a tag has weight or not (default no) | |||
The self-healing powers of the tag system have failed imho and hence votes should be ditched in favor of weight to symbolize the importance. | The self-healing powers of the tag system have failed imho and hence votes should be ditched in favor of weight to symbolize the importance. | ||
Line 48: | Line 49: | ||
group 1: | group 1: | ||
:tag 1 (<number of usage>) | :tag 1 (<number of usage>) [<weight if applicable>] | ||
:tag 2 (<number of usage>) | :tag 2 (<number of usage>) [<weight if applicable>] | ||
:tag 3 (<number of usage>) | :tag 3 (<number of usage>) [<weight if applicable>] | ||
:tag 4 (<number of usage>) | :tag 4 (<number of usage>) [<weight if applicable>] | ||
group 2: | group 2: | ||
:tag 5 (<number of usage>) | :tag 5 (<number of usage>) [<weight if applicable>] | ||
etc. | etc. | ||
Line 60: | Line 61: | ||
Character Tags on the anime page could be displayed like this as well. | Character Tags on the anime page could be displayed like this as well. | ||
==Import Scenarios== | ==Import Scenarios== | ||
Line 83: | Line 82: | ||
===Creator Tags=== | ===Creator Tags=== | ||
* straight convert, no changes needed | * straight convert, no changes needed | ||
===Lexicon=== | |||
* straight merge with the related data (can be used to find a few dupes existing in both systems) | |||
==Database== | |||
===Option A=== | |||
====tagtb==== | |||
*id | |||
*description | |||
*tooltip | |||
*picurl | |||
*isverified | |||
*isspoiler | |||
*isimportant | |||
*usage | |||
*redirectid | |||
--in case similar tags with different names should share a lexicon entry (German and Germany for instance) | |||
*date | |||
*update | |||
*uid | |||
*edituid | |||
====tagnametb==== | |||
*id | |||
*name (1. main title 2. lexicon title, 3. Alias) | |||
*type | |||
*langid | |||
*isverified | |||
*date | |||
*update | |||
*uid | |||
*edituid | |||
UNIQUE(type, langid) | |||
====taggrouptb==== | |||
*id | |||
*name | |||
*reltb | |||
*parentid | |||
*isvisible | |||
*tagid | |||
--to allow chained adding we need to store the tag that is set on this level (let's say you want to set BDSM and at the same time Pornography which is the level above) | |||
*date | |||
*update | |||
*uid | |||
*edituid | |||
====taggroupreltb==== | |||
*id | |||
*tagid | |||
*gid | |||
*hasweight | |||
*usage | |||
*date | |||
*update | |||
*uid | |||
*edituid | |||
UNIQUE(tagid, gid) | |||
====tagentityreltb==== | |||
*id | |||
*tagid | |||
*relid | |||
*reltb | |||
*weight | |||
*isspoiler | |||
*date | |||
*update | |||
*uid | |||
*edituid | |||
UNIQUE(tagid, relid, reltb) | |||
===Option B=== | |||
Display groups would be defined as "is abstract" and "is visible" | |||
====tagtb==== | |||
*id | |||
*description | |||
*tooltip | |||
*picurl | |||
*isverified | |||
*usage | |||
*redirectid | |||
--in case similar tags with different names should share a lexicon entry (German and Germany for instance) | |||
*date | |||
*update | |||
*uid | |||
*edituid | |||
====tagnametb==== | |||
*id | |||
*name (1. main title 2. lexicon title, 3. Alias) | |||
*type | |||
*langid | |||
*isverified | |||
*date | |||
*update | |||
*uid | |||
*edituid | |||
UNIQUE(type, langid) | |||
====tagentityreltb==== | |||
*id | |||
*tagid | |||
*relid | |||
*reltb | |||
*weight | |||
*isspoiler | |||
*date | |||
*update | |||
*uid | |||
*edituid | |||
UNIQUE(tagid, relid, reltb) | |||
====tagreltb==== | |||
*id | |||
*tagid | |||
*parentid | |||
*reltb | |||
*usage | |||
*is_abstract | |||
*is_visible | |||
*has_weight | |||
*is_spoiler | |||
*is_important | |||
*is_porn_only | |||
*is_general_only | |||
*is_blocked | |||
*date | |||
*update | |||
*uid | |||
*edituid | |||
UNIQUE(tagid, reltb) | |||
==Todo== | ==Todo== | ||
* fix the anime tags data pool | * fix the anime tags data pool | ||
:* remove crap | |||
:* merge dupes | |||
:* change titles/purpose to something sane for certain tags | |||
===Open Questions=== | ===Open Questions=== | ||
* Are biased and subjective tags | * <s>Are biased and subjective tags really needed (for anime)?</s> | ||
:* If yes do we need a different presentation? | :* <s>If yes do we need a different presentation?</s> NO | ||
* Is there a need for certain tags in an approved group for a certain entity to not be available or the other way around | * <s>Is there a need for certain tags in an approved group for a certain entity to not be available or the other way around</s> | ||
:* Are there tags that would be grouped differently for different entities?/do we need groups per entity? | :* <s>Are there tags that would be grouped differently for different entities?/do we need groups per entity?</s> YES | ||
* How do we display the content on the anime page? Clouds? Listings? Mixed depending on type? | * How do we display the content on the anime page? Clouds? Listings? Mixed depending on type? | ||
[[Category:Development]] | [[Category:Development]] |