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