TestDbContext.cs

using Microsoft.EntityFrameworkCore;

namespace SchemaMagic.Examples;

public class TestDbContext : DbContext
{
    // Core entities with extensive properties
    public DbSet<User> Users { get; set; }
    public DbSet<Company> Companies { get; set; }
    public DbSet<Department> Departments { get; set; }
    public DbSet<Project> Projects { get; set; }
    public DbSet<Task> Tasks { get; set; }
    public DbSet<Document> Documents { get; set; }
    public DbSet<Comment> Comments { get; set; }
    public DbSet<Attachment> Attachments { get; set; }
    public DbSet<Tag> Tags { get; set; }
    public DbSet<TaskTag> TaskTags { get; set; }
    public DbSet<UserProject> UserProjects { get; set; }
    public DbSet<AuditLog> AuditLogs { get; set; }

    protected override void OnModelCreating(ModelBuilder modelBuilder)
    {
        // Configure many-to-many relationships
        modelBuilder.Entity<TaskTag>()
            .HasKey(tt => new { tt.TaskId, tt.TagId });

        modelBuilder.Entity<TaskTag>()
            .HasOne(tt => tt.Task)
            .WithMany(t => t.TaskTags)
            .HasForeignKey(tt => tt.TaskId);

        modelBuilder.Entity<TaskTag>()
            .HasOne(tt => tt.Tag)
            .WithMany(t => t.TaskTags)
            .HasForeignKey(tt => tt.TagId);

        modelBuilder.Entity<UserProject>()
            .HasKey(up => new { up.UserId, up.ProjectId });

        modelBuilder.Entity<UserProject>()
            .HasOne(up => up.User)
            .WithMany(u => u.UserProjects)
            .HasForeignKey(up => up.UserId);

        modelBuilder.Entity<UserProject>()
            .HasOne(up => up.Project)
            .WithMany(p => p.UserProjects)
            .HasForeignKey(up => up.ProjectId);

        // Configure foreign key relationships
        modelBuilder.Entity<Department>()
            .HasOne(d => d.Company)
            .WithMany(c => c.Departments)
            .HasForeignKey(d => d.CompanyId);

        modelBuilder.Entity<User>()
            .HasOne(u => u.Department)
            .WithMany(d => d.Employees)
            .HasForeignKey(u => u.DepartmentId);

        modelBuilder.Entity<Project>()
            .HasOne(p => p.Company)
            .WithMany(c => c.Projects)
            .HasForeignKey(p => p.CompanyId);

        modelBuilder.Entity<Project>()
            .HasOne(p => p.ProjectManager)
            .WithMany(u => u.ManagedProjects)
            .HasForeignKey(p => p.ProjectManagerId);

        modelBuilder.Entity<Task>()
            .HasOne(t => t.Project)
            .WithMany(p => p.Tasks)
            .HasForeignKey(t => t.ProjectId);

        modelBuilder.Entity<Task>()
            .HasOne(t => t.AssignedTo)
            .WithMany(u => u.AssignedTasks)
            .HasForeignKey(t => t.AssignedToId);

        modelBuilder.Entity<Task>()
            .HasOne(t => t.CreatedBy)
            .WithMany(u => u.CreatedTasks)
            .HasForeignKey(t => t.CreatedById);

        modelBuilder.Entity<Document>()
            .HasOne(d => d.Project)
            .WithMany(p => p.Documents)
            .HasForeignKey(d => d.ProjectId);

        modelBuilder.Entity<Document>()
            .HasOne(d => d.UploadedBy)
            .WithMany(u => u.UploadedDocuments)
            .HasForeignKey(d => d.UploadedById);

        modelBuilder.Entity<Comment>()
            .HasOne(c => c.Task)
            .WithMany(t => t.Comments)
            .HasForeignKey(c => c.TaskId);

        modelBuilder.Entity<Comment>()
            .HasOne(c => c.Author)
            .WithMany(u => u.Comments)
            .HasForeignKey(c => c.AuthorId);

        modelBuilder.Entity<Attachment>()
            .HasOne(a => a.Comment)
            .WithMany(c => c.Attachments)
            .HasForeignKey(a => a.CommentId);

        modelBuilder.Entity<Attachment>()
            .HasOne(a => a.UploadedBy)
            .WithMany(u => u.UploadedAttachments)
            .HasForeignKey(a => a.UploadedById);

        modelBuilder.Entity<AuditLog>()
            .HasOne(a => a.User)
            .WithMany(u => u.AuditLogs)
            .HasForeignKey(a => a.UserId);
    }
}

/// <summary>
/// Represents a business organization that manages departments and projects
/// </summary>
[Comment("Business organization entity - root tenant for multi-company operations")]
public class Company
{
    [Comment("Primary key - unique company identifier")]
    public int Id { get; set; }

    /// <summary>
    /// Official company name as registered
    /// </summary>
    [Comment("Official business name")]
    public string Name { get; set; } = string.Empty;

    [Comment("Industry sector classification")]
    public string Industry { get; set; } = string.Empty;

    /// <summary>
    /// Street address of company headquarters
    /// </summary>
    public string Address { get; set; } = string.Empty;

    [Comment("City where company is headquartered")]
    public string City { get; set; } = string.Empty;

    /// <summary>
    /// State or province
    /// </summary>
    public string State { get; set; } = string.Empty;

    [Comment("ZIP or postal code")]
    public string PostalCode { get; set; } = string.Empty;

    /// <summary>
    /// Country of incorporation
    /// </summary>
    [Comment("Country code - ISO 3166-1 alpha-2")]
    public string Country { get; set; } = string.Empty;

    [Comment("Main phone number")]
    public string Phone { get; set; } = string.Empty;

    /// <summary>
    /// Primary contact email for the company
    /// </summary>
    public string Email { get; set; } = string.Empty;

    [Comment("Corporate website URL")]
    public string Website { get; set; } = string.Empty;

    /// <summary>
    /// Tax identification number
    /// </summary>
    [Comment("EIN or Tax ID - used for compliance")]
    public string TaxId { get; set; } = string.Empty;

    [Comment("Date company was established")]
    public DateTime EstablishedDate { get; set; }

    /// <summary>
    /// Total headcount across all departments
    /// </summary>
    public int EmployeeCount { get; set; }

    [Comment("Annual revenue in base currency")]
    public decimal AnnualRevenue { get; set; }

    /// <summary>
    /// Currency code for financial transactions
    /// </summary>
    [Comment("ISO 4217 currency code (USD, EUR, GBP, etc.)")]
    public string Currency { get; set; } = string.Empty;

    [Comment("IANA timezone identifier")]
    public string TimeZone { get; set; } = string.Empty;

    /// <summary>
    /// Indicates if company is operational
    /// </summary>
    [Comment("Active status - false for dissolved companies")]
    public bool IsActive { get; set; }

    [Comment("Record creation timestamp")]
    public DateTime CreatedAt { get; set; }

    /// <summary>
    /// Last modification time
    /// </summary>
    public DateTime UpdatedAt { get; set; }

    [Comment("Username who created this record")]
    public string CreatedBy { get; set; } = string.Empty;

    /// <summary>
    /// Username who last updated this record
    /// </summary>
    public string UpdatedBy { get; set; } = string.Empty;

    /// <summary>
    /// All departments belonging to this company
    /// </summary>
    public ICollection<Department> Departments { get; set; } = new List<Department>();

    /// <summary>
    /// All projects managed by this company
    /// </summary>
    public ICollection<Project> Projects { get; set; } = new List<Project>();
}

/// <summary>
/// Organizational unit within a company
/// </summary>
[Comment("Department entity - organizational subdivision with budget and staff")]
public class Department
{
    [Comment("Primary key")]
    public int Id { get; set; }

    /// <summary>
    /// Department name
    /// </summary>
    [Comment("Department display name")]
    public string Name { get; set; } = string.Empty;

    [Comment("Purpose and responsibilities of department")]
    public string Description { get; set; } = string.Empty;

    /// <summary>
    /// Short code for department
    /// </summary>
    [Comment("Department code - used in accounting")]
    public string Code { get; set; } = string.Empty;

    [Comment("Office location or site name")]
    public string Location { get; set; } = string.Empty;

    /// <summary>
    /// Floor number in building
    /// </summary>
    public string Floor { get; set; } = string.Empty;

    [Comment("Building name or number")]
    public string Building { get; set; } = string.Empty;

    /// <summary>
    /// Department phone extension
    /// </summary>
    public string Phone { get; set; } = string.Empty;

    [Comment("Department contact email")]
    public string Email { get; set; } = string.Empty;

    /// <summary>
    /// Annual budget allocation
    /// </summary>
    [Comment("Budget in company currency")]
    public decimal Budget { get; set; }

    [Comment("GL account cost center code")]
    public string CostCenter { get; set; } = string.Empty;

    /// <summary>
    /// Whether department is currently active
    /// </summary>
    public bool IsActive { get; set; }

    [Comment("Record creation date")]
    public DateTime CreatedAt { get; set; }

    /// <summary>
    /// Last update timestamp
    /// </summary>
    public DateTime UpdatedAt { get; set; }

    [Comment("Additional notes or comments")]
    public string Notes { get; set; } = string.Empty;

