1CREATE TABLE persons ( 2 id NUMBER NOT NULL, 3 name varchar2(255) NOT NULL, 4 surname varchar2(255) NOT NULL, 5 password varchar2(64) NOT NULL 6); 7 8CREATE TABLE institutes ( 9 id NUMBER NOT NULL, 10 name varchar2(255) 11); 12 13CREATE TABLE documents ( 14 id NUMBER NOT NULL, 15 title varchar2(255) NOT NULL, 16 abstract varchar2(255) 17); 18 19CREATE TABLE authors_docs ( 20 pers_id NUMBER NOT NULL, 21 doc_id NUMBER NOT NULL 22); 23 24CREATE TABLE phones ( 25 id NUMBER NOT NULL , 26 phone varchar2(255) NOT NULL , 27 pers_id NUMBER NOT NULL 28); 29 30 31ALTER TABLE authors_docs ADD 32 CONSTRAINT PK_authors_docs PRIMARY KEY 33 ( 34 pers_id, 35 doc_id 36 ); 37 38ALTER TABLE documents ADD 39 CONSTRAINT PK_documents PRIMARY KEY 40 ( 41 id 42 ); 43 44ALTER TABLE institutes ADD 45 CONSTRAINT PK_institutes PRIMARY KEY 46 ( 47 id 48 ); 49 50ALTER TABLE persons ADD 51 CONSTRAINT PK_persons PRIMARY KEY 52 ( 53 id 54 ); 55 56ALTER TABLE phones ADD 57 CONSTRAINT PK_phones PRIMARY KEY 58 ( 59 id 60 ); 61 62CREATE SEQUENCE person_ids START WITH 1 INCREMENT BY 1; 63 64CREATE SEQUENCE document_ids START WITH 1 INCREMENT BY 1; 65 66CREATE SEQUENCE institute_ids START WITH 1 INCREMENT BY 1; 67 68CREATE SEQUENCE phone_ids START WITH 1 INCREMENT BY 1; 69