squad-rain-ops-mini/Helpers/SquadGameLog/LogEntities.cs

using System;
using SqlSugar;

namespace RainOpsMini.Helpers.SquadGameLog
{
    [SugarTable("Log_Disconnect")]
    public class Log_Disconnect
    {
        [SugarColumn(IsPrimaryKey = true)]
        public string Id { get; set; }
        public DateTime? LogTime { get; set; }
        [SugarColumn(IsNullable = true)]
        public string RawContent { get; set; }

        [SugarColumn(IsNullable = true)]
        public string OutTime { get; set; }
        [SugarColumn(IsNullable = true)]
        public string JoinTime { get; set; }
        [SugarColumn(IsNullable = true)]
        public string ThreadID { get; set; }
        [SugarColumn(IsNullable = true)]
        public string ChIndex { get; set; }
        [SugarColumn(IsNullable = true)]
        public string ChIndexName { get; set; }
        [SugarColumn(IsNullable = true)]
        public string Closing { get; set; }
        [SugarColumn(IsNullable = true)]
        public string RemoteAddrIP { get; set; }
        [SugarColumn(IsNullable = true)]
        public string RemoteAddrPort { get; set; }
        [SugarColumn(IsNullable = true)]
        public string EOSIpNetConnectionID { get; set; }
        [SugarColumn(IsNullable = true)]
        public string DriverID { get; set; }
        [SugarColumn(IsNullable = true)]
        public string PC { get; set; }
        [SugarColumn(IsNullable = true)]
        public string Owner { get; set; }
        [SugarColumn(IsNullable = true)]
        public string EOSID { get; set; }
        [SugarColumn(IsNullable = true)]
        public string SteamID { get; set; }
        [SugarColumn(IsNullable = true)]
        public string SteamName { get; set; }
    }

    [SugarTable("Log_MatchLost")]
    public class Log_MatchLost
    {
        [SugarColumn(IsPrimaryKey = true)]
        public string Id { get; set; }
        public DateTime? LogTime { get; set; }
        [SugarColumn(IsNullable = true)]
        public string RawContent { get; set; }

        [SugarColumn(IsNullable = true)]
        public string ThreadID { get; set; }
        [SugarColumn(IsNullable = true)]
        public string TeamNumber { get; set; }
        [SugarColumn(IsNullable = true)]
        public string TeamInfo { get; set; }
        [SugarColumn(IsNullable = true)]
        public string Type { get; set; }
        [SugarColumn(IsNullable = true)]
        public string Tickets { get; set; }
        [SugarColumn(IsNullable = true)]
        public string MapLayer { get; set; }
        [SugarColumn(IsNullable = true)]
        public string MapLevel { get; set; }
    }

    [SugarTable("Log_BattleEnd")]
    public class Log_BattleEnd
    {
        [SugarColumn(IsPrimaryKey = true)]
        public string Id { get; set; }
        public DateTime? LogTime { get; set; }
        [SugarColumn(IsNullable = true)]
        public string RawContent { get; set; }

        [SugarColumn(IsNullable = true)]
        public string ThreadID { get; set; }
        [SugarColumn(IsNullable = true)]
        public string TeamNumber { get; set; }
        [SugarColumn(IsNullable = true)]
        public string TeamInfo { get; set; }
        [SugarColumn(IsNullable = true)]
        public string Type { get; set; }
        [SugarColumn(IsNullable = true)]
        public string Tickets { get; set; }
        [SugarColumn(IsNullable = true)]
        public string MapLayer { get; set; }
        [SugarColumn(IsNullable = true)]
        public string MapLevel { get; set; }
    }

    [SugarTable("Log_CreateSquad")]
    public class Log_CreateSquad
    {
        [SugarColumn(IsPrimaryKey = true)]
        public string Id { get; set; }
        public DateTime? LogTime { get; set; }
        [SugarColumn(IsNullable = true)]
        public string RawContent { get; set; }

