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