OpenSER database tables

OpenSER Development Team

Edited by

Henning Westerholt

Norman Brandinger


Table of Contents
1. Accounting
2. alias db
3. Subscriber
4. AVP Operations
5. carrierroute
6. Call-processing language
7. Dialog support
8. Dispatcher
9. Domain
10. Domainpolicy
11. Extensions
12. Group checking
13. Instant Message Conference
14. Least-cost Routing
15. Message Storage
16. Prefix-Domain Translation
17. Permissions
18. Presence
19. Registrar
20. RLS
21. SERWeb
22. SIPtrace
23. Speed dial
24. Version
25. SIP URI checks
26. User location
List of Tables
1-1. Table "acc"
1-2. Table "acc" indexes
1-3. Table "missed_calls"
1-4. Table "missed_calls" indexes
2-1. Table "dbaliases"
2-2. Table "dbaliases" indexes
3-1. Table "subscriber"
3-2. Table "subscriber" indexes
4-1. Table "usr_preferences"
4-2. Table "usr_preferences" indexes
5-1. Table "carrierroute"
5-2. Table "route_tree"
6-1. Table "cpl"
6-2. Table "cpl" indexes
7-1. Table "dialog"
7-2. Table "dialog" indexes
8-1. Table "dispatcher"
9-1. Table "domain"
9-2. Table "domain" indexes
10-1. Table "domainpolicy"
10-2. Table "domainpolicy" indexes
12-1. Table "grp"
12-2. Table "grp" indexes
12-3. Table "re_grp"
12-4. Table "re_grp" indexes
13-1. Table "imc_rooms"
13-2. Table "imc_rooms" indexes
13-3. Table "imc_members"
13-4. Table "imc_members" indexes
14-1. Table "gw"
14-2. Table "gw" indexes
14-3. Table "gw_grp"
14-4. Table "lcr"
14-5. Table "lcr" indexes
15-1. Table "silo"
15-2. Table "silo" indexes
16-1. Table "pdt"
16-2. Table "pdt" indexes
17-1. Table "trusted"
17-2. Table "trusted" indexes
17-3. Table "address"
18-1. Table "presentity"
18-2. Table "presentity" indexes
18-3. Table "active_watchers"
18-4. Table "active_watchers" indexes
18-5. Table "watchers"
18-6. Table "watchers" indexes
18-7. Table "xcap"
18-8. Table "xcap" indexes
18-9. Table "pua"
19-1. Table "aliases"
19-2. Table "aliases" indexes
20-1. Table "rls_presentity"
20-2. Table "rls_presentity" indexes
20-3. Table "rls_watchers"
20-4. Table "rls_watchers" indexes
21-1. Table "active_sessions"
21-2. Table "active_sessions" indexes
21-3. Table "pending"
21-4. Table "pending" indexes
21-5. Table "phonebook"
21-6. Table "usr_preferences_types"
21-7. Table "server_monitoring"
21-8. Table "server_monitoring" indexes
21-9. Table "server_monitoring_agg"
21-10. Table "admin_privileges"
21-11. Table "admin_privileges" indexes
22-1. Table "sip_trace"
22-2. Table "sip_trace" indexes
23-1. Table "speed_dial"
23-2. Table "speed_dial" indexes
24-1. Table "version"
25-1. Table "uri"
25-2. Table "uri" indexes
26-1. Table "location"
26-2. Table "location" indexes

Chapter 1. Accounting

acc

This table is used by the ACC module to report on transactions - accounted calls. More information is available at: http://www.openser.org/docs/modules/devel/acc.html

missed_calls

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.openser.org/docs/modules/devel/acc.html

Table 1-1. Table "acc"

nametypesizedefaultnullkeyextra attributesdescription
id unsigned int 10  noprimaryautoincrement

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  no  

Date and time when this record was written.

Table 1-2. Table "acc" indexes

nametypelinksdescription
callid_idx defaultcallid

