bazzar/crates/idp/migrations/202204131842_addresses.sql
2024-06-26 11:12:06 +02:00

14 lines
516 B
SQL

CREATE TABLE public.account_addresses
(
id serial NOT NULL,
name text NOT NULL,
email text NOT NULL,
street text NOT NULL,
city text NOT NULL,
country text NOT NULL,
zip text NOT NULL,
account_id integer,
is_default boolean DEFAULT false NOT NULL,
phone text DEFAULT ''::text NOT NULL
);