psa.Templates

Overview

Column Descriptions

id –
name –
note_id –
owner_id –
type –
uuid –
external_id –

CREATE TABLE `Templates` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8 NOT NULL,
  `note_id` int(10) unsigned DEFAULT NULL,
  `owner_id` int(10) unsigned NOT NULL,
  `type` enum('reseller','client','domain','domain_addon') NOT NULL,
  `uuid` varchar(36) CHARACTER SET ascii NOT NULL,
  `external_id` varchar(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uuid` (`uuid`),
  KEY `note_id` (`note_id`),
  KEY `owner_id` (`owner_id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1

Related documentation