psa.PlanItems

Overview

Column Descriptions

id –
classname –
name –
isVisible –
applicableToSubscription –
applicableToEmail –
applicableToSite –
uuid –

CREATE TABLE `PlanItems` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `classname` varchar(255) CHARACTER SET ascii NOT NULL,
  `name` varchar(255) CHARACTER SET ascii NOT NULL,
  `isVisible` int(10) unsigned DEFAULT '1',
  `applicableToSubscription` int(10) unsigned DEFAULT '0',
  `applicableToEmail` int(10) unsigned DEFAULT '0',
  `applicableToSite` int(10) unsigned DEFAULT '0',
  `uuid` varchar(36) CHARACTER SET ascii NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`),
  UNIQUE KEY `uuid` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1

Related documentation