Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| sil_data_id | serial | 10 | √ | nextval('sil_data_sil_data_id_seq'::regclass) |
|
|
Unique identifier for the SIL data point. Auto-incremented upon insertion. |
||||
| sil_id | int4 | 10 | √ | null |
|
|
Refers to the SIL test defined in sil_meta table. |
||||
| test_data_id | int4 | 10 | √ | null |
|
|
Refers to the test data defined in test_data table. |
||||
| cycle | int2 | 5 | √ | null |
|
|
The cycle number of the data point. Tracks number of charge/discharge cycles. |
||||
| 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. |
||||
| overpotential_mv | numeric | 0 | √ | null |
|
|
The overpotential of the data point. |
||||
| solution_time_ms | numeric | 0 | √ | null |
|
|
The solution time of the data point. |
||||
| insert_time | timestamptz | 35,6 | now() |
|
|
Timestamp of insertion into the database. |
|||||
| modeled_current_ma | numeric | 0 | √ | null |
|
|
The current predicted by the model during the data point. |
||||
| model_states | _numeric | 131089 | √ | null |
|
|
The model states during the data point. |
||||
| other_details | jsonb | 2147483647 | √ | null |
|
|
Other details about the SIL data point. |
||||
| recorded_datetime | timestamptz | 35,6 | √ | null |
|
|
The date and time the data point was recorded. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| sil_data_insert_time_idx | Performance | Desc | insert_time |
Relationships
Close relationships within degrees of separation
