Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| hil_data_id | serial | 10 | √ | nextval('hil_data_hil_data_id_seq'::regclass) |
|
|
Unique identifier for the HIL data point. Auto-incremented upon insertion. |
||||
| hil_id | int4 | 10 | √ | null |
|
|
Refers to the HIL test defined in hil_meta table. |
||||
| cycle | int2 | 5 | √ | null |
|
|
The cycle number of the data point. Tracks number of charge/discharge cycles. |
||||
| step | int2 | 5 | √ | null |
|
|
The step number of the data point. |
||||
| step_time_s | numeric | 0 | √ | null |
|
|
The time in seconds since the start of the step, ignoring pauses. |
||||
| test_time_s | numeric | 0 | √ | null |
|
|
The time in seconds since the start of the test, ignoring pauses. |
||||
| measured_voltage_mv | numeric | 0 | √ | null |
|
|
The voltage measured by the cycler during the data point. |
||||
| modeled_voltage_mv | numeric | 0 | √ | null |
|
|
The voltage predicted by the model during the data point. |
||||
| voltage_delta_mv | numeric | 0 | √ | null |
|
|
The difference between the measured and modeled voltage during the data point. |
||||
| measured_current_ma | numeric | 0 | √ | null |
|
|
The current measured by the cycler during the data point. |
||||
| modeled_current_ma | numeric | 0 | √ | null |
|
|
The current predicted by the model during the data point. |
||||
| datetime | timestamptz | 35,6 | √ | null |
|
|
The date and time the data point was recorded by cycler. Matches timezone of cycler. |
||||
| unixtime_s | numeric | 0 | √ | null |
|
|
The time in seconds since the Unix epoch (January 1, 1970). Calculated from recorded_datetime. |
||||
| status | text | 2147483647 | √ | null |
|
|
The status of the cycler during the data point. Can be idle, rest, charge, discharge, problem, or other. |
||||
| overpotential_mv | numeric | 0 | √ | null |
|
|
The overpotential of the data point. |
||||
| solution_time_ms | numeric | 0 | √ | null |
|
|
The solution time of the data point. |
||||
| model_states | _numeric | 131089 | √ | null |
|
|
The model states during the data point. |
||||
| insert_time | timestamptz | 35,6 | now() |
|
|
Timestamp of insertion into the database. |
|||||
| other_details | jsonb | 2147483647 | √ | null |
|
|
Other details about the HIL data point. |
||||
| reported_charge_capacity_mah | numeric | 0 | √ | null |
|
|
The charge capacity reported by the cycler at the end of the cycle. |
||||
| reported_discharge_capacity_mah | numeric | 0 | √ | null |
|
|
The discharge capacity reported by the cycler at the end of the cycle. |
||||
| reported_charge_energy_mwh | numeric | 0 | √ | null |
|
|
The charge energy reported by the cycler at the end of the cycle. |
||||
| reported_discharge_energy_mwh | numeric | 0 | √ | null |
|
|
The discharge energy reported by the cycler at the end of the cycle. |
||||
| state_of_charge | numeric | 0 | √ | null |
|
|
The state of charge reported by the cycler at the end of the cycle. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| hil_data_insert_time_idx | Performance | Desc | insert_time |
Relationships
Close relationships within degrees of separation
