227
edits
User:Dvdkhl/Ideas: Difference between revisions
→Prerequisites
| Line 47: | Line 47: | ||
* Anime(<u>Id</u>, ...) | * Anime(<u>Id</u>, ...) | ||
* Entity(<u>Id</u>, EntityType, GuiseId, Name, ...) | * Entity(<u>Id</u>, EntityType, GuiseId, Name, ...) | ||
* Used to describe an entity in a single state (Specific point in time or episode) | |||
** ⊇ Character(<u>Id</u>, Gender, DateOfBirth, DateOfDeath, Age, ...) | ** ⊇ Character(<u>Id</u>, Gender, DateOfBirth, DateOfDeath, Age, ...) | ||
** ⊇ Organisation(<u>Id</u>, ...) | ** ⊇ Organisation(<u>Id</u>, ...) | ||
| Line 52: | Line 53: | ||
** ⊇ Mecha(<u>Id</u>, ...) | ** ⊇ Mecha(<u>Id</u>, ...) | ||
* EntityGuise(<u>EgoId</u>, <u>GuiseOfId</u>) | * EntityGuise(<u>EgoId</u>, <u>GuiseOfId</u>) | ||
** Connects characters which are the '''same''' character only in a different state (Aged, Transformed, etc.) | |||
* Anime_EntityEntityRelation(<u>AId</u>, <u>RelationType</u>, RelationId) | * Anime_EntityEntityRelation(<u>AId</u>, <u>RelationType</u>, RelationId) | ||
** Anime_EntityEntityRelation.RelationId as Primary Key for Relation Models | ** Anime_EntityEntityRelation.RelationId as Primary Key for Relation Models | ||
** Each model has its own tables | ** Each model has its own tables | ||
** The usage is defined by each model/view pair | ** The usage is defined by each model/view pair | ||
=== Presets === | === Presets === | ||