Database draft
by David Coll
1. poutils_types
1.1. id
1.1.1. hasMany ressource_id
1.2. New node
2. pages_outils
2.1. id
2.2. poutils_type_id
2.2.1. belongsTo
2.3. category_id
2.3.1. belongsTo
2.4. level_id
2.4.1. belongsTo
2.5. title
3. comments
3.1. id
3.2. user_id
3.2.1. belongsTo
3.3. page_id
3.3.1. belongsTo
3.4. title
3.5. content
4. poutils_types_ressources
4.1. JOIN table
4.2. poutils_type_id
4.3. ressources_id
5. categories
5.1. id
5.2. name
5.3. cat_order
6. levels
6.1. id
6.2. name
6.3. lvl_order
7. tags
7.1. id
7.2. name
8. comments_tags
8.1. JOIN table
8.2. comment_id
8.3. tag_id
9. users
9.1. id
9.2. username
9.3. password
10. groups
10.1. id
10.2. name
10.3. chief
11. profiles
11.1. id
11.2. user_id
11.2.1. belongsTo
11.3. name
11.4. study_year
11.5. email
12. groups_users
12.1. JOIN table
12.2. group_id
12.3. user_id
13. ressources
13.1. id
13.1.1. hasMany poutils_type_id
13.2. url
13.3. position
13.3.1. inside/outside website