Table 1-3. Table "missed_calls"

nametypesizedefaultnullkeyextra attributesdescription
id unsigned int 10  noprimaryautoincrement

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  no  

Date and time when this record was written.

Table 1-4. Table "missed_calls" indexes

nametypelinksdescription
callid_idx defaultcallid


Chapter 2. alias db

dbaliases

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.openser.org/docs/modules/devel/alias_db.html

Table 2-1. Table "dbaliases"

nametypesizedefaultnullkeyextra attributesdescription
id unsigned int 10  noprimaryautoincrement

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

Table 2-2. Table "dbaliases" indexes

nametypelinksdescription
alias_idx uniquealias_username, alias_domain

target_idx defaultusername, domain


Chapter 3. Subscriber

subscriber

This table is used to provide authentication information. More information about the auth_db module can be found at: http://www.openser.org/docs/modules/devel/auth_db.html

Table 3-1. Table "subscriber"

nametypesizedefaultnullkeyextra attributesdescription
id unsigned int 10  noprimaryautoincrement

Unique ID

username string 64 ''no  

Username / phone number

domain string 64 ''no  

Domain name

password string 25 ''no  

Password

first_name string 64 ''no  

First name

last_name string 64 ''no  

Last name

email_address string 64 ''no  

Email address

datetime_created datetime not specified '1900-01-01 00:00:01'no  

Date and time when this record was created

ha1 string 64 ''no  

md5(username:realm:password)

ha1b string 64 ''no  

md5(username@domain:realm:password)

timezone string 64 NULLyes  

User's time zone

rpid string 64 NULLyes  

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.

Table 3-2. Table "subscriber" indexes

nametypelinksdescription
account_idx uniqueusername, domain

username_idx defaultusername


Chapter 4. AVP Operations

usr_preferences

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.openser.org/docs/modules/devel/avpops.html

Table 4-1. Table "usr_preferences"

nametypesizedefaultnullkeyextra attributesdescription
id unsigned int 10  noprimaryautoincrement

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 4-2. Table "usr_preferences" indexes

nametypelinksdescription
ua_idx defaultuuid, attribute

uda_idx defaultusername, domain, attribute


Chapter 5. carrierroute

carrierroute

This table is used by the carrierroute module to provides routing, balancing and blacklisting capabilities. More information is available at: http://www.openser.org/docs/modules/devel/carrierroute.html

route_tree

This table is used by the carrierroute module to provides routing, balancing and blacklisting capabilities. More information is available at: http://www.openser.org/docs/modules/devel/carrierroute.html

Table 5-1. Table "carrierroute"

nametypesizedefaultnullkeyextra attributesdescription
id unsigned int 10  noprimaryautoincrement

unique ID

carrier unsigned int 10 '0'no  

This column contains the carrier id.

scan_prefix string 64 ''no  

This column contains the scan prefix, which define the matching portion of a phone number.

domain string 64 ''no  

This column contains the route domain. Additional domains could be used for example as fallback.

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.

comment string 255 NULLyes  

A comment for the route entry, useful for larger routing tables.

Table 5-2. Table "route_tree"

nametypesizedefaultnullkeyextra attributesdescription
id unsigned int 10 '0'noprimary 

unique ID

carrier string 64 NULLyes  

This column contains the carrier name.


Chapter 6. Call-processing language

cpl

Table for the call processing language "cpl" module. More information is available at: http://www.openser.org/docs/modules/devel/cpl-c.html

Table 6-1. Table "cpl"

nametypesizedefaultnullkeyextra attributesdescription
id unsigned int 10  noprimaryautoincrement

Unique ID

username string 64  no  

domain string 64 ''no  

cpl_xml text not specified  yes  

cpl_bin text not specified  yes  

Table 6-2. Table "cpl" indexes

nametypelinksdescription
account_idx uniqueusername, domain


Chapter 7. Dialog support

dialog

