view docs/specs/db/account.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 6f4965c26ceb
line wrap: on
line source

# Account

The account object defines a unique login on the server side.

## Table recommandation

| field         | type                      |
|---------------|---------------------------|
| id            | big integer (primary key) |
| login         | string not null           |
| email         | string not null           |
| firstname     | string not null           |
| lastname      | string                    |
| createdate    | date (default to now)     |

## Associations

````nohighlight
+---------------+       0..* +---------------+
| account       +-----+------+ character     |
+---------------+     |      +---------------+
                      |
                      |
                      | 0..* +---------------+
                      +------+ connect_log   +
                             +---------------+
````