public.refunds

Description

Labels

svc-smarttab

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
id	uuid		false	public.slip_copies
payment_id	uuid		false		public.payments
idempotency_key	varchar(100)		false
amount	numeric(12,2)		false
reason	varchar(255)		false
staff_code	varchar(50)		false
status	varchar(50)		false
refunded_at	timestamp with time zone		true
created_at	timestamp with time zone	now()	false
card_arn	varchar(100)		true
metadata	jsonb		true
transaction_id	varchar(255)		true
caller_type	varchar(20)	'user'::character varying	false
caller_id	varchar(50)		true

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