        public int ThreadID { get; set; }
        [SugarColumn(IsNullable = true)]
        public string UserName { get; set; }
        [SugarColumn(IsNullable = true)]
        public string EOSID { get; set; }
        [SugarColumn(IsNullable = true)]
        public string SteamID { get; set; }
        [SugarColumn(IsNullable = true)]
        public string SquadNum { get; set; }
        [SugarColumn(IsNullable = true)]
        public string SquadName { get; set; }
        [SugarColumn(IsNullable = true)]
        public string TeamName { get; set; }
        [SugarColumn(IsNullable = true)]
        public string Note { get; set; }
    }

    [SugarTable("Log_NewPlayerConnect")]
    public class Log_NewPlayerConnect
    {
        [SugarColumn(IsPrimaryKey = true)]
        public string Id { get; set; }
        public DateTime? LogTime { get; set; }
        [SugarColumn(IsNullable = true)]
        public string RawContent { get; set; }

        public int ThreadID { get; set; }
        [SugarColumn(IsNullable = true)]
        public string PlayerController { get; set; }
        [SugarColumn(IsNullable = true)]
        public string IPAddress { get; set; }
        [SugarColumn(IsNullable = true)]
        public string EOSID { get; set; }
        [SugarColumn(IsNullable = true)]
        public string SteamID { get; set; }
    }

    [SugarTable("Log_Wound")]
    public class Log_Wound
    {
        [SugarColumn(IsPrimaryKey = true)]
        public string Id { get; set; }
        public DateTime? LogTime { get; set; }
        [SugarColumn(IsNullable = true)]
        public string RawContent { get; set; }

        public int ThreadID { get; set; }
        [SugarColumn(IsNullable = true)]
        public string PlayerName { get; set; }
        public double KillingDamage { get; set; }
        [SugarColumn(IsNullable = true)]
        public string CausePlayerControllerID { get; set; }
        [SugarColumn(IsNullable = true)]
        public string EOSID { get; set; }
        [SugarColumn(IsNullable = true)]
        public string SteamID { get; set; }
        [SugarColumn(IsNullable = true)]
        public string ControllerID { get; set; }
        [SugarColumn(IsNullable = true)]
        public string CauseObjectID { get; set; }
        [SugarColumn(IsNullable = true)]
        public string MapName { get; set; }
        [SugarColumn(IsNullable = true)]
        public string MatchTime { get; set; }
        [SugarColumn(IsNullable = true)]
        public bool? IsTK { get; set; }
        [SugarColumn(IsNullable = true)]
        public string AttackerName { get; set; }
        [SugarColumn(IsNullable = true)]
        public string AttackerSteamID { get; set; }
        [SugarColumn(IsNullable = true)]
        public string VictimName { get; set; }
        [SugarColumn(IsNullable = true)]
        public string VictimSteamID { get; set; }
    }

    [SugarTable("Log_Die")]
    public class Log_Die
    {
        [SugarColumn(IsPrimaryKey = true)]
        public string Id { get; set; }
        public DateTime? LogTime { get; set; }
        [SugarColumn(IsNullable = true)]
        public string RawContent { get; set; }

        public int ThreadID { get; set; }
        [SugarColumn(IsNullable = true)]
        public string PlayerName { get; set; }
        [SugarColumn(IsNullable = true)]
        public string DamageValue { get; set; }
        [SugarColumn(IsNullable = true)]
        public string ControllerID { get; set; }
        [SugarColumn(IsNullable = true)]
        public string EOSID { get; set; }
        [SugarColumn(IsNullable = true)]
        public string SteamID { get; set; }
        [SugarColumn(IsNullable = true)]
        public string WeaponType { get; set; }
        [SugarColumn(IsNullable = true)]
        public string MapName { get; set; }
        [SugarColumn(IsNullable = true)]
        public string MatchTime { get; set; }
        [SugarColumn(IsNullable = true)]
        public bool? IsTK { get; set; }
        [SugarColumn(IsNullable = true)]
        public string AttackerName { get; set; }
        [SugarColumn(IsNullable = true)]
        public string AttackerSteamID { get; set; }
        [SugarColumn(IsNullable = true)]
        public string VictimName { get; set; }
        [SugarColumn(IsNullable = true)]
        public string VictimSteamID { get; set; }
    }

