What are the different subscriber types recorded on the subscriber table?
The subscriber_types and their values are: 1 – Current Subscriber. The subscribers name, address and protocol are in the same row. 2 – Ex subscriber – A subscriber that unsubscribed but had agent entries in the history aq$_queuetable_h IOT. 4 – Address – Used to store addresses of recipients. The name is always NULL. The address is always non-NULL. 8 – Proxy for Propagation – The name is always NULL. database proxy to local queues, address=NULL, protocol=0 database proxy to remote queues, address=dblink address, protocol=0 3rd party proxies, address = NULL, protocol = 3rd party protocol.