Table Name Index Name Column Name ========================================================================================== ACL ACL1 RIGHTNAME OBJECTTYPE OBJECTID PRINCIPALTYPE PRINCIPALID ACL_KEY ID ========================================================================================== ATTACHMENTS ATTACHMENTS2 TRANSACTIONID ATTACHMENTS3 PARENT TRANSACTIONID ATTACHMENTS_KEY ID ========================================================================================== ATTRIBUTES ATTRIBUTES1 NAME ATTRIBUTES2 OBJECTTYPE OBJECTID SYS_C007890 ID ========================================================================================== CACHEDGROUPMEMBERS CACHEDGROUPMEMBERS_KEY ID CACHEDGRPMEM_MEMBER MEMBERID DISGROUMEM GROUPID MEMBERID DISABLED GROUMEM GROUPID MEMBERID ========================================================================================== CUSTOMFIELDS CUSTOMFIELDS1 DISABLED QUEUE CUSTOMFIELDS_KEY ID ========================================================================================== CUSTOMFIELDVALUES CUSTOMFIELDVALUES1 CUSTOMFIELD CUSTOMFIELDVALUES_KEY ID ========================================================================================== GROUPMEMBERS GROUPMEMBERS1 GROUPID MEMBERID GROUPMEMBERS_KEY ID ========================================================================================== GROUPS GROUPS1 LOWER("DOMAIN") INSTANCE LOWER("TYPE") ID GROUPS2 LOWER("TYPE") INSTANCE LOWER("DOMAIN") GROUPS3 LOWER("DOMAIN") LOWER("TYPE") GROUPS4 DOMAIN ID GROUPS5 INSTANCE GROUPS_KEY ID ========================================================================================== LINKS LINKS1 BASE TARGET TYPE LINKS2 BASE TYPE LINKS3 TARGET TYPE LINKS4 TYPE LOCALBASE LINKS_KEY ID ========================================================================================== PRINCIPALS PRINCIPALS2 OBJECTID PRINCIPALS_KEY ID ========================================================================================== QUEUES QUEUES1 LOWER("NAME") QUEUES2 DISABLED QUEUES_KEY ID QUEUES_NAME_UNIQUE NAME ========================================================================================== SCRIPACTIONS SCRIPACTIONS_KEY ID ========================================================================================== SCRIPCONDITIONS SCRIPCONDITIONS_KEY ID ========================================================================================== SCRIPS SCRIPS_KEY ID ========================================================================================== SESSIONS SESSIONS_KEY ID ========================================================================================== TEMPLATES TEMPLATES_KEY ID ========================================================================================== TICKETCUSTOMFIELDVALUES TICKETCUSTOMFIELDVALUES1 CUSTOMFIELD TICKET CONTENT TICKETCUSTOMFIELDVALUES2 CUSTOMFIELD TICKET TICKETCUSTOMFIELDVALUES_KEY ID ========================================================================================== TICKETS TICKETS1 QUEUE STATUS TICKETS2 OWNER TICKETS4 ID STATUS TICKETS5 ID EFFECTIVEID TICKETS6 EFFECTIVEID TYPE TICKETS7 OWNER STATUS TICKETS_KEY ID ========================================================================================== TRANSACTIONS TRANSACTIONS1 TICKET TRANSACTIONS2 EFFECTIVETICKET TRANSACTIONS_KEY ID ========================================================================================== USERS USERS2 LOWER("NAME") USERS4 LOWER("EMAILADDRESS") USERS_KEY ID USERS_NAME_UNIQUE NAME