Core_Be/Models/ClientInvoice.cs

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

namespace Fitness_core_BE.Models
{
    public class ClientInvoice
    {
        [Key]
        public Guid ClientInvoiceId { get; set; }
        public Guid FKClientSubscriptionId { get; set; }
        [ForeignKey("FKClientSubscriptionId")]
        public virtual ClientSubscription ClientSubscription { get; set; }

        public Guid FKUserId { get; set; }
        [ForeignKey("FKUserId")]
        public virtual User User { get; set; }

        public int FKClientCardId { get; set; }
        [ForeignKey("FKClientCardId")]
        public virtual ClientCard ClientCard { get; set; }

        public decimal Amount { get; set; }
        // "Pending" | "Partial" | "Paid"
        public string Status { get; set; } = "Pending";
        public decimal PaidAmount { get; set; } = 0;

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

        public virtual ICollection<ClientInvoiceItem> Items { get; set; } = new List<ClientInvoiceItem>();
    }
}