-- ----------------------------
-- Table structure for ec_reflookuptabledata
-- ----------------------------
DROP TABLE IF EXISTS `ec_reflookuptabledata`;
CREATE TABLE `ec_reflookuptabledata`  (
  `SP_ID` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `lookupValue` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `lookupTableAttrId` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `recordNumber` int NULL DEFAULT NULL,
  PRIMARY KEY (`SP_ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;