227
edits
User:Dvdkhl/Ideas: Difference between revisions
Jump to navigation
Jump to search
→Character Relations Graph (2. Approach)
| Line 32: | Line 32: | ||
* Take the first selected entity for the cursor | * Take the first selected entity for the cursor | ||
* Switching cursor position replaces the selected items and with the new cursor entity | * Switching cursor position replaces the selected items and with the new cursor entity | ||
=== Models === | === Models === | ||
| Line 40: | Line 41: | ||
* Avoid complex structures | * Avoid complex structures | ||
** No reference to other models allowed | ** No reference to other models allowed | ||
=== Prerequisites === | === Prerequisites === | ||
(Assumed) Global DB Tables: | (Assumed) Global DB Tables: | ||
* Anime(<u>Id</u>, ...) | * Anime(<u>Id</u>, ...) | ||
* Entity(<u>Id</u>, EntityType, GuiseId, Name, ...) | * Entity(<u>Id</u>, EntityType, GuiseId, Name, ...) | ||
| Line 55: | Line 56: | ||
** 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 === | |||
<div style="margin-left: 1em; background-color: #F8FFFF; border: 3px black double;"> | |||
== Social == | |||
Replacement for the "family of" relation. Currently there is no standardized way to specify blood relations. | |||
This makes it impossible to form small groups of information like a group with only directly related characters (i.e. Father, Mother, Children). | |||
But since this Character-Relations approach is based on displaying small groups of information a more fine grained representation is necessary. | |||
<div style="padding-left: 1em;"> | |||
=== Model === | |||
* Additional Tables | |||
** FamilyRelations(RelationId, ChildId, ParentId, IsVirtualParent, IsAdopted) | |||
** SocialUnions(<u>Id</u>, TypeId) | |||
** SocialUnionTypes(<u>Id</u>, Label, Style) | |||
** SocialUnionMembers(RelationId, MemberId, UnionId) | |||
; FamilyRelations | |||
: Represents the bloodline of characters | |||
: For sibling relations where the parents do not exist a virtual parent is created and the fields are set accordingly | |||
: For more flexibility IsAdopted can be set to true for adopted children or other kinds of families (e.g. Patchwork families where no blood relations exist) | |||
; SocialUnions | |||
: Used to describe bonds of social status (i.e. Marriage, PoliticalMarriage, PatchworkFamily) | |||
; SocialUnionTypes | |||
: Used by views to define default style | |||
; SocialUnionMembers | |||
: Used to map characters to social unions | |||
: If necessary add a Type field to describe directional relations (i.e. (King, Mistress) vs (Queen, Lover or whatever the equivalent for Male Mistress is)) | |||
=== Views === | |||
</div></div> | |||
== Character Relations Graph (Abandoned) == | == Character Relations Graph (Abandoned) == | ||