diff 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
line wrap: on
line diff
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/docs/specs/db/spell.md	Mon Aug 21 07:39:41 2017 +0200
@@ -0,0 +1,17 @@
+# Spell
+
+Each `character` have a series of spell that is customized by the user.
+
+## Table recommandation
+
+| field         | type                      |
+|---------------|---------------------------|
+| id            | big integer (primary key) |
+| character_id  | big integer               |
+| level         | short int                 |
+| name          | string                    |
+
+  - **id**: unique idenfitier,
+  - **character_id**: references character.id,
+  - **level**: spell level,
+  - **name**: name of spell, to instanciate in the game.