# 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               |
| nickname      | string unique not null    |
| classname     | string not null           |
| level         | short uint                |
| hp            | short uint                |

## Fields

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

## Associations

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