psa.Subscriptions

Overview

Column Descriptions

id –
object_id –
object_type –
locked –
synchronized –
custom –
uuid –

CREATE TABLE `Subscriptions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `object_id` int(10) unsigned NOT NULL,
  `object_type` enum('client','domain') NOT NULL,
  `locked` enum('true','false') NOT NULL DEFAULT 'false',
  `synchronized` enum('true','false') NOT NULL DEFAULT 'true',
  `custom` enum('true','false') NOT NULL DEFAULT 'false',
  `uuid` varchar(36) CHARACTER SET ascii NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `object_id` (`object_id`,`object_type`),
  UNIQUE KEY `uuid` (`uuid`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1

Related documentation