The task is to design a database schema allowing to store:
users; their permission levels; information, whether a user has been activated by an admin; recent login
preparations already uploaded to the server; their location on disk; comments; metadata (should be similar to those provided in imzml); dependencies describing derived datasets; users allowed to view a dataset (some may be shared among all users, some may be private and some shared to selected friends)
The task is to design a database schema allowing to store: