3,699
edits
ClassificationSystem DEV: Difference between revisions
→Database
| Line 89: | Line 89: | ||
==Database== | ==Database== | ||
===tagtb=== | ===Option A=== | ||
====tagtb==== | |||
*id | *id | ||
*description | *description | ||
*tooltip | *tooltip | ||
*picurl | *picurl | ||
* | *isverified | ||
* | *isspoiler | ||
* | *isimportant | ||
*usage | *usage | ||
*redirectid | *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 | ||
* | *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 | ||
* | *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 | ||
* | *langid | ||
* | *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 | ||
* | *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== | ||