public.payment_provider_methods

Description

Labels

svc-smarttab

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
id	integer	nextval('payment_provider_methods_id_seq'::regclass)	false	public.payments
payment_method_id	integer		false		public.payment_methods
payment_provider_id	integer		false		public.payment_providers
display_name	varchar(150)		false
is_active	boolean	true	true
sort_order	integer	0	true
config	jsonb		true
created_at	timestamp with time zone	now()	true
updated_at	timestamp with time zone	now()	true

Viewpoints

Name	Definition
Payment Configuration	Payment method and provider configuration

Constraints

Name	Type	Definition
payment_provider_methods_payment_method_id_fkey	FOREIGN KEY	FOREIGN KEY (payment_method_id) REFERENCES payment_methods(id) ON DELETE RESTRICT
payment_provider_methods_payment_provider_id_fkey	FOREIGN KEY	FOREIGN KEY (payment_provider_id) REFERENCES payment_providers(id) ON DELETE RESTRICT
payment_provider_methods_pkey	PRIMARY KEY	PRIMARY KEY (id)
uq_payment_provider_methods	UNIQUE	UNIQUE (payment_method_id, payment_provider_id)

Indexes

Name	Definition
payment_provider_methods_pkey	CREATE UNIQUE INDEX payment_provider_methods_pkey ON public.payment_provider_methods USING btree (id)
uq_payment_provider_methods	CREATE UNIQUE INDEX uq_payment_provider_methods ON public.payment_provider_methods USING btree (payment_method_id, payment_provider_id)

Relations

---

Generated by tbls