Persistent dialog information for the dialog module. More information can be found at: http://www.openser.org/docs/modules/devel/dialog.html

Table 7-1. Table "dialog"

nametypesizedefaultnullkeyextra attributesdescription
id unsigned int 10  noprimaryautoincrement

unique ID

hash_entry unsigned int 10  no  

Number of the hash entry in the dialog hash table

hash_id unsigned int 10  no  

The ID on the hash entry

callid string 255  no  

Call-ID of the dialog

from_uri string 128  no  

The URI of the FROM header (as per INVITE)

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_uri string 128  no  

The URI of the TO header (as per INVITE)

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.

caller_cseq string 7  no  

Last Cseq number on the caller side.

callee_cseq string 7  no  

Last Cseq number on the caller side.

caller_route_set string 512  yes  

Route set on the caller side.

callee_route_set string 512  yes  

Route set on on the caller side.

caller_contact string 128  no  

Caller's contact uri.

callee_contact string 128  no  

Callee's contact uri.

caller_sock string 64  no  

Local socket used to communicate with caller

callee_sock string 64  no  

Local socket used to communicate with callee

state unsigned int 10  no  

The state of the dialog.

start_time unsigned int 10  no  

The timestamp (unix time) when the dialog was confirmed.

timeout unsigned int 10  no  

The timestamp (unix time) when the dialog will expire.

Table 7-2. Table "dialog" indexes

nametypelinksdescription
hash_idx defaulthash_entry, hash_id


Chapter 8. Dispatcher

dispatcher

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.openser.org/docs/modules/devel/dispatcher.html

Table 8-1. Table "dispatcher"

nametypesizedefaultnullkeyextra attributesdescription
id unsigned int 10  noprimaryautoincrement

unique ID

setid int not specified '0'no  

Destination set id

destination string 192 ''no  

Destination SIP address

description string 64 ''no  

Description for this destination


Chapter 9. Domain

domain

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.openser.org/docs/modules/devel/domain.html

Table 9-1. Table "domain"

nametypesizedefaultnullkeyextra attributesdescription
id unsigned int 10  noprimaryautoincrement

unique ID

domain string 64 ''no  

Domain name

last_modified datetime not specified '1900-01-01 00:00:01'no  

Date and time when this record was last modified.

Table 9-2. Table "domain" indexes

nametypelinksdescription
domain_idx uniquedomain


Chapter 10. Domainpolicy

domainpolicy

Table for the domainpolicy module. More information at http://www.openser.org/docs/modules/devel/domainpolicy.html.

Table 10-1. Table "domainpolicy"

nametypesizedefaultnullkeyextra attributesdescription
id unsigned int 10  noprimaryautoincrement

unique ID

rule string 255  no  

Domain policy rule name which is equal to the URI as published in the domain policy NAPTRs.

type string 255  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  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  yes  

It contains the values for AVPs created by dp_can_connect(). Default value is "val"

comment string 255  no  

Comment about the rule

Table 10-2. Table "domainpolicy" indexes

nametypelinksdescription
rav_idx uniquerule, att, val

rule_idx defaultrule


Chapter 11. Extensions

>


Chapter 12. Group checking

grp

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.openser.org/docs/modules/devel/group.html

re_grp

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.openser.org/docs/modules/devel/group.html

Table 12-1. Table "grp"

nametypesizedefaultnullkeyextra attributesdescription
id unsigned int 10  noprimaryautoincrement

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 12-2. Table "grp" indexes

nametypelinksdescription
account_group_idx uniqueusername, domain, grp

Table 12-3. Table "re_grp"

nametypesizedefaultnullkeyextra attributesdescription
id unsigned int 10  noprimaryautoincrement

unique ID

reg_exp string 128 ''no  

Regular expression

group_id int 11 '0'no  

Group ID

Table 12-4. Table "re_grp" indexes

nametypelinksdescription
group_idx defaultgroup_id


