Mercurial > malikania
comparison 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 |
comparison
equal
deleted
inserted
replaced
| 99:0addfab87b17 | 100:0e9c01d3e0d1 |
|---|---|
| 1 # Spell | |
| 2 | |
| 3 Each `character` have a series of spell that is customized by the user. | |
| 4 | |
| 5 ## Table recommandation | |
| 6 | |
| 7 | field | type | | |
| 8 |---------------|---------------------------| | |
| 9 | id | big integer (primary key) | | |
| 10 | character_id | big integer | | |
| 11 | level | short int | | |
| 12 | name | string | | |
| 13 | |
| 14 - **id**: unique idenfitier, | |
| 15 - **character_id**: references character.id, | |
| 16 - **level**: spell level, | |
| 17 - **name**: name of spell, to instanciate in the game. |