    /// <summary>
    /// Foreign key to parent company
    /// </summary>
    [Comment("FK to Companies")]
    public int CompanyId { get; set; }

    /// <summary>
    /// Navigation to parent company
    /// </summary>
    public Company Company { get; set; } = null!;

    /// <summary>
    /// All employees in this department
    /// </summary>
    public ICollection<User> Employees { get; set; } = new List<User>();
}

/// <summary>
/// System user with authentication and profile information
/// </summary>
[Comment("User entity - authentication and employee profile data")]
public class User
{
    [Comment("Primary key - unique user ID")]
    public int Id { get; set; }

    /// <summary>
    /// User's first name
    /// </summary>
    [Comment("Given name")]
    public string FirstName { get; set; } = string.Empty;

    [Comment("Family name or surname")]
    public string LastName { get; set; } = string.Empty;

    /// <summary>
    /// Middle name or initial
    /// </summary>
    public string MiddleName { get; set; } = string.Empty;

    [Comment("Primary email - used for login")]
    public string Email { get; set; } = string.Empty;

    /// <summary>
    /// Unique username for authentication
    /// </summary>
    [Comment("Login username - must be unique")]
    public string Username { get; set; } = string.Empty;

    [Comment("Bcrypt hashed password")]
    public string PasswordHash { get; set; } = string.Empty;

    /// <summary>
    /// Salt used for password hashing
    /// </summary>
    public string Salt { get; set; } = string.Empty;

    [Comment("Office phone number")]
    public string Phone { get; set; } = string.Empty;

    /// <summary>
    /// Mobile phone for SMS and 2FA
    /// </summary>
    [Comment("Mobile number for notifications")]
    public string MobilePhone { get; set; } = string.Empty;

    [Comment("Job title or position")]
    public string JobTitle { get; set; } = string.Empty;

    /// <summary>
    /// Internal employee identification number
    /// </summary>
    [Comment("Employee ID badge number")]
    public string EmployeeId { get; set; } = string.Empty;

    [Comment("Date of birth - for age verification")]
    public DateTime? DateOfBirth { get; set; }

    /// <summary>
    /// Employment start date
    /// </summary>
    [Comment("Date employee was hired")]
    public DateTime HireDate { get; set; }

    [Comment("Date employment ended - null if active")]
    public DateTime? TerminationDate { get; set; }

    /// <summary>
    /// Annual salary amount
    /// </summary>
    [Comment("Salary in specified currency")]
    public decimal Salary { get; set; }

    [Comment("Salary currency code")]
    public string Currency { get; set; } = string.Empty;

    /// <summary>
    /// Home street address
    /// </summary>
    public string Address { get; set; } = string.Empty;

    [Comment("City of residence")]
    public string City { get; set; } = string.Empty;

    /// <summary>
    /// State or province
    /// </summary>
    public string State { get; set; } = string.Empty;

    [Comment("ZIP or postal code")]
    public string PostalCode { get; set; } = string.Empty;

    /// <summary>
    /// Country of residence
    /// </summary>
    [Comment("Country code")]
    public string Country { get; set; } = string.Empty;

    [Comment("Emergency contact name")]
    public string EmergencyContactName { get; set; } = string.Empty;

    /// <summary>
    /// Emergency contact phone
    /// </summary>
    [Comment("Emergency contact phone number")]
    public string EmergencyContactPhone { get; set; } = string.Empty;

    [Comment("Comma-separated skills list")]
    public string Skills { get; set; } = string.Empty;

    /// <summary>
    /// User biography or description
    /// </summary>
    public string Bio { get; set; } = string.Empty;

    [Comment("Avatar image URL")]
    public string ProfileImageUrl { get; set; } = string.Empty;

    /// <summary>
    /// User's preferred timezone
    /// </summary>
    [Comment("IANA timezone identifier")]
    public string TimeZone { get; set; } = string.Empty;

    [Comment("Preferred UI language code")]
    public string Language { get; set; } = string.Empty;

    /// <summary>
    /// Whether user account is active
    /// </summary>
    [Comment("Account active flag")]
    public bool IsActive { get; set; }

    [Comment("Email verified status")]
    public bool IsEmailVerified { get; set; }

    /// <summary>
    /// Phone number verification status
    /// </summary>
    public bool IsPhoneVerified { get; set; }

    [Comment("Last successful login timestamp")]
    public DateTime LastLoginAt { get; set; }

    /// <summary>
    /// IP address of last login
    /// </summary>
    [Comment("Last login IP address")]
    public string LastLoginIp { get; set; } = string.Empty;

    [Comment("Failed login attempt counter")]
    public int LoginAttempts { get; set; }

