Tables


SchemaSpy Analysis of open_lmis

Generated on Mon Jan 18 14:14 GMT 2021

XML Representation
Insertion Order Deletion Order
TABLES 17
VIEWS 0
COLUMNS 119
Constraints 10
Anomalies 0
Routines 0

Database Properties

Database Type: PostgreSQL - 9.6.12

Tables

Table / View Children Parents Columns Type Comments
proofs_of_delivery 1 1 6 Table
proof_of_delivery_line_items 0 1 11 Table
shipment_drafts 1 1 3 Table
order_number_configurations 0 0 5 Table
shipment_draft_line_items 0 1 6 Table
order_line_items 0 1 5 Table
transfer_properties 0 0 13 Table
file_templates 1 0 4 Table
status_messages 0 1 5 Table
templates 1 0 5 Table
configuration_settings 0 0 2 Table
status_changes 0 0 5 Table
shipment_line_items 0 1 7 Table
template_parameters 0 1 8 Table
shipments 2 1 6 Table
orders 4 0 16 Table
file_columns 0 1 12 Table