3,699
edits
ClassificationSystem DEV: Difference between revisions
m
no edit summary
mNo edit summary |
|||
| (4 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 | *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 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 | *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== | ||