    [SugarTable("Log_Revived")]
    public class Log_Revived
    {
        [SugarColumn(IsPrimaryKey = true)]
        public string Id { get; set; }
        public DateTime? LogTime { get; set; }
        [SugarColumn(IsNullable = true)]
        public string RawContent { get; set; }

        [SugarColumn(IsNullable = true)]
        public string ThreadID { get; set; }
        [SugarColumn(IsNullable = true)]
        public string ReviverName { get; set; }
        [SugarColumn(IsNullable = true)]
        public string ReviverEOSID { get; set; }
        [SugarColumn(IsNullable = true)]
        public string ReviverSteamID { get; set; }
        [SugarColumn(IsNullable = true)]
        public string RevivedName { get; set; }
        [SugarColumn(IsNullable = true)]
        public string RevivedEOSID { get; set; }
        [SugarColumn(IsNullable = true)]
        public string RevivedSteamID { get; set; }
        [SugarColumn(IsNullable = true)]
        public string MapName { get; set; }
        [SugarColumn(IsNullable = true)]
        public string MatchTime { get; set; }
        [SugarColumn(IsNullable = true)]
        public bool? IsTK { get; set; }
    }

    [SugarTable("Log_Attack")]
    public class Log_Attack
    {
        [SugarColumn(IsPrimaryKey = true)]
        public string Id { get; set; }
        public DateTime? LogTime { get; set; }
        [SugarColumn(IsNullable = true)]
        public string RawContent { get; set; }

        public int ThreadID { get; set; }
        [SugarColumn(IsNullable = true)]
        public string PlayerName { get; set; }
        public double ActualDamage { get; set; }
        [SugarColumn(IsNullable = true)]
        public string AttackerName { get; set; }
        [SugarColumn(IsNullable = true)]
        public string AttackerEOSID { get; set; }
        [SugarColumn(IsNullable = true)]
        public string AttackerSteamID { get; set; }
        [SugarColumn(IsNullable = true)]
        public string AttackerControllerID { get; set; }
        [SugarColumn(IsNullable = true)]
        public string Weapon { get; set; }
    }

    [SugarTable("Log_Tick")]
    public class Log_Tick
    {
        [SugarColumn(IsPrimaryKey = true)]
        public string Id { get; set; }
        public DateTime? LogTime { get; set; }
        [SugarColumn(IsNullable = true)]
        public string RawContent { get; set; }

        [SugarColumn(IsNullable = true)]
        public string ThreadID { get; set; }
        [SugarColumn(IsNullable = true)]
        public string TickRate { get; set; }
        [SugarColumn(IsNullable = true)]
        public int? PlayerCount { get; set; }
        [SugarColumn(IsNullable = true)]
        public int? MatchTime { get; set; } // Duration in seconds
        [SugarColumn(IsNullable = true)]
        public string MapName { get; set; }
    }

    [SugarTable("Log_SetNextLayer")]
    public class Log_SetNextLayer
    {
        [SugarColumn(IsPrimaryKey = true)]
        public string Id { get; set; }
        public DateTime? LogTime { get; set; }
        [SugarColumn(IsNullable = true)]
        public string RawContent { get; set; }

        [SugarColumn(IsNullable = true)]
        public string ThreadID { get; set; }
        [SugarColumn(IsNullable = true)]
        public string Command { get; set; }
        [SugarColumn(IsNullable = true)]
        public string TargetServerInfo { get; set; }
    }

