forked from ddrilling/AsbCloudServer
41 lines
1.6 KiB
C#
41 lines
1.6 KiB
C#
using Microsoft.EntityFrameworkCore;
|
|
using System;
|
|
using System.ComponentModel.DataAnnotations;
|
|
using System.ComponentModel.DataAnnotations.Schema;
|
|
|
|
namespace AsbCloudDb.Model
|
|
{
|
|
[Table("t_data_saub_stat_drilling_quality"), Comment("Кеш-таблица для хранения данных для построения страницы \"Качество\"")]
|
|
public class DataSaubStatDrillingQuality : IId, IDataSaubStat
|
|
{
|
|
[Key]
|
|
[Column("id")]
|
|
public int Id { get; set; }
|
|
|
|
[Column("id_telemetry"), Comment("Ключ телеметрии")]
|
|
public int IdTelemetry { get; set; }
|
|
|
|
[Column("date_start", TypeName = "timestamp with time zone"), Comment("Дата и время начала")]
|
|
public DateTimeOffset DateStart { get; set; }
|
|
|
|
[Column("date_end", TypeName = "timestamp with time zone"), Comment("Дата и время окончания")]
|
|
public DateTimeOffset DateEnd { get; set; }
|
|
|
|
[Column("depth_start"), Comment("Глубина забоя по стволу начальная")]
|
|
public double DepthStart { get; set; }
|
|
|
|
[Column("depth_end"), Comment("Глубина забоя по стволу конечная")]
|
|
public double DepthEnd { get; set; }
|
|
|
|
[Column("id_feed_regulator"), Comment("Флаг")]
|
|
public int IdFeedRegulator { get; set; }
|
|
|
|
[Column("depth_drilling_quality"), Comment("Качественная проходка")]
|
|
public double DepthDrillingQuality { get; set; }
|
|
|
|
[ForeignKey(nameof(IdTelemetry))]
|
|
public virtual Telemetry Telemetry { get; set; } = null!;
|
|
|
|
}
|
|
}
|