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