H6ANx5Pe

1
2create table account (
3    id int8 generated by default as identity,
4    type int8 not null,
5    lead_id int8 not null,
6    primary key (id)
7                     );
8create table lead (
9    id int8 generated by default as identity,
10    dateof_birth timestamp, email varchar(255),
11    first_name varchar(255), gender boolean not null,
12    last_name varchar(255),
13    login varchar(255),
14    middle_name varchar(255),
15    password varchar(255),
16    phone_number varchar(255),
17    primary key (id)
18                  );
19create table subscription_type (
20    id int8 generated by default as identity,
21    title varchar(255),
22    primary key (id)
23                               );
24
25alter table if exists account add constraint FKdla8jxchbmuf5yxyyp39ygf58 foreign key (type) references subscription_type;
26
27alter table if exists account add constraint FKgva8br7vnn3jjug9oeygf6bgx foreign key (lead_id) references lead;
28
29
30