3,699
edits
mNo edit summary |
|||
(16 intermediate revisions by the same user not shown) | |||
Line 49: | 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 61: | 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 84: | 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]] |