Chapter 13. Instant Message Conference

imc_rooms

Room table for the IMC module. More information at http://www.openser.org/docs/modules/devel/imc.html.

imc_members

Member table for the IMC module. More information at http://www.openser.org/docs/modules/devel/imc.html.

Table 13-1. Table "imc_rooms"

nametypesizedefaultnullkeyextra attributesdescription
id unsigned int 10  noprimaryautoincrement

unique ID

name string 64  no  

Name of the room

domain string 64  no  

Domain of the room

flag int 11  no  

Flags

Table 13-2. Table "imc_rooms" indexes

nametypelinksdescription
name_domain_idx uniquename, domain

Table 13-3. Table "imc_members"

nametypesizedefaultnullkeyextra attributesdescription
id unsigned int 10  noprimaryautoincrement

unique ID

username string 64  no  

Username

domain string 64  no  

Domain

room string 64  no  

flag int 11  no  

Flags

Table 13-4. Table "imc_members" indexes

nametypelinksdescription
account_room_idx uniqueusername, domain, room


Chapter 14. Least-cost Routing

gw

This table contains Least Cost Routing Gateway definitions for the LCR module. More information can be found at: http://www.openser.org/docs/modules/devel/lcr.html.

gw_grp

This table is used from the lcr module for administrative purposes only to associate names with gateway group ids. More information can be found at: http://www.openser.org/docs/modules/devel/lcr.html.

lcr

This table is used by the lcr (Least Cost Routing) rules. More information can be found at: http://www.openser.org/docs/modules/devel/lcr.html.

Table 14-1. Table "gw"

nametypesizedefaultnullkeyextra attributesdescription
id unsigned int 10  noprimaryautoincrement

gw_name string 128  no  

Gateway Name

grp_id unsigned int not specified  no  

Gateway ID

ip_addr string 15  no  

IP Address of the gateway

port unsigned short not specified  yes  

Port of the gateway

uri_scheme unsigned char not specified  yes  

URI scheme of the gateway

transport unsigned char not specified  yes  

Transport type to be used for the gateway

strip unsigned char not specified  yes  

The number of digits to strip from the RURI before applying the prefix.

prefix string 16 NULLyes  

The R-URI(destination) prefix

dm unsigned char not specified '1'no  

Does gateway support directed media (0 = no, 1 = yes)

Table 14-2. Table "gw" indexes

nametypelinksdescription
gw_name_idx uniquegw_name

grp_id_idx defaultgrp_id

Table 14-3. Table "gw_grp"

nametypesizedefaultnullkeyextra attributesdescription
grp_id unsigned int not specified  noprimaryautoincrement

Group ID

grp_name string 64  no  

Group name

Table 14-4. Table "lcr"

nametypesizedefaultnullkeyextra attributesdescription
id unsigned int 10  noprimaryautoincrement

prefix string 16 NULLyes  

The Request-URI (destination) prefix.

from_uri string 64 NULLyes  

The FROM (source) URI.

grp_id unsigned int not specified  no  

Group ID

priority unsigned char not specified  no  

Priority

Table 14-5. Table "lcr" indexes

nametypelinksdescription
prefix_idx defaultprefix

from_uri_idx defaultfrom_uri

grp_id_idx defaultgrp_id


Chapter 15. Message Storage

silo

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.openser.org/docs/modules/devel/msilo.html

Table 15-1. Table "silo"

nametypesizedefaultnullkeyextra attributesdescription
id unsigned int 10  noprimaryautoincrement

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 32 'text/plain'no  

Content type

body binary not specified ''no  

Body of the message

Table 15-2. Table "silo" indexes

nametypelinksdescription
account_idx defaultusername, domain


Chapter 16. Prefix-Domain Translation

pdt

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.openser.org/docs/modules/devel/pdt.html

Table 16-1. Table "pdt"

nametypesizedefaultnullkeyextra attributesdescription
id unsigned int 10  noprimaryautoincrement

