Answer the question
In order to leave comments, you need to log in
What is the best way to design a database for cloud storage (files)?
You need to make your file storage in the "cloud", such as Google / Yandex / mail, etc., while I started with designing a database for this business.
I made a database schema, you can tell me what else you can add / remove or help with advice, I think that something is missing and I would like to decide in advance so as not to redo it.
Will work on ASP.NET MVC and MS SQL.
To work with files, there will be a Web interface and WebApi.
Access to files will be both via direct links and via api from another IS (therefore, differentiation by fields, or without roles, but with a referral link check, i.e. if it’s not my domain, then you can’t download it) + you need to have digital signatures for files .
I plan to organize files on the server in the following format:
Option 1.
-files(root)
Option 2:
-files
(
root)
--bfa0dd80-76f2-4b9c -99bc-e63197277ed9(directory ID)
---026f8e459c8f89ef75fa7a78265a0025(file name(calculate MD5 hash to avoid duplicates))
Database version at the moment:
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question