/*
 Navicat Premium Data Transfer

 Source Server         : 190
 Source Server Type    : SQL Server
 Source Server Version : 13001601
 Source Host           : 192.168.1.190:1433
 Source Catalog        : HealthOne
 Source Schema         : dbo

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

 Date: 25/05/2022 14:21:45
*/


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

CREATE TABLE [dbo].[Mobile_Work] (
  [M_WORK01] int  IDENTITY(1,1) NOT NULL,
  [M_WORK02] varchar(100) COLLATE Chinese_PRC_CI_AS DEFAULT '' NULL,
  [VAA01] int DEFAULT ((0)) NOT NULL,
  [VAE01] int DEFAULT ((0)) NOT NULL,
  [BCE01] int DEFAULT ((0)) NOT NULL,
  [BCK01A] int DEFAULT ((0)) NOT NULL,
  [ParentID] int DEFAULT ((0)) NOT NULL,
  [M_PRO01] int DEFAULT ((0)) NOT NULL,
  [VAP01] int DEFAULT ((0)) NULL,
  [M_WORK10] datetime  NOT NULL,
  [VBI21] varchar(20) COLLATE Chinese_PRC_CI_AS DEFAULT '' NULL,
  [M_WORK12] varchar(20) COLLATE Chinese_PRC_CI_AS DEFAULT '' NULL,
  [M_WORK13] varchar(20) COLLATE Chinese_PRC_CI_AS DEFAULT '' NULL,
  [M_WORK14] varchar(20) COLLATE Chinese_PRC_CI_AS DEFAULT '' NULL,
  [M_WORK15] varchar(20) COLLATE Chinese_PRC_CI_AS DEFAULT '' NULL,
  [M_WORK16] varchar(20) COLLATE Chinese_PRC_CI_AS DEFAULT '' NULL,
  [M_WORK17] varchar(20) COLLATE Chinese_PRC_CI_AS DEFAULT '' NULL,
  [M_WORK18] varchar(100) COLLATE Chinese_PRC_CI_AS DEFAULT '' NULL,
  [M_WORK19] varchar(512) COLLATE Chinese_PRC_CI_AS DEFAULT '' NULL,
  [BCK01B] int DEFAULT ((0)) NULL,
  [BCK03] varchar(50) COLLATE Chinese_PRC_CI_AS DEFAULT '' NULL,
  [BCQ04] varchar(50) COLLATE Chinese_PRC_CI_AS DEFAULT '' NULL,
  [M_WORK23] int DEFAULT ((0)) NULL,
  [M_WORK24] int DEFAULT ((0)) NULL,
  [M_WORK25] varchar(100) COLLATE Chinese_PRC_CI_AS DEFAULT '' NULL,
  [M_WORK26] varchar(100) COLLATE Chinese_PRC_CI_AS DEFAULT '' NULL,
  [M_WORK27] int DEFAULT ((0)) NULL,
  [M_WORK28] int DEFAULT ((0)) NULL,
  [M_WORK29] varchar(100) COLLATE Chinese_PRC_CI_AS DEFAULT '' NULL,
  [M_WORK30] varchar(20) COLLATE Chinese_PRC_CI_AS DEFAULT '' NULL
)
GO

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


-- ----------------------------
-- Auto increment value for Mobile_Work
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[Mobile_Work]', RESEED, 1085)
GO


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