    /// <summary>
    /// Account lockout expiration
    /// </summary>
    [Comment("Lockout end time - null if not locked")]
    public DateTime? LockedUntil { get; set; }

    [Comment("Record created timestamp")]
    public DateTime CreatedAt { get; set; }

    /// <summary>
    /// Last profile update time
    /// </summary>
    public DateTime UpdatedAt { get; set; }

    /// <summary>
    /// Foreign key to department
    /// </summary>
    [Comment("FK to Departments")]
    public int? DepartmentId { get; set; }

    /// <summary>
    /// Navigation to department
    /// </summary>
    public Department? Department { get; set; }

    /// <summary>
    /// Project assignments for this user
    /// </summary>
    public ICollection<UserProject> UserProjects { get; set; } = new List<UserProject>();

    /// <summary>
    /// Projects where user is manager
    /// </summary>
    public ICollection<Project> ManagedProjects { get; set; } = new List<Project>();

    /// <summary>
    /// Tasks assigned to this user
    /// </summary>
    public ICollection<Task> AssignedTasks { get; set; } = new List<Task>();

    /// <summary>
    /// Tasks created by this user
    /// </summary>
    public ICollection<Task> CreatedTasks { get; set; } = new List<Task>();

    /// <summary>
    /// Documents uploaded by user
    /// </summary>
    public ICollection<Document> UploadedDocuments { get; set; } = new List<Document>();

    /// <summary>
    /// Comments authored by user
    /// </summary>
    public ICollection<Comment> Comments { get; set; } = new List<Comment>();

    /// <summary>
    /// Attachments uploaded by user
    /// </summary>
    public ICollection<Attachment> UploadedAttachments { get; set; } = new List<Attachment>();

    /// <summary>
    /// Audit trail entries for user actions
    /// </summary>
    public ICollection<AuditLog> AuditLogs { get; set; } = new List<AuditLog>();
}

/// <summary>
/// Project tracking entity with budget and timeline
/// </summary>
[Comment("Project entity - tracks initiatives with budget, timeline, and deliverables")]
public class Project
{
    [Comment("Primary key")]
    public int Id { get; set; }

    /// <summary>
    /// Project display name
    /// </summary>
    [Comment("Project name")]
    public string Name { get; set; } = string.Empty;

    [Comment("Detailed project description")]
    public string Description { get; set; } = string.Empty;

    /// <summary>
    /// Short project code
    /// </summary>
    [Comment("Project code - used in tracking")]
    public string Code { get; set; } = string.Empty;

    [Comment("Priority level - High, Medium, Low")]
    public string Priority { get; set; } = string.Empty;

    /// <summary>
    /// Current project status
    /// </summary>
    [Comment("Status - Planning, Active, On Hold, Completed, Cancelled")]
    public string Status { get; set; } = string.Empty;

    [Comment("Current project phase")]
    public string Phase { get; set; } = string.Empty;

    /// <summary>
    /// Approved budget amount
    /// </summary>
    [Comment("Total budget allocation")]
    public decimal Budget { get; set; }

    [Comment("Budget currency code")]
    public string Currency { get; set; } = string.Empty;

    /// <summary>
    /// Actual money spent
    /// </summary>
    [Comment("Actual costs incurred")]
    public decimal ActualCost { get; set; }

    [Comment("Planned start date")]
    public DateTime StartDate { get; set; }

    /// <summary>
    /// Planned end date
    /// </summary>
    [Comment("Target completion date")]
    public DateTime? EndDate { get; set; }

    [Comment("Actual completion date")]
    public DateTime? ActualEndDate { get; set; }

    /// <summary>
    /// Estimated hours to complete
    /// </summary>
    [Comment("Estimated effort in hours")]
    public int EstimatedHours { get; set; }

    [Comment("Actual hours spent")]
    public int ActualHours { get; set; }

    /// <summary>
    /// Completion percentage (0-100)
    /// </summary>
    [Comment("Percent complete - 0 to 100")]
    public decimal PercentComplete { get; set; }

    [Comment("Risk assessment - Low, Medium, High, Critical")]
    public string RiskLevel { get; set; } = string.Empty;

    /// <summary>
    /// Overall project health
    /// </summary>
    [Comment("Health status - On Track, At Risk, Off Track")]
    public string HealthStatus { get; set; } = string.Empty;

    [Comment("Development methodology - Agile, Waterfall, etc.")]
    public string Methodology { get; set; } = string.Empty;

    /// <summary>
    /// Source control repository URL
    /// </summary>
    [Comment("Git repository URL")]
    public string Repository { get; set; } = string.Empty;

