Rewrote the existing bits of the Web interface to match the new database structure, and began figuring out how best to handle uploading document and image files. This is the plan right now:

• When you create a new record in a table which has file uploads (i.e. References and Images), you can specify a file to upload.
• When it's uploaded to the server, a sanitized, rationalized version of its filename is created; this is also stored in a text field.
• When you view or edit the record, you see the filename. If you choose to delete or modify that (by pressing a button), you're given the upload control again. At this point, if nothing is uploaded, the existing fields are emptied (the filename field and the binary field); otherwise, they're replaced with the new data.
• Eventually, when we've figured out how to do this, the filename will be shown in the form of a link which you can click on to download the file.