From openSIPS

Documentation: DB schema - ver 1.7

Documentation -> Manuals -> Manual 1.7 -> DB schema

Pages for other versions: devel 3.6 3.5 3.4 Older versions: 3.3 3.2 3.1 3.0 2.4 2.3 2.2 2.1 1.11 1.10 1.9 1.8 1.7 1.6 1.5 1.4

OpenSIPS database tables
OpenSIPS Development Team
http://www.opensips.org/
Copyright © 2007-2011 OpenSIPS development Team
Table of Contents
1. Accounting
2. alias db
3. Subscriber
4. AVP Operations
5. B2BUA
6. carrierroute
7. Accounting
8. Call-processing language
9. Dialog support
10. Matching and translation rules
11. Dispatcher
12. Domain
13. Domainpolicy
14. Dynamic Routing
15. Extensions
16. Group checking
17. Instant Message Conference
18. Load Balancer
19. Message Storage
20. NAT Helper
21. Prefix-Domain Translation
22. Permissions
23. Presence
24. Registrar
25. RLS
26. SIPtrace
27. Speed dial
28. Version
29. SIP URI checks
30. User and global blacklists
31. 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 "b2b_entities"
5-2. Table "b2b_entities" indexes
5-3. Table "b2b_logic"
5-4. Table "b2b_logic" indexes
6-1. Table "carrierroute"
6-2. Table "carrierfailureroute"
6-3. Table "route_tree"
7-1. Table "closeddial"
7-2. Table "closeddial" indexes
8-1. Table "cpl"
8-2. Table "cpl" indexes
9-1. Table "dialog"
9-2. Table "dialog" indexes
10-1. Table "dialplan"
11-1. Table "dispatcher"
12-1. Table "domain"
12-2. Table "domain" indexes
13-1. Table "domainpolicy"
13-2. Table "domainpolicy" indexes
14-1. Table "dr_gateways"
14-2. Table "dr_rules"
14-3. Table "dr_gw_lists"
14-4. Table "dr_groups"
16-1. Table "grp"
16-2. Table "grp" indexes
16-3. Table "re_grp"
16-4. Table "re_grp" indexes
17-1. Table "imc_rooms"
17-2. Table "imc_rooms" indexes
17-3. Table "imc_members"
17-4. Table "imc_members" indexes
18-1. Table "load_balancer"
18-2. Table "load_balancer" indexes
19-1. Table "silo"
19-2. Table "silo" indexes
20-1. Table "nh_sockets"
21-1. Table "pdt"
21-2. Table "pdt" indexes
22-1. Table "address"
23-1. Table "presentity"
23-2. Table "presentity" indexes
23-3. Table "active_watchers"
23-4. Table "active_watchers" indexes
23-5. Table "watchers"
23-6. Table "watchers" indexes
23-7. Table "xcap"
23-8. Table "xcap" indexes
23-9. Table "pua"
24-1. Table "aliases"
24-2. Table "aliases" indexes
25-1. Table "rls_presentity"
25-2. Table "rls_presentity" indexes
25-3. Table "rls_watchers"
25-4. Table "rls_watchers" indexes
26-1. Table "sip_trace"
26-2. Table "sip_trace" indexes
27-1. Table "speed_dial"
27-2. Table "speed_dial" indexes
28-1. Table "version"
28-2. Table "version" indexes
29-1. Table "uri"
29-2. Table "uri" indexes
30-1. Table "userblacklist"
30-2. Table "userblacklist" indexes
30-3. Table "globalblacklist"
30-4. Table "globalblacklist" indexes
31-1. Table "location"
31-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.opensips.org/html/docs/modules/1.5.xacc.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.opensips.org/html/docs/modules/1.5.xacc.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-2. Table "acc" indexes
name
type
links
description
              callid_idx
            
default
callid
              
 
            
    
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.
            
    
Table 1-4. Table "missed_calls" indexes
name
type
links
description
              callid_idx
            
default
callid
              
 
            
  
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.opensips.org/html/docs/modules/1.5.xalias_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
            
    
Table 2-2. Table "dbaliases" indexes
name
type
links
description
              alias_idx
            
unique
alias_username, alias_domain
              
 
            
              target_idx
            
default
username, 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.opensips.org/html/docs/modules/1.5.xauth_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.
            
    
Table 3-2. Table "subscriber" indexes
name
type
links
description
              account_idx
            
unique
username, domain
              
 
            
              username_idx
            
default
username
              
 
            
  
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.opensips.org/html/docs/modules/1.5.xavpops.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 4-2. Table "usr_preferences" indexes
name
type
links
description
              ua_idx
            
default
uuid, attribute
              
 
            
              uda_idx
            
default
username, domain, attribute
              
 
            
              value_idx
            
