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)