共用方式為


3.1.1.3.24 SubscriptionPublisherProperties Table

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

Table identifier: {5A84E824-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

SubscriberPartitionIdentifier

eDT_GUID

16

0x00000003

RO

-

2

SubscriberConglomerationIdentifier

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 SubscriptionPartitionIdentifier property of the subscription.

SubscriberConglomerationIdentifier: The SubscriberConglomerationIdentifier property of the subscription.

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

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

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