CRC

作者: F的平方 | 来源:发表于2019-07-24 16:35 被阅读0次

    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='人员的产品权限';

    相关文章

      网友评论

          本文标题:CRC

          本文链接:https://www.haomeiwen.com/subject/gaxfrctx.html