专注于VoIP,Opensips,Kamailio等技术,QQ群：QQ群：293697898
List of Tables
1-1. Table "acc"
1-2. Table "acc"
1-3. Table "missed_calls"
1-4. Table "missed_calls"
2-1. Table "dbaliases"
2-2. Table "dbaliases"
3-1. Table "subscriber"
3-2. Table "subscriber"
4-1. Table "usr_preferences"
4-2. Table "usr_preferences"
5-1. Table "b2b_entities"
5-2. Table "b2b_entities"
5-3. Table "b2b_logic"
5-4. Table "b2b_logic"
6-1. Table "cachedb"
7-1. Table "carrierroute"
7-2. Table "carrierfailureroute"
7-3. Table "route_tree"
8-1. Table "closeddial"
8-2. Table "closeddial"
9-1. Table "cpl"
9-2. Table "cpl"
10-1. Table "dialog"
11-1. Table "dialplan"
12-1. Table "dispatcher"
13-1. Table "domain"
13-2. Table "domain"
14-1. Table "domainpolicy"
14-2. Table "domainpolicy"
15-1. Table "dr_gateways"
15-2. Table "dr_gateways"
15-3. Table "dr_rules"
15-4. Table "dr_carriers"
15-5. Table "dr_carriers"
15-6. Table "dr_groups"
17-1. Table "grp"
17-2. Table "grp"
17-3. Table "re_grp"
17-4. Table "re_grp"
18-1. Table "imc_rooms"
18-2. Table "imc_rooms"
18-3. Table "imc_members"
18-4. Table "imc_members"
19-1. Table "load_balancer"
19-2. Table "load_balancer"
20-1. Table "silo"
20-2. Table "silo"
21-1. Table "pdt"
21-2. Table "pdt"
22-1. Table "address"
23-1. Table "presentity"
23-2. Table "presentity"
23-3. Table "active_watchers"
23-4. Table "active_watchers"
23-5. Table "watchers"
23-6. Table "watchers"
23-7. Table "xcap"
23-8. Table "xcap"
23-9. Table "pua"
24-1. Table "registrant"
24-2. Table "registrant"
25-1. Table "aliases"
25-2. Table "aliases"
26-1. Table "rls_presentity"
26-2. Table "rls_presentity"
26-3. Table "rls_watchers"
26-4. Table "rls_watchers"
27-1. Table "rtpproxy_sockets"
28-1. Table "sip_trace"
28-2. Table "sip_trace"
29-1. Table "speed_dial"
29-2. Table "speed_dial"
30-1. Table "version"
30-2. Table "version"
31-1. Table "uri"
31-2. Table "uri"
32-1. Table "userblacklist"
32-2. Table "userblacklist"
32-3. Table "globalblacklist"
32-4. Table "globalblacklist"
33-1. Table "location"
33-2. Table "location"
This table is used by the ACC module to report on transactions - accounted calls. More information is available at: http://www.opensips.org/html/docs/modules/1.11.x/acc.html
This table is used by the ACC module for keeping track of missed calls. This table is similar to the 'acc' table. More information is available at: http://www.opensips.org/html/docs/modules/1.11.x/acc.html
Table 1-1. Table "acc"
| name | type | size | default | null | key | extra attributes | description |
|---|---|---|---|---|---|---|---|
id
| unsigned int
| 10
| default | no | primary | autoincrement | unique ID |
method
| string
| 16
| ' | no | A method is the primary function that a request is meant to invoke on a server. | ||
from_tag
| string
| 64
| ' | no | The tag parameter serves as a general mechanism to identify a dialog, which is the combination of the Call-ID along with two tags, one from participant in the dialog. | ||
to_tag
| string
| 64
| ' | no | The tag parameter serves as a general mechanism to identify a dialog, which is the combination of the Call-ID along with two tags, one from participant in the dialog. | ||
callid
| string
| 64
| ' | no | Call-ID header field uniquely identifies a particular invitation or all registrations of a particular client. | ||
sip_code
| string
| 3
| ' | no | SIP reply code | ||
sip_reason
| string
| 32
| ' | no | SIP reply reason | ||
time
| datetime
| not specified
| default | no | Date and time when this record was written. | ||
duration
| unsigned int
| 11
| 0 | no | Call duration (from 200OK INVITE to BYE request) - this filed is populated only if CDR support is enabled in ACC module (see cdr_flag parameter) | ||
setuptime
| unsigned int
| 11
| 0 | no | Call initialization duration - (from INVITE request to 200 OK INVITE) - this filed is populated only if CDR support is enabled in ACC module (see cdr_flag parameter) | ||
created
| datetime
| not specified
| NULL | yes | The call creation date and time. |
Table 1-3. Table "missed_calls"
| name | type | size | default | null | key | extra attributes | description |
|---|---|---|---|---|---|---|---|
id
| unsigned int
| 10
| default | no | primary | autoincrement | unique ID |
method
| string
| 16
| ' | no | A method is the primary function that a request is meant to invoke on a server. | ||
from_tag
| string
| 64
| ' | no | The tag parameter serves as a general mechanism to identify a dialog, which is the combination of the Call-ID along with two tags, one from participant in the dialog. | ||
to_tag
| string
| 64
| ' | no | The tag parameter serves as a general mechanism to identify a dialog, which is the combination of the Call-ID along with two tags, one from participant in the dialog. | ||
callid
| string
| 64
| ' | no | Call-ID header field uniquely identifies a particular invitation or all registrations of a particular client. | ||
sip_code
| string
| 3
| ' | no | SIP reply code | ||
sip_reason
| string
| 32
| ' | no | SIP reply reason | ||
time
| datetime
| not specified
| default | no | Date and time when this record was written. |
This table us used by the alias_db module as an alternative for user aliases via userloc. More information about the alias_db module can be found at: http://www.opensips.org/html/docs/modules/1.11.x/alias_db.html
Table 2-1. Table "dbaliases"
| name | type | size | default | null | key | extra attributes | description |
|---|---|---|---|---|---|---|---|
id
| unsigned int
| 10
| default | no | primary | autoincrement | unique ID |
alias_username
| string
| 64
| ' | no | Alias username / phone number | ||
alias_domain
| string
| 64
| ' | no | Alias domain name | ||
username
| string
| 64
| ' | no | Username / phone number | ||
domain
| string
| 64
| ' | no | Domain name |
This table is used to provide authentication information. More information about the auth_db module can be found at: http://www.opensips.org/html/docs/modules/1.11.x/auth_db.html
Table 3-1. Table "subscriber"
| name | type | size | default | null | key | extra attributes | description |
|---|---|---|---|---|---|---|---|
id
| unsigned int
| 10
| default | no | primary | autoincrement | Unique ID |
username
| string
| 64
| ' | no | Username / phone number | ||
domain
| string
| 64
| ' | no | Domain name | ||
password
| string
| 25
| ' | no | Password | ||
email_address
| string
| 64
| ' | no | Email address | ||
ha1
| string
| 64
| ' | no | md5(username:realm:password) | ||
ha1b
| string
| 64
| ' | no | md5(username@domain:realm:password) | ||
rpid
| string
| 64
| NULL | yes | The SIP Remote-Party-ID header identifies the calling party and includes user, party, screen and privacy headers that specify how a call is presented and screened. |
This table us used by the avpops module to implement Attribute Value Pairs (AVP's). More information about the avpops module can be found at: http://www.opensips.org/html/docs/modules/1.11.x/avpops.html
Table 4-1. Table "usr_preferences"
| name | type | size | default | null | key | extra attributes | description |
|---|---|---|---|---|---|---|---|
id
| unsigned int
| 10
| default | no | primary | autoincrement | Unique ID |
uuid
| string
| 64
| ' | no | Unique user ID | ||
username
| string
| 128
| 0 | no | Username / phone number | ||
domain
| string
| 64
| ' | no | Domain name | ||
attribute
| string
| 32
| ' | no | AVP attribute | ||
type
| int
| 11
| 0 | no | AVP type | ||
value
| string
| 128
| ' | no | AVP value | ||
last_modified
| datetime
| not specified
| '1900-01-01 00:00:01' | no | Date and time when this record was last modified. |
Table for the b2b_entities module. More information can be found at: http://www.opensips.org/html/docs/modules/1.11.x/b2b_entities.html
Table for the b2b_logic module. More information can be found at: http://www.opensips.org/html/docs/modules/1.11.x/b2b_logic.html
Table 5-1. Table "b2b_entities"
| name | type | size | default | null | key | extra attributes | description |
|---|---|---|---|---|---|---|---|
id
| unsigned int
| 10
| default | no | primary | autoincrement | Unique ID |
type
| int
| 2
| default | no | Entity type: 0-server, 1-client | ||
state
| int
| 2
| default | no | Dialog state | ||
ruri
| string
| 128
| default | yes | RURI(stored only for server entities to correctly match CANCEL) | ||
from_uri
| string
| 128
| default | no | From URI | ||
to_uri
| string
| 128
| default | no | To URI | ||
from_dname
| string
| 64
| default | yes | From display name | ||
to_dname
| string
| 64
| default | yes | To display name | ||
tag0
| string
| 64
| default | no | TO tag | ||
tag1
| string
| 64
| default | yes | From tag | ||
callid
| string
| 64
| default | no | Call ID | ||
cseq0
| int
| 11
| default | no | Cseq0 | ||
cseq1
| int
| 11
| default | yes | Cseq1 | ||
contact0
| string
| 128
| default | no | Contact0 | ||
contact1
| string
| 128
| default | yes | Contact1 | ||
route0
| text
| not specified
| default | yes | Record route 0 | ||
route1
| text
| not specified
| default | yes | Record route 1 | ||
sockinfo_srv
| string
| 64
| default | yes | Socket Info | ||
param
| string
| 128
| default | no | Logic parameter | ||
lm
| int
| 11
| default | no | Last method | ||
lrc
| int
| 11
| default | yes | Last reply code | ||
lic
| int
| 11
| default | yes | Last invite cseq | ||
leg_cseq
| int
| 11
| default | yes | Leg cseq | ||
leg_route
| text
| not specified
| default | yes | Leg route | ||
leg_tag
| string
| 64
| default | yes | Leg tag | ||
leg_contact
| string
| 128
| default | yes | Leg contact | ||
leg_sockinfo
| string
| 128
| default | yes | Leg sockinfo |
Table 5-2. Table "b2b_entities" indexes
| name | type | links | description |
|---|---|---|---|
b2b_entities_idx
| unique | type, tag0, tag1, callid |
|
b2b_entities_param
| default | param |
|
Table 5-3. Table "b2b_logic"
| name | type | size | default | null | key | extra attributes | description |
|---|---|---|---|---|---|---|---|
id
| unsigned int
| 10
| default | no | primary | autoincrement | Unique ID |
si_key
| string
| 64
| default | no | Scenario instantiation key | ||
scenario
| string
| 64
| default | no | Scenario id | ||
sstate
| int
| 2
| default | no | Scenario State | ||
next_sstate
| int
| 2
| default | no | Next Scenario State | ||
sparam0
| string
| 64
| default | yes | Scenario id | ||
sparam1
| string
| 64
| default | yes | Scenario id | ||
sparam2
| string
| 64
| default | yes | Scenario id | ||
sparam3
| string
| 64
| default | yes | Scenario id | ||
sparam4
| string
| 64
| default | yes | Scenario id | ||
sdp
| text
| 64
| default | yes | Scenario id | ||
lifetime
| int
| 10
| 0 | no | Lifetime | ||
e1_type
| int
| 2
| default | no | E1 type | ||
e1_sid
| string
| 64
| default | no | E1 Scenario ID | ||
e1_from
| string
| 128
| default | no | E1 From URI | ||
e1_to
| string
| 128
| default | no | E1 To URI | ||
e1_key
| string
| 64
| default | no | E1 Key | ||
e2_type
| int
| 2
| default | no | E2 type | ||
e2_sid
| string
| 64
| default | no | E2 Scenario ID | ||
e2_from
| string
| 128
| default | no | E2 From URI | ||
e2_to
| string
| 128
| default | no | E2 To URI | ||
e2_key
| string
| 64
| default | no | E2 Key | ||
e3_type
| int
| 2
| default | yes | E3 type | ||
e3_sid
| string
| 64
| default | yes | E3 Scenario ID | ||
e3_from
| string
| 128
| default | yes | E3 From URI | ||
e3_to
| string
| 128
| default | yes | E3 To URI | ||
e3_key
| string
| 64
| default | yes | E3 Key |
Persistent sca information for the b2b_sca module. More information can be found at: http://www.opensips.org/html/docs/modules/1.11.x/b2b_sca.html
Table 6-1. Table "b2b_sca"
| name | type | size | default | null | key | extra attributes | description |
|---|---|---|---|---|---|---|---|
id
| unsigned int
| 10
| default | no | primary | autoincrement | unique ID |
shared_line
| string
| 64
| default | no | The shared line. | ||
watchers
| string
| 255
| default | no | The URI list of watchers | ||
app1_shared_entity
| unsigned int
| 1
| NULL | yes | The entity to keep. | ||
app1_call_state
| unsigned int
| 1
| NULL | yes | &nbsnbsp; | The state of the appearance index. | |
app1_call_info_uri
| string
| 128
| NULL | yes | The URI of the Call-Info header | ||
app1_call_info_appearance_uri
| string
| 128
| NULL | yes | The URI of the appearance in Call-Info header | ||
app1_b2bl_key
| string
| 64
| NULL | yes | The b2b_logic key. | ||
app2_shared_entity
| unsigned int
| 1
| NULL | yes | The entity to keep. | ||
app2_call_state
| unsigned int
| 1
| NULL | yes | The state of the appearance index. | ||
app2_call_info_uri
| string
| 128
| NULL | yes | The URI of the Call-Info header | ||
app2_call_info_appearance_uri
| string
| 128
| NULL | yes | The URI of the appearance in Call-Info header | ||
app2_b2bl_key
| string
| 64
| NULL | yes | The b2b_logic key. | ||
app3_shared_entity
| unsigned int
| 1
| NULL | yes | The entity to keep. | ||
app3_call_state
| unsigned int
| 1
| NULL | yes | The state of the appearance index. | ||
app3_call_info_uri
| string
| 128
| NULL | yes | The URI of the Call-Info header | ||
app3_call_info_appearance_uri
| string
| 128
| NULL | yes | The URI of the appearance in Call-Info header | ||
app3_b2bl_key
| string
| 64
| NULL | yes | The b2b_logic key. | ||
app4_shared_entity
| unsigned int
| 1
| NULL | yes | The entity to keep. | ||
app4_call_state
| unsigned int
| 1
| NULL | yes | The state of the appearance index. | ||
app4_call_info_uri
| string
| 128
| NULL | yes | The URI of the Call-Info header | ||
app4_call_info_appearance_uri
| string
| 128
| NULL | yes | The URI of the appearance in Call-Info header | ||
app4_b2bl_key
| string
| 64
| NULL | yes | The b2b_logic key. | ||
app5_shared_entity
| unsigned int
| 1
| NULL | yes | The entity to keep. | ||
app5_call_state
| unsigned int
| 1
| NULL | yes | The state of the appearance index. | ||
app5_call_info_uri
| string
| 128
| NULL | yes | The URI of the Call-Info header | ||
app5_call_info_appearance_uri
| string
| 128
| NULL | yes | The URI of the appearance in Call-Info header | ||
app5_b2bl_key
| string
| 64
| NULL | yes | The b2b_logic key. | ||
app6_shared_entity
| unsigned int
| 1
| NULL | yes | The entity to keep. | ||
app6_call_state
| unsigned int
| 1
| NULL | yes | The state of the appearance index. | ||
app6_call_info_uri
| string
| 128
| NULL | yes | The URI of the Call-Info header | ||
app6_call_info_appearance_uri
| string
| 128
| NULL | yes | The URI of the appearance in Call-Info header | ||
app6_b2bl_key
| string
| 64
| NULL | yes | The b2b_logic key. | ||
app7_shared_entity
| unsigned int
| 1
| NULL | yes | The entity to keep. | ||
app7_call_state
| unsigned int
| 1
| NULL | yes | The state of the appearance index. | ||
app7_call_info_uri
| string
| 128
| NULL | yes | The URI of the Call-Info header | ||
app7_call_info_appearance_uri
| string
| 128
| NULL | yes | The URI of the appearance in Call-Info header | ||
app7_b2bl_key
| string
| 64
| NULL | yes | The b2b_logic key. | ||
app8_shared_entity
| unsigned int
| 1
| NULL | yes | The entity to keep. | ||
app8_call_state
| unsigned int
| 1
| NULL | yes | The state of the appearance index. | ||
app8_call_info_uri
| string
| 128
| NULL | yes | The URI of the Call-Info header | ||
app8_call_info_appearance_uri
| string
| 128
| NULL | yes | The URI of the appearance in Call-Info header | ||
app8_b2bl_key
| string
| 64
| NULL | yes | The b2b_logic key. | ||
app9_shared_entity
| unsigned int
| 1
| NULL | yes | The entity to keep. | ||
app9_call_state
| unsigned int
| 1
| NULL | yes | The state of the appearance index. | ||
app9_call_info_uri
| string
| 128
| NULL | yes | The URI of the Call-Info header | ||
app9_call_info_appearance_uri
| string
| 128
| NULL | yes | The URI of the appearance in Call-Info header | ||
app9_b2bl_key
| string
| 64
| NULL | yes | The b2b_logic key. | ||
app10_shared_entity
| unsigned int
| 1
| NULL | yes | The entity to keep. | ||
app10_call_state
| unsigned int
| 1
| NULL | yes | The state of the appearance index. | ||
app10_call_info_uri
| string
| 128
| NULL | yes | The URI of the Call-Info header | ||
app10_call_info_appearance_uri
| string
| 128
| NULL | yes | The URI of the appearance in Call-Info header | ||
app10_b2bl_key
| string
| 64
| NULL | yes | The b2b_logic key. |
DB implementation of the CacheDB interface: http://www.opensips.org/html/docs/modules/1.11.x/cachedb_sql.html
This table is used by the Call Center module to store the definition of the call queues / flows. More information can be found at: http://www.opensips.org/html/docs/modules/1.11.x/call_center.html.
This table is used by the Call Center module to store the definition of the agents serving the flows/queues. More information can be found at: http://www.opensips.org/html/docs/modules/1.11.x/call_center.html.
This table is used by the Call Center module to store the Call Data Records (CDRs) for all the handled calls. More information can be found at: http://www.opensips.org/html/docs/modules/1.11.x/call_center.html.
This table is used by the Call Center module to store ongoing calls for restart persitancy. It consists only of runtime data and should not be manually provisioned. More information can be found at: http://www.opensips.org/html/docs/modules/1.11.x/call_center.html.
Table 8-1. Table "cc_flows"
| name | type | size | default | null | key | extra attributes | description |
|---|---|---|---|---|---|---|---|
id
| unsigned int
| 10
| default | no | primary | autoincrement | Flow unique ID in DB |
flowid
| string
| 64
| default | no | The unique ID of the flow in the Call Center module - to be used to identify the flow/queue in the module and from outside the module; It is an alphanumerical string. | ||
priority
| unsigned int
| 11
| 256 | no | The priority of the flow (in relation to the other flows); 0 is maximum priority and calls for this flow will be processed first all the time. | ||
skill
| string
| 64
| default | no | The skill required from an agent in order to receive calls from this flow/queue. | ||
prependcid
| string
| 32
| default | no | Aphanumerical prefix to be added to the caller displayname when sending calls from this flow to agents (so agent - serving muliple flows - can see what was the flow the call was received on. | ||
message_welcome
| string
| 128
| NULL | yes | SIP URI point to a media server; this is used for playing the welcome message for this flow. | ||
message_queue
| string
| 128
| default | no | SIP URI point to a media server; this is used for playing the onhold message for this flow. IMPORTANT - this message must cycle and media server must never hung up on it. |
Table 8-3. Table "cc_agents"
| name | type | size | default | null | key | extra attributes | description |
|---|---|---|---|---|---|---|---|
id
| unsigned int
| 10
| default | no | primary | autoincrement | Agent unique ID in DB |
agentid
| string
| 128
| default | no | The unique ID of the agent in the Call Center module - to be used to identify the agent in the module and from outside the module; It is an alphanumerical string. | ||
location
| string
| 128
| default | no | SIP URI point to the agent location; All calls for this agents will be sent to this SIP address. | ||
logstate
| unsigned int
| 10
| 0 | no | The login state of the agent; 0 - not logged in; 1 - logged in ; Agent will start receiving calls only if logged in. | ||
skills
| string
| 255
| default | no | Comma separated list of skills offered by the agent; these skills must match the skills used in the queues/flows definition; In order to receive calls from a flow, the agent must have the skill required by that flow. | ||
last_call_end
| int
| 11
| 0 | no | The timestamp of the last call of an agent. If different than 0, the agent will only receive calls after wrapup seconds pass after this timestamp. |
Table 8-5. Table "cc_cdrs"
| name | type | size | default | null | key | extra attributes | description |
|---|---|---|---|---|---|---|---|
id
| unsigned int
| 10
| default | no | primary | autoincrement | CDR unique ID in DB |
caller
| string
| 64
| default | no | The SIP URI identifing the caller. | ||
received_timestamp
| datetime
| not specified
| default | no | When the call was received. | ||
wait_time
| unsigned int
| 11
| 0 | no | Time (in seconds) spent by the call in queue (onhold). | ||
pickup_time
| unsigned int
| 11
| 0 | no | Time (in seconds) spent by the call in ringing to the agent. | ||
talk_time
| unsigned int
| 11
| 0 | no | The duration (in seconds) of the call. | ||
flow_id
| string
| 128
| default | no | The ID of the flow the call was received on. | ||
agent_id
| string
| 128
| NULL | yes | The ID of the agent who picked this call (if any). | ||
call_type
| int
| 11
| -1 | no | Type of call: -2 - call rejected by agent; -1 - call dropped because of internal error; 0 - call handled by agent; 1 - call dropped while in queue; | ||
rejected
| unsigned int
| 11
| 0 | no | How many times the call was rejected by agents (agent not answering his phone). | ||
fstats
| unsigned int
| 11
| 0 | no | Bitmask of the following binary flags: 0 - it is inbound call; 1 - call was distributed to agents; 2 - call was answered; 3 - call was abandoned. | ||
cid
| unsigned int
| 11
| 0 | yes | Sequence number of the call. |
Table 8-6. Table "cc_calls"
| name | type | size | default | null | key | extra attributes | description |
|---|---|---|---|---|---|---|---|
id
| unsigned int
| 10
| default | no | autoincrement | unique ID of the call. | |
state
| int
| 11
| default | no | The state of the call. | ||
ig_cback
| int
| 11
| default | no | Indicates if the call should be ignored. | ||
no_rej
| int
| 11
| default | no | Indicates whether the call can be rejected or not. | ||
setup_time
| int
| 11
| default | no | Stores the call setup time. | ||
eta
| int
| 11
| default | no | The estimated wait time for a call until it is answered by an agent. | ||
last_start
| int
| 11
| default | no | Stores the timestamp when the last call has started. | ||
recv_time
| int
| 11
| default | no | Stores the timestamp when the call was received by the call center. | ||
caller_dn
| string
| 128
| default | no | Caller Display Name. | ||
caller_un
| string
| 128
| default | no | Caller User Name. | ||
b2buaid
| string
| 128
| ' | no | primary | The B2B id internally used by the B2B module to identify the call. | |
flow
| string
| 128
| default | no | The flow/queue this call belongs to. | ||
agent
| string
| 128
| default | no | The agent that handles the call. |
This table is used by the carrierroute module to provides routing, balancing and blacklisting capabilities. More information is available at: http://www.opensips.org/html/docs/modules/1.11.x/carrierroute.html
This table is used by the carrierroute module to provide failure routing capabilities. More information is available at: http://www.opensips.org/html/docs/modules/1.11.x/carrierroute.html
This table is used by the carrierroute module to provides routing, balancing and blacklisting capabilities. More information is available at: http://www.opensips.org/html/docs/modules/1.11.x/carrierroute.html
Table 9-1. Table "carrierroute"
| name | type | size | default | null | key | extra attributes | description |
|---|---|---|---|---|---|---|---|
id
| unsigned int
| 10
| default | no | primary | autoincrement | unique ID |
carrier
| unsigned int
| 10
| 0 | no | This column contains the carrier id. | ||
domain
| string
| 64
| ' | no | This column contains the route domain. Additional domains could be used for example as fallback. | ||
scan_prefix
| string
| 64
| ' | no | This column contains the scan prefix, which define the matching portion of a phone number. | ||
flags
| unsigned int
| 11
| 0 | no | This column contains the flags used for rule matching. | ||
mask
| unsigned int
| 11
| 0 | no | This column contains the mask that is applied to the message flags before rule matching. | ||
prob
| float
| not specified
| 0 | no | Name of column containing the probability. The probability value is used to distribute the traffic between several gateways. | ||
strip
| unsigned int
| 11
| 0 | no | Name of the column containing the number of digits to be stripped of the userpart of an URI before prepending rewrite_prefix. | ||
rewrite_host
| string
| 128
| ' | no | Name of column containing rewrite prefixes. Here you can define a rewrite prefix for the localpart of the SIP URI. | ||
rewrite_prefix
| string
| 64
| ' | no | Rewrite prefix for the localpart of the SIP URI. | ||
rewrite_suffix
| string
| 64
| ' | no | Rewrite suffix for the localpart of the SIP URI. | ||
description
| string
| 255
| NULL | yes | A comment for the route entry, useful for larger routing tables. |
Table 9-2. Table "carrierfailureroute"
| name | type | size | default | null | key | extra attributes | description |
|---|---|---|---|---|---|---|---|
id
| unsigned int
| 10
| default | no | primary | autoincrement | unique ID |
carrier
| unsigned int
| 10
| 0 | no | This column contains the carrier id. | ||
domain
| string
| 64
| ' | no | This column contains the route domain. Additional domains could be used for example as fallback. | ||
scan_prefix
| string
| 64
| ' | no | This column contains the scan prefix, which define the matching portion of a phone number. | ||
host_name
| string
| 128
| ' | no | This column contains the routing destination used for rule matching. | ||
reply_code
| string
| 3
| ' | no | This column contains the reply code used for rule matching. | ||
flags
| unsigned int
| 11
| 0 | no | This column contains the flags used for rule matching. | ||
mask
| unsigned int
| 11
| 0 | no | This column contains the mask that is applied to the message flags before rule matching. | ||
next_domain
| string
| 64
| ' | no | This column contains the route domain that should be used for the next routing attempt. | ||
description
| string
| 255
| NULL | yes | A comment for the route entry, useful for larger routing tables. |
This table is used by the closeddial module to provide closed dial functionality for groups of usernames; This is a functionality similar to a Centrex. More information about the closeddial module can be found at: http://www.opensips.org/html/docs/modules/1.11.x/closeddial.html
Table 10-1. Table "closeddial"
| name | type | size | default | null | key | extra attributes | description |
|---|---|---|---|---|---|---|---|
id
| unsigned int
| 10
| default | no | primary | autoincrement | unique ID |
username
| string
| 64
| ' | no | Username / phone number | ||
domain
| string
| 64
| ' | no | Domain name | ||
cd_username
| string
| 64
| ' | no | Closed dial username | ||
cd_domain
| string
| 64
| ' | no | Closed dial domain | ||
group_id
| string
| 64
| ' | no | Attribute use to group usernames | ||
new_uri
| string
| 128
| ' | no | New URI |
Table for the call processing language "cpl" module. More information is available at: http://www.opensips.org/html/docs/modules/1.11.x/cpl-c.html
Persistent dialog information for the dialog module. More information can be found at: http://www.opensips.org/html/docs/modules/1.11.x/dialog.html
Table 12-1. Table "dialog"
| name | type | size | default | null | key | extra attributes | description |
|---|---|---|---|---|---|---|---|
dlg_id
| unsigned long
| 10
| default | no | primary | h_entry | h_id | |
callid
| string
| 255
| default | no | Call-ID of the dialog | ||
from_uri
| string
| 128
| default | no | The URI of the FROM header (as per INVITE) | ||
from_tag
| string
| 64
| default | no | The tag parameter serves as a general mechanism to identify a dialog, which is the combination of the Call-ID along with two tags, one from participant in the dialog. | ||
to_uri
| string
| 128
| default | no | The URI of the TO header (as per INVITE) | ||
to_tag
| string
| 64
| default | no | The tag parameter serves as a general mechanism to identify a dialog, which is the combination of the Call-ID along with two tags, one from participant in the dialog. | ||
mangled_from_uri
| string
| 64
| NULL | yes | The mangled from URI, in case uac_replace_from was called for this dialog. | ||
mangled_to_uri
| string
| 64
| NULL | yes | The mangled to URI, in case uac_replace_to was called for this dialog | ||
caller_cseq
| string
| 11
| default | no | Last Cseq number on the caller side. | ||
callee_cseq
| string
| 11
| default | no | Last Cseq number on the callee side. | ||
caller_ping_cseq
| unsigned int
| 11
| default | no | Last Cseq number of pings generated on caller side. | ||
callee_ping_cseq
| unsigned int
| 11
| default | no | Last Cseq number of pings generated on callee side. | ||
caller_route_set
| text
| 512
| default | yes | Route set on the caller side. | ||
callee_route_set
| text
| 512
| default | yes | Route set on on the caller side. | ||
caller_contact
| string
| 128
| default | no | Caller's contact uri. | ||
callee_contact
| string
| 128
| default | no | Callee's contact uri. | ||
caller_sock
| string
| 64
| default | no | Local socket used to communicate with caller | ||
callee_sock
| string
| 64
| default | no | Local socket used to communicate with callee | ||
state
| unsigned int
| 10
| default | no | The state of the dialog. | ||
start_time
| unsigned int
| 10
| default | no | The timestamp (unix time) when the dialog was confirmed. | ||
timeout
| unsigned int
| 10
| default | no | The timestamp (unix time) when the dialog will expire. | ||
vars
| binary
| 4096
| NULL | yes | Variables attached to this dialog. | ||
profiles
| text
| 512
| NULL | yes | Profiles this dialog belongs to. | ||
script_flags
| unsigned int
| 10
| 0 | no | Script flags for the dialog. | ||
flags
| unsigned int
| 10
| 0 | no | Internal flags used by the module. |
This table is used by the dialplan module for the translation rules. More information is available at: http://www.opensips.org/html/docs/modules/1.11.x/dialplan.html
Table 13-1. Table "dialplan"
| name | type | size | default | null | key | extra attributes | description |
|---|---|---|---|---|---|---|---|
id
| unsigned int
| 10
| default | no | primary | autoincrement | unique ID |
dpid
| int
| 11
| default | no | Dialplan ID. | ||
pr
| int
| 11
| default | no | Priority of rule. | ||
match_op
| int
| 11
| default | no | Matching operator for rule (0-equal, 1-regexp). | ||
match_exp
| string
| 64
| default | no | Matching expresion (regexp or string). | ||
match_flags
| int
| 11
| default | no | Matching flags (0-case sensitive, 1-case insensitive). | ||
subst_exp
| string
| 64
| default | no | Substitution expresion. | ||
repl_exp
| string
| 32
| default | no | Replacement expresion (sed like). | ||
disabled
| int
| 11
| 0 | no | Specifies if the command can be used, or is disabled. | ||
attrs
| string
| 32
| default | no | General attributes string to be returned in case of rule matching. |
This table is used by the dispatcher module. It contains the sets of destinations used for load balancing and dispatching. More information about the dispatcher module can be found at: http://www.opensips.org/html/docs/modules/1.11.x/dispatcher.html
Table 14-1. Table "dispatcher"
| name | type | size | default | null | key | extra attributes | description |
|---|---|---|---|---|---|---|---|
id
| unsigned int
| 10
| default | no | primary | autoincrement | unique ID |
setid
| int
| not specified
| 0 | no | Destination set id | ||
destination
| string
| 192
| ' | no | Destination SIP address | ||
socket
| string
| 128
| NULL | yes | Local Socket to be used when sending requests (traffic and probes) to the destination - must be an listener configured in opensips. | ||
state
| int
| not specified
| 0 | no | The state of the destination (0 enabled, 1 disabled , 2 probing) | ||
weight
| int
| not specified
| 1 | no | The weight of the destination | ||
attrs
| string
| 128
| ' | no | Attribute string - custom, opaque string that will be pushed into script when this destination will be selected | ||
description
| string
| 64
| ' | no | Description for this destination |
This table is used by the domain module to determine if a host part of a URI is "local" or not. More information about the domain module can be found at: http://www.opensips.org/html/docs/modules/1.11.x/domain.html
Table for the domainpolicy module. More information at http://www.opensips.org/html/docs/modules/1.11.x/domainpolicy.html.
Table 16-1. Table "domainpolicy"
| name | type | size | default | null | key | extra attributes | description |
|---|---|---|---|---|---|---|---|
id
| unsigned int
| 10
| default | no | primary | autoincrement | unique ID |
rule
| string
| 255
| default | no | Domain policy rule name which is equal to the URI as published in the domain policy NAPTRs. | ||
type
| string
| 255
| default | no | Domain policy rule type. In the case of federation names, this is "fed". For standard referrals according to draft-lendl-speermint-technical-policy-00, this is "std". For direct domain lookups, this is "dom". Default value is "type". | ||
att
| string
| 255
| default | yes | It contains the AVP's name. If the rule stored in this row triggers, than dp_can_connect() will add an AVP with that name. | ||
val
| string
| 128
| default | yes | It contains the values for AVPs created by dp_can_connect(). Default value is "val" | ||
description
| string
| 255
| default | no | Comment about the rule |
This table is used by the Dynamic Routing module to store information about the destinations/gateways where to route calls. More information can be found at: http://www.opensips.org/html/docs/modules/1.11.x/drouting.html.
This table is used by the Dynamic Routing module to store information about the routing rules. More information can be found at: http://www.opensips.org/html/docs/modules/1.11.x/drouting.html.
This table is used by the Dynamic Routing module to define carriers (a carrier is defined by a list of gateways and an ordering rule). More information can be found at: http://www.opensips.org/html/docs/modules/1.11.x/drouting.html.
This table is used by the Dynamic Routing module to store information about the routing groups (users mapped over groups). More information can be found at: http://www.opensips.org/html/docs/modules/1.11.x/drouting.html.
Table 17-1. Table "dr_gateways"
| name | type | size | default | null | key | extra attributes | description |
|---|---|---|---|---|---|---|---|
id
| unsigned int
| 10
| default | no | primary | autoincrement | Table primary key, not used by module |
gwid
| string
| 64
| default | no | GW unique ID - used to link the GW from the routing rules | ||
type
| unsigned int
| 11
| 0 | no | Type/class of the GW (user defined) | ||
address
| string
| 128
| default | no | GW/destination address as name/IP[:port] | ||
strip
| unsigned int
| 11
| 0 | no | Number of digits to be striped out for the begining of the username when using this GW/destination | ||
pri_prefix
| string
| 16
| NULL | yes | String to prefix the username of RURI when using this GW/destination | ||
attrs
| string
| 255
| NULL | yes | Generic string describing GW attributes - this string is to be interpreted from the script | ||
probe_mode
| unsigned int
| 11
| 0 | no | 0- No probing; 1-Probe on disable only ; 2-Always probe; | ||
state
| unsigned int
| 11
| 0 | no | State of the gateway: 0 - enabled; 1 - permanent disabled; 2 - temporary disabled (probing) | ||
socket
| string
| 128
| NULL | yes | Local Socket to be used when sending requests (traffic and probes) to the destination - must be an listener configured in opensips. | ||
description
| string
| 128
| ' | no | Text description of the GW/destination |
Table 17-3. Table "dr_rules"
| name | type | size | default | null | key | extra attributes | description |
|---|---|---|---|---|---|---|---|
ruleid
| unsigned int
| 10
| default | no | primary | autoincrement | Rule unique ID |
groupid
| string
| 255
| default | no | The ID(s) of the routing group(s) this rule is to be used for - comma separeted list of numerical Ids | ||
prefix
| string
| 64
| default | no | Numerical prefix to match this rule | ||
timerec
| string
| 255
| default | no | Time recurrence used for matching this rule. | ||
priority
| int
| 11
| 0 | no | Priority of this rule (among rules with same prefix and timerec). | ||
routeid
| string
| 255
| NULL | yes | Route block (from cfg script) to be called when rule matches. | ||
gwlist
| string
| 255
| default | no | Reference to the GWs/destinations to be used when rule matches. | ||
attrs
| string
| 255
| NULL | yes | Generic string describing RULE attributes - this string is to be interpreted from the script | ||
description
| string
| 128
| ' | no | Text description of the rule |
Table 17-4. Table "dr_carriers"
| name | type | size | default | null | key | extra attributes | description |
|---|---|---|---|---|---|---|---|
id
| unsigned int
| 10
| default | no | primary | autoincrement | Table key, not used by module |
carrierid
| string
| 64
| default | no | Unique ID of the carrier | ||
gwlist
| string
| 255
| default | no | Reference to the GWs/destinations from the list. | ||
flags
| unsigned int
| 11
| 0 | no | Flags (for different purposes) of the carriers | ||
state
| unsigned int
| 11
| 0 | no | The state of the carrier (on / off). | ||
attrs
| string
| 255
| ' | yes | Attributes string for the carrier | ||
description
| string
| 128
| ' | no | Text description of the GW list |
Table 17-6. Table "dr_groups"
| name | type | size | default | null | key | extra attributes | description |
|---|---|---|---|---|---|---|---|
id
| unsigned int
| 10
| default | no | primary | autoincrement | Unique ID |
username
| string
| 64
| default | no | Username part of user | ||
domain
| string
| 128
| ' | no | Domain part of user | ||
groupid
| unsigned int
| 11
| 0 | no | The ID of the routing group the user belongs to. | ||
description
| string
| 128
| ' | no | Text description of the group/user |
This table us used by the group module as a means of group membership checking. Used primarily for Access Control Lists (ACL's). More information about the group module can be found at: http://www.opensips.org/html/docs/modules/1.11.x/group.html
This table is used by the group module to check membership based on regular expressions. More information about the group module can be found at: http://www.opensips.org/html/docs/modules/1.11.x/group.html
Table 19-1. Table "grp"
| name | type | size | default | null | key | extra attributes | description |
|---|---|---|---|---|---|---|---|
id
| unsigned int
| 10
| default | no | primary | autoincrement | unique ID |
username
| string
| 64
| ' | no | Username / phone number | ||
domain
| string
| 64
| ' | no | Domain name | ||
grp
| string
| 64
| ' | no | Group name | ||
last_modified
| datetime
| not specified
| '1900-01-01 00:00:01' | no | Date and time when this record was last modified. |
Table 19-2. Table "grp" indexes
| name | type | links | description |
|---|---|---|---|
account_group_idx
| unique | username, domain, grp |
|
Room table for the IMC module. More information at http://www.opensips.org/html/docs/modules/1.11.x/imc.html.
Member table for the IMC module. More information at http://www.opensips.org/html/docs/modules/1.11.x/imc.html.
Table 20-1. Table "imc_rooms"
| name | type | size | default | null | key | extra attributes | description |
|---|---|---|---|---|---|---|---|
id
| unsigned int
| 10
| default | no | primary | autoincrement | unique ID |
name
| string
| 64
| default | no | Name of the room | ||
domain
| string
| 64
| default | no | Domain of the room | ||
flag
| int
| 11
| default | no | Flags |
This table is used by the Load-Balancer module to store information about the destinations the balance the calls between. More information can be found at: http://www.opensips.org/html/docs/modules/1.11.x/load_balancer.html.
Table 21-1. Table "load_balancer"
| name | type | size | default | null | key | extra attributes | description |
|---|---|---|---|---|---|---|---|
id
| unsigned int
| 10
| default | no | primary | autoincrement | unique ID of the destination |
group_id
| unsigned int
| 11
| 0 | no | The group the destination belongs to | ||
dst_uri
| string
| 128
| default | no | Destination address as a SIP URI | ||
resources
| string
| 255
| default | no | String with the definition of the resource provided by the destination and the capacity of each resource | ||
probe_mode
| unsigned int
| 11
| 0 | no | Probing mode (0-none, 1-if disabled, 2-all the time) | ||
description
| string
| 128
| ' | no | Text description of the destination |
This table us used by the msilo module to provide offline message storage More information about the msilo module can be found at: http://www.opensips.org/html/docs/modules/1.11.x/msilo.html
Table 22-1. Table "silo"
| name | type | size | default | null | key | extra attributes | description |
|---|---|---|---|---|---|---|---|
id
| unsigned int
| 10
| default | no | primary | autoincrement | unique ID |
src_addr
| string
| 128
| ' | no | Source address - From URI | ||
dst_addr
| string
| 128
| ' | no | Destination address - To URI | ||
username
| string
| 64
| ' | no | SIP domain of target user | ||
domain
| string
| 64
| ' | no | Username / phone number of target user | ||
inc_time
| int
| not specified
| 0 | no | Incoming time | ||
exp_time
| int
| not specified
| 0 | no | Expiration time | ||
snd_time
| int
| not specified
| 0 | no | Reminder send time | ||
ctype
| string
| 255
| NULL | yes | Content type | ||
body
| binary
| not specified
| NULL | yes | Body of the message |
Prefix-Domain Translation means to change the host and port in R-URI, based on the prefix found in R-URI and source domain (that is domain in From-URI). More information can be found at: http://www.opensips.org/html/docs/modules/1.11.x/pdt.html
Table 23-1. Table "pdt"
| name | type | size | default | null | key | extra attributes | description |
|---|---|---|---|---|---|---|---|
id
| unsigned int
| 10
| default | no | primary | autoincrement | Unique ID |
sdomain
| string
| 128
| default | no | Source domain | ||
prefix
| string
| 32
| default | no | Prefix found in the username part of R-URI. | ||
domain
| string
| 128
| ' | no | Domain corresponding to (sdomain, prefix) pair where the message must be sent. |
This table is used by the permissions module. More information is available at: http://www.opensips.org/html/docs/modules/1.11.x/permissions.html
Table 24-1. Table "address"
| name | type | size | default | null | key | extra attributes | description |
|---|---|---|---|---|---|---|---|
id
| unsigned int
| 10
| default | no | primary | autoincrement | unique ID |
grp
| unsigned short
| 5
| 0 | no | Group | ||
ip
| string
| 50
| default | no | IP address | ||
mask
| char
| not specified
| 32 | no | Network mask | ||
port
| unsigned short
| 5
| 0 | no | Port | ||
proto
| string
| 4
| 'any' | no | Transport protocol is either "any" or equal to transport protocol of request. Possible values that can be stored are "any", "udp", "tcp", "tls", and "sctp". | ||
pattern
| string
| 64
| NULL | yes | Regular expression | ||
context_info
| string
| 32
| NULL | yes | Extra context information |
Table for the presence module. More information can be found at: http://www.opensips.org/html/docs/modules/1.11.x/presence.html
Table for the presence module. More information can be found at: http://www.opensips.org/html/docs/modules/1.11.x/presence.html
Table for the presence module. More information can be found at: http://www.opensips.org/html/docs/modules/1.11.x/presence.html
Table for the presence module. More information can be found at: http://www.opensips.org/html/docs/modules/1.11.x/presence.html
Table for the presence related pua module. More information can be found at: http://www.opensips.org/html/docs/modules/1.11.x/pua.html
Table 25-1. Table "presentity"
| name | type | size | default | null | key | extra attributes | description |
|---|---|---|---|---|---|---|---|
id
| unsigned int
| 10
| default | no | primary | autoincrement | Unique ID |
username
| string
| 64
| default | no | User name | ||
domain
| string
| 64
| default | no | Domain | ||
event
| string
| 64
| default | no | Event | ||
etag
| string
| 64
| default | no | User name | ||
expires
| int
| 11
| default | no | Expires | ||
received_time
| int
| 11
| default | no | Reveived time | ||
body
| binary
| not specified
| default | no |
| ||
extra_hdrs
| binary
| not specified
| ' | no |
| ||
sender
| string
| 128
| default | no | Sender contact |
Table 25-2. Table "presentity" indexes
| name | type | links | description |
|---|---|---|---|
presentity_idx
| unique | username, domain, event, etag |
|
Table 25-3. Table "active_watchers"
| name | type | size | default | null | key | extra attributes | description |
|---|---|---|---|---|---|---|---|
id
| unsigned int
| 10
| default | no | primary | autoincrement | Unique ID |
presentity_uri
| string
| 128
| default | no | Presence URI | ||
watcher_username
| string
| 64
| default | no | From User | ||
watcher_domain
| string
| 64
| default | no | From Domain | ||
to_user
| string
| 64
| default | no | To User | ||
to_domain
| string
| 64
| default | no | To Domain | ||
event
| string
| 64
| 'presence' | no | Event description | ||
event_id
| string
| 64
| default | yes | Event ID | ||
to_tag
| string
| 64
| default | no | TO tag | ||
from_tag
| string
| 64
| default | no | From tag | ||
callid
| string
| 64
| default | no | Call ID | ||
local_cseq
| int
| 11
| default | no | Local cseq | ||
remote_cseq
| int
| 11
| default | no | Remote cseq | ||
contact
| string
| 128
| default | no | Contact | ||
record_route
| text
| not specified
| default | yes | Record route | ||
expires
| int
| 11
| default | no | Expires | ||
status
| int
| 11
| 2 | no | Status | ||
reason
| string
| 64
| default | no | Reason | ||
version
| int
| 11
| 0 | no | Version | ||
socket_info
| string
| 64
| default | no | Socket info | ||
local_contact
| string
| 128
| default | no | Local contact |
Table 25-4. Table "active_watchers" indexes
| name | type | links | description |
|---|---|---|---|
active_watchers_idx
| unique | presentity_uri, callid, to_tag, from_tag |
|
Table 25-5. Table "watchers"
| name | type | size | default | null | key | extra attributes | description |
|---|---|---|---|---|---|---|---|
id
| unsigned int
| 10
| default | no | primary | autoincrement | Unique ID |
presentity_uri
| string
| 128
| default | no | Presentity Uri | ||
watcher_username
| string
| 64
| default | no | Watcher User | ||
watcher_domain
| string
| 64
| default | no | Watcher Domain | ||
event
| string
| 64
| 'presence' | no | Event description | ||
status
| int
| 11
| default | no | Status | ||
reason
| string
| 64
| default | yes | Reason | ||
inserted_time
| int
| 11
| default | no |
|
Table 25-6. Table "watchers" indexes
| name | type | links | description |
|---|---|---|---|
watcher_idx
| unique | presentity_uri, watcher_username, watcher_domain, event |
|
Table 25-7. Table "xcap"
| name | type | size | default | null | key | extra attributes | description |
|---|---|---|---|---|---|---|---|
id
| unsigned int
| 10
| default | no | primary | autoincrement | Unique ID |
username
| string
| 64
| default | no | User name | ||
domain
| string
| 64
| default | no | Domain | ||
doc
| binary
| not specified
| default | no | doc | ||
doc_type
| int
| 11
| default | no | Document type | ||
etag
| string
| 64
| default | no | Document Etag | ||
source
| int
| 11
| default | no | Entity inserting the record | ||
doc_uri
| string
| 128
| default | no | Document uri | ||
port
| int
| 11
| default | no | XCAP server port |
Table 25-8. Table "xcap" indexes
| name | type | links | description |
|---|---|---|---|
account_doc_type_idx
| unique | username, domain, doc_type, doc_uri |
|
source_idx
| default | source |
|
Table 25-9. Table "pua"
| name | type | size | default | null | key | extra attributes | description |
|---|---|---|---|---|---|---|---|
id
| unsigned int
| 10
| default | no | primary | autoincrement | Unique ID |
pres_uri
| string
| 128
| default | no | URI | ||
pres_id
| string
| 255
| default | no | ID | ||
event
| int
| 11
| default | no | Event | ||
expires
| int
| 11
| default | no | Expires | ||
desired_expires
| int
| 11
| default | no | Desired Expires | ||
flag
| int
| 11
| default | no | Flags | ||
etag
| string
| 64
| default | yes | Etag | ||
tuple_id
| string
| 64
| default | yes | Tuple ID | ||
watcher_uri
| string
| 128
| default | yes | Watcher URI | ||
to_uri
| string
| 128
| default | yes | URI | ||
call_id
| string
| 64
| default | yes | Call ID | ||
to_tag
| string
| 64
| default | yes | To tag | ||
from_tag
| string
| 64
| default | yes | From tag | ||
cseq
| int
| 11
| default | yes |
| ||
record_route
| text
| not specified
| default | yes | Record route | ||
contact
| string
| 128
| default | yes | Contact | ||
remote_contact
| string
| 128
| default | yes | Remote contact | ||
version
| int
| 11
| default | yes |
| ||
extra_headers
| text
| not specified
| default | yes | Extra Headers |
Registrant information for the uac_registrant module. More information can be found at: http://www.opensips.org/html/docs/modules/1.11.x/uac_registrant.html
Table 26-1. Table "registrant"
| name | type | size | default | null | key | extra attributes | description |
|---|---|---|---|---|---|---|---|
id
| unsigned int
| 10
| default | no | primary | autoincrement | unique ID |
registrar
| string
| 128
| ' | no | URI pointing to the remote registrar. | ||
proxy
| string
| 128
| NULL | yes | URI pointing to the outbond proxy. | ||
aor
| string
| 128
| ' | no | URI defining the address of record. | ||
third_party_registrant
| string
| 128
| NULL | yes | URI defining the third party registrant. | ||
username
| string
| 64
| NULL | yes | Username for authentication. | ||
password
| string
| 64
| NULL | yes | Password for authentication. | ||
binding_URI
| string
| 128
| ' | no | Contact URI in REGISTER. | ||
binding_params
| string
| 64
| NULL | yes | Contact params in REGISTER. | ||
expiry
| unsigned int
| 1
| NULL | yes | Expiration time. | ||
forced_socket
| string
| 64
| NULL | yes | socket for sending the REGISTER. |
This table for the registrar module is similar to the "location" table, (the aliases index makes lookup of missed calls much faster). Thus, the function lookup("alias") can be used to map aliases to AORs. More information is available at: http://www.opensips.org/html/docs/modules/1.11.x/registrar.html. Most people uses the dbaliases table with the alias_db module now.
Table 27-1. Table "aliases"
| name | type | size | default | null | key | extra attributes | description |
|---|---|---|---|---|---|---|---|
id
| unsigned int
| 10
| default | no | primary | autoincrement | unique ID |
username
| string
| 64
| ' | no | Alias Username / Phone Number | ||
domain
| string
| 64
| ' | no | Domain name | ||
contact
| string
| 255
| ' | no | Contact header field value provides a URI whoses meaning depends on the type of request or response it is in. | ||
received
| string
| 128
| NULL | yes | Received IP:PORT in the format SIP:IP:PORT | ||
path
| string
| 255
| NULL | yes | Path Header(s) per RFC 3327 | ||
expires
| datetime
| not specified
| '2020-05-28 21:32:15' | no | Date and time when this entry expires. | ||
q
| float
| 10,2
| 1.0 | no | Value used for preferential routing. | ||
callid
| string
| 255
| 'Default-Call-ID' | no | Call-ID header field uniquely identifies a particular invitation or all registrations of a particular client. | ||
cseq
| int
| 11
| 13 | no | CSeq header field contains a single decimal sequence number and the request method. | ||
last_modified
| datetime
| not specified
| '1900-01-01 00:00:01' | no | Date and time when this entry was last modified. | ||
flags
| int
| 11
| 0 | no | Flags | ||
cflags
| string
| 255
| NULL | yes | CFlags | ||
user_agent
| string
| 255
| ' | no | User-Agent header field contains information about the UAC originating the request. | ||
socket
| string
| 64
| NULL | yes | Socket used to connect to OpenSIPS. For example: UDP:IP:PORT | ||
methods
| int
| 11
| NULL | yes | Flags that indicate the SIP Methods this contact will accept. | ||
sip_instance
| string
| 255
| NULL | yes | SIP Instance for this particular contact | ||
attr
| string
| 255
| NULL | yes | Optional information specific to each registration |
Table for the RLS module.
Table for RLS module used for storing resource lists subscribe information.
Table 28-1. Table "rls_presentity"
| name | type | size | default | null | key | extra attributes | description |
|---|---|---|---|---|---|---|---|
id
| unsigned int
| 10
| default | no | primary | autoincrement | Unique ID |
rlsubs_did
| string
| 255
| default | no | Resource list subscribe dialog id | ||
resource_uri
| string
| 128
| default | no | List Uri | ||
content_type
| string
| 255
| default | no | Content type | ||
presence_state
| binary
| not specified
| default | no |
| ||
expires
| int
| 11
| default | no | Expires | ||
updated
| int
| 11
| default | no | Update flag | ||
auth_state
| int
| 11
| default | no | Watcher authorization state | ||
reason
| string
| 64
| default | no | reason for watcher authorization state |
Table 28-2. Table "rls_presentity" indexes
| name | type | links | description |
|---|---|---|---|
rls_presentity_idx
| unique | rlsubs_did, resource_uri |
|
updated_idx
| default | updated |
|
Table 28-3. Table "rls_watchers"
| name | type | size | default | null | key | extra attributes | description |
|---|---|---|---|---|---|---|---|
id
| unsigned int
| 10
| default | no | primary | autoincrement | Unique ID |
presentity_uri
| string
| 128
| default | no | Presence URI | ||
to_user
| string
| 64
| default | no | To user | ||
to_domain
| string
| 64
| default | no | To domain | ||
watcher_username
| string
| 64
| default | no | From user | ||
watcher_domain
| string
| 64
| default | no | From domain | ||
event
| string
| 64
| 'presence' | no | Event description | ||
event_id
| string
| 64
| default | yes | Event ID | ||
to_tag
| string
| 64
| default | no | To tag | ||
from_tag
| string
| 64
| default | no | From tag | ||
callid
| string
| 64
| default | no | Call ID | ||
local_cseq
| int
| 11
| default | no | Local cseq | ||
remote_cseq
| int
| 11
| default | no | Remote cseq | ||
contact
| string
| 64
| default | no | Contact | ||
record_route
| text
| not specified
| default | yes | Record route | ||
expires
| int
| 11
| default | no | Expires | ||
status
| int
| 11
| 2 | no | Status | ||
reason
| string
| 64
| default | no | Reason | ||
version
| int
| 11
| 0 | no | Version | ||
socket_info
| string
| 64
| default | no | Socket info | ||
local_contact
| string
| 128
| default | no | Local contact |
This table is used by the NAT Helper module to store
definitions of socket(s) used to connect to (a set) RTPProxy.
More information can be found at: http://www.opensips.org/html/docs/modules/1.11.x/nathelper.html.
Table 29-1. Table "rtpproxy_sockets"
| name | type | size | default | null | key | extra attributes | description |
|---|---|---|---|---|---|---|---|
id
| unsigned int
| 10
| default | no | primary | autoincrement | Unique ID |
rtpproxy_sock
| text
| not specified
| default | no | A list of sockets use to connect to a set of RTPProxy. Example: "udp:localhost:12221 udp:localhost:12222". | ||
set_id
| unsigned int
| 10
| default | no | The ID of the RTPProxy set. |
This table is used to store incoming/outgoing SIP messages in database. More informations can be found in the siptrace module documentation at: http://www.opensips.org/html/docs/modules/1.11.x/siptrace.html.
Table 30-1. Table "sip_trace"
| name | type | size | default | null | key | extra attributes | description |
|---|---|---|---|---|---|---|---|
id
| unsigned int
| 10
| default | no | primary | autoincrement | unique ID |
time_stamp
| datetime
| not specified
| '1900-01-01 00:00:01' | no | Recording date | ||
callid
| string
| 255
| ' | no | call ID from SIP message | ||
traced_user
| string
| 128
| NULL | yes | SIP URI of the user being traced | ||
msg
| text
| not specified
| default | no | Full SIP message | ||
method
| string
| 32
| ' | no | SIP method name | ||
status
| string
| 128
| NULL | yes | SIP reply status | ||
fromip
| string
| 50
| ' | no | Source IP address | ||
toip
| string
| 50
| ' | no | Destination IP address | ||
fromtag
| string
| 64
| ' | no | From tag | ||
direction
| string
| 4
| ' | no | Destination IP address |
This table is used by the speeddial module to provide on-server speed dial facilities. More information about the speeddial module can be found at: http://www.opensips.org/html/docs/modules/1.11.x/speeddial.html
Table 31-1. Table "speed_dial"
| name | type | size | default | null | key | extra attributes | description |
|---|---|---|---|---|---|---|---|
id
| unsigned int
| 10
| default | no | primary | autoincrement | unique ID |
username
| string
| 64
| ' | no | Username / phone number | ||
domain
| string
| 64
| ' | no | Domain name | ||
sd_username
| string
| 64
| ' | no | Speed dial username | ||
sd_domain
| string
| 64
| ' | no | Speed dial domain | ||
new_uri
| string
| 128
| ' | no | New URI | ||
fname
| string
| 64
| ' | no | First name | ||
lname
| string
| 64
| ' | no | Last name | ||
description
| string
| 64
| ' | no | Description |
This table is used by uri_db module to implement various SIP URI checks. More information about the uri_db module can be found at: http://www.opensips.org/html/docs/modules/1.11.x/uri_db.html
Table 33-1. Table "uri"
| name | type | size | default | null | key | extra attributes | description |
|---|---|---|---|---|---|---|---|
id
| unsigned int
| 10
| default | no | primary | autoincrement |
|
username
| string
| 64
| ' | no | Username / phone number | ||
domain
| string
| 64
| ' | no | Domain name | ||
uri_user
| string
| 64
| ' | no | Username / phone number | ||
last_modified
| datetime
| not specified
| '1900-01-01 00:00:01' | no | Date and time when this record was last modified. |
This table is used by the userblacklist module for the user specific blacklists. More information is available at: http://www.opensips.org/html/docs/modules/1.11.x/userblacklist.html
This table is used by the userblacklist module for the global blacklists. More information is available at: http://www.opensips.org/html/docs/modules/1.11.x/userblacklist.html
Table 34-1. Table "userblacklist"
| name | type | size | default | null | key | extra attributes | description |
|---|---|---|---|---|---|---|---|
id
| unsigned int
| 10
| default | no | primary | autoincrement | unique ID |
username
| string
| 64
| ' | no | The user that is used for the blacklist lookup. | ||
domain
| string
| 64
| ' | no | The domain that is used for the blacklist lookup. | ||
prefix
| string
| 64
| ' | no | The prefix that is matched for the blacklist. | ||
whitelist
| char
| 1
| 0 | no | Specify if this a blacklist (0) or a whitelist (1) entry. |
Table 34-2. Table "userblacklist" indexes
| name | type | links | description |
|---|---|---|---|
userblacklist_idx
| default | username, domain, prefix |
|
Table 34-3. Table "globalblacklist"
| name | type | size | default | null | key | extra attributes | description |
|---|---|---|---|---|---|---|---|
id
| unsigned int
| 10
| default | no | primary | autoincrement | unique ID |
prefix
| string
| 64
| ' | no | The prefix that is matched for the blacklist. | ||
whitelist
| char
| 1
| 0 | no | Specify if this a blacklist (0) or a whitelist (1) entry. | ||
description
| string
| 255
| NULL | yes | A comment for the entry. |
Persistent user location information for the usrloc module. More information can be found at: http://www.opensips.org/html/docs/modules/1.11.x/usrloc.html
Table 35-1. Table "location"
| name | type | size | default | null | key | extra attributes | description |
|---|---|---|---|---|---|---|---|
id
| unsigned int
| 10
| default | no | primary | autoincrement | unique ID |
username
| string
| 64
| ' | no | Username / phone number | ||
domain
| string
| 64
| ' | no | Domain name | ||
contact
| string
| 255
| ' | no | Contact header field value provides a URI whoses meaning depends on the type of request or response it is in. | ||
received
| string
| 128
| NULL | yes | Received IP:PORT in the format SIP:IP:PORT | ||
path
| string
| 255
| NULL | yes | Path Header(s) per RFC 3327 | ||
expires
| datetime
| not specified
| '2020-05-28 21:32:15' | no | Date and time when this entry expires. | ||
q
| float
| 10,2
| 1.0 | no | Value used for preferential routing. | ||
callid
| string
| 255
| 'Default-Call-ID' | no | Call-ID header field uniquely identifies a particular invitation or all registrations of a particular client. | ||
cseq
| int
| 11
| 13 | no | CSeq header field contains a single decimal sequence number and the request method. | ||
last_modified
| datetime
| not specified
| '1900-01-01 00:00:01' | no | Date and time when this entry was last modified. | ||
flags
| int
| 11
| 0 | no | Flags | ||
cflags
| string
| 255
| NULL | yes | CFlags | ||
user_agent
| string
| 255
| ' | no | User-Agent header field contains information about the UAC originating the request. | ||
socket
| string
| 64
| NULL | yes | Socket used to connect to OpenSIPS. For example: UDP:IP:PORT | ||
methods
| int
| 11
| NULL | yes | Flags that indicate the SIP Methods this contact will accept. | ||
sip_instance
| string
| 255
| NULL | yes | SIP Instance for this particular contact | ||
attr
| string
| 255
| NULL | yes | Optional information specific to each registration |
Table 35-2. Table "location" indexes
| name | type | links | description |
|---|---|---|---|
account_contact_idx
| unique | username, domain, contact, callid |
|