+------------+------------------+------+-----+---------+----------------+
| Field      | Type             | Null | Key | Default | Extra          |
+------------+------------------+------+-----+---------+----------------+
| id         | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| sid        | int(11)          | YES  | MUL | NULL    |                |
| cid        | int(11)          | YES  | MUL | NULL    |                |
| user_id    | int(11)          | YES  | MUL | NULL    |                |
| body       | text             | YES  |     | NULL    |                |
| created_at | datetime         | NO   |     | NULL    |                |
| updated_at | datetime         | NO   |     | NULL    |                |
+------------+------------------+------+-----+---------+----------------+

Back to Database Schema

Back to Snorby E-Book