subsidyapplications.ts 1.5 KB

1234567891011121314151617181920212223242526272829
  1. /** 补贴申请表*/
  2. // CREATE TABLE `subsidyapplications` (
  3. // `subsidyapplicationsid` varchar(50) NOT NULL COMMENT '补贴申请唯一标识符(主键)',
  4. // `subsidyapplicationsmerchantid` varchar(50) DEFAULT NULL COMMENT '经销商ID',
  5. // `subsidyapplicationstotalsales` decimal(10,2) DEFAULT NULL COMMENT '经销商累计销售金额',
  6. // `subsidyapplicationssubsidyamount` decimal(10,2) DEFAULT NULL COMMENT '补贴金额',
  7. // `subsidyapplicationsapprovalstatus` tinyint(2) DEFAULT NULL COMMENT '审批状态(0:待审核,1:已通过,2:已拒绝)',
  8. // `subsidyapplicationsapplydate` datetime DEFAULT NULL COMMENT '申请日期',
  9. // PRIMARY KEY (`subsidyapplicationsid`),
  10. // KEY `subsidyapplicationsmerchantid` (`subsidyapplicationsmerchantid`),
  11. // CONSTRAINT `subsidyapplicationsmerchantid` FOREIGN KEY (`subsidyapplicationsmerchantid`) REFERENCES `users` (`usersid`)
  12. // ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='补贴申请表';
  13. interface SubsidyApplicationsEntity {
  14. /** 补贴申请唯一标识符(主键) */
  15. subsidyapplicationsid: string;
  16. /** 经销商ID */
  17. subsidyapplicationsmerchantid: string;
  18. /** 经销商累计销售金额 */
  19. subsidyapplicationstotalsales: number;
  20. /** 补贴金额 */
  21. subsidyapplicationssubsidyamount: number;
  22. /** 审批状态(0:待审核,1:已通过,2:已拒绝) */
  23. subsidyapplicationsapprovalstatus: number;
  24. /** 申请日期 */
  25. subsidyapplicationsapplydate: string;
  26. }
  27. export type { SubsidyApplicationsEntity };