squad-rain-ops-mini/Models/CdkInfo.cs

using System;
using SqlSugar;

namespace RainOpsMini.Models
{
    [SugarTable("Cdks")]
    public class CdkInfo
    {
        [SugarColumn(IsPrimaryKey = true)]
        public string Code { get; set; } = null!;

        public string Type { get; set; } = "VIP"; // "VIP", "SVIP"

        public int DurationDays { get; set; } = 30;

        public string Status { get; set; } = "Unused"; // "Unused", "Used"

        public string Creator { get; set; } = "System";

        public string Reason { get; set; } = "";

        public string BatchId { get; set; } = ""; // To limit 1 redemption per batch per user

        public DateTime CreatedAt { get; set; } = DateTime.UtcNow;

        public string? RedeemedBy { get; set; }

        public DateTime? RedeemedAt { get; set; }
    }
}