Unique ID

sdomain string 128  no  

Source domain

prefix string 32  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.

Table 16-2. Table "pdt" indexes

nametypelinksdescription
sdomain_prefix_idx uniquesdomain, prefix


Chapter 17. Permissions

trusted

This table is used by the permissions module to determine if a call has the appropriate permission to be established. More information about the permissions module can be found at: http://www.openser.org/docs/modules/devel/permissions.html

address

This table is used by the permissions module. More information is available at: http://www.openser.org/docs/modules/devel/permissions.html

Table 17-1. Table "trusted"

nametypesizedefaultnullkeyextra attributesdescription
id unsigned int 10  noprimaryautoincrement

unique ID

src_ip string 50  no  

Source address is equal to source address of request

proto string 4  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".

from_pattern string 64 NULLyes  

Regular expression matches From URI of request.

tag string 32  yes  

Tag

Table 17-2. Table "trusted" indexes

nametypelinksdescription
peer_idx defaultsrc_ip

Table 17-3. Table "address"

nametypesizedefaultnullkeyextra attributesdescription
id unsigned int 10  noprimaryautoincrement

unique ID

grp unsigned short 5 '0'no  

Group

ip_addr string 15  no  

IP address

mask char not specified '32'no  

Network mask

port unsigned short 5 '0'no  

Port


Chapter 18. Presence

presentity

Table for the presence module. More information can be found at: http://www.openser.org/docs/modules/devel/presence.html

active_watchers

Table for the presence module. More information can be found at: http://www.openser.org/docs/modules/devel/presence.html

watchers

Table for the presence module. More information can be found at: http://www.openser.org/docs/modules/devel/presence.html

xcap

Table for the presence module. More information can be found at: http://www.openser.org/docs/modules/devel/presence.html

pua

Table for the presence related pua module. More information can be found at: http://www.openser.org/docs/modules/devel/pua.html

Table 18-1. Table "presentity"

nametypesizedefaultnullkeyextra attributesdescription
id unsigned int 10  noprimaryautoincrement

Unique ID

username string 64  no  

User name

domain string 64  no  

Domain

event string 64  no  

Event

etag string 64  no  

User name

expires int 11  no  

Expires

received_time int 11  no  

Reveived time

body binary not specified  no  

Table 18-2. Table "presentity" indexes

nametypelinksdescription
presentity_idx uniqueusername, domain, event, etag

Table 18-3. Table "active_watchers"

nametypesizedefaultnullkeyextra attributesdescription
id unsigned int 10  noprimaryautoincrement

Unique ID

presentity_uri string 128  no  

Presence URI

watcher_username string 64  no  

From User

watcher_domain string 64  no  

From Domain

to_user string 64  no  

To User

to_domain string 64  no  

To Domain

event string 64 'presence'no  

Event description

event_id string 64  yes  

Event ID

to_tag string 64  no  

TO tag

from_tag string 64  no  

From tag

callid string 64  no  

Call ID

local_cseq int 11  no  

Local cseq

remote_cseq int 11  no  

Remote cseq

contact string 64  no  

Contact

record_route text not specified  yes  

Record route

expires int 11  no  

Expires

status int 11 '2'no  

Status

reason string 64  no  

Reason

version int 11 '0'no  

Version

socket_info string 64  no  

Socket info

local_contact string 128  no  

Local contact

Table 18-4. Table "active_watchers" indexes

nametypelinksdescription
active_watchers_idx uniquepresentity_uri, callid, to_tag, from_tag

Table 18-5. Table "watchers"

nametypesizedefaultnullkeyextra attributesdescription
id unsigned int 10  noprimaryautoincrement

Unique ID

presentity_uri string 128  no  

Presentity Uri

watcher_username string 64  no  

Watcher User

watcher_domain string 64  no  

Watcher Domain

event string 64 'presence'no  

Event description

status int 11  no  

Status

reason string 64  yes  

