VideoHosting database

Coursework for university - I implemented a database similar to YouTube.

Tables scheme

QUICK START

If you use windows

git config --global core.autocrlf false

Git clone this project

git clone https://github.com/BaggerFast/VideoHostingDatabase.git

Set hard password to user SA into docker-compose.yml

MSSQL_SA_PASSWORD=""

Connect to database via docker-compose

docker compose up

Scripts structure
- STRUCTURE.sql - Create table
- TRIGGERS.sql - Create triggers for table
- INSERT.sql - Insert data into table
- SELECT.sql - Select table
- TRUNCATE.sql - Clear table
- DROP.sql - Delete table
Use scripts in this order
- TAGS
- ACCESS_LEVELS
- AGE_RESTRICTIONS
- USERS
- VIDEOS
- FK_VIDEO_TAGS
- VIEW
- COMMENTS
- SUBSCRIPTIONS
- REACTIONS
- PLAYLISTS
- FK_VIDEO_PLAYLISTS
- FUNCTIONS
- PROCEDURES