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