Reason

inserted_time int 11  no  

Table 18-6. Table "watchers" indexes

nametypelinksdescription
watcher_idx uniquepresentity_uri, watcher_username, watcher_domain, event

Table 18-7. Table "xcap"

nametypesizedefaultnullkeyextra attributesdescription
id unsigned int 10  noprimaryautoincrement

Unique ID

username string 64  no  

User name

domain string 64  no  

Domain

doc binary not specified  no  

doc

doc_type int 11  no  

Document type

etag string 64  no  

Document Etag

source int 11  no  

Entity inserting the record

doc_uri string 128  no  

Document uri

port int 11  no  

XCAP server port

Table 18-8. Table "xcap" indexes

nametypelinksdescription
account_doc_type_idx uniqueusername, domain, doc_type, doc_uri

source_idx defaultsource

Table 18-9. Table "pua"

nametypesizedefaultnullkeyextra attributesdescription
id unsigned int 10  noprimaryautoincrement

Unique ID

pres_uri string 128  no  

URI

pres_id string 64  no  

ID

event int 11  no  

Event

expires int 11  no  

Expires

desired_expires int 11  no  

Desired Expires

flag int 11  no  

Flags

etag string 64  no  

Etag

tuple_id string 64  yes  

Tuple ID

watcher_uri string 128  no  

Watcher URI

call_id string 64  no  

Call ID

to_tag string 64  no  

To tag

from_tag string 64  no  

To tag

cseq int 11  no  

record_route text not specified  yes  

Record route

contact string 128  no  

Contact

version int 11  no  

extra_headers text not specified  no  

Extra Headers


Chapter 19. Registrar

aliases

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.openser.org/docs/modules/devel/registrar.html. Most people uses the dbaliases table with the alias_db module now.

Table 19-1. Table "aliases"

nametypesizedefaultnullkeyextra attributesdescription
id unsigned int 10  noprimaryautoincrement

unique ID

username string 64 ''no  

Alias Username / Phone Number

domain string 64 NULLyes  

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 NULLyes  

Received IP:PORT in the format SIP:IP:PORT

path string 128 NULLyes  

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 int 11 '0'no  

CFlags

user_agent string 255 ''no  

User-Agent header field contains information about the UAC originating the request.

socket string 64 NULLyes  

Socket used to connect to OpenSER. For example: UDP:IP:PORT

methods int 11 NULLyes  

Flags that indicate the SIP Methods this contact will accept.

Table 19-2. Table "aliases" indexes

nametypelinksdescription
alias_idx defaultusername, domain, contact


Chapter 20. RLS

rls_presentity

Table for the RLS module.

rls_watchers

Table for RLS module used for storing resource lists subscribe information.

Table 20-1. Table "rls_presentity"

nametypesizedefaultnullkeyextra attributesdescription
id unsigned int 10  noprimaryautoincrement

Unique ID

rlsubs_did string 512  no  

Resource list subscribe dialog id

resource_uri string 128  no  

List Uri

content_type string 64  no  

Event

presence_state binary not specified  no  

expires int 11  no  

Expires

updated int 11  no  

Update flag

auth_state int 11  no  

Watcher authorization state

reason string 64  no  

reason for watcher authorization state

Table 20-2. Table "rls_presentity" indexes

nametypelinksdescription
rls_presentity_idx uniquerlsubs_did, resource_uri

updated_idx defaultupdated

Table 20-3. Table "rls_watchers"

nametypesizedefaultnullkeyextra attributesdescription
id unsigned int 10  noprimaryautoincrement

Unique ID

presentity_uri string 128  no  

Presence URI

to_user string 64  no  

To user

to_domain string 64  no  

To domain

watcher_username string 64  no  

From user

watcher_domain string 64  no  

From domain

event string 64 'presence'no  

Event description

event_id string 64  yes  

Event ID

to_tag string 64  no  

To tag

from_tag string 64  no  

