Phase 1: Database Schema & Models

• Description: Create/extend DBIx::Class Result classes for workshop data model. The schema system will auto-generate database tables and columns from these Result classes. WHY: Schema-driven approach ensures type safety, relationship integrity, and automatic migration. This establishes the data foundation for all workshop functionality including lifecycle management, multi-site support, participant tracking, content management, email history, and role-based access.
• Start Date: 2026-02-15
• End Date: 2026-02-20
• Status: Completed
• Project Code: WS-P1
• Project Size: 2
• Estimated Man Hours: 8
• Developer Name: Zencoder AI
• Client Name: Internal
• Comments: Schema-driven migration via DBIx::Class. Extend WorkShop.pm and Participant.pm. Create WorkshopContent.pm, WorkshopEmail.pm, WorkshopRole.pm, SiteWorkshop.pm. Schema system handles table creation automatically.

📋 Todos for Phase 1: Database Schema & Models (8)

Subject	Description	Start Date	Due Date	Status	Priority	Accumulated Time	Actions
Extend WorkShop.pm Result class	Add columns: status, created_by, created_at, updated_at, registration_deadline, site_id. Add relationships: creator, participants, content, emails, site_associations. Add methods: current_participants, is_full, can_register	2026-02-16	2026-02-20	Completed	Critical	0h 0m	Edit Details Add Log
Extend Participant.pm Result class	Add columns: user_id, email, site_affiliation, registered_at, status. Add relationship to User model	2026-02-16	2026-02-20	Completed	Critical	0h 0m	Edit Details Add Log
Create WorkshopContent.pm Result class	Define table workshop_content with columns: id, workshop_id, content_type, title, content, file_id, sort_order, timestamps. Add relationships to WorkShop and File. Load TimeStamp component	2026-02-16	2026-02-20	Completed	Critical	0h 0m	Edit Details Add Log
Create WorkshopEmail.pm Result class	Define table workshop_emails with columns: id, workshop_id, sent_by, subject, body, sent_at, recipient_count, status. Add relationships to WorkShop and User (sender)	2026-02-16	2026-02-20	Completed	Critical	0h 0m	Edit Details Add Log
Create WorkshopRole.pm Result class	Define table workshop_roles with columns: id, user_id, workshop_id, role, site_id, granted_by, granted_at. Add relationships to User, WorkShop, granter. Add unique constraint on user_id + workshop_id	2026-02-16	2026-02-20	Completed	Critical	0h 0m	Edit Details Add Log
Create SiteWorkshop.pm Result class	Define table site_workshop with columns: id, site_id, workshop_id, created_at. Add relationship to WorkShop. Add unique constraint on site_id + workshop_id	2026-02-16	2026-02-20	Completed	Critical	0h 0m	Edit Details Add Log
Update Schema/Ency.pm to register new Result classes	Register WorkshopContent, WorkshopEmail, WorkshopRole, SiteWorkshop in Schema/Ency.pm result class list	2026-02-16	2026-02-20	Completed	Critical	0h 0m	Edit Details Add Log
Verify schema loads and tables auto-generate	Run perl syntax checks on all Result classes. Start application to trigger schema system table creation. Verify all tables created correctly	2026-02-16	2026-02-20	Completed	Critical	0h 0m	Edit Details Add Log

No sub-projects found. Add a sub-project