huimv-baqing/sql/biz_subsidy_grant_record.sql

-- 补贴发放记录
CREATE TABLE IF NOT EXISTS `biz_subsidy_grant_record` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `subsidy_project_name` varchar(64) NOT NULL COMMENT '补贴项目名称',
  `subsidy_type` tinyint(4) NOT NULL COMMENT '1农业生产 2住房基建 3民生保障',
  `recipient_name` varchar(32) NOT NULL COMMENT '受补贴人姓名',
  `id_card` varchar(18) NOT NULL COMMENT '身份证号',
  `contact_phone` varchar(20) NOT NULL COMMENT '联系电话',
  `bank_account` varchar(32) NOT NULL COMMENT '银行账户',
  `subsidy_amount` decimal(12,2) NOT NULL COMMENT '补贴金额',
  `grant_date` date NOT NULL COMMENT '发放日期',
  `create_by` varchar(64) DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`),
  KEY `idx_grant_date` (`grant_date`),
  KEY `idx_subsidy_type` (`subsidy_type`),
  KEY `idx_recipient_name` (`recipient_name`),
  KEY `idx_id_card` (`id_card`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='补贴发放记录';