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_timeupdated date