    [Comment("Documentation wiki or site URL")]
    public string DocumentationUrl { get; set; } = string.Empty;

    /// <summary>
    /// Whether project is active
    /// </summary>
    [Comment("Active status flag")]
    public bool IsActive { get; set; }

    [Comment("Public visibility flag")]
    public bool IsPublic { get; set; }

    /// <summary>
    /// Project creation timestamp
    /// </summary>
    public DateTime CreatedAt { get; set; }

    [Comment("Last update timestamp")]
    public DateTime UpdatedAt { get; set; }

    /// <summary>
    /// Additional project notes
    /// </summary>
    public string Notes { get; set; } = string.Empty;

    /// <summary>
    /// Foreign key to company
    /// </summary>
    [Comment("FK to Companies")]
    public int CompanyId { get; set; }

    /// <summary>
    /// Foreign key to project manager
    /// </summary>
    [Comment("FK to Users - project manager")]
    public int? ProjectManagerId { get; set; }

    /// <summary>
    /// Navigation to company
    /// </summary>
    public Company Company { get; set; } = null!;

    /// <summary>
    /// Navigation to project manager
    /// </summary>
    public User? ProjectManager { get; set; }

    /// <summary>
    /// Team members assigned to project
    /// </summary>
    public ICollection<UserProject> UserProjects { get; set; } = new List<UserProject>();

    /// <summary>
    /// All tasks in this project
    /// </summary>
    public ICollection<Task> Tasks { get; set; } = new List<Task>();

    /// <summary>
    /// Documents related to project
    /// </summary>
    public ICollection<Document> Documents { get; set; } = new List<Document>();
}

/// <summary>
/// Work item or task within a project
/// </summary>
[Comment("Task entity - individual work items with assignments and tracking")]
public class Task
{
    [Comment("Primary key")]
    public int Id { get; set; }

    /// <summary>
    /// Task title or summary
    /// </summary>
    [Comment("Task title")]
    public string Title { get; set; } = string.Empty;

    [Comment("Detailed task description")]
    public string Description { get; set; } = string.Empty;

    /// <summary>
    /// Current task status
    /// </summary>
    [Comment("Status - New, In Progress, Review, Done, Cancelled")]
    public string Status { get; set; } = string.Empty;

    [Comment("Priority - Critical, High, Medium, Low")]
    public string Priority { get; set; } = string.Empty;

    /// <summary>
    /// Task type classification
    /// </summary>
    [Comment("Type - Bug, Feature, Enhancement, Research")]
    public string Type { get; set; } = string.Empty;

    [Comment("Category for grouping tasks")]
    public string Category { get; set; } = string.Empty;

    /// <summary>
    /// Estimated hours to complete
    /// </summary>
    [Comment("Time estimate in hours")]
    public int EstimatedHours { get; set; }

    [Comment("Actual time spent in hours")]
    public int ActualHours { get; set; }

    /// <summary>
    /// Story points for agile estimation
    /// </summary>
    [Comment("Agile story points")]
    public int StoryPoints { get; set; }

    [Comment("Completion percentage - 0 to 100")]
    public decimal PercentComplete { get; set; }

    /// <summary>
    /// Work start date
    /// </summary>
    [Comment("Task start date")]
    public DateTime? StartDate { get; set; }

    [Comment("Target due date")]
    public DateTime? DueDate { get; set; }

    /// <summary>
    /// Actual completion date
    /// </summary>
    [Comment("Date task was completed")]
    public DateTime? CompletedDate { get; set; }

    [Comment("Resolution notes")]
    public string Resolution { get; set; } = string.Empty;

    /// <summary>
    /// Definition of done criteria
    /// </summary>
    [Comment("Acceptance criteria for completion")]
    public string AcceptanceCriteria { get; set; } = string.Empty;

    [Comment("Testing notes and results")]
    public string TestNotes { get; set; } = string.Empty;

    /// <summary>
    /// Git branch name for this task
    /// </summary>
    [Comment("Feature branch name")]
    public string Branch { get; set; } = string.Empty;

    [Comment("Pull request URL")]
    public string PullRequestUrl { get; set; } = string.Empty;

    /// <summary>
    /// Whether task is blocked
    /// </summary>
    [Comment("Blocked status flag")]
    public bool IsBlocked { get; set; }

    [Comment("Reason task is blocked")]
    public string BlockedReason { get; set; } = string.Empty;

    /// <summary>
    /// Whether time is billable to client
    /// </summary>
    [Comment("Billable flag for time tracking")]
    public bool IsBillable { get; set; }

    [Comment("Task creation timestamp")]
    public DateTime CreatedAt { get; set; }

