// ============================================================
// GoodBooks ERP — Skill Management Module
// DTO    : SkillDomainDTO
// Table  : MSKILLDOMAIN (S1) — top-level domain master
// Joins  : MCLIENT (tenant display name)
// Updated: Aligned to new DDL schema v1.0
// ============================================================

namespace SkillManagementDAL.DTO.SkillDomain
{
    public class SkillDomainDTO
    {
        // ── Primary key ──────────────────────────────────────────
        public int DomainId { get; set; }

        // ── Business columns  (MSKILLDOMAIN) ─────────────────────
        public string DomainCode { get; set; } = string.Empty;
        public string DomainName { get; set; } = string.Empty;
        public byte DomainType { get; set; }               // 0=Manufacturing,1=Quality,2=Maintenance,3=General,4=Support
        public short DisplayOrder { get; set; }               // MSKILLDOMAIN.DISPLAYORDER SMALLINT
        public byte IsActive { get; set; } = 1;          // 0=No, 1=Yes
        public string? Description { get; set; }

        // ── Standard fields  (MSKILLDOMAIN) ──────────────────────
        public short Version { get; set; }               // MSKILLDOMAIN.VERSION
        public byte Status { get; set; } = 1;          // 0=Pending,1=Active,2=Deleted,3=Amended,4=Inactive,5=Archived
        public short SortOrder { get; set; } = 9999;
        public int CreatedById { get; set; }
        public DateTime? CreatedOn { get; set; }               // MSKILLDOMAIN.CREATEDON  (was missing from old DTO)
        public int ModifiedById { get; set; }
        public DateTime? ModifiedOn { get; set; }               // MSKILLDOMAIN.MODIFIEDON  (was missing from old DTO)
        public byte SourceType { get; set; } = 5;          // 1=Framework,2=Devadmin,3=Impadmin,4=Admin,5=User
        public int TenantId { get; set; }

        // ── Joined display fields — MCLIENT ───────────────────────
        // TenantName resolved via MCLIENT.CLIENTID = TENANTID
        // NOTE: adjust CLIENTNAME to your actual MCLIENT display column
        public string? TenantName { get; set; }               // MCLIENT.CLIENTNAME  (was in DTO but never joined in old queries)
    }
}