1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
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
|
|
