-
Notifications
You must be signed in to change notification settings - Fork 44
/
features.sql
303 lines (303 loc) · 12 KB
/
features.sql
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
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
CREATE TABLE features_import (
browseruseragent character varying(1023),
browsername character varying(255),
browsernameos character varying(255),
browsernameversion character varying(255),
browsernameversionos character varying(255),
browseros character varying(255),
browsertype character varying(255),
browserversion character varying(255),
bwegoogactualencbitratemean real,
bwegoogactualencbitratemax real,
bwegoogactualencbitratemin real,
bwegoogactualencbitratevariance real,
bwegoogactualencbitrateskewness real,
bwegoogactualencbitratekurtosis real,
bwegoogretransmitbitratemean real,
bwegoogretransmitbitratemax real,
bwegoogretransmitbitratemin real,
bwegoogretransmitbitratevariance real,
bwegoogretransmitbitrateskewness real,
bwegoogretransmitbitratekurtosis real,
bwegoogtargetencbitratemean real,
bwegoogtargetencbitratemax real,
bwegoogtargetencbitratemin real,
bwegoogtargetencbitratevariance real,
bwegoogtargetencbitrateskewness real,
bwegoogtargetencbitratekurtosis real,
bwegoogbucketdelaymean real,
bwegoogbucketdelaymax real,
bwegoogbucketdelaymin real,
bwegoogbucketdelayvariance real,
bwegoogbucketdelayskewness real,
bwegoogbucketdelaykurtosis real,
bwegoogtransmitbitratemean real,
bwegoogtransmitbitratemax real,
bwegoogtransmitbitratemin real,
bwegoogtransmitbitratevariance real,
bwegoogtransmitbitrateskewness real,
bwegoogtransmitbitratekurtosis real,
bweavailableoutgoingbitratemean real,
bweavailableoutgoingbitratemax real,
bweavailableoutgoingbitratemin real,
bweavailableoutgoingbitratevariance real,
bweavailableoutgoingbitrateskewness real,
bweavailableoutgoingbitratekurtosis real,
bweavailableincomingbitratemean real,
bweavailableincomingbitratemax real,
bweavailableincomingbitratemin real,
bweavailableincomingbitratevariance real,
bweavailableincomingbitrateskewness real,
bweavailableincomingbitratekurtosis real,
calledgetusermedia boolean,
calledgetusermediarequestingaudio boolean,
calledgetusermediarequestingscreen character varying(255),
calledgetusermediarequestingvideo boolean,
calledlegacygetusermedia boolean,
calledmediadevicesgetusermedia boolean,
clientid character varying(255),
clientidentifier character varying(255),
conferenceidentifier character varying(4096),
configured boolean,
configuredbundlepolicy boolean,
configuredcertificate boolean,
configuredicetransportpolicy boolean,
configuredrtcpmuxpolicy boolean,
configuredwithiceservers boolean,
configuredwithstun boolean,
configuredwithturn boolean,
configuredwithturntcp boolean,
configuredwithturntls boolean,
configuredwithturnudp boolean,
connectionid character varying(255) default ''::character varying not null,
connectiontime integer,
date bigint,
datetime bigint,
dtlsciphersuite character varying(255),
firstaudiotracklabel character varying(255),
firstcandidatepairtype character varying(255),
firstcandidatepairlocaltype character varying(255),
firstcandidatepairremotetype character varying(255),
firstcandidatepairlocalipaddress character varying(255),
firstcandidatepairremoteipaddress character varying(255),
firstcandidatepairlocaltypepreference integer,
firstcandidatepairremotetypepreference integer,
firstvideotracklabel character varying(255),
gatheredhost boolean,
gatheredstun boolean,
gatheredturntcp boolean,
gatheredturntls boolean,
gatheredturnudp boolean,
gatheredrfc1918addressprefix16 boolean,
gatheredrfc1918addressprefix12 boolean,
gatheredrfc1918addressprefix10 boolean,
gatheringtime integer,
gatheringtimeturntcp integer,
gatheringtimeturntls integer,
gatheringtimeturnudp integer,
getusermediaerror character varying(4096),
getusermediasuccess boolean,
hadremoteturncandidate boolean,
iceconnectedorcompleted boolean,
icefailure boolean,
icefailuresubsequent boolean,
icegatheringcomplete boolean,
icerestart boolean,
isinitiator boolean,
localcreatedelay integer,
maxstreams integer,
mediatypes character varying(255),
numberofcandidatepairchanges integer,
numberoflocalicecandidates integer,
numberofremoteicecandidates integer,
numberofpeerconnections integer,
pageurl character varying(4096),
origin character varying(255),
peeridentifier character varying(255),
recvaudiocodec character varying(255),
recvvideocodec character varying(255),
remotetype character varying(255),
sendaudiocodec character varying(255),
sendvideocodec character varying(255),
sessionduration integer,
signalingstableatleastonce boolean,
srtpciphersuite character varying(255),
statsmeanaudiolevel real,
statsmeanreceivingbitrate integer,
statsmeanroundtriptime integer,
statsmeansendingbitrate integer,
timebetweengetusermediaandgetusermediasuccess integer,
timebetweengetusermediaandgetusermediafailure integer,
timebetweensetlocaldescriptionandonicecandidate integer,
timebetweensetremotedescriptionandaddicecandidate integer,
usingbundle boolean,
usingicelite boolean,
usingmultistream boolean,
usingrtcpmux boolean,
wasgoogbandwidthlimitedresolutionevertrue boolean,
wasgoogcpulimitedresolutionevertrue boolean,
audiosendaudiolevelmean real,
audiosendaudiolevelmax real,
audiosendaudiolevelmin real,
audiosendaudiolevelvariance real,
audiosendaudiolevelskewness real,
audiosendaudiolevelkurtosis real,
audiosendgoogjitterreceivedmean real,
audiosendgoogjitterreceivedmax real,
audiosendgoogjitterreceivedmin real,
audiosendgoogjitterreceivedvariance real,
audiosendgoogjitterreceivedskewness real,
audiosendgoogjitterreceivedkurtosis real,
audiosendgoogrttmean real,
audiosendgoogrttmax real,
audiosendgoogrttmin real,
audiosendgoogrttvariance real,
audiosendgoogrttskewness real,
audiosendgoogrttkurtosis real,
audiorecvaudiolevelmean real,
audiorecvaudiolevelmax real,
audiorecvaudiolevelmin real,
audiorecvaudiolevelvariance real,
audiorecvaudiolevelskewness real,
audiorecvaudiolevelkurtosis real,
audiorecvgoogjitterreceivedmean real,
audiorecvgoogjitterreceivedmax real,
audiorecvgoogjitterreceivedmin real,
audiorecvgoogjitterreceivedvariance real,
audiorecvgoogjitterreceivedskewness real,
audiorecvgoogjitterreceivedkurtosis real,
audiorecvgoogcurrentdelaymsmean real,
audiorecvgoogcurrentdelaymsmax real,
audiorecvgoogcurrentdelaymsmin real,
audiorecvgoogcurrentdelaymsvariance real,
audiorecvgoogcurrentdelaymsskewness real,
audiorecvgoogcurrentdelaymskurtosis real,
audiorecvgoogjitterbuffermsmean real,
audiorecvgoogjitterbuffermsmax real,
audiorecvgoogjitterbuffermsmin real,
audiorecvgoogjitterbuffermsvariance real,
audiorecvgoogjitterbuffermsskewness real,
audiorecvgoogjitterbuffermskurtosis real,
audiorecvgoogpreferredjitterbuffermsmean real,
audiorecvgoogpreferredjitterbuffermsmax real,
audiorecvgoogpreferredjitterbuffermsmin real,
audiorecvgoogpreferredjitterbuffermsvariance real,
audiorecvgoogpreferredjitterbuffermsskewness real,
audiorecvgoogpreferredjitterbuffermskurtosis real,
videosendgoogrttmean real,
videosendgoogrttmax real,
videosendgoogrttmin real,
videosendgoogrttvariance real,
videosendgoogrttskewness real,
videosendgoogrttkurtosis real,
videosendgoogencodeusagepercentmean real,
videosendgoogencodeusagepercentmax real,
videosendgoogencodeusagepercentmin real,
videosendgoogencodeusagepercentvariance real,
videosendgoogencodeusagepercentskewness real,
videosendgoogencodeusagepercentkurtosis real,
videosendgoogframeheightinputmax real,
videosendgoogframeheightinputmin real,
videosendgoogframeheightinputmode real,
videosendgoogframeheightsentmax real,
videosendgoogframeheightsentmin real,
videosendgoogframeheightsentmode real,
videosendgoogframewidthinputmax real,
videosendgoogframewidthinputmin real,
videosendgoogframewidthinputmode real,
videosendgoogframewidthsentmax real,
videosendgoogframewidthsentmin real,
videosendgoogframewidthsentmode real,
videosendgoogcpulimitedresolutionmean real,
videosendgoogcpulimitedresolutionmax real,
videosendgoogcpulimitedresolutionmin real,
videosendgoogcpulimitedresolutionmode real,
videosendgoogbandwidthlimitedresolutionmean real,
videosendgoogbandwidthlimitedresolutionmax real,
videosendgoogbandwidthlimitedresolutionmin real,
videosendgoogbandwidthlimitedresolutionmode real,
videorecvgoogcurrentdelaymsmean real,
videorecvgoogcurrentdelaymsmax real,
videorecvgoogcurrentdelaymsmin real,
videorecvgoogcurrentdelaymsvariance real,
videorecvgoogcurrentdelaymsskewness real,
videorecvgoogcurrentdelaymskurtosis real,
videorecvgoogjitterbuffermsmean real,
videorecvgoogjitterbuffermsmax real,
videorecvgoogjitterbuffermsmin real,
videorecvgoogjitterbuffermsvariance real,
videorecvgoogjitterbuffermsskewness real,
videorecvgoogjitterbuffermskurtosis real,
videorecvgoogdecodemsmean real,
videorecvgoogdecodemsmax real,
videorecvgoogdecodemsmin real,
videorecvgoogdecodemsvariance real,
videorecvgoogdecodemsskewness real,
videorecvgoogdecodemskurtosis real,
videorecvgoogmaxdecodemsmean real,
videorecvgoogmaxdecodemsmax real,
videorecvgoogmaxdecodemsmin real,
videorecvgoogmaxdecodemsvariance real,
videorecvgoogmaxdecodemsskewness real,
videorecvgoogmaxdecodemskurtosis real,
videorecvgoogminplayoutdelaymsmean real,
videorecvgoogminplayoutdelaymsmax real,
videorecvgoogminplayoutdelaymsmin real,
videorecvgoogminplayoutdelaymsvariance real,
videorecvgoogminplayoutdelaymsskewness real,
videorecvgoogminplayoutdelaymskurtosis real,
videorecvgoogrenderdelaymsmean real,
videorecvgoogrenderdelaymsmax real,
videorecvgoogrenderdelaymsmin real,
videorecvgoogrenderdelaymsvariance real,
videorecvgoogrenderdelaymsskewness real,
videorecvgoogrenderdelaymskurtosis real,
videorecvgoogtargetdelaymsmean real,
videorecvgoogtargetdelaymsmax real,
videorecvgoogtargetdelaymsmin real,
videorecvgoogtargetdelaymsvariance real,
videorecvgoogtargetdelaymsskewness real,
videorecvgoogtargetdelaymskurtosis real,
videorecvgoogframeheightreceivedmax real,
videorecvgoogframeheightreceivedmin real,
videorecvgoogframeheightreceivedmode real,
videorecvgoogframewidthreceivedmax real,
videorecvgoogframewidthreceivedmin real,
videorecvgoogframewidthreceivedmode real,
relayaddress character varying(255),
notsendingaudio boolean,
notsendingvideo boolean,
receivingvideo10spacketsreceived real,
receivingvideo10sframewidth real,
receivingvideo10sframeheight real,
browsermajorversion integer,
starttime bigint,
icerestartsuccess boolean,
icerestartfollowedbysetremotedescription boolean,
numberofinterfaces integer,
icerestartfollowedbyrelaycandidate boolean,
setlocaldescriptionfailure character varying(4096),
setremotedescriptionfailure character varying(4096),
addicecandidatefailure character varying(4096),
stoptime bigint,
lifetime integer,
locationLon real,
locationLat real,
locationLonLat character varying(255),
locationContinent character varying(16),
locationCountry character varying(255),
locationCity character varying(255),
publicipaddress character varying(255),
userfeedbackaudio integer,
userfeedbackvideo integer,
receivingaudio10spacketsreceived real,
receivingaudio10sjitterbufferms real,
timeuntilreceivingvideo bigint,
firstremotestreamid character varying(255),
firstremotestreamaudio character varying(255),
firstremotestreamvideo character varying(255),
usingsimulcast boolean,
sdpsemantics: character varying(32),
calledaddtrack: boolean,
calledaddstream: boolean
);