public.refunds

Description

Labels

svc-smarttab

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
id	uuid		false	public.slip_copies		Refund identifier (UUID).
payment_id	uuid		false		public.payments	Original payment ID.
idempotency_key	varchar(100)		false			Idempotency key for duplicate prevention.
amount	numeric(12,2)		false			Refund amount.
reason	varchar(255)		false			Refund reason.
staff_code	varchar(50)		false			Staff code who processed refund.
status	varchar(50)		false			Refund status: PENDING, SUCCESS, FAILED.
refunded_at	timestamp with time zone		true			Refund processed timestamp.
created_at	timestamp with time zone	now()	false			Record creation timestamp.
card_arn	varchar(100)		true			Acquirer Reference Number from refund response.
metadata	jsonb		true			Refund metadata (JSON).
transaction_id	varchar(255)		true			Provider transaction ID.
caller_type	varchar(20)	'user'::character varying	false			Caller type: user or device.
caller_id	varchar(50)		true			Caller identifier.

Viewpoints

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

Constraints

Name	Type	Definition
refunds_amount_check	CHECK	CHECK ((amount > (0)::numeric))
refunds_payment_id_fkey	FOREIGN KEY	FOREIGN KEY (payment_id) REFERENCES payments(id) ON DELETE RESTRICT
refunds_pkey	PRIMARY KEY	PRIMARY KEY (id)

Indexes

Name	Definition
refunds_pkey	CREATE UNIQUE INDEX refunds_pkey ON public.refunds USING btree (id)
ix_refunds_idempotency_key	CREATE UNIQUE INDEX ix_refunds_idempotency_key ON public.refunds USING btree (idempotency_key)
ix_refunds_payment_id	CREATE INDEX ix_refunds_payment_id ON public.refunds USING btree (payment_id)
ix_refunds_status	CREATE INDEX ix_refunds_status ON public.refunds USING btree (status)

Relations

---

Generated by tbls