view 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 source

# 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.