Database Structure

• assets
• assignments
• attachments
• attrs
• lists
• logs
• notifications
• permissions
• scripts
• sms
• users

assets

• assetId
• assetName
• type - enum, "project", "shot"
• dueDate

assignments

• assignmentId
• userId
• assetId
• dueDate
• description e.g. "lighting"

attachments

• attachmentId
• logEntryId
• filePath

attrs

• attrId
• assetId
• attrKey
• attrVal

lists

• listId
• parentId
• parentType - enum "show","user"
• listLabel - "My Shots"

logs

• entryId
• assetId
• timestamp
• text
• entryType - "user","system"
• userId

notifications

• notificationId
• userId
• assetId
• notifyFor - "user","system","both"
• notifyVia - "email","sms","both"

permissions

• permissionId
• assetId
• userId
• permissionLevel - "none","guest","basic","admin"

scripts

• scriptId
• scriptName
• scriptPath

sms

• smsId
• carrierName
• carrierEmail

users

• userId
• userName
• password
• email
• cellNum
• cellCarrier