default
value
              
 
            
  
Chapter 5. B2BUA
    
b2b_entities
Table for the b2b_entities module. More information can be found at: http://www.opensips.org/html/docs/modules/1.5.xb2b_entities.html
        
b2b_logic
Table for the b2b_logic module. More information can be found at: http://www.opensips.org/html/docs/modules/1.5.xb2b_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
              
 
            
    
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
            
    
Table 5-4. Table "b2b_logic" indexes
name
type
links
description
              b2b_logic_idx
            
unique
si_key
              
 
            
  
Chapter 6. carrierroute
    
carrierroute
This table is used by the carrierroute module to provides routing, balancing and blacklisting capabilities. More information is available at: http://www.opensips.org/docs/modules/devel/carrierroute.html
			  
carrierfailureroute
This table is used by the carrierroute module to provide failure routing capabilities. More information is available at: http://www.opensips.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.opensips.org/html/docs/modules/1.5.xcarrierroute.html
			  
  
    
Table 6-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 6-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.
            
    
Table 6-3. Table "route_tree"
name
type
size
default
null
key
extra attributes
description
              id
            
              unsigned int
            
              10
            
default
no
primary
autoincrement
              
unique ID
            
              carrier
            
              string
            
              64
            
NULL
yes
 
 
              
This column contains the carrier name.
            
  
Chapter 7. Accounting
    
closeddial
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.5.xcloseddial.html
        
  
    
Table 7-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 7-2. Table "closeddial" indexes
name
type
links
description
              cd_idx1
            
unique
username, domain, cd_domain, cd_username, group_id
              
 
            
              cd_idx2
            
default
group_id
              
 
            
              cd_idx3
            
default
cd_username
              
 
            
              cd_idx4
            
default
username
              
 
            
  
Chapter 8. Call-processing language
    
cpl
Table for the call processing language "cpl" module. More information is available at: http://www.opensips.org/html/docs/modules/1.5.xcpl-c.html
  
    
Table 8-1. Table "cpl"
name
type
size
default
null
key
extra attributes
description
              id
            
              unsigned int
            
              10
            
default
no
primary
autoincrement
              
Unique ID
            
              username
            
              string
            
              64
            
default
no
 
 
              
 
            
              domain
            
              string
            
              64
            
''
no
 
 
              
 
            
              cpl_xml
            
              text
            
              not specified
            
default
yes
 
 
              
 
            
              cpl_bin
            
              text
            
              not specified
            
default
yes
 
 
              
 
            
    
Table 8-2. Table "cpl" indexes
name
type
links
description
              account_idx
            
unique
username, domain
              
 
            
  
Chapter 9. Dialog support
    
dialog
Persistent dialog information for the dialog module. More 
		information can be found at: http://www.opensips.org/html/docs/modules/1.5.xdialog.html
		
  
    
Table 9-1. Table "dialog"
name
type
size
default
null
key
extra attributes
description
              id
            
              unsigned int
            
              10
            
default
no
primary
autoincrement
              
unique ID
            
              hash_entry
            
              unsigned int
            
              10
            
default
no
 
 
              
Number of the hash entry in the dialog hash table
		
            
              hash_id
            
              unsigned int
            
              10
            
default
no
 
 
              
The ID on the hash entry
            
              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
            
              text
            
              512
            
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.
            
    
Table 9-2. Table "dialog" indexes
name
type
links
description
              hash_idx
            
default
hash_entry, hash_id
              
 
            
  
Chapter 10. Matching and translation rules
    
dialplan
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.5.xdialplan.html
        
  
    
Table 10-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_len
            
              int
            
              11
            
default
no
 
 
              
Length of the matching expresion (used only for equal operator).
            
              subst_exp
            
              string
            
              64
            
default
no
 
 
              
Substitution expresion.
            
              repl_exp
            
              string
            
              32
            
default
no
 
 
              
Replacement expresion (sed like).
            
              attrs
            
              string
            
              32
            
default
no
 
 
              
General attributes string to be returned in case of rule matching.
            
  
Chapter 11. 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.opensips.org/html/docs/modules/1.5.xdispatcher.html
        
  
    
Table 11-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
            
              flags
            
              int
            
              not specified
            
0
no
 
 
              
Flags of destination SIP address
            
              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
            
  
Chapter 12. 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.opensips.org/html/docs/modules/1.5.xdomain.html
        
  
    
Table 12-1. Table "domain"
name
type
size
default
null
key
extra attributes
description
              id
            
              unsigned int
            
              10
            
default
no
primary
autoincrement
              
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 12-2. Table "domain" indexes
name
type
links
description
              domain_idx
            
unique
domain
              
 
            
  
Chapter 13. Domainpolicy
    
