CREATE TABLE `batchcardrecharges` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Code` longtext DEFAULT NULL,
  `TenantId` int(11) DEFAULT NULL,
  `EnterpriseId` char(36) NOT NULL,
  `EnterpriseCode` longtext DEFAULT NULL,
  `LastUpdatorId` char(36) NOT NULL,
  `LastUpdatorCode` longtext DEFAULT NULL,
  `LastUpdatorName` longtext DEFAULT NULL,
  `LastUpdatorTime` datetime(6) NOT NULL,
  `IsDeleted` bit(1) NOT NULL,
  `DeletionTime` datetime(6) DEFAULT NULL,
  `DeleteorId` char(36) DEFAULT NULL,
  `DeleteorCode` longtext DEFAULT NULL,
  `DeleteorName` longtext DEFAULT NULL,
  `OrderCode` longtext DEFAULT NULL,
  `OrderState` int(11) NOT NULL,
  `Batch` longtext DEFAULT NULL,
  `BatchName` longtext DEFAULT NULL,
  `ComboId` char(36) NOT NULL,
  `ComboCode` longtext DEFAULT NULL,
  `ComboName` longtext DEFAULT NULL,
  `SaleCount` int(11) NOT NULL,
  `BeginCardNumber` longtext DEFAULT NULL,
  `EndCardNumber` longtext DEFAULT NULL,
  `CreatorId` char(36) NOT NULL,
  `CreatorCode` longtext DEFAULT NULL,
  `CreatorName` longtext DEFAULT NULL,
  `CreatorTime` datetime(6) NOT NULL,
  `ReviewerId` char(36) NOT NULL,
  `ReviewerCode` longtext DEFAULT NULL,
  `ReviewerName` longtext DEFAULT NULL,
  `ReviewerTime` datetime(6) DEFAULT NULL,
  `OrderRemarks` longtext DEFAULT NULL,
  `ReviewerRemarks` longtext DEFAULT NULL,
  `Remarks` longtext DEFAULT NULL,
  `IsActivat` bit(1) NOT NULL DEFAULT b'0',
  `SalePrice` decimal(65,30) NOT NULL DEFAULT '0.000000000000000000000000000000',
  `OrderActivat` bit(1) NOT NULL DEFAULT b'0',
  `LastUpdateOrganization` char(36) DEFAULT NULL,
  `LastUpdateOrganizationCode` longtext DEFAULT NULL,
  `LastUpdateOrganizationName` longtext DEFAULT NULL,
  `OrganizationCode` longtext DEFAULT NULL,
  `OrganizationId` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
  `OrganizationName` longtext DEFAULT NULL,
  `OrderType` int(11) NOT NULL DEFAULT '0',
  `SaleOrderCode` longtext DEFAULT NULL,
  `SaleAmount` decimal(65,30) NOT NULL DEFAULT '0.000000000000000000000000000000',
  PRIMARY KEY (`Id`)
) ORGANIZATION INDEX AUTO_INCREMENT = 1002040 AUTO_INCREMENT_MODE = 'ORDER' DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC COMPRESSION = 'zstd_1.3.8' REPLICA_NUM = 2 BLOCK_SIZE = 16384 USE_BLOOM_FILTER = FALSE ENABLE_MACRO_BLOCK_BLOOM_FILTER = FALSE TABLET_SIZE = 134217728 PCTFREE = 0;

CREATE TABLE `batchcardrechargedetails` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `TenantId` int(11) NOT NULL,
  `BatchCardRechargeId` int(11) NOT NULL,
  `OrderCode` longtext DEFAULT NULL,
  `Batch` longtext DEFAULT NULL,
  `BatchName` longtext DEFAULT NULL,
  `CardNumber` longtext DEFAULT NULL,
  `ActivationState` bit(1) NOT NULL DEFAULT b'0',
  `BindType` int(11) NOT NULL DEFAULT '0',
  `IsResetEmptyCard` tinyint(1) NOT NULL DEFAULT '0',
  `IsReturn` tinyint(1) NOT NULL DEFAULT '0',
  `Amount` decimal(65,30) NOT NULL DEFAULT '0.000000000000000000000000000000',
  PRIMARY KEY (`Id`)
) ORGANIZATION INDEX AUTO_INCREMENT = 1311318 AUTO_INCREMENT_MODE = 'ORDER' DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC COMPRESSION = 'zstd_1.3.8' REPLICA_NUM = 2 BLOCK_SIZE = 16384 USE_BLOOM_FILTER = FALSE ENABLE_MACRO_BLOCK_BLOOM_FILTER = FALSE TABLET_SIZE = 134217728 PCTFREE = 0;

CREATE TABLE `membercombos` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `TenantId` int(11) NOT NULL,
  `CardNo` varchar(50) DEFAULT NULL,
  `MemberId` char(36) DEFAULT NULL,
  `MemberCode` varchar(50) DEFAULT NULL,
  `MemberName` varchar(50) DEFAULT NULL,
  `ComboId` char(36) NOT NULL,
  `ComboName` varchar(100) DEFAULT NULL,
  `IsReceive` bit(1) NOT NULL,
  `IsUse` bit(1) NOT NULL,
  `ReceiveDate` datetime(6) DEFAULT NULL,
  `UseDate` datetime(6) DEFAULT NULL,
  `SourceType` int(11) NOT NULL,
  `SourceId` char(36) NOT NULL,
  `CreatorTime` datetime(6) NOT NULL,
  `IsEnd` bit(1) NOT NULL,
  `TriggerId` varchar(100) DEFAULT NULL,
  `ExpireBeginDate` datetime(6) NOT NULL,
  `ExpireEndDate` datetime(6) NOT NULL,
  `OrganizationId` char(36) DEFAULT NULL,
  `OrganizationCode` longtext DEFAULT NULL,
  `UseAmount` decimal(65,30) DEFAULT NULL,
  `Amount` decimal(65,30) DEFAULT NULL,
  `RemainAmout` decimal(65,30) DEFAULT NULL,
  `CouponNum` int(11) DEFAULT NULL,
  `UseCouponNum` int(11) DEFAULT NULL,
  `RemainCouponNum` int(11) DEFAULT NULL,
  `IsDeleted` bit(1) NOT NULL,
  `IsFreeze` bit(1) NOT NULL,
  `DeletionTime` datetime(6) DEFAULT NULL,
  `YesterdayRechargeAmount` decimal(65,30) DEFAULT NULL,
  `IsComboCardSale` bit(1) NOT NULL DEFAULT b'0',
  `ActivationDate` datetime(6) DEFAULT NULL,
  `ActivationState` bit(1) NOT NULL DEFAULT b'0',
  `TempComboId` char(36) DEFAULT NULL,
  `IsFreezeShow` bit(1) NOT NULL DEFAULT b'0',
  `ComboSaleCardNo` longtext DEFAULT NULL,
  `MemberAwardLevel` int(11) NOT NULL DEFAULT '0',
  `AdjustAmount` decimal(65,30) DEFAULT NULL,
  `CasherCode` longtext DEFAULT NULL,
  `CasherId` char(36) DEFAULT NULL,
  `CasherName` longtext DEFAULT NULL,
  `ComboSaleAmount` decimal(65,30) NOT NULL DEFAULT '0.000000000000000000000000000000',
  `ComboSaleOrderCode` longtext DEFAULT NULL,
  `ComboSaleReturnOrderCode` longtext DEFAULT NULL,
  `ComboSaleScore` decimal(65,30) NOT NULL DEFAULT '0.000000000000000000000000000000',
  `MemberPhone` varchar(50) DEFAULT NULL,
  `OrganizationName` longtext DEFAULT NULL,
  `ReturnOrganizationCode` longtext DEFAULT NULL,
  `ReturnOrganizationId` char(36) DEFAULT NULL,
  `ReturnOrganizationName` longtext DEFAULT NULL,
  `ComboSourceType` int(11) NOT NULL DEFAULT '0',
  `CancelType` int(11) NOT NULL DEFAULT '0',
  `IsCancel` tinyint(1) NOT NULL DEFAULT '0',
  `CancelDate` datetime(6) DEFAULT NULL,
  `FreezeDate` datetime(6) DEFAULT NULL,
  `CardReturnAmount` decimal(65,30) DEFAULT NULL,
  `OccupyAmount` decimal(65,30) NOT NULL DEFAULT '0.000000000000000000000000000000',
  `CartNumberNames` longtext DEFAULT NULL,
  `NumberType` int(11) DEFAULT NULL,
  `PrestoreNumber` int(11) DEFAULT NULL,
  `RemainPrestoreNumber` int(11) DEFAULT NULL,
  `UsedPrestoreNumber` int(11) DEFAULT NULL,
  `OccupyAmountEncryption` longtext DEFAULT NULL,
  `RemainAmoutEncryption` longtext DEFAULT NULL,
  PRIMARY KEY (`Id`),
  KEY `IX_MemberCombos_ActivationDate` (`ActivationDate`) BLOCK_SIZE 16384 LOCAL,
  KEY `IX_MemberCombos_Amount` (`Amount`) BLOCK_SIZE 16384 LOCAL,
  KEY `IX_MemberCombos_CardNo` (`CardNo`) BLOCK_SIZE 16384 LOCAL,
  KEY `IX_MemberCombos_MemberId` (`MemberId`) BLOCK_SIZE 16384 LOCAL,
  KEY `IX_MemberCombos_SourceId` (`SourceId`) BLOCK_SIZE 16384 LOCAL,
  KEY `IX_MemberCombos_SourceType` (`SourceType`) BLOCK_SIZE 16384 LOCAL,
  KEY `IX_MemberCombos_TempComboId` (`TempComboId`) BLOCK_SIZE 16384 LOCAL,
  KEY `IX_MemberCombos_TenantId` (`TenantId`) BLOCK_SIZE 16384 LOCAL,
  KEY `IX_MemberCombos_TriggerId` (`TriggerId`) BLOCK_SIZE 16384 LOCAL,
  CONSTRAINT `CK_RemainAmout` CHECK ((`RemainAmout` >= 0)),
  CONSTRAINT `CK_UseAmount` CHECK ((((`Amount` + `AdjustAmount`) + `CardReturnAmount`) >= `UseAmount`))
) ORGANIZATION INDEX AUTO_INCREMENT = 1285180 AUTO_INCREMENT_MODE = 'ORDER' DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC COMPRESSION = 'zstd_1.3.8' REPLICA_NUM = 2 BLOCK_SIZE = 16384 USE_BLOOM_FILTER = FALSE ENABLE_MACRO_BLOCK_BLOOM_FILTER = FALSE TABLET_SIZE = 134217728 PCTFREE = 0;

CREATE TABLE `shopconsumptionrefund` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `TenantId` int(11) DEFAULT NULL,
  `Code` longtext DEFAULT NULL,
  `EnterpriseId` char(36) NOT NULL,
  `EnterpriseCode` longtext DEFAULT NULL,
  `CreatorId` char(36) NOT NULL,
  `CreatorCode` longtext DEFAULT NULL,
  `CreatorName` longtext DEFAULT NULL,
  `CreatorTime` datetime(6) NOT NULL,
  `LastUpdatorId` char(36) NOT NULL,
  `LastUpdatorCode` longtext DEFAULT NULL,
  `LastUpdatorName` longtext DEFAULT NULL,
  `LastUpdatorTime` datetime(6) NOT NULL,
  `DeleteorId` char(36) DEFAULT NULL,
  `DeleteorCode` longtext DEFAULT NULL,
  `DeleteorName` longtext DEFAULT NULL,
  `IsDeleted` bit(1) NOT NULL,
  `DeletionTime` datetime(6) DEFAULT NULL,
  `BusinessformatId` char(36) NOT NULL,
  `BusinessformatCode` longtext DEFAULT NULL,
  `BusinessformatName` longtext DEFAULT NULL,
  `OrganizationId` char(36) NOT NULL,
  `OrganizationCode` longtext DEFAULT NULL,
  `OrganizationName` longtext DEFAULT NULL,
  `OrderCode` varchar(50) DEFAULT NULL,
  `MemberId` char(36) NOT NULL,
  `MemberCode` varchar(50) DEFAULT NULL,
  `MemberName` varchar(50) DEFAULT NULL,
  `MemberPhone` varchar(50) DEFAULT NULL,
  `OrderType` int(11) NOT NULL,
  `RefundMethod` int(11) NOT NULL,
  `RefundReason` int(11) DEFAULT NULL,
  `GoodsId` char(36) NOT NULL,
  `ProductSpecificationId` char(36) DEFAULT NULL,
  `ShopId` char(36) NOT NULL,
  `RefundGoodsNum` decimal(18,4) NOT NULL,
  `RefundAmount` decimal(18,4) NOT NULL,
  `RefundInstruction` longtext DEFAULT NULL,
  `VoucherPicture` longtext DEFAULT NULL,
  `ConsumptionOrderCode` varchar(50) DEFAULT NULL,
  `ConsumptionOrderId` int(11) NOT NULL,
  `ConsumptionOrderDetailId` int(11) NOT NULL,
  `CargoStatus` int(11) DEFAULT NULL,
  `OrderStatus` int(11) NOT NULL,
  `ReturnLogisticsOrderCode` varchar(50) DEFAULT NULL,
  `LogisticsDescription` varchar(300) DEFAULT NULL,
  `ReturnLogisticsVoucher` longtext DEFAULT NULL,
  `EvaluationType` int(11) DEFAULT NULL,
  `EvaluationContent` varchar(300) DEFAULT NULL,
  `RefuseReason` varchar(300) DEFAULT NULL,
  `SellerReceivingAddress` varchar(300) DEFAULT NULL,
  `RefundScore` decimal(18,4) NOT NULL DEFAULT '0.0000',
  `LogisticsCompanyId` int(11) DEFAULT NULL,
  `LogisticsCompanyName` varchar(100) DEFAULT NULL,
  `ReturnLogisticsTime` datetime(6) DEFAULT NULL,
  `Freight` decimal(18,4) NOT NULL DEFAULT '0.0000',
  `SellerReceivingAddressId` char(36) DEFAULT NULL,
  `OrderSource` int(11) DEFAULT NULL,
  `exkey` longtext DEFAULT NULL,
  `ShopName` longtext DEFAULT NULL,
  `ConsumptionOrderType` int(11) NOT NULL DEFAULT '0',
  `RefundTime` datetime(6) DEFAULT NULL,
  `SyncResult` bit(1) NOT NULL DEFAULT b'0',
  `SyncTime` datetime(6) NOT NULL DEFAULT '0001-01-01 00:00:00.000000',
  `FormatBarCode` longtext DEFAULT NULL,
  `FormatName` varchar(200) DEFAULT NULL,
  `GoodBrandCode` longtext DEFAULT NULL,
  `GoodBrandName` longtext DEFAULT NULL,
  `GoodClassCode` longtext DEFAULT NULL,
  `GoodClassName` longtext DEFAULT NULL,
  `GoodCode` varchar(50) DEFAULT NULL,
  `GoodImage` varchar(200) DEFAULT NULL,
  `GoodName` varchar(200) DEFAULT NULL,
  `GoodType` int(11) NOT NULL DEFAULT '0',
  `ThridCode` varchar(50) DEFAULT NULL,
  `RowVersion` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  `LiveRoomId` int(11) NOT NULL DEFAULT '0',
  `OrderOrigin` int(11) NOT NULL DEFAULT '0',
  `TaskTime` datetime(6) DEFAULT NULL,
  `AgreeTime` datetime(6) DEFAULT NULL,
  `RefundSource` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`Id`)
) ORGANIZATION INDEX AUTO_INCREMENT = 1003457 AUTO_INCREMENT_MODE = 'ORDER' DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC COMPRESSION = 'zstd_1.3.8' REPLICA_NUM = 2 BLOCK_SIZE = 16384 USE_BLOOM_FILTER = FALSE ENABLE_MACRO_BLOCK_BLOOM_FILTER = FALSE TABLET_SIZE = 134217728 PCTFREE = 0;

CREATE TABLE `combo` (
  `Id` char(36) NOT NULL,
  `Code` varchar(100) DEFAULT NULL,
  `TenantId` int(11) DEFAULT NULL,
  `EnterpriseId` char(36) NOT NULL,
  `EnterpriseCode` longtext DEFAULT NULL,
  `CreatorId` char(36) NOT NULL,
  `CreatorCode` longtext DEFAULT NULL,
  `CreatorName` longtext DEFAULT NULL,
  `CreatorTime` datetime(6) NOT NULL,
  `LastUpdatorId` char(36) NOT NULL,
  `LastUpdatorCode` longtext DEFAULT NULL,
  `LastUpdatorName` longtext DEFAULT NULL,
  `LastUpdatorTime` datetime(6) NOT NULL,
  `IsDeleted` bit(1) NOT NULL,
  `DeletionTime` datetime(6) DEFAULT NULL,
  `DeleteorId` char(36) DEFAULT NULL,
  `DeleteorCode` longtext DEFAULT NULL,
  `DeleteorName` longtext DEFAULT NULL,
  `BusinessformatId` char(36) NOT NULL,
  `BusinessformatCode` longtext DEFAULT NULL,
  `BusinessformatName` longtext DEFAULT NULL,
  `OrganizationId` char(36) NOT NULL,
  `OrganizationCode` longtext DEFAULT NULL,
  `OrganizationName` longtext DEFAULT NULL,
  `Name` longtext DEFAULT NULL,
  `DepositType` int(11) NOT NULL,
  `DiscountAmount` decimal(65,30) DEFAULT NULL,
  `SalePrice` decimal(65,30) NOT NULL,
  `Quota` int(11) NOT NULL,
  `CouponNum` int(11) DEFAULT NULL,
  `ExpireDateType` int(11) NOT NULL,
  `EffectExpireMonths` int(11) DEFAULT NULL,
  `ExpireBeginDate` datetime(6) DEFAULT NULL,
  `ExpireEndDate` datetime(6) DEFAULT NULL,
  `IsTransmit` bit(1) NOT NULL,
  `IsShare` bit(1) NOT NULL,
  `OrganizationRangeType` int(11) NOT NULL,
  `Picture1` longtext DEFAULT NULL,
  `Picture2` longtext DEFAULT NULL,
  `Remark` longtext DEFAULT NULL,
  `State` int(11) NOT NULL,
  `IsMeanwhile` bit(1) NOT NULL,
  `OrganizationIds` longtext DEFAULT NULL,
  `LastUpdateOrganization` char(36) DEFAULT NULL,
  `LastUpdateOrganizationCode` longtext DEFAULT NULL,
  `LastUpdateOrganizationName` longtext DEFAULT NULL,
  `CouponNames` longtext DEFAULT NULL,
  `CartNumberNames` longtext DEFAULT NULL,
  `NumberType` int(11) DEFAULT NULL,
  `PrestoreNumber` int(11) DEFAULT NULL,
  `ComboPreStorageMethod` int(11) NOT NULL DEFAULT '0',
  `ComboUseMethod` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`Id`),
  KEY `IX_Combo_Code` (`Code`) BLOCK_SIZE 16384 LOCAL
) ORGANIZATION INDEX DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC COMPRESSION = 'zstd_1.3.8' REPLICA_NUM = 2 BLOCK_SIZE = 16384 USE_BLOOM_FILTER = FALSE ENABLE_MACRO_BLOCK_BLOOM_FILTER = FALSE TABLET_SIZE = 134217728 PCTFREE = 0;