Index: relational_schema.txt
===================================================================
--- relational_schema.txt	(revision c859c173b67061c05538945f86bc1e237a320d7d)
+++ relational_schema.txt	(revision c859c173b67061c05538945f86bc1e237a320d7d)
@@ -0,0 +1,47 @@
+## Relational Schema
+
+1. **users** (_**username**_, is_activate, password, description, registered_at, sex)
+
+2. **moderator** (_**username#(users)**_) [inherits users]
+
+3. **developer** (_**username#(users)**_) [inherits users]
+
+4. **project_manager** (_**username#(users)**_) [inherits users]
+
+5. **thread** (_**id**_, description, logo_url, title, username#(users))
+
+6. **likes** (_**username#(users)**_, _**thread_id#(thread)**_)
+
+7. **threads_moderators** (_**thread_id#(thread)**_, _**username#(users)**_)
+
+8. **tag** (_**name**_)
+
+9. **tag_threads** (_**thread_id#(thread)**_, _**tag_name#(tag)**_)
+
+10. **topic_thread** (_**id**_, description, logo_url, title, username#(users), guidelines, next_discussion_id) [inherits thread]
+
+11. **project_thread** (_**id**_, description, logo_url, title, username#(users), repo_url) [inherits thread]
+
+12. **discussion_thread** (_**id**_, _**topic_id#(thread)**_, text, created_by_user#(users), reply_discussion, reply_topic_id)
+
+13. **topic_belongs_to_project** (_**topic_id#(thread)**_, _**project_id#(thread)**_)
+
+14. **topic_blacklist** (_**username#(users)**_, _**project_id#(users)**_)
+
+15. **developer_associated_with_project** (_**project_id#(thread)**_, _**developer#(users)**_, _**started_at**_, ended_at)
+
+16. **permissions** (_**name**_)
+
+17. **project_roles** (_**name**_, _**project_id#(thread)**_, description)
+
+18. **users_project_roles** (_**username#(users)**_, _**project_id#(thread)**_, _**role_name#(project_roles)**_)
+
+19. **project_roles_permissions** (_**permission_name#(permissions)**_, _**role_name#(project_roles)**_, _**project_id#(thread)**_)
+
+20. **project_request** (_**id**_, reason, status, submited_by_user#(users), for_project#(thread))
+
+21. **report** (_**id**_, created_at, description, status, thread_id#(thread), for_user#(users), by_user#(users))
+
+22. **channel** (_**name**_, description, logo_url, _**project_id#(thread)**_, developer#(users))
+
+23. **messages** (_**sent_at**_, content, _**sent_by#(users)**_, _**project_id#(thread)**_, _**channel_name#(channel)**_)