offtoinventory
Tables (10)
inventory_low_stock_notification_configuration
- source_code — varchar(255) — Primary key — NOT NULL
- sku — varchar(64) — Primary key — NOT NULL
- notify_stock_qty — decimal(12,4)
inventory_reservation
- reservation_id — int(10) — Primary key — NOT NULL
- stock_id — int(10) — NOT NULL
- sku — varchar(64) — NOT NULL
- quantity — decimal(10,4) — NOT NULL
- metadata — varchar(255)
inventory_shipment_source
- shipment_id — int(10) — Primary key — NOT NULL
- source_code — varchar(255) — NOT NULL
inventory_source
- source_code — varchar(255) — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- enabled — smallint(5) — NOT NULL
- description — text
- latitude — decimal(8,6)
- longitude — decimal(9,6)
- country_id — varchar(2) — NOT NULL
- region_id — int(10)
- region — varchar(255)
- city — varchar(255)
- street — varchar(255)
- postcode — varchar(255) — NOT NULL
- contact_name — varchar(255)
- email — varchar(255)
- phone — varchar(255)
- fax — varchar(255)
- use_default_carrier_config — smallint(5) — NOT NULL
inventory_source_carrier_link
- link_id — int(10) — Primary key — NOT NULL
- source_code — varchar(255) — Foreign key → inventory_source.source_code — NOT NULL
- carrier_code — varchar(255) — NOT NULL
- position — smallint(5)
inventory_source_item
- source_item_id — int(10) — Primary key — NOT NULL
- source_code — varchar(255) — Foreign key → inventory_source.source_code — NOT NULL
- sku — varchar(64) — NOT NULL
- quantity — decimal(12,4) — NOT NULL
- status — smallint(5) — NOT NULL
inventory_source_stock_link
- link_id — int(10) — Primary key — NOT NULL
- stock_id — int(10) — Foreign key → inventory_stock.stock_id — NOT NULL
- source_code — varchar(255) — NOT NULL
- priority — smallint(5) — NOT NULL
inventory_stock
- stock_id — int(10) — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
inventory_stock_1
- product_id — int(10)
- website_id — smallint(5)
- stock_id — smallint(5)
- quantity — decimal(12,4)
- is_salable — smallint(5)
- sku — varchar(64)
inventory_stock_sales_channel
- type — varchar(64) — Primary key — NOT NULL
- code — varchar(64) — Primary key — NOT NULL
- stock_id — int(10) — Foreign key → inventory_stock.stock_id — NOT NULL