ClassificationSystem DEV: Difference between revisions

← Older edit

ClassificationSystem DEV (view source)

Revision as of 12:11, 13 October 2012

1,946 bytes added , 13 October 2012

m

no edit summary

Der Idiot

Bureaucrats, Interface administrators, Administrators

3,699

edits

@@ Line 49: / 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 61: / 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 84: / 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]]