ClassificationSystem DEV: Difference between revisions

Jump to navigation Jump to search
Line 89: Line 89:


==Database==
==Database==
===tagtb===
===Option A===
====tagtb====
*id
*id
*description
*description
*tooltip
*tooltip
*picurl
*picurl
*is_verified
*isverified
*is_spoiler
*isspoiler
*is_important
*isimportant
*usage
*usage
*redirectid #in case similar tags with different names should share a lexicon entry (German and Germany for instance)
*redirectid
--in case similar tags with different names should share a lexicon entry (German and Germany for instance)
*date
*date
*update
*update
Line 104: Line 106:
*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
*is_verified
*isverified
*date
*date
*update
*update
*uid
*uid
*edituid
*edituid
UNIQUE(type, langid)


===taggrouptb===
====taggrouptb====
*id
*id
*name
*name
*reltb
*parentid
*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
*date
*update
*update
Line 124: Line 131:
*edituid
*edituid


===taggroupreltb===
====taggroupreltb====
*id
*id
*tagid
*tagid
*groupid
*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===
====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
*type
*has_weight
*langid
*usage
*isverified
*date
*date
*update
*update
*uid
*uid
*edituid
*edituid
UNIQUE(type, langid)


===tagentityreltb===
====tagentityreltb====
*id
*id
*tagid
*tagid
Line 142: Line 191:
*reltb
*reltb
*weight
*weight
*is_spoiler
*isspoiler
*date
*update
*uid
*edituid
UNIQUE(tagid, relid, reltb)
 
====tagtagreltb====
*id
*tagid
*parentid
*reltb
*hasweight
*usage
*date
*update
*uid
*edituid
UNIQUE(tagid, parentid, reltb)
 
====tagreltb====
*id
*tagid
*reltb
*isabstract
*isvisible
*date
*date
*update
*update
*uid
*uid
*edituid
*edituid
UNIQUE(tagid, reltb)


==Todo==
==Todo==

Navigation menu

MediaWiki spam blocked by CleanTalk.
MediaWiki spam blocked by CleanTalk.