    /// <summary>
    /// Last update timestamp
    /// </summary>
    public DateTime UpdatedAt { get; set; }

    /// <summary>
    /// Foreign key to project
    /// </summary>
    [Comment("FK to Projects")]
    public int ProjectId { get; set; }

    /// <summary>
    /// Foreign key to assigned user
    /// </summary>
    [Comment("FK to Users - assignee")]
    public int? AssignedToId { get; set; }

    /// <summary>
    /// Foreign key to creator
    /// </summary>
    [Comment("FK to Users - creator")]
    public int CreatedById { get; set; }

    /// <summary>
    /// Navigation to project
    /// </summary>
    public Project Project { get; set; } = null!;

    /// <summary>
    /// Navigation to assigned user
    /// </summary>
    public User? AssignedTo { get; set; }

    /// <summary>
    /// Navigation to creator
    /// </summary>
    public User CreatedBy { get; set; } = null!;

    /// <summary>
    /// Comments on this task
    /// </summary>
    public ICollection<Comment> Comments { get; set; } = new List<Comment>();

    /// <summary>
    /// Tags applied to task
    /// </summary>
    public ICollection<TaskTag> TaskTags { get; set; } = new List<TaskTag>();
}

/// <summary>
/// Document or file attached to project
/// </summary>
[Comment("Document entity - file storage with versioning and access control")]
public class Document
{
    [Comment("Primary key")]
    public int Id { get; set; }

    /// <summary>
    /// Display name for document
    /// </summary>
    [Comment("Document display name")]
    public string Name { get; set; } = string.Empty;

    [Comment("Original uploaded filename")]
    public string OriginalName { get; set; } = string.Empty;

    /// <summary>
    /// Document description
    /// </summary>
    [Comment("Document description or summary")]
    public string Description { get; set; } = string.Empty;

    [Comment("Category - Specification, Design, Report, etc.")]
    public string Category { get; set; } = string.Empty;

    /// <summary>
    /// Document type
    /// </summary>
    [Comment("Document type classification")]
    public string Type { get; set; } = string.Empty;

    [Comment("Storage path or S3 key")]
    public string FilePath { get; set; } = string.Empty;

    /// <summary>
    /// MIME content type
    /// </summary>
    [Comment("MIME type - application/pdf, image/png, etc.")]
    public string MimeType { get; set; } = string.Empty;

    [Comment("File size in bytes")]
    public long FileSize { get; set; }

    /// <summary>
    /// File hash for integrity
    /// </summary>
    [Comment("SHA256 hash for integrity verification")]
    public string Hash { get; set; } = string.Empty;

    [Comment("Version number")]
    public string Version { get; set; } = string.Empty;

    /// <summary>
    /// Whether this is latest version
    /// </summary>
    [Comment("Latest version flag")]
    public bool IsLatestVersion { get; set; }

    [Comment("Document status - Draft, Review, Approved, Archived")]
    public string Status { get; set; } = string.Empty;

    /// <summary>
    /// Access control level
    /// </summary>
    [Comment("Access level - Public, Internal, Confidential, Restricted")]
    public string AccessLevel { get; set; } = string.Empty;

    [Comment("Document expiration date")]
    public DateTime? ExpiryDate { get; set; }

    /// <summary>
    /// Download counter
    /// </summary>
    [Comment("Total download count")]
    public int Downloads { get; set; }

    [Comment("Encryption status flag")]
    public bool IsEncrypted { get; set; }

    /// <summary>
    /// Searchable keywords
    /// </summary>
    [Comment("Comma-separated keywords")]
    public string Keywords { get; set; } = string.Empty;

    [Comment("Upload timestamp")]
    public DateTime CreatedAt { get; set; }

    /// <summary>
    /// Last modification time
    /// </summary>
    public DateTime UpdatedAt { get; set; }

    /// <summary>
    /// Foreign key to project
    /// </summary>
    [Comment("FK to Projects")]
    public int ProjectId { get; set; }

    /// <summary>
    /// Foreign key to uploader
    /// </summary>
    [Comment("FK to Users - uploader")]
    public int UploadedById { get; set; }

    /// <summary>
    /// Navigation to project
    /// </summary>
    public Project Project { get; set; } = null!;

    /// <summary>
    /// Navigation to uploader
    /// </summary>
    public User UploadedBy { get; set; } = null!;
}

/// <summary>
/// Comment or note on a task
/// </summary>
[Comment("Comment entity - discussion threads on tasks")]
public class Comment
{
    [Comment("Primary key")]
    public int Id { get; set; }

    /// <summary>
    /// Comment text content
    /// </summary>
    [Comment("Comment plain text content")]
    public string Content { get; set; } = string.Empty;

