Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| channel_status_id | serial | 10 | √ | nextval('cycler_monitor_channel_statuses_id_seq'::regclass) |
|
|
Unique identifier for the cycler channel status. Auto-incremented upon insertion. |
||||
| cycler_id | int4 | 10 | null |
|
|
Refers to the cycler instance defined in cyclers table. |
|||||
| channel | int2 | 5 | null |
|
|
Channel number of the cycler. |
|||||
| status | text | 2147483647 | null |
|
|
Status of the cycler channel. Can be idle, rest, charge, discharge, problem, or other. |
|||||
| cycle | int2 | 5 | √ | null |
|
|
Cycle number of the cycler channel. |
||||
| step | int2 | 5 | √ | null |
|
|
Step number of the cycler channel. |
||||
| test_time_s | numeric | 0 | √ | null |
|
|
Test time in seconds. |
||||
| step_time_s | numeric | 0 | √ | null |
|
|
Step time in seconds. |
||||
| voltage_mv | int4 | 10 | √ | null |
|
|
Voltage in mV. |
||||
| current_ma | int4 | 10 | √ | null |
|
|
Current in mA. |
||||
| charge_capacity_mah | int4 | 10 | √ | null |
|
|
Charge capacity in mAh. |
||||
| discharge_capacity_mah | int4 | 10 | √ | null |
|
|
Discharge capacity in mAh. |
||||
| charge_energy_mwh | int4 | 10 | √ | null |
|
|
Charge energy in mWh. |
||||
| discharge_energy_mwh | int4 | 10 | √ | null |
|
|
Discharge energy in mWh. |
||||
| timestamp_s | float8 | 17,17 | null |
|
|
Timestamp in seconds. |
|||||
| insert_time | timestamptz | 35,6 | now() |
|
|
Timestamp of insertion into the database. |
|||||
| other_details | jsonb | 2147483647 | √ | null |
|
|
Other details about the cycler channel status. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| cycler_rt_channel_statuses_insert_time_idx | Performance | Desc | insert_time |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| status_vals | ((status = ANY (ARRAY['idle'::text, 'rest'::text, 'charge'::text, 'discharge'::text, 'problem'::text, 'finished'::text, 'other'::text]))) |
Relationships
Close relationships within degrees of separation
