---
# System prepended metadata

title: DDAC System

---

# DDAC System

## Features
### User
- View posts
- Subscribe to posts
- Like comment posts
- Contact support
- Save posts (read later)
- Share post
- Download article

### Editor
- Register
- Modify account details / Publisher information
- Create and edit posts
- Remove created posts
- Contact support
### Administrator
- Approve or reject posts before publication
- Remove posts, comments
- Create/Edit new or existing posts
- Manage user access rights
- Manage the pricing group for each post/publisher

## Database Design
### SQL
#### User Table
- name
- surname
- email
- password
- role
- img_url

#### Subscription Table (might be nested under post)
- user_id
- post_id

#### Saved Posts Table (might be nested under post)
- user_id
- post_id

#### Post likes (might be nested under post)
- user_id
- post_id

#### Comment likes (might be nested under comments)
- user_id
- comment_id

### Cosmos DB (NoSQL)
#### Post 
- author
- title
- description
- img_url
- likes
- created_at
- plan 
- genre
- approved

#### Comment (if can be nested into post then nest)
- post_id
- author
- comment
- likes

#### Message
- from
- to 
- message

#### Report (might be nested under post)
- post_id
- author 
- description


### Blob
#### Images
#### Videos (maybe)