表

CREATE TABLE [dbo].[tbl_report_record](
    [id] [int] IDENTITY(1,1) NOT NULL,
    [report_id] [varchar](50) NULL,
    [report_time] [varchar](100) NULL,
    [status] [int] NULL,
    [create_time] [date] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[tbl_report_record] ADD  CONSTRAINT [DF_tbl_report_record_create_time]  DEFAULT (getdate()) FOR [create_time]
GO
CREATE NONCLUSTERED INDEX [tbl_report_record_id] ON [dbo].[tbl_report_record]
(
    [report_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO