mirror of
https://github.com/hanzo-fi/payments.git
synced 2026-10-30 20:31:20 +00:00
Paul NicolasandGitHub
979b040d94
* chore(storage): remove errors.Wrap deprecated * feat: add psu models * feat(storage): add psu migrations and functions * feat(*): add payment service users entity * feat(tests): update sdks and add psu integration tests * feat(validation): add validation on email and phone number
37 lines
877 B
SQL
37 lines
877 B
SQL
-- payment service users
|
|
create table if not exists payment_service_users (
|
|
-- Autoincrement fields
|
|
sort_id bigserial not null,
|
|
|
|
-- Mandatory fields
|
|
id uuid not null,
|
|
created_at timestamp without time zone not null,
|
|
|
|
-- Encrypted fields
|
|
name bytea,
|
|
street_name bytea,
|
|
street_number bytea,
|
|
postal_code bytea,
|
|
city bytea,
|
|
region bytea,
|
|
country bytea,
|
|
email bytea,
|
|
phone_number bytea,
|
|
|
|
-- Optional fields with default
|
|
metadata jsonb not null default '{}'::jsonb,
|
|
|
|
-- Primary key
|
|
primary key (id)
|
|
);
|
|
|
|
create index psu_created_at_sort_id on payment_service_users (created_at, sort_id);
|
|
|
|
alter table bank_accounts
|
|
add column if not exists psu_id uuid;
|
|
|
|
alter table bank_accounts
|
|
add constraint fk_psu_id
|
|
foreign key (psu_id)
|
|
references payment_service_users (id)
|
|
on delete set null; |