59 lines
2.0 KiB
MySQL
59 lines
2.0 KiB
MySQL
|
SET ANSI_NULLS ON
|
||
|
|
GO
|
||
|
|
|
||
|
|
SET QUOTED_IDENTIFIER ON
|
||
|
|
GO
|
||
|
|
|
||
|
|
SET ANSI_PADDING ON
|
||
|
|
GO
|
||
|
|
|
||
|
|
CREATE TABLE [hrsa_salary_acct_result_report](
|
||
|
|
[id] [bigint] NOT NULL,
|
||
|
|
[salary_sob_id] [bigint] NOT NULL,
|
||
|
|
[salary_acct_emp_id] [varchar](200) NULL,
|
||
|
|
[salary_acct_record_id] [bigint] NOT NULL,
|
||
|
|
[employee_id] [varchar](200) NULL,
|
||
|
|
[tax_agent_id] [bigint] NOT NULL,
|
||
|
|
[salary_item_id] [bigint] NOT NULL,
|
||
|
|
[result_value] [varchar](1000) NOT NULL,
|
||
|
|
[creator] [bigint] NOT NULL,
|
||
|
|
[create_time] [datetime] NOT NULL,
|
||
|
|
[update_time] [datetime] NOT NULL,
|
||
|
|
[delete_type] [int] NOT NULL,
|
||
|
|
[tenant_key] [varchar](10) NOT NULL,
|
||
|
|
[department_id] [bigint] NULL,
|
||
|
|
[subcompany_id] [bigint] NULL,
|
||
|
|
[costcenter_id] [bigint] NULL,
|
||
|
|
[jobtitle_id] [bigint] NULL,
|
||
|
|
[location_id] [bigint] NULL,
|
||
|
|
CONSTRAINT [PK_hrsa_salary_acct_result_report] PRIMARY KEY CLUSTERED
|
||
|
|
(
|
||
|
|
[id] ASC
|
||
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
||
|
|
) ON [PRIMARY]
|
||
|
|
|
||
|
|
GO
|
||
|
|
|
||
|
|
SET ANSI_PADDING OFF
|
||
|
|
GO
|
||
|
|
|
||
|
|
ALTER TABLE [hrsa_salary_acct_result_report] ADD CONSTRAINT [DF_hrsa_salary_acct_result_report_salary_acct_emp_id] DEFAULT ((0)) FOR [salary_acct_emp_id]
|
||
|
|
GO
|
||
|
|
|
||
|
|
ALTER TABLE [hrsa_salary_acct_result_report] ADD CONSTRAINT [DF_hrsa_salary_acct_result_report_employee_id] DEFAULT ((0)) FOR [employee_id]
|
||
|
|
GO
|
||
|
|
|
||
|
|
ALTER TABLE [hrsa_salary_acct_result_report] ADD CONSTRAINT [DF__hrsa_sala__resul__2DAA0852] DEFAULT ('') FOR [result_value]
|
||
|
|
GO
|
||
|
|
|
||
|
|
ALTER TABLE [hrsa_salary_acct_result_report] ADD CONSTRAINT [DF__hrsa_sala__creat__2E9E2C8B] DEFAULT (getdate()) FOR [create_time]
|
||
|
|
GO
|
||
|
|
|
||
|
|
ALTER TABLE [hrsa_salary_acct_result_report] ADD CONSTRAINT [DF__hrsa_sala__updat__2F9250C4] DEFAULT (getdate()) FOR [update_time]
|
||
|
|
GO
|
||
|
|
|
||
|
|
ALTER TABLE [hrsa_salary_acct_result_report] ADD CONSTRAINT [DF__hrsa_sala__delet__308674FD] DEFAULT ('0') FOR [delete_type]
|
||
|
|
GO
|
||
|
|
|
||
|
|
ALTER TABLE [hrsa_salary_acct_result_report] ADD CONSTRAINT [DF__hrsa_sala__tenan__317A9936] DEFAULT ('') FOR [tenant_key]
|
||
|
|
GO
|