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
109
110
111
112
113
114
115
116
117
| USE [zhengcaioa];
| GO
| SET ANSI_NULLS ON;
| GO
| SET QUOTED_IDENTIFIER ON;
| GO
| CREATE TABLE [dbo].[ExpertOrderDispatch] (
| [id] varchar(50) NOT NULL,
| [orderid] varchar(50) NOT NULL,
| [ExpertId] varchar(50) NOT NULL,
| [Money] decimal(18, 2) NULL,
| [rec_status] nvarchar(1) NOT NULL,
| [creater] nvarchar(50) NOT NULL,
| [createtime] datetime NOT NULL,
| [modifier] nvarchar(50) NOT NULL,
| [sort] varchar(50) NULL,
| [modifytime] datetime NOT NULL)
| ON [PRIMARY]
| WITH (DATA_COMPRESSION = NONE);
| GO
| ALTER TABLE [dbo].[ExpertOrderDispatch] SET (LOCK_ESCALATION = TABLE);
| GO
|
|
| CREATE TABLE [dbo].[expertPromote] (
| [id] varchar(50) NOT NULL,
| [expertId] varchar(50) NULL,
| [SN] varchar(50) NULL,
| [content] varchar(800) NULL,
| [PromoteDate] date NULL,
| [sort] varchar(50) NULL,
| [rec_status] nvarchar(1) NOT NULL,
| [creater] nvarchar(50) NOT NULL,
| [createtime] datetime NOT NULL,
| [modifier] nvarchar(50) NOT NULL,
| [modifytime] datetime NOT NULL)
| ON [PRIMARY]
| WITH (DATA_COMPRESSION = NONE);
| GO
| ALTER TABLE [dbo].[expertPromote] SET (LOCK_ESCALATION = TABLE);
| GO
|
|
| GO
| CREATE TABLE [dbo].[experts] (
| [name] nvarchar(64) NOT NULL,
| [id] nvarchar(50) NOT NULL,
| [sex] nvarchar(50) NOT NULL,
| [idCard] nvarchar(18) NOT NULL,
| [InfoSource] nvarchar(18) NOT NULL,
| [expertType] nvarchar(50) NOT NULL,
| [level] nvarchar(50) NULL,
| [ReviewItem] nvarchar(50) NULL,
| [CertiNumber] nvarchar(20) NULL,
| [Province] varchar(50) NULL,
| [City] varchar(50) NULL,
| [AreaId] varchar(50) NULL,
| [address] nvarchar(200) NULL,
| [phone1] nvarchar(15) NULL,
| [phone2] nvarchar(15) NULL,
| [QQ] nvarchar(12) NULL,
| [wechat] nvarchar(20) NULL,
| [CertiFont] nvarchar(200) NULL,
| [certiBack] nvarchar(200) NULL,
| [TitileCerti] nvarchar(200) NULL,
| [remark] nvarchar(1000) NULL,
| [rec_status] nvarchar(1) NOT NULL,
| [creater] nvarchar(50) NOT NULL,
| [createtime] datetime NOT NULL,
| [modifier] nvarchar(50) NOT NULL,
| [modifytime] datetime NOT NULL,
| [sort] varchar(50) NULL,
| [postal] varchar(50) NULL)
| ON [PRIMARY]
| WITH (DATA_COMPRESSION = NONE);
| GO
| ALTER TABLE [dbo].[experts] SET (LOCK_ESCALATION = TABLE);
| GO
|
| insert into [dbo].[sys_code]([Id],[code_table],[code_field],[comments],[rec_status],[creater],[createtime],[modifier],[modifytime]) values ('0de5255f-c5cc-4004-bfb1-b0f79992a822','experts','expertType','专家类型','A','e4c93811-b9b1-4998-89f5-c416ebab0c07','2021-03-03 14:44:20','e4c93811-b9b1-4998-89f5-c416ebab0c07','2021-03-03 14:44:20')
| insert into [dbo].[sys_code]([Id],[code_table],[code_field],[comments],[rec_status],[creater],[createtime],[modifier],[modifytime]) values ('9c25041d-125b-4bc1-9832-7f032289a867','experts','level','专家等级','A','e4c93811-b9b1-4998-89f5-c416ebab0c07','2021-03-03 14:46:52','e4c93811-b9b1-4998-89f5-c416ebab0c07','2021-03-03 14:46:52')
|
| GO
|
|
| insert into [dbo].[plt_page]([Id],[system_id],[page_name],[page_shortcut],[display_seq],[page_path],[page_method],[page_type],[page_superior],[page_ico],[open_type],[rec_status],[creater],[createtime],[modifier],[modifytime]) values ('07fed12a-5b4a-4028-b149-8b793f90ed39','1','新增专家',null,1,'/Expert/Edit/','01','M','dc2e85a8-7732-4758-a1b6-8b98e08cdc7c',null,0,'A','e4c93811-b9b1-4998-89f5-c416ebab0c07','2021-03-03 09:43:00','e4c93811-b9b1-4998-89f5-c416ebab0c07','2021-03-03 09:54:41')
| insert into [dbo].[plt_page]([Id],[system_id],[page_name],[page_shortcut],[display_seq],[page_path],[page_method],[page_type],[page_superior],[page_ico],[open_type],[rec_status],[creater],[createtime],[modifier],[modifytime]) values ('46d3158d-59ea-443e-89be-3acb000670b6','1','专家派单',null,3,'/Expert/ExpertOrderDispatch','01','M','dc2e85a8-7732-4758-a1b6-8b98e08cdc7c',null,0,'A','e4c93811-b9b1-4998-89f5-c416ebab0c07','2021-03-08 16:10:26','e4c93811-b9b1-4998-89f5-c416ebab0c07','2021-03-08 16:55:39')
| insert into [dbo].[plt_page]([Id],[system_id],[page_name],[page_shortcut],[display_seq],[page_path],[page_method],[page_type],[page_superior],[page_ico],[open_type],[rec_status],[creater],[createtime],[modifier],[modifytime]) values ('9518f2a5-4142-4659-abe6-ceeab301e319','1','专家管理',null,2,'/Expert/index/','01','M','dc2e85a8-7732-4758-a1b6-8b98e08cdc7c',null,0,'A','e4c93811-b9b1-4998-89f5-c416ebab0c07','2021-03-03 09:44:23','e4c93811-b9b1-4998-89f5-c416ebab0c07','2021-03-03 09:54:54')
| insert into [dbo].[plt_page]([Id],[system_id],[page_name],[page_shortcut],[display_seq],[page_path],[page_method],[page_type],[page_superior],[page_ico],[open_type],[rec_status],[creater],[createtime],[modifier],[modifytime]) values ('dc2e85a8-7732-4758-a1b6-8b98e08cdc7c','1','专家管理',null,5,null,'01','M','0','fa fa-user',0,'A','e4c93811-b9b1-4998-89f5-c416ebab0c07','2021-03-03 09:39:16','e4c93811-b9b1-4998-89f5-c416ebab0c07','2021-03-08 16:06:16')
|
| GO
|
|
| insert into [dbo].[sys_code_dtl]([Id],[role_id],[code_sn],[code_id],[comments],[contents],[sort],[classify1],[classify2],[classify3],[rec_status],[creater],[createtime],[modifier],[modifytime]) values ('20cd05d9-17b6-4038-aac3-436f42cf84af','','1','9c25041d-125b-4bc1-9832-7f032289a867','一般专家','',1,null,null,null,'A','e4c93811-b9b1-4998-89f5-c416ebab0c07','2021-03-03 14:46:52','e4c93811-b9b1-4998-89f5-c416ebab0c07','2021-03-03 14:46:52')
| insert into [dbo].[sys_code_dtl]([Id],[role_id],[code_sn],[code_id],[comments],[contents],[sort],[classify1],[classify2],[classify3],[rec_status],[creater],[createtime],[modifier],[modifytime]) values ('6b82051b-27a8-4adc-a5bb-a2e7c3a947d5','','2','9c25041d-125b-4bc1-9832-7f032289a867','活跃专家','',2,null,null,null,'A','e4c93811-b9b1-4998-89f5-c416ebab0c07','2021-03-03 14:46:52','e4c93811-b9b1-4998-89f5-c416ebab0c07','2021-03-03 14:46:52')
| insert into [dbo].[sys_code_dtl]([Id],[role_id],[code_sn],[code_id],[comments],[contents],[sort],[classify1],[classify2],[classify3],[rec_status],[creater],[createtime],[modifier],[modifytime]) values ('ab7f3249-0ea4-4a8b-9e31-817d360c8d4d','','3','9c25041d-125b-4bc1-9832-7f032289a867','资深专家','',3,null,null,null,'A','e4c93811-b9b1-4998-89f5-c416ebab0c07','2021-03-03 14:46:52','e4c93811-b9b1-4998-89f5-c416ebab0c07','2021-03-03 14:46:52')
|
|
| insert into [dbo].[sys_code_dtl]([Id],[role_id],[code_sn],[code_id],[comments],[contents],[sort],[classify1],[classify2],[classify3],[rec_status],[creater],[createtime],[modifier],[modifytime]) values ('316feb53-c577-4aaa-b5e9-edd9a4106219','','3','0de5255f-c5cc-4004-bfb1-b0f79992a822','离职专家','',3,null,null,null,'A','e4c93811-b9b1-4998-89f5-c416ebab0c07','2021-03-03 14:44:20','e4c93811-b9b1-4998-89f5-c416ebab0c07','2021-03-03 14:44:20')
| insert into [dbo].[sys_code_dtl]([Id],[role_id],[code_sn],[code_id],[comments],[contents],[sort],[classify1],[classify2],[classify3],[rec_status],[creater],[createtime],[modifier],[modifytime]) values ('33e7913d-1bcb-4a83-8321-2a7fa9a45fe4','','2','0de5255f-c5cc-4004-bfb1-b0f79992a822','专职专家','',2,null,null,null,'A','e4c93811-b9b1-4998-89f5-c416ebab0c07','2021-03-03 14:44:20','e4c93811-b9b1-4998-89f5-c416ebab0c07','2021-03-03 14:44:20')
| insert into [dbo].[sys_code_dtl]([Id],[role_id],[code_sn],[code_id],[comments],[contents],[sort],[classify1],[classify2],[classify3],[rec_status],[creater],[createtime],[modifier],[modifytime]) values ('5268502e-92ac-4f03-8e6c-f3e402346ed6','','1','0de5255f-c5cc-4004-bfb1-b0f79992a822','兼职专家','',1,null,null,null,'A','e4c93811-b9b1-4998-89f5-c416ebab0c07','2021-03-03 14:44:20','e4c93811-b9b1-4998-89f5-c416ebab0c07','2021-03-03 14:44:20')
|
| GO
|
|
| SELECT TOP (1000) [Id]
| ,[subjecttype]
| ,[subjectname]
| ,[remark]
| ,[rec_status]
| ,[creater]
| ,[createtime]
| ,[modifier]
| ,[modifytime]
| ,[qiyong_status]
| FROM [zhengcaioa].[dbo].[fi_subject]
| GO
|
|
