远程数据共享

/*
Navicat Premium Data Transfer

Source Server : 192.168.10.178
Source Server Type : SQL Server
Source Server Version : 13001601
Source Host : 192.168.10.178:1433
Source Catalog : szgthbp
Source Schema : dbo

Target Server Type : SQL Server
Target Server Version : 13001601
File Encoding : 65001

Date: 16/06/2022 17:10:02
*/

-- ----------------------------
-- Table structure for t_jscyj
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[t_jscyj]') AND type IN ('U'))
DROP TABLE [dbo].[t_jscyj]
GO

CREATE TABLE [dbo].[t_jscyj] (
[id_] varchar(64) COLLATE Chinese_PRC_CI_AS NOT NULL,
[ip_] varchar(15) COLLATE Chinese_PRC_CI_AS NULL,
[create_by_] varchar(64) COLLATE Chinese_PRC_CI_AS NULL,
[create_time_] datetime NULL,
[update_by_] varchar(64) COLLATE Chinese_PRC_CI_AS NULL,
[update_time_] datetime NULL,
[number_] varchar(64) COLLATE Chinese_PRC_CI_AS NULL,
[informant_] varchar(255) COLLATE Chinese_PRC_CI_AS NULL,
[fill_in_time_] datetime NULL,
[fill_in_comments] varchar(255) COLLATE Chinese_PRC_CI_AS NULL,
[organize_] varchar(255) COLLATE Chinese_PRC_CI_AS NULL,
[remark] text COLLATE Chinese_PRC_CI_AS DEFAULT NULL NULL,
[enclosure] text COLLATE Chinese_PRC_CI_AS DEFAULT NULL NULL
)
GO

ALTER TABLE [dbo].[t_jscyj] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'主键',
'SCHEMA', N'dbo',
'TABLE', N't_jscyj',
'COLUMN', N'id_'
GO

EXEC sp_addextendedproperty
'MS_Description', N'IP地址',
'SCHEMA', N'dbo',
'TABLE', N't_jscyj',
'COLUMN', N'ip_'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建人',
'SCHEMA', N'dbo',
'TABLE', N't_jscyj',
'COLUMN', N'create_by_'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建时间',
'SCHEMA', N'dbo',
'TABLE', N't_jscyj',
'COLUMN', N'create_time_'
GO

EXEC sp_addextendedproperty
'MS_Description', N'更新人',
'SCHEMA', N'dbo',
'TABLE', N't_jscyj',
'COLUMN', N'update_by_'
GO

EXEC sp_addextendedproperty
'MS_Description', N'更新时间',
'SCHEMA', N'dbo',
'TABLE', N't_jscyj',
'COLUMN', N'update_time_'
GO

EXEC sp_addextendedproperty
'MS_Description', N'工单编号',
'SCHEMA', N'dbo',
'TABLE', N't_jscyj',
'COLUMN', N'number_'
GO

EXEC sp_addextendedproperty
'MS_Description', N'填报人',
'SCHEMA', N'dbo',
'TABLE', N't_jscyj',
'COLUMN', N'informant_'
GO

EXEC sp_addextendedproperty
'MS_Description', N'填报时间',
'SCHEMA', N'dbo',
'TABLE', N't_jscyj',
'COLUMN', N'fill_in_time_'
GO

EXEC sp_addextendedproperty
'MS_Description', N'填报意见',
'SCHEMA', N'dbo',
'TABLE', N't_jscyj',
'COLUMN', N'fill_in_comments'
GO

EXEC sp_addextendedproperty
'MS_Description', N'当前组织',
'SCHEMA', N'dbo',
'TABLE', N't_jscyj',
'COLUMN', N'organize_'
GO

EXEC sp_addextendedproperty
'MS_Description', N'备注',
'SCHEMA', N'dbo',
'TABLE', N't_jscyj',
'COLUMN', N'remark'
GO

EXEC sp_addextendedproperty
'MS_Description', N'附件',
'SCHEMA', N'dbo',
'TABLE', N't_jscyj',
'COLUMN', N'enclosure'
GO

-- ----------------------------
-- Primary Key structure for table t_jscyj
-- ----------------------------
ALTER TABLE [dbo].[t_jscyj] ADD CONSTRAINT [PK__t_jscyj__DC501A1197266A98] PRIMARY KEY CLUSTERED ([id_])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
ON [PRIMARY]
GO