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