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 | Payment method identifier. | |
| code | varchar(20) | false | Payment method code: CASH, CREDIT_CARD, MPM_QR, etc. | |||
| name | varchar(100) | false | Payment method display name. | |||
| description | text | true | Payment method description. | |||
| is_active | boolean | true | true | Payment method 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_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