+----------------------+------------------+------+-----+---------+----------------+
| Field                | Type             | Null | Key | Default | Extra          |
+----------------------+------------------+------+-----+---------+----------------+
| email                | varchar(255)     | NO   |     |         |                |
| encrypted_password   | varchar(128)     | NO   |     |         |                |
| remember_token       | varchar(255)     | YES  |     | NULL    |                |
| remember_created_at  | datetime         | YES  |     | NULL    |                |
| reset_password_token | varchar(255)     | YES  |     | NULL    |                |
| sign_in_count        | int(11)          | YES  |     | 0       |                |
| current_sign_in_at   | datetime         | YES  |     | NULL    |                |
| last_sign_in_at      | datetime         | YES  |     | NULL    |                |
| current_sign_in_ip   | varchar(255)     | YES  |     | NULL    |                |
| last_sign_in_ip      | varchar(255)     | YES  |     | NULL    |                |
| favorites_count      | int(11)          | YES  | MUL | 0       |                |
| accept_notes         | int(11)          | YES  |     | 1       |                |
| notes_count          | int(11)          | YES  | MUL | 0       |                |
| id                   | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| per_page_count       | int(11)          | YES  | MUL | 25      |                |
| name                 | varchar(50)      | YES  |     | NULL    |                |
| timezone             | varchar(50)      | YES  |     | UTC     |                |
| admin                | tinyint(1)       | YES  |     | 0       |                |
| enabled              | tinyint(1)       | YES  |     | 1       |                |
| gravatar             | tinyint(1)       | YES  |     | 0       |                |
| created_at           | datetime         | NO   |     | NULL    |                |
| updated_at           | datetime         | NO   |     | NULL    |                |
| avatar_file_name     | varchar(255)     | YES  |     | NULL    |                |
| avatar_content_type  | varchar(255)     | YES  |     | NULL    |                |
| avatar_file_size     | int(11)          | YES  |     | NULL    |                |
| avatar_updated_at    | datetime         | YES  |     | NULL    |                |
+----------------------+------------------+------+-----+---------+----------------+

Back to Database Schema

Back to Snorby E-Book