Export (0) Print
Expand All

Schema

[Windows Search 2.x is obsolete after Windows XP. Instead, use Windows Search.]

The schema documents the values and properties that the index uses to store data for indexing or sorting. The Schema table lists the columns and their properties (type and propid) included in the schema for Microsoft Windows Desktop Search (WDS) 2.6.5.

Schema

Column NameDescriptionPropid
DocCommentsCommentsF29F85E0-4FF9-1068-AB91-08002B27B3D9/6
CreateDate and time the file was createdB725F130-47EF-101A-A5F1-02608C9EEBAC/15
DisplayFolderUser-friendly folder for itemD5CDD505-2E9C-101B-9397-08002B2CF9AE/DisplayFolder
DocAuthorAuthor of the documentF29F85E0-4FF9-1068-AB91-08002B27B3D9/4
DocCategoryCategoryD5CDD502-2E9C-101B-9397-08002B2CF9AE/2
DocKeywordsKeywordsF29F85E0-4FF9-1068-AB91-08002B27B3D9/5
DocTitlePrefixPrefix of subject (Re:, Fw:, etc.)D5CDD505-2E9C-101B-9397-08002B2CF9AE/DocTitlePrefix
DocTitleTitleF29F85E0-4FF9-1068-AB91-08002B27B3D9/2
FileExtDescUser-friendly description of the file type from the registry (Ex: .psq --> Product Studio Query File)D5CDD505-2E9C-101B-9397-08002B2CF9AE/FileExtDesc
FolderNameName of the parent folderD5CDD505-2E9C-101B-9397-08002B2CF9AE/FolderName
IsAttachmentIndicates item is an attachmentD5CDD505-2E9C-101B-9397-08002B2CF9AE/IsAttachment
IsDeletedIndicates item is marked for deletion (Recycle bin, deleted items, etc.)D5CDD505-2E9C-101B-9397-08002B2CF9AE/IsDeleted
LastViewedDate the item was last viewed by userD5CDD505-2E9C-101B-9397-08002B2CF9AE/LastViewed
PeoplePeople involved with this itemD5CDD505-2E9C-101B-9397-08002B2CF9AE/People
PerceivedTypePerceivedType of the object NOTE: This is only for retrieval.D5CDD505-2E9C-101B-9397-08002B2CF9AE/PerceivedType
PerceivedTypeNameDisplay name of the PerceivedType.  Never displayed or queriedD5CDD505-2E9C-101B-9397-08002B2CF9AE/PerceivedTypeName
PrimaryDateMost interesting date (Last write time for files, date received for email)D5CDD505-2E9C-101B-9397-08002B2CF9AE/PrimaryDate
SizeSize of a file.B725F130-47EF-101A-A5F1-02608C9EEBAC/12
DocSubjectSubject of file. NOTE: Currently, email subjects map to PrimaryTitle today and don't get duplicated due to their lengthF29F85E0-4FF9-1068-AB91-08002B27B3D9/3
URLQuery-based URL49691C90-7E17-101A-A91C-08002B2ECDA9/9
WriteDate and time of the last write to the fileB725F130-47EF-101A-A5F1-02608C9EEBAC/14
DueDateDate an item is dueD5CDD505-2E9C-101B-9397-08002B2CF9AE/DueDate
IsIncompleteIndicates item is not fully availableD5CDD505-2E9C-101B-9397-08002B2CF9AE/IsIncomplete
IsFlaggedCompletedIndicates item is flagged as completedD5CDD505-2E9C-101B-9397-08002B2CF9AE/IsFlaggedCompleted
IsFlaggedIndicates item is flaggedD5CDD505-2E9C-101B-9397-08002B2CF9AE/IsFlagged
FlagTextText displayed for the flag, e.g., Review, Follow up, etc.D5CDD505-2E9C-101B-9397-08002B2CF9AE/FlagText
IdentityIdentity for OE usersD5CDD505-2E9C-101B-9397-08002B2CF9AE/Identity
IsReadIndicates item has been readD5CDD505-2E9C-101B-9397-08002B2CF9AE/IsRead
ImportanceMAPI importance or priorityD5CDD505-2E9C-101B-9397-08002B2CF9AE/Importance
ContainerHashHash code that identifies attachments to be deleted based on a common container URLD5CDD505-2E9C-101B-9397-08002B2CF9AE/ContainerHash
DocFormatDocument format or MIMETYPE (for example 'message/rfc822' for an EML file)0B63E350-9CCC-11D0-BCDB-00805FCCCE04/5
GatherTimeModifiedTime the indexer last crawled the document for catalog update0b63e350-9ccc-11d0-bcdb-00805fccce04/4
StoreThe store or protocol handler (FILE, MAIL, OUTLOOKEXPRESS)D5CDD505-2E9C-101B-9397-08002B2CF9AE/Store
FileExtFile extensionD5CDD505-2E9C-101B-9397-08002B2CF9AE/FileExt
FileNameName of the fileB725F130-47EF-101A-A5F1-02608C9EEBAC/10
ShortNameShort (8.3) file name for the fileB725F130-47EF-101A-A5F1-02608C9EEBAC/20
AttachmentNamesNames of attachments in a messageD5CDD505-2E9C-101B-9397-08002B2CF9AE/AttachmentNames
BccAddressAddresses in Bcc: fieldD5CDD505-2E9C-101B-9397-08002B2CF9AE/BccAddress
BccNamePerson names in Bcc: fieldD5CDD505-2E9C-101B-9397-08002B2CF9AE/BccName
CcAddressAddresses in Cc: fieldD5CDD505-2E9C-101B-9397-08002B2CF9AE/CcAddress
CcNamePerson names in Cc: fieldD5CDD505-2E9C-101B-9397-08002B2CF9AE/CcName
ConversationIDUnique ID for a conversation in email threadsD5CDD505-2E9C-101B-9397-08002B2CF9AE/ConversationID
FromAddressAddresses in From: fieldD5CDD505-2E9C-101B-9397-08002B2CF9AE/FromAddress
FromNamePerson name in From: fieldD5CDD505-2E9C-101B-9397-08002B2CF9AE/FromName
FwdRplyIndicates mail was replied to or forwarded (cdoPR_ACTION=261 262)D5CDD505-2E9C-101B-9397-08002B2CF9AE/FwdRply
HasAttachIndicates mail has an attachment (T or F)D5CDD505-2E9C-101B-9397-08002B2CF9AE/HasAttach
ReceivedDateDelivery timeD5CDD505-2E9C-101B-9397-08002B2CF9AE/ReceivedDate
ToAddressAddresses in To: fieldD5CDD505-2E9C-101B-9397-08002B2CF9AE/ToAddress
ToNamePerson names in To: fieldD5CDD505-2E9C-101B-9397-08002B2CF9AE/ToName
TaskStatusStatus of a taskD5CDD505-2E9C-101B-9397-08002B2CF9AE/TaskStatus
EndDateEnd time (usually for meetings/events)D5CDD505-2E9C-101B-9397-08002B2CF9AE/EndDate
IsRecurringIndicates item is recurring (e.g., meetings)D5CDD505-2E9C-101B-9397-08002B2CF9AE/IsRecurring
StartDateStart time (usually for meetings/events)D5CDD505-2E9C-101B-9397-08002B2CF9AE/StartDate
DurationLength of meeting in minutesD5CDD505-2E9C-101B-9397-08002B2CF9AE/Duration
LocationLocation where item (like a meeting) occursD5CDD505-2E9C-101B-9397-08002B2CF9AE/Location
AnniversaryAnniversary dateD5CDD505-2E9C-101B-9397-08002B2CF9AE/Anniversary
AssistantNameAssistant nameD5CDD505-2E9C-101B-9397-08002B2CF9AE/AssistantName
AssistantTelephoneAssistant telephoneD5CDD505-2E9C-101B-9397-08002B2CF9AE/AssistantTelephone
BirthdayBirthday of contactD5CDD505-2E9C-101B-9397-08002B2CF9AE/Birthday
BusinessAddressCityBusiness address infoD5CDD505-2E9C-101B-9397-08002B2CF9AE/BusinessAddressCity
BusinessAddressPostalCodeBusiness address infoD5CDD505-2E9C-101B-9397-08002B2CF9AE/BusinessAddressPostalCode
BusinessAddressPostOfficeBoxBusiness address infoD5CDD505-2E9C-101B-9397-08002B2CF9AE/BusinessAddressPostOfficeBox
BusinessAddressStateBusiness address infoD5CDD505-2E9C-101B-9397-08002B2CF9AE/BusinessAddressState
BusinessAddressStreetBusiness address infoD5CDD505-2E9C-101B-9397-08002B2CF9AE/BusinessAddressStreet
BusinessAddressCountryBusiness address infoD5CDD505-2E9C-101B-9397-08002B2CF9AE/BusinessAddressCountry
CallbackTelephoneCall back telephone infoD5CDD505-2E9C-101B-9397-08002B2CF9AE/CallbackTelephone
CarTelephoneTelephone infoD5CDD505-2E9C-101B-9397-08002B2CF9AE/CarTelephone
ChildrenChildren's names for contactD5CDD505-2E9C-101B-9397-08002B2CF9AE/Children
CompanyMainTelephoneTelephone infoD5CDD505-2E9C-101B-9397-08002B2CF9AE/CompanyMainTelephone
EmailAddressContact email nameD5CDD505-2E9C-101B-9397-08002B2CF9AE/EmailAddress
EmailNameDisplay name for email addressD5CDD505-2E9C-101B-9397-08002B2CF9AE/EmailName
FirstNameContact's first nameD5CDD505-2E9C-101B-9397-08002B2CF9AE/FirstName
FullNameContact's full nameD5CDD505-2E9C-101B-9397-08002B2CF9AE/FullName
GenderMale/female/otherD5CDD505-2E9C-101B-9397-08002B2CF9AE/Gender
HobbyContact infoD5CDD505-2E9C-101B-9397-08002B2CF9AE/Hobby
HomeAddressCityHome address infoD5CDD505-2E9C-101B-9397-08002B2CF9AE/HomeAddressCity
HomeAddressCountryHome address infoD5CDD505-2E9C-101B-9397-08002B2CF9AE/HomeAddressCountry
HomeAddressPostalCodeHome address infoD5CDD505-2E9C-101B-9397-08002B2CF9AE/HomeAddressPostalCode
HomeAddressStateHome address infoD5CDD505-2E9C-101B-9397-08002B2CF9AE/HomeAddressState
HomeAddressStreetHome address infoD5CDD505-2E9C-101B-9397-08002B2CF9AE/HomeAddressStreet
HomeFaxNumberFacsimile infoD5CDD505-2E9C-101B-9397-08002B2CF9AE/HomeFaxNumber
BusinessFaxNumberFacsimile infoD5CDD505-2E9C-101B-9397-08002B2CF9AE/BusinessFaxNumber
HomeTelephoneTelephone infoD5CDD505-2E9C-101B-9397-08002B2CF9AE/HomeTelephone
IMAddressInstant message infoD5CDD505-2E9C-101B-9397-08002B2CF9AE/IMAddress
JobTitleContact's job titleD5CDD505-2E9C-101B-9397-08002B2CF9AE/JobTitle
MiddleNameContact infoD5CDD505-2E9C-101B-9397-08002B2CF9AE/MiddleName
MobileTelephoneTelephone infoD5CDD505-2E9C-101B-9397-08002B2CF9AE/MobileTelephone
NickNameContact infoD5CDD505-2E9C-101B-9397-08002B2CF9AE/NickName
OfficeContact infoD5CDD505-2E9C-101B-9397-08002B2CF9AE/Office
OfficeTelephoneTelephone infoD5CDD505-2E9C-101B-9397-08002B2CF9AE/OfficeTelephone
PagerTelephoneTelephone infoD5CDD505-2E9C-101B-9397-08002B2CF9AE/PagerTelephone
LastNameContact infoD5CDD505-2E9C-101B-9397-08002B2CF9AE/LastName
PersonalTitleProfession title (Dr., Mr., Mrs., Ms.)D5CDD505-2E9C-101B-9397-08002B2CF9AE/PersonalTitle
PrimaryTelephoneTelephone infoD5CDD505-2E9C-101B-9397-08002B2CF9AE/PrimaryTelephone
ProfessionContact infoD5CDD505-2E9C-101B-9397-08002B2CF9AE/Profession
SpouseContact infoD5CDD505-2E9C-101B-9397-08002B2CF9AE/Spouse
SuffixContact infoD5CDD505-2E9C-101B-9397-08002B2CF9AE/Suffix
TelexNumberTelex infoD5CDD505-2E9C-101B-9397-08002B2CF9AE/TelexNumber
TTYTDDTelephoneTTY/TDD infoD5CDD505-2E9C-101B-9397-08002B2CF9AE/TTYTDDTelephone
WebPageContact web pageD5CDD505-2E9C-101B-9397-08002B2CF9AE/WebPage
DocCompanyCompanyD5CDD502-2E9C-101B-9397-08002B2CF9AE/15
DocLastAuthorUser the doc wa last saved byF29F85E0-4FF9-1068-AB91-08002B27B3D9/8
DocLastPrintedLast PrintedF29F85E0-4FF9-1068-AB91-08002B27B3D9/11
DocManagerManagerD5CDD502-2E9C-101B-9397-08002B2CF9AE/14
DocPresentationFormatPresentationTargetD5CDD502-2E9C-101B-9397-08002B2CF9AE/3
DocSlideCountSlidesD5CDD502-2E9C-101B-9397-08002B2CF9AE/7
AudioAvgDataRateAverage data rate in Kbps for the audio file64440490-4C8B-11D1-8B70-080036B11A03/4
AudioTimeLengthLength in milliseconds of the audio file56A3372E-CE9C-11D2-9F0E-006097C686F6/8
MusicAlbumAlbum name56A3372E-CE9C-11D2-9F0E-006097C686F6/4
MusicArtistName of the artist56A3372E-CE9C-11D2-9F0E-006097C686F6/2
MusicGenreGenre of the album56A3372E-CE9C-11D2-9F0E-006097C686F6/11
MusicTrackNumber of tracks in the album56A3372E-CE9C-11D2-9F0E-006097C686F6/7
MusicYearYear in which the album was recorded56A3372E-CE9C-11D2-9F0E-006097C686F6/5
ExifCameraMakeManufacturer of camera14B81DA1-0135-4D31-96D9-6CBFC9671A99/271
ExifCameraModelModel of camera14B81DA1-0135-4D31-96D9-6CBFC9671A99/272
DateTakenFILETIME of data takenD5CDD505-2E9C-101B-9397-08002B2CF9AE/DateTaken
ExifOrientationOrientation14B81DA1-0135-4D31-96D9-6CBFC9671A99/274
ImageDimensionsDimensions of the image6444048F-4C8B-11D1-8B70-080036B11A03/13
ImageResXX resolution for the image6444048F-4C8B-11D1-8B70-080036B11A03/5
ImageResYY resolution for the image6444048F-4C8B-11D1-8B70-080036B11A03/6
VideoFrameHeightFrame height for the video stream64440491-4C8B-11D1-8B70-080036B11A03/4
VideoFrameRateFrame rate in frames per millisecond for the video stream64440491-4C8B-11D1-8B70-080036B11A03/6
VideoFrameWidthFrame width for the video stream64440491-4C8B-11D1-8B70-080036B11A03/3
ClassClass name8dee0300-16c2-101b-b121-08002b2ecda9/class
FunctionFunction name8dee0300-16c2-101b-b121-08002b2ecda9/func
StructStructure name8dee0300-16c2-101b-b121-08002b2ecda9/struct
InterfaceInterface name8dee0300-16c2-101b-b121-08002b2ecda9/interface
DelegateDelegate name8dee0300-16c2-101b-b121-08002b2ecda9/delegate
PropertyProperty name8dee0300-16c2-101b-b121-08002b2ecda9/property
EnumEnum name8dee0300-16c2-101b-b121-08002b2ecda9/enum
ConstConst name8dee0300-16c2-101b-b121-08002b2ecda9/const
EventEvent name8dee0300-16c2-101b-b121-08002b2ecda9/event
FieldField name8dee0300-16c2-101b-b121-08002b2ecda9/field
DefineDefine name8dee0300-16c2-101b-b121-08002b2ecda9/def
ComponentComponent name8dee0300-16c2-101b-b121-08002b2ecda9/component
ProjectProject name8dee0300-16c2-101b-b121-08002b2ecda9/project
SolutionSolution name8dee0300-16c2-101b-b121-08002b2ecda9/solution

 

Related topics

Reference
Developing IFilter Add-ins
Developing Protocol Handlers
Advanced Query Syntax
Perceived Types

 

 

Build date: 7/12/2013

Community Additions

ADD
Show:
© 2014 Microsoft