Refactor: Update Drizzle schema and relations

Commit notes

This commit updates the Drizzle schema and relations to reflect recent changes in the database structure. It includes adding new fields, modifying existing ones, and adjusting relationships between tables.

Co-authored-by: armin.naimi <[email redacted]>