Repository navigation
Expand file tree
/
Copy pathcreate_tables.sql
More file actions
173 lines (159 loc) · 4.74 KB
/
Copy pathcreate_tables.sql
File metadata and controls
173 lines (159 loc) · 4.74 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
DROP TABLE IF EXISTS dbo.Resumes
GO
CREATE TABLE dbo.Resumes
(
PersonId bigint NOT NULL PRIMARY KEY NONCLUSTERED HASH WITH (BUCKET_COUNT=100000),
DocId bigint NOT NULL,
RT1 float NOT NULL DEFAULT 0.0,
RT2 float NOT NULL DEFAULT 0.0,
RT3 float NOT NULL DEFAULT 0.0,
RT4 float NOT NULL DEFAULT 0.0,
RT5 float NOT NULL DEFAULT 0.0,
RT6 float NOT NULL DEFAULT 0.0,
RT7 float NOT NULL DEFAULT 0.0,
RT8 float NOT NULL DEFAULT 0.0,
RT9 float NOT NULL DEFAULT 0.0,
RT10 float NOT NULL DEFAULT 0.0,
RT11 float NOT NULL DEFAULT 0.0,
RT12 float NOT NULL DEFAULT 0.0,
RT13 float NOT NULL DEFAULT 0.0,
RT14 float NOT NULL DEFAULT 0.0,
RT15 float NOT NULL DEFAULT 0.0,
RT16 float NOT NULL DEFAULT 0.0,
RT17 float NOT NULL DEFAULT 0.0,
RT18 float NOT NULL DEFAULT 0.0,
RT19 float NOT NULL DEFAULT 0.0,
RT20 float NOT NULL DEFAULT 0.0,
RT21 float NOT NULL DEFAULT 0.0,
RT22 float NOT NULL DEFAULT 0.0,
RT23 float NOT NULL DEFAULT 0.0,
RT24 float NOT NULL DEFAULT 0.0,
RT25 float NOT NULL DEFAULT 0.0,
RT26 float NOT NULL DEFAULT 0.0,
RT27 float NOT NULL DEFAULT 0.0,
RT28 float NOT NULL DEFAULT 0.0,
RT29 float NOT NULL DEFAULT 0.0,
RT30 float NOT NULL DEFAULT 0.0,
RT31 float NOT NULL DEFAULT 0.0,
RT32 float NOT NULL DEFAULT 0.0,
RT33 float NOT NULL DEFAULT 0.0,
RT34 float NOT NULL DEFAULT 0.0,
RT35 float NOT NULL DEFAULT 0.0,
RT36 float NOT NULL DEFAULT 0.0,
RT37 float NOT NULL DEFAULT 0.0,
RT38 float NOT NULL DEFAULT 0.0,
RT39 float NOT NULL DEFAULT 0.0,
RT40 float NOT NULL DEFAULT 0.0,
RT41 float NOT NULL DEFAULT 0.0,
RT42 float NOT NULL DEFAULT 0.0,
RT43 float NOT NULL DEFAULT 0.0,
RT44 float NOT NULL DEFAULT 0.0,
RT45 float NOT NULL DEFAULT 0.0,
RT46 float NOT NULL DEFAULT 0.0,
RT47 float NOT NULL DEFAULT 0.0,
RT48 float NOT NULL DEFAULT 0.0,
RT49 float NOT NULL DEFAULT 0.0,
RT50 float NOT NULL DEFAULT 0.0,
INDEX IX_PersonId HASH (PersonId) with (BUCKET_COUNT=10000)
) WITH (MEMORY_OPTIMIZED=ON)
GO
DROP TABLE IF EXISTS dbo.Projects
GO
CREATE TABLE dbo.Projects
(
ProjectId bigint NOT NULL PRIMARY KEY NONCLUSTERED HASH WITH (BUCKET_COUNT=100000),
PT1 float NOT NULL DEFAULT 0.0,
PT2 float NOT NULL DEFAULT 0.0,
PT3 float NOT NULL DEFAULT 0.0,
PT4 float NOT NULL DEFAULT 0.0,
PT5 float NOT NULL DEFAULT 0.0,
PT6 float NOT NULL DEFAULT 0.0,
PT7 float NOT NULL DEFAULT 0.0,
PT8 float NOT NULL DEFAULT 0.0,
PT9 float NOT NULL DEFAULT 0.0,
PT10 float NOT NULL DEFAULT 0.0,
PT11 float NOT NULL DEFAULT 0.0,
PT12 float NOT NULL DEFAULT 0.0,
PT13 float NOT NULL DEFAULT 0.0,
PT14 float NOT NULL DEFAULT 0.0,
PT15 float NOT NULL DEFAULT 0.0,
PT16 float NOT NULL DEFAULT 0.0,
PT17 float NOT NULL DEFAULT 0.0,
PT18 float NOT NULL DEFAULT 0.0,
PT19 float NOT NULL DEFAULT 0.0,
PT20 float NOT NULL DEFAULT 0.0,
PT21 float NOT NULL DEFAULT 0.0,
PT22 float NOT NULL DEFAULT 0.0,
PT23 float NOT NULL DEFAULT 0.0,
PT24 float NOT NULL DEFAULT 0.0,
PT25 float NOT NULL DEFAULT 0.0,
PT26 float NOT NULL DEFAULT 0.0,
PT27 float NOT NULL DEFAULT 0.0,
PT28 float NOT NULL DEFAULT 0.0,
PT29 float NOT NULL DEFAULT 0.0,
PT30 float NOT NULL DEFAULT 0.0,
PT31 float NOT NULL DEFAULT 0.0,
PT32 float NOT NULL DEFAULT 0.0,
PT33 float NOT NULL DEFAULT 0.0,
PT34 float NOT NULL DEFAULT 0.0,
PT35 float NOT NULL DEFAULT 0.0,
PT36 float NOT NULL DEFAULT 0.0,
PT37 float NOT NULL DEFAULT 0.0,
PT38 float NOT NULL DEFAULT 0.0,
PT39 float NOT NULL DEFAULT 0.0,
PT40 float NOT NULL DEFAULT 0.0,
PT41 float NOT NULL DEFAULT 0.0,
PT42 float NOT NULL DEFAULT 0.0,
PT43 float NOT NULL DEFAULT 0.0,
PT44 float NOT NULL DEFAULT 0.0,
PT45 float NOT NULL DEFAULT 0.0,
PT46 float NOT NULL DEFAULT 0.0,
PT47 float NOT NULL DEFAULT 0.0,
PT48 float NOT NULL DEFAULT 0.0,
PT49 float NOT NULL DEFAULT 0.0,
PT50 float NOT NULL DEFAULT 0.0,
INDEX IX_ProjectId HASH (ProjectId) WITH (BUCKET_COUNT=10000)
) WITH (MEMORY_OPTIMIZED=ON)
GO
DROP TABLE IF EXISTS dbo.LabeledData
GO
CREATE TABLE dbo.LabeledData
(
Label tinyint NOT NULL,
DocId bigint NOT NULL,
ProjectId bigint NOT NULL
)
GO
DROP TABLE IF EXISTS dbo.ClassificationModelR
GO
CREATE TABLE dbo.ClassificationModelR
(
modelName varchar(100) not null,
model varbinary(max) not null
)
GO
DROP TABLE IF EXISTS dbo.PredictionsR
GO
CREATE TABLE dbo.PredictionsR
(
[id] bigint IDENTITY(1,1) PRIMARY KEY NONCLUSTERED,
[PersonId] [bigint] NOT NULL,
[DocId] [bigint] NOT NULL,
[ProjectId] [bigint] NOT NULL,
[Probability] [float] NOT NULL,
) WITH (MEMORY_OPTIMIZED=ON, DURABILITY=SCHEMA_AND_DATA)
GO
DROP TABLE IF EXISTS dbo.scoring_stats
GO
CREATE TABLE dbo.scoring_stats
(
project_id bigint NOT NULL,
group_id int NOT NULL,
match_row_count int NOT NULL,
start_time datetime2 NOT NULL,
end_time datetime2 NOT NULL,
r_predict_duration float NOT NULL,
total_duration float NOT NULL,
rate_prediction float NOT NULL
)
GO