Database
users - system users
roles - users roles.
directions - medical branches such as Cardiology, Neurology, Pediatrics, etc. Used by both tables users and posts.
sources - additional assets for users and posts such as video, images, etc. Used by both tables users and posts.
institutions - medical institutions of doctors(users), e.g. hospital, clinic or university.
cities - the institutions location.
regions - areas where cities are located
posts - publications with all provided information posted by doctors.
post_types - types of the publications(posts) - article, video, etc.
tags - keywords for posts
1. Create DataBase "dokazovi"
2. Create Login/Group Role
- General - Name: "dokazovi"
- Definition - Password: enter password to DB
- Privileges - Can login: "Yes"
Done!