org.order_channels

Sales channel classification (e.g., DIRECT, SPS). Required on every sales order.

Columns

Column	Type	Notes
id	UUID PK
org_id	UUID FK	→ platform.organizations(id).
name	VARCHAR(100)	UNIQUE per (org_id, name).
sort_order	SMALLINT	CHECK >= 0. UNIQUE per (org_id, sort_order) — DEFERRABLE INITIALLY IMMEDIATE for reorders.
is_active	BOOL	NOT NULL. Default true.
created_at	TIMESTAMPTZ	NOT NULL. Default NOW().
updated_at	TIMESTAMPTZ	NOT NULL. Default NOW(). Auto-updated by trigger.

Cross-references

Referenced by sales orders via sales_orders.order_channel_id (RESTRICT).