Mercurial > malikania
annotate docs/specs/db/spell.md @ 100:0e9c01d3e0d1
Misc: write database specs, closes #682
author | David Demelier <markand@malikania.fr> |
---|---|
date | Mon, 21 Aug 2017 07:39:41 +0200 |
parents | |
children | 42d2367132df |
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. |