Helios-Telemetry/packages/db/src/entities/Battery.entity.ts at 3d802fae7ca2f40f80a92ba5a26af3fc88a0a1ee · UCSolarCarTeam/Helios-Telemetry · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
import { Entity, Column, Index, PrimaryColumn } from "typeorm";
import { Hypertable, TimeColumn } from "@timescaledb/typeorm";

/**
 * Battery sensor data hypertable
 * Related to telemetry_metadata via timestamp + rfid
 */
@Entity("battery")
@Hypertable({
  timeColumnName: "timestamp",
  chunkTimeInterval: "1 month",
  compression: {
    compress: true,
    compress_segmentby: "rfid",
    compress_orderby: "timestamp DESC",
  },
})
@Index(["rfid", "timestamp"])
export class Battery {
  @TimeColumn()
  @PrimaryColumn({ type: "timestamptz" })
  Timestamp!: Date;

  @PrimaryColumn({ type: "text" })
  Rfid!: string;

  @Column({ type: "boolean" })
  AlwaysOnSignalStatus!: boolean;

  @Column({ type: "float" })
  AverageCellVoltage!: number;

  @Column({ type: "float" })
  AverageTemperature!: number;

  @Column({ type: "integer" })
  BmuAlive!: number;

  @Column({ type: "boolean" })
  ChargeRelayEnabled!: boolean;

  @Column({ type: "boolean" })
  ChargerSafetyEnabled!: boolean;

  @Column({ type: "boolean" })
  DischargeRelayEnabled!: boolean;

  @Column({ type: "float" })
  FanSpeed!: number;

  @Column({ type: "float" })
  FanVoltage!: number;

  @Column({ type: "float" })
  HighCellVoltage!: number;

  @Column({ type: "integer" })
  HighCellVoltageId!: number;

  @Column({ type: "float" })
  HighTemperature!: number;

  @Column({ type: "integer" })
  HighThermistorId!: number;

  @Column({ type: "float" })
  Input12v!: number;

  @Column({ type: "float" })
  InternalTemperature!: number;

  @Column({ type: "boolean" })
  IsChargingSignalStatus!: boolean;

  @Column({ type: "boolean" })
  IsReadySignalStatus!: boolean;

  @Column({ type: "float" })
  LowCellVoltage!: number;

  @Column({ type: "integer" })
  LowCellVoltageId!: number;

  @Column({ type: "float" })
  LowTemperature!: number;

  @Column({ type: "integer" })
  LowThermistorId!: number;

  @Column({ type: "boolean" })
  MalfunctionIndicatorActive!: boolean;

  @Column({ type: "float" })
  MaximumCellVoltage!: number;

  @Column({ type: "float" })
  MaximumPackVoltage!: number;

  @Column({ type: "float" })
  MinimumCellVoltage!: number;

  @Column({ type: "float" })
  MinimumPackVoltage!: number;

  @Column({ type: "boolean" })
  MultiPurposeInputSignalStatus!: boolean;

  @Column({ type: "float" })
  PackAmphours!: number;

  @Column({ type: "float" })
  PackCurrent!: number;

  @Column({ type: "float" })
  PackDepthOfDischarge!: number;

  @Column({ type: "float" })
  PackStateOfCharge!: number;

  @Column({ type: "float" })
  PackVoltage!: number;

  @Column({ type: "integer" })
  PopulatedCells!: number;

  @Column({ type: "float" })
  RequestedFanSpeed!: number;
}