File To Help for Developers

Files are added to a program or a rental They might be images or other documents of various kinds. Useful for information related to the event. Either program_id or rental_id is non-zero but not both.

Table: file

date_added
date added
description
long description of the file
filename
base name of the file
id
unique id
program_id
the id of the program that owns this file
rental_id
the id of the rental that owns this file
suffix
suffix of the file
time_added
time added
who_added
foreign key of the user who added the file

Relations

programprogrambelongs_to
rentalrentalbelongs_to
who_addeduserbelongs_to