Tables


SchemaSpy Analysis of open_lmis

Generated on Mon Jan 04 10:59 GMT 2021

XML Representation
Insertion Order Deletion Order
TABLES 21
VIEWS 0
COLUMNS 118
Constraints 22
Anomalies 1
Routines 0

Database Properties

Database Type: PostgreSQL - 9.6.12

Tables

Table / View Children Parents Columns Type Comments
available_stock_card_fields 1 0 2 Table
physical_inventories 1 1 8 Table
nodes 4 0 3 Table
stock_card_line_item_fields 0 2 5 Table
stock_event_line_items 1 1 13 Table
stock_card_templates 2 0 3 Table
physical_inventory_line_item_adjustments 0 4 6 Table
calculated_stocks_on_hand 0 1 5 Table
stock_card_line_item_reasons 4 0 6 Table
jasper_templates 0 0 5 Table
stock_cards 2 1 6 Table
valid_destination_assignments 0 1 5 Table
valid_source_assignments 0 1 5 Table
available_stock_card_line_item_fields 1 0 2 Table
organizations 0 0 2 Table
valid_reason_assignments 0 1 5 Table
stock_card_line_item_reason_tags 0 1 2 Table
stock_card_fields 0 2 5 Table
stock_events 4 0 7 Table
stock_card_line_items 1 5 16 Table
physical_inventory_line_items 1 1 7 Table