Skip to main content

Attachments & Files - Key Tables

Full column listings for the 1 key table in this category.

ATTACHMENT (26 columns)

# Column Type Length Nullable Default
1 ATid int NO
2 ATBlob varbinary -1 YES
3 ATFilename nvarchar 4000 YES
4 ATDateCreated datetime YES
5 ATNote nvarchar 4000 YES
6 atfilesize int YES ((0))
7 atType int NO ((0))
8 atUniqueID int NO ((0))
9 ATDesc nvarchar 255 YES
10 aaunum int YES ((0))
11 aauserid int YES ((0))
12 ATshowforusers bit YES ((0))
13 atisimage bit YES ((0))
14 atguid uniqueidentifier YES
15 ATThirdPartyId nvarchar 250 YES
16 atkey nvarchar 200 YES ('')
17 atallowguid bit YES ((0))
18 atencid int YES ((0))
19 ATipaddress nvarchar 100 YES ('')
20 ATImageUse int YES ((0))
21 ATContentType nvarchar 100 YES ('')
22 atlink nvarchar 4000 YES
23 atparentid int YES
24 atlinkedversionid int YES
25 atallowanonupload bit YES
26 atlastupdated datetime YES ((0))
Back to top