+-------------------+----------+------+-----+---------+-------+
| Field             | Type     | Null | Key | Default | Extra |
+-------------------+----------+------+-----+---------+-------+
| sid               | int(11)  | NO   | PRI | NULL    |       |
| cid               | int(11)  | NO   | PRI | NULL    |       |
| signature         | int(11)  | YES  | MUL | NULL    |       |
| classification_id | int(11)  | YES  | MUL | NULL    |       |
| users_count       | int(11)  | YES  | MUL | 0       |       |
| user_id           | int(11)  | YES  | MUL | NULL    |       |
| notes_count       | int(11)  | YES  | MUL | 0       |       |
| timestamp         | datetime | YES  |     | NULL    |       |
+-------------------+----------+------+-----+---------+-------+

Back to Database Schema

Back to Snorby E-Book