    [Comment("HTML formatted content")]
    public string FormattedContent { get; set; } = string.Empty;

    /// <summary>
    /// Comment type
    /// </summary>
    [Comment("Type - Comment, Note, System")]
    public string Type { get; set; } = string.Empty;

    [Comment("Internal visibility flag")]
    public bool IsInternal { get; set; }

    /// <summary>
    /// Whether comment was edited
    /// </summary>
    [Comment("Edited status flag")]
    public bool IsEdited { get; set; }

    [Comment("Last edit timestamp")]
    public DateTime? EditedAt { get; set; }

    /// <summary>
    /// IP address of commenter
    /// </summary>
    [Comment("Client IP address")]
    public string IpAddress { get; set; } = string.Empty;

    [Comment("Client user agent string")]
    public string UserAgent { get; set; } = string.Empty;

    /// <summary>
    /// Comment creation time
    /// </summary>
    public DateTime CreatedAt { get; set; }

    [Comment("Last update timestamp")]
    public DateTime UpdatedAt { get; set; }

    /// <summary>
    /// Foreign key to task
    /// </summary>
    [Comment("FK to Tasks")]
    public int TaskId { get; set; }

    /// <summary>
    /// Foreign key to author
    /// </summary>
    [Comment("FK to Users - author")]
    public int AuthorId { get; set; }

    /// <summary>
    /// Navigation to task
    /// </summary>
    public Task Task { get; set; } = null!;

    /// <summary>
    /// Navigation to author
    /// </summary>
    public User Author { get; set; } = null!;

    /// <summary>
    /// Files attached to comment
    /// </summary>
    public ICollection<Attachment> Attachments { get; set; } = new List<Attachment>();
}

/// <summary>
/// File attached to a comment
/// </summary>
[Comment("Attachment entity - files attached to comments")]
public class Attachment
{
    [Comment("Primary key")]
    public int Id { get; set; }

    /// <summary>
    /// Attachment display name
    /// </summary>
    [Comment("Display name")]
    public string Name { get; set; } = string.Empty;

    [Comment("Original filename")]
    public string OriginalName { get; set; } = string.Empty;

    /// <summary>
    /// Storage path
    /// </summary>
    [Comment("File storage path")]
    public string FilePath { get; set; } = string.Empty;

    [Comment("MIME content type")]
    public string MimeType { get; set; } = string.Empty;

    /// <summary>
    /// File size in bytes
    /// </summary>
    [Comment("File size in bytes")]
    public long FileSize { get; set; }

    [Comment("SHA256 hash")]
    public string Hash { get; set; } = string.Empty;

    /// <summary>
    /// Thumbnail image path
    /// </summary>
    [Comment("Thumbnail path for images")]
    public string ThumbnailPath { get; set; } = string.Empty;

    [Comment("Image file flag")]
    public bool IsImage { get; set; }

    /// <summary>
    /// Image width in pixels
    /// </summary>
    [Comment("Image width")]
    public int? ImageWidth { get; set; }

    [Comment("Image height")]
    public int? ImageHeight { get; set; }

    /// <summary>
    /// Upload timestamp
    /// </summary>
    public DateTime CreatedAt { get; set; }

    /// <summary>
    /// Foreign key to comment
    /// </summary>
    [Comment("FK to Comments")]
    public int CommentId { get; set; }

    /// <summary>
    /// Foreign key to uploader
    /// </summary>
    [Comment("FK to Users - uploader")]
    public int UploadedById { get; set; }

    /// <summary>
    /// Navigation to comment
    /// </summary>
    public Comment Comment { get; set; } = null!;

    /// <summary>
    /// Navigation to uploader
    /// </summary>
    public User UploadedBy { get; set; } = null!;
}

/// <summary>
/// Tag for categorizing tasks
/// </summary>
[Comment("Tag entity - labels for categorizing and filtering tasks")]
public class Tag
{
    [Comment("Primary key")]
    public int Id { get; set; }

    /// <summary>
    /// Tag name
    /// </summary>
    [Comment("Tag display name")]
    public string Name { get; set; } = string.Empty;

    [Comment("Tag description")]
    public string Description { get; set; } = string.Empty;

    /// <summary>
    /// Tag color code
    /// </summary>
    [Comment("Hex color code")]
    public string Color { get; set; } = string.Empty;

    [Comment("Icon name or class")]
    public string Icon { get; set; } = string.Empty;

    /// <summary>
    /// Tag category
    /// </summary>
    [Comment("Category for grouping tags")]
    public string Category { get; set; } = string.Empty;

    [Comment("Active status flag")]
    public bool IsActive { get; set; }

