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