I’m thinking of a collaborative Desktop application, database driven, that can output a final SRT file and allows one or more “Directors” to manage which riffs are “Canon” for the project.
Hey, just because I’m on vacation away from a PC that doesn’t mean I’m not thinking of this… at my hotel, poolside while my kids are whacking each other with pool noodles.
Here’s what I’ve got so far for database tables, for those of us that are more technically inclined:
User
UserName varchar(50)
Email varchar(250)
PassHash varchar(250)
Content
ID int
FileName varchar(250)
Title varchar(250)
Length int
Data BLOB
RiffProject
ID int
Description varchar(250)
ContentID int > Content.ID
RiffProjectUsers
RiffProjectID int > RiffProject.ID
User varchar(50) > User.UserName
Director bool
Riff
RiffProjectID int > RiffProject.ID
Time DateTimeStamp
Text varchar(4000)
Canon bool
And I can out together a basic UI when I get home that will allow any user to work on any RiffProject at any time, and the “Directors” of the project can choose to canonize or decanonize the specific riffs at any time, as well as add or remove users from a RiffProject (with the option to remove all of the user’s riffs).
