goods

Tables (9)

inbound

  • inbound_id — BIGINT
  • inbound_number — VARCHAR(100) — NOT NULL
  • warehouse_id — BIGINT — Foreign key → warehouse.warehouse_id — NOT NULL
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • supplier_name — VARCHAR(150) — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • requested_at — DATETIME — NOT NULL
  • completed_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

inbound_line

  • inbound_line_id — BIGINT
  • inbound_id — BIGINT — Foreign key → inbound.inbound_id — NOT NULL
  • product_id — BIGINT — Foreign key → product.product_id — NOT NULL
  • zone_id — BIGINT — Foreign key → warehouse_zone.zone_id — NOT NULL
  • expected_quantity — INT — NOT NULL
  • received_quantity — INT — NOT NULL
  • normal_quantity — INT — NOT NULL
  • damaged_quantity — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

inventory

  • inventory_id — BIGINT
  • zone_id — BIGINT — Foreign key → warehouse_zone.zone_id — NOT NULL
  • product_id — BIGINT — Foreign key → product.product_id — NOT NULL
  • normal_quantity — INT — NOT NULL
  • damaged_quantity — INT — NOT NULL
  • reserved_quantity — INT — NOT NULL
  • updated_at — DATETIME — NOT NULL

member

  • member_id — BIGINT
  • name — VARCHAR(100) — NOT NULL
  • email — VARCHAR(150) — NOT NULL
  • phone_number — VARCHAR(30)
  • department — VARCHAR(100)
  • role — VARCHAR(50) — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

outbound

  • outbound_id — BIGINT
  • outbound_number — VARCHAR(100) — NOT NULL
  • warehouse_id — BIGINT — Foreign key → warehouse.warehouse_id — NOT NULL
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • destination_name — VARCHAR(150) — NOT NULL
  • purpose — VARCHAR(50) — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • requested_at — DATETIME — NOT NULL
  • completed_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

outbound_line

  • outbound_line_id — BIGINT
  • outbound_id — BIGINT — Foreign key → outbound.outbound_id — NOT NULL
  • product_id — BIGINT — Foreign key → product.product_id — NOT NULL
  • zone_id — BIGINT — Foreign key → warehouse_zone.zone_id — NOT NULL
  • requested_quantity — INT — NOT NULL
  • confirmed_quantity — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

product

  • product_id — BIGINT
  • sku — VARCHAR(100) — NOT NULL
  • name — VARCHAR(150) — NOT NULL
  • character_name — VARCHAR(100)
  • series_name — VARCHAR(100)
  • limited_edition — BOOLEAN — NOT NULL
  • edition_label — VARCHAR(100)
  • product_status — VARCHAR(30) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

warehouse

  • warehouse_id — BIGINT
  • warehouse_code — VARCHAR(50) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • address — VARCHAR(255)
  • type — VARCHAR(50) — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

warehouse_zone

  • zone_id — BIGINT
  • warehouse_id — BIGINT — Foreign key → warehouse.warehouse_id — NOT NULL
  • zone_code — VARCHAR(50) — NOT NULL
  • zone_name — VARCHAR(100) — NOT NULL
  • zone_type — VARCHAR(50) — NOT NULL
  • active — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL