Diferencia entre revisiones de «BD.MET PERFILES SALA»

De VIVAitwiki
Ir a la navegaciónIr a la búsqueda
 
(No se muestran 14 ediciones intermedias de 2 usuarios)
Línea 1: Línea 1:
 
==Descripción==
 
==Descripción==
 +
 +
  
 
==Campos==
 
==Campos==
  
 
===ID===
 
===ID===
INT NOT NULL AUTO_INCREMENT,
+
INT(11) NOT NULL AUTO_INCREMENT,
  
 
===C_NOMBRE===
 
===C_NOMBRE===
VARCHAR(45) CHARACTER SET 'utf8' NULL DEFAULT NULL,
+
VARCHAR(45) CHARACTER SET 'utf8' COLLATE 'utf8_spanish_ci' NULL DEFAULT NULL,
  
 
===C_DESCRIPCION===
 
===C_DESCRIPCION===
VARCHAR(128) CHARACTER SET 'utf8' NULL DEFAULT NULL,
+
 
 +
VARCHAR(128) CHARACTER SET 'utf8' COLLATE 'utf8_spanish_ci' NULL DEFAULT NULL,
  
 
===N_MAX_PUBLISHER===
 
===N_MAX_PUBLISHER===
 
INT(11) NULL DEFAULT NULL,
 
INT(11) NULL DEFAULT NULL,
 +
 +
<max number of concurrent senders> (e.g., 6 for a video
 +
;              conference or 1 for a webinar)
  
 
===N_DYN_USER_MAX_MINS===
 
===N_DYN_USER_MAX_MINS===
Línea 29: Línea 35:
 
===N_BITRATE===
 
===N_BITRATE===
 
INT(11) NULL DEFAULT NULL,
 
INT(11) NULL DEFAULT NULL,
 +
 +
<max video bitrate for senders> (e.g., 128000)
 +
 +
===B_BITRATE_CAP===
 +
TINYINT(1) NOT NULL DEFAULT '0',
 +
 +
Si el valor es true el bitrate no puede sobrepasarse.
  
 
===N_FIR_FREQ===
 
===N_FIR_FREQ===
 
INT(11) NULL DEFAULT NULL,
 
INT(11) NULL DEFAULT NULL,
 +
 +
<send a FIR to publishers every fir_freq seconds> (0=disable)
  
 
===E_AUDIO_CODEC===
 
===E_AUDIO_CODEC===
Línea 66: Línea 81:
 
===B_VIDEO_SVC===
 
===B_VIDEO_SVC===
 
TINYINT(1) NULL DEFAULT NULL,
 
TINYINT(1) NULL DEFAULT NULL,
 +
 +
yes|no (whether SVC support must be enabled; works only for VP9, default=no)
  
 
===B_AUDIOLEVEL_EXT===
 
===B_AUDIOLEVEL_EXT===
 
TINYINT(1) NULL DEFAULT NULL,
 
TINYINT(1) NULL DEFAULT NULL,
 +
 +
yes|no
 +
(whether the ssrc-audio-level RTP extension must be negotiated/used or not for new publishers, default=yes)
  
 
===B_AUDIOLEVEL_EVENT===
 
===B_AUDIOLEVEL_EVENT===
 
TINYINT(1) NULL DEFAULT NULL,
 
TINYINT(1) NULL DEFAULT NULL,
 +
 +
yes|no (whether to emit event to other users or not, default=no)
  
 
===N_AUDIO_ACTIVE_PACKETS===
 
===N_AUDIO_ACTIVE_PACKETS===
 
INT(11) NULL DEFAULT NULL,
 
INT(11) NULL DEFAULT NULL,
 +
 +
100 (number of packets with audio level, default=100, 2 seconds)
  
 
===N_AUDIO_LEVEL_AVERAGE===
 
===N_AUDIO_LEVEL_AVERAGE===
 
INT(11) NULL DEFAULT NULL,
 
INT(11) NULL DEFAULT NULL,
 +
 +
25 (average value of audio level, 127=muted, 0='too loud', default=25)
  
 
===B_VIDEOORIENT_EXT===
 
===B_VIDEOORIENT_EXT===
 
TINYINT(1) NULL DEFAULT NULL,
 
TINYINT(1) NULL DEFAULT NULL,
 +
 +
yes|no
 +
 +
(whether the video-orientation RTP extension must be negotiated/used or not for new publishers, default=yes)
  
 
===B_PLAYOUTDELAY_EXT===
 
===B_PLAYOUTDELAY_EXT===
 
TINYINT(1) NULL DEFAULT NULL,
 
TINYINT(1) NULL DEFAULT NULL,
 +
 +
yes|no
 +
 +
(whether the playout-delay RTP extension must be negotiated/used or not for new publishers, default=yes)
 +
 +
===B_TRANSPORT_WIDE_CC_EXT===
 +
TINYINT(1) NULL DEFAULT NULL,
 +
 +
yes|no
 +
 +
(whether the transport wide CC RTP extension must be negotiated/used or not for new publishers, default=no; note that this currently doesn't work correctly when the publisher is doing simulcasting)
  
 
===B_GRABAR===
 
===B_GRABAR===
 
TINYINT(1) NOT NULL DEFAULT '0',
 
TINYINT(1) NOT NULL DEFAULT '0',
 +
 +
true|false (whether this room should be recorded, default=false)
  
 
===B_HAY_PAD===
 
===B_HAY_PAD===
 
TINYINT(1) NOT NULL DEFAULT '0',
 
TINYINT(1) NOT NULL DEFAULT '0',
 +
 +
Si hay documentos compartidos
  
 
===B_NO_USAR===
 
===B_NO_USAR===

Revisión actual del 12:45 28 oct 2021

1 Descripción

2 Campos

2.1 ID

INT(11) NOT NULL AUTO_INCREMENT,

2.2 C_NOMBRE

VARCHAR(45) CHARACTER SET 'utf8' COLLATE 'utf8_spanish_ci' NULL DEFAULT NULL,

2.3 C_DESCRIPCION

VARCHAR(128) CHARACTER SET 'utf8' COLLATE 'utf8_spanish_ci' NULL DEFAULT NULL,

2.4 N_MAX_PUBLISHER

INT(11) NULL DEFAULT NULL,

<max number of concurrent senders> (e.g., 6 for a video

conference or 1 for a webinar)

2.5 N_DYN_USER_MAX_MINS

INT(11) NULL DEFAULT NULL,

2.6 N_DYN_USER_MAX_DELAY_HOURS

INT(11) NULL DEFAULT NULL,

2.7 ID_PLANTILLA_ASUNTO_INVITACION

INT(11) NULL DEFAULT NULL,

2.8 ID_PLANTILLA_CUERPO_INVITACION

INT(11) NULL DEFAULT NULL,

2.9 N_BITRATE

INT(11) NULL DEFAULT NULL,

<max video bitrate for senders> (e.g., 128000)

2.10 B_BITRATE_CAP

TINYINT(1) NOT NULL DEFAULT '0',

Si el valor es true el bitrate no puede sobrepasarse.

2.11 N_FIR_FREQ

INT(11) NULL DEFAULT NULL,

<send a FIR to publishers every fir_freq seconds> (0=disable)

2.12 E_AUDIO_CODEC

INT(11) NULL DEFAULT NULL

Este campo usa el enumerado TConferenciaAvanAudioCodec.

2.13 E_AUDIO_CODEC_1

INT(11) NULL DEFAULT NULL

Este campo usa el enumerado TConferenciaAvanAudioCodec.

2.14 E_AUDIO_CODEC_2

INT(11) NULL DEFAULT NULL

Este campo usa el enumerado TConferenciaAvanAudioCodec.

2.15 E_VIDEO_CODEC

INT(11) NULL DEFAULT NULL

Este campo usa el enumerado TConferenciaAvanVideoCodec.


2.16 E_VIDEO_CODEC_1

INT(11) NULL DEFAULT NULL

Este campo usa el enumerado TConferenciaAvanVideoCodec.

2.17 E_VIDEO_CODEC_2

INT(11) NULL DEFAULT NULL

Este campo usa el enumerado TConferenciaAvanVideoCodec.

2.18 B_VIDEO_SVC

TINYINT(1) NULL DEFAULT NULL,

yes|no (whether SVC support must be enabled; works only for VP9, default=no)

2.19 B_AUDIOLEVEL_EXT

TINYINT(1) NULL DEFAULT NULL,

yes|no (whether the ssrc-audio-level RTP extension must be negotiated/used or not for new publishers, default=yes)

2.20 B_AUDIOLEVEL_EVENT

TINYINT(1) NULL DEFAULT NULL,

yes|no (whether to emit event to other users or not, default=no)

2.21 N_AUDIO_ACTIVE_PACKETS

INT(11) NULL DEFAULT NULL,

100 (number of packets with audio level, default=100, 2 seconds)

2.22 N_AUDIO_LEVEL_AVERAGE

INT(11) NULL DEFAULT NULL,

25 (average value of audio level, 127=muted, 0='too loud', default=25)

2.23 B_VIDEOORIENT_EXT

TINYINT(1) NULL DEFAULT NULL,

yes|no

(whether the video-orientation RTP extension must be negotiated/used or not for new publishers, default=yes)

2.24 B_PLAYOUTDELAY_EXT

TINYINT(1) NULL DEFAULT NULL,

yes|no

(whether the playout-delay RTP extension must be negotiated/used or not for new publishers, default=yes)

2.25 B_TRANSPORT_WIDE_CC_EXT

TINYINT(1) NULL DEFAULT NULL,

yes|no

(whether the transport wide CC RTP extension must be negotiated/used or not for new publishers, default=no; note that this currently doesn't work correctly when the publisher is doing simulcasting)

2.26 B_GRABAR

TINYINT(1) NOT NULL DEFAULT '0',

true|false (whether this room should be recorded, default=false)

2.27 B_HAY_PAD

TINYINT(1) NOT NULL DEFAULT '0',

Si hay documentos compartidos

2.28 B_NO_USAR

TINYINT(1) NOT NULL DEFAULT '0',

3 índices

 PRIMARY KEY (`ID`)

4 índices réplica