|
|
CenterStage-NS DB Schema
Registered User Information
subscribers Table
| Column Name |
Data Type |
Attribute |
Example |
Description |
| userid |
integer |
PRIMARY KEY |
10001 |
ID information of the registered user. However, this ID information is for internally use only and does not appear on the API. |
| subscriber |
varchar |
|
alice |
User portion of the SIP URI. For example, if the URI is "sip:alice@atlanta.com," "alice" is stored as the subscriber. |
| host |
varchar |
NOT NULL |
atlanta.com |
Domain portion of the SIP URI. For example, if the URI is "sip:alice@atlanta.com," "atlanta.com" is stored as the host. |
| alias |
varchar |
|
05012345678 |
Alias of the user name. It is also possible to receive messages at "sip:alias@host." It may be left unspecified (NULL), but if it is specified, it should be done so as a unique SIP URI. Since its constraint is complicated, it should be specified not as a constraint on the DB but be checked from the application that writes it. |
| authfailure |
integer |
|
|
Incremented when REGISTER has failed. |
| blockstatus |
integer |
|
|
Flag to indicate incoming blockage. When set to 1, incoming blockage is enabled. |
Constraint
digestauth Table
| Column Name |
Data Type |
Attribute |
Example |
Description |
| userid |
integer |
NOT NULL |
10001 |
ID information of the registered user. |
| username |
varchar |
NOT NULL |
alice |
User name of the registered user. Used in Digest authentication. |
| ha1 |
varchar |
NOT NULL |
|
Hash information of Digest authentication. |
| realm |
varchar |
|
|
Authentication realm of the registered user. When NULL is specified, the default realm is applied. |
| blockstatus |
integer |
|
DEFAULT 0 |
Flag for outgoing blockage. When 1 is set, outgoing blockage is enabled. |
| testcall |
integer |
|
DEFAULT 0 |
Flag to indicate whether the user is for performing test-call. For details, see the CenterStage-NS documentation. |
Constraint
- FOREIGN KEY (userid) references subscribers(userid) ON DELETE CASCADE
Location information
registrations Table
| Column Name |
Data Type |
Attribute |
Example |
Description |
| userid |
integer |
NOT NULL |
10001 |
ID information of the registered user. |
| contact |
varchar |
|
|
Contact header information upon REGISTER. |
| expirytime |
integer |
|
|
Expiry time of the location information. |
| updatetime |
integer |
|
|
Update time of the location information. |
| callid |
varchar |
|
|
Call-ID header information of REGISTER method. |
| cseq |
integer |
|
|
Number information of the CSeq header set for recent REGISTER method. |
| admincontactstatus |
integer |
DEFAULT 0 |
|
Constraint
- FOREIGN KEY (userid) references subscribers(userid) ON DELETE CASCADE
Presence ACL Information
acceptsubscription Table
| Column Name |
Data Type |
Attribute |
Example |
Description |
| userid |
integer |
NOT NULL |
10001 |
ID information of the registered user. |
| accepturl |
varchar |
|
xxx@yyy |
Accepted URL. |
Constraint
- FOREIGN KEY (userid) references subscribers(userid) ON DELETE CASCADE
denysubscription Table
| Column Name |
Data Type |
Attribute |
Example |
Description |
| userid |
integer |
NOT NULL |
10001 |
ID information of the registered user. |
| denyurl |
varchar |
|
xxx@yyy |
Denied URL. |
Constraint
- FOREIGN KEY (userid) references subscribers(userid) ON DELETE CASCADE
Presence List Information
presencelists Table
| Column Name |
Data Type |
Attribute |
Example |
Description |
| listname |
varchar |
NOT NULL |
|
List name |
| listid |
integer |
NOT NULL |
|
ID information to identify the list |
Constraint
listauthorization Table
| Column Name |
Data Type |
Attribute |
Example |
Description |
| listid |
integer |
NOT NULL |
|
ID information to identify the list |
| userid |
integer |
NOT NULL |
|
ID information of the registered user who is allowed to use this list |
Constraint
- FOREIGN KEY (userid) references subscribers(userid) ON DELETE CASCADE
listentries Table
| Column Name |
Data Type |
Attribute |
Example |
Description |
| listid |
integer |
NOT NULL |
|
ID information to identify the list |
| presentityuri |
varchar |
NOT NULL |
|
URI of the presentity registered in this list |
Constraint
- FOREIGN KEY (listid) references presencelists(listid) ON DELETE CASCADE
Last Modified:Tue Mar 23 18:47:11 JST 2004
|
|