`id` bigint(20) NOT NULL AUTO_INCREMENT,
`authentication_token` int(11) DEFAULT NULL,
`customer_id` bigint(20) DEFAULT NULL,
`temporary_authentication_token` int(11) DEFAULT NULL,
`user_name` varchar(255) DEFAULT NULL,
`email` varchar(255) DEFAULT NULL,
`encrypted_password` tinyblob NOT NULL,
`encryption_salt` tinyblob NOT NULL,
`failed_password_attempts` int(11) NOT NULL,
`ip_white_list` varchar(255) DEFAULT NULL,
`maximum_password_attempts` int(11) NOT NULL,
`password_blocked` bit(1) NOT NULL,
`preferred_locale` varchar(255) NOT NULL,
`acknowledged_alerts` varchar(255) DEFAULT NULL,
`date_created` datetime DEFAULT NULL,
`user_first_name` varchar(255) DEFAULT NULL,
`user_last_name` varchar(255) DEFAULT NULL,
`last_resethmac_creation` datetime DEFAULT NULL,
`is_rest_allowed` bit(1) NOT NULL,
`preferred_locale_on_creation` varchar(255) DEFAULT NULL,
`password_modified_date` datetime DEFAULT NULL,
`api_key_id` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `user_name` (`user_name`),
UNIQUE KEY `email` (`email`),
KEY `FKB9D38A2D2BF03DD6` (`customer_id`),
KEY `FK_d719su8axro45brdey4w4gq2k` (`api_key_id`),
CONSTRAINT `FKB9D38A2D2BF03DD6` FOREIGN KEY (`customer_id`) REFERENCES `customer` (`id`),
CONSTRAINT `FK_d719su8axro45brdey4w4gq2k` FOREIGN KEY (`api_key_id`) REFERENCES `api_key` (`id`)
Нажмите, чтобы раскрыть...
