view docs/specs/db/character.md @ 107:6f4965c26ceb

Server: add basic accounts tests, #682
author David Demelier <markand@malikania.fr>
date Tue, 05 Sep 2017 13:33:57 +0200
parents 0e9c01d3e0d1
children 42d2367132df
line wrap: on
line source

# Character

A character is a playable entity that is owned by an `account`.

## Table recommandation

| field         | type                      |
|---------------|---------------------------|
| id            | big integer (primary key) |
| account_id    | big integer               |
| level         | short uint                |
| hp            | short uint                |

  - **id**: unique idenfitier,
  - **account_id**: references account.id,
  - **level**: current character level,
  - **hp**: current heal points.

## Associations

````nohighlight
+---------------+       0..* +---------------+
| character     +------------+ spell         |
+---------------+            +---------------+
````