    /// <summary>
    /// Number of times tag is used
    /// </summary>
    [Comment("Usage counter")]
    public int UsageCount { get; set; }

    [Comment("Tag creation timestamp")]
    public DateTime CreatedAt { get; set; }

    /// <summary>
    /// Tasks with this tag
    /// </summary>
    public ICollection<TaskTag> TaskTags { get; set; } = new List<TaskTag>();
}

/// <summary>
/// Many-to-many relationship between tasks and tags
/// </summary>
[Comment("TaskTag junction - many-to-many relationship between tasks and tags")]
public class TaskTag
{
    /// <summary>
    /// Foreign key to task (composite key)
    /// </summary>
    [Comment("FK to Tasks - part of composite key")]
    public int TaskId { get; set; }

    /// <summary>
    /// Foreign key to tag (composite key)
    /// </summary>
    [Comment("FK to Tags - part of composite key")]
    public int TagId { get; set; }

    [Comment("Timestamp when tag was applied")]
    public DateTime TaggedAt { get; set; }

    /// <summary>
    /// Username who applied tag
    /// </summary>
    [Comment("User who applied the tag")]
    public string TaggedBy { get; set; } = string.Empty;

    /// <summary>
    /// Navigation to task
    /// </summary>
    public Task Task { get; set; } = null!;

    /// <summary>
    /// Navigation to tag
    /// </summary>
    public Tag Tag { get; set; } = null!;
}

/// <summary>
/// Many-to-many relationship between users and projects
/// </summary>
[Comment("UserProject junction - team membership with roles and rates")]
public class UserProject
{
    /// <summary>
    /// Foreign key to user (composite key)
    /// </summary>
    [Comment("FK to Users - part of composite key")]
    public int UserId { get; set; }

    /// <summary>
    /// Foreign key to project (composite key)
    /// </summary>
    [Comment("FK to Projects - part of composite key")]
    public int ProjectId { get; set; }

    [Comment("User role on project - Developer, Designer, QA, etc.")]
    public string Role { get; set; } = string.Empty;

    /// <summary>
    /// Permission set for user
    /// </summary>
    [Comment("Comma-separated permissions")]
    public string Permissions { get; set; } = string.Empty;

    [Comment("Date user joined project")]
    public DateTime JoinedAt { get; set; }

    /// <summary>
    /// Date user left project
    /// </summary>
    [Comment("Date user left project - null if active")]
    public DateTime? LeftAt { get; set; }

    [Comment("Active membership flag")]
    public bool IsActive { get; set; }

    /// <summary>
    /// Billing rate per hour
    /// </summary>
    [Comment("Hourly rate for billing")]
    public decimal HourlyRate { get; set; }

    [Comment("Rate currency code")]
    public string Currency { get; set; } = string.Empty;

    /// <summary>
    /// Navigation to user
    /// </summary>
    public User User { get; set; } = null!;

    /// <summary>
    /// Navigation to project
    /// </summary>
    public Project Project { get; set; } = null!;
}

/// <summary>
/// Audit log for tracking system changes
/// </summary>
[Comment("AuditLog entity - comprehensive audit trail for compliance")]
public class AuditLog
{
    [Comment("Primary key")]
    public int Id { get; set; }

    /// <summary>
    /// Action performed
    /// </summary>
    [Comment("Action - Create, Update, Delete, View")]
    public string Action { get; set; } = string.Empty;

    [Comment("Entity type name")]
    public string EntityType { get; set; } = string.Empty;

    /// <summary>
    /// ID of affected entity
    /// </summary>
    [Comment("Entity ID that was modified")]
    public int? EntityId { get; set; }

    [Comment("JSON of old values before change")]
    public string OldValues { get; set; } = string.Empty;

    /// <summary>
    /// New values after change
    /// </summary>
    [Comment("JSON of new values after change")]
    public string NewValues { get; set; } = string.Empty;

    [Comment("Client IP address")]
    public string IpAddress { get; set; } = string.Empty;

    /// <summary>
    /// Browser user agent
    /// </summary>
    [Comment("Client user agent string")]
    public string UserAgent { get; set; } = string.Empty;

    [Comment("Session identifier")]
    public string SessionId { get; set; } = string.Empty;

    /// <summary>
    /// When action occurred
    /// </summary>
    [Comment("Action timestamp")]
    public DateTime Timestamp { get; set; }

    [Comment("Additional audit details")]
    public string Details { get; set; } = string.Empty;

    /// <summary>
    /// Foreign key to user who performed action
    /// </summary>
    [Comment("FK to Users - who performed the action")]
    public int? UserId { get; set; }

    /// <summary>
    /// Navigation to user
    /// </summary>
    public User? User { get; set; }
}