namespace SwDAL.DTO.RefDataSource;

/// <summary>Registry row for ReferenceDataScriptGenerator (tracker §36) — names a source table
/// and an optional row filter identifying its curated/standard rows for one DbModel.</summary>
public class RefDataSourceDTO
{
    public int     RefDataSourceId { get; set; }
    public int     DbModelId       { get; set; }
    public string  TableName       { get; set; } = string.Empty;
    public string? RowFilterSql    { get; set; }
    public string? Description     { get; set; }

    // Scope (043_ALTER_MSWREFDATASOURCE_ScopeType.sql) — mirrors SW.MSWUPGRADEPACKAGE's own
    // PackageScopeType shape. Records which package family a generated script belongs to; a
    // "Z_"-prefixed table is, by the platform's own established convention, always custom to one
    // client and must never be registered Universal — see RefDataSourceBLL.Save's own guard.
    public byte    ScopeType       { get; set; }   // 0=Universal 1=PartnerProduct 2=Industry 3=Country 4=Client
    public string? ScopeValue      { get; set; }

    // Standard M-table fields
    public short   Version         { get; set; }
    public byte    Status          { get; set; } = 1;
    public short   SortOrder       { get; set; } = 9999;
    public int     CreatedById     { get; set; }
    public DateTime CreatedOn      { get; set; }
    public int     ModifiedById    { get; set; }
    public DateTime ModifiedOn     { get; set; }
    public byte    SourceType      { get; set; } = 5;
    public int     TenantId        { get; set; }
}