Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| test_id | serial | 10 | √ | nextval('testdata_meta_test_id_seq'::regclass) |
|
|
Unique identifier for the test. Auto-incremented upon insertion. |
||||||||||||||||||||||||||||||||||
| cell_id | int2 | 5 | √ | null |
|
|
Specific cell being tested. References the cell_id in the cells table. |
||||||||||||||||||||||||||||||||||
| schedule_id | int2 | 5 | √ | null |
|
|
Schedule file used in the test. References the schedule_id in the schedule_meta table. |
||||||||||||||||||||||||||||||||||
| test_name | text | 2147483647 | √ | null |
|
|
Name of the test in cycling software. |
||||||||||||||||||||||||||||||||||
| start_date | date | 13 | √ | null |
|
|
Date the test was started. Populated manually in config file. |
||||||||||||||||||||||||||||||||||
| end_date | date | 13 | √ | null |
|
|
Date the test was ended. Populated manually in config file. |
||||||||||||||||||||||||||||||||||
| channel | int2 | 5 | √ | null |
|
|
Cycler channel the test was run on. |
||||||||||||||||||||||||||||||||||
| ev_chamber | int2 | 5 | √ | null |
|
|
The environmental chamber the test was run in. |
||||||||||||||||||||||||||||||||||
| ev_chamber_slot | int2 | 5 | √ | null |
|
|
The slot in the environmental chamber the test was run in. |
||||||||||||||||||||||||||||||||||
| thermocouples | int2 | 5 | √ | null |
|
|
Specific thermocouple attached to the cell being tested. |
||||||||||||||||||||||||||||||||||
| thermocouple_channels | int2 | 5 | √ | null |
|
|
Channel the thermocouple is attached to. |
||||||||||||||||||||||||||||||||||
| comments | text | 2147483647 | √ | null |
|
|
Additional info about the test. |
||||||||||||||||||||||||||||||||||
| project_id | int4 | 10 | √ | null |
|
|
Project the test is associated with. References the project_id in the projects table. |
||||||||||||||||||||||||||||||||||
| test_capacity_mah | int4 | 10 | √ | null |
|
|
Rated capacity of the cell being tested. |
||||||||||||||||||||||||||||||||||
| potentiostat_id | _int4 | 10 | √ | null |
|
|
Potentiostat the test was run on. References the potentiostat_id in the potentiostats table. |
||||||||||||||||||||||||||||||||||
| cycler_id | int4 | 10 | √ | null |
|
|
Cycler the test was run on. References the cycler_id in the cyclers table. |
||||||||||||||||||||||||||||||||||
| first_recorded_datetime | timestamptz | 35,6 | √ | null |
|
|
|||||||||||||||||||||||||||||||||||
| last_recorded_datetime | timestamptz | 35,6 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| test_id | Primary key | Asc | test_id |



