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