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 table institutes;
11
drop sequence institutes_id_seq;
12
create table institutes (
13
id serial not null primary key,
18
drop sequence documents_id_seq;
19
create table documents (
20
id serial not null primary key,
21
title varchar(255) not null,
25
drop table authors_docs;
26
create table authors_docs (
29
primary key ( pers_id, doc_id )
33
drop sequence phones_id_seq;
35
id serial not null primary key,
36
phone varchar(255) not null ,
41
drop sequence certs_id_seq;
43
id int not null primary key,
49
drop sequence referrals_id_seq;
50
create table referrals (
51
id serial not null primary key,
52
name varchar(255) not null,
53
url varchar(255) not null