Requirement
The Digital Drop Box is a tool that the Instructor, Students and others can use to exchange files. The Digital Drop Box works by uploading a file from a disk or a computer to a depository. Files can be sent back and forth from the Instructor’s Drop Box to the Drop Box of other users in the course. Basically each person has a drop box and others can place files in the drop box. In the context of a course, files that are uploaded by a Learner will always end up in the drop box of the Instructor. The Instructor can review the file(s) and make notes and reload to that particular Learner.
Upload a file (to the Instructors drop box)
Upload a file (to the Students drop box)
Delete a file (from their own drop box)
DB schema
A new model 'DropBoxItem' which extends from Asset. (All the uploads in to the system are stored in Asset). DorpBoxItem will have details of the files uploaded and the owner id. All the files that gets uploaded to DropBoxItem, gets converted to swf through paperclip processor.
Additionaly, a new table is created to store the details of who has permission to others DropBoxItem
Table Name : drop_box_permissions
| Column_name | type | Description |
|---|---|---|
| id | integer | primary key |
| asset_id | integer | references the dropboxitem in the asset table |
| associate_id | integer | user who can access the DropBoxItem |
| associate_type | varchar | type of dropbox, user or course |
| create_at | date_time | created date |
| updated_at | date_time | updated date |
