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