Share via

3.1.1.3.25 SubscriptionSubscriberProperties Table

  • Article

The entries in the SubscriptionSubscriberProperties table represent properties associated with the subscriber for a persistent subscription in a publisher-subscriber framework.

Table identifier: {5A84E825-7277-11D2-9029-3078302C2030}

AuxiliaryGuid: {EB56EAE8-BA51-11D2-B121-00805FC73204}

Defined in catalog version: All catalog versions.

Prerequisites: None.

Hidden bitness property: No.

Supported query templates:

  • Catalog version 3.00.

    Cell 1

    SubscriptionIdentifier equals <A>.

  • Catalog version 4.00 and catalog version 5.00.

    Cell 1

    Cell 2

    Cell 3

    SubscriberConglomerationIdentifier equals <A>.

    SubscriberPartitionIdentifier equals <B>.

    SubscriptionIdentifier equals <C>.

Primary key:

  • Catalog version 3.00: SubscriptionIdentifier, Name

  • Catalog version 4.00 and catalog version 5.00: SubscriptionIdentifier, SubscriberPartitionIdentifier, SubscriberConglomerationIdentifier, Name

Other referential constraints:

  • Catalog version 3.00: There MUST exist an entry in the Subscriptions table with an identical value of SubscriptionIdentifier.

  • Catalog version 4.00 and catalog version 5.00: There MUST exist an entry in the Subscriptions table with identical values of SubscriptionIdentifier, SubscriberPartitionIdentifier, and SubscriberConglomerationIdentifier.

Write restrictions: No restrictions.

Cascade: None.

Populate: None.

Properties:

 Index (3.00)

 Index (4.00/5.00)

 Property name

 Type

 Size

 Flags

Meta

0

0

SubscriptionIdentifier

eDT_GUID

16

0x00000003

RO

-

1

SubscriptionPartitionIdentifier

eDT_GUID

16

0x00000003

RO

-

2

SubscriptionConglomerationIdentifier

eDT_GUID

16

0x00000003

RO

1

3

Name

eDT_LPWSTR

variable

0x00000003

RO

2

4

Type

eDT_ULONG

4

0x00000002

3

5

Value

eDT_BYTES

variable

0x00000000

SubscriptionIdentifier: The SubscriptionIdentifier property of the subscription.

SubscriberPartitionIdentifier: The partition of the Subscriber component.

SubscriberConglomerationIdentifier: The application of the Subscriber component.

Name: A NameProperty (section 2.2.2.6) providing a human-readable name of application-specific subscriber property.<257>

Type: A SubscriptionPropertyTypeProperty (section 2.2.2.32.1) identifying the type of the application-specific subscriber property.

Value: A SubscriptionPropertyValueProperty (section 2.2.2.32.2) containing an encoding of the subscriber property's value according to the type specified by the Type property.<258>