public.payment_methods
Description
Labels
svc-smarttab
Columns
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| id | integer | nextval('payment_methods_id_seq'::regclass) | false | public.payment_provider_methods | ||
| code | varchar(20) | false | ||||
| name | varchar(100) | false | ||||
| description | text | true | ||||
| 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_methods_pkey | PRIMARY KEY | PRIMARY KEY (id) |
| payment_methods_code_key | UNIQUE | UNIQUE (code) |
Indexes
| Name | Definition |
|---|---|
| payment_methods_pkey | CREATE UNIQUE INDEX payment_methods_pkey ON public.payment_methods USING btree (id) |
| payment_methods_code_key | CREATE UNIQUE INDEX payment_methods_code_key ON public.payment_methods USING btree (code) |
Relations
Generated by tbls