| Tasks (Task) | title, description, status (To Do, In Progress, Done, Blocked), priority (Low, Medium, High, Urgent), assignee (name/email), project_name, category (Framing, Electrical, Plumbing, HVAC, Drywall, etc.), due_date, start_date, overdue_only (bool), estimated_days | Yes (status, assignee, priority, due_date, start_date, estimated_days, title, description) | Yes | Daily trade dispatch, bottleneck identification, punch lists, urgent reassignment |
| Projects (Project) | name, code, status (Planning, Active, On Hold, Completed, Archived), client_name, start_date, target_completion_date, completion_percentage, velocity | Read / Filter / Scope | Via Project Wizard | Multi-site status overview, schedule milestone audit, executive client reports |
| Timesheets (TimeLog) | user_name / contractor, project_name, task_name, start_date, end_date, hours_spent, is_billable (bool) | Read / Analytics | Via Field Mobile App Timers | Weekly payroll reconciliation, sub vs direct labor breakdown, unbilled labor audit |
| SOP Templates (SOPTemplate) | template_name, category (Site Prep, Rough-In Inspection, Safety, Handover), status (Draft, Active), target_engine (commander, creator, all) | Apply to Project (Instantiates standard checklists) | SOP Editor | Rapid project kickoff, OSHA safety checklist injection, building code compliance |
| Invoices & Billing (Invoice) | invoice_number, client_name, status (Draft, Sent, Paid, Overdue), issue_date, due_date, total_amount, balance_due | Read / Financial Summary | Billing Flow | Tracking unpaid draws, deposit aging, subcontractor change-order reconciliations |
| Team & Subcontractors (User) | name, email, role (Admin, Manager, Worker, Contractor), active_status, trade_specialty | Assignee Lookup | Company Admin | Finding available electricians/carpenters, checking trade capacity, assigning leads |