2 CREATE TABLE authors_docs (
8 CREATE 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
16 CREATE TABLE institutes (
17 id int IDENTITY (1, 1) NOT NULL ,
18 name varchar (255) NOT NULL
23 CREATE TABLE persons (
24 id int IDENTITY (1, 1) NOT NULL ,
25 name varchar (255) NULL
30 id int IDENTITY (1, 1) NOT NULL ,
31 phone varchar (255) NOT NULL ,
36 ALTER TABLE authors_docs WITH NOCHECK ADD
37 CONSTRAINT PK_authors_docs PRIMARY KEY
44 ALTER TABLE documents WITH NOCHECK ADD
45 CONSTRAINT PK_documents PRIMARY KEY
51 ALTER TABLE institutes WITH NOCHECK ADD
52 CONSTRAINT PK_institutes PRIMARY KEY
59 ALTER TABLE persons WITH NOCHECK ADD
60 CONSTRAINT PK_persons PRIMARY KEY
66 ALTER TABLE phones WITH NOCHECK ADD
67 CONSTRAINT PK_phones PRIMARY KEY