From c149c7b54b754538709117bd0f9349e8acabfd92 Mon Sep 17 00:00:00 2001 From: qwj <qwjzorro@163.com> Date: 星期一, 28 八月 2023 09:27:30 +0800 Subject: [PATCH] 资料管理数据库sql --- docSQL.sql | 108 ++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 108 insertions(+), 0 deletions(-) diff --git a/docSQL.sql b/docSQL.sql new file mode 100644 index 0000000..cec0549 --- /dev/null +++ b/docSQL.sql @@ -0,0 +1,108 @@ + +/****** 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 -- Gitblit v1.9.1