using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;

namespace Svrnty.Sample.Data.Entities;

/// <summary>
/// Represents monthly revenue data
/// </summary>
[Table("revenue", Schema = "agent")]
public class Revenue
{
    [Key]
    [Column("id")]
    [DatabaseGenerated(DatabaseGeneratedOption.Identity)]
    public int Id { get; set; }

    [Column("month")]
    [Required]
    [MaxLength(50)]
    public string Month { get; set; } = string.Empty;

    [Column("amount", TypeName = "decimal(18,2)")]
    [Required]
    public decimal Amount { get; set; }

    [Column("year")]
    [Required]
    public int Year { get; set; }

    [Column("created_at")]
    [Required]
    public DateTime CreatedAt { get; set; } = DateTime.UtcNow;
}