-- ============================================================ -- 湛江市智慧人社运营运维（2025-2027年）项目 -- 就业一湛通服务平台 - 深度分析（补贴管理）达梦数据库建表脚本 -- -- 依据：《需求规格说明书》第3.6节 - 深度分析 -- 3.6.1 吸纳就业困难人员社保补贴（企业） -- 3.6.2 小微企业社保补贴（企业） -- 3.6.3 灵活就业社保补贴（个人） -- 3.6.4 员工制家政企业社保补贴（企业） -- 3.6.5 一般性岗位补贴（企业） -- 3.6.6 公益性岗位补贴（企业） -- 3.6.7 乡村公益性岗位补贴（企业） -- 3.6.8 公共就业服务岗位补贴（企业） -- 3.6.9 求职创业补贴（个人） -- 3.6.10 粤东粤西粤北地区就业补贴（个人） -- 3.6.11 就业见习补贴（企业） -- 3.6.12 一次性吸纳就业补贴（企业） -- 3.6.13 吸纳退役军人就业补贴（企业） -- 3.6.14 吸纳脱贫人口就业补贴（企业） -- 3.6.15 一次性创业资助（个人） -- 3.6.16 创业租金补贴（个人） -- 3.6.17 创业带动就业补贴（企业） -- 3.6.18 创业孵化补贴（企业） -- 3.6.19 员工制家政企业吸纳就业补贴（企业） -- 3.6.20 家政服务企业商业保险补贴（企业） -- 3.6.21 职业介绍补贴（企业） -- 数据库：达梦数据库 (DM8) -- 创建日期：2025-06-10 -- ============================================================ -- ============================================================ -- 3.6.1 吸纳就业困难人员社保补贴（企业） -- 说明：省平台回流，记录符合吸纳就业困难人员社保补贴条件的企业信息 -- ============================================================ CREATE TABLE DA_ABSORB_DIFFICULT_SUBSIDY ( ID VARCHAR(36) NOT NULL, RECORD_ID VARCHAR(100), UNIT_CREDIT_CODE VARCHAR(50), UNIT_NAME VARCHAR(200), DISTRICT VARCHAR(50), QUALIFIED_COUNT INTEGER, FIRST_DECLARE_DATE DATE, DEADLINE_DATE DATE, DECLARE_STATUS VARCHAR(50), LAST_NOTIFY_TIME DATE, DATA_REFLUX_TIME DATE, CREATE_BY VARCHAR(50), CREATE_TIME DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, UPDATE_BY VARCHAR(50), UPDATE_TIME DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, SYS_ORG_CODE VARCHAR(50), PRIMARY KEY (ID) ); COMMENT ON TABLE DA_ABSORB_DIFFICULT_SUBSIDY IS '吸纳就业困难人员社保补贴（企业）'; COMMENT ON COLUMN DA_ABSORB_DIFFICULT_SUBSIDY.ID IS '主键ID'; COMMENT ON COLUMN DA_ABSORB_DIFFICULT_SUBSIDY.RECORD_ID IS '备案记录ID（省平台唯一标识，用于数据关联）'; COMMENT ON COLUMN DA_ABSORB_DIFFICULT_SUBSIDY.UNIT_CREDIT_CODE IS '单位统一社会信用代码'; COMMENT ON COLUMN DA_ABSORB_DIFFICULT_SUBSIDY.UNIT_NAME IS '单位名称'; COMMENT ON COLUMN DA_ABSORB_DIFFICULT_SUBSIDY.DISTRICT IS '所属县区'; COMMENT ON COLUMN DA_ABSORB_DIFFICULT_SUBSIDY.QUALIFIED_COUNT IS '符合条件人数'; COMMENT ON COLUMN DA_ABSORB_DIFFICULT_SUBSIDY.FIRST_DECLARE_DATE IS '首次可以申报日期'; COMMENT ON COLUMN DA_ABSORB_DIFFICULT_SUBSIDY.DEADLINE_DATE IS '补贴限期截止日期'; COMMENT ON COLUMN DA_ABSORB_DIFFICULT_SUBSIDY.DECLARE_STATUS IS '申报状态（未申报/已申报/待审核/已通过/已驳回）'; COMMENT ON COLUMN DA_ABSORB_DIFFICULT_SUBSIDY.LAST_NOTIFY_TIME IS '最后通知时间（发送消息后自动记录时间）'; COMMENT ON COLUMN DA_ABSORB_DIFFICULT_SUBSIDY.DATA_REFLUX_TIME IS '数据回流时间'; COMMENT ON COLUMN DA_ABSORB_DIFFICULT_SUBSIDY.CREATE_BY IS '创建人'; COMMENT ON COLUMN DA_ABSORB_DIFFICULT_SUBSIDY.CREATE_TIME IS '创建时间'; COMMENT ON COLUMN DA_ABSORB_DIFFICULT_SUBSIDY.UPDATE_BY IS '修改人'; COMMENT ON COLUMN DA_ABSORB_DIFFICULT_SUBSIDY.UPDATE_TIME IS '更新时间'; COMMENT ON COLUMN DA_ABSORB_DIFFICULT_SUBSIDY.SYS_ORG_CODE IS '组织机构编号'; CREATE INDEX IDX_DA_ABSORB_DIFFICULT_SUBSIDY_UNIT ON DA_ABSORB_DIFFICULT_SUBSIDY(UNIT_CREDIT_CODE); CREATE INDEX IDX_DA_ABSORB_DIFFICULT_SUBSIDY_STATUS ON DA_ABSORB_DIFFICULT_SUBSIDY(DECLARE_STATUS); -- ============================================================ -- 3.6.2 小微企业社保补贴（企业） -- 说明：省平台回流，记录符合小微企业社保补贴条件的企业信息 -- ============================================================ CREATE TABLE DA_SMALL_MICRO_SUBSIDY ( ID VARCHAR(36) NOT NULL, RECORD_ID VARCHAR(100), UNIT_CREDIT_CODE VARCHAR(50), UNIT_NAME VARCHAR(200), DISTRICT VARCHAR(50), SMALL_MICRO_FLAG VARCHAR(10), QUALIFIED_COUNT INTEGER, FIRST_DECLARE_DATE DATE, DEADLINE_DATE DATE, DECLARE_STATUS VARCHAR(50), LAST_NOTIFY_TIME DATE, DATA_REFLUX_TIME DATE, CREATE_BY VARCHAR(50), CREATE_TIME DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, UPDATE_BY VARCHAR(50), UPDATE_TIME DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, SYS_ORG_CODE VARCHAR(50), PRIMARY KEY (ID) ); COMMENT ON TABLE DA_SMALL_MICRO_SUBSIDY IS '小微企业社保补贴（企业）'; COMMENT ON COLUMN DA_SMALL_MICRO_SUBSIDY.ID IS '主键ID'; COMMENT ON COLUMN DA_SMALL_MICRO_SUBSIDY.RECORD_ID IS '备案记录ID（省平台唯一标识，用于数据关联）'; COMMENT ON COLUMN DA_SMALL_MICRO_SUBSIDY.UNIT_CREDIT_CODE IS '单位统一社会信用代码'; COMMENT ON COLUMN DA_SMALL_MICRO_SUBSIDY.UNIT_NAME IS '单位名称'; COMMENT ON COLUMN DA_SMALL_MICRO_SUBSIDY.DISTRICT IS '所属县区'; COMMENT ON COLUMN DA_SMALL_MICRO_SUBSIDY.SMALL_MICRO_FLAG IS '小微企业标识（是/否）'; COMMENT ON COLUMN DA_SMALL_MICRO_SUBSIDY.QUALIFIED_COUNT IS '符合条件人数'; COMMENT ON COLUMN DA_SMALL_MICRO_SUBSIDY.FIRST_DECLARE_DATE IS '首次可以申报日期'; COMMENT ON COLUMN DA_SMALL_MICRO_SUBSIDY.DEADLINE_DATE IS '补贴限期截止日期'; COMMENT ON COLUMN DA_SMALL_MICRO_SUBSIDY.DECLARE_STATUS IS '申报状态（未申报/已申报/待审核/已通过/已驳回）'; COMMENT ON COLUMN DA_SMALL_MICRO_SUBSIDY.LAST_NOTIFY_TIME IS '最后通知时间（发送消息后自动记录时间）'; COMMENT ON COLUMN DA_SMALL_MICRO_SUBSIDY.DATA_REFLUX_TIME IS '数据回流时间'; COMMENT ON COLUMN DA_SMALL_MICRO_SUBSIDY.CREATE_BY IS '创建人'; COMMENT ON COLUMN DA_SMALL_MICRO_SUBSIDY.CREATE_TIME IS '创建时间'; COMMENT ON COLUMN DA_SMALL_MICRO_SUBSIDY.UPDATE_BY IS '修改人'; COMMENT ON COLUMN DA_SMALL_MICRO_SUBSIDY.UPDATE_TIME IS '更新时间'; COMMENT ON COLUMN DA_SMALL_MICRO_SUBSIDY.SYS_ORG_CODE IS '组织机构编号'; CREATE INDEX IDX_DA_SMALL_MICRO_SUBSIDY_UNIT ON DA_SMALL_MICRO_SUBSIDY(UNIT_CREDIT_CODE); CREATE INDEX IDX_DA_SMALL_MICRO_SUBSIDY_STATUS ON DA_SMALL_MICRO_SUBSIDY(DECLARE_STATUS); -- ============================================================ -- 3.6.3 灵活就业社保补贴（个人） -- 说明：省平台回流，记录符合灵活就业社保补贴条件的个人信息 -- ============================================================ CREATE TABLE DA_FLEXIBLE_EMPLOY_SUBSIDY ( ID VARCHAR(36) NOT NULL, RECORD_ID VARCHAR(100), ID_CARD VARCHAR(50), FULL_NAME VARCHAR(100), DISTRICT VARCHAR(50), FLEXIBLE_FLAG VARCHAR(10), PERSON_CATEGORY VARCHAR(100), CONTACT_PHONE VARCHAR(50), SOCIAL_SEC_AMOUNT NUMERIC(18,2), SUBSIDY_STANDARD VARCHAR(100), FIRST_DECLARE_DATE DATE, DEADLINE_DATE DATE, DECLARE_STATUS VARCHAR(50), LAST_NOTIFY_TIME DATE, DATA_REFLUX_TIME DATE, CREATE_BY VARCHAR(50), CREATE_TIME DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, UPDATE_BY VARCHAR(50), UPDATE_TIME DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, SYS_ORG_CODE VARCHAR(50), PRIMARY KEY (ID) ); COMMENT ON TABLE DA_FLEXIBLE_EMPLOY_SUBSIDY IS '灵活就业社保补贴（个人）'; COMMENT ON COLUMN DA_FLEXIBLE_EMPLOY_SUBSIDY.ID IS '主键ID'; COMMENT ON COLUMN DA_FLEXIBLE_EMPLOY_SUBSIDY.RECORD_ID IS '备案记录ID（省平台唯一标识，用于数据关联）'; COMMENT ON COLUMN DA_FLEXIBLE_EMPLOY_SUBSIDY.ID_CARD IS '个人身份证号'; COMMENT ON COLUMN DA_FLEXIBLE_EMPLOY_SUBSIDY.FULL_NAME IS '姓名'; COMMENT ON COLUMN DA_FLEXIBLE_EMPLOY_SUBSIDY.DISTRICT IS '所属县区（户籍所在地）'; COMMENT ON COLUMN DA_FLEXIBLE_EMPLOY_SUBSIDY.FLEXIBLE_FLAG IS '灵活就业标识（是/否）'; COMMENT ON COLUMN DA_FLEXIBLE_EMPLOY_SUBSIDY.PERSON_CATEGORY IS '人员类别（就业困难人员/高校毕业生/脱贫人口等，以回流数据为准）'; COMMENT ON COLUMN DA_FLEXIBLE_EMPLOY_SUBSIDY.CONTACT_PHONE IS '联系方式'; COMMENT ON COLUMN DA_FLEXIBLE_EMPLOY_SUBSIDY.SOCIAL_SEC_AMOUNT IS '社保缴费金额'; COMMENT ON COLUMN DA_FLEXIBLE_EMPLOY_SUBSIDY.SUBSIDY_STANDARD IS '补贴标准'; COMMENT ON COLUMN DA_FLEXIBLE_EMPLOY_SUBSIDY.FIRST_DECLARE_DATE IS '首次可申报日期'; COMMENT ON COLUMN DA_FLEXIBLE_EMPLOY_SUBSIDY.DEADLINE_DATE IS '补贴期限截止日期'; COMMENT ON COLUMN DA_FLEXIBLE_EMPLOY_SUBSIDY.DECLARE_STATUS IS '申报状态（未申报/已申报/待审核/已通过/已驳回）'; COMMENT ON COLUMN DA_FLEXIBLE_EMPLOY_SUBSIDY.LAST_NOTIFY_TIME IS '最后通知时间（发送消息后自动记录时间）'; COMMENT ON COLUMN DA_FLEXIBLE_EMPLOY_SUBSIDY.DATA_REFLUX_TIME IS '数据回流时间'; COMMENT ON COLUMN DA_FLEXIBLE_EMPLOY_SUBSIDY.CREATE_BY IS '创建人'; COMMENT ON COLUMN DA_FLEXIBLE_EMPLOY_SUBSIDY.CREATE_TIME IS '创建时间'; COMMENT ON COLUMN DA_FLEXIBLE_EMPLOY_SUBSIDY.UPDATE_BY IS '修改人'; COMMENT ON COLUMN DA_FLEXIBLE_EMPLOY_SUBSIDY.UPDATE_TIME IS '更新时间'; COMMENT ON COLUMN DA_FLEXIBLE_EMPLOY_SUBSIDY.SYS_ORG_CODE IS '组织机构编号'; CREATE INDEX IDX_DA_FLEXIBLE_EMPLOY_SUBSIDY_ID_CARD ON DA_FLEXIBLE_EMPLOY_SUBSIDY(ID_CARD); CREATE INDEX IDX_DA_FLEXIBLE_EMPLOY_SUBSIDY_STATUS ON DA_FLEXIBLE_EMPLOY_SUBSIDY(DECLARE_STATUS); -- ============================================================ -- 3.6.4 员工制家政企业社保补贴（企业） -- 说明：省平台回流，记录符合员工制家政企业社保补贴条件的企业信息 -- ============================================================ CREATE TABLE DA_FAMILY_SERVICE_SUBSIDY ( ID VARCHAR(36) NOT NULL, RECORD_ID VARCHAR(100), UNIT_CREDIT_CODE VARCHAR(50), UNIT_NAME VARCHAR(200), DISTRICT VARCHAR(50), FAMILY_SERVICE_FLAG VARCHAR(10), HOUSEKEEPING_COUNT INTEGER, SOCIAL_SEC_AMOUNT NUMERIC(18,2), SUBSIDY_STANDARD VARCHAR(100), FIRST_DECLARE_DATE DATE, DEADLINE_DATE DATE, DECLARE_STATUS VARCHAR(50), LAST_NOTIFY_TIME DATE, DATA_REFLUX_TIME DATE, CREATE_BY VARCHAR(50), CREATE_TIME DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, UPDATE_BY VARCHAR(50), UPDATE_TIME DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, SYS_ORG_CODE VARCHAR(50), PRIMARY KEY (ID) ); COMMENT ON TABLE DA_FAMILY_SERVICE_SUBSIDY IS '员工制家政企业社保补贴（企业）'; COMMENT ON COLUMN DA_FAMILY_SERVICE_SUBSIDY.ID IS '主键ID'; COMMENT ON COLUMN DA_FAMILY_SERVICE_SUBSIDY.RECORD_ID IS '备案记录ID（省平台唯一标识，用于数据关联）'; COMMENT ON COLUMN DA_FAMILY_SERVICE_SUBSIDY.UNIT_CREDIT_CODE IS '单位统一社会信用代码'; COMMENT ON COLUMN DA_FAMILY_SERVICE_SUBSIDY.UNIT_NAME IS '单位名称'; COMMENT ON COLUMN DA_FAMILY_SERVICE_SUBSIDY.DISTRICT IS '所属县区'; COMMENT ON COLUMN DA_FAMILY_SERVICE_SUBSIDY.FAMILY_SERVICE_FLAG IS '员工制家政企业标识（是/否）'; COMMENT ON COLUMN DA_FAMILY_SERVICE_SUBSIDY.HOUSEKEEPING_COUNT IS '家政从业人员数'; COMMENT ON COLUMN DA_FAMILY_SERVICE_SUBSIDY.SOCIAL_SEC_AMOUNT IS '社保缴费金额'; COMMENT ON COLUMN DA_FAMILY_SERVICE_SUBSIDY.SUBSIDY_STANDARD IS '补贴标准'; COMMENT ON COLUMN DA_FAMILY_SERVICE_SUBSIDY.FIRST_DECLARE_DATE IS '首次可申报日期'; COMMENT ON COLUMN DA_FAMILY_SERVICE_SUBSIDY.DEADLINE_DATE IS '补贴期限截止日期'; COMMENT ON COLUMN DA_FAMILY_SERVICE_SUBSIDY.DECLARE_STATUS IS '申报状态（未申报/已申报/待审核/已通过/已驳回）'; COMMENT ON COLUMN DA_FAMILY_SERVICE_SUBSIDY.LAST_NOTIFY_TIME IS '最后通知时间（发送消息后自动记录时间）'; COMMENT ON COLUMN DA_FAMILY_SERVICE_SUBSIDY.DATA_REFLUX_TIME IS '数据回流时间'; COMMENT ON COLUMN DA_FAMILY_SERVICE_SUBSIDY.CREATE_BY IS '创建人'; COMMENT ON COLUMN DA_FAMILY_SERVICE_SUBSIDY.CREATE_TIME IS '创建时间'; COMMENT ON COLUMN DA_FAMILY_SERVICE_SUBSIDY.UPDATE_BY IS '修改人'; COMMENT ON COLUMN DA_FAMILY_SERVICE_SUBSIDY.UPDATE_TIME IS '更新时间'; COMMENT ON COLUMN DA_FAMILY_SERVICE_SUBSIDY.SYS_ORG_CODE IS '组织机构编号'; CREATE INDEX IDX_DA_FAMILY_SERVICE_SUBSIDY_UNIT ON DA_FAMILY_SERVICE_SUBSIDY(UNIT_CREDIT_CODE); CREATE INDEX IDX_DA_FAMILY_SERVICE_SUBSIDY_STATUS ON DA_FAMILY_SERVICE_SUBSIDY(DECLARE_STATUS); -- ============================================================ -- 3.6.5 一般性岗位补贴（企业） -- 说明：省平台回流，记录符合一般性岗位补贴条件的企业信息 -- ============================================================ CREATE TABLE DA_GENERAL_POST_SUBSIDY ( ID VARCHAR(36) NOT NULL, RECORD_ID VARCHAR(100), UNIT_CREDIT_CODE VARCHAR(50), UNIT_NAME VARCHAR(200), DISTRICT VARCHAR(50), GENERAL_POST_FLAG VARCHAR(10), POST_COUNT INTEGER, QUALIFIED_COUNT INTEGER, SUBSIDY_STANDARD VARCHAR(100), FIRST_DECLARE_DATE DATE, DEADLINE_DATE DATE, DECLARE_STATUS VARCHAR(50), LAST_NOTIFY_TIME DATE, DATA_REFLUX_TIME DATE, CREATE_BY VARCHAR(50), CREATE_TIME DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, UPDATE_BY VARCHAR(50), UPDATE_TIME DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, SYS_ORG_CODE VARCHAR(50), PRIMARY KEY (ID) ); COMMENT ON TABLE DA_GENERAL_POST_SUBSIDY IS '一般性岗位补贴（企业）'; COMMENT ON COLUMN DA_GENERAL_POST_SUBSIDY.ID IS '主键ID'; COMMENT ON COLUMN DA_GENERAL_POST_SUBSIDY.RECORD_ID IS '备案记录ID（省平台唯一标识，用于数据关联）'; COMMENT ON COLUMN DA_GENERAL_POST_SUBSIDY.UNIT_CREDIT_CODE IS '单位统一社会信用代码'; COMMENT ON COLUMN DA_GENERAL_POST_SUBSIDY.UNIT_NAME IS '单位名称'; COMMENT ON COLUMN DA_GENERAL_POST_SUBSIDY.DISTRICT IS '所属县区'; COMMENT ON COLUMN DA_GENERAL_POST_SUBSIDY.GENERAL_POST_FLAG IS '一般性岗位标识（是/否）'; COMMENT ON COLUMN DA_GENERAL_POST_SUBSIDY.POST_COUNT IS '岗位数量'; COMMENT ON COLUMN DA_GENERAL_POST_SUBSIDY.QUALIFIED_COUNT IS '符合条件从业人数'; COMMENT ON COLUMN DA_GENERAL_POST_SUBSIDY.SUBSIDY_STANDARD IS '补贴标准'; COMMENT ON COLUMN DA_GENERAL_POST_SUBSIDY.FIRST_DECLARE_DATE IS '首次可申报日期'; COMMENT ON COLUMN DA_GENERAL_POST_SUBSIDY.DEADLINE_DATE IS '补贴期限截止日期'; COMMENT ON COLUMN DA_GENERAL_POST_SUBSIDY.DECLARE_STATUS IS '申报状态（未申报/已申报/待审核/已通过/已驳回）'; COMMENT ON COLUMN DA_GENERAL_POST_SUBSIDY.LAST_NOTIFY_TIME IS '最后通知时间（发送消息后自动记录时间）'; COMMENT ON COLUMN DA_GENERAL_POST_SUBSIDY.DATA_REFLUX_TIME IS '数据回流时间'; COMMENT ON COLUMN DA_GENERAL_POST_SUBSIDY.CREATE_BY IS '创建人'; COMMENT ON COLUMN DA_GENERAL_POST_SUBSIDY.CREATE_TIME IS '创建时间'; COMMENT ON COLUMN DA_GENERAL_POST_SUBSIDY.UPDATE_BY IS '修改人'; COMMENT ON COLUMN DA_GENERAL_POST_SUBSIDY.UPDATE_TIME IS '更新时间'; COMMENT ON COLUMN DA_GENERAL_POST_SUBSIDY.SYS_ORG_CODE IS '组织机构编号'; CREATE INDEX IDX_DA_GENERAL_POST_SUBSIDY_UNIT ON DA_GENERAL_POST_SUBSIDY(UNIT_CREDIT_CODE); CREATE INDEX IDX_DA_GENERAL_POST_SUBSIDY_STATUS ON DA_GENERAL_POST_SUBSIDY(DECLARE_STATUS); -- ============================================================ -- 3.6.6 公益性岗位补贴（企业） -- 说明：省平台回流，记录符合公益性岗位补贴条件的安置单位信息 -- ============================================================ CREATE TABLE DA_PUBLIC_WELFARE_POST_SUBSIDY ( ID VARCHAR(36) NOT NULL, RECORD_ID VARCHAR(100), UNIT_CREDIT_CODE VARCHAR(50), UNIT_NAME VARCHAR(200), DISTRICT VARCHAR(50), CONTACT_PHONE VARCHAR(50), PUBLIC_WELFARE_FLAG VARCHAR(10), QUALIFIED_COUNT INTEGER, SUBSIDY_STANDARD VARCHAR(100), FIRST_DECLARE_DATE DATE, DEADLINE_DATE DATE, DECLARE_STATUS VARCHAR(50), LAST_NOTIFY_TIME DATE, DATA_REFLUX_TIME DATE, CREATE_BY VARCHAR(50), CREATE_TIME DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, UPDATE_BY VARCHAR(50), UPDATE_TIME DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, SYS_ORG_CODE VARCHAR(50), PRIMARY KEY (ID) ); COMMENT ON TABLE DA_PUBLIC_WELFARE_POST_SUBSIDY IS '公益性岗位补贴（企业）'; COMMENT ON COLUMN DA_PUBLIC_WELFARE_POST_SUBSIDY.ID IS '主键ID'; COMMENT ON COLUMN DA_PUBLIC_WELFARE_POST_SUBSIDY.RECORD_ID IS '备案记录ID（省平台唯一标识，用于数据关联）'; COMMENT ON COLUMN DA_PUBLIC_WELFARE_POST_SUBSIDY.UNIT_CREDIT_CODE IS '单位统一社会信用代码'; COMMENT ON COLUMN DA_PUBLIC_WELFARE_POST_SUBSIDY.UNIT_NAME IS '单位名称'; COMMENT ON COLUMN DA_PUBLIC_WELFARE_POST_SUBSIDY.DISTRICT IS '所属县区'; COMMENT ON COLUMN DA_PUBLIC_WELFARE_POST_SUBSIDY.CONTACT_PHONE IS '联系人手机号（经办人）'; COMMENT ON COLUMN DA_PUBLIC_WELFARE_POST_SUBSIDY.PUBLIC_WELFARE_FLAG IS '公益性岗位标识（是/否）'; COMMENT ON COLUMN DA_PUBLIC_WELFARE_POST_SUBSIDY.QUALIFIED_COUNT IS '符合条件安置人数'; COMMENT ON COLUMN DA_PUBLIC_WELFARE_POST_SUBSIDY.SUBSIDY_STANDARD IS '补贴标准'; COMMENT ON COLUMN DA_PUBLIC_WELFARE_POST_SUBSIDY.FIRST_DECLARE_DATE IS '首次可申报日期'; COMMENT ON COLUMN DA_PUBLIC_WELFARE_POST_SUBSIDY.DEADLINE_DATE IS '补贴期限截止日期'; COMMENT ON COLUMN DA_PUBLIC_WELFARE_POST_SUBSIDY.DECLARE_STATUS IS '申报状态（未申报/已申报/待审核/已通过/已驳回）'; COMMENT ON COLUMN DA_PUBLIC_WELFARE_POST_SUBSIDY.LAST_NOTIFY_TIME IS '最后通知时间（发送消息后自动记录时间）'; COMMENT ON COLUMN DA_PUBLIC_WELFARE_POST_SUBSIDY.DATA_REFLUX_TIME IS '数据回流时间'; COMMENT ON COLUMN DA_PUBLIC_WELFARE_POST_SUBSIDY.CREATE_BY IS '创建人'; COMMENT ON COLUMN DA_PUBLIC_WELFARE_POST_SUBSIDY.CREATE_TIME IS '创建时间'; COMMENT ON COLUMN DA_PUBLIC_WELFARE_POST_SUBSIDY.UPDATE_BY IS '修改人'; COMMENT ON COLUMN DA_PUBLIC_WELFARE_POST_SUBSIDY.UPDATE_TIME IS '更新时间'; COMMENT ON COLUMN DA_PUBLIC_WELFARE_POST_SUBSIDY.SYS_ORG_CODE IS '组织机构编号'; CREATE INDEX IDX_DA_PUBLIC_WELFARE_POST_SUBSIDY_UNIT ON DA_PUBLIC_WELFARE_POST_SUBSIDY(UNIT_CREDIT_CODE); CREATE INDEX IDX_DA_PUBLIC_WELFARE_POST_SUBSIDY_STATUS ON DA_PUBLIC_WELFARE_POST_SUBSIDY(DECLARE_STATUS); -- ============================================================ -- 3.6.7 乡村公益性岗位补贴（企业） -- 说明：省平台回流，记录符合乡村公益性岗位补贴条件的安置单位信息 -- ============================================================ CREATE TABLE DA_RURAL_WELFARE_POST_SUBSIDY ( ID VARCHAR(36) NOT NULL, RECORD_ID VARCHAR(100), UNIT_CREDIT_CODE VARCHAR(50), UNIT_NAME VARCHAR(200), DISTRICT VARCHAR(50), RURAL_AREA VARCHAR(200), RURAL_WELFARE_FLAG VARCHAR(10), POST_COUNT INTEGER, QUALIFIED_COUNT INTEGER, SUBSIDY_STANDARD VARCHAR(100), FIRST_DECLARE_DATE DATE, DEADLINE_DATE DATE, DECLARE_STATUS VARCHAR(50), LAST_NOTIFY_TIME DATE, DATA_REFLUX_TIME DATE, CREATE_BY VARCHAR(50), CREATE_TIME DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, UPDATE_BY VARCHAR(50), UPDATE_TIME DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, SYS_ORG_CODE VARCHAR(50), PRIMARY KEY (ID) ); COMMENT ON TABLE DA_RURAL_WELFARE_POST_SUBSIDY IS '乡村公益性岗位补贴（企业）'; COMMENT ON COLUMN DA_RURAL_WELFARE_POST_SUBSIDY.ID IS '主键ID'; COMMENT ON COLUMN DA_RURAL_WELFARE_POST_SUBSIDY.RECORD_ID IS '备案记录ID（省平台唯一标识，用于数据关联）'; COMMENT ON COLUMN DA_RURAL_WELFARE_POST_SUBSIDY.UNIT_CREDIT_CODE IS '单位统一社会信用代码'; COMMENT ON COLUMN DA_RURAL_WELFARE_POST_SUBSIDY.UNIT_NAME IS '单位名称'; COMMENT ON COLUMN DA_RURAL_WELFARE_POST_SUBSIDY.DISTRICT IS '所属县区'; COMMENT ON COLUMN DA_RURAL_WELFARE_POST_SUBSIDY.RURAL_AREA IS '乡村区域'; COMMENT ON COLUMN DA_RURAL_WELFARE_POST_SUBSIDY.RURAL_WELFARE_FLAG IS '乡村公益性岗位标识（是/否）'; COMMENT ON COLUMN DA_RURAL_WELFARE_POST_SUBSIDY.POST_COUNT IS '岗位数量'; COMMENT ON COLUMN DA_RURAL_WELFARE_POST_SUBSIDY.QUALIFIED_COUNT IS '符合条件安置人数'; COMMENT ON COLUMN DA_RURAL_WELFARE_POST_SUBSIDY.SUBSIDY_STANDARD IS '补贴标准'; COMMENT ON COLUMN DA_RURAL_WELFARE_POST_SUBSIDY.FIRST_DECLARE_DATE IS '首次可申报日期'; COMMENT ON COLUMN DA_RURAL_WELFARE_POST_SUBSIDY.DEADLINE_DATE IS '补贴期限截止日期'; COMMENT ON COLUMN DA_RURAL_WELFARE_POST_SUBSIDY.DECLARE_STATUS IS '申报状态（未申报/已申报/待审核/已通过/已驳回）'; COMMENT ON COLUMN DA_RURAL_WELFARE_POST_SUBSIDY.LAST_NOTIFY_TIME IS '最后通知时间（发送消息后自动记录时间）'; COMMENT ON COLUMN DA_RURAL_WELFARE_POST_SUBSIDY.DATA_REFLUX_TIME IS '数据回流时间'; COMMENT ON COLUMN DA_RURAL_WELFARE_POST_SUBSIDY.CREATE_BY IS '创建人'; COMMENT ON COLUMN DA_RURAL_WELFARE_POST_SUBSIDY.CREATE_TIME IS '创建时间'; COMMENT ON COLUMN DA_RURAL_WELFARE_POST_SUBSIDY.UPDATE_BY IS '修改人'; COMMENT ON COLUMN DA_RURAL_WELFARE_POST_SUBSIDY.UPDATE_TIME IS '更新时间'; COMMENT ON COLUMN DA_RURAL_WELFARE_POST_SUBSIDY.SYS_ORG_CODE IS '组织机构编号'; CREATE INDEX IDX_DA_RURAL_WELFARE_POST_SUBSIDY_UNIT ON DA_RURAL_WELFARE_POST_SUBSIDY(UNIT_CREDIT_CODE); CREATE INDEX IDX_DA_RURAL_WELFARE_POST_SUBSIDY_STATUS ON DA_RURAL_WELFARE_POST_SUBSIDY(DECLARE_STATUS); -- ============================================================ -- 3.6.8 公共就业服务岗位补贴（企业） -- 说明：省平台回流，记录符合公共就业服务岗位补贴条件的机构信息 -- ============================================================ CREATE TABLE DA_PUBLIC_EMPLOY_SERVICE_SUBSIDY ( ID VARCHAR(36) NOT NULL, RECORD_ID VARCHAR(100), UNIT_CREDIT_CODE VARCHAR(50), UNIT_NAME VARCHAR(200), DISTRICT VARCHAR(50), ORG_TYPE VARCHAR(200), PUBLIC_SERVICE_FLAG VARCHAR(10), SERVICE_ITEM VARCHAR(200), SERVICE_RESULT VARCHAR(100), SUBSIDY_STANDARD VARCHAR(100), FIRST_DECLARE_DATE DATE, DEADLINE_DATE DATE, DECLARE_STATUS VARCHAR(50), LAST_NOTIFY_TIME DATE, DATA_REFLUX_TIME DATE, CREATE_BY VARCHAR(50), CREATE_TIME DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, UPDATE_BY VARCHAR(50), UPDATE_TIME DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, SYS_ORG_CODE VARCHAR(50), PRIMARY KEY (ID) ); COMMENT ON TABLE DA_PUBLIC_EMPLOY_SERVICE_SUBSIDY IS '公共就业服务岗位补贴（企业）'; COMMENT ON COLUMN DA_PUBLIC_EMPLOY_SERVICE_SUBSIDY.ID IS '主键ID'; COMMENT ON COLUMN DA_PUBLIC_EMPLOY_SERVICE_SUBSIDY.RECORD_ID IS '备案记录ID（省平台唯一标识，用于数据关联）'; COMMENT ON COLUMN DA_PUBLIC_EMPLOY_SERVICE_SUBSIDY.UNIT_CREDIT_CODE IS '单位统一社会信用代码'; COMMENT ON COLUMN DA_PUBLIC_EMPLOY_SERVICE_SUBSIDY.UNIT_NAME IS '单位名称'; COMMENT ON COLUMN DA_PUBLIC_EMPLOY_SERVICE_SUBSIDY.DISTRICT IS '所属县区'; COMMENT ON COLUMN DA_PUBLIC_EMPLOY_SERVICE_SUBSIDY.ORG_TYPE IS '机构类型（公共就业服务中心/街道社区服务站/人力资源服务机构/社会组织，以回流数据为准）'; COMMENT ON COLUMN DA_PUBLIC_EMPLOY_SERVICE_SUBSIDY.PUBLIC_SERVICE_FLAG IS '公共就业服务标识（是/否）'; COMMENT ON COLUMN DA_PUBLIC_EMPLOY_SERVICE_SUBSIDY.SERVICE_ITEM IS '服务项目'; COMMENT ON COLUMN DA_PUBLIC_EMPLOY_SERVICE_SUBSIDY.SERVICE_RESULT IS '服务成效（人数/场次）'; COMMENT ON COLUMN DA_PUBLIC_EMPLOY_SERVICE_SUBSIDY.SUBSIDY_STANDARD IS '补贴标准'; COMMENT ON COLUMN DA_PUBLIC_EMPLOY_SERVICE_SUBSIDY.FIRST_DECLARE_DATE IS '首次可申报日期'; COMMENT ON COLUMN DA_PUBLIC_EMPLOY_SERVICE_SUBSIDY.DEADLINE_DATE IS '补贴期限截止日期'; COMMENT ON COLUMN DA_PUBLIC_EMPLOY_SERVICE_SUBSIDY.DECLARE_STATUS IS '申报状态（未申报/已申报/待审核/已通过/已驳回）'; COMMENT ON COLUMN DA_PUBLIC_EMPLOY_SERVICE_SUBSIDY.LAST_NOTIFY_TIME IS '最后通知时间（发送消息后自动记录时间）'; COMMENT ON COLUMN DA_PUBLIC_EMPLOY_SERVICE_SUBSIDY.DATA_REFLUX_TIME IS '数据回流时间'; COMMENT ON COLUMN DA_PUBLIC_EMPLOY_SERVICE_SUBSIDY.CREATE_BY IS '创建人'; COMMENT ON COLUMN DA_PUBLIC_EMPLOY_SERVICE_SUBSIDY.CREATE_TIME IS '创建时间'; COMMENT ON COLUMN DA_PUBLIC_EMPLOY_SERVICE_SUBSIDY.UPDATE_BY IS '修改人'; COMMENT ON COLUMN DA_PUBLIC_EMPLOY_SERVICE_SUBSIDY.UPDATE_TIME IS '更新时间'; COMMENT ON COLUMN DA_PUBLIC_EMPLOY_SERVICE_SUBSIDY.SYS_ORG_CODE IS '组织机构编号'; CREATE INDEX IDX_DA_PUBLIC_EMPLOY_SERVICE_SUBSIDY_UNIT ON DA_PUBLIC_EMPLOY_SERVICE_SUBSIDY(UNIT_CREDIT_CODE); CREATE INDEX IDX_DA_PUBLIC_EMPLOY_SERVICE_SUBSIDY_STATUS ON DA_PUBLIC_EMPLOY_SERVICE_SUBSIDY(DECLARE_STATUS); -- ============================================================ -- 3.6.9 求职创业补贴（个人） -- 说明：省平台回流，记录符合求职创业补贴条件的个人信息 -- ============================================================ CREATE TABLE DA_JOB_SEEKING_SUBSIDY ( ID VARCHAR(36) NOT NULL, RECORD_ID VARCHAR(100), ID_CARD VARCHAR(50), FULL_NAME VARCHAR(100), DISTRICT VARCHAR(50), FLEXIBLE_FLAG VARCHAR(10), PERSON_CATEGORY VARCHAR(100), JOB_SEEKING_FLAG VARCHAR(10), JOB_SEEKING_STATUS VARCHAR(50), CONTACT_PHONE VARCHAR(50), SUBSIDY_AMOUNT NUMERIC(18,2), FIRST_DECLARE_DATE DATE, DEADLINE_DATE DATE, DECLARE_STATUS VARCHAR(50), LAST_NOTIFY_TIME DATE, DATA_REFLUX_TIME DATE, CREATE_BY VARCHAR(50), CREATE_TIME DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, UPDATE_BY VARCHAR(50), UPDATE_TIME DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, SYS_ORG_CODE VARCHAR(50), PRIMARY KEY (ID) ); COMMENT ON TABLE DA_JOB_SEEKING_SUBSIDY IS '求职创业补贴（个人）'; COMMENT ON COLUMN DA_JOB_SEEKING_SUBSIDY.ID IS '主键ID'; COMMENT ON COLUMN DA_JOB_SEEKING_SUBSIDY.RECORD_ID IS '备案记录ID（省平台唯一标识，用于数据关联）'; COMMENT ON COLUMN DA_JOB_SEEKING_SUBSIDY.ID_CARD IS '个人身份证号'; COMMENT ON COLUMN DA_JOB_SEEKING_SUBSIDY.FULL_NAME IS '姓名'; COMMENT ON COLUMN DA_JOB_SEEKING_SUBSIDY.DISTRICT IS '所属县区（户籍所在地）'; COMMENT ON COLUMN DA_JOB_SEEKING_SUBSIDY.FLEXIBLE_FLAG IS '灵活就业标识（是/否）'; COMMENT ON COLUMN DA_JOB_SEEKING_SUBSIDY.PERSON_CATEGORY IS '人员类别（就业困难人员/高校毕业生/脱贫人口等，以回流数据为准）'; COMMENT ON COLUMN DA_JOB_SEEKING_SUBSIDY.JOB_SEEKING_FLAG IS '求职创业补贴标识（是/否）'; COMMENT ON COLUMN DA_JOB_SEEKING_SUBSIDY.JOB_SEEKING_STATUS IS '求职创业状态（求职中/创业中）'; COMMENT ON COLUMN DA_JOB_SEEKING_SUBSIDY.CONTACT_PHONE IS '联系方式'; COMMENT ON COLUMN DA_JOB_SEEKING_SUBSIDY.SUBSIDY_AMOUNT IS '补贴金额'; COMMENT ON COLUMN DA_JOB_SEEKING_SUBSIDY.FIRST_DECLARE_DATE IS '首次可申报日期'; COMMENT ON COLUMN DA_JOB_SEEKING_SUBSIDY.DEADLINE_DATE IS '补贴期限截止日期'; COMMENT ON COLUMN DA_JOB_SEEKING_SUBSIDY.DECLARE_STATUS IS '申报状态（未申报/已申报/待审核/已通过/已驳回）'; COMMENT ON COLUMN DA_JOB_SEEKING_SUBSIDY.LAST_NOTIFY_TIME IS '最后通知时间（发送消息后自动记录时间）'; COMMENT ON COLUMN DA_JOB_SEEKING_SUBSIDY.DATA_REFLUX_TIME IS '数据回流时间'; COMMENT ON COLUMN DA_JOB_SEEKING_SUBSIDY.CREATE_BY IS '创建人'; COMMENT ON COLUMN DA_JOB_SEEKING_SUBSIDY.CREATE_TIME IS '创建时间'; COMMENT ON COLUMN DA_JOB_SEEKING_SUBSIDY.UPDATE_BY IS '修改人'; COMMENT ON COLUMN DA_JOB_SEEKING_SUBSIDY.UPDATE_TIME IS '更新时间'; COMMENT ON COLUMN DA_JOB_SEEKING_SUBSIDY.SYS_ORG_CODE IS '组织机构编号'; CREATE INDEX IDX_DA_JOB_SEEKING_SUBSIDY_ID_CARD ON DA_JOB_SEEKING_SUBSIDY(ID_CARD); CREATE INDEX IDX_DA_JOB_SEEKING_SUBSIDY_STATUS ON DA_JOB_SEEKING_SUBSIDY(DECLARE_STATUS); -- ============================================================ -- 3.6.10 粤东粤西粤北地区就业补贴（个人） -- 说明：省平台回流，记录符合粤东西北地区就业补贴条件的个人信息 -- ============================================================ CREATE TABLE DA_NORTH_REGION_SUBSIDY ( ID VARCHAR(36) NOT NULL, RECORD_ID VARCHAR(100), ID_CARD VARCHAR(50), FULL_NAME VARCHAR(100), DISTRICT VARCHAR(50), EDUCATION_LEVEL VARCHAR(100), EMPLOY_REGION VARCHAR(50), NORTH_REGION_FLAG VARCHAR(10), SOCIAL_SEC_SIX_MONTHS VARCHAR(10), CONTACT_PHONE VARCHAR(50), SUBSIDY_AMOUNT NUMERIC(18,2), FIRST_DECLARE_DATE DATE, DEADLINE_DATE DATE, DECLARE_STATUS VARCHAR(50), LAST_NOTIFY_TIME DATE, DATA_REFLUX_TIME DATE, CREATE_BY VARCHAR(50), CREATE_TIME DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, UPDATE_BY VARCHAR(50), UPDATE_TIME DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, SYS_ORG_CODE VARCHAR(50), PRIMARY KEY (ID) ); COMMENT ON TABLE DA_NORTH_REGION_SUBSIDY IS '粤东粤西粤北地区就业补贴（个人）'; COMMENT ON COLUMN DA_NORTH_REGION_SUBSIDY.ID IS '主键ID'; COMMENT ON COLUMN DA_NORTH_REGION_SUBSIDY.RECORD_ID IS '备案记录ID（省平台唯一标识，用于数据关联）'; COMMENT ON COLUMN DA_NORTH_REGION_SUBSIDY.ID_CARD IS '个人身份证号'; COMMENT ON COLUMN DA_NORTH_REGION_SUBSIDY.FULL_NAME IS '姓名'; COMMENT ON COLUMN DA_NORTH_REGION_SUBSIDY.DISTRICT IS '所属县区（户籍所在地）'; COMMENT ON COLUMN DA_NORTH_REGION_SUBSIDY.EDUCATION_LEVEL IS '学历档次'; COMMENT ON COLUMN DA_NORTH_REGION_SUBSIDY.EMPLOY_REGION IS '就业区域（粤东/粤西/粤北）'; COMMENT ON COLUMN DA_NORTH_REGION_SUBSIDY.NORTH_REGION_FLAG IS '粤东西北就业补贴标识（是/否）'; COMMENT ON COLUMN DA_NORTH_REGION_SUBSIDY.SOCIAL_SEC_SIX_MONTHS IS '社保缴费满6个月（是/否）'; COMMENT ON COLUMN DA_NORTH_REGION_SUBSIDY.CONTACT_PHONE IS '联系方式'; COMMENT ON COLUMN DA_NORTH_REGION_SUBSIDY.SUBSIDY_AMOUNT IS '补贴金额'; COMMENT ON COLUMN DA_NORTH_REGION_SUBSIDY.FIRST_DECLARE_DATE IS '首次可申报日期'; COMMENT ON COLUMN DA_NORTH_REGION_SUBSIDY.DEADLINE_DATE IS '补贴期限截止日期'; COMMENT ON COLUMN DA_NORTH_REGION_SUBSIDY.DECLARE_STATUS IS '申报状态（未申报/已申报/待审核/已通过/已驳回）'; COMMENT ON COLUMN DA_NORTH_REGION_SUBSIDY.LAST_NOTIFY_TIME IS '最后通知时间（发送消息后自动记录时间）'; COMMENT ON COLUMN DA_NORTH_REGION_SUBSIDY.DATA_REFLUX_TIME IS '数据回流时间'; COMMENT ON COLUMN DA_NORTH_REGION_SUBSIDY.CREATE_BY IS '创建人'; COMMENT ON COLUMN DA_NORTH_REGION_SUBSIDY.CREATE_TIME IS '创建时间'; COMMENT ON COLUMN DA_NORTH_REGION_SUBSIDY.UPDATE_BY IS '修改人'; COMMENT ON COLUMN DA_NORTH_REGION_SUBSIDY.UPDATE_TIME IS '更新时间'; COMMENT ON COLUMN DA_NORTH_REGION_SUBSIDY.SYS_ORG_CODE IS '组织机构编号'; CREATE INDEX IDX_DA_NORTH_REGION_SUBSIDY_ID_CARD ON DA_NORTH_REGION_SUBSIDY(ID_CARD); CREATE INDEX IDX_DA_NORTH_REGION_SUBSIDY_STATUS ON DA_NORTH_REGION_SUBSIDY(DECLARE_STATUS); -- ============================================================ -- 3.6.11 就业见习补贴（企业） -- 说明：省平台回流，记录符合就业见习补贴条件的企业信息 -- ============================================================ CREATE TABLE DA_JOB_INTERNSHIP_SUBSIDY ( ID VARCHAR(36) NOT NULL, RECORD_ID VARCHAR(100), UNIT_CREDIT_CODE VARCHAR(50), UNIT_NAME VARCHAR(200), DISTRICT VARCHAR(50), UNIT_TYPE VARCHAR(100), INTERNSHIP_FLAG VARCHAR(10), INTERNSHIP_POST_COUNT INTEGER, INTERN_COUNT INTEGER, INTERNSHIP_MONTHS INTEGER, SUBSIDY_STANDARD VARCHAR(100), FIRST_DECLARE_DATE DATE, DEADLINE_DATE DATE, DECLARE_STATUS VARCHAR(50), LAST_NOTIFY_TIME DATE, DATA_REFLUX_TIME DATE, CREATE_BY VARCHAR(50), CREATE_TIME DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, UPDATE_BY VARCHAR(50), UPDATE_TIME DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, SYS_ORG_CODE VARCHAR(50), PRIMARY KEY (ID) ); COMMENT ON TABLE DA_JOB_INTERNSHIP_SUBSIDY IS '就业见习补贴（企业）'; COMMENT ON COLUMN DA_JOB_INTERNSHIP_SUBSIDY.ID IS '主键ID'; COMMENT ON COLUMN DA_JOB_INTERNSHIP_SUBSIDY.RECORD_ID IS '备案记录ID（省平台唯一标识，用于数据关联）'; COMMENT ON COLUMN DA_JOB_INTERNSHIP_SUBSIDY.UNIT_CREDIT_CODE IS '单位统一社会信用代码'; COMMENT ON COLUMN DA_JOB_INTERNSHIP_SUBSIDY.UNIT_NAME IS '单位名称'; COMMENT ON COLUMN DA_JOB_INTERNSHIP_SUBSIDY.DISTRICT IS '所属县区'; COMMENT ON COLUMN DA_JOB_INTERNSHIP_SUBSIDY.UNIT_TYPE IS '单位类型（企业/事业单位/社会组织，以回流数据为准）'; COMMENT ON COLUMN DA_JOB_INTERNSHIP_SUBSIDY.INTERNSHIP_FLAG IS '就业见习单位标识（是/否）'; COMMENT ON COLUMN DA_JOB_INTERNSHIP_SUBSIDY.INTERNSHIP_POST_COUNT IS '见习岗位数量'; COMMENT ON COLUMN DA_JOB_INTERNSHIP_SUBSIDY.INTERN_COUNT IS '见习人员数'; COMMENT ON COLUMN DA_JOB_INTERNSHIP_SUBSIDY.INTERNSHIP_MONTHS IS '见习时长（月）'; COMMENT ON COLUMN DA_JOB_INTERNSHIP_SUBSIDY.SUBSIDY_STANDARD IS '补贴标准'; COMMENT ON COLUMN DA_JOB_INTERNSHIP_SUBSIDY.FIRST_DECLARE_DATE IS '首次可申报日期'; COMMENT ON COLUMN DA_JOB_INTERNSHIP_SUBSIDY.DEADLINE_DATE IS '补贴期限截止日期'; COMMENT ON COLUMN DA_JOB_INTERNSHIP_SUBSIDY.DECLARE_STATUS IS '申报状态（未申报/已申报/待审核/已通过/已驳回）'; COMMENT ON COLUMN DA_JOB_INTERNSHIP_SUBSIDY.LAST_NOTIFY_TIME IS '最后通知时间（发送消息后自动记录时间）'; COMMENT ON COLUMN DA_JOB_INTERNSHIP_SUBSIDY.DATA_REFLUX_TIME IS '数据回流时间'; COMMENT ON COLUMN DA_JOB_INTERNSHIP_SUBSIDY.CREATE_BY IS '创建人'; COMMENT ON COLUMN DA_JOB_INTERNSHIP_SUBSIDY.CREATE_TIME IS '创建时间'; COMMENT ON COLUMN DA_JOB_INTERNSHIP_SUBSIDY.UPDATE_BY IS '修改人'; COMMENT ON COLUMN DA_JOB_INTERNSHIP_SUBSIDY.UPDATE_TIME IS '更新时间'; COMMENT ON COLUMN DA_JOB_INTERNSHIP_SUBSIDY.SYS_ORG_CODE IS '组织机构编号'; CREATE INDEX IDX_DA_JOB_INTERNSHIP_SUBSIDY_UNIT ON DA_JOB_INTERNSHIP_SUBSIDY(UNIT_CREDIT_CODE); CREATE INDEX IDX_DA_JOB_INTERNSHIP_SUBSIDY_STATUS ON DA_JOB_INTERNSHIP_SUBSIDY(DECLARE_STATUS); -- ============================================================ -- 3.6.12 一次性吸纳就业补贴（企业） -- 说明：省平台回流，记录符合一次性吸纳就业补贴条件的企业信息 -- ============================================================ CREATE TABLE DA_ONE_TIME_ABSORB_SUBSIDY ( ID VARCHAR(36) NOT NULL, RECORD_ID VARCHAR(100), UNIT_CREDIT_CODE VARCHAR(50), UNIT_NAME VARCHAR(200), DISTRICT VARCHAR(50), UNIT_TYPE VARCHAR(100), ONE_TIME_ABSORB_FLAG VARCHAR(10), ABSORB_COUNT INTEGER, ABSORB_PERSON_CATEGORY VARCHAR(200), SOCIAL_SEC_MONTHS INTEGER, SUBSIDY_AMOUNT NUMERIC(18,2), FIRST_DECLARE_DATE DATE, DEADLINE_DATE DATE, DECLARE_STATUS VARCHAR(50), LAST_NOTIFY_TIME DATE, DATA_REFLUX_TIME DATE, CREATE_BY VARCHAR(50), CREATE_TIME DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, UPDATE_BY VARCHAR(50), UPDATE_TIME DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, SYS_ORG_CODE VARCHAR(50), PRIMARY KEY (ID) ); COMMENT ON TABLE DA_ONE_TIME_ABSORB_SUBSIDY IS '一次性吸纳就业补贴（企业）'; COMMENT ON COLUMN DA_ONE_TIME_ABSORB_SUBSIDY.ID IS '主键ID'; COMMENT ON COLUMN DA_ONE_TIME_ABSORB_SUBSIDY.RECORD_ID IS '备案记录ID（省平台唯一标识，用于数据关联）'; COMMENT ON COLUMN DA_ONE_TIME_ABSORB_SUBSIDY.UNIT_CREDIT_CODE IS '单位统一社会信用代码'; COMMENT ON COLUMN DA_ONE_TIME_ABSORB_SUBSIDY.UNIT_NAME IS '单位名称'; COMMENT ON COLUMN DA_ONE_TIME_ABSORB_SUBSIDY.DISTRICT IS '所属县区'; COMMENT ON COLUMN DA_ONE_TIME_ABSORB_SUBSIDY.UNIT_TYPE IS '单位类型（企业/事业单位/社会组织，以回流数据为准）'; COMMENT ON COLUMN DA_ONE_TIME_ABSORB_SUBSIDY.ONE_TIME_ABSORB_FLAG IS '一次性吸纳就业补贴标识（是/否）'; COMMENT ON COLUMN DA_ONE_TIME_ABSORB_SUBSIDY.ABSORB_COUNT IS '吸纳人数'; COMMENT ON COLUMN DA_ONE_TIME_ABSORB_SUBSIDY.ABSORB_PERSON_CATEGORY IS '吸纳人员类别（就业困难人员/脱贫人口/高校毕业生等，以回流数据为准）'; COMMENT ON COLUMN DA_ONE_TIME_ABSORB_SUBSIDY.SOCIAL_SEC_MONTHS IS '社保缴费时长（月）'; COMMENT ON COLUMN DA_ONE_TIME_ABSORB_SUBSIDY.SUBSIDY_AMOUNT IS '补贴金额'; COMMENT ON COLUMN DA_ONE_TIME_ABSORB_SUBSIDY.FIRST_DECLARE_DATE IS '首次可申报日期'; COMMENT ON COLUMN DA_ONE_TIME_ABSORB_SUBSIDY.DEADLINE_DATE IS '补贴期限截止日期'; COMMENT ON COLUMN DA_ONE_TIME_ABSORB_SUBSIDY.DECLARE_STATUS IS '申报状态（未申报/已申报/待审核/已通过/已驳回）'; COMMENT ON COLUMN DA_ONE_TIME_ABSORB_SUBSIDY.LAST_NOTIFY_TIME IS '最后通知时间（发送消息后自动记录时间）'; COMMENT ON COLUMN DA_ONE_TIME_ABSORB_SUBSIDY.DATA_REFLUX_TIME IS '数据回流时间'; COMMENT ON COLUMN DA_ONE_TIME_ABSORB_SUBSIDY.CREATE_BY IS '创建人'; COMMENT ON COLUMN DA_ONE_TIME_ABSORB_SUBSIDY.CREATE_TIME IS '创建时间'; COMMENT ON COLUMN DA_ONE_TIME_ABSORB_SUBSIDY.UPDATE_BY IS '修改人'; COMMENT ON COLUMN DA_ONE_TIME_ABSORB_SUBSIDY.UPDATE_TIME IS '更新时间'; COMMENT ON COLUMN DA_ONE_TIME_ABSORB_SUBSIDY.SYS_ORG_CODE IS '组织机构编号'; CREATE INDEX IDX_DA_ONE_TIME_ABSORB_SUBSIDY_UNIT ON DA_ONE_TIME_ABSORB_SUBSIDY(UNIT_CREDIT_CODE); CREATE INDEX IDX_DA_ONE_TIME_ABSORB_SUBSIDY_STATUS ON DA_ONE_TIME_ABSORB_SUBSIDY(DECLARE_STATUS); -- ============================================================ -- 3.6.13 吸纳退役军人就业补贴（企业） -- 说明：省平台回流，记录符合吸纳退役军人就业补贴条件的企业信息 -- ============================================================ CREATE TABLE DA_VETERAN_ABSORB_SUBSIDY ( ID VARCHAR(36) NOT NULL, RECORD_ID VARCHAR(100), UNIT_CREDIT_CODE VARCHAR(50), UNIT_NAME VARCHAR(200), DISTRICT VARCHAR(50), UNIT_TYPE VARCHAR(100), VETERAN_FLAG VARCHAR(10), VETERAN_COUNT INTEGER, SOCIAL_SEC_MONTHS INTEGER, SUBSIDY_STANDARD VARCHAR(100), SUBSIDY_TOTAL NUMERIC(18,2), FIRST_DECLARE_DATE DATE, DEADLINE_DATE DATE, DECLARE_STATUS VARCHAR(50), LAST_NOTIFY_TIME DATE, DATA_REFLUX_TIME DATE, CREATE_BY VARCHAR(50), CREATE_TIME DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, UPDATE_BY VARCHAR(50), UPDATE_TIME DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, SYS_ORG_CODE VARCHAR(50), PRIMARY KEY (ID) ); COMMENT ON TABLE DA_VETERAN_ABSORB_SUBSIDY IS '吸纳退役军人就业补贴（企业）'; COMMENT ON COLUMN DA_VETERAN_ABSORB_SUBSIDY.ID IS '主键ID'; COMMENT ON COLUMN DA_VETERAN_ABSORB_SUBSIDY.RECORD_ID IS '备案记录ID（省平台唯一标识，用于数据关联）'; COMMENT ON COLUMN DA_VETERAN_ABSORB_SUBSIDY.UNIT_CREDIT_CODE IS '单位统一社会信用代码'; COMMENT ON COLUMN DA_VETERAN_ABSORB_SUBSIDY.UNIT_NAME IS '单位名称'; COMMENT ON COLUMN DA_VETERAN_ABSORB_SUBSIDY.DISTRICT IS '所属县区'; COMMENT ON COLUMN DA_VETERAN_ABSORB_SUBSIDY.UNIT_TYPE IS '单位类型（企业/事业单位/社会组织，以回流数据为准）'; COMMENT ON COLUMN DA_VETERAN_ABSORB_SUBSIDY.VETERAN_FLAG IS '退役军人吸纳标识（是/否）'; COMMENT ON COLUMN DA_VETERAN_ABSORB_SUBSIDY.VETERAN_COUNT IS '吸纳退役军人人数'; COMMENT ON COLUMN DA_VETERAN_ABSORB_SUBSIDY.SOCIAL_SEC_MONTHS IS '社保缴费时长（月）'; COMMENT ON COLUMN DA_VETERAN_ABSORB_SUBSIDY.SUBSIDY_STANDARD IS '补贴标准'; COMMENT ON COLUMN DA_VETERAN_ABSORB_SUBSIDY.SUBSIDY_TOTAL IS '补贴总额（人数×标准）'; COMMENT ON COLUMN DA_VETERAN_ABSORB_SUBSIDY.FIRST_DECLARE_DATE IS '首次可申报日期'; COMMENT ON COLUMN DA_VETERAN_ABSORB_SUBSIDY.DEADLINE_DATE IS '补贴期限截止日期'; COMMENT ON COLUMN DA_VETERAN_ABSORB_SUBSIDY.DECLARE_STATUS IS '申报状态（未申报/已申报/待审核/已通过/已驳回）'; COMMENT ON COLUMN DA_VETERAN_ABSORB_SUBSIDY.LAST_NOTIFY_TIME IS '最后通知时间（发送消息后自动记录时间）'; COMMENT ON COLUMN DA_VETERAN_ABSORB_SUBSIDY.DATA_REFLUX_TIME IS '数据回流时间'; COMMENT ON COLUMN DA_VETERAN_ABSORB_SUBSIDY.CREATE_BY IS '创建人'; COMMENT ON COLUMN DA_VETERAN_ABSORB_SUBSIDY.CREATE_TIME IS '创建时间'; COMMENT ON COLUMN DA_VETERAN_ABSORB_SUBSIDY.UPDATE_BY IS '修改人'; COMMENT ON COLUMN DA_VETERAN_ABSORB_SUBSIDY.UPDATE_TIME IS '更新时间'; COMMENT ON COLUMN DA_VETERAN_ABSORB_SUBSIDY.SYS_ORG_CODE IS '组织机构编号'; CREATE INDEX IDX_DA_VETERAN_ABSORB_SUBSIDY_UNIT ON DA_VETERAN_ABSORB_SUBSIDY(UNIT_CREDIT_CODE); CREATE INDEX IDX_DA_VETERAN_ABSORB_SUBSIDY_STATUS ON DA_VETERAN_ABSORB_SUBSIDY(DECLARE_STATUS); -- ============================================================ -- 3.6.14 吸纳脱贫人口就业补贴（企业） -- 说明：省平台回流，记录符合吸纳脱贫人口就业补贴条件的企业信息 -- ============================================================ CREATE TABLE DA_POVERTY_ALLEVIATION_SUBSIDY ( ID VARCHAR(36) NOT NULL, RECORD_ID VARCHAR(100), UNIT_CREDIT_CODE VARCHAR(50), UNIT_NAME VARCHAR(200), DISTRICT VARCHAR(50), UNIT_TYPE VARCHAR(100), POVERTY_ALLEVIATION_FLAG VARCHAR(10), POVERTY_COUNT INTEGER, MONITOR_COUNT INTEGER, SOCIAL_SEC_MONTHS INTEGER, SUBSIDY_TYPE VARCHAR(100), SUBSIDY_STANDARD VARCHAR(100), SUBSIDY_AMOUNT NUMERIC(18,2), FIRST_DECLARE_DATE DATE, DEADLINE_DATE DATE, DECLARE_STATUS VARCHAR(50), LAST_NOTIFY_TIME DATE, DATA_REFLUX_TIME DATE, CREATE_BY VARCHAR(50), CREATE_TIME DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, UPDATE_BY VARCHAR(50), UPDATE_TIME DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, SYS_ORG_CODE VARCHAR(50), PRIMARY KEY (ID) ); COMMENT ON TABLE DA_POVERTY_ALLEVIATION_SUBSIDY IS '吸纳脱贫人口就业补贴（企业）'; COMMENT ON COLUMN DA_POVERTY_ALLEVIATION_SUBSIDY.ID IS '主键ID'; COMMENT ON COLUMN DA_POVERTY_ALLEVIATION_SUBSIDY.RECORD_ID IS '备案记录ID（省平台唯一标识，用于数据关联）'; COMMENT ON COLUMN DA_POVERTY_ALLEVIATION_SUBSIDY.UNIT_CREDIT_CODE IS '单位统一社会信用代码'; COMMENT ON COLUMN DA_POVERTY_ALLEVIATION_SUBSIDY.UNIT_NAME IS '单位名称'; COMMENT ON COLUMN DA_POVERTY_ALLEVIATION_SUBSIDY.DISTRICT IS '所属县区'; COMMENT ON COLUMN DA_POVERTY_ALLEVIATION_SUBSIDY.UNIT_TYPE IS '单位类型（企业/事业单位/社会组织，以回流数据为准）'; COMMENT ON COLUMN DA_POVERTY_ALLEVIATION_SUBSIDY.POVERTY_ALLEVIATION_FLAG IS '吸纳脱贫人员补贴标识（是/否）'; COMMENT ON COLUMN DA_POVERTY_ALLEVIATION_SUBSIDY.POVERTY_COUNT IS '吸纳脱贫人员数'; COMMENT ON COLUMN DA_POVERTY_ALLEVIATION_SUBSIDY.MONITOR_COUNT IS '防返贫监测对象数'; COMMENT ON COLUMN DA_POVERTY_ALLEVIATION_SUBSIDY.SOCIAL_SEC_MONTHS IS '社保缴费时长（月）'; COMMENT ON COLUMN DA_POVERTY_ALLEVIATION_SUBSIDY.SUBSIDY_TYPE IS '补贴类型（一次性吸纳补贴/稳岗补贴，以回流数据为准）'; COMMENT ON COLUMN DA_POVERTY_ALLEVIATION_SUBSIDY.SUBSIDY_STANDARD IS '补贴标准（按补贴类型设定的每人补贴金额）'; COMMENT ON COLUMN DA_POVERTY_ALLEVIATION_SUBSIDY.SUBSIDY_AMOUNT IS '补贴金额'; COMMENT ON COLUMN DA_POVERTY_ALLEVIATION_SUBSIDY.FIRST_DECLARE_DATE IS '首次可申报日期'; COMMENT ON COLUMN DA_POVERTY_ALLEVIATION_SUBSIDY.DEADLINE_DATE IS '补贴期限截止日期'; COMMENT ON COLUMN DA_POVERTY_ALLEVIATION_SUBSIDY.DECLARE_STATUS IS '申报状态（未申报/已申报/待审核/已通过/已驳回）'; COMMENT ON COLUMN DA_POVERTY_ALLEVIATION_SUBSIDY.LAST_NOTIFY_TIME IS '最后通知时间（发送消息后自动记录时间）'; COMMENT ON COLUMN DA_POVERTY_ALLEVIATION_SUBSIDY.DATA_REFLUX_TIME IS '数据回流时间'; COMMENT ON COLUMN DA_POVERTY_ALLEVIATION_SUBSIDY.CREATE_BY IS '创建人'; COMMENT ON COLUMN DA_POVERTY_ALLEVIATION_SUBSIDY.CREATE_TIME IS '创建时间'; COMMENT ON COLUMN DA_POVERTY_ALLEVIATION_SUBSIDY.UPDATE_BY IS '修改人'; COMMENT ON COLUMN DA_POVERTY_ALLEVIATION_SUBSIDY.UPDATE_TIME IS '更新时间'; COMMENT ON COLUMN DA_POVERTY_ALLEVIATION_SUBSIDY.SYS_ORG_CODE IS '组织机构编号'; CREATE INDEX IDX_DA_POVERTY_ALLEVIATION_SUBSIDY_UNIT ON DA_POVERTY_ALLEVIATION_SUBSIDY(UNIT_CREDIT_CODE); CREATE INDEX IDX_DA_POVERTY_ALLEVIATION_SUBSIDY_STATUS ON DA_POVERTY_ALLEVIATION_SUBSIDY(DECLARE_STATUS); -- ============================================================ -- 3.6.15 一次性创业资助（个人） -- 说明：省平台回流，记录符合一次性创业资助条件的个人信息 -- ============================================================ CREATE TABLE DA_ONE_TIME_STARTUP_SUBSIDY ( ID VARCHAR(36) NOT NULL, RECORD_ID VARCHAR(100), ID_CARD VARCHAR(50), FULL_NAME VARCHAR(100), DISTRICT VARCHAR(50), REGISTER_TYPE VARCHAR(100), STARTUP_FLAG VARCHAR(10), SUBSIDY_AMOUNT NUMERIC(18,2), DRIVE_EMPLOY_COUNT INTEGER, BUSINESS_ADDRESS VARCHAR(500), CONTACT_PHONE VARCHAR(50), FIRST_DECLARE_DATE DATE, DEADLINE_DATE DATE, DECLARE_STATUS VARCHAR(50), LAST_NOTIFY_TIME DATE, DATA_REFLUX_TIME DATE, CREATE_BY VARCHAR(50), CREATE_TIME DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, UPDATE_BY VARCHAR(50), UPDATE_TIME DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, SYS_ORG_CODE VARCHAR(50), PRIMARY KEY (ID) ); COMMENT ON TABLE DA_ONE_TIME_STARTUP_SUBSIDY IS '一次性创业资助（个人）'; COMMENT ON COLUMN DA_ONE_TIME_STARTUP_SUBSIDY.ID IS '主键ID'; COMMENT ON COLUMN DA_ONE_TIME_STARTUP_SUBSIDY.RECORD_ID IS '备案记录ID（省平台唯一标识，用于数据关联）'; COMMENT ON COLUMN DA_ONE_TIME_STARTUP_SUBSIDY.ID_CARD IS '个人身份证号'; COMMENT ON COLUMN DA_ONE_TIME_STARTUP_SUBSIDY.FULL_NAME IS '姓名'; COMMENT ON COLUMN DA_ONE_TIME_STARTUP_SUBSIDY.DISTRICT IS '所属县区（户籍所在地）'; COMMENT ON COLUMN DA_ONE_TIME_STARTUP_SUBSIDY.REGISTER_TYPE IS '注册类型（个体工商户/企业/农民专业合作社，以回流数据为准）'; COMMENT ON COLUMN DA_ONE_TIME_STARTUP_SUBSIDY.STARTUP_FLAG IS '创业资助标识（是/否）'; COMMENT ON COLUMN DA_ONE_TIME_STARTUP_SUBSIDY.SUBSIDY_AMOUNT IS '资助金额'; COMMENT ON COLUMN DA_ONE_TIME_STARTUP_SUBSIDY.DRIVE_EMPLOY_COUNT IS '带动就业人数'; COMMENT ON COLUMN DA_ONE_TIME_STARTUP_SUBSIDY.BUSINESS_ADDRESS IS '经营场所地址'; COMMENT ON COLUMN DA_ONE_TIME_STARTUP_SUBSIDY.CONTACT_PHONE IS '联系电话'; COMMENT ON COLUMN DA_ONE_TIME_STARTUP_SUBSIDY.FIRST_DECLARE_DATE IS '首次可申报日期'; COMMENT ON COLUMN DA_ONE_TIME_STARTUP_SUBSIDY.DEADLINE_DATE IS '补贴期限截止日期'; COMMENT ON COLUMN DA_ONE_TIME_STARTUP_SUBSIDY.DECLARE_STATUS IS '申报状态（未申报/已申报/待审核/已通过/已驳回）'; COMMENT ON COLUMN DA_ONE_TIME_STARTUP_SUBSIDY.LAST_NOTIFY_TIME IS '最后通知时间（发送消息后自动记录时间）'; COMMENT ON COLUMN DA_ONE_TIME_STARTUP_SUBSIDY.DATA_REFLUX_TIME IS '数据回流时间'; COMMENT ON COLUMN DA_ONE_TIME_STARTUP_SUBSIDY.CREATE_BY IS '创建人'; COMMENT ON COLUMN DA_ONE_TIME_STARTUP_SUBSIDY.CREATE_TIME IS '创建时间'; COMMENT ON COLUMN DA_ONE_TIME_STARTUP_SUBSIDY.UPDATE_BY IS '修改人'; COMMENT ON COLUMN DA_ONE_TIME_STARTUP_SUBSIDY.UPDATE_TIME IS '更新时间'; COMMENT ON COLUMN DA_ONE_TIME_STARTUP_SUBSIDY.SYS_ORG_CODE IS '组织机构编号'; CREATE INDEX IDX_DA_ONE_TIME_STARTUP_SUBSIDY_ID_CARD ON DA_ONE_TIME_STARTUP_SUBSIDY(ID_CARD); CREATE INDEX IDX_DA_ONE_TIME_STARTUP_SUBSIDY_STATUS ON DA_ONE_TIME_STARTUP_SUBSIDY(DECLARE_STATUS); -- ============================================================ -- 3.6.16 创业租金补贴（个人） -- 说明：省平台回流，记录符合创业租金补贴条件的个人信息 -- ============================================================ CREATE TABLE DA_STARTUP_RENT_SUBSIDY ( ID VARCHAR(36) NOT NULL, RECORD_ID VARCHAR(100), ID_CARD VARCHAR(50), FULL_NAME VARCHAR(100), DISTRICT VARCHAR(50), REGISTER_TYPE VARCHAR(100), RENT_FLAG VARCHAR(10), BUSINESS_ADDRESS VARCHAR(500), LEASE_RECORD_NO VARCHAR(100), LEASE_TERM INTEGER, MONTHLY_RENT NUMERIC(18,2), SUBSIDY_RATIO VARCHAR(50), MONTHLY_SUBSIDY NUMERIC(18,2), SUBSIDY_CYCLE VARCHAR(50), REMAINING_TERM INTEGER, CONTACT_PHONE VARCHAR(50), FIRST_DECLARE_DATE DATE, DEADLINE_DATE DATE, DECLARE_STATUS VARCHAR(50), LAST_NOTIFY_TIME DATE, DATA_REFLUX_TIME DATE, CREATE_BY VARCHAR(50), CREATE_TIME DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, UPDATE_BY VARCHAR(50), UPDATE_TIME DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, SYS_ORG_CODE VARCHAR(50), PRIMARY KEY (ID) ); COMMENT ON TABLE DA_STARTUP_RENT_SUBSIDY IS '创业租金补贴（个人）'; COMMENT ON COLUMN DA_STARTUP_RENT_SUBSIDY.ID IS '主键ID'; COMMENT ON COLUMN DA_STARTUP_RENT_SUBSIDY.RECORD_ID IS '备案记录ID（省平台唯一标识，用于数据关联）'; COMMENT ON COLUMN DA_STARTUP_RENT_SUBSIDY.ID_CARD IS '个人身份证号'; COMMENT ON COLUMN DA_STARTUP_RENT_SUBSIDY.FULL_NAME IS '姓名'; COMMENT ON COLUMN DA_STARTUP_RENT_SUBSIDY.DISTRICT IS '所属县区（户籍所在地）'; COMMENT ON COLUMN DA_STARTUP_RENT_SUBSIDY.REGISTER_TYPE IS '注册类型（个体工商户/企业/农民专业合作社，以回流数据为准）'; COMMENT ON COLUMN DA_STARTUP_RENT_SUBSIDY.RENT_FLAG IS '创业租金补贴标识（是/否）'; COMMENT ON COLUMN DA_STARTUP_RENT_SUBSIDY.BUSINESS_ADDRESS IS '经营场所地址'; COMMENT ON COLUMN DA_STARTUP_RENT_SUBSIDY.LEASE_RECORD_NO IS '租赁备案号'; COMMENT ON COLUMN DA_STARTUP_RENT_SUBSIDY.LEASE_TERM IS '租赁期限'; COMMENT ON COLUMN DA_STARTUP_RENT_SUBSIDY.MONTHLY_RENT IS '月租金金额'; COMMENT ON COLUMN DA_STARTUP_RENT_SUBSIDY.SUBSIDY_RATIO IS '补贴比例'; COMMENT ON COLUMN DA_STARTUP_RENT_SUBSIDY.MONTHLY_SUBSIDY IS '月补贴金额'; COMMENT ON COLUMN DA_STARTUP_RENT_SUBSIDY.SUBSIDY_CYCLE IS '补贴周期（按月/按季度，以回流数据为准）'; COMMENT ON COLUMN DA_STARTUP_RENT_SUBSIDY.REMAINING_TERM IS '剩余补贴期限'; COMMENT ON COLUMN DA_STARTUP_RENT_SUBSIDY.CONTACT_PHONE IS '联系电话'; COMMENT ON COLUMN DA_STARTUP_RENT_SUBSIDY.FIRST_DECLARE_DATE IS '首次可申报日期'; COMMENT ON COLUMN DA_STARTUP_RENT_SUBSIDY.DEADLINE_DATE IS '补贴期限截止日期'; COMMENT ON COLUMN DA_STARTUP_RENT_SUBSIDY.DECLARE_STATUS IS '申报状态（未申报/已申报/待审核/已通过/已驳回）'; COMMENT ON COLUMN DA_STARTUP_RENT_SUBSIDY.LAST_NOTIFY_TIME IS '最后通知时间（发送消息后自动记录时间）'; COMMENT ON COLUMN DA_STARTUP_RENT_SUBSIDY.DATA_REFLUX_TIME IS '数据回流时间'; COMMENT ON COLUMN DA_STARTUP_RENT_SUBSIDY.CREATE_BY IS '创建人'; COMMENT ON COLUMN DA_STARTUP_RENT_SUBSIDY.CREATE_TIME IS '创建时间'; COMMENT ON COLUMN DA_STARTUP_RENT_SUBSIDY.UPDATE_BY IS '修改人'; COMMENT ON COLUMN DA_STARTUP_RENT_SUBSIDY.UPDATE_TIME IS '更新时间'; COMMENT ON COLUMN DA_STARTUP_RENT_SUBSIDY.SYS_ORG_CODE IS '组织机构编号'; CREATE INDEX IDX_DA_STARTUP_RENT_SUBSIDY_ID_CARD ON DA_STARTUP_RENT_SUBSIDY(ID_CARD); CREATE INDEX IDX_DA_STARTUP_RENT_SUBSIDY_STATUS ON DA_STARTUP_RENT_SUBSIDY(DECLARE_STATUS); -- ============================================================ -- 3.6.17 创业带动就业补贴（企业） -- 说明：省平台回流，记录符合创业带动就业补贴条件的企业信息 -- ============================================================ CREATE TABLE DA_STARTUP_DRIVE_EMPLOY_SUBSIDY ( ID VARCHAR(36) NOT NULL, RECORD_ID VARCHAR(100), UNIT_CREDIT_CODE VARCHAR(50), UNIT_NAME VARCHAR(200), DISTRICT VARCHAR(50), STARTUP_FLAG VARCHAR(10), EXCLUDE_FLAG VARCHAR(10), COMPLIANT_HIRE_COUNT INTEGER, NET_INCREASE_COUNT INTEGER, SUBSIDY_TOTAL NUMERIC(18,2), REGISTER_DATE DATE, FIRST_DECLARE_DATE DATE, DEADLINE_DATE DATE, DECLARE_STATUS VARCHAR(50), LAST_NOTIFY_TIME DATE, DATA_REFLUX_TIME DATE, CREATE_BY VARCHAR(50), CREATE_TIME DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, UPDATE_BY VARCHAR(50), UPDATE_TIME DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, SYS_ORG_CODE VARCHAR(50), PRIMARY KEY (ID) ); COMMENT ON TABLE DA_STARTUP_DRIVE_EMPLOY_SUBSIDY IS '创业带动就业补贴（企业）'; COMMENT ON COLUMN DA_STARTUP_DRIVE_EMPLOY_SUBSIDY.ID IS '主键ID'; COMMENT ON COLUMN DA_STARTUP_DRIVE_EMPLOY_SUBSIDY.RECORD_ID IS '备案记录ID（省平台唯一标识，用于数据关联）'; COMMENT ON COLUMN DA_STARTUP_DRIVE_EMPLOY_SUBSIDY.UNIT_CREDIT_CODE IS '单位统一社会信用代码'; COMMENT ON COLUMN DA_STARTUP_DRIVE_EMPLOY_SUBSIDY.UNIT_NAME IS '单位名称'; COMMENT ON COLUMN DA_STARTUP_DRIVE_EMPLOY_SUBSIDY.DISTRICT IS '所属县区'; COMMENT ON COLUMN DA_STARTUP_DRIVE_EMPLOY_SUBSIDY.STARTUP_FLAG IS '初创企业标识'; COMMENT ON COLUMN DA_STARTUP_DRIVE_EMPLOY_SUBSIDY.EXCLUDE_FLAG IS '排除禁申标识'; COMMENT ON COLUMN DA_STARTUP_DRIVE_EMPLOY_SUBSIDY.COMPLIANT_HIRE_COUNT IS '合规招用总人数'; COMMENT ON COLUMN DA_STARTUP_DRIVE_EMPLOY_SUBSIDY.NET_INCREASE_COUNT IS '本期净增用工人数'; COMMENT ON COLUMN DA_STARTUP_DRIVE_EMPLOY_SUBSIDY.SUBSIDY_TOTAL IS '补贴核算总额'; COMMENT ON COLUMN DA_STARTUP_DRIVE_EMPLOY_SUBSIDY.REGISTER_DATE IS '企业注册成立日期'; COMMENT ON COLUMN DA_STARTUP_DRIVE_EMPLOY_SUBSIDY.FIRST_DECLARE_DATE IS '首次可申报日期'; COMMENT ON COLUMN DA_STARTUP_DRIVE_EMPLOY_SUBSIDY.DEADLINE_DATE IS '补贴期限截止日期'; COMMENT ON COLUMN DA_STARTUP_DRIVE_EMPLOY_SUBSIDY.DECLARE_STATUS IS '申报状态（未申报/已申报/待审核/已通过/已驳回）'; COMMENT ON COLUMN DA_STARTUP_DRIVE_EMPLOY_SUBSIDY.LAST_NOTIFY_TIME IS '最后通知时间（发送消息后自动记录时间）'; COMMENT ON COLUMN DA_STARTUP_DRIVE_EMPLOY_SUBSIDY.DATA_REFLUX_TIME IS '数据回流时间'; COMMENT ON COLUMN DA_STARTUP_DRIVE_EMPLOY_SUBSIDY.CREATE_BY IS '创建人'; COMMENT ON COLUMN DA_STARTUP_DRIVE_EMPLOY_SUBSIDY.CREATE_TIME IS '创建时间'; COMMENT ON COLUMN DA_STARTUP_DRIVE_EMPLOY_SUBSIDY.UPDATE_BY IS '修改人'; COMMENT ON COLUMN DA_STARTUP_DRIVE_EMPLOY_SUBSIDY.UPDATE_TIME IS '更新时间'; COMMENT ON COLUMN DA_STARTUP_DRIVE_EMPLOY_SUBSIDY.SYS_ORG_CODE IS '组织机构编号'; CREATE INDEX IDX_STARTUP_DRIVE_SUBSIDY_UNIT ON DA_STARTUP_DRIVE_EMPLOY_SUBSIDY(UNIT_CREDIT_CODE); CREATE INDEX IDX_STARTUP_DRIVE_SUBSIDY_STATUS ON DA_STARTUP_DRIVE_EMPLOY_SUBSIDY(DECLARE_STATUS); -- ============================================================ -- 3.6.18 创业孵化补贴（企业） -- 说明：省平台回流，记录符合创业孵化补贴条件的孵化基地信息 -- ============================================================ CREATE TABLE DA_STARTUP_INCUBATION_SUBSIDY ( ID VARCHAR(36) NOT NULL, RECORD_ID VARCHAR(100), UNIT_CREDIT_CODE VARCHAR(50), UNIT_NAME VARCHAR(200), DISTRICT VARCHAR(50), INCUBATION_BASE_NO VARCHAR(100), SIX_CATEGORY_FLAG VARCHAR(10), INCUBATION_OCCUPANCY INTEGER, INCUBATION_YEARS INTEGER, SUBSIDY_YEARS INTEGER, ANNUAL_STANDARD NUMERIC(18,2), SUBSIDY_TOTAL NUMERIC(18,2), BUSINESS_REGISTER_DATE DATE, INCUBATION_END_DATE DATE, BUSINESS_ABNORMAL_FLAG VARCHAR(10), CONTACT_PHONE VARCHAR(50), FIRST_DECLARE_DATE DATE, DEADLINE_DATE DATE, DECLARE_STATUS VARCHAR(50), LAST_NOTIFY_TIME DATE, DATA_REFLUX_TIME DATE, CREATE_BY VARCHAR(50), CREATE_TIME DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, UPDATE_BY VARCHAR(50), UPDATE_TIME DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, SYS_ORG_CODE VARCHAR(50), PRIMARY KEY (ID) ); COMMENT ON TABLE DA_STARTUP_INCUBATION_SUBSIDY IS '创业孵化补贴（企业）'; COMMENT ON COLUMN DA_STARTUP_INCUBATION_SUBSIDY.ID IS '主键ID'; COMMENT ON COLUMN DA_STARTUP_INCUBATION_SUBSIDY.RECORD_ID IS '备案记录ID（省平台唯一标识，用于数据关联）'; COMMENT ON COLUMN DA_STARTUP_INCUBATION_SUBSIDY.UNIT_CREDIT_CODE IS '单位统一社会信用代码（孵化基地）'; COMMENT ON COLUMN DA_STARTUP_INCUBATION_SUBSIDY.UNIT_NAME IS '单位名称（孵化基地名称）'; COMMENT ON COLUMN DA_STARTUP_INCUBATION_SUBSIDY.DISTRICT IS '所属县区'; COMMENT ON COLUMN DA_STARTUP_INCUBATION_SUBSIDY.INCUBATION_BASE_NO IS '人社认定基地编号'; COMMENT ON COLUMN DA_STARTUP_INCUBATION_SUBSIDY.SIX_CATEGORY_FLAG IS '六类孵化对象标识（是/否）'; COMMENT ON COLUMN DA_STARTUP_INCUBATION_SUBSIDY.INCUBATION_OCCUPANCY IS '在孵合规户数'; COMMENT ON COLUMN DA_STARTUP_INCUBATION_SUBSIDY.INCUBATION_YEARS IS '孵化服务年限'; COMMENT ON COLUMN DA_STARTUP_INCUBATION_SUBSIDY.SUBSIDY_YEARS IS '补贴核算年限'; COMMENT ON COLUMN DA_STARTUP_INCUBATION_SUBSIDY.ANNUAL_STANDARD IS '年度每户补贴标准'; COMMENT ON COLUMN DA_STARTUP_INCUBATION_SUBSIDY.SUBSIDY_TOTAL IS '本次应补总金额'; COMMENT ON COLUMN DA_STARTUP_INCUBATION_SUBSIDY.BUSINESS_REGISTER_DATE IS '营业执照注册日期'; COMMENT ON COLUMN DA_STARTUP_INCUBATION_SUBSIDY.INCUBATION_END_DATE IS '孵化期满日期'; COMMENT ON COLUMN DA_STARTUP_INCUBATION_SUBSIDY.BUSINESS_ABNORMAL_FLAG IS '经营异常名录标识'; COMMENT ON COLUMN DA_STARTUP_INCUBATION_SUBSIDY.CONTACT_PHONE IS '联系人手机'; COMMENT ON COLUMN DA_STARTUP_INCUBATION_SUBSIDY.FIRST_DECLARE_DATE IS '首次可申报日期'; COMMENT ON COLUMN DA_STARTUP_INCUBATION_SUBSIDY.DEADLINE_DATE IS '补贴期限截止日期'; COMMENT ON COLUMN DA_STARTUP_INCUBATION_SUBSIDY.DECLARE_STATUS IS '申报状态（未申报/已申报/待审核/已通过/已驳回）'; COMMENT ON COLUMN DA_STARTUP_INCUBATION_SUBSIDY.LAST_NOTIFY_TIME IS '最后通知时间（发送消息后自动记录时间）'; COMMENT ON COLUMN DA_STARTUP_INCUBATION_SUBSIDY.DATA_REFLUX_TIME IS '数据回流时间'; COMMENT ON COLUMN DA_STARTUP_INCUBATION_SUBSIDY.CREATE_BY IS '创建人'; COMMENT ON COLUMN DA_STARTUP_INCUBATION_SUBSIDY.CREATE_TIME IS '创建时间'; COMMENT ON COLUMN DA_STARTUP_INCUBATION_SUBSIDY.UPDATE_BY IS '修改人'; COMMENT ON COLUMN DA_STARTUP_INCUBATION_SUBSIDY.UPDATE_TIME IS '更新时间'; COMMENT ON COLUMN DA_STARTUP_INCUBATION_SUBSIDY.SYS_ORG_CODE IS '组织机构编号'; CREATE INDEX IDX_DA_STARTUP_INCUBATION_SUBSIDY_UNIT ON DA_STARTUP_INCUBATION_SUBSIDY(UNIT_CREDIT_CODE); CREATE INDEX IDX_DA_STARTUP_INCUBATION_SUBSIDY_STATUS ON DA_STARTUP_INCUBATION_SUBSIDY(DECLARE_STATUS); -- ============================================================ -- 3.6.19 员工制家政企业吸纳就业补贴（企业） -- 说明：省平台回流，记录符合员工制家政企业吸纳就业补贴条件的企业信息 -- ============================================================ CREATE TABLE DA_FAMILY_SERVICE_ABSORB_SUBSIDY ( ID VARCHAR(36) NOT NULL, RECORD_ID VARCHAR(100), UNIT_CREDIT_CODE VARCHAR(50), UNIT_NAME VARCHAR(200), DISTRICT VARCHAR(50), AREA_TYPE VARCHAR(50), MONTHLY_AVG_PERSONS INTEGER, SUBSIDY_TOTAL NUMERIC(18,2), CONTACT_PHONE VARCHAR(50), FIRST_DECLARE_DATE DATE, DEADLINE_DATE DATE, DECLARE_STATUS VARCHAR(50), LAST_NOTIFY_TIME DATE, DATA_REFLUX_TIME DATE, CREATE_BY VARCHAR(50), CREATE_TIME DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, UPDATE_BY VARCHAR(50), UPDATE_TIME DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, SYS_ORG_CODE VARCHAR(50), PRIMARY KEY (ID) ); COMMENT ON TABLE DA_FAMILY_SERVICE_ABSORB_SUBSIDY IS '员工制家政企业吸纳就业补贴（企业）'; COMMENT ON COLUMN DA_FAMILY_SERVICE_ABSORB_SUBSIDY.ID IS '主键ID'; COMMENT ON COLUMN DA_FAMILY_SERVICE_ABSORB_SUBSIDY.RECORD_ID IS '备案记录ID（省平台唯一标识，用于数据关联）'; COMMENT ON COLUMN DA_FAMILY_SERVICE_ABSORB_SUBSIDY.UNIT_CREDIT_CODE IS '单位统一社会信用代码'; COMMENT ON COLUMN DA_FAMILY_SERVICE_ABSORB_SUBSIDY.UNIT_NAME IS '单位名称'; COMMENT ON COLUMN DA_FAMILY_SERVICE_ABSORB_SUBSIDY.DISTRICT IS '所属县区'; COMMENT ON COLUMN DA_FAMILY_SERVICE_ABSORB_SUBSIDY.AREA_TYPE IS '区域类型（珠三角/粤东西北，以回流数据为准）'; COMMENT ON COLUMN DA_FAMILY_SERVICE_ABSORB_SUBSIDY.MONTHLY_AVG_PERSONS IS '月平均缴费人数'; COMMENT ON COLUMN DA_FAMILY_SERVICE_ABSORB_SUBSIDY.SUBSIDY_TOTAL IS '补贴核算总额'; COMMENT ON COLUMN DA_FAMILY_SERVICE_ABSORB_SUBSIDY.CONTACT_PHONE IS '联系人手机'; COMMENT ON COLUMN DA_FAMILY_SERVICE_ABSORB_SUBSIDY.FIRST_DECLARE_DATE IS '首次可申报日期'; COMMENT ON COLUMN DA_FAMILY_SERVICE_ABSORB_SUBSIDY.DEADLINE_DATE IS '补贴期限截止日期'; COMMENT ON COLUMN DA_FAMILY_SERVICE_ABSORB_SUBSIDY.DECLARE_STATUS IS '申报状态（未申报/已申报/待审核/已通过/已驳回）'; COMMENT ON COLUMN DA_FAMILY_SERVICE_ABSORB_SUBSIDY.LAST_NOTIFY_TIME IS '最后通知时间（发送消息后自动记录时间）'; COMMENT ON COLUMN DA_FAMILY_SERVICE_ABSORB_SUBSIDY.DATA_REFLUX_TIME IS '数据回流时间'; COMMENT ON COLUMN DA_FAMILY_SERVICE_ABSORB_SUBSIDY.CREATE_BY IS '创建人'; COMMENT ON COLUMN DA_FAMILY_SERVICE_ABSORB_SUBSIDY.CREATE_TIME IS '创建时间'; COMMENT ON COLUMN DA_FAMILY_SERVICE_ABSORB_SUBSIDY.UPDATE_BY IS '修改人'; COMMENT ON COLUMN DA_FAMILY_SERVICE_ABSORB_SUBSIDY.UPDATE_TIME IS '更新时间'; COMMENT ON COLUMN DA_FAMILY_SERVICE_ABSORB_SUBSIDY.SYS_ORG_CODE IS '组织机构编号'; CREATE INDEX IDX_DA_FAMILY_SERVICE_ABSORB_SUBSIDY_UNIT ON DA_FAMILY_SERVICE_ABSORB_SUBSIDY(UNIT_CREDIT_CODE); CREATE INDEX IDX_DA_FAMILY_SERVICE_ABSORB_SUBSIDY_STATUS ON DA_FAMILY_SERVICE_ABSORB_SUBSIDY(DECLARE_STATUS); -- ============================================================ -- 3.6.20 家政服务企业商业保险补贴（企业） -- 说明：省平台回流，记录符合家政服务企业商业保险补贴条件的企业信息 -- ============================================================ CREATE TABLE DA_FAMILY_SERVICE_INSURANCE_SUBSIDY ( ID VARCHAR(36) NOT NULL, RECORD_ID VARCHAR(100), UNIT_CREDIT_CODE VARCHAR(50), UNIT_NAME VARCHAR(200), DISTRICT VARCHAR(50), AREA_TYPE VARCHAR(50), HOUSEKEEPING_COUNT INTEGER, INSURED_COUNT INTEGER, ANNUAL_PREMIUM NUMERIC(18,2), SUBSIDY_TOTAL NUMERIC(18,2), SUBSIDY_YEARS INTEGER, CONTACT_PHONE VARCHAR(50), FIRST_DECLARE_DATE DATE, DEADLINE_DATE DATE, DECLARE_STATUS VARCHAR(50), LAST_NOTIFY_TIME DATE, DATA_REFLUX_TIME DATE, CREATE_BY VARCHAR(50), CREATE_TIME DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, UPDATE_BY VARCHAR(50), UPDATE_TIME DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, SYS_ORG_CODE VARCHAR(50), PRIMARY KEY (ID) ); COMMENT ON TABLE DA_FAMILY_SERVICE_INSURANCE_SUBSIDY IS '家政服务企业商业保险补贴（企业）'; COMMENT ON COLUMN DA_FAMILY_SERVICE_INSURANCE_SUBSIDY.ID IS '主键ID'; COMMENT ON COLUMN DA_FAMILY_SERVICE_INSURANCE_SUBSIDY.RECORD_ID IS '备案记录ID（省平台唯一标识，用于数据关联）'; COMMENT ON COLUMN DA_FAMILY_SERVICE_INSURANCE_SUBSIDY.UNIT_CREDIT_CODE IS '单位统一社会信用代码'; COMMENT ON COLUMN DA_FAMILY_SERVICE_INSURANCE_SUBSIDY.UNIT_NAME IS '单位名称'; COMMENT ON COLUMN DA_FAMILY_SERVICE_INSURANCE_SUBSIDY.DISTRICT IS '所属县区'; COMMENT ON COLUMN DA_FAMILY_SERVICE_INSURANCE_SUBSIDY.AREA_TYPE IS '区域类型（珠三角/粤东西北，以回流数据为准）'; COMMENT ON COLUMN DA_FAMILY_SERVICE_INSURANCE_SUBSIDY.HOUSEKEEPING_COUNT IS '家政服务人员数'; COMMENT ON COLUMN DA_FAMILY_SERVICE_INSURANCE_SUBSIDY.INSURED_COUNT IS '购买商业保险人数'; COMMENT ON COLUMN DA_FAMILY_SERVICE_INSURANCE_SUBSIDY.ANNUAL_PREMIUM IS '年度保费总额'; COMMENT ON COLUMN DA_FAMILY_SERVICE_INSURANCE_SUBSIDY.SUBSIDY_TOTAL IS '补贴核算总额'; COMMENT ON COLUMN DA_FAMILY_SERVICE_INSURANCE_SUBSIDY.SUBSIDY_YEARS IS '享受补贴年限'; COMMENT ON COLUMN DA_FAMILY_SERVICE_INSURANCE_SUBSIDY.CONTACT_PHONE IS '联系人手机'; COMMENT ON COLUMN DA_FAMILY_SERVICE_INSURANCE_SUBSIDY.FIRST_DECLARE_DATE IS '首次可申报日期'; COMMENT ON COLUMN DA_FAMILY_SERVICE_INSURANCE_SUBSIDY.DEADLINE_DATE IS '补贴期限截止日期'; COMMENT ON COLUMN DA_FAMILY_SERVICE_INSURANCE_SUBSIDY.DECLARE_STATUS IS '申报状态（未申报/已申报/待审核/已通过/已驳回）'; COMMENT ON COLUMN DA_FAMILY_SERVICE_INSURANCE_SUBSIDY.LAST_NOTIFY_TIME IS '最后通知时间（发送消息后自动记录时间）'; COMMENT ON COLUMN DA_FAMILY_SERVICE_INSURANCE_SUBSIDY.DATA_REFLUX_TIME IS '数据回流时间'; COMMENT ON COLUMN DA_FAMILY_SERVICE_INSURANCE_SUBSIDY.CREATE_BY IS '创建人'; COMMENT ON COLUMN DA_FAMILY_SERVICE_INSURANCE_SUBSIDY.CREATE_TIME IS '创建时间'; COMMENT ON COLUMN DA_FAMILY_SERVICE_INSURANCE_SUBSIDY.UPDATE_BY IS '修改人'; COMMENT ON COLUMN DA_FAMILY_SERVICE_INSURANCE_SUBSIDY.UPDATE_TIME IS '更新时间'; COMMENT ON COLUMN DA_FAMILY_SERVICE_INSURANCE_SUBSIDY.SYS_ORG_CODE IS '组织机构编号'; CREATE INDEX IDX_DA_FAMILY_SERVICE_INSURANCE_SUBSIDY_UNIT ON DA_FAMILY_SERVICE_INSURANCE_SUBSIDY(UNIT_CREDIT_CODE); CREATE INDEX IDX_DA_FAMILY_SERVICE_INSURANCE_SUBSIDY_STATUS ON DA_FAMILY_SERVICE_INSURANCE_SUBSIDY(DECLARE_STATUS); -- ============================================================ -- 3.6.21 职业介绍补贴（企业） -- 说明：省平台回流，记录符合职业介绍补贴条件的人力资源服务机构信息 -- ============================================================ CREATE TABLE DA_JOB_INTRODUCTION_SUBSIDY ( ID VARCHAR(36) NOT NULL, RECORD_ID VARCHAR(100), UNIT_CREDIT_CODE VARCHAR(50), UNIT_NAME VARCHAR(200), DISTRICT VARCHAR(50), AGENCY_RECORD_NO VARCHAR(100), COMPLIANT_REFERRAL_COUNT INTEGER, SINGLE_STANDARD NUMERIC(18,2), SUBSIDY_TOTAL NUMERIC(18,2), STABLE_EMPLOY_MONTHS INTEGER, CONTACT_PHONE VARCHAR(50), FIRST_DECLARE_DATE DATE, DEADLINE_DATE DATE, DECLARE_STATUS VARCHAR(50), LAST_NOTIFY_TIME DATE, DATA_REFLUX_TIME DATE, CREATE_BY VARCHAR(50), CREATE_TIME DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, UPDATE_BY VARCHAR(50), UPDATE_TIME DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, SYS_ORG_CODE VARCHAR(50), PRIMARY KEY (ID) ); COMMENT ON TABLE DA_JOB_INTRODUCTION_SUBSIDY IS '职业介绍补贴（企业）'; COMMENT ON COLUMN DA_JOB_INTRODUCTION_SUBSIDY.ID IS '主键ID'; COMMENT ON COLUMN DA_JOB_INTRODUCTION_SUBSIDY.RECORD_ID IS '备案记录ID（省平台唯一标识，用于数据关联）'; COMMENT ON COLUMN DA_JOB_INTRODUCTION_SUBSIDY.UNIT_CREDIT_CODE IS '单位统一社会信用代码'; COMMENT ON COLUMN DA_JOB_INTRODUCTION_SUBSIDY.UNIT_NAME IS '单位名称'; COMMENT ON COLUMN DA_JOB_INTRODUCTION_SUBSIDY.DISTRICT IS '所属县区'; COMMENT ON COLUMN DA_JOB_INTRODUCTION_SUBSIDY.AGENCY_RECORD_NO IS '中介备案编号'; COMMENT ON COLUMN DA_JOB_INTRODUCTION_SUBSIDY.COMPLIANT_REFERRAL_COUNT IS '成功合规介绍人数'; COMMENT ON COLUMN DA_JOB_INTRODUCTION_SUBSIDY.SINGLE_STANDARD IS '单人补贴核定标准'; COMMENT ON COLUMN DA_JOB_INTRODUCTION_SUBSIDY.SUBSIDY_TOTAL IS '本期补贴核算总额'; COMMENT ON COLUMN DA_JOB_INTRODUCTION_SUBSIDY.STABLE_EMPLOY_MONTHS IS '稳定就业达标月数'; COMMENT ON COLUMN DA_JOB_INTRODUCTION_SUBSIDY.CONTACT_PHONE IS '联系人手机'; COMMENT ON COLUMN DA_JOB_INTRODUCTION_SUBSIDY.FIRST_DECLARE_DATE IS '首次可申报日期'; COMMENT ON COLUMN DA_JOB_INTRODUCTION_SUBSIDY.DEADLINE_DATE IS '补贴期限截止日期'; COMMENT ON COLUMN DA_JOB_INTRODUCTION_SUBSIDY.DECLARE_STATUS IS '申报状态（未申报/已申报/待审核/已通过/已驳回）'; COMMENT ON COLUMN DA_JOB_INTRODUCTION_SUBSIDY.LAST_NOTIFY_TIME IS '最后通知时间（发送消息后自动记录时间）'; COMMENT ON COLUMN DA_JOB_INTRODUCTION_SUBSIDY.DATA_REFLUX_TIME IS '数据回流时间'; COMMENT ON COLUMN DA_JOB_INTRODUCTION_SUBSIDY.CREATE_BY IS '创建人'; COMMENT ON COLUMN DA_JOB_INTRODUCTION_SUBSIDY.CREATE_TIME IS '创建时间'; COMMENT ON COLUMN DA_JOB_INTRODUCTION_SUBSIDY.UPDATE_BY IS '修改人'; COMMENT ON COLUMN DA_JOB_INTRODUCTION_SUBSIDY.UPDATE_TIME IS '更新时间'; COMMENT ON COLUMN DA_JOB_INTRODUCTION_SUBSIDY.SYS_ORG_CODE IS '组织机构编号'; CREATE INDEX IDX_DA_JOB_INTRODUCTION_SUBSIDY_UNIT ON DA_JOB_INTRODUCTION_SUBSIDY(UNIT_CREDIT_CODE); CREATE INDEX IDX_DA_JOB_INTRODUCTION_SUBSIDY_STATUS ON DA_JOB_INTRODUCTION_SUBSIDY(DECLARE_STATUS); -- ============================================================ -- 公共消息表 -- 说明：记录系统各业务模块发送的消息通知，统一管理消息记录 -- ============================================================ CREATE TABLE DA_MESSAGE ( ID VARCHAR(36) NOT NULL, BIZ_MODULE_NAME VARCHAR(100), BIZ_ID VARCHAR(36), MSG_TITLE VARCHAR(200), MSG_CONTENT TEXT, SENDER VARCHAR(100), SEND_TIME DATETIME, CREATE_BY VARCHAR(50), CREATE_TIME DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, UPDATE_BY VARCHAR(50), UPDATE_TIME DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, SYS_ORG_CODE VARCHAR(50), PRIMARY KEY (ID) ); COMMENT ON TABLE DA_MESSAGE IS '公共消息表'; COMMENT ON COLUMN DA_MESSAGE.ID IS '主键ID'; COMMENT ON COLUMN DA_MESSAGE.BIZ_MODULE_NAME IS '所属业务模块名称'; COMMENT ON COLUMN DA_MESSAGE.BIZ_ID IS '关联业务ID'; COMMENT ON COLUMN DA_MESSAGE.MSG_TITLE IS '消息标题'; COMMENT ON COLUMN DA_MESSAGE.MSG_CONTENT IS '消息内容'; COMMENT ON COLUMN DA_MESSAGE.SENDER IS '发送人'; COMMENT ON COLUMN DA_MESSAGE.SEND_TIME IS '发送时间'; COMMENT ON COLUMN DA_MESSAGE.CREATE_BY IS '创建人'; COMMENT ON COLUMN DA_MESSAGE.CREATE_TIME IS '创建时间'; COMMENT ON COLUMN DA_MESSAGE.UPDATE_BY IS '修改人'; COMMENT ON COLUMN DA_MESSAGE.UPDATE_TIME IS '更新时间'; COMMENT ON COLUMN DA_MESSAGE.SYS_ORG_CODE IS '组织机构编号'; CREATE INDEX IDX_DA_MESSAGE_BIZ_MODULE ON DA_MESSAGE(BIZ_MODULE_NAME); CREATE INDEX IDX_DA_MESSAGE_BIZ_ID ON DA_MESSAGE(BIZ_ID); -- ============================================================ -- 消息模版表 -- 说明：存储消息通知的模板，用于统一消息内容的格式 -- ============================================================ CREATE TABLE DA_MESSAGE_TEMPLATE ( ID VARCHAR(36) NOT NULL, TEMPLATE_NAME VARCHAR(200), TEMPLATE_CONTENT TEXT, CREATE_BY VARCHAR(50), CREATE_TIME DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, UPDATE_BY VARCHAR(50), UPDATE_TIME DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, SYS_ORG_CODE VARCHAR(50), PRIMARY KEY (ID) ); COMMENT ON TABLE DA_MESSAGE_TEMPLATE IS '消息模版表'; COMMENT ON COLUMN DA_MESSAGE_TEMPLATE.ID IS '主键ID'; COMMENT ON COLUMN DA_MESSAGE_TEMPLATE.TEMPLATE_NAME IS '模板名称'; COMMENT ON COLUMN DA_MESSAGE_TEMPLATE.TEMPLATE_CONTENT IS '模板内容'; COMMENT ON COLUMN DA_MESSAGE_TEMPLATE.CREATE_BY IS '创建人'; COMMENT ON COLUMN DA_MESSAGE_TEMPLATE.CREATE_TIME IS '创建时间'; COMMENT ON COLUMN DA_MESSAGE_TEMPLATE.UPDATE_BY IS '修改人'; COMMENT ON COLUMN DA_MESSAGE_TEMPLATE.UPDATE_TIME IS '更新时间'; COMMENT ON COLUMN DA_MESSAGE_TEMPLATE.SYS_ORG_CODE IS '组织机构编号';