2 drop sequence persons_id_seq;
4 id serial not null primary key,
5 name varchar(255) not null,
6 surname varchar(255) not null
10 drop sequence institutes_id_seq;
11 create table institutes (
12 id serial not null primary key,
17 drop sequence documents_id_seq;
18 create table documents (
19 id serial not null primary key,
20 title varchar(255) not null,
24 drop table authors_docs;
25 create table authors_docs (
28 primary key ( pers_id, doc_id )
32 drop sequence phones_id_seq;
34 id serial not null primary key,
35 phone varchar(255) not null ,