From tag

callid string 64  no  

Call ID

local_cseq int 11  no  

Local cseq

remote_cseq int 11  no  

Remote cseq

contact string 64  no  

Contact

record_route text not specified  yes  

Record route

expires int 11  no  

Expires

status int 11 '2'no  

Status

reason string 64  no  

Reason

version int 11 '0'no  

Version

socket_info string 64  no  

Socket info

local_contact string 128  no  

Local contact

Table 20-4. Table "rls_watchers" indexes

nametypelinksdescription
rls_watcher_idx uniquepresentity_uri, callid, to_tag, from_tag


Chapter 21. SERWeb

active_sessions

This table is used by SERWeb to maintain active sessions. It is not used by OpenSER.

pending

SerWEB specific table - Not used by OpenSER. It should have same structure as table subscriber and contains unconfirmed subscription requests.

phonebook

Users Phonebook table used from SERWeb.

usr_preferences_types

User preferences table for SERWeb.

server_monitoring

Server monitoring table used from SERWeb.

server_monitoring_agg

Server monitoring table used from SERWeb.

admin_privileges

Admin privileges table for SERWeb for multidomain ACL control.

Table 21-1. Table "active_sessions"

nametypesizedefaultnullkeyextra attributesdescription
sid string 32 ''no  

Session ID

name string 32 ''no  

Session Name

val text not specified  yes  

Val

changed string 14 ''no  

Domain corresponding to (sdomain, prefix) pair where the message must be sent.

Table 21-2. Table "active_sessions" indexes

nametypelinksdescription
sw_as_idx primaryname, sid

changed defaultchanged

Table 21-3. Table "pending"

nametypesizedefaultnullkeyextra attributesdescription
id unsigned int 10  noprimaryautoincrement

Unique ID

phplib_id string 32 ''no  

PHP Library ID

username string 64 ''no  

Username / Phone Number

domain string 64 ''no  

Domain name

password string 25 ''no  

Password

firstname string 25 ''no  

First name

lastname string 45 ''no  

Last name

phone string 15 ''no  

email_address string 50 ''no  

Email Address

datetime_created datetime not specified '1900-01-01 00:00:01'no  

Date / Time this record was created

datetime_modified datetime not specified '1900-01-01 00:00:01'no  

Date / Time this record was modified

confirmation string 64 ''no  

Confirmation

flag string 1 'o'no  

Flag

sendnotification string 50 ''no  

Send notification

greeting string 50 ''no  

Greeting

ha1 string 64 ''no  

md5(username:realm:password)

ha1b string 64 ''no  

md5(username@domain:realm:password)

allow_find string 1 '0'no  

Allow find Flag

timezone string 64 NULLyes  

Users time zone

rpid string 64 NULLyes  

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.

Table 21-4. Table "pending" indexes

nametypelinksdescription
sw_user_id uniqueusername, domain

phplib_id uniquephplib_id

username_id defaultusername

Table 21-5. Table "phonebook"

nametypesizedefaultnullkeyextra attributesdescription
id unsigned int 10  noprimaryautoincrement

Unique ID

username string 64 ''no  

Username / Phonenumber

domain string 64 ''no  

Domain Name

fname string 32 ''no  

First Nname

lname string 32 ''no  

Last Name

sip_uri string 64 ''no  

SIP URI associated with this record

Table 21-6. Table "usr_preferences_types"

nametypesizedefaultnullkeyextra attributesdescription
att_name string 32 ''noprimary 

att_name

att_rich string 32 'string'no  

att_rich

att_raw_type int not specified '2'no  

att_raw

att_type_spec text not specified  no  

att_type_spec

default_value string 100 ''no  

Default Value

Table 21-7. Table "server_monitoring"

nametypesizedefaultnullkeyextra attributesdescription
id unsigned int 10 '0'no  

Unique ID

time datetime not specified '1900-01-01 00:00:01'no  

Time

