namespace AnalyticsDAL.DTO.DataSource
{
    public class DataSourceDTO
    {
        public int DataSourceId { get; set; }
        public string DataSourceCode { get; set; } = string.Empty;
        public string DataSourceName { get; set; } = string.Empty;
        public byte DataSourceType { get; set; }
        public byte ConnectionType { get; set; }
        public string? HostName { get; set; }
        public int Port { get; set; }
        public string? DatabaseName { get; set; }
        public string? SchemaName { get; set; }
        public string? CredentialRef { get; set; }
        public byte RefreshType { get; set; }
        public byte AccessMode { get; set; }
        public byte IsValidated { get; set; }
        public DateTime? LastValidatedOn { get; set; }
        public int WorkspaceId { get; set; }
        public string? Remarks { get; set; }
        /// <summary>FK-by-convention to SqlWorkbench MSWCLIENTDATABASE.CLIENTDBID — when set,
        /// this DataSource executes against a SqlWorkbench-managed client database rather than
        /// the standalone HostName/Port/DatabaseName connection fields above. V1 scope requires
        /// the resolved client DB's DbServer to be SQL-Server-typed (see DataSourceBLL.SaveDataSource).</summary>
        public int? SwClientDatabaseId { get; set; }
        public short Version { get; set; }
        public byte Status { get; set; }
        public short SortOrder { get; set; }
        public byte SourceType { get; set; }
        public int TenantId { get; set; }
        public int CreatedById { get; set; }
        public DateTime CreatedOn { get; set; }
        public string? CreatedByName { get; set; }
        public int ModifiedById { get; set; }
        public DateTime ModifiedOn { get; set; }
        public string? ModifiedByName { get; set; }
    }
}