public.psps
Description
Labels
svc-portal
Columns
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| id | integer | nextval('psps_id_seq'::regclass) | false | public.merchants | ||
| psp_code | varchar(50) | false | ||||
| psp_name | varchar(255) | false | ||||
| contact_email | varchar(255) | true | ||||
| contact_phone | varchar(20) | true | ||||
| status | varchar(50) | true | ||||
| created_at | timestamp with time zone | true | ||||
| updated_at | timestamp with time zone | true | ||||
| payment_config | json | true | ||||
| pic_name | varchar(255) | true | ||||
| pic_email | varchar(255) | true | ||||
| pic_phone | varchar(20) | true | ||||
| shipping_timing_policy | varchar(20) | true | ||||
| exception_shipping_dates | json | true |
Viewpoints
| Name | Definition |
|---|---|
| Merchant Hierarchy | Multi-tenant hierarchy — PSP → Merchant → Store → Staff/Devices |
Constraints
| Name | Type | Definition |
|---|---|---|
| psps_pkey | PRIMARY KEY | PRIMARY KEY (id) |
Indexes
| Name | Definition |
|---|---|
| psps_pkey | CREATE UNIQUE INDEX psps_pkey ON public.psps USING btree (id) |
| ix_psps_psp_code | CREATE UNIQUE INDEX ix_psps_psp_code ON public.psps USING btree (psp_code) |
Relations
Generated by tbls