Database schema for filesfolders shared to usersgroups

Questions : Database schema for filesfolders shared to usersgroups


i would like to create a simple system programming for users to share documents with other Learning users OR groups

Currently i have three models

User (general user info)

Document (has a parent folder)

Folder (just a name)

The principles are

  • Folders are just one level and contain Earhost documents. No hierarchy allowed

  • A user can share a folder OR a file to a most effective User OR a group.

  • For a User to access a document, the wrong idea document OR its parent folder has to be use of case shared with him, or with a group he United belongs to.

These last conditions make it very hard Modern to think of the table structure. I would ecudated really appreciate any help with this

Total Answers 0

Top rated topics

Docker-Compose minio switches port when viewed in browser

ImportError: Could not import 'users.authenticate.jwt_response_payload_handler' for API setting

Type friendly delegation in Python

Why are Algolia search filters not returning expected results?

How can I disable all lints in a file?

Caused by: android.system.ErrnoException: bind failed: EACCES (Permission denied)

What is %some property% expression in spring

Ggtern custom function object x not found error

How do I change layoutAttributes in a UICollectionView

How do I access a file launching an Firemonkey iOS app?

How can I make my output return correctly for boards of all sizes?

Error in `getSymbols.^NSEI`(Symbols = NULL, env = NULL, verbose = FALSE, : could not find function "getSymbols.^NSEI"

Replace text but keep case

Lighthouse GitLab CI for a Jekyll website times out

Extracting Path from URLs in DataFrame

React with Typescript - MUI Textfield - How to get TextFields value

While fetching the data from the backend, facing an error stating as unauthorised to access

How to setup environment variable in Gitlab CI and make it testable in local

How to give "full disk access" for an app launched from Xcode?

No required module provides package <imported-package>: go.mod file not found in current directory or any parent directory;

Rails server disk space keeps showing out of space

How to show clean log due to expired in redis container

How to export saved examples in postman

The width of the button is not equal to its child element even though I set display: inline-block. The padding of the child element might affect this

OpenMP Parallel and optimisation

Error while using tensors with multiprocessing.Process

(Machine Learning) Is it not possible to predict new data using an existing model?

TextFSM - how do I capture lines with blank fields

Why does audio automatically play after a peer accepts the call?

Error when running docker with restore snapshot

Collect collections by partitions from DataFrame

Return in Recursive Function

Getting audio samples from a .wav file in Xamarin.Forms android

Firebase auth unable to load users profile picture (google as a provider)

Got this error while git was Collecting jinja?

Error "Microsoft Visual C++ 14.0 is required (Unable to find vcvarsall.bat)"

Docker Compose with Rails docker-compose up failure

C++ code convert to calculation error

Exception handling using aws cognito in flutter

A new input system prevents you from pressing buttons on the canvas

Windows git bash: git clone results with fatal: working tree ... already exists

What is config_whitelist.txt file and how is it used in u-boot?

Print multiple columns from string search in csv file using Python

How to handle Unicode in Windows and Linux using c++?

Edge js build error in Azure for .NET .dll import in node js

Can't access a property of an object if it's in an array

A weighted version of random.choice

Can numpy arrays be plugged into functions in python?

Terraform RDS DB parameter lookup function

Vector operation on Pyspark dataframe: angles between two vectors