scm_test
Tables (5)
inventory
- Key (inventory_uid) — INT — Primary key — NOT NULL
- quantity — INT — NOT NULL
- Key (warehouse_uid) — INT — Foreign key → warehouse.Key — NOT NULL
- Key (product_uid) — INT — Foreign key → product.Key — NOT NULL
- Key (market_uid) — INT — Foreign key → market.Key — NOT NULL
inventory_movement
- Key (movement_uid) — INT — Primary key — NOT NULL
- source_warehouse_id — INT
- destination_warehouse_id — INT
- quantity — INT — NOT NULL
- movement_type — VARCHAR(50) — NOT NULL
- movement_date — TIMESTAMP
- Key (product_uid) — INT — Foreign key → product.Key — NOT NULL
- Key (src_market_uid) — INT — Foreign key → market.Key — NOT NULL
- Key (dest_market_uid) — INT — Foreign key → market.Key — NOT NULL
- Key (src_warehouse_uid) — INT — Foreign key → warehouse.Key — NOT NULL
- Key (dest_warehouse_uid) — INT — Foreign key → warehouse.Key — NOT NULL
market
- Key (market_uid) — INT — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
- location — VARCHAR(255) — NOT NULL
product
- Key (product_uid) — INT — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
- description — TEXT
- price — DECIMAL(10, 2) — NOT NULL
warehouse
- Key (warehouse_uid) — INT — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
- location — VARCHAR(255) — NOT NULL