CREATE TABLE `qjcx_product_permission` (
`DATA_ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
`USER_ID` bigint(20) NOT NULL DEFAULT '0' COMMENT '用户id,crc',
`PRODUCT_DATA_ID` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '产品id',
`PROVIDER_DATA_ID` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '供应商data_id',
`MODEL` char(10) NOT NULL DEFAULT '' COMMENT '型号',
`IMPORTANCE_NAME_KEY` tinyint(1) NOT NULL DEFAULT '0' COMMENT '重要程度',
`PRODUCT_USE_SCOPE_KEY` tinyint(1) NOT NULL DEFAULT '0' COMMENT '型号领域key',
`PRODUCT_USE_SCOPE_KEY_CRC` bigint(20) NOT NULL DEFAULT '0' COMMENT '型号领域key crc',
`CATEGORY_KEY` tinyint(1) NOT NULL DEFAULT '0' COMMENT '产品属性key',
`LEVEL_CLASS_KEY` int(11) NOT NULL DEFAULT '0' COMMENT '产品层级key',
PRIMARY KEY (`DATA_ID`),
KEY `USER_ID` (`USER_ID`) USING BTREE,
KEY `RPOVIDER_DATA_ID` (`PROVIDER_DATA_ID`) USING BTREE,
KEY `UNI_TABLE_1` (`USER_ID`,`PROVIDER_DATA_ID`),
KEY `UNI_TABLE_3` (`USER_ID`,`PRODUCT_USE_SCOPE_KEY`,`PROVIDER_DATA_ID`),
KEY `UNI_TABLE_4` (`USER_ID`,`PROVIDER_DATA_ID`,`PRODUCT_USE_SCOPE_KEY_CRC`),
KEY `UNI_TABLE_5` (`USER_ID`,`PROVIDER_DATA_ID`,`MODEL`),
KEY `MPORTANCE_NAME_KEY` (`IMPORTANCE_NAME_KEY`),
KEY `UNI_TABLE_2` (`USER_ID`,`IMPORTANCE_NAME_KEY`,`PROVIDER_DATA_ID`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=10049800 DEFAULT CHARSET=utf8 COMMENT='人员的产品权限';
网友评论