-
Notifications
You must be signed in to change notification settings - Fork 0
/
Schema
219 lines (216 loc) · 10 KB
/
Schema
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
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
DEFINE SCHEMA
RECORD TYPE DateIntMatrix (
"___createTime" TIMESTAMP,
"___createdBy" REFERENCE,
"___etag" STRING,
"___modTime" TIMESTAMP,
"___modifiedBy" REFERENCE,
"___recordID" REFERENCE,
cell_1_00 INT64 QUERYABLE SORTABLE,
cell_1_01 INT64 QUERYABLE SORTABLE,
cell_1_02 INT64 QUERYABLE SORTABLE,
cell_1_03 INT64 QUERYABLE SORTABLE,
cell_1_04 INT64 QUERYABLE SORTABLE,
cell_1_05 INT64 QUERYABLE SORTABLE,
cell_1_06 INT64 QUERYABLE SORTABLE,
cell_1_07 INT64 QUERYABLE SORTABLE,
cell_1_08 INT64 QUERYABLE SORTABLE,
cell_1_09 INT64 QUERYABLE SORTABLE,
cell_1_10 INT64 QUERYABLE SORTABLE,
cell_1_11 INT64 QUERYABLE SORTABLE,
cell_1_12 INT64 QUERYABLE SORTABLE,
cell_1_13 INT64 QUERYABLE SORTABLE,
cell_1_14 INT64 QUERYABLE SORTABLE,
cell_1_15 INT64 QUERYABLE SORTABLE,
cell_1_16 INT64 QUERYABLE SORTABLE,
cell_1_17 INT64 QUERYABLE SORTABLE,
cell_1_18 INT64 QUERYABLE SORTABLE,
cell_1_19 INT64 QUERYABLE SORTABLE,
cell_1_20 INT64 QUERYABLE SORTABLE,
cell_1_21 INT64 QUERYABLE SORTABLE,
cell_1_22 INT64 QUERYABLE SORTABLE,
cell_1_23 INT64 QUERYABLE SORTABLE,
cell_2_00 INT64 QUERYABLE SORTABLE,
cell_2_01 INT64 QUERYABLE SORTABLE,
cell_2_02 INT64 QUERYABLE SORTABLE,
cell_2_03 INT64 QUERYABLE SORTABLE,
cell_2_04 INT64 QUERYABLE SORTABLE,
cell_2_05 INT64 QUERYABLE SORTABLE,
cell_2_06 INT64 QUERYABLE SORTABLE,
cell_2_07 INT64 QUERYABLE SORTABLE,
cell_2_08 INT64 QUERYABLE SORTABLE,
cell_2_09 INT64 QUERYABLE SORTABLE,
cell_2_10 INT64 QUERYABLE SORTABLE,
cell_2_11 INT64 QUERYABLE SORTABLE,
cell_2_12 INT64 QUERYABLE SORTABLE,
cell_2_13 INT64 QUERYABLE SORTABLE,
cell_2_14 INT64 QUERYABLE SORTABLE,
cell_2_15 INT64 QUERYABLE SORTABLE,
cell_2_16 INT64 QUERYABLE SORTABLE,
cell_2_17 INT64 QUERYABLE SORTABLE,
cell_2_18 INT64 QUERYABLE SORTABLE,
cell_2_19 INT64 QUERYABLE SORTABLE,
cell_2_20 INT64 QUERYABLE SORTABLE,
cell_2_21 INT64 QUERYABLE SORTABLE,
cell_2_22 INT64 QUERYABLE SORTABLE,
cell_2_23 INT64 QUERYABLE SORTABLE,
cell_3_00 INT64 QUERYABLE SORTABLE,
cell_3_01 INT64 QUERYABLE SORTABLE,
cell_3_02 INT64 QUERYABLE SORTABLE,
cell_3_03 INT64 QUERYABLE SORTABLE,
cell_3_04 INT64 QUERYABLE SORTABLE,
cell_3_05 INT64 QUERYABLE SORTABLE,
cell_3_06 INT64 QUERYABLE SORTABLE,
cell_3_07 INT64 QUERYABLE SORTABLE,
cell_3_08 INT64 QUERYABLE SORTABLE,
cell_3_09 INT64 QUERYABLE SORTABLE,
cell_3_10 INT64 QUERYABLE SORTABLE,
cell_3_11 INT64 QUERYABLE SORTABLE,
cell_3_12 INT64 QUERYABLE SORTABLE,
cell_3_13 INT64 QUERYABLE SORTABLE,
cell_3_14 INT64 QUERYABLE SORTABLE,
cell_3_15 INT64 QUERYABLE SORTABLE,
cell_3_16 INT64 QUERYABLE SORTABLE,
cell_3_17 INT64 QUERYABLE SORTABLE,
cell_3_18 INT64 QUERYABLE SORTABLE,
cell_3_19 INT64 QUERYABLE SORTABLE,
cell_3_20 INT64 QUERYABLE SORTABLE,
cell_3_21 INT64 QUERYABLE SORTABLE,
cell_3_22 INT64 QUERYABLE SORTABLE,
cell_3_23 INT64 QUERYABLE SORTABLE,
cell_4_00 INT64 QUERYABLE SORTABLE,
cell_4_01 INT64 QUERYABLE SORTABLE,
cell_4_02 INT64 QUERYABLE SORTABLE,
cell_4_03 INT64 QUERYABLE SORTABLE,
cell_4_04 INT64 QUERYABLE SORTABLE,
cell_4_05 INT64 QUERYABLE SORTABLE,
cell_4_06 INT64 QUERYABLE SORTABLE,
cell_4_07 INT64 QUERYABLE SORTABLE,
cell_4_08 INT64 QUERYABLE SORTABLE,
cell_4_09 INT64 QUERYABLE SORTABLE,
cell_4_10 INT64 QUERYABLE SORTABLE,
cell_4_11 INT64 QUERYABLE SORTABLE,
cell_4_12 INT64 QUERYABLE SORTABLE,
cell_4_13 INT64 QUERYABLE SORTABLE,
cell_4_14 INT64 QUERYABLE SORTABLE,
cell_4_15 INT64 QUERYABLE SORTABLE,
cell_4_16 INT64 QUERYABLE SORTABLE,
cell_4_17 INT64 QUERYABLE SORTABLE,
cell_4_18 INT64 QUERYABLE SORTABLE,
cell_4_19 INT64 QUERYABLE SORTABLE,
cell_4_20 INT64 QUERYABLE SORTABLE,
cell_4_21 INT64 QUERYABLE SORTABLE,
cell_4_22 INT64 QUERYABLE SORTABLE,
cell_4_23 INT64 QUERYABLE SORTABLE,
cell_5_00 INT64 QUERYABLE SORTABLE,
cell_5_01 INT64 QUERYABLE SORTABLE,
cell_5_02 INT64 QUERYABLE SORTABLE,
cell_5_03 INT64 QUERYABLE SORTABLE,
cell_5_04 INT64 QUERYABLE SORTABLE,
cell_5_05 INT64 QUERYABLE SORTABLE,
cell_5_06 INT64 QUERYABLE SORTABLE,
cell_5_07 INT64 QUERYABLE SORTABLE,
cell_5_08 INT64 QUERYABLE SORTABLE,
cell_5_09 INT64 QUERYABLE SORTABLE,
cell_5_10 INT64 QUERYABLE SORTABLE,
cell_5_11 INT64 QUERYABLE SORTABLE,
cell_5_12 INT64 QUERYABLE SORTABLE,
cell_5_13 INT64 QUERYABLE SORTABLE,
cell_5_14 INT64 QUERYABLE SORTABLE,
cell_5_15 INT64 QUERYABLE SORTABLE,
cell_5_16 INT64 QUERYABLE SORTABLE,
cell_5_17 INT64 QUERYABLE SORTABLE,
cell_5_18 INT64 QUERYABLE SORTABLE,
cell_5_19 INT64 QUERYABLE SORTABLE,
cell_5_20 INT64 QUERYABLE SORTABLE,
cell_5_21 INT64 QUERYABLE SORTABLE,
cell_5_22 INT64 QUERYABLE SORTABLE,
cell_5_23 INT64 QUERYABLE SORTABLE,
cell_6_00 INT64 QUERYABLE SORTABLE,
cell_6_01 INT64 QUERYABLE SORTABLE,
cell_6_02 INT64 QUERYABLE SORTABLE,
cell_6_03 INT64 QUERYABLE SORTABLE,
cell_6_04 INT64 QUERYABLE SORTABLE,
cell_6_05 INT64 QUERYABLE SORTABLE,
cell_6_06 INT64 QUERYABLE SORTABLE,
cell_6_07 INT64 QUERYABLE SORTABLE,
cell_6_08 INT64 QUERYABLE SORTABLE,
cell_6_09 INT64 QUERYABLE SORTABLE,
cell_6_10 INT64 QUERYABLE SORTABLE,
cell_6_11 INT64 QUERYABLE SORTABLE,
cell_6_12 INT64 QUERYABLE SORTABLE,
cell_6_13 INT64 QUERYABLE SORTABLE,
cell_6_14 INT64 QUERYABLE SORTABLE,
cell_6_15 INT64 QUERYABLE SORTABLE,
cell_6_16 INT64 QUERYABLE SORTABLE,
cell_6_17 INT64 QUERYABLE SORTABLE,
cell_6_18 INT64 QUERYABLE SORTABLE,
cell_6_19 INT64 QUERYABLE SORTABLE,
cell_6_20 INT64 QUERYABLE SORTABLE,
cell_6_21 INT64 QUERYABLE SORTABLE,
cell_6_22 INT64 QUERYABLE SORTABLE,
cell_6_23 INT64 QUERYABLE SORTABLE,
cell_7_00 INT64 QUERYABLE SORTABLE,
cell_7_01 INT64 QUERYABLE SORTABLE,
cell_7_02 INT64 QUERYABLE SORTABLE,
cell_7_03 INT64 QUERYABLE SORTABLE,
cell_7_04 INT64 QUERYABLE SORTABLE,
cell_7_05 INT64 QUERYABLE SORTABLE,
cell_7_06 INT64 QUERYABLE SORTABLE,
cell_7_07 INT64 QUERYABLE SORTABLE,
cell_7_08 INT64 QUERYABLE SORTABLE,
cell_7_09 INT64 QUERYABLE SORTABLE,
cell_7_10 INT64 QUERYABLE SORTABLE,
cell_7_11 INT64 QUERYABLE SORTABLE,
cell_7_12 INT64 QUERYABLE SORTABLE,
cell_7_13 INT64 QUERYABLE SORTABLE,
cell_7_14 INT64 QUERYABLE SORTABLE,
cell_7_15 INT64 QUERYABLE SORTABLE,
cell_7_16 INT64 QUERYABLE SORTABLE,
cell_7_17 INT64 QUERYABLE SORTABLE,
cell_7_18 INT64 QUERYABLE SORTABLE,
cell_7_19 INT64 QUERYABLE SORTABLE,
cell_7_20 INT64 QUERYABLE SORTABLE,
cell_7_21 INT64 QUERYABLE SORTABLE,
cell_7_22 INT64 QUERYABLE SORTABLE,
cell_7_23 INT64 QUERYABLE SORTABLE,
date TIMESTAMP QUERYABLE SORTABLE,
name STRING QUERYABLE SEARCHABLE SORTABLE,
version INT64 QUERYABLE SORTABLE,
GRANT WRITE TO "_creator",
GRANT CREATE, WRITE TO "_icloud",
GRANT READ TO "_world"
);
RECORD TYPE Event (
"___createTime" TIMESTAMP,
"___createdBy" REFERENCE,
"___etag" STRING,
"___modTime" TIMESTAMP,
"___modifiedBy" REFERENCE,
"___recordID" REFERENCE QUERYABLE,
date TIMESTAMP QUERYABLE SORTABLE,
hour TIMESTAMP QUERYABLE SORTABLE,
level STRING QUERYABLE SEARCHABLE SORTABLE,
name STRING QUERYABLE SEARCHABLE SORTABLE,
param_count INT64 QUERYABLE SORTABLE,
params BYTES QUERYABLE SORTABLE,
session_id STRING QUERYABLE SEARCHABLE SORTABLE,
user_id STRING QUERYABLE SEARCHABLE SORTABLE,
uuid STRING QUERYABLE SEARCHABLE SORTABLE,
version INT64 QUERYABLE SORTABLE,
week TIMESTAMP QUERYABLE SORTABLE,
GRANT WRITE TO "_creator",
GRANT CREATE TO "_icloud",
GRANT READ TO "_world"
);
RECORD TYPE Users (
"___createTime" TIMESTAMP,
"___createdBy" REFERENCE,
"___etag" STRING,
"___modTime" TIMESTAMP,
"___modifiedBy" REFERENCE,
"___recordID" REFERENCE,
roles LIST<INT64>,
GRANT WRITE TO "_creator",
GRANT READ TO "_world"
);