public.payment_providers

Description

Labels

svc-smarttab

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
id	integer	nextval('payment_providers_id_seq'::regclass)	false	public.payment_provider_methods		Payment provider identifier.
provider_code	varchar(50)		false			Provider code for integration.
provider_name	varchar(100)		false			Provider display name.
is_active	boolean	true	true			Provider active status.
sort_order	integer	0	true			Display sort order.
created_at	timestamp with time zone	now()	true			Record creation timestamp.

Viewpoints

Name	Definition
Payment Configuration	Payment method and provider configuration

Constraints

Name	Type	Definition
payment_providers_pkey	PRIMARY KEY	PRIMARY KEY (id)
payment_providers_provider_code_key	UNIQUE	UNIQUE (provider_code)

Indexes

Name	Definition
payment_providers_pkey	CREATE UNIQUE INDEX payment_providers_pkey ON public.payment_providers USING btree (id)
payment_providers_provider_code_key	CREATE UNIQUE INDEX payment_providers_provider_code_key ON public.payment_providers USING btree (provider_code)

Relations

---

Generated by tbls