/****** Object:  Table [dbo].[t_doc_classification]    Script Date: 2023-08-08 11:35:47 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[t_doc_classification](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[doc_classification_code] [nvarchar](10) NULL,
	[doc_classification] [nvarchar](30) NULL,
	[parent_code] [nvarchar](10) NULL,
	[is_system] [bit] NULL,
	[tenant_code] [int] NULL,
	[status] [int] NULL,
	[sort_id] [int] NULL,
	[add_time] [datetime] NULL,
 CONSTRAINT [PK_t_doc_classification] 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 IDENTITY_INSERT [dbo].[t_doc_classification] ON 
GO
INSERT [dbo].[t_doc_classification] ([id], [doc_classification_code], [doc_classification], [parent_code], [is_system], [tenant_code], [status], [sort_id], [add_time]) VALUES (1, N'001', N'×ÊÖÊÀà±ð', N'00', 1, NULL, 1, 1, CAST(N'2023-08-01T16:21:39.003' AS DateTime))
INSERT [dbo].[t_doc_classification] ([id], [doc_classification_code], [doc_classification], [parent_code], [is_system], [tenant_code], [status], [sort_id], [add_time]) VALUES (2, N'002', N'Òµ¼¨Àà±ð', N'00', 1, NULL, 1, 2, CAST(N'2023-08-02T16:22:39.003' AS DateTime))
INSERT [dbo].[t_doc_classification] ([id], [doc_classification_code], [doc_classification], [parent_code], [is_system], [tenant_code], [status], [sort_id], [add_time]) VALUES (3, N'003', N'·½°¸Àà±ð', N'00', 1, NULL, 1, 3, CAST(N'2023-08-03T16:23:39.003' AS DateTime))
INSERT [dbo].[t_doc_classification] ([id], [doc_classification_code], [doc_classification], [parent_code], [is_system], [tenant_code], [status], [sort_id], [add_time]) VALUES (4, N'004', N'²ÆÎñÀà±ð', N'00', 1, NULL, 1, 4, CAST(N'2023-08-04T16:24:39.003' AS DateTime))
INSERT [dbo].[t_doc_classification] ([id], [doc_classification_code], [doc_classification], [parent_code], [is_system], [tenant_code], [status], [sort_id], [add_time]) VALUES (5, N'005', N'¼¼ÊõÀà±ð', N'00', 1, NULL, 1, 5, CAST(N'2023-08-05T16:25:39.003' AS DateTime))
INSERT [dbo].[t_doc_classification] ([id], [doc_classification_code], [doc_classification], [parent_code], [is_system], [tenant_code], [status], [sort_id], [add_time]) VALUES (6, N'006', N'É豸×ÊÁÏ', N'00', 1, NULL, 1, 6, CAST(N'2023-08-06T16:25:39.003' AS DateTime))
INSERT [dbo].[t_doc_classification] ([id], [doc_classification_code], [doc_classification], [parent_code], [is_system], [tenant_code], [status], [sort_id], [add_time]) VALUES (7, N'007', N'Öʼ챨¸æ', N'00', 1, NULL, 1, 7, CAST(N'2023-08-07T16:25:39.003' AS DateTime))
INSERT [dbo].[t_doc_classification] ([id], [doc_classification_code], [doc_classification], [parent_code], [is_system], [tenant_code], [status], [sort_id], [add_time]) VALUES (8, N'008', N'ÖƶÈÁ÷³Ì', N'00', 1, NULL, 1, 8, CAST(N'2023-08-08T16:25:39.003' AS DateTime))
SET IDENTITY_INSERT [dbo].[t_doc_classification] OFF
GO


/****** Object:  Table [dbo].[t_project_file]    Script Date: 2023-08-09 14:21:20 ******/
CREATE TABLE [dbo].[t_document](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[doc_code] [nvarchar](10) NOT NULL,
	[classification_id] [int] NULL,
	[doc_name] [nvarchar](50) NOT NULL,
	[org_id] [int] NULL,
	[project_id] [int] NULL,
	[status] [int] NOT NULL,
	[add_time] [datetime] NOT NULL,
	[tenant_code] [int] NULL,
	[is_del] [bit] NULL,
 CONSTRAINT [PK_t_doc_credential] 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


CREATE TABLE [dbo].[t_doc_file](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[fileoldname] [nvarchar](50) NULL,
	[filenewname] [nvarchar](50) NULL,
	[fileservername] [nvarchar](50) NULL,
	[filesize] [int] NULL,
	[suffix] [nvarchar](10) NULL,
	[uptime] [datetime] NULL,
	[doc_id] [int] NULL,
	[status] [int] NULL,
	[filetype] [nvarchar](10) NULL,
	[up_userid] [int] NULL,
	[up_username] [nvarchar](40) NULL,
	[filepath] [nvarchar](150) NULL,
	[sort] [int] NULL,
 CONSTRAINT [PK_t_project_file] 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


/****** Object:  Table [dbo].[t_doc_achievement]    Script Date: 2023-08-25 16:10:21 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[t_doc_achievement](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[classification_id] [int] NULL,
	[project_id] [int] NULL,
	[achievement_name] [nvarchar](50) NULL,
	[zbtzs_url] [nvarchar](100) NULL,
	[ht_url] [nvarchar](100) NULL,
	[ysbg_url] [nvarchar](100) NULL,
	[fkpz_url] [nvarchar](100) NULL,
	[yhpj_url] [nvarchar](100) NULL,
	[hjzs_url] [nvarchar](100) NULL,
	[tenant_code] [int] NULL,
	[add_time] [datetime] NULL,
	[status] [int] NULL,
 CONSTRAINT [PK_t_doc_achievement] 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