GMS_Peaking_Analysis

Tables (5)

batch_shipping_orders

  • id — int — Primary key
  • batch_id — bigint — Foreign key → batches.id
  • seq — int
  • shippingorder_id — bigint

batches

  • id — bigint — Primary key
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • deleted_at — datetime(6)
  • serial_no — varchar(20) — NOT NULL
  • status — varchar(20)
  • manager — int
  • created_user_id — bigint
  • updated_user_id — bigint
  • batch_end_at — datetime(6)
  • batch_start_at — datetime(6)
  • warehouse_id — bigint
  • type — varchar(20)

picks

  • id — int — Primary key
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • picking_qty — bigint
  • created_user_id — bigint
  • inventory_lpn_id — bigint
  • shipping_order_id — bigint
  • shipping_order_item_id — bigint
  • updated_user_id — bigint
  • id (id2) — bigint — Foreign key → shipping_order_items.id

shipping_order_items (shipping_order_items_01)

  • id — bigint — Primary key
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • deleted_at — datetime(6)
  • sell_id — bigint — NOT NULL
  • goods_seq — varchar(50)
  • goods_nm — varchar(500)
  • qty — bigint
  • status — varchar(20)
  • created_user_id — bigint
  • shipping_order_id — bigint
  • updated_user_id — bigint
  • note — longtext
  • goods_id — bigint
  • picking_qty — bigint

shipping_orders

  • id — bigint — Primary key
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • deleted_at — datetime(6)
  • delivery_id — bigint — NOT NULL
  • delivery_seq — varchar(50)
  • status — varchar(20)
  • created_user_id — bigint
  • updated_user_id — bigint
  • transfer_code — varchar(20)
  • bin_id — bigint
  • warehouse_id — bigint