A
A
Andrey-22021-04-19 11:38:34
Database design
Andrey-2, 2021-04-19 11:38:34

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:

607e7244ac8e2734375903.jpeg

Answer the question

In order to leave comments, you need to log in

1 answer(s)
D
Dimonchik, 2021-04-19
@dimonchik2013

you take these
https://habr.com/ru/post/430970/
well, or 1-2 if there is not enough time, you set it and see how and what is organized, you
highlight the same patterns

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question