INSERT INTO hrsa_tax_report_column(id, create_time, update_time, creator, delete_type, tenant_key, tax_report_type, income_category, report_column_name, report_column_data_index, data_type, request_param_key, report_column_label, contrast_type) VALUES (700000000000000001, NULL, NULL, NULL, 0, 'all_teams', '1', '700', '当期收入额', 'royaltiesIncome', 'number', 'sre', NULL, 0);
INSERT INTO hrsa_tax_report_column(id, create_time, update_time, creator, delete_type, tenant_key, tax_report_type, income_category, report_column_name, report_column_data_index, data_type, request_param_key, report_column_label, contrast_type) VALUES (700000000000000002, NULL, NULL, NULL, 0, 'all_teams', '1', '700', '免税收入', 'royaltiesTaxFreeIncome', 'number', 'mssd', NULL, 0);
INSERT INTO hrsa_tax_report_column(id, create_time, update_time, creator, delete_type, tenant_key, tax_report_type, income_category, report_column_name, report_column_data_index, data_type, request_param_key, report_column_label, contrast_type) VALUES (700000000000000003, NULL, NULL, NULL, 0, 'all_teams', '1', '700', '其他', 'royaltiesOther', 'number', 'qt', NULL, 0);
INSERT INTO hrsa_tax_report_column(id, create_time, update_time, creator, delete_type, tenant_key, tax_report_type, income_category, report_column_name, report_column_data_index, data_type, request_param_key, report_column_label, contrast_type) VALUES (700000000000000004, NULL, NULL, NULL, 0, 'all_teams', '1', '700', '备注', 'royaltiesRemark', 'string', 'bz', NULL, 0);
INSERT INTO hrsa_tax_report_column(id, create_time, update_time, creator, delete_type, tenant_key, tax_report_type, income_category, report_column_name, report_column_data_index, data_type, request_param_key, report_column_label, contrast_type) VALUES (700000000000000005, NULL, NULL, NULL, 0, 'all_teams', '1', '700', '减免税额', 'royaltiesTaxDeduction', 'number', 'jmse', NULL, 0);


CREATE TABLE hrsa_api_task_record  (
  id bigint(0) NOT NULL ,
  source varchar(500) ,
  api varchar(500),
  param text ,
  response text,
  tenant_key varchar(255) ,
  delete_type int(0) ,
  create_time datetime(0),
  update_time datetime(0),
  PRIMARY KEY (id) USING BTREE
);

create table hrsa_api_task_record
(
  id number primary key ,
  source varchar2(500) ,
  api varchar2(500),
  param clob ,
  response clob,
  create_time date,
  update_time date,
  delete_type int default 0,
  tenant_key varchar2(10)
)
/

create table hrsa_api_task_record
(
  id bigint primary key ,
  source varchar(500) ,
  api varchar(500),
  param ntext ,
  response ntext,
  create_time datetime,
  update_time datetime,
  delete_type int default 0,
  tenant_key nvarchar(10)
)
GO

create table hrsa_api_task_record
(
  id bigint primary key ,
  source varchar(500) ,
  api varchar(500),
  param text ,
  response text,
  create_time timestamp,
  update_time timestamp,
  delete_type int default 0,
  tenant_key varchar(10)
);
/