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 | Link identifier. | |
| payment_method_id | integer | false | public.payment_methods | Payment method ID. | ||
| payment_provider_id | integer | false | public.payment_providers | Payment provider ID. | ||
| display_name | varchar(150) | false | Display name for this method-provider combination. | |||
| is_active | boolean | true | true | Active status. | ||
| sort_order | integer | 0 | true | Display sort order. | ||
| config | jsonb | true | Provider-specific configuration (JSON). | |||
| created_at | timestamp with time zone | now() | true | Record creation timestamp. | ||
| updated_at | timestamp with time zone | now() | true | Record last update timestamp. |
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