Tables


SchemaSpy Analysis of battdb.public

Generated on Thu Feb 29 20:56 GMT 2024

XML Representation
Insertion Order Deletion Order
TABLES 30
VIEWS 22
COLUMNS 589
Constraints 29
Anomalies 2
Routines 0

Database Properties

Database Type: PostgreSQL - 15.5

Schema public

standard public schema

Tables

Table / View Children Parents Columns Rows Type Comments
cyclers_meta 1 0 9 -1 Table

Stores information for types of cycler.

flyway_schema_history 0 0 10 -1 Table

Schema history table

test_data 0 1 12 -1 Table

Stores test data for tests performed on single cells.

eis_meta 0 0 15 -1 Table

Stores high-level information about the potentiostat test.

modules_test_meta 2 3 11 -1 Table

Stores high-level information about tests performed using modules.

cells_meta 6 0 8 -1 Table

Stores information for types of cells.

cycler_rt_channel_statuses 0 1 17 -1 Table

Stores real-time information for cycler channels.

test_meta 11 4 18 -1 Table

Contains high-level information about tests on single cells.

schedule_meta 3 0 9 -1 Table

Stores high-level information about schedule files.

hil_meta 5 1 9 -1 Table

Stores high-level information about the hardware-in-the-loop test.

customers 1 0 2 -1 Table

Tracks customers.

modules 1 1 7 -1 Table

Stores information for module instances.

models_meta 1 1 6 -1 Table

Stores information for types of models.

profiles_meta 0 1 5 -1 Table

Stores information about charge profiles used in schedules.

test_data_cycle_stats 0 1 25 -1 Table

Stores summary statistics for each cycle for tests performed on single cells.

sil_meta 5 2 8 -1 Table

Stores high-level information about software-in-the-loop tests.

sim_data 0 1 16 -1 Table

Stores model outputs and test data from simulation testing.

sil_data 0 1 16 -1 Table

Stores model outputs and test data from software-in-the-loop testing.

cells 3 1 11 -1 Table

Stores information for cell instances.

sim_meta 5 2 8 -1 Table

Stores high-level information about simulation tests.

projects 2 1 3 -1 Table

Tracks projects associated with a customer.

potentiostats 0 1 5 -1 Table

Stores information about potentiostat instance.

potentiostats_meta 1 0 4 -1 Table

Stores information about type of potentiostat.

modules_test_data 0 1 25 -1 Table

Stores test data for tests performed using modules.

eis_data 0 1 13 -1 Table

Stores potentiostat test data.

cyclers 6 1 6 -1 Table

Stores information for cycler instances.

models 0 1 9 -1 Table

Stores information for model instances.

hil_data 0 1 24 -1 Table

Stores test data from hardware-in-the-loop test.

modules_meta 1 1 8 -1 Table

Stores information about types of module.

modules_test_data_cycle_stats 0 1 25 -1 Table

Stores summary statistics for each cycle of a test performed using modules.

cycler_rt_channel_statuses_summary_daily 0 1 9 0 View
hil_data_summary_daily 0 1 14 0 View
sil_data_summary_hourly 0 1 9 0 View
sim_data_summary_10min 0 1 9 0 View
sim_data_summary_30s 0 1 9 0 View
pg_stat_statements 0 0 43 0 View
sil_data_summary_10min 0 1 9 0 View
test_data_summary_daily 0 0 9 0 View
sim_data_summary_hourly 0 1 9 0 View
pg_stat_statements_info 0 0 2 0 View
sil_data_summary_daily 0 1 9 0 View
sim_data_summary_daily 0 1 9 0 View
sil_data_summary_30s 0 1 9 0 View
cycler_rt_channel_statuses_summary_10min 0 1 9 0 View
hil_data_summary_10min 0 1 14 0 View
cycler_rt_channel_statuses_summary_30s 0 1 9 0 View
test_data_summary_hourly 0 0 9 0 View
hil_data_summary_30s 0 1 14 0 View
cycler_rt_channel_statuses_summary_hourly 0 1 9 0 View
test_data_summary_30s 0 0 9 0 View
test_data_summary_10min 0 0 9 0 View
hil_data_summary_hourly 0 1 14 0 View