Distribution database table. Associates a subscriber with a particular article. (This is actually subscriber-side information maintained in the distribution database.)
| Column | Datatype | Description |
|---|---|---|
| publisher | varchar(30) | The name of the publishing server. |
| publisher_id | smallint | The local server ID of the publishing server. |
| publisher_db | varchar(30) | The name of the published database. |
| subscriber | varchar(30) | The name of the subscriber. |
| subscriber_id | smallint | The local server ID of the subscribing server. |
| art_id | int | The article ID. |
| subscriber_db | varchar(30) | The name of the database on the subscribing server. |
| status | tinyint | Status: 0 Inactive 1 Subscribed 2 Active |
| ts | binary(8) | The timestamp of the published subscription. |
| status | tinyint | Reserved. |
ucMSsubscriptions clustered, unique on publisher_db, publisher_id, art_id, subscriber_id