public.settlements

Description

Labels

svc-smarttab

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
id	uuid		false	public.payments
merchant_id	integer		false		public.merchants
store_id	integer		false		public.stores
status	varchar(20)		false
opened_at	timestamp with time zone		false
closed_at	timestamp with time zone		true
total_sales_amount	numeric(12,2)	'0'::numeric	false
total_transaction_count	integer	0	false
total_refund_amount	numeric(12,2)	'0'::numeric	false
total_refund_count	integer	0	false
net_sales_amount	numeric(12,2)	'0'::numeric	false
payment_breakdown	jsonb		true
currency	varchar(3)	'JPY'::character varying	false

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