| 1234567891011121314151617181920212223242526272829 |
- /** 补贴申请表*/
- // 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 };
|