// ============================================================
// GoodBooks ERP — Skill Management Module
// DTO    : SkillGroupDTO
// Table  : MSKILLGROUP (S2) — second-level grouping master
// Joins  : MSKILLDOMAIN (S1)
// Updated: Aligned to new DDL schema v1.0
// ============================================================

namespace SkillManagementDAL.DTO.SkillGroup
{
    public class SkillGroupDTO
    {
        // ── Primary key ──────────────────────────────────────────
        public int GroupId { get; set; }

        // ── Business columns  (MSKILLGROUP) ──────────────────────
        public int DomainId { get; set; }               // FK -> MSKILLDOMAIN.DOMAINID
        public string GroupCode { get; set; } = string.Empty;
        public string GroupName { get; set; } = string.Empty;
        public short DisplayOrder { get; set; }               // MSKILLGROUP.DISPLAYORDER SMALLINT
        public byte IsActive { get; set; } = 1;          // 0=No, 1=Yes

        // ── Standard fields  (MSKILLGROUP) ───────────────────────
        public short Version { get; set; }               // MSKILLGROUP.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; }               // MSKILLGROUP.CREATEDON  (was missing from old DTO)
        public int ModifiedById { get; set; }
        public DateTime? ModifiedOn { get; set; }               // MSKILLGROUP.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 — MSKILLDOMAIN (S1) ────────────
        public string? DomainName { get; set; }               // MSKILLDOMAIN.DOMAINNAME
        public string? DomainCode { get; set; }               // MSKILLDOMAIN.DOMAINCODE  (was missing from old DTO)
        public byte DomainType { get; set; }               // MSKILLDOMAIN.DOMAINTYPE  (was missing — 0=Manufacturing,1=Quality,2=Maintenance,3=General,4=Support)
    }
}