ClassificationSystem DEV: Difference between revisions

← Older edit

ClassificationSystem DEV (view source)

Revision as of 12:11, 13 October 2012

2,015 bytes added , 13 October 2012

m

no edit summary

Der Idiot

Bureaucrats, Interface administrators, Administrators

3,699

edits

@@ Line 29: / Line 29: @@
 * 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)
+* 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.
@@ Line 48: / Line 49: @@
 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:
-:tag 5 (<number of usage>)
+:tag 5 (<number of usage>) [<weight if applicable>]
 etc.
@@ Line 60: / Line 61: @@
 Character Tags on the anime page could be displayed like this as well.
-Open question here is if clouds should be ditched alltogether or if a mixed display is wanted.
 ==Import Scenarios==
@@ Line 83: / Line 82: @@
 ===Creator Tags===
 * 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==
 * fix the anime tags data pool
+:* remove crap
+:* merge dupes
+:* change titles/purpose to something sane for certain tags
 ===Open Questions===
-* Are biased and subjective tags are really needed (for anime)?
+* <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?
 [[Category:Development]]