TC_ROOMS Table
The TC_ROOMS table contains information for group chat rooms.
Column Name |
Postgres Datatype |
Oracle Datatype |
Microsoft SQL Datatype |
Not Null |
Description |
---|---|---|---|---|---|
ROOM_JID |
VARCHAR (3071) |
VARCHAR2 (3071) |
varchar (3071) |
Yes |
The ID of the room. |
CREATOR_JID |
VARCHAR (3071) |
VARCHAR2 (3071) |
varchar (3071) |
Yes |
The ID of the user who created the room. |
SUBJECT |
VARCHAR (255) |
VARCHAR2 (255) |
varchar (255) |
Yes |
The current subject for the room. |
TYPE |
VARCHAR (32) |
VARCHAR2 (32) |
varchar (32) |
Yes |
The constraint check_type. This value must be either "ad-hoc" or "persistent". |
CONFIG |
TEXT |
CLOB |
text |
Yes |
The entire packet from the last time the room was configured. This information enables the room to be reconfigured when the room is recreated (for example, at start-up). |
SPACKET |
TEXT |
CLOB |
text |
Yes |
The entire packet from the last time the subject was set for the room. This information enables the room subject to be displayed when the room is recreated. |
START_MSG_ID |
BIGINT |
NUMBER (19) |
bigint |
Yes |
A sequence number that is used to populate the MSG_ID column in the TC_MSGARCHIVE table. Do not modify this value. |
NEXT_MSG_ID |
BIGINT |
NUMBER (19) |
bigint |
Yes |
A sequence number that is used to populate the MSG_ID column in the TC_MSGARCHIVE table. Do not modify this value. |