H - History B - Binary As mentioned, the H table has two columns for each status you have, one for time, one for user B tables are B<schemaID><fieldID> if I remember correctly...they contain the compressed data that was added to the attachment field with that ID on that form.
_____ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Pargeter, Christie :CO IS Sent: Thursday, March 25, 2010 9:25 AM To: [email protected] Subject: Re: Question on H and T tables in Remedy Schema ** Doesn't the B table contain large fields including attachments? _____ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of ARSmarts Support Sent: Thursday, March 25, 2010 8:24 AM To: [email protected] Subject: Re: Question on H and T tables in Remedy Schema ** The H table contains the status history data. Best regards ARSmarts, your most useful AR System companion. www.ARSmarts.com <http://www.ARSmarts.com/> On 25 Mar 2010, at 16:16, Jim Coryat wrote: ** I have a quick question on the tables in the Remedy schema. I know that the T prefixed tables are the actual form data. What function do the H prefixed tables provide? Our EIE:Log form has over 60 million rows. We want to truncate the table and them implement purging for the form. Thinking we can implement the purging and have it purge the rows is not realistic. However I don't want to do this and have some other dependent forms start having issues because of this action. Jim Coryat Micron Technology Inc. ITIL v2 Practitioner Certified _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