domainpolicy
Table for the domainpolicy module. More information at http://www.opensips.org/html/docs/modules/1.5.xdomainpolicy.html.
        
  
    
Table 13-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
            
    
Table 13-2. Table "domainpolicy" indexes
name
type
links
description
              rav_idx
            
unique
rule, att, val
              
 
            
              rule_idx
            
default
rule
              
 
            
  
Chapter 14. Dynamic Routing
    
dr_gateways
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.5.xdrouting.html.
		
dr_rules
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.5.xdrouting.html.
		
dr_gw_lists
This table is used by the Dynamic Routing module to define
		lists of gateways to be used in rule definitions.
		More information can be found at: http://www.opensips.org/html/docs/modules/1.5.xdrouting.html.
		
dr_groups
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.5.xdrouting.html.
		
  
    
Table 14-1. Table "dr_gateways"
name
type
size
default
null
key
extra attributes
description
              gwid
            
              unsigned int
            
              10
            
default
no
primary
autoincrement
              
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;  
            
              description
            
              string
            
              128
            
''
no
 
 
              
Text description of the GW/destination
            
    
Table 14-2. 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
            
default
no
 
 
              
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 14-3. Table "dr_gw_lists"
name
type
size
default
null
key
extra attributes
description
              id
            
              unsigned int
            
              10
            
default
no
primary
autoincrement
              
Unique ID
            
              gwlist
            
              string
            
              255
            
default
no
 
 
              
Reference to the GWs/destinations from the list.
		
            
              description
            
              string
            
              128
            
''
no
 
 
              
Text description of the GW list
            
    
Table 14-4. 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
            
  
Chapter 15. Extensions
>
Chapter 16. 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.opensips.org/html/docs/modules/1.5.xgroup.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.opensips.org/html/docs/modules/1.5.xgroup.html
        
  
    
Table 16-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 16-2. Table "grp" indexes
name
type
links
description
              account_group_idx
            
unique
username, domain, grp
              
 
            
    
Table 16-3. Table "re_grp"
name
type
size
default
null
key
extra attributes
description
              id
            
              unsigned int
            
              10
            
default
no
primary
autoincrement
              
unique ID
            
              reg_exp
            
              string
            
              128
            
''
no
 
 
              
Regular expression
            
              group_id
            
              int
            
              11
            
0
no
 
 
              
Group ID
            
    
Table 16-4. Table "re_grp" indexes
name
type
links
description
              group_idx
            
default
group_id
              
 
            
  
Chapter 17. Instant Message Conference
    
imc_rooms
Room table for the IMC module. More information at http://www.opensips.org/html/docs/modules/1.5.ximc.html.
        
imc_members
Member table for the IMC module. More information at http://www.opensips.org/html/docs/modules/1.5.ximc.html.
        
  
    
Table 17-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
            
    
Table 17-2. Table "imc_rooms" indexes
name
type
links
description
              name_domain_idx
            
unique
name, domain
              
 
            
    
Table 17-3. Table "imc_members"
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
            
              domain
            
              string
            
              64
            
default
no
 
 
              
Domain
            
              room
            
              string
            
              64
            
default
no
 
 
              
 
            
              flag
            
              int
            
              11
            
default
no
 
 
              
Flags
            
    
Table 17-4. Table "imc_members" indexes
name
type
links
description
              account_room_idx
            
unique
username, domain, room
              
 
            
  
Chapter 18. Load Balancer
    
load_balancer
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.5.xload_balancer.html.
		
  
    
Table 18-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
            
    
Table 18-2. Table "load_balancer" indexes
name
type
links
description
              dsturi_idx
            
default
dst_uri
              
 
            
  
Chapter 19. 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.opensips.org/html/docs/modules/1.5.xmsilo.html
        
  
    
Table 19-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
            
              32
            
'text/plain'
no
 
 
              
Content type
            
              body
            
              binary
            
              not specified
            
''
no
 
 
              
Body of the message
            
    
Table 19-2. Table "silo" indexes
name
type
links
description
              account_idx
            
default
username, domain
              
 
            
  
Chapter 20. NAT Helper
    
nh_sockets
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.5.xnathelper.html.
		
  
    
Table 20-1. Table "nh_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.
            
  
Chapter 21. 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.opensips.org/html/docs/modules/1.5.xpdt.html 
        
  
    
Table 21-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.
            
    
Table 21-2. Table "pdt" indexes
name
type
links
description
              sdomain_prefix_idx
            
unique
sdomain, prefix
              
 
            
  
Chapter 22. Permissions
    
address
This table is used by the permissions module. More information is available at: http://www.opensips.org/html/docs/modules/1.5.xpermissions.html
        
  
    
Table 22-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
            
  
Chapter 23. Presence
    
presentity
Table for the presence module. More information can be found at: http://www.opensips.org/html/docs/modules/1.5.xpresence.html
        
active_watchers
Table for the presence module. More information can be found at: http://www.opensips.org/html/docs/modules/1.5.xpresence.html
        
watchers
Table for the presence module. More information can be found at: http://www.opensips.org/html/docs/modules/1.5.xpresence.html
        
xcap
Table for the presence module. More information can be found at: http://www.opensips.org/html/docs/modules/1.5.xpresence.html
        
pua
Table for the presence related pua module. More information can be found at: http://www.opensips.org/html/docs/modules/1.5.xpua.html
        
  
    
Table 23-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 23-2. Table "presentity" indexes
name
type
links
description
              presentity_idx
            
unique
username, domain, event, etag
              
 
            
    
Table 23-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 23-4. Table "active_watchers" indexes
name
type
links
description
              active_watchers_idx
            
unique
presentity_uri, callid, to_tag, from_tag
              
 
            
    
Table 23-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 23-6. Table "watchers" indexes
name
type
links
description
              watcher_idx
            
unique
presentity_uri, watcher_username, watcher_domain, event
              
 
            
    
Table 23-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 23-8. Table "xcap" indexes
name
type
links
description
              account_doc_type_idx
            
unique
username, domain, doc_type, doc_uri
              
 
            
              source_idx
            
default
source
              
 
            
    
Table 23-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
            
  
Chapter 24. 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.opensips.org/html/docs/modules/1.5.xregistrar.html. Most people uses the dbaliases table with the alias_db module now.
        
  
    
Table 24-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
            
NULL
yes
 
 
              
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
            
              128
            
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
            
              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
            
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
            
    
Table 24-2. Table "aliases" indexes
name
type
links
description
              alias_idx
            
unique
username, domain, contact, callid
              
 
            
  
Chapter 25. RLS
    
rls_presentity
Table for the RLS module.
        
rls_watchers
Table for RLS module used for storing resource lists subscribe
                 information.
        
  
    
Table 25-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 25-2. Table "rls_presentity" indexes
name
type
links
description
              rls_presentity_idx
            
unique
rlsubs_did, resource_uri
              
 
            
              updated_idx
            
default
updated
              
 
            
    
Table 25-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
            
    
Table 25-4. Table "rls_watchers" indexes
name
type
links
description
              rls_watcher_idx
            
unique
presentity_uri, callid, to_tag, from_tag
              
 
            
  
Chapter 26. 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.opensips.org/html/docs/modules/1.5.xsiptrace.html.
        
  
    
Table 26-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
            
    
Table 26-2. Table "sip_trace" indexes
name
type
links
description
              traced_user_idx
            
default
traced_user
              
 
            
              date_idx
            
default
time_stamp
              
 
            
              fromip_idx
            
default
fromip
              
 
            
              callid_idx
            
default
callid
              
 
            
  
Chapter 27. 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.opensips.org/html/docs/modules/1.5.xspeeddial.html
        
  
    
Table 27-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
            
    
Table 27-2. Table "speed_dial" indexes
name
type
links
description
              speed_dial_idx
            
unique
username, domain, sd_domain, sd_username
              
 
            
  
Chapter 28. Version
    
version
 
  
    
Table 28-1. Table "version"
name
type
size
default
null
key
extra attributes
description
              table_name
            
              string
            
              32
            
default
no
 
 
              
 
            
              table_version
            
              unsigned int
            
              not specified
            
0
no
 
 
              
 
            
    
Table 28-2. Table "version" indexes
name
type
links
description
              t_name_idx
            
unique
table_name
              
 
            
  
Chapter 29. 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.opensips.org/html/docs/modules/1.5.xuri_db.html 
        
  
    
Table 29-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.
            
    
Table 29-2. Table "uri" indexes
name
type
links
description
              account_idx
            
unique
username, domain, uri_user
              
 
            
  
Chapter 30. User and global blacklists
    
userblacklist
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.5.xuserblacklist.html
        
globalblacklist
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.5.xuserblacklist.html
        
  
    
Table 30-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 30-2. Table "userblacklist" indexes
name
type
links
description
              userblacklist_idx
            
default
username, domain, prefix
              
 
            
    
Table 30-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.
            
    
Table 30-4. Table "globalblacklist" indexes
name
type
links
description
              globalblacklist_idx
            
default
prefix
              
 
            
  
Chapter 31. User location
    
location
Persistent user location information for the usrloc module. More information can be found at: http://www.opensips.org/html/docs/modules/1.5.xusrloc.html
        
  
    
Table 31-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
            
              128
            
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
            
              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
            
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.
            
    
Table 31-2. Table "location" indexes
name
type
links
description
              account_contact_idx
            
unique
username, domain, contact