1
Tables (5)
bin
- bin_id — VARCHAR(255) — Primary key — NOT NULL
- warehouse_id — VARCHAR(255) — NOT NULL
- status — VARCHAR(50) — EMPTY / AVAILABLE / IN_USE / FULL / INACTIVE
- capacity_quantity — INT
- max_volume_cbft — INT
- is_active — TINYINT(1)
- created_at — VARCHAR(255)
- updated_at — VARCHAR(255)
- created_by — VARCHAR(255)
- updated_by — VARCHAR(255)
location
- location_id — VARCHAR(255) — Primary key — NOT NULL
- worker_account_id — VARCHAR(255)
- warehouse_id — VARCHAR(255) — NOT NULL
- current_sku_id — VARCHAR(255)
- status — VARCHAR(50) — AVAILABLE / IN_USE / FULL / INACTIVE
- capacity_quantity — INT
- max_volume_cbft — INT
- is_active — TINYINT(1)
- created_at — VARCHAR(255)
- updated_at — VARCHAR(255)
- created_by — VARCHAR(255)
- updated_by — VARCHAR(255)
rack
- rack_id — VARCHAR(255) — Primary key — NOT NULL
- warehouse_id — VARCHAR(255) — NOT NULL
- sort_no — INT
- is_active — TINYINT(1)
- created_at — VARCHAR(255)
- updated_at — VARCHAR(255)
- created_by — VARCHAR(255)
- updated_by — VARCHAR(255)
warehouse
- warehouse_id — VARCHAR(255) — Primary key — NOT NULL
- location_id — VARCHAR(255) — Foreign key → location.location_id — NOT NULL
- tenant_id — VARCHAR(255) — NOT NULL
- warehouse_name — VARCHAR(255)
- address — VARCHAR(255)
- state_name — VARCHAR(255)
- city_name — VARCHAR(255)
- zip_code — VARCHAR(255)
- operation_start_at — VARCHAR(255)
- operation_end_at — VARCHAR(255)
- phone_no — VARCHAR(255)
- area_sqft — INT
- status — VARCHAR(50) — ACTIVE / INACTIVE
- created_at — VARCHAR(255)
- updated_at — VARCHAR(255)
- created_by — VARCHAR(255)
- updated_by — VARCHAR(255)
zone
- zone_id — VARCHAR(255) — Primary key — NOT NULL
- warehouse_id — VARCHAR(255) — NOT NULL
- zone_purpose — VARCHAR(50) — GENERAL / QUARANTINE / STAGING
- sort_no — INT
- is_active — TINYINT(1)
- created_at — DATETIME
- updated_at — VARCHAR(255)
- created_by — VARCHAR(255)
- updated_by — VARCHAR(255)