Tables


SchemaSpy Analysis of grid.db

Generated on Mon Oct 18 07:55 UTC 2021

XML Representation
Insertion Order Deletion Order
TABLES 33
VIEWS 2
COLUMNS 321
Constraints 1
Anomalies 1
Routines 0

Database Properties

Database Type: SQLite - 3.31.1

Tables

Table / View Children Parents Columns Rows Type Comments
location 0 0 9 0 Table
product_property_value 0 0 16 0 Table
pike_organization_alternate_id 0 0 7 0 Table
record 0 0 9 0 Table
pike_role 0 0 10 0 Table
__diesel_schema_migrations 1 0 2 6 Table
proposal 0 0 12 0 Table
commits 0 0 4 0 Table
batches 1 0 12 0 Table
pike_role_state_address_assoc 0 0 7 0 Table
transactions 0 2 5 0 Table
reporter 0 0 9 0 Table
grid_schema 0 0 8 0 Table
associated_agent 0 0 8 0 Table
location_attribute 0 0 16 0 Table
pike_allowed_orgs 0 0 7 0 Table
pike_organization_metadata 0 0 7 0 Table
product 0 0 9 0 Table
grid_property_definition 0 0 12 0 Table
reported_value 0 0 17 0 Table
pike_organization 0 0 8 0 Table
purchase_order_alternate_id 0 0 8 0 Table
property 0 0 9 0 Table
pike_agent_role_assoc 0 0 7 0 Table
transaction_receipts 0 0 8 0 Table
pike_organization_location_assoc 0 0 6 0 Table
purchase_order_version 0 0 9 0 Table
chain_record 0 0 4 0 Table
purchase_order 0 0 12 0 Table
pike_agent 0 0 10 0 Table
pike_permissions 0 0 7 0 Table
pike_inherit_from 0 0 8 0 Table
purchase_order_version_revision 0 0 10 0 Table
reported_value_reporter_to_agent_metadata 0 0 20 0 View
reporter_to_agent_metadata 0 0 9 0 View