public.settlements

Description

Labels

svc-smarttab

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
id	uuid		false	public.payments		Settlement identifier (UUID).
merchant_id	integer		false		public.merchants	Parent merchant ID.
store_id	integer		false		public.stores	Parent store ID.
status	varchar(20)		false			Settlement status: OPEN or CLOSED.
opened_at	timestamp with time zone		false			Settlement opened timestamp.
closed_at	timestamp with time zone		true			Settlement closed timestamp.
total_sales_amount	numeric(12,2)	'0'::numeric	false			Total sales amount.
total_transaction_count	integer	0	false			Total transaction count.
total_refund_amount	numeric(12,2)	'0'::numeric	false			Total refund amount.
total_refund_count	integer	0	false			Total refund count.
net_sales_amount	numeric(12,2)	'0'::numeric	false			Net sales amount.
payment_breakdown	jsonb		true			Payment breakdown by method (JSON).
currency	varchar(3)	'JPY'::character varying	false			Currency code.

Viewpoints

Name	Definition
Order & Billing	Order lifecycle — Orders → Bills → Payments → Settlements

Constraints

Name	Type	Definition
ck_settlements_status	CHECK	CHECK (((status)::text = ANY ((ARRAY['open'::character varying, 'closed'::character varying])::text[])))
settlements_merchant_id_fkey	FOREIGN KEY	FOREIGN KEY (merchant_id) REFERENCES merchants(id) ON DELETE RESTRICT
settlements_store_id_fkey	FOREIGN KEY	FOREIGN KEY (store_id) REFERENCES stores(id) ON DELETE RESTRICT
settlements_pkey	PRIMARY KEY	PRIMARY KEY (id)

Indexes

Name	Definition
settlements_pkey	CREATE UNIQUE INDEX settlements_pkey ON public.settlements USING btree (id)
ix_settlements_merchant_id	CREATE INDEX ix_settlements_merchant_id ON public.settlements USING btree (merchant_id)
ix_settlements_merchant_store_status	CREATE INDEX ix_settlements_merchant_store_status ON public.settlements USING btree (merchant_id, store_id, status)
ix_settlements_store_id	CREATE INDEX ix_settlements_store_id ON public.settlements USING btree (store_id)
ix_settlements_store_opened	CREATE INDEX ix_settlements_store_opened ON public.settlements USING btree (store_id, opened_at)

Relations

---

Generated by tbls