Lytho Workflow views

Projects are the hub. Work requests and campaigns feed into them, and tasks, proofs, reviews, and time entries all join back through PROJECT_UID, TASK_UID, or PROOF_UID. PROJECT_CUSTOM_FIELDS joins to projects on PROJECT_UID.
Lytho DAM views

Assets are the hub. Files and activity events join on ASSET_ID, and activity and batch downloads join to users on USER_ID. Reference and summary views can be queried on their own.