psa.smb_users

Overview

Column Descriptions

id –

CREATE TABLE `smb_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `login` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `contactName` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `companyName` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `fax` varchar(255) DEFAULT NULL,
  `address` text,
  `city` varchar(255) DEFAULT NULL,
  `state` varchar(255) DEFAULT NULL,
  `zip` varchar(255) DEFAULT NULL,
  `country` varchar(255) DEFAULT NULL,
  `creationDate` varchar(25) NOT NULL,
  `isBuiltIn` int(11) DEFAULT '0',
  `roleId` int(11) NOT NULL,
  `uuid` varchar(36) NOT NULL,
  `isLocked` int(11) DEFAULT '0',
  `authCookie` varchar(255) DEFAULT NULL,
  `sessionId` varchar(255) DEFAULT NULL,
  `externalId` varchar(255) DEFAULT NULL,
  `ownerId` int(11) DEFAULT NULL,
  `isDomainAdmin` int(11) DEFAULT NULL,
  `additionalInfo` text,
  `imNumber` varchar(255) DEFAULT NULL,
  `imType` int(11) DEFAULT NULL,
  `isLegacyUser` int(11) DEFAULT NULL,
  `subscriptionDomainId` bigint(20) DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uuid` (`uuid`),
  UNIQUE KEY `login` (`login`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8

Related documentation