    [SugarTable("Log_ChangeLayer")]
    public class Log_ChangeLayer
    {
        [SugarColumn(IsPrimaryKey = true)]
        public string Id { get; set; }
        public DateTime? LogTime { get; set; }
        [SugarColumn(IsNullable = true)]
        public string RawContent { get; set; }

        [SugarColumn(IsNullable = true)]
        public string ThreadID { get; set; }
        [SugarColumn(IsNullable = true)]
        public string Command { get; set; }
        [SugarColumn(IsNullable = true)]
        public string TargetServerInfo { get; set; }
    }

    [SugarTable("MatchPlayerStats")]
    public class MatchPlayerStats
    {
        [SugarColumn(IsPrimaryKey = true, IsIdentity = true)]
        public int Id { get; set; }
        [SugarColumn(IsNullable = true)]
        public string MatchId { get; set; } // MapName_Timestamp
        public DateTime MatchDate { get; set; }
        [SugarColumn(IsNullable = true)]
        public string MapName { get; set; }
        [SugarColumn(IsNullable = true)]
        public string PlayerName { get; set; }
        [SugarColumn(IsNullable = true)]
        public string SteamId { get; set; }
        [SugarColumn(IsNullable = true)]
        public string EosId { get; set; }
        public int TeamId { get; set; }
        [SugarColumn(IsNullable = true)]
        public string Role { get; set; }

        public int Kills { get; set; }
        public int Deaths { get; set; }
        public int Wounds { get; set; }
        public int Revives { get; set; }
        public int TeamKills { get; set; }
        [SugarColumn(IsNullable = true)]
        public string Command { get; set; }



        [SugarColumn(IsNullable = true)]
        public string TargetServerInfo { get; set; }
    }
}
[SugarTable("Log_ChangeLayer")]
public class Log_ChangeLayer
{
    [SugarColumn(IsPrimaryKey = true)]
    public string Id { get; set; }
    public DateTime? LogTime { get; set; }
    [SugarColumn(IsNullable = true)]
    public string RawContent { get; set; }

    [SugarColumn(IsNullable = true)]
    public string ThreadID { get; set; }
    [SugarColumn(IsNullable = true)]
    public string Command { get; set; }
    [SugarColumn(IsNullable = true)]
    public string TargetServerInfo { get; set; }
}

[SugarTable("Log_RemovedPlayer")]
public class Log_RemovedPlayer
{
    [SugarColumn(IsPrimaryKey = true)]
    public string Id { get; set; }
    public DateTime? LogTime { get; set; }
    [SugarColumn(IsNullable = true)]
    public string RawContent { get; set; }

    [SugarColumn(IsNullable = true)]
    public string ThreadID { get; set; }
    [SugarColumn(IsNullable = true)]
    public string AntiCheatID { get; set; }
    [SugarColumn(IsNullable = true)]
    public string SessionID { get; set; }
    [SugarColumn(IsNullable = true)]
    public string EOSID { get; set; }
}

[SugarTable("PlayerProfile")]
public class PlayerProfile
{
    [SugarColumn(IsPrimaryKey = true)]
    public string SteamID { get; set; }
    [SugarColumn(IsNullable = true)]
    public string EOSID { get; set; }
    [SugarColumn(IsNullable = true)]
    public string LastName { get; set; }
    public DateTime FirstSeen { get; set; }
    public DateTime LastSeen { get; set; }
    public double TotalPlaytimeSeconds { get; set; }
    public int SquadPlaytimeHours { get; set; }
    public double PlayStickiness { get; set; }
}

[SugarTable("PlayerSession")]
public class PlayerSession
{
    [SugarColumn(IsPrimaryKey = true, IsIdentity = true)]
    public int Id { get; set; }
    [SugarColumn(IsNullable = true)]
    public string SteamID { get; set; }
    public DateTime StartTime { get; set; }
    public DateTime? EndTime { get; set; }
    public double DurationSeconds { get; set; }
}