/** 补贴申请表*/ // CREATE TABLE `subsidyapplications` ( // `subsidyapplicationsid` varchar(50) NOT NULL COMMENT '补贴申请唯一标识符(主键)', // `subsidyapplicationsmerchantid` varchar(50) DEFAULT NULL COMMENT '经销商ID', // `subsidyapplicationstotalsales` decimal(10,2) DEFAULT NULL COMMENT '经销商累计销售金额', // `subsidyapplicationssubsidyamount` decimal(10,2) DEFAULT NULL COMMENT '补贴金额', // `subsidyapplicationsapprovalstatus` tinyint(2) DEFAULT NULL COMMENT '审批状态(0:待审核,1:已通过,2:已拒绝)', // `subsidyapplicationsapplydate` datetime DEFAULT NULL COMMENT '申请日期', // PRIMARY KEY (`subsidyapplicationsid`), // KEY `subsidyapplicationsmerchantid` (`subsidyapplicationsmerchantid`), // CONSTRAINT `subsidyapplicationsmerchantid` FOREIGN KEY (`subsidyapplicationsmerchantid`) REFERENCES `users` (`usersid`) // ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='补贴申请表'; interface SubsidyApplicationsEntity { /** 补贴申请唯一标识符(主键) */ subsidyapplicationsid: string; /** 经销商ID */ subsidyapplicationsmerchantid: string; /** 经销商累计销售金额 */ subsidyapplicationstotalsales: number; /** 补贴金额 */ subsidyapplicationssubsidyamount: number; /** 审批状态(0:待审核,1:已通过,2:已拒绝) */ subsidyapplicationsapprovalstatus: number; /** 申请日期 */ subsidyapplicationsapplydate: string; } export type { SubsidyApplicationsEntity };