Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| cycle_stats_id | serial | 10 | √ | nextval('testdata_cyclestats_cyclestats_id_seq'::regclass) |
|
|
Unique identifier for the test data cycle stats. Auto-incremented upon insertion. |
||||
| test_id | int2 | 5 | null |
|
|
The specific test the data point is associated with. References the test_id in the test_meta table. |
|||||
| cycle | int2 | 5 | √ | null |
|
|
The cycle number of the data point. Tracks number of charge/discharge cycles. |
||||
| test_time_s | int4 | 10 | √ | null |
|
|
The time in seconds since the start of the test, ignoring pauses. |
||||
| 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. |
||||
| calculated_charge_capacity_mah | numeric | 0 | √ | null |
|
|
The charge capacity at the end of the cycle. Calculated from test_data Table values by battetl. Should be the same as reported_charge_capacity_mah. |
||||
| calculated_max_charge_temp_c | numeric | 0 | √ | null |
|
|
The maximum temperature during the charge step of the cycle. Calculated from test_data table values by battetl. |
||||
| calculated_discharge_capacity_mah | numeric | 0 | √ | null |
|
|
The discharge capacity at the end of the cycle. Calculated from test_data table values by battetl. Should be the same as reported_discharge_capacity_mah. |
||||
| calculated_max_discharge_temp_c | numeric | 0 | √ | null |
|
|
The maximum temperature during the discharge step of the cycle. Calculated from test_data table values by battetl. |
||||
| calculated_cc_charge_time_s | numeric | 0 | √ | null |
|
|
The time in seconds spent in the constant current charge step of the cycle. Calculated from test_data table values by battetl. |
||||
| calculated_cv_charge_time_s | numeric | 0 | √ | null |
|
|
The time in seconds spent in the constant voltage charge step of the cycle. Calculated from test_data table values by battetl. |
||||
| calculated_cc_capacity_mah | numeric | 0 | √ | null |
|
|
The capacity in mAh delivered during the constant current charge step of the cycle. Calculated from test_data table values by battetl. |
||||
| calculated_cv_capacity_mah | numeric | 0 | √ | null |
|
|
The capacity in mAh delivered during the constant voltage charge step of the cycle. Calculated from test_data table values by battetl. |
||||
| calculated_coulombic_efficiency | numeric | 0 | √ | null |
|
|
Ratio of discharge capacity to charge capacity for cycle. Calculated from test_data table values by battetl. |
||||
| reported_coulombic_efficiency | numeric | 0 | √ | null |
|
|
Ratio of discharge capacity to charge capacity for cycle. Reported by cycler. |
||||
| reported_charge_time_s | numeric | 0 | √ | null |
|
|
The time in seconds spent in the charge step of the cycle. Reported by cycler. |
||||
| reported_discharge_time_s | numeric | 0 | √ | null |
|
|
The time in seconds spent in the discharge step of the cycle. Reported by cycler. |
||||
| calculated_fifty_percent_charge_time_s | numeric | 0 | √ | null |
|
|
The time in seconds to reach 50% of the final charge capacity for cycle. Calculated from test_data table values by battetl. |
||||
| calculated_eighty_percent_charge_time_s | numeric | 0 | √ | null |
|
|
The time in seconds to reach 80% of the final charge capacity for cycle. Calculated from test_data table values by battetl. |
||||
| calculated_charge_energy_mwh | numeric | 0 | √ | null |
|
|
The charge energy at the end of the cycle. Calculated from test_data table values by battetl. Should be the same as reported_charge_energy_mwh. |
||||
| calculated_discharge_energy_mwh | numeric | 0 | √ | null |
|
|
The discharge energy at the end of the cycle. Calculated from test_data table values by battetl. Should be the same as reported_discharge_energy_mwh. |
||||
| other_details | jsonb | 2147483647 | √ | null |
|
|
Other details about the test data cycle stats. Contains data for auxillary measurements. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| cyclestats_id | Primary key | Asc | cycle_stats_id |
| testdata_cyclestats_test_id_idx | Performance | Asc | test_id |
Relationships
Close relationships within degrees of separation
