1CREATE TABLE persons ( 2 id int NOT NULL primary key, 3 name varchar(255) NOT NULL 4) 5unique hash on (id) pages=100; 6 7CREATE TABLE institutes ( 8 id int NOT NULL primary key, 9 name varchar(255) 10) 11unique hash on (id) pages=100; 12 13CREATE TABLE documents ( 14 id int NOT NULL primary key, 15 title varchar(255) NOT NULL, 16 abstract varchar(255) 17) 18unique hash on (id) pages=100; 19 20CREATE TABLE authors_docs ( 21 pers_id int NOT NULL, 22 doc_id int NOT NULL, 23 PRIMARY KEY 24 ( 25 pers_id, 26 doc_id 27 ) 28) unique hash on (pers_id, doc_id) pages=100; 29 30CREATE TABLE phones ( 31 id int NOT NULL primary key, 32 phone varchar(255) NOT NULL , 33 pers_id int NOT NULL 34) 35unique hash on (id) pages=100; 36 37