AuraLinksTable

table

Breakdex::DataStores::AuraLinksTable

Directed edges in the move transition graph with affinity weights

An aura link is a transition from one move to another with an affinity rating. Natural transitions flow easily, possible transitions require effort, stretch transitions are aspirational. Together they form the breakdancer's personal flow graph.

Relationships

Depends On 1

aura_dao

Reads From 1

moves_table

Breaks If 2

move_id_format_changescascade_delete_creates_dangling_edges

Data Access

\u2190 Reads 1

moves_table

Answers

Columns

NameTypeConstraints
from_move_idtextNOT NULL
to_move_idtextNOT NULL
affinitytextNOT NULL ENUM: natural, possible, stretch
notestext
created_atdatetimeNOT NULL DEFAULT: now

Primary Key

from_move_id, to_move_id

Foreign Keys

from_move_id \u2192 moves
to_move_id \u2192 moves