3,699
edits
ClassificationSystem DEV: Difference between revisions
Jump to navigation
Jump to search
m
no edit summary
m (→Todo) |
mNo edit summary |
||
| (11 intermediate revisions by the same user not shown) | |||
| 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 89: | Line 87: | ||
==Database== | ==Database== | ||
===tagtb=== | ===Option A=== | ||
====tagtb==== | |||
*id | *id | ||
*description | *description | ||
*tooltip | *tooltip | ||
*picurl | *picurl | ||
* | *isverified | ||
* | *isspoiler | ||
* | *isimportant | ||
*usage | *usage | ||
*redirectid | |||
--in case similar tags with different names should share a lexicon entry (German and Germany for instance) | |||
*date | *date | ||
*update | *update | ||
| Line 103: | Line 104: | ||
*edituid | *edituid | ||
===tagnametb=== | ====tagnametb==== | ||
*id | *id | ||
*name (1. main title 2. lexicon title, 3. Alias) | *name (1. main title 2. lexicon title, 3. Alias) | ||
*type | *type | ||
*langid | *langid | ||
* | *isverified | ||
*date | *date | ||
*update | *update | ||
*uid | *uid | ||
*edituid | *edituid | ||
UNIQUE(type, langid) | |||
===taggrouptb=== | ====taggrouptb==== | ||
*id | *id | ||
*name | *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 | *date | ||
*update | *update | ||
*uid | *uid | ||
*edituid | *edituid | ||
UNIQUE(tagid, gid) | |||
=== | ====tagentityreltb==== | ||
*id | *id | ||
*tagid | *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 | *type | ||
* | *langid | ||
* | *isverified | ||
*date | *date | ||
*update | *update | ||
*uid | *uid | ||
*edituid | *edituid | ||
UNIQUE(type, langid) | |||
===tagentityreltb=== | ====tagentityreltb==== | ||
*id | *id | ||
*tagid | *tagid | ||
| Line 142: | Line 188: | ||
*reltb | *reltb | ||
*weight | *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_spoiler | ||
*is_important | |||
*is_porn_only | |||
*is_general_only | |||
*is_blocked | |||
*date | *date | ||
*update | *update | ||
*uid | *uid | ||
*edituid | *edituid | ||
UNIQUE(tagid, reltb) | |||
==Todo== | ==Todo== | ||
| Line 152: | Line 219: | ||
:* remove crap | :* remove crap | ||
:* merge dupes | :* merge dupes | ||
:* change titles/purpose to something sane for | :* 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]] | ||