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
provider_code	varchar(50)		false
provider_name	varchar(100)		false
is_active	boolean	true	true
sort_order	integer	0	true
created_at	timestamp with time zone	now()	true

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