2 id int NOT NULL primary key,
3 name varchar(255) NOT NULL,
7 organization varchar(255)
9 unique hash on (id) pages=100;
10 create index personsx1 on persons(title_U);
11 create index personsx2 on persons(name_u);
13 CREATE TABLE institutes (
14 id int NOT NULL primary key,
17 unique hash on (id) pages=100;
19 CREATE TABLE documents (
20 id int NOT NULL primary key,
21 title varchar(255) NOT NULL,
24 unique hash on (id) pages=100;
26 CREATE TABLE authors_docs (
34 ) unique hash on (pers_id, doc_id) pages=100;
37 id int NOT NULL primary key,
38 phone varchar(255) NOT NULL ,
41 unique hash on (id) pages=100;