DD.WellWorkover.Cloud/AsbCloudDb/Model/FileMark.cs

using Microsoft.EntityFrameworkCore;
using System;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using System.Text.Json.Serialization;

namespace AsbCloudDb.Model
{
    [Table("t_file_mark"), Comment("Действия с файлами.")]
    public class FileMark
    {
        [Key]
        [Column("id")]
        public int Id { get; set; }

        [Column("id_file"), Comment("id файла")]
        public int IdFile { get; set; }

        [Column("id_mark_type"), Comment("0 - отклонен, 1 - согласован")]
        public int IdMarkType { get; set; }

        [Column("date_created", TypeName = "timestamp with time zone"), Comment("Дата совершенного действия")]
        public DateTimeOffset DateCreated { get; set; }

        [Column("id_user"), Comment("id пользователя")]
        public int IdUser { get; set; }

        [Column("comment"), Comment("Комментарий")]
        [StringLength(255)]
        public string? Comment { get; set; }

        [Column("is_deleted"), Comment("Помечен ли файл как удаленный")]
        public bool IsDeleted { get; set; }

        [JsonIgnore]
        [ForeignKey(nameof(IdUser))]
        public virtual User User { get; set; } = null!;

        [JsonIgnore]
        [ForeignKey(nameof(IdFile))]
        public virtual FileInfo FileInfo { get; set; } = null!;
    }
}