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

Leave a comment

Your comment