1
Tables (28)
account
- account_id — VARCHAR(255) — Primary key — NOT NULL
- role_id — VARCHAR(255) — NOT NULL
- warehouse_id — VARCHAR(255)
- tenant_id — VARCHAR(255)
- seller_id — VARCHAR(255)
- account_name — VARCHAR(255)
- status — VARCHAR(50) — ACTIVE / INACTIVE / LOCKED / INVITED / INVITE_EXPIRED / TEMP_PASSWORD_ISSUED
- email — VARCHAR(255)
- worker_no — VARCHAR(255)
- phone_no — VARCHAR(255)
- invite_sent_at — VARCHAR(255)
- invite_expired_at — VARCHAR(255)
- last_login_at — VARCHAR(255)
- password_changed_at — VARCHAR(255)
- is_temporary_password — TINYINT(1)
- created_at — VARCHAR(255)
- updated_at — VARCHAR(255)
- created_by — VARCHAR(255)
- updated_by — VARCHAR(255)
allocated_inventory
- order_id — VARCHAR(255) — Foreign key → sales_order.order_id — NOT NULL
- sku_id — VARCHAR(255) — Foreign key → product.sku_id — NOT NULL
- location_id — VARCHAR(255) — Foreign key → location.location_id — NOT NULL
- quantity — INT
- created_at — VARCHAR(255)
- updated_at — VARCHAR(255)
- created_by — VARCHAR(255)
- updated_by — VARCHAR(255)
- allocated_at — VARCHAR(255)
- released_at — VARCHAR(255)
asn
- asn_id — VARCHAR(255) — Primary key — NOT NULL
- seller_id — VARCHAR(255) — NOT NULL
- warehouse_id — VARCHAR(255)
- expected_arrival_date — VARCHAR(255)
- status — VARCHAR(50) — REGISTERED / UNLOADING_ASSIGNED / ARRIVED / INSPECTING_PUTAWAY / STORED / CANCELED
- box_quantity — INT
- seller_memo — VARCHAR(255)
- created_at — VARCHAR(255)
- updated_at — VARCHAR(255)
- created_by — VARCHAR(255)
- updated_by — VARCHAR(255)
- arrived_at — VARCHAR(255)
- stored_at — VARCHAR(255)
asn_item
- asn_id — VARCHAR(255) — Foreign key → asn.asn_id — NOT NULL
- sku_id — VARCHAR(255) — Foreign key → product.sku_id — NOT NULL
- quantity — INT
- product_name_snapshot — VARCHAR(255)
- box_quantity — INT
- inspected_quantity — INT
- defective_quantity — INT
- defect_reason — VARCHAR(255)
- memo — VARCHAR(255)
- created_at — VARCHAR(255)
- updated_at — VARCHAR(255)
- created_by — VARCHAR(255)
- updated_by — VARCHAR(255)
bin
- bin_id — VARCHAR(255) — Primary key — NOT NULL
- rack_id — VARCHAR(255) — NOT NULL
- zone_id — VARCHAR(255) — 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)
inbound_expected
- asn_id — VARCHAR(255) — Foreign key → asn.asn_id — NOT NULL
- sku_id — VARCHAR(255) — Foreign key → product.sku_id — NOT NULL
- created_at — VARCHAR(255)
- updated_at — VARCHAR(255)
- created_by — VARCHAR(255)
- updated_by — VARCHAR(255)
- status_at — VARCHAR(255)
inspection_putaway
- asn_id — VARCHAR(255) — Foreign key → asn.asn_id — NOT NULL
- sku_id — VARCHAR(255) — Foreign key → product.sku_id — NOT NULL
- location_id — VARCHAR(255) — Foreign key → location.location_id — NOT NULL
- worker_account_id — VARCHAR(255)
- inspected_quantity — INT
- putaway_quantity — INT
- defective_quantity — INT
- defect_reason — VARCHAR(255)
- defect_photo_url — VARCHAR(255)
- created_at — VARCHAR(255)
- updated_at — VARCHAR(255)
- created_by — VARCHAR(255)
- updated_by — VARCHAR(255)
- started_at — VARCHAR(255)
- completed_at — VARCHAR(255)
- is_completed — TINYINT(1)
inventory
- location_id — VARCHAR(255) — Foreign key → location.location_id — NOT NULL
- sku_id — VARCHAR(255) — Foreign key → product.sku_id — NOT NULL
- last_asn_id — VARCHAR(255)
- quantity — INT
- inventory_type — VARCHAR(50) — AVAILABLE / DEFECTIVE / QUARANTINED
- created_at — VARCHAR(255)
- updated_at — VARCHAR(255)
- created_by — VARCHAR(255)
- updated_by — VARCHAR(255)
- received_at — VARCHAR(255)
- adjusted_at — VARCHAR(255)
location
- location_id — VARCHAR(255) — Primary key — NOT NULL
- worker_account_id — VARCHAR(255)
- bin_id — VARCHAR(255) — NOT NULL
- rack_id — VARCHAR(255) — NOT NULL
- zone_id — VARCHAR(255) — NOT NULL
- 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)
outbound_completed
- order_id — VARCHAR(255) — Foreign key → sales_order.order_id — NOT NULL
- sku_id — VARCHAR(255) — Foreign key → product.sku_id — NOT NULL
- location_id — VARCHAR(255) — Foreign key → location.location_id — NOT NULL
- confirmed_account_id — VARCHAR(255)
- created_at — VARCHAR(255)
- updated_at — VARCHAR(255)
- created_by — VARCHAR(255)
- updated_by — VARCHAR(255)
- completed_at — VARCHAR(255)
outbound_pending
- order_id — VARCHAR(255) — Foreign key → sales_order.order_id — NOT NULL
- sku_id — VARCHAR(255) — Foreign key → product.sku_id — NOT NULL
- location_id — VARCHAR(255) — Foreign key → location.location_id — NOT NULL
- created_quantity — VARCHAR(255)
- updated_quantity — VARCHAR(255)
- created_by — VARCHAR(255)
- updated_by — VARCHAR(255)
- pending_at — VARCHAR(255)
- invoice_issued_at — VARCHAR(255)
permission
- permission_id — VARCHAR(255) — Primary key — NOT NULL
- permission_name — VARCHAR(255)
- menu_name — VARCHAR(255)
- permission_description — VARCHAR(255)
- created_at — VARCHAR(255)
- updated_at — VARCHAR(255)
- created_by — VARCHAR(255)
- updated_by — VARCHAR(255)
picking_packing
- order_id — VARCHAR(255) — Foreign key → sales_order.order_id — NOT NULL
- sku_id — VARCHAR(255) — Foreign key → product.sku_id — NOT NULL
- location_id — VARCHAR(255) — Foreign key → location.location_id — NOT NULL
- worker_account_id — VARCHAR(255)
- picked_quantity — INT
- packed_quantity — INT
- created_at — VARCHAR(255)
- updated_at — VARCHAR(255)
- created_by — VARCHAR(255)
- updated_by — VARCHAR(255)
- started_at — VARCHAR(255)
- completed_at — VARCHAR(255)
- issue_note — VARCHAR(255)
product
- sku_id — VARCHAR(255) — Primary key — NOT NULL
- seller_id — VARCHAR(255) — NOT NULL
- product_name — VARCHAR(255)
- category_name — VARCHAR(255)
- sale_price_amt — INT
- cost_price_amt — INT
- weight_oz — INT
- width_in — INT
- depth_in — INT
- height_in — INT
- safety_stock_equantity — INT
- status — VARCHAR(50) — ACTIVE / INACTIVE
- created_at — VARCHAR(255)
- updated_at — VARCHAR(255)
- created_by — VARCHAR(255)
- updated_by — VARCHAR(255)
product_attachment
- attachment_url — VARCHAR(255) — Primary key — NOT NULL
- sku_id — VARCHAR(255) — Foreign key → product.sku_id — NOT NULL
- attachment_type — VARCHAR(50) — IMAGE / DOCUMENT
- is_primary — TINYINT(1)
- created_at — VARCHAR(255)
- updated_at — VARCHAR(255)
- created_by — VARCHAR(255)
- updated_by — VARCHAR(255)
- uploaded_at — VARCHAR(255)
rack
- rack_id — VARCHAR(255) — Primary key — NOT NULL
- zone_id — VARCHAR(255) — 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)
role
- role_id — VARCHAR(255) — Primary key — NOT NULL
- role_name — VARCHAR(255)
- role_description — VARCHAR(255)
- is_active — TINYINT(1)
- created_at — VARCHAR(255)
- updated_at — VARCHAR(255)
- created_by — VARCHAR(255)
- updated_by — VARCHAR(255)
role_permission
- role_id — VARCHAR(255) — Foreign key → role.role_id — NOT NULL
- permission_id — VARCHAR(255) — Foreign key → permission.permission_id — NOT NULL
- is_enabled — TINYINT(1)
- can_read — TINYINT(1)
- can_write — TINYINT(1)
- can_delete — TINYINT(1)
- created_at — VARCHAR(255)
- updated_at — VARCHAR(255)
- created_by — VARCHAR(255)
- updated_by — VARCHAR(255)
- changed_at — VARCHAR(255)
sales_order
- order_id — VARCHAR(255) — Primary key — NOT NULL
- invoice_no — VARCHAR(255)
- seller_id — VARCHAR(255) — NOT NULL
- warehouse_id — VARCHAR(255)
- assigned_account_id — VARCHAR(255)
- channel_order_no — VARCHAR(255)
- order_channel — VARCHAR(50) — AMAZON / MANUAL / EXCEL / SHOPIFY
- status — VARCHAR(100) — RECEIVED / ALLOCATED / OUTBOUND_INSTRUCTED / PICKING_PACKING / OUTBOUND_PENDING / OUTBOUND_COMPLETED / CANCELED
- ordered_at — VARCHAR(255)
- created_at — VARCHAR(255)
- updated_at — VARCHAR(255)
- created_by — VARCHAR(255)
- updated_by — VARCHAR(255)
- receiver_name — VARCHAR(255)
- receiver_phone_no — VARCHAR(255)
- ship_to_address1 — VARCHAR(255)
- ship_to_address2 — VARCHAR(255)
- ship_to_state — VARCHAR(255)
- ship_to_city — VARCHAR(255)
- ship_to_zip_code — VARCHAR(255)
- shipped_at — VARCHAR(255)
sales_order_item
- order_id — VARCHAR(255) — Foreign key → sales_order.order_id — NOT NULL
- sku_id — VARCHAR(255) — Foreign key → product.sku_id — NOT NULL
- quantity — INT
- created_at — VARCHAR(255)
- updated_at — VARCHAR(255)
- created_by — VARCHAR(255)
- updated_by — VARCHAR(255)
- product_name_snapshot — VARCHAR(255)
- picked_quantity — INT
- packed_quantity — INT
seller
- seller_id — VARCHAR(255) — Primary key — NOT NULL
- tenant_id — VARCHAR(255)
- seller_info — VARCHAR(255)
- seller_name — VARCHAR(255)
- representative_name — VARCHAR(255)
- business_no — VARCHAR(255)
- phone_no — VARCHAR(255)
- email — VARCHAR(255)
- category_name — VARCHAR(255)
- status — VARCHAR(50) — ACTIVE / INACTIVE
- created_at — VARCHAR(255)
- updated_at — VARCHAR(255)
- created_by — VARCHAR(255)
- updated_by — VARCHAR(255)
seller_warehouse
- seller_id — VARCHAR(255) — Foreign key → seller.seller_id — NOT NULL
- warehouse_id — VARCHAR(255) — Foreign key → warehouse.warehouse_id — NOT NULL
- is_default — TINYINT(1)
- created_at — VARCHAR(255)
- updated_at — VARCHAR(255)
- created_by — VARCHAR(255)
- updated_by — VARCHAR(255)
shipment_invoice
- invoice_no — VARCHAR(255) — Primary key — NOT NULL
- carrier_type — VARCHAR(50) — USPS / UPS / FEDEX
- freight_charge_amt — INT
- ship_to_address — VARCHAR(255)
- tracking_url — VARCHAR(255)
- label_file_url — VARCHAR(255)
- created_at — VARCHAR(255)
- updated_at — VARCHAR(255)
- created_by — VARCHAR(255)
- updated_by — VARCHAR(255)
- issued_at — VARCHAR(255)
- handover_at — VARCHAR(255)
tenant
- tenant_id — VARCHAR(255) — Primary key — NOT NULL
- tenant_name — VARCHAR(255)
- representative_name — VARCHAR(255)
- business_no — VARCHAR(255)
- phone_no — VARCHAR(255)
- email — VARCHAR(255)
- address — VARCHAR(255)
- tenant_type — VARCHAR(50)
- status — VARCHAR(50) — SETTING / ACTIVE / INACTIVE
- created_at — VARCHAR(255)
- updated_at — VARCHAR(255)
- created_by — VARCHAR(255)
- updated_by — VARCHAR(255)
- activated_at — VARCHAR(255)
warehouse
- warehouse_id — VARCHAR(255) — Primary key — 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)
work_assignment
- work_id — VARCHAR(255) — Foreign key → work_detail.work_id — NOT NULL
- account_id — VARCHAR(255) — Foreign key → account.account_id — NOT NULL
- assigned_by_account_id — VARCHAR(255)
- is_completed — TINYINT(1)
- created_at — VARCHAR(255)
- updated_at — VARCHAR(255)
- created_by — VARCHAR(255)
- updated_by — VARCHAR(255)
- assigned_at — VARCHAR(255)
work_detail
- work_id — VARCHAR(255) — Primary key — NOT NULL
- location_id — VARCHAR(255)
- asn_id — VARCHAR(255)
- order_id — VARCHAR(255)
- sku_id — VARCHAR(255)
- status — VARCHAR(50) — READY / IN_PROGRESS / COMPLETED / CANCELED
- reference_type — VARCHAR(50) — ASN / ORDER
- quantity — INT
- work_type — VARCHAR(255)
- created_at — VARCHAR(255)
- updated_at — VARCHAR(255)
- created_by — VARCHAR(255)
- updated_by — VARCHAR(255)
- started_at — VARCHAR(255)
- completed_at — VARCHAR(255)
- issue_note — VARCHAR(255)
zone
- zone_id — VARCHAR(255) — Primary key — NOT NULL
- warehouse_id — VARCHAR(255) — NOT NULL
- zone_name — VARCHAR(255)
- zone_purpose — VARCHAR(50) — GENERAL / QUARANTINE / STAGING
- sort_no — INT
- is_active — TINYINT(1)
- created_at — VARCHAR(255)
- updated_at — VARCHAR(255)
- created_by — VARCHAR(255)
- updated_by — VARCHAR(255)