Mercurial > malikania

annotate docs/specs/db/spell.md @ 100:0e9c01d3e0d1

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Misc: write database specs, closes #682
author David Demelier <markand@malikania.fr>
date Mon, 21 Aug 2017 07:39:41 +0200
parents
children 42d2367132df
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
100
0e9c01d3e0d1 Misc: write database specs, closes #682
David Demelier <markand@malikania.fr>
parents:
diff changeset
1 # Spell
0e9c01d3e0d1 Misc: write database specs, closes #682
David Demelier <markand@malikania.fr>
parents:
diff changeset
2
0e9c01d3e0d1 Misc: write database specs, closes #682
David Demelier <markand@malikania.fr>
parents:
diff changeset
3 Each `character` have a series of spell that is customized by the user.
0e9c01d3e0d1 Misc: write database specs, closes #682
David Demelier <markand@malikania.fr>
parents:
diff changeset
4
0e9c01d3e0d1 Misc: write database specs, closes #682
David Demelier <markand@malikania.fr>
parents:
diff changeset
5 ## Table recommandation
0e9c01d3e0d1 Misc: write database specs, closes #682
David Demelier <markand@malikania.fr>
parents:
diff changeset
6
0e9c01d3e0d1 Misc: write database specs, closes #682
David Demelier <markand@malikania.fr>
parents:
diff changeset
7 | field | type |
0e9c01d3e0d1 Misc: write database specs, closes #682
David Demelier <markand@malikania.fr>
parents:
diff changeset
8 |---------------|---------------------------|
0e9c01d3e0d1 Misc: write database specs, closes #682
David Demelier <markand@malikania.fr>
parents:
diff changeset
9 | id | big integer (primary key) |
0e9c01d3e0d1 Misc: write database specs, closes #682
David Demelier <markand@malikania.fr>
parents:
diff changeset
10 | character_id | big integer |
0e9c01d3e0d1 Misc: write database specs, closes #682
David Demelier <markand@malikania.fr>
parents:
diff changeset
11 | level | short int |
0e9c01d3e0d1 Misc: write database specs, closes #682
David Demelier <markand@malikania.fr>
parents:
diff changeset
12 | name | string |
0e9c01d3e0d1 Misc: write database specs, closes #682
David Demelier <markand@malikania.fr>
parents:
diff changeset
13
0e9c01d3e0d1 Misc: write database specs, closes #682
David Demelier <markand@malikania.fr>
parents:
diff changeset
14 - **id**: unique idenfitier,
0e9c01d3e0d1 Misc: write database specs, closes #682
David Demelier <markand@malikania.fr>
parents:
diff changeset
15 - **character_id**: references character.id,
0e9c01d3e0d1 Misc: write database specs, closes #682
David Demelier <markand@malikania.fr>
parents:
diff changeset
16 - **level**: spell level,
0e9c01d3e0d1 Misc: write database specs, closes #682
David Demelier <markand@malikania.fr>
parents:
diff changeset
17 - **name**: name of spell, to instanciate in the game.