forked from ddrilling/AsbCloudServer
646 lines
18 KiB
C#
646 lines
18 KiB
C#
using System.ComponentModel.DataAnnotations.Schema;
|
|
|
|
namespace AsbCloudDb.Model.WITS
|
|
{
|
|
/// <summary>
|
|
/// Record name: Bit Report
|
|
/// Description: Bit Report data
|
|
/// Description2:
|
|
/// </summary>
|
|
[Table("t_telemetry_wits_21")]
|
|
public class Record21 : RecordBase
|
|
{
|
|
|
|
/// <summary>
|
|
/// RecordId = 21,
|
|
/// ItemId = 8,
|
|
/// LongMnemonic = "BTNUM",
|
|
/// ShortMnemonic = "BNUM",
|
|
/// Description = "Bit Number",
|
|
/// Description2 = "",
|
|
/// FPSUnits = "----",
|
|
/// MetricUnits = "----",
|
|
/// Length = 8,
|
|
/// ValueType = "A"
|
|
/// </summary>
|
|
[Column("BTNUM")]
|
|
public string? Btnum { get; set; }
|
|
|
|
/// <summary>
|
|
/// RecordId = 21,
|
|
/// ItemId = 9,
|
|
/// LongMnemonic = "BTDIAM",
|
|
/// ShortMnemonic = "BDIA",
|
|
/// Description = "Bit Diameter",
|
|
/// Description2 = "",
|
|
/// FPSUnits = "IN",
|
|
/// MetricUnits = "MM",
|
|
/// Length = 4,
|
|
/// ValueType = "F"
|
|
/// </summary>
|
|
[Column("BTDIAM")]
|
|
public float? Btdiam { get; set; }
|
|
|
|
/// <summary>
|
|
/// RecordId = 21,
|
|
/// ItemId = 10,
|
|
/// LongMnemonic = "BTMANUF",
|
|
/// ShortMnemonic = "BMAN",
|
|
/// Description = "Bit Manufacturer",
|
|
/// Description2 = "",
|
|
/// FPSUnits = "----",
|
|
/// MetricUnits = "----",
|
|
/// Length = 16,
|
|
/// ValueType = "A"
|
|
/// </summary>
|
|
[Column("BTMANUF")]
|
|
public string? Btmanuf { get; set; }
|
|
|
|
/// <summary>
|
|
/// RecordId = 21,
|
|
/// ItemId = 11,
|
|
/// LongMnemonic = "BTNAME",
|
|
/// ShortMnemonic = "BNAM",
|
|
/// Description = "Bit Name",
|
|
/// Description2 = "",
|
|
/// FPSUnits = "----",
|
|
/// MetricUnits = "----",
|
|
/// Length = 16,
|
|
/// ValueType = "A"
|
|
/// </summary>
|
|
[Column("BTNAME")]
|
|
public string? Btname { get; set; }
|
|
|
|
/// <summary>
|
|
/// RecordId = 21,
|
|
/// ItemId = 12,
|
|
/// LongMnemonic = "BTCODE",
|
|
/// ShortMnemonic = "BCOD",
|
|
/// Description = "Bit IADC Code",
|
|
/// Description2 = "",
|
|
/// FPSUnits = "----",
|
|
/// MetricUnits = "----",
|
|
/// Length = 8,
|
|
/// ValueType = "A"
|
|
/// </summary>
|
|
[Column("BTCODE")]
|
|
public string? Btcode { get; set; }
|
|
|
|
/// <summary>
|
|
/// RecordId = 21,
|
|
/// ItemId = 13,
|
|
/// LongMnemonic = "BTSERNUM",
|
|
/// ShortMnemonic = "BSER",
|
|
/// Description = "Bit Serial Number",
|
|
/// Description2 = "",
|
|
/// FPSUnits = "----",
|
|
/// MetricUnits = "----",
|
|
/// Length = 16,
|
|
/// ValueType = "A"
|
|
/// </summary>
|
|
[Column("BTSERNUM")]
|
|
public string? Btsernum { get; set; }
|
|
|
|
/// <summary>
|
|
/// RecordId = 21,
|
|
/// ItemId = 14,
|
|
/// LongMnemonic = "BTCOST",
|
|
/// ShortMnemonic = "BCST",
|
|
/// Description = "Bit Cost",
|
|
/// Description2 = "",
|
|
/// FPSUnits = "$",
|
|
/// MetricUnits = "$",
|
|
/// Length = 4,
|
|
/// ValueType = "F"
|
|
/// </summary>
|
|
[Column("BTCOST")]
|
|
public float? Btcost { get; set; }
|
|
|
|
/// <summary>
|
|
/// RecordId = 21,
|
|
/// ItemId = 15,
|
|
/// LongMnemonic = "BTJET1",
|
|
/// ShortMnemonic = "BJT1",
|
|
/// Description = "Bit Jet 1 Diameter",
|
|
/// Description2 = "",
|
|
/// FPSUnits = "I/32",
|
|
/// MetricUnits = "MM",
|
|
/// Length = 4,
|
|
/// ValueType = "F"
|
|
/// </summary>
|
|
[Column("BTJET1")]
|
|
public float? Btjet1 { get; set; }
|
|
|
|
/// <summary>
|
|
/// RecordId = 21,
|
|
/// ItemId = 16,
|
|
/// LongMnemonic = "BTJET2",
|
|
/// ShortMnemonic = "BJT2",
|
|
/// Description = "Bit Jet 2 Diameter",
|
|
/// Description2 = "",
|
|
/// FPSUnits = "I/32",
|
|
/// MetricUnits = "MM",
|
|
/// Length = 4,
|
|
/// ValueType = "F"
|
|
/// </summary>
|
|
[Column("BTJET2")]
|
|
public float? Btjet2 { get; set; }
|
|
|
|
/// <summary>
|
|
/// RecordId = 21,
|
|
/// ItemId = 17,
|
|
/// LongMnemonic = "BTJET3",
|
|
/// ShortMnemonic = "BJT3",
|
|
/// Description = "Bit Jet 3 Diameter",
|
|
/// Description2 = "",
|
|
/// FPSUnits = "I/32",
|
|
/// MetricUnits = "MM",
|
|
/// Length = 4,
|
|
/// ValueType = "F"
|
|
/// </summary>
|
|
[Column("BTJET3")]
|
|
public float? Btjet3 { get; set; }
|
|
|
|
/// <summary>
|
|
/// RecordId = 21,
|
|
/// ItemId = 18,
|
|
/// LongMnemonic = "BTJET4",
|
|
/// ShortMnemonic = "BJT4",
|
|
/// Description = "Bit Jet 4 Diameter",
|
|
/// Description2 = "",
|
|
/// FPSUnits = "I/32",
|
|
/// MetricUnits = "MM",
|
|
/// Length = 4,
|
|
/// ValueType = "F"
|
|
/// </summary>
|
|
[Column("BTJET4")]
|
|
public float? Btjet4 { get; set; }
|
|
|
|
/// <summary>
|
|
/// RecordId = 21,
|
|
/// ItemId = 19,
|
|
/// LongMnemonic = "BTJETCEN",
|
|
/// ShortMnemonic = "BJTC",
|
|
/// Description = "Bit Center Jet Diameter",
|
|
/// Description2 = "",
|
|
/// FPSUnits = "I/32",
|
|
/// MetricUnits = "MM",
|
|
/// Length = 4,
|
|
/// ValueType = "F"
|
|
/// </summary>
|
|
[Column("BTJETCEN")]
|
|
public float? Btjetcen { get; set; }
|
|
|
|
/// <summary>
|
|
/// RecordId = 21,
|
|
/// ItemId = 20,
|
|
/// LongMnemonic = "BTTFA",
|
|
/// ShortMnemonic = "BTFA",
|
|
/// Description = "Bit Total Flow Area",
|
|
/// Description2 = "",
|
|
/// FPSUnits = "SQIN",
|
|
/// MetricUnits = "MM2",
|
|
/// Length = 4,
|
|
/// ValueType = "F"
|
|
/// </summary>
|
|
[Column("BTTFA")]
|
|
public float? Bttfa { get; set; }
|
|
|
|
/// <summary>
|
|
/// RecordId = 21,
|
|
/// ItemId = 21,
|
|
/// LongMnemonic = "BTDEPIN",
|
|
/// ShortMnemonic = "BDPI",
|
|
/// Description = "Bit Starting Depth (In)",
|
|
/// Description2 = "",
|
|
/// FPSUnits = "F",
|
|
/// MetricUnits = "M",
|
|
/// Length = 4,
|
|
/// ValueType = "F"
|
|
/// </summary>
|
|
[Column("BTDEPIN")]
|
|
public float? Btdepin { get; set; }
|
|
|
|
/// <summary>
|
|
/// RecordId = 21,
|
|
/// ItemId = 22,
|
|
/// LongMnemonic = "BTDEPOUT",
|
|
/// ShortMnemonic = "BDPO",
|
|
/// Description = "Bit Ending Depth (Out)",
|
|
/// Description2 = "",
|
|
/// FPSUnits = "F",
|
|
/// MetricUnits = "M",
|
|
/// Length = 4,
|
|
/// ValueType = "F"
|
|
/// </summary>
|
|
[Column("BTDEPOUT")]
|
|
public float? Btdepout { get; set; }
|
|
|
|
/// <summary>
|
|
/// RecordId = 21,
|
|
/// ItemId = 23,
|
|
/// LongMnemonic = "BTDDIST",
|
|
/// ShortMnemonic = "BDDI",
|
|
/// Description = "Bit Run Drilled Distance",
|
|
/// Description2 = "",
|
|
/// FPSUnits = "F",
|
|
/// MetricUnits = "M",
|
|
/// Length = 4,
|
|
/// ValueType = "F"
|
|
/// </summary>
|
|
[Column("BTDDIST")]
|
|
public float? Btddist { get; set; }
|
|
|
|
/// <summary>
|
|
/// RecordId = 21,
|
|
/// ItemId = 24,
|
|
/// LongMnemonic = "BTDTIME",
|
|
/// ShortMnemonic = "BDTI",
|
|
/// Description = "Bit Run Drilled Time",
|
|
/// Description2 = "",
|
|
/// FPSUnits = "HR",
|
|
/// MetricUnits = "HR",
|
|
/// Length = 4,
|
|
/// ValueType = "F"
|
|
/// </summary>
|
|
[Column("BTDTIME")]
|
|
public float? Btdtime { get; set; }
|
|
|
|
/// <summary>
|
|
/// RecordId = 21,
|
|
/// ItemId = 25,
|
|
/// LongMnemonic = "BTRTIME",
|
|
/// ShortMnemonic = "BRTI",
|
|
/// Description = "Bit Run Reamed Time",
|
|
/// Description2 = "",
|
|
/// FPSUnits = "HR",
|
|
/// MetricUnits = "HR",
|
|
/// Length = 4,
|
|
/// ValueType = "F"
|
|
/// </summary>
|
|
[Column("BTRTIME")]
|
|
public float? Btrtime { get; set; }
|
|
|
|
/// <summary>
|
|
/// RecordId = 21,
|
|
/// ItemId = 26,
|
|
/// LongMnemonic = "BTROPA",
|
|
/// ShortMnemonic = "BRPA",
|
|
/// Description = "Bit Penetration Rate (avg)",
|
|
/// Description2 = "",
|
|
/// FPSUnits = "F/HR",
|
|
/// MetricUnits = "M/HR",
|
|
/// Length = 4,
|
|
/// ValueType = "F"
|
|
/// </summary>
|
|
[Column("BTROPA")]
|
|
public float? Btropa { get; set; }
|
|
|
|
/// <summary>
|
|
/// RecordId = 21,
|
|
/// ItemId = 27,
|
|
/// LongMnemonic = "BTWOBA",
|
|
/// ShortMnemonic = "BWBA",
|
|
/// Description = "Bit Weight-on-Bit (avg)",
|
|
/// Description2 = "",
|
|
/// FPSUnits = "KLB",
|
|
/// MetricUnits = "KDN",
|
|
/// Length = 4,
|
|
/// ValueType = "F"
|
|
/// </summary>
|
|
[Column("BTWOBA")]
|
|
public float? Btwoba { get; set; }
|
|
|
|
/// <summary>
|
|
/// RecordId = 21,
|
|
/// ItemId = 28,
|
|
/// LongMnemonic = "BTWOBX",
|
|
/// ShortMnemonic = "BWBX",
|
|
/// Description = "Bit Weight-on-Bit (max)",
|
|
/// Description2 = "",
|
|
/// FPSUnits = "KLB",
|
|
/// MetricUnits = "KDN",
|
|
/// Length = 4,
|
|
/// ValueType = "F"
|
|
/// </summary>
|
|
[Column("BTWOBX")]
|
|
public float? Btwobx { get; set; }
|
|
|
|
/// <summary>
|
|
/// RecordId = 21,
|
|
/// ItemId = 29,
|
|
/// LongMnemonic = "BTRPMA",
|
|
/// ShortMnemonic = "BRMA",
|
|
/// Description = "Bit Rotary Speed (avg)",
|
|
/// Description2 = "",
|
|
/// FPSUnits = "RPM",
|
|
/// MetricUnits = "RPM",
|
|
/// Length = 2,
|
|
/// ValueType = "S"
|
|
/// </summary>
|
|
[Column("BTRPMA")]
|
|
public short? Btrpma { get; set; }
|
|
|
|
/// <summary>
|
|
/// RecordId = 21,
|
|
/// ItemId = 30,
|
|
/// LongMnemonic = "BTRPMX",
|
|
/// ShortMnemonic = "BRMX",
|
|
/// Description = "Bit Rotary Speed (max)",
|
|
/// Description2 = "",
|
|
/// FPSUnits = "RPM",
|
|
/// MetricUnits = "RPM",
|
|
/// Length = 2,
|
|
/// ValueType = "S"
|
|
/// </summary>
|
|
[Column("BTRPMX")]
|
|
public short? Btrpmx { get; set; }
|
|
|
|
/// <summary>
|
|
/// RecordId = 21,
|
|
/// ItemId = 31,
|
|
/// LongMnemonic = "BTMFA",
|
|
/// ShortMnemonic = "BMFA",
|
|
/// Description = "Bit Mud Flow Rate (avg)",
|
|
/// Description2 = "",
|
|
/// FPSUnits = "GPM",
|
|
/// MetricUnits = "L/M",
|
|
/// Length = 4,
|
|
/// ValueType = "F"
|
|
/// </summary>
|
|
[Column("BTMFA")]
|
|
public float? Btmfa { get; set; }
|
|
|
|
/// <summary>
|
|
/// RecordId = 21,
|
|
/// ItemId = 32,
|
|
/// LongMnemonic = "BTMDA",
|
|
/// ShortMnemonic = "BMDA",
|
|
/// Description = "Bit Mud Density (avg)",
|
|
/// Description2 = "",
|
|
/// FPSUnits = "PPG",
|
|
/// MetricUnits = "KGM3",
|
|
/// Length = 4,
|
|
/// ValueType = "F"
|
|
/// </summary>
|
|
[Column("BTMDA")]
|
|
public float? Btmda { get; set; }
|
|
|
|
/// <summary>
|
|
/// RecordId = 21,
|
|
/// ItemId = 33,
|
|
/// LongMnemonic = "BTSPPA",
|
|
/// ShortMnemonic = "BSPA",
|
|
/// Description = "Bit Standpipe Pressure (avg)",
|
|
/// Description2 = "",
|
|
/// FPSUnits = "PSI",
|
|
/// MetricUnits = "KPA",
|
|
/// Length = 4,
|
|
/// ValueType = "F"
|
|
/// </summary>
|
|
[Column("BTSPPA")]
|
|
public float? Btsppa { get; set; }
|
|
|
|
/// <summary>
|
|
/// RecordId = 21,
|
|
/// ItemId = 34,
|
|
/// LongMnemonic = "BTRUN",
|
|
/// ShortMnemonic = "BRUN",
|
|
/// Description = "Bit Reason Run",
|
|
/// Description2 = "",
|
|
/// FPSUnits = "----",
|
|
/// MetricUnits = "----",
|
|
/// Length = 16,
|
|
/// ValueType = "A"
|
|
/// </summary>
|
|
[Column("BTRUN")]
|
|
public string? Btrun { get; set; }
|
|
|
|
/// <summary>
|
|
/// RecordId = 21,
|
|
/// ItemId = 35,
|
|
/// LongMnemonic = "BTPULL",
|
|
/// ShortMnemonic = "BPUL",
|
|
/// Description = "Bit Reason Pulled",
|
|
/// Description2 = "",
|
|
/// FPSUnits = "----",
|
|
/// MetricUnits = "----",
|
|
/// Length = 16,
|
|
/// ValueType = "A"
|
|
/// </summary>
|
|
[Column("BTPULL")]
|
|
public string? Btpull { get; set; }
|
|
|
|
/// <summary>
|
|
/// RecordId = 21,
|
|
/// ItemId = 36,
|
|
/// LongMnemonic = "BTGRDIN",
|
|
/// ShortMnemonic = "BGI",
|
|
/// Description = "Bit Grade In",
|
|
/// Description2 = "",
|
|
/// FPSUnits = "----",
|
|
/// MetricUnits = "----",
|
|
/// Length = 16,
|
|
/// ValueType = "A"
|
|
/// </summary>
|
|
[Column("BTGRDIN")]
|
|
public string? Btgrdin { get; set; }
|
|
|
|
/// <summary>
|
|
/// RecordId = 21,
|
|
/// ItemId = 37,
|
|
/// LongMnemonic = "BTGRDOUT",
|
|
/// ShortMnemonic = "BGO",
|
|
/// Description = "Bit Grade Out",
|
|
/// Description2 = "",
|
|
/// FPSUnits = "----",
|
|
/// MetricUnits = "----",
|
|
/// Length = 16,
|
|
/// ValueType = "A"
|
|
/// </summary>
|
|
[Column("BTGRDOUT")]
|
|
public string? Btgrdout { get; set; }
|
|
|
|
/// <summary>
|
|
/// RecordId = 21,
|
|
/// ItemId = 38,
|
|
/// LongMnemonic = "BTSHKSUB",
|
|
/// ShortMnemonic = "BSHK",
|
|
/// Description = "Bit Shock Sub Used ?",
|
|
/// Description2 = "",
|
|
/// FPSUnits = "----",
|
|
/// MetricUnits = "----",
|
|
/// Length = 1,
|
|
/// ValueType = "A"
|
|
/// </summary>
|
|
[Column("BTSHKSUB")]
|
|
public string? Btshksub { get; set; }
|
|
|
|
/// <summary>
|
|
/// RecordId = 21,
|
|
/// ItemId = 39,
|
|
/// LongMnemonic = "BTMUDMOT",
|
|
/// ShortMnemonic = "BMM",
|
|
/// Description = "Bit Mud Motor Used ?",
|
|
/// Description2 = "",
|
|
/// FPSUnits = "----",
|
|
/// MetricUnits = "----",
|
|
/// Length = 1,
|
|
/// ValueType = "A"
|
|
/// </summary>
|
|
[Column("BTMUDMOT")]
|
|
public string? Btmudmot { get; set; }
|
|
|
|
/// <summary>
|
|
/// RecordId = 21,
|
|
/// ItemId = 40,
|
|
/// LongMnemonic = "BTCOMM",
|
|
/// ShortMnemonic = "BCOM",
|
|
/// Description = "Bit Comments",
|
|
/// Description2 = "",
|
|
/// FPSUnits = "----",
|
|
/// MetricUnits = "----",
|
|
/// Length = 128,
|
|
/// ValueType = "A"
|
|
/// </summary>
|
|
[Column("BTCOMM")]
|
|
public string? Btcomm { get; set; }
|
|
|
|
/// <summary>
|
|
/// RecordId = 21,
|
|
/// ItemId = 41,
|
|
/// LongMnemonic = "SPARE1",
|
|
/// ShortMnemonic = "SPR1",
|
|
/// Description = "< SPARE 1>",
|
|
/// Description2 = "",
|
|
/// FPSUnits = "----",
|
|
/// MetricUnits = "----",
|
|
/// Length = 4,
|
|
/// ValueType = "F"
|
|
/// </summary>
|
|
[Column("SPARE1")]
|
|
public float? Spare1 { get; set; }
|
|
|
|
/// <summary>
|
|
/// RecordId = 21,
|
|
/// ItemId = 42,
|
|
/// LongMnemonic = "SPARE2",
|
|
/// ShortMnemonic = "SPR2",
|
|
/// Description = "< SPARE 2>",
|
|
/// Description2 = "",
|
|
/// FPSUnits = "----",
|
|
/// MetricUnits = "----",
|
|
/// Length = 4,
|
|
/// ValueType = "F"
|
|
/// </summary>
|
|
[Column("SPARE2")]
|
|
public float? Spare2 { get; set; }
|
|
|
|
/// <summary>
|
|
/// RecordId = 21,
|
|
/// ItemId = 43,
|
|
/// LongMnemonic = "SPARE3",
|
|
/// ShortMnemonic = "SPR3",
|
|
/// Description = "< SPARE 3>",
|
|
/// Description2 = "",
|
|
/// FPSUnits = "----",
|
|
/// MetricUnits = "----",
|
|
/// Length = 4,
|
|
/// ValueType = "F"
|
|
/// </summary>
|
|
[Column("SPARE3")]
|
|
public float? Spare3 { get; set; }
|
|
|
|
/// <summary>
|
|
/// RecordId = 21,
|
|
/// ItemId = 44,
|
|
/// LongMnemonic = "SPARE4",
|
|
/// ShortMnemonic = "SPR4",
|
|
/// Description = "< SPARE 4>",
|
|
/// Description2 = "",
|
|
/// FPSUnits = "----",
|
|
/// MetricUnits = "----",
|
|
/// Length = 4,
|
|
/// ValueType = "F"
|
|
/// </summary>
|
|
[Column("SPARE4")]
|
|
public float? Spare4 { get; set; }
|
|
|
|
/// <summary>
|
|
/// RecordId = 21,
|
|
/// ItemId = 45,
|
|
/// LongMnemonic = "SPARE5",
|
|
/// ShortMnemonic = "SPR5",
|
|
/// Description = "< SPARE 5>",
|
|
/// Description2 = "",
|
|
/// FPSUnits = "----",
|
|
/// MetricUnits = "---",
|
|
/// Length = 4,
|
|
/// ValueType = "F"
|
|
/// </summary>
|
|
[Column("SPARE5")]
|
|
public float? Spare5 { get; set; }
|
|
|
|
/// <summary>
|
|
/// RecordId = 21,
|
|
/// ItemId = 46,
|
|
/// LongMnemonic = "SPARE6",
|
|
/// ShortMnemonic = "SPR6",
|
|
/// Description = "< SPARE 6>",
|
|
/// Description2 = "",
|
|
/// FPSUnits = "----",
|
|
/// MetricUnits = "----",
|
|
/// Length = 4,
|
|
/// ValueType = "F"
|
|
/// </summary>
|
|
[Column("SPARE6")]
|
|
public float? Spare6 { get; set; }
|
|
|
|
/// <summary>
|
|
/// RecordId = 21,
|
|
/// ItemId = 47,
|
|
/// LongMnemonic = "SPARE7",
|
|
/// ShortMnemonic = "SPR7",
|
|
/// Description = "< SPARE 7>",
|
|
/// Description2 = "",
|
|
/// FPSUnits = "----",
|
|
/// MetricUnits = "----",
|
|
/// Length = 4,
|
|
/// ValueType = "F"
|
|
/// </summary>
|
|
[Column("SPARE7")]
|
|
public float? Spare7 { get; set; }
|
|
|
|
/// <summary>
|
|
/// RecordId = 21,
|
|
/// ItemId = 48,
|
|
/// LongMnemonic = "SPARE8",
|
|
/// ShortMnemonic = "SPR8",
|
|
/// Description = "< SPARE 8>",
|
|
/// Description2 = "",
|
|
/// FPSUnits = "----",
|
|
/// MetricUnits = "----",
|
|
/// Length = 4,
|
|
/// ValueType = "F"
|
|
/// </summary>
|
|
[Column("SPARE8")]
|
|
public float? Spare8 { get; set; }
|
|
|
|
/// <summary>
|
|
/// RecordId = 21,
|
|
/// ItemId = 49,
|
|
/// LongMnemonic = "SPARE9",
|
|
/// ShortMnemonic = "SPR9",
|
|
/// Description = "< SPARE 9>",
|
|
/// Description2 = "",
|
|
/// FPSUnits = "----",
|
|
/// MetricUnits = "---",
|
|
/// Length = 4,
|
|
/// ValueType = "F"
|
|
/// </summary>
|
|
[Column("SPARE9")]
|
|
public float? Spare9 { get; set; }
|
|
|
|
}
|
|
}
|