sys_attachment_doc Table

[#1]

Does anyone know what the sys_attachment_doc table is used for or how it goes with sys_attachment table?

[#2]

Any attachment you save in the system is broken up into 3k chunks.
Those chunks are then base64 encoded, producing 4k strings.

Those strings are then written out as sequential rows in sys_attachment_doc

There's one "master" entry in sys_attachment describing the file name, file type and whatnot, which, in turn, is associated with a record in the database like "incident INC10002".

The various entries in sys_attachment_doc then relate back to that entry in sys_attachment.

[#3]

Thanks Pat. I should be able to copy an attachment by using these tables on insert of an attachment, correct?

[#4]

You could definitely do that, you'd just have to be real careful and make sure you copy both the sys_attachment record and the multiple sys_attachment_doc records.

[#5]

Nice. It seems to be working now.