<div dir="auto">I'll probably post it on my GitHub once I get it cleaned up a bit!</div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Tue, Dec 17, 2019, 2:40 PM Anthony Holloway <<a href="mailto:avholloway%2Bcisco-voip@gmail.com">avholloway+cisco-voip@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">All this mention of the Python file, and yet, no Python file.  What gives Brian?  ;)<div><br></div><div>Thanks for the update!</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Tue, Dec 17, 2019 at 1:36 PM Brian Meade <<a href="mailto:bmeade90@vt.edu" target="_blank" rel="noreferrer">bmeade90@vt.edu</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">Just to update everyone on this, these are stored in the pep_node and pep_node_items tables on the actual IM&Presence server.<div><br></div><div>I was able to find that documented here- <a href="https://bst.cloudapps.cisco.com/bugsearch/bug/CSCvm46828" target="_blank" rel="noreferrer">https://bst.cloudapps.cisco.com/bugsearch/bug/CSCvm46828</a></div><div><br></div><div>I was able to use a Python script to export the contents of pep_node and pep_node_items and then insert those records into the new IM&Presence cluster.  The pep_node table references the xcp_user_id which is different than the actual user ID so you have to export those mappings from the old cluster and then find the new xcp_user_id's on the new cluster.  XCP Router must also be restarted after doing the Inserts.</div><div><br></div><div>I was able to write a Python script to handle the export/import.</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, Dec 4, 2019 at 5:17 PM Anthony Holloway <<a href="mailto:avholloway%2Bcisco-voip@gmail.com" target="_blank" rel="noreferrer">avholloway+cisco-voip@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">It does seem to be held in the external database.  The IM&P server might just be compiling the my rooms list dynamically for the user at login, versus it being held in any one spot.<div><br></div><div><h2 id="m_3748981714763916565gmail-m_9009530509111126887gmail-m_2997015913427842000gmail-ariaid-title11" style="margin:0px 0px 8px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:400;font-stretch:inherit;line-height:1.22222em;font-family:inherit;vertical-align:baseline;color:rgb(57,57,59)"><font size="2">TC_ROOMS Table</font></h2><p id="m_3748981714763916565gmail-m_9009530509111126887gmail-m_2997015913427842000gmail-CUP0_RF_TCBD4E17_00__p18" style="margin:12px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline">The TC_ROOMS table contains information for group chat rooms.</p><div style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;overflow:auto visible"><table width="100%" border="1" id="m_3748981714763916565gmail-m_9009530509111126887gmail-m_2997015913427842000gmail-CUP0_RF_TCBD4E17_00__table_268059D86D2B4DCE925FEB2AE7FB68CC" style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;border-collapse:collapse;border-spacing:0px;max-width:100%;overflow:auto visible;width:initial"><caption style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;text-align:left"></caption><colgroup><col><col><col style="width:72.65pt"><col style="width:70.31pt"><col style="width:37.69pt"><col style="width:252.44pt"></colgroup><thead style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline"><tr style="margin:0px auto;padding:0px 22px;border:0px solid transparent;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;box-sizing:border-box;background-color:transparent;max-width:1280px;width:823px;column-gap:24px;background-clip:padding-box"><th id="m_3748981714763916565gmail-m_9009530509111126887gmail-m_2997015913427842000gmail-CUP0_RF_TCBD4E17_00__table_268059D86D2B4DCE925FEB2AE7FB68CC__entry__1" style="margin:0px;padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:400;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline">Column Name</p></th><th id="m_3748981714763916565gmail-m_9009530509111126887gmail-m_2997015913427842000gmail-CUP0_RF_TCBD4E17_00__table_268059D86D2B4DCE925FEB2AE7FB68CC__entry__2" style="margin:0px;padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:400;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline">Postgres Datatype</p></th><th id="m_3748981714763916565gmail-m_9009530509111126887gmail-m_2997015913427842000gmail-CUP0_RF_TCBD4E17_00__table_268059D86D2B4DCE925FEB2AE7FB68CC__entry__3" style="margin:0px;padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:400;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline">Oracle Datatype</p></th><th id="m_3748981714763916565gmail-m_9009530509111126887gmail-m_2997015913427842000gmail-CUP0_RF_TCBD4E17_00__table_268059D86D2B4DCE925FEB2AE7FB68CC__entry__4" style="margin:0px;padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:400;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline">Microsoft SQL Datatype</p></th><th id="m_3748981714763916565gmail-m_9009530509111126887gmail-m_2997015913427842000gmail-CUP0_RF_TCBD4E17_00__table_268059D86D2B4DCE925FEB2AE7FB68CC__entry__5" style="margin:0px;padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:400;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline">Not Null</p></th><th id="m_3748981714763916565gmail-m_9009530509111126887gmail-m_2997015913427842000gmail-CUP0_RF_TCBD4E17_00__table_268059D86D2B4DCE925FEB2AE7FB68CC__entry__6" style="margin:0px;padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:400;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline">Description</p></th></tr></thead><tbody style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline"><tr style="margin:0px auto;padding:0px 22px;border:0px solid transparent;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;box-sizing:border-box;background-color:transparent;max-width:1280px;width:823px;column-gap:24px;background-clip:padding-box"><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_TCBD4E17_00__table_268059D86D2B4DCE925FEB2AE7FB68CC__entry__1" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline">ROOM_JID</p></td><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_TCBD4E17_00__table_268059D86D2B4DCE925FEB2AE7FB68CC__entry__2" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline">VARCHAR (3071)</p></td><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_TCBD4E17_00__table_268059D86D2B4DCE925FEB2AE7FB68CC__entry__3" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline">VARCHAR2 (3071)</p></td><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_TCBD4E17_00__table_268059D86D2B4DCE925FEB2AE7FB68CC__entry__4" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline">varchar (3071)</p></td><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_TCBD4E17_00__table_268059D86D2B4DCE925FEB2AE7FB68CC__entry__5" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline">Yes</p></td><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_TCBD4E17_00__table_268059D86D2B4DCE925FEB2AE7FB68CC__entry__6" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline">The ID of the room.</p></td></tr><tr style="margin:0px auto;padding:0px 22px;border:0px solid transparent;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;box-sizing:border-box;background-color:transparent;max-width:1280px;width:823px;column-gap:24px;background-clip:padding-box"><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_TCBD4E17_00__table_268059D86D2B4DCE925FEB2AE7FB68CC__entry__1" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline">CREATOR_JID</p></td><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_TCBD4E17_00__table_268059D86D2B4DCE925FEB2AE7FB68CC__entry__2" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline">VARCHAR (3071)</p></td><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_TCBD4E17_00__table_268059D86D2B4DCE925FEB2AE7FB68CC__entry__3" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline">VARCHAR2 (3071)</p></td><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_TCBD4E17_00__table_268059D86D2B4DCE925FEB2AE7FB68CC__entry__4" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline">varchar (3071)</p></td><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_TCBD4E17_00__table_268059D86D2B4DCE925FEB2AE7FB68CC__entry__5" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline">Yes</p></td><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_TCBD4E17_00__table_268059D86D2B4DCE925FEB2AE7FB68CC__entry__6" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline">The ID of the user who created the room.</p></td></tr><tr style="margin:0px auto;padding:0px 22px;border:0px solid transparent;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;box-sizing:border-box;background-color:transparent;max-width:1280px;width:823px;column-gap:24px;background-clip:padding-box"><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_TCBD4E17_00__table_268059D86D2B4DCE925FEB2AE7FB68CC__entry__1" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline">SUBJECT</p></td><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_TCBD4E17_00__table_268059D86D2B4DCE925FEB2AE7FB68CC__entry__2" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline">VARCHAR (255)</p></td><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_TCBD4E17_00__table_268059D86D2B4DCE925FEB2AE7FB68CC__entry__3" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline">VARCHAR2 (255)</p></td><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_TCBD4E17_00__table_268059D86D2B4DCE925FEB2AE7FB68CC__entry__4" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline">varchar (255)</p></td><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_TCBD4E17_00__table_268059D86D2B4DCE925FEB2AE7FB68CC__entry__5" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline">Yes</p></td><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_TCBD4E17_00__table_268059D86D2B4DCE925FEB2AE7FB68CC__entry__6" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline">The current subject for the room.</p></td></tr><tr style="margin:0px auto;padding:0px 22px;border:0px solid transparent;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;box-sizing:border-box;background-color:transparent;max-width:1280px;width:823px;column-gap:24px;background-clip:padding-box"><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_TCBD4E17_00__table_268059D86D2B4DCE925FEB2AE7FB68CC__entry__1" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline">TYPE</p></td><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_TCBD4E17_00__table_268059D86D2B4DCE925FEB2AE7FB68CC__entry__2" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline">VARCHAR (32)</p></td><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_TCBD4E17_00__table_268059D86D2B4DCE925FEB2AE7FB68CC__entry__3" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline">VARCHAR2 (32)</p></td><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_TCBD4E17_00__table_268059D86D2B4DCE925FEB2AE7FB68CC__entry__4" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline">varchar (32)</p></td><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_TCBD4E17_00__table_268059D86D2B4DCE925FEB2AE7FB68CC__entry__5" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline">Yes</p></td><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_TCBD4E17_00__table_268059D86D2B4DCE925FEB2AE7FB68CC__entry__6" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline">The constraint check_type. This value must be either <span style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline">"ad-hoc"</span> or <span style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline">"persistent"</span>.</p></td></tr><tr style="margin:0px auto;padding:0px 22px;border:0px solid transparent;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;box-sizing:border-box;background-color:transparent;max-width:1280px;width:823px;column-gap:24px;background-clip:padding-box"><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_TCBD4E17_00__table_268059D86D2B4DCE925FEB2AE7FB68CC__entry__1" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline">CONFIG</p></td><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_TCBD4E17_00__table_268059D86D2B4DCE925FEB2AE7FB68CC__entry__2" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline">TEXT</p></td><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_TCBD4E17_00__table_268059D86D2B4DCE925FEB2AE7FB68CC__entry__3" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline">CLOB</p></td><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_TCBD4E17_00__table_268059D86D2B4DCE925FEB2AE7FB68CC__entry__4" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline">text</p></td><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_TCBD4E17_00__table_268059D86D2B4DCE925FEB2AE7FB68CC__entry__5" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline">Yes</p></td><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_TCBD4E17_00__table_268059D86D2B4DCE925FEB2AE7FB68CC__entry__6" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline">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).</p></td></tr><tr style="margin:0px auto;padding:0px 22px;border:0px solid transparent;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;box-sizing:border-box;background-color:transparent;max-width:1280px;width:823px;column-gap:24px;background-clip:padding-box"><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_TCBD4E17_00__table_268059D86D2B4DCE925FEB2AE7FB68CC__entry__1" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline">SPACKET</p></td><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_TCBD4E17_00__table_268059D86D2B4DCE925FEB2AE7FB68CC__entry__2" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline">TEXT</p></td><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_TCBD4E17_00__table_268059D86D2B4DCE925FEB2AE7FB68CC__entry__3" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline">CLOB</p></td><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_TCBD4E17_00__table_268059D86D2B4DCE925FEB2AE7FB68CC__entry__4" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline">text</p></td><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_TCBD4E17_00__table_268059D86D2B4DCE925FEB2AE7FB68CC__entry__5" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline">Yes</p></td><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_TCBD4E17_00__table_268059D86D2B4DCE925FEB2AE7FB68CC__entry__6" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline">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.</p></td></tr><tr style="margin:0px auto;padding:0px 22px;border:0px solid transparent;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;box-sizing:border-box;background-color:transparent;max-width:1280px;width:823px;column-gap:24px;background-clip:padding-box"><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_TCBD4E17_00__table_268059D86D2B4DCE925FEB2AE7FB68CC__entry__1" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline">START_MSG_ID</p></td><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_TCBD4E17_00__table_268059D86D2B4DCE925FEB2AE7FB68CC__entry__2" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline">BIGINT</p></td><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_TCBD4E17_00__table_268059D86D2B4DCE925FEB2AE7FB68CC__entry__3" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline">NUMBER (19)</p></td><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_TCBD4E17_00__table_268059D86D2B4DCE925FEB2AE7FB68CC__entry__4" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline">bigint</p></td><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_TCBD4E17_00__table_268059D86D2B4DCE925FEB2AE7FB68CC__entry__5" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline">Yes</p></td><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_TCBD4E17_00__table_268059D86D2B4DCE925FEB2AE7FB68CC__entry__6" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline">A sequence number that is used to populate the MSG_ID column in the TC_MSGARCHIVE table.</p><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline">Do not modify this value.</p></td></tr><tr style="margin:0px auto;padding:0px 22px;border:0px solid transparent;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;box-sizing:border-box;background-color:transparent;max-width:1280px;width:823px;column-gap:24px;background-clip:padding-box"><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_TCBD4E17_00__table_268059D86D2B4DCE925FEB2AE7FB68CC__entry__1" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline">NEXT_MSG_ID</p></td><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_TCBD4E17_00__table_268059D86D2B4DCE925FEB2AE7FB68CC__entry__2" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline">BIGINT</p></td><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_TCBD4E17_00__table_268059D86D2B4DCE925FEB2AE7FB68CC__entry__3" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline">NUMBER (19)</p></td><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_TCBD4E17_00__table_268059D86D2B4DCE925FEB2AE7FB68CC__entry__4" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline">bigint</p></td><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_TCBD4E17_00__table_268059D86D2B4DCE925FEB2AE7FB68CC__entry__5" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline">Yes</p></td><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_TCBD4E17_00__table_268059D86D2B4DCE925FEB2AE7FB68CC__entry__6" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline">A sequence number that is used to populate the MSG_ID column in the TC_MSGARCHIVE table.</p><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline">Do not modify this value.</p></td></tr></tbody></table></div><h2 id="m_3748981714763916565gmail-m_9009530509111126887gmail-m_2997015913427842000gmail-ariaid-title12" style="margin:0px 0px 8px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:400;font-stretch:inherit;line-height:1.22222em;font-family:inherit;vertical-align:baseline;color:rgb(57,57,59)"><font size="2">TC_USERS Table</font></h2><p id="m_3748981714763916565gmail-m_9009530509111126887gmail-m_2997015913427842000gmail-CUP0_RF_T83847AC_00__p69" style="margin:12px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline"><font size="2">The TC_USERS table contains roles and affiliations, alternate names, and other data associated with group chat room users.</font></p><div style="margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;overflow:auto visible"><table width="100%" border="1" id="m_3748981714763916565gmail-m_9009530509111126887gmail-m_2997015913427842000gmail-CUP0_RF_T83847AC_00__table_D89490E766104EF58E814C78BD286ECC" style="margin:6px 0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;border-collapse:collapse;border-spacing:0px;max-width:100%;overflow:auto visible;width:initial"><caption style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;text-align:left"></caption><colgroup><col><col><col style="width:76pt"><col style="width:73.13pt"><col style="width:59.64pt"><col style="width:249.75pt"></colgroup><thead style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline"><tr style="margin:0px auto;padding:0px 22px;border:0px solid transparent;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;box-sizing:border-box;background-color:transparent;max-width:1280px;width:848px;column-gap:24px;background-clip:padding-box"><th id="m_3748981714763916565gmail-m_9009530509111126887gmail-m_2997015913427842000gmail-CUP0_RF_T83847AC_00__table_D89490E766104EF58E814C78BD286ECC__entry__1" style="margin:0px;padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:400;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline"><font size="2">Column Name</font></p></th><th id="m_3748981714763916565gmail-m_9009530509111126887gmail-m_2997015913427842000gmail-CUP0_RF_T83847AC_00__table_D89490E766104EF58E814C78BD286ECC__entry__2" style="margin:0px;padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:400;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline"><font size="2">Postgres Datatype</font></p></th><th id="m_3748981714763916565gmail-m_9009530509111126887gmail-m_2997015913427842000gmail-CUP0_RF_T83847AC_00__table_D89490E766104EF58E814C78BD286ECC__entry__3" style="margin:0px;padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:400;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline"><font size="2">Oracle Datatype</font></p></th><th id="m_3748981714763916565gmail-m_9009530509111126887gmail-m_2997015913427842000gmail-CUP0_RF_T83847AC_00__table_D89490E766104EF58E814C78BD286ECC__entry__4" style="margin:0px;padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:400;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline"><font size="2">Microsoft SQL Datatype</font></p></th><th id="m_3748981714763916565gmail-m_9009530509111126887gmail-m_2997015913427842000gmail-CUP0_RF_T83847AC_00__table_D89490E766104EF58E814C78BD286ECC__entry__5" style="margin:0px;padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:400;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline"><font size="2">Not Null</font></p></th><th id="m_3748981714763916565gmail-m_9009530509111126887gmail-m_2997015913427842000gmail-CUP0_RF_T83847AC_00__table_D89490E766104EF58E814C78BD286ECC__entry__6" style="margin:0px;padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:400;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline"><font size="2">Description</font></p></th></tr></thead><tbody style="margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline"><tr style="margin:0px auto;padding:0px 22px;border:0px solid transparent;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;box-sizing:border-box;background-color:transparent;max-width:1280px;width:848px;column-gap:24px;background-clip:padding-box"><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_T83847AC_00__table_D89490E766104EF58E814C78BD286ECC__entry__1" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline"><font size="2">ROOM_JID</font></p></td><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_T83847AC_00__table_D89490E766104EF58E814C78BD286ECC__entry__2" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline"><font size="2">VARCHAR (3071)</font></p></td><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_T83847AC_00__table_D89490E766104EF58E814C78BD286ECC__entry__3" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline"><font size="2">VARCHAR2 (3071)</font></p></td><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_T83847AC_00__table_D89490E766104EF58E814C78BD286ECC__entry__4" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline"><font size="2">varchar (3071)</font></p></td><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_T83847AC_00__table_D89490E766104EF58E814C78BD286ECC__entry__5" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline"><font size="2">Yes</font></p></td><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_T83847AC_00__table_D89490E766104EF58E814C78BD286ECC__entry__6" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline"><font size="2">The ID of the room.</font></p></td></tr><tr style="margin:0px auto;padding:0px 22px;border:0px solid transparent;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;box-sizing:border-box;background-color:transparent;max-width:1280px;width:848px;column-gap:24px;background-clip:padding-box"><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_T83847AC_00__table_D89490E766104EF58E814C78BD286ECC__entry__1" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline"><font size="2">REAL_JID</font></p></td><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_T83847AC_00__table_D89490E766104EF58E814C78BD286ECC__entry__2" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline"><font size="2">VARCHAR (3071)</font></p></td><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_T83847AC_00__table_D89490E766104EF58E814C78BD286ECC__entry__3" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline"><font size="2">VARCHAR2 (3071)</font></p></td><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_T83847AC_00__table_D89490E766104EF58E814C78BD286ECC__entry__4" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline"><font size="2">varchar (3071)</font></p></td><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_T83847AC_00__table_D89490E766104EF58E814C78BD286ECC__entry__5" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline"><font size="2">Yes</font></p></td><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_T83847AC_00__table_D89490E766104EF58E814C78BD286ECC__entry__6" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline"><font size="2">The ID of a user in the room. This value is the actual ID of the user, rather than an alternate name.</font></p></td></tr><tr style="margin:0px auto;padding:0px 22px;border:0px solid transparent;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;box-sizing:border-box;background-color:transparent;max-width:1280px;width:848px;column-gap:24px;background-clip:padding-box"><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_T83847AC_00__table_D89490E766104EF58E814C78BD286ECC__entry__1" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline"><font size="2">ROLE</font></p></td><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_T83847AC_00__table_D89490E766104EF58E814C78BD286ECC__entry__2" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline"><font size="2">VARCHAR (32)</font></p></td><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_T83847AC_00__table_D89490E766104EF58E814C78BD286ECC__entry__3" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline"><font size="2">VARCHAR2 (32)</font></p></td><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_T83847AC_00__table_D89490E766104EF58E814C78BD286ECC__entry__4" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline"><font size="2">varchar (32)</font></p></td><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_T83847AC_00__table_D89490E766104EF58E814C78BD286ECC__entry__5" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline"><font size="2">Yes</font></p></td><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_T83847AC_00__table_D89490E766104EF58E814C78BD286ECC__entry__6" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline"><font size="2">The role of the user in the room. This value is constrained to one of the following: <span style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline">"none"</span>, <span style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline">"hidden"</span>, <span style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline">"visitor"</span>, <span style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline">"participant"</span>, or <span style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline">"moderator"</span>.</font></p></td></tr><tr style="margin:0px auto;padding:0px 22px;border:0px solid transparent;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;box-sizing:border-box;background-color:transparent;max-width:1280px;width:848px;column-gap:24px;background-clip:padding-box"><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_T83847AC_00__table_D89490E766104EF58E814C78BD286ECC__entry__1" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline"><font size="2">AFFILIATION</font></p></td><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_T83847AC_00__table_D89490E766104EF58E814C78BD286ECC__entry__2" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline"><font size="2">VARCHAR (32)</font></p></td><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_T83847AC_00__table_D89490E766104EF58E814C78BD286ECC__entry__3" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline"><font size="2">VARCHAR2 (32)</font></p></td><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_T83847AC_00__table_D89490E766104EF58E814C78BD286ECC__entry__4" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline"><font size="2">varchar (32)</font></p></td><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_T83847AC_00__table_D89490E766104EF58E814C78BD286ECC__entry__5" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline"><font size="2">Yes</font></p></td><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_T83847AC_00__table_D89490E766104EF58E814C78BD286ECC__entry__6" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline"><font size="2">The affiliation of the user in the room. This value is constrained to one of the following: <span style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline">"none"</span>, <span style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline">"outcast"</span>, <span style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline">"member"</span>, <span style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline">"admin"</span>, or <span style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline">"owner"</span>.</font></p></td></tr><tr style="margin:0px auto;padding:0px 22px;border:0px solid transparent;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;box-sizing:border-box;background-color:transparent;max-width:1280px;width:848px;column-gap:24px;background-clip:padding-box"><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_T83847AC_00__table_D89490E766104EF58E814C78BD286ECC__entry__1" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline"><font size="2">NICK_JID</font></p></td><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_T83847AC_00__table_D89490E766104EF58E814C78BD286ECC__entry__2" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline"><font size="2">VARCHAR (3071)</font></p></td><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_T83847AC_00__table_D89490E766104EF58E814C78BD286ECC__entry__3" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline"><font size="2">VARCHAR2 (3071)</font></p></td><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_T83847AC_00__table_D89490E766104EF58E814C78BD286ECC__entry__4" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline"><font size="2">varchar (3071)</font></p></td><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_T83847AC_00__table_D89490E766104EF58E814C78BD286ECC__entry__5" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline"><font size="2">Yes</font></p></td><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_T83847AC_00__table_D89490E766104EF58E814C78BD286ECC__entry__6" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline"><font size="2">The ID of the room, plus the alternate name for the user. The format is room@tc-server/nick.</font></p></td></tr><tr style="margin:0px auto;padding:0px 22px;border:0px solid transparent;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;box-sizing:border-box;background-color:transparent;max-width:1280px;width:848px;column-gap:24px;background-clip:padding-box"><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_T83847AC_00__table_D89490E766104EF58E814C78BD286ECC__entry__1" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline"><font size="2">REASON</font></p></td><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_T83847AC_00__table_D89490E766104EF58E814C78BD286ECC__entry__2" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline"><font size="2">VARCHAR (255)</font></p></td><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_T83847AC_00__table_D89490E766104EF58E814C78BD286ECC__entry__3" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline"><font size="2">VARCHAR2 (255)</font></p></td><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_T83847AC_00__table_D89490E766104EF58E814C78BD286ECC__entry__4" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline"><font size="2">varchar (255)</font></p></td><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_T83847AC_00__table_D89490E766104EF58E814C78BD286ECC__entry__5" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline"><font size="2">Yes</font></p></td><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_T83847AC_00__table_D89490E766104EF58E814C78BD286ECC__entry__6" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline"><font size="2">The reason entered when the user's affiliation was last changed.</font></p></td></tr><tr style="margin:0px auto;padding:0px 22px;border:0px solid transparent;font:inherit;vertical-align:baseline;box-sizing:border-box;background-color:transparent;max-width:1280px;width:848px;column-gap:24px;background-clip:padding-box"><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_T83847AC_00__table_D89490E766104EF58E814C78BD286ECC__entry__1" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline"><font size="2">INITIATOR_JID</font></p></td><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_T83847AC_00__table_D89490E766104EF58E814C78BD286ECC__entry__2" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline"><font size="2">VARCHAR (3071)</font></p></td><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_T83847AC_00__table_D89490E766104EF58E814C78BD286ECC__entry__3" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline"><font size="2">VARCHAR2 (3071)</font></p></td><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_T83847AC_00__table_D89490E766104EF58E814C78BD286ECC__entry__4" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline"><font size="2">varchar (3071)</font></p></td><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_T83847AC_00__table_D89490E766104EF58E814C78BD286ECC__entry__5" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline"><font size="2">Yes</font></p></td><td headers="m_3748981714763916565m_9009530509111126887m_2997015913427842000CUP0_RF_T83847AC_00__table_D89490E766104EF58E814C78BD286ECC__entry__6" style="padding:0px 5px;border:1px solid rgb(198,199,202);font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:top"><p style="margin:6px 0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:1.4em;font-family:inherit;vertical-align:baseline"><font size="2">The ID of the room in which the configuration change occurred.</font></p></td></tr></tbody></table></div></div><div><br></div><div>Source: <a href="https://www.cisco.com/c/en/us/td/docs/voice_ip_comm/cucm/im_presence/database_setup/11_5_1/cup0_b_database-setup-guide-imp-115/cup0_b_database-setup-guide-imp-115_chapter_0100.html#CUP0_RF_TCBD4E17_00" target="_blank" rel="noreferrer">https://www.cisco.com/c/en/us/td/docs/voice_ip_comm/cucm/im_presence/database_setup/11_5_1/cup0_b_database-setup-guide-imp-115/cup0_b_database-setup-guide-imp-115_chapter_0100.html#CUP0_RF_TCBD4E17_00</a>  <br></div><div><br><div><br></div><div><br></div></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, Dec 4, 2019 at 3:40 PM Brian Meade <<a href="mailto:bmeade90@vt.edu" target="_blank" rel="noreferrer">bmeade90@vt.edu</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">Does anyone know where the My Rooms information is stored?  It doesn't seem to be in the persistent chat database or stored locally on the client.  Is this stored on IM&P somewhere?</div>
_______________________________________________<br>
cisco-voip mailing list<br>
<a href="mailto:cisco-voip@puck.nether.net" target="_blank" rel="noreferrer">cisco-voip@puck.nether.net</a><br>
<a href="https://puck.nether.net/mailman/listinfo/cisco-voip" rel="noreferrer noreferrer" target="_blank">https://puck.nether.net/mailman/listinfo/cisco-voip</a><br>
</blockquote></div>
</blockquote></div>
</blockquote></div>
</blockquote></div>