Also this page links to some in-depth case studies about how it's used:
https://airtable.com?try=videoproduction
If I can offer a suggestion, take a look into ftrack and try to copy some of their core featureset (unless maybe you can already do that, in which case just make a template! ).