RDB$SUBSCRIBERS
Go Up to System Tables
The required Subscriber information is stored in a new system relation RDB$SUBSCRIBERS
| Column name | Data type | Length | Description |
|---|---|---|---|
|
|
|
31 |
Name of subscribing user |
|
|
|
67 |
Name of subscription |
|
|
|
32 |
Destination of subscriber |
|
RDB$FLAGS |
SMALLINT |
2 |
|
|
|
|
8 |
Transaction ID of last subscription check out |
|
RDB$CHECK_OUT_TIMESTAMP |
TIMESTAMP |
8 |
Date and time of last subscription check out |
|
RDB$CHECK_OUT_OLDEST_ TRANSACTION_ID |
INT64 |
8 |
Transaction of oldest active transaction at check out |
|
RDB$CHECK_OUT_TRANSACTIONS |
BLOB |
Set of active transaction IDs at last transaction check out | |
|
RDB$CHECK_IN_TRANSACTION_ID |
INT64 |
8 |
Transaction ID of last subscription check in |
|
RDB$CHECK_IN_TIMESTAMP |
TIMESTAMP |
8 |
Date and time of last subscription check in |
|
RDB$CHECK_IN_TRANSACTIONS |
BLOB |
Set of check in transaction IDs by this subscription |