Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| modules_testdata_id | serial | 10 | √ | nextval('modules_testdata_modules_testdata_id_seq'::regclass) |
|
|
Unique identifier for the module test data point. Auto-incremented upon insertion. |
||||
| module_test_id | int4 | 10 | null |
|
|
Refers to the module test defined in modules_test_meta table. |
|||||
| datetime | timestamptz | 35,6 | √ | null |
|
|
Date and time (relative to the timezone set on the cycler computer) at the specific sample time. |
||||
| unixtime_s | numeric | 0 | √ | null |
|
|
Date and time converted to unix time (also called ‘epoch time’) for the specific sample time. |
||||
| cycle | int2 | 5 | √ | null |
|
|
Total number of charge/discharge step pairs the schedule file has completed. Can vary depending on the schedule file. |
||||
| tc_counter1 | int2 | 5 | √ | null |
|
|
Counter for loops in loops. |
||||
| tc_counter2 | int2 | 5 | √ | null |
|
|
Counter for loops in loops. |
||||
| tc_counter3 | int2 | 5 | √ | null |
|
|
Counter for loops in loops. |
||||
| tc_counter4 | int2 | 5 | √ | null |
|
|
Counter for loops in loops. |
||||
| max_cellvoltage_mv | numeric | 0 | √ | null |
|
|
Cell in module with the highest voltage. |
||||
| min_cellvoltage_mv | numeric | 0 | √ | null |
|
|
Cell in module with the lowest voltage. |
||||
| max_cellvoltage_index | int2 | 5 | √ | null |
|
|
Index of cell in module with the highest voltage. |
||||
| min_cellvoltage_index | int2 | 5 | √ | null |
|
|
Index of cell in module with the lowest voltage. |
||||
| cell_voltage_delta_mv | numeric | 0 | √ | null |
|
|
Change in voltage from last sample. |
||||
| step | int2 | 5 | √ | null |
|
|
The cycle schedule step for the data point. |
||||
| step_time_s | numeric | 0 | √ | null |
|
|
Time ellapsed since the start of the step, not counting pauses. |
||||
| test_time_s | numeric | 0 | √ | null |
|
|
Time ellapsed since the start of the test, not counting pauses. |
||||
| temps_c | _numeric | 131089 | √ | null |
|
|
Temperature of each cell in the module. |
||||
| module_voltage_mv | numeric | 0 | √ | null |
|
|
Voltage of the module. Nominally this is the battery voltage. |
||||
| cell_voltages_mv | _numeric | 131089 | √ | null |
|
|
Voltage of each cell in the module. |
||||
| current_ma | numeric | 0 | √ | null |
|
|
The current sourced (or sunk for discharge) by the cycler at the specific sample time. |
||||
| charge_capacity_mah | numeric | 0 | √ | null |
|
|
The cumulative charge put out by the cycler during charge for the current step. |
||||
| discharge_capacity_mah | numeric | 0 | √ | null |
|
|
The cumulative charge taken in by the cycler during discharge charge for the current step. |
||||
| charge_energy_mwh | numeric | 0 | √ | null |
|
|
The cumulative energy used by the charger during the current step at the sample time. |
||||
| discharge_energy_mwh | numeric | 0 | √ | null |
|
|
The cumulative energy used by the charger during the current step at the sample time. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| modules_testdata_pkey | Primary key | Asc | modules_testdata_id |
Relationships
Close relationships within degrees of separation
