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 ,
26
surname varchar (255) NULL ,
27
password varchar (64) NULL
32
id int IDENTITY (1, 1) NOT NULL ,
33
phone varchar (255) NOT NULL ,
38
ALTER TABLE authors_docs WITH NOCHECK ADD
39
CONSTRAINT PK_authors_docs PRIMARY KEY
46
ALTER TABLE documents WITH NOCHECK ADD
47
CONSTRAINT PK_documents PRIMARY KEY
53
ALTER TABLE institutes WITH NOCHECK ADD
54
CONSTRAINT PK_institutes PRIMARY KEY
61
ALTER TABLE persons WITH NOCHECK ADD
62
CONSTRAINT PK_persons PRIMARY KEY
68
ALTER TABLE phones WITH NOCHECK ADD
69
CONSTRAINT PK_phones PRIMARY KEY