Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| test_data_id | serial | 10 | √ | nextval('testdata_test_data_id_seq'::regclass) |
|
|
Unique identifier for the test data point. 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. |
||||
| step | int2 | 5 | √ | null |
|
|
Schedule step associated with the data point. |
||||
| test_time_s | numeric | 0 | √ | null |
|
|
The time in seconds since the start of the test, ignoring pauses. |
||||
| step_time_s | numeric | 0 | √ | null |
|
|
The time in seconds since the start of the step, ignoring pauses. |
||||
| current_ma | numeric | 0 | null |
|
|
The current sourced (or sunk) by the cycler at the specific sample time. Positive for charge, negative for discharge. |
|||||
| voltage_mv | numeric | 0 | null |
|
|
The voltage measured by the cycler at the specific sample time. |
|||||
| recorded_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. |
|||||
| thermocouple_temps_c | _numeric | 131089 | √ | null |
|
|
The temperature (in Celsius) of each thermocouple. Usually T1 is chamber temperature and T2 is cell temperature. |
||||
| other_details | jsonb | 2147483647 | √ | null |
|
|
Contains data for auxillary measurements. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| test_data_recorded_datetime_idx | Performance | Desc | recorded_datetime |
| testdata_test_id_idx | Performance | Asc | test_id |
Relationships
Close relationships within degrees of separation
