using System.ComponentModel.DataAnnotations.Schema;
using System.Text.Json.Serialization;
using vendorApproverBackend.Enums;

namespace vendorApproverBackend.Entities
{
    [Table("employee_applications")]
    public class EmployeeApplication
    {
        [Column("id")]
        public long Id { get; set; }

        [Column("user_id")]
        public long UserId { get; set; }
        
        public User User { get; set; } = null!;

        [Column("type")]
        public EmployeeTypeEnum? Type { get; set; }

        [Column("Category")]
        public EmployeeCategory? Category { get; set; }

        [Column("experience")]
        public int? Experience { get; set; }

        [Column("qualifications", TypeName = "text")]
        public string? Qualifications { get; set; } = string.Empty;

        [Column("certification_ids")]
        public List<long?> CertificationIds { get; set; } = new List<long?>();

        [Column("status")]
        public ApplicationStatus? Status { get; set; } = ApplicationStatus.SUBMITTED;

         [Column("reason", TypeName = "text")]
        public string? Reason { get; set; }

        public List<ApplicationCategory> ApplicationCategories { get; set; } = new();


        [Column("submission_date")]
        public DateTime? SubmissionDate { get; set; } = DateTime.UtcNow;
    }
}