param string 32 ''no  

Param

value int 10 '0'no  

Value

increment int 10 '0'no  

Increment

Table 21-8. Table "server_monitoring" indexes

nametypelinksdescription
sw_sm_idx primaryid, param

Table 21-9. Table "server_monitoring_agg"

nametypesizedefaultnullkeyextra attributesdescription
param string 32 ''noprimary 

Param

s_value int 10 '0'no  

s_value

s_increment int 10 '0'no  

s_increment

last_aggregated_increment int 10 '0'no  

last aggregated increment

av float not specified '0'no  

av

mv int 10 '0'no  

mv

ad float not specified '0'no  

ad

lv int 10 '0'no  

lv

min_val int 10 '0'no  

minimum value

max_val int 10 '0'no  

maximum value

min_inc int 10 '0'no  

minimal increment

max_inc int 10 '0'no  

maximal increment

lastupdate datetime not specified '1900-01-01 00:00:01'no  

last update time and date

Table 21-10. Table "admin_privileges"

nametypesizedefaultnullkeyextra attributesdescription
username string 64 ''no  

Username

domain string 64 ''no  

Domain

priv_name string 64 ''no  

priv_name

priv_value string 64 ''no  

priv_value

Table 21-11. Table "admin_privileges" indexes

nametypelinksdescription
sw_ap_idx primaryusername, priv_name, priv_value, domain


Chapter 22. SIPtrace

sip_trace

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.openser.org/docs/modules/devel/siptrace.html.

Table 22-1. Table "sip_trace"

nametypesizedefaultnullkeyextra attributesdescription
id unsigned int 10  noprimaryautoincrement

unique ID

date 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 ''no  

SIP URI of the user being traced

msg text not specified  no  

Full SIP message

method string 50 ''no  

SIP method name

status string 128 ''no  

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

Table 22-2. Table "sip_trace" indexes

nametypelinksdescription
traced_user_idx defaulttraced_user

date_idx defaultdate

fromip_idx defaultfromip

callid_idx defaultcallid


Chapter 23. Speed dial

speed_dial

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.openser.org/docs/modules/devel/speeddial.html

Table 23-1. Table "speed_dial"

nametypesizedefaultnullkeyextra attributesdescription
id unsigned int 10  noprimaryautoincrement

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

Table 23-2. Table "speed_dial" indexes

nametypelinksdescription
speed_dial_idx uniqueusername, domain, sd_domain, sd_username


Chapter 24. Version

Table 24-1. Table "version"

nametypesizedefaultnullkeyextra attributesdescription
table_name string 32  no  

table_version unsigned int not specified '0'no  


Chapter 25. SIP URI checks

uri

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.openser.org/docs/modules/devel/uri_db.html

Table 25-1. Table "uri"

nametypesizedefaultnullkeyextra attributesdescription
id unsigned int 10  noprimaryautoincrement

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.

Table 25-2. Table "uri" indexes

nametypelinksdescription
account_idx uniqueusername, domain, uri_user


Chapter 26. User location

location

Persistent user location information for the usrloc module. More information can be found at: http://www.openser.org/docs/modules/devel/usrloc.html

Table 26-1. Table "location"

nametypesizedefaultnullkeyextra attributesdescription
id unsigned int 10  noprimaryautoincrement

unique ID

username string 64 ''no  

Username / phone number

domain string 64 NULLyes  

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 NULLyes  

Received IP:PORT in the format SIP:IP:PORT

path string 128 NULLyes  

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 int 11 '0'no  

CFlags

user_agent string 255 ''no  

User-Agent header field contains information about the UAC originating the request.

socket string 64 NULLyes  

Socket used to connect to OpenSER. For example: UDP:IP:PORT

methods int 11 NULLyes  

Flags that indicate the SIP Methods this contact will accept.

Table 26-2. Table "location" indexes

nametypelinksdescription
account_contact_idx defaultusername, domain, contact