ÿþUSE [came]

GO

/****** Object:  Table [dbo].[AccountContent202401]    Script Date: 2025/4/26 17:45:53 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[AccountContent202401](

	[R 0] [varchar](1000) NULL,

	[R 1] [varchar](1000) NULL,

	[R 2] [varchar](1000) NULL,

	[R 3] [varchar](1000) NULL,

	[R 4] [varchar](1000) NULL,

	[R 5] [varchar](1000) NULL

) ON [PRIMARY]



GO

SET ANSI_PADDING OFF

GO

/****** Object:  Table [dbo].[API_Json]    Script Date: 2025/4/26 17:45:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[API_Json](

	[id] [int] IDENTITY(1,1) NOT NULL,

	[method] [nvarchar](500) NULL,

	[Json] [nvarchar](max) NULL,

	[Json_time] [datetime] NULL,

	[is_Json] [int] NULL,

	[is_Json_time] [datetime] NULL,

	[reserve] [nvarchar](200) NULL,

 CONSTRAINT [PK_API_Json] 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] TEXTIMAGE_ON [PRIMARY]



GO

/****** Object:  Table [dbo].[CallRecord]    Script Date: 2025/4/26 17:45:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[CallRecord](

	[CallRecordID] [int] IDENTITY(1,1) NOT NULL,

	[CallRecord_Phine] [nvarchar](20) NULL,

	[CallRecord_OAUserID] [int] NULL,

	[CallRecord_StartTime] [datetime] NULL,

	[CallRecord_EndTime] [datetime] NULL,

	[CallRecord_Type] [int] NULL,

	[CallRecord_OrdClass] [nvarchar](4) NULL,

	[CallRecord_OrdID] [int] NULL,

	[CallRecord_Record] [nvarchar](500) NULL,

	[CallRecord_Source] [int] NULL,

	[CallRecord_InAndOut] [int] NULL,

 CONSTRAINT [PK_CallRecord] PRIMARY KEY CLUSTERED 

(

	[CallRecordID] 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].[CarData]    Script Date: 2025/4/26 17:45:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[CarData](

	[CarID] [int] IDENTITY(1,1) NOT NULL,

	[CarLicense] [nvarchar](50) NULL,

	[CarVIN] [nvarchar](50) NULL,

	[CarModels] [nvarchar](50) NULL,

	[CarState] [int] NULL,

	[GPS_IMEI] [nvarchar](50) NULL,

	[Video_ID] [nvarchar](50) NULL,

	[CarOrdClass] [nvarchar](50) NULL,

	[CarTop] [int] NULL,

	[CarStateTXT] [nvarchar](100) NULL,

 CONSTRAINT [PK_CarData] PRIMARY KEY CLUSTERED 

(

	[CarID] 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].[CarGas]    Script Date: 2025/4/26 17:45:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[CarGas](

	[id] [int] IDENTITY(1,1) NOT NULL,

	[GasCarID] [int] NULL,

	[GasDate] [datetime] NULL,

	[GasMileage] [nvarchar](20) NULL,

	[GasVolume] [money] NULL,

	[GasPrice] [money] NULL,

	[GasMacSumPrice] [money] NULL,

	[GasSumPrice] [money] NULL,

	[GasType] [nvarchar](20) NULL,

	[GasStation] [nvarchar](50) NULL,

	[GasPayment] [nvarchar](50) NULL,

	[GasRemarks] [nvarchar](100) NULL,

	[OAID] [int] NULL,

	[OATime] [datetime] NULL,

	[GasState] [int] NULL,

	[is_JumpGun] [int] NULL,

 CONSTRAINT [PK_CarGas] 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].[CarGPS]    Script Date: 2025/4/26 17:45:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[CarGPS](

	[id] [int] IDENTITY(1,1) NOT NULL,

	[imei] [nvarchar](50) NULL,

	[device_info] [int] NULL,

	[device_info_new] [int] NULL,

	[gps_time] [int] NULL,

	[sys_time] [int] NULL,

	[heart_time] [int] NULL,

	[server_time] [int] NULL,

	[lng] [numeric](15, 10) NULL,

	[lat] [numeric](15, 10) NULL,

	[course] [int] NULL,

	[speed] [int] NULL,

	[DataTime] [datetime] NULL,

 CONSTRAINT [PK_CarGPS] 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].[CarGPS_Milestat]    Script Date: 2025/4/26 17:45:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[CarGPS_Milestat](

	[id] [int] IDENTITY(1,1) NOT NULL,

	[imei] [nvarchar](50) NULL,

	[GPS_datetime] [datetime] NULL,

	[GPS_milestat] [int] NULL,

	[GPS_outspeed] [int] NULL,

	[GPS_outspeedlimit] [int] NULL,

	[GPS_stop] [int] NULL,

	[DataTime] [datetime] NULL,

 CONSTRAINT [PK_CarGPS_Milestat] 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].[CarIllegal]    Script Date: 2025/4/26 17:45:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[CarIllegal](

	[id] [int] IDENTITY(1,1) NOT NULL,

	[IllegalCarID] [int] NULL,

	[ViolationEvent] [nvarchar](100) NULL,

	[IllegalItems] [nvarchar](100) NULL,

	[IllegalPeopleID] [int] NULL,

	[Points] [nvarchar](50) NULL,

	[fine] [nvarchar](50) NULL,

	[is_Payment] [int] NULL,

	[IllegalDate] [datetime] NULL,

	[OAID] [int] NULL,

	[OATime] [datetime] NULL,

	[IllegalState] [int] NULL,

 CONSTRAINT [PK_CarIllegal] 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].[CarInspection]    Script Date: 2025/4/26 17:45:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[CarInspection](

	[id] [int] IDENTITY(1,1) NOT NULL,

	[InspectionCarID] [int] NULL,

	[DispatchOrdIDPK] [bigint] NULL,

	[CarInspection] [nvarchar](255) NULL,

	[InspectionDate] [datetime] NULL,

	[OAID] [int] NULL,

	[OATime] [datetime] NULL,

	[InspectionState] [int] NULL,

 CONSTRAINT [PK_CarInspection] 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].[CarRepair]    Script Date: 2025/4/26 17:45:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[CarRepair](

	[id] [int] IDENTITY(1,1) NOT NULL,

	[RepairCarID] [int] NULL,

	[MaintenancePlace] [nvarchar](50) NULL,

	[RepairCarLicense] [nvarchar](50) NULL,

	[RepairCarFrame] [nvarchar](50) NULL,

	[RepairCarVIN] [nvarchar](50) NULL,

	[RepairDate] [datetime] NULL,

	[RepairMileage] [nvarchar](50) NULL,

	[MaintenanceItem] [nvarchar](200) NULL,

	[ReplacementParts] [nvarchar](200) NULL,

	[UnitPrice] [money] NULL,

	[UnitInt] [int] NULL,

	[UnitName] [nvarchar](50) NULL,

	[MaterialMoney] [money] NULL,

	[ManHourMoney] [money] NULL,

	[OAID] [int] NULL,

	[OATime] [datetime] NULL,

	[RepairState] [int] NULL,

 CONSTRAINT [PK_CarRepair] 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].[CarStItm]    Script Date: 2025/4/26 17:45:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[CarStItm](

	[CarStItmID] [int] IDENTITY(1,1) NOT NULL,

	[strItmIDPK] [int] NULL,

	[CarStItmInt] [int] NULL,

	[CarStItmType] [int] NULL,

	[CarStItmTop] [int] NULL,

 CONSTRAINT [PK_CarStItm] PRIMARY KEY CLUSTERED 

(

	[CarStItmID] 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].[Coupon]    Script Date: 2025/4/26 17:45:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Coupon](

	[id] [int] IDENTITY(1,1) NOT NULL,

	[CouponNO] [nvarchar](20) NULL,

	[CouponName] [nvarchar](50) NULL,

	[CouponMoney] [money] NULL,

	[CouponDate] [datetime] NULL,

	[CouponDate_Ent] [datetime] NULL,

	[CouponState] [int] NULL,

	[CouponRemarks] [nvarchar](50) NULL,

	[ServiceOrdIDPK] [bigint] NULL,

	[ToUserID] [int] NULL,

	[ToOAid] [int] NULL,

 CONSTRAINT [PK_Coupon] 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].[dictionary]    Script Date: 2025/4/26 17:45:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[dictionary](

	[id] [int] IDENTITY(1,1) NOT NULL,

	[vID] [int] NULL,

	[vtext] [nvarchar](512) NULL,

	[vtitle] [nvarchar](50) NULL,

	[vType] [int] NULL,

	[vMono] [nvarchar](255) NULL,

	[vOrder] [money] NULL,

	[vOrder2] [nvarchar](500) NULL,

 CONSTRAINT [PK_dictionary] 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].[DispatchOrd]    Script Date: 2025/4/26 17:45:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[DispatchOrd](

	[DispatchOrdID] [bigint] IDENTITY(3016003200,1) NOT NULL,

	[DispatchOrdClass] [nvarchar](4) NULL,

	[ServiceOrdIDDt] [bigint] NULL,

	[DispatchOrdState] [int] NULL,

	[StateInt] [int] NULL,

	[DispatchOrdStartDate] [datetime] NULL,

	[DispatchOrdTraSDTime] [datetime] NULL,

	[DispatchOrd_NS_ID] [int] NULL,

	[DispatchOrd_NS_Time] [datetime] NULL,

	[DispatchOrd_AP_ID] [int] NULL,

	[DispatchOrd_AP_Time] [datetime] NULL,

	[DispatchOrd_AP2_ID] [int] NULL,

	[DispatchOrd_AP2_Time] [datetime] NULL,

	[DispatchOrd_AP_Check] [int] NULL,

	[DispatchOrd_AP_Reason] [nvarchar](200) NULL,

	[DispatchOrdActualDate] [datetime] NULL,

	[DispatchOrdArriveDate] [datetime] NULL,

	[DispatchOrdReturnDate] [datetime] NULL,

	[DispatchOrdTraDistance] [nchar](10) NULL,

	[DispatchOrdCarID] [int] NULL,

	[DispatchOrdTraStreet] [nvarchar](200) NULL,

	[DispatchOrdTraEnd] [nvarchar](200) NULL,

	[DispatchOrdTraVia] [nvarchar](500) NULL,

	[DispatchOrdCoName] [nvarchar](50) NULL,

	[DispatchOrdCoPhone] [nvarchar](50) NULL,

	[DispatchOrdTraStreetMileage] [money] NULL,

	[DispatchOrdTraEndMileage] [money] NULL,

	[DispatchOrdMileage] [money] NULL,

	[DispatchOrdGasoline] [money] NULL,

	[DispatchOrdRemarks] [nvarchar](500) NULL,

	[DispatchOrdResult] [nvarchar](100) NULL,

	[DispatchOrdLuqiaoFee] [money] NULL,

	[DispatchOrdGasolineFee] [money] NULL,

	[DispatchOrdTravelFee] [money] NULL,

	[DispatchOrdOtherFee] [money] NULL,

	[DispatchOrdOtherFee_TXT] [nvarchar](100) NULL,

	[DispatchOrdOxygen] [nvarchar](200) NULL,

	[DispatchOrdConsumables] [nvarchar](200) NULL,

	[DispatchOrdDrugs] [nvarchar](200) NULL,

	[DispatchOrdIsEnd] [int] NULL,

	[DispatchOrdIsEndDate] [datetime] NULL,

	[EntourageName_aid1] [nvarchar](50) NULL,

	[EntourageName_aid2] [nvarchar](50) NULL,

	[DispatchOrdNo] [int] NULL,

	[DispatchOrdPerfomance] [money] NULL,

	[DispatchOrdCancelReason] [int] NULL,

	[DispatchOrdCancelReasonTXT] [nvarchar](200) NULL,

	[DispatchOrdWeixinDate] [datetime] NULL,

	[RecommendedCar] [nvarchar](10) NULL,

	[CarStItm] [nvarchar](max) NULL,

	[CarStItm_OAId] [int] NULL,

	[CarStItm_Time] [datetime] NULL,

	[CarSeatBelt_OAId] [int] NULL,

	[StretcherMoney] [money] NULL,

	[DispatchOrdPicUrl] [nvarchar](500) NULL,

	[TimeLength_Program] [money] NULL,

	[TimeLength_ICU] [money] NULL,

	[TimeLength_Wait] [money] NULL,

	[DispatchDoctor] [int] NULL,

	[DispatchNurse] [int] NULL,

	[DispatchDriver] [int] NULL,

	[DispatchOrdTaskRemarks] [nvarchar](500) NULL,

	[DispatchOrd_OAName] [nvarchar](100) NULL,

	[DispatchOrd_OAEntourage] [nvarchar](100) NULL,

	[DispatchOrdUpdateOAid] [int] NULL,

	[DispatchOrdUpdateTime] [datetime] NULL,

	[DispatchOrdOnlineOAName] [nvarchar](100) NULL,

	[DispatchEmployeeGroup] [int] NULL,

	[DispatchOrd_FA_ID] [int] NULL,

	[DispatchOrd_FA_Time] [datetime] NULL,

	[DispatchOrd_FA_Check] [int] NULL,

	[DispatchOrd_FA_Reason] [nvarchar](100) NULL,

	[IsSterilize] [nvarchar](10) NULL,

	[IsSterilize_Time] [datetime] NULL,

	[IsLocking] [int] NULL,

	[IsLocking_Time] [datetime] NULL,

	[IsSterilize_OAID] [int] NULL,

 CONSTRAINT [PK_DispatchOrd] PRIMARY KEY CLUSTERED 

(

	[DispatchOrdID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]



GO

/****** Object:  Table [dbo].[DispatchOrd_CarStItm]    Script Date: 2025/4/26 17:45:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[DispatchOrd_CarStItm](

	[id] [bigint] IDENTITY(1,1) NOT NULL,

 CONSTRAINT [PK_DispatchOrd_CarStItm] 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].[DispatchOrd_Entourage]    Script Date: 2025/4/26 17:45:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[DispatchOrd_Entourage](

	[id] [int] IDENTITY(1,1) NOT NULL,

	[DispatchOrdIDDt] [bigint] NULL,

	[EntourageID] [int] NULL,

	[EntourageOAid] [int] NULL,

	[EntourageState] [int] NULL,

	[EntourageState_Time] [datetime] NULL,

	[EntourageLead] [int] NULL,

	[EntourageOT_is] [int] NULL,

	[EntourageOT2_is] [int] NULL,

	[EntourageLong_is] [int] NULL,

	[EntourageBetimesHH] [int] NULL,

	[EntourageOther] [nvarchar](100) NULL,

	[EntourageRead_Time] [datetime] NULL,

	[EntourageDKP] [int] NULL,

	[EntourageDKPScale] [money] NULL,

	[EntourageEnd_Time] [datetime] NULL,

	[Check_is] [int] NULL,

	[Check_Time] [datetime] NULL,

	[Check_OAid] [int] NULL,

	[DKPEdit_Reason] [nvarchar](100) NULL,

	[DKPEdit_Time] [datetime] NULL,

	[DKPEdit_OAid] [int] NULL,

	[Stretcher_is] [int] NULL,

	[Guest_PointE] [nvarchar](50) NULL,

	[Guest_Point_1] [int] NULL,

	[Guest_Point_2] [int] NULL,

	[Guest_Point_3] [int] NULL,

	[RV_PointE] [nvarchar](50) NULL,

	[RV_Point_1] [int] NULL,

	[RV_Point_2] [int] NULL,

	[RV_Point_3] [int] NULL,

	[EntourageMileageFactor] [money] NULL,

	[EntourageP1] [money] NULL,

	[EntourageMileageEdit] [money] NULL,

	[Condition_is] [int] NULL,

	[EntourageOA_Name] [nvarchar](50) NULL,

	[EntourageOA_DepartmentName] [nvarchar](50) NULL,

	[EntourageOutHosp] [nvarchar](50) NULL,

	[EntourageInHosp] [nvarchar](50) NULL,

	[ConversionDistance] [int] NULL,

	[EntourageOT_Money] [money] NULL,

	[Stretcher_Money] [money] NULL,

	[Condition_Money] [money] NULL,

	[Entourage_Time] [datetime] NULL,

 CONSTRAINT [PK_DispatchOrd_Entourage] 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].[DispatchOrd_Equipment]    Script Date: 2025/4/26 17:45:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[DispatchOrd_Equipment](

	[id] [int] IDENTITY(1,1) NOT NULL,

	[DispatchOrdIDDt] [bigint] NULL,

	[EquipmentID] [int] NULL,

	[EquipmentUseSituation] [nvarchar](50) NULL,

	[EquipmentInspect] [nvarchar](50) NULL,

	[EquipmentOAid] [int] NULL,

	[EquipmentTime] [datetime] NULL,

 CONSTRAINT [PK_DispatchOrd_Equipment] 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].[DispatchOrd_Equipment2]    Script Date: 2025/4/26 17:45:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[DispatchOrd_Equipment2](

	[id] [int] IDENTITY(1,1) NOT NULL,

	[DispatchOrdIDDt] [bigint] NULL,

	[strItmIDPK] [int] NULL,

	[EquipmentUseSituation] [int] NULL,

	[EquipmentPurchasePrice] [money] NULL,

	[EquipmentInspect] [nvarchar](50) NULL,

	[EquipmentOAid] [int] NULL,

	[EquipmentTime] [datetime] NULL,

 CONSTRAINT [PK_DispatchOrd_Equipment2] 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].[DispatchOrd_Hotel]    Script Date: 2025/4/26 17:45:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[DispatchOrd_Hotel](

	[id] [int] IDENTITY(1,1) NOT NULL,

	[DispatchOrdIDDt] [bigint] NULL,

	[HotelDate] [datetime] NULL,

	[HotelName] [nvarchar](50) NULL,

	[HotelPrice] [money] NULL,

	[HotelRemarks] [nvarchar](200) NULL,

	[HotelGPS_address] [nvarchar](100) NULL,

	[HotelGPS_latitude] [nvarchar](50) NULL,

	[HotelGPS_longitude] [nvarchar](50) NULL,

	[Hotel_OATime] [datetime] NULL,

	[Hotel_OAID] [int] NULL,

 CONSTRAINT [PK_DispatchOrd_Hotel] 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].[DispatchOrd_Running]    Script Date: 2025/4/26 17:45:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[DispatchOrd_Running](

	[id] [int] IDENTITY(1,1) NOT NULL,

	[DispatchOrdIDDt] [bigint] NULL,

	[DispatchOrdState] [int] NULL,

	[DispatchOrdStartDate] [datetime] NULL,

	[DispatchOrdStartOA] [int] NULL,

	[OA_latitude] [float] NULL,

	[OA_longitude] [float] NULL,

	[OA_address] [nvarchar](200) NULL,

 CONSTRAINT [PK_DispatchOrd_Running] 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].[DispatchOrd_StItm]    Script Date: 2025/4/26 17:45:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[DispatchOrd_StItm](

	[id] [int] IDENTITY(1,1) NOT NULL,

	[DispatchOrdIDDt] [bigint] NULL,

	[DispatchStItmID] [int] NULL,

	[DispatchStItmInt] [int] NULL,

	[DispatchStItmTime] [datetime] NULL,

	[DispatchStItmOAID] [int] NULL,

 CONSTRAINT [PK_DispatchOrd_StItm] 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].[dwzURL]    Script Date: 2025/4/26 17:45:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[dwzURL](

	[id] [int] IDENTITY(1,1) NOT NULL,

	[n] [nvarchar](10) NULL,

	[URL] [nvarchar](100) NULL,

	[nTime] [datetime] NULL,

 CONSTRAINT [PK_dwzURL] 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].[HospData]    Script Date: 2025/4/26 17:45:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[HospData](

	[HospID] [int] IDENTITY(1,1) NOT NULL,

	[HospName] [nvarchar](100) NULL,

	[HospCityID] [int] NULL,

	[HospShort] [nvarchar](100) NULL,

	[HopsProvince] [nvarchar](50) NULL,

	[HopsCity] [nvarchar](50) NULL,

	[HopsArea] [nvarchar](50) NULL,

	[HospAddress] [nvarchar](100) NULL,

	[HospTEL] [nvarchar](50) NULL,

	[HospUnitID] [int] NULL,

	[HospState] [int] NULL,

	[HospOAID] [nvarchar](50) NULL,

	[HospIntroducerID] [int] NULL,

	[HospIntroducerDate] [datetime] NULL,

	[HospLevel] [int] NULL,

 CONSTRAINT [PK_Hosp] PRIMARY KEY CLUSTERED 

(

	[HospID] 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].[HospDepartment]    Script Date: 2025/4/26 17:45:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[HospDepartment](

	[HospD_ID] [int] NOT NULL,

 CONSTRAINT [PK_HospDepartment] PRIMARY KEY CLUSTERED 

(

	[HospD_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].[ICD10]    Script Date: 2025/4/26 17:45:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[ICD10](

	[id] [int] IDENTITY(1,1) NOT NULL,

	[icd_code] [nvarchar](255) NULL,

	[xh] [float] NULL,

	[fm] [nvarchar](255) NULL,

	[icd_name] [nvarchar](255) NULL,

	[zjm] [nvarchar](255) NULL,

	[sm] [nvarchar](255) NULL,

	[sbxz] [nvarchar](255) NULL,

	[lxxz] [nvarchar](255) NULL,

	[ICDState] [int] NULL,

 CONSTRAINT [PK_ICD10] 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].[ImageData]    Script Date: 2025/4/26 17:45:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[ImageData](

	[id] [int] IDENTITY(1,1) NOT NULL,

	[DOrdIDDt] [bigint] NULL,

	[SOrdIDDt] [bigint] NULL,

	[ImageType] [int] NULL,

	[ImageUrl] [nvarchar](512) NULL,

	[ImageUrls] [nvarchar](512) NULL,

	[ImageDeg] [int] NULL,

	[UpImageTime] [datetime] NULL,

	[UpImageOAid] [int] NULL,

	[ImageDel] [int] NULL,

	[isAP] [int] NULL,

	[isAP_ID] [int] NULL,

	[isAP_Time] [datetime] NULL

) ON [PRIMARY]



GO

/****** Object:  Table [dbo].[IntroducerData]    Script Date: 2025/4/26 17:45:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[IntroducerData](

	[IntroducerID] [int] IDENTITY(1,1) NOT NULL,

	[IntroducerName] [nvarchar](50) NULL,

	[IntroducerTEL] [nvarchar](50) NULL,

	[IntroducerUnitID] [int] NULL,

	[IntroducerState] [int] NULL,

	[IntroducerOrdClass] [nvarchar](50) NULL,

	[IntroducerAdminName] [nvarchar](50) NULL,

	[IntroducerAdminPass] [nvarchar](50) NULL,

	[IntroducerAdminDate] [datetime] NULL,

 CONSTRAINT [PK_IntroducerData] PRIMARY KEY CLUSTERED 

(

	[IntroducerID] 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].[IntroducerRegion]    Script Date: 2025/4/26 17:45:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[IntroducerRegion](

	[IRid] [int] IDENTITY(1,1) NOT NULL,

	[IRUnitID] [int] NULL,

	[IRProvince] [nvarchar](50) NULL,

	[IRCity] [nvarchar](50) NULL,

	[IRArea] [nvarchar](50) NULL,

	[IRkeyword] [nvarchar](100) NULL,

	[IRPrice] [money] NULL,

	[IRNursingLevel] [int] NULL,

	[IRPrice1] [money] NULL,

	[IRPrice2] [money] NULL,

	[IRPrice3] [money] NULL,

	[IRlimit1] [int] NULL,

	[IRlimit2] [int] NULL,

	[IRlimit3] [int] NULL,

	[IRVentilatorCost] [money] NULL,

	[IRWarmBoxCost] [money] NULL,

	[IRLiftingCost] [money] NULL,

	[IRWaitingCost] [money] NULL,

	[IRFerryCost] [money] NULL,

	[IRState] [int] NULL,

	[IRwxState] [int] NULL,

	[IRRemarks] [nvarchar](200) NULL,

	[Unitlimit] [int] NULL,

	[UnitPrice] [money] NULL,

 CONSTRAINT [PK_IntroducerRegion] PRIMARY KEY CLUSTERED 

(

	[IRid] 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].[IntroducerRegionDt]    Script Date: 2025/4/26 17:45:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[IntroducerRegionDt](

	[id] [int] IDENTITY(1,1) NOT NULL,

	[IRDt_id] [int] NULL,

	[IRDtPrice] [money] NULL,

	[IRDtlimit] [int] NULL,

 CONSTRAINT [PK_IntroducerRegionDt] 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].[IntroducerUnitData]    Script Date: 2025/4/26 17:45:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[IntroducerUnitData](

	[UnitID] [int] IDENTITY(1,1) NOT NULL,

	[UnitName] [nvarchar](100) NULL,

	[UnitShort] [nvarchar](50) NULL,

	[UnitAddress] [nvarchar](100) NULL,

	[UnitTEL] [nvarchar](50) NULL,

	[UnitState] [int] NULL,

	[APPID] [nvarchar](50) NULL,

	[APPSECRET] [nvarchar](50) NULL,

	[is_test] [int] NULL,

	[wx_OriginalID] [nvarchar](50) NULL,

	[wx_APPID] [nvarchar](50) NULL,

	[wx_APPSECRET] [nvarchar](100) NULL,

	[wx_access_tokenID] [nvarchar](512) NULL,

	[wx_access_tokenTime] [datetime] NULL,

	[wx_jsapi_ticketID] [nvarchar](512) NULL,

	[wx_jsapi_ticketTime] [datetime] NULL,

	[wxcx_OriginalID] [nvarchar](50) NULL,

	[wxcx_APPID] [nvarchar](50) NULL,

	[wxcx_APPSECRET] [nvarchar](100) NULL,

	[wxcx_access_tokenID] [nvarchar](512) NULL,

	[wxcx_access_tokenTime] [datetime] NULL,

	[wxcx_jsapi_ticketID] [nvarchar](512) NULL,

	[wxcx_jsapi_ticketTime] [datetime] NULL,

	[pay_mch_id] [nvarchar](50) NULL,

	[pay_mch_key] [nvarchar](50) NULL,

	[ServiceBranch] [nvarchar](50) NULL,

	[ServiceMinPrice] [money] NULL,

	[ServiceUnitPrice] [money] NULL,

	[ServiceLong] [int] NULL,

	[ServiceRemarks] [nvarchar](512) NULL,

	[ServiceAddress] [nvarchar](200) NULL,

	[ServiceAddress_lat] [decimal](18, 10) NULL,

	[ServiceAddress_lng] [decimal](18, 10) NULL,

	[NC_OAIDs] [nvarchar](100) NULL,

	[OrdDateMode] [int] NULL,

 CONSTRAINT [PK_IntroducerUnit] PRIMARY KEY CLUSTERED 

(

	[UnitID] 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].[InvoiceData]    Script Date: 2025/4/26 17:45:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[InvoiceData](

	[InvoiceID] [int] IDENTITY(1,1) NOT NULL,

	[ServiceOrderIDPK] [bigint] NULL,

	[InvoiceType] [int] NULL,

	[InvoiceName] [nvarchar](50) NULL,

	[InvoiceMakeout] [nvarchar](1000) NULL,

	[InvoiceCompanyPhone] [nvarchar](50) NULL,

	[InvoiceCompanyID] [nvarchar](50) NULL,

	[InvoiceCompanyAdd] [nvarchar](100) NULL,

	[InvoiceCompanyBank] [nvarchar](50) NULL,

	[InvoiceCompanyBankNo] [nvarchar](50) NULL,

	[InvoiceZipCode] [nvarchar](50) NULL,

	[Invoice_strAdd] [nvarchar](100) NULL,

	[Invoice_strName] [nvarchar](50) NULL,

	[Invoice_strPhone] [nvarchar](50) NULL,

	[Invoice_strEmail] [nvarchar](50) NULL,

	[ApplicationTime] [datetime] NULL,

	[AuditTime] [datetime] NULL,

	[AuditStatus] [int] NULL,

	[AuditOAID] [int] NULL,

	[AuditMakeout] [nvarchar](100) NULL,

	[InvoiceMoney] [money] NULL,

	[InvoiceNo] [nvarchar](50) NULL,

	[InvoiceURL] [nvarchar](1000) NULL,

	[InvoiceOddNo] [nvarchar](200) NULL,

	[EleCloud_ZTDM] [nvarchar](50) NULL,

	[EleCloud_ZTXX] [nvarchar](100) NULL,

	[EleCloud_PDF] [nvarchar](100) NULL,

	[EleCloud_Time] [datetime] NULL,

	[ApplyOAID] [int] NULL,

 CONSTRAINT [PK_InvoiceData] PRIMARY KEY CLUSTERED 

(

	[InvoiceID] 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].[MRP_OrderApply]    Script Date: 2025/4/26 17:45:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[MRP_OrderApply](

	[MRP_OSID] [int] IDENTITY(1,1) NOT NULL,

	[MRP_OrderID] [nvarchar](20) NULL,

	[OrderCustomerName] [nvarchar](50) NULL,

	[OrderWarehouseID] [int] NULL,

	[OrderState] [int] NULL,

	[OrderTime] [datetime] NULL,

	[OrderTime_OAid] [int] NULL,

	[AuditTime] [datetime] NULL,

	[AuditTime_OAid] [int] NULL,

	[ShipmentTime] [datetime] NULL,

	[ShipmentTime_OAid] [int] NULL,

	[TotalMoney] [money] NULL,

	[TotalQty] [int] NULL,

	[OrderRemarks] [nvarchar](200) NULL,

 CONSTRAINT [PK_MRP_OrderSale] PRIMARY KEY CLUSTERED 

(

	[MRP_OSID] 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].[MRP_OrderDetail]    Script Date: 2025/4/26 17:45:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[MRP_OrderDetail](

	[MRP_ODID] [int] IDENTITY(1,1) NOT NULL,

	[MRP_OrderIDPK] [nvarchar](20) NULL,

	[StItmIDPK] [int] NULL,

	[OD_Qty] [int] NULL,

	[OD_QtyA] [int] NULL,

	[OD_Price] [money] NULL,

	[OD_Remarks] [nvarchar](100) NULL,

 CONSTRAINT [PK_MRP_OrderDetail] PRIMARY KEY CLUSTERED 

(

	[MRP_ODID] 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].[MRP_OrderManoeuvre]    Script Date: 2025/4/26 17:45:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[MRP_OrderManoeuvre](

	[MRP_OMID] [int] IDENTITY(1,1) NOT NULL,

	[MRP_OrderID] [nvarchar](20) NULL,

	[OutWarehouseID] [int] NULL,

	[InWarehouseID] [int] NULL,

	[OrderState] [int] NULL,

	[OrderTime] [datetime] NULL,

	[OrderTime_OAid] [int] NULL,

	[AuditTime] [datetime] NULL,

	[AuditTime_OAid] [int] NULL,

	[OutTime] [datetime] NULL,

	[OutTime_OAid] [int] NULL,

	[InTime] [datetime] NULL,

	[InTime_OAid] [int] NULL,

	[TotalMoney] [money] NULL,

	[TotalQty] [int] NULL,

	[OrderRemarks] [nvarchar](200) NULL,

 CONSTRAINT [PK_MRP_OrderManoeuvre] PRIMARY KEY CLUSTERED 

(

	[MRP_OMID] 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].[MRP_OrderPurchase]    Script Date: 2025/4/26 17:45:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[MRP_OrderPurchase](

	[MRP_OPID] [int] IDENTITY(1,1) NOT NULL,

	[MRP_OrderID] [nvarchar](20) NULL,

	[OrderSupplierID] [int] NULL,

	[OrderWarehouseID] [int] NULL,

	[OrderState] [int] NULL,

	[OrderTime] [datetime] NULL,

	[OrderTime_OAid] [int] NULL,

	[AuditTime] [datetime] NULL,

	[AuditTime_OAid] [int] NULL,

	[StorageTime] [datetime] NULL,

	[StorageTime_OAid] [int] NULL,

	[TotalMoney] [money] NULL,

	[TotalQty] [int] NULL,

	[OrderRemarks] [nvarchar](max) NULL,

 CONSTRAINT [PK_MRP_OrderPurchase] PRIMARY KEY CLUSTERED 

(

	[MRP_OPID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]



GO

/****** Object:  Table [dbo].[MRP_OrderSale]    Script Date: 2025/4/26 17:45:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[MRP_OrderSale](

	[MRP_OSID] [int] NOT NULL,

	[MRP_OrderID] [nvarchar](20) NULL,

	[OrderCustomerName] [nvarchar](50) NULL,

	[OrderWarehouseID] [int] NULL,

	[OrderState] [int] NULL,

	[OrderTime] [datetime] NULL,

	[OrderTime_OAid] [int] NULL,

	[AuditTime] [datetime] NULL,

	[AuditTime_OAid] [int] NULL,

	[ShipmentTime] [datetime] NULL,

	[ShipmentTime_OAid] [int] NULL,

	[TotalMoney] [money] NULL,

	[TotalQty] [int] NULL,

	[OrderRemarks] [nvarchar](200) NULL,

 CONSTRAINT [PK_MRP_OrderSale_1] PRIMARY KEY CLUSTERED 

(

	[MRP_OSID] 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].[MRP_OrderStockAdjust]    Script Date: 2025/4/26 17:45:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[MRP_OrderStockAdjust](

	[MRP_OSID] [int] IDENTITY(1,1) NOT NULL,

	[MRP_OrderID] [nvarchar](20) NULL,

	[OrderWarehouseID] [int] NULL,

	[OrderState] [int] NULL,

	[OrderTime] [datetime] NULL,

	[OrderTime_OAid] [int] NULL,

	[AuditTime] [datetime] NULL,

	[AuditTime_OAid] [int] NULL,

	[TotalMoney] [money] NULL,

	[TotalQty] [int] NULL,

	[OrderRemarks] [nvarchar](max) NULL,

 CONSTRAINT [PK_MRP_OrderStockAdjust] PRIMARY KEY CLUSTERED 

(

	[MRP_OSID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]



GO

/****** Object:  Table [dbo].[MRP_Stock]    Script Date: 2025/4/26 17:45:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[MRP_Stock](

	[MRP_StockID] [int] IDENTITY(1,1) NOT NULL,

	[StItmIDPK] [int] NULL,

	[StockQty] [int] NULL,

	[StockWarehouseID] [int] NULL,

	[StockTime] [datetime] NULL,

	[StockTime_OAid] [int] NULL,

	[MRP_OrderIDPK] [nvarchar](20) NULL,

 CONSTRAINT [PK_MRP_Stock] PRIMARY KEY CLUSTERED 

(

	[MRP_StockID] 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].[MRP_Supplier]    Script Date: 2025/4/26 17:45:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[MRP_Supplier](

	[SupplierID] [int] IDENTITY(1,1) NOT NULL,

	[SupplierName] [nvarchar](50) NULL,

	[SupplierContact] [nvarchar](50) NULL,

	[SupplierTEL] [nvarchar](50) NULL,

	[SupplierAddress] [nvarchar](50) NULL,

	[SupplierRemarks] [nvarchar](100) NULL,

	[SupplierState] [int] NULL,

 CONSTRAINT [PK_MRP_Supplier] PRIMARY KEY CLUSTERED 

(

	[SupplierID] 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].[MRP_Warehouse]    Script Date: 2025/4/26 17:45:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[MRP_Warehouse](

	[WarehouseID] [int] IDENTITY(1,1) NOT NULL,

	[WarehouseName] [nvarchar](50) NULL,

	[WarehouseContact] [nvarchar](50) NULL,

	[WarehouseTEL] [nvarchar](50) NULL,

	[WarehouseAddress] [nvarchar](50) NULL,

	[WarehouseRemarks] [nvarchar](100) NULL,

	[WarehouseType] [int] NULL,

 CONSTRAINT [PK_tblWarehouse] PRIMARY KEY CLUSTERED 

(

	[WarehouseID] 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].[MRP_WarehouseShelves]    Script Date: 2025/4/26 17:45:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[MRP_WarehouseShelves](

	[id] [int] IDENTITY(1,1) NOT NULL,

	[ShelvesID] [int] NULL,

	[ItmID] [int] NULL,

	[isShelves] [int] NULL,

 CONSTRAINT [PK_MRP_WarehouseShelves] 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].[Notification]    Script Date: 2025/4/26 17:45:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Notification](

	[NC_ID] [int] IDENTITY(1,1) NOT NULL,

	[NC_OAID] [int] NULL,

	[NC_OAClass] [nvarchar](50) NULL,

	[NC_Name] [nvarchar](50) NULL,

	[NC_Content] [nvarchar](200) NULL,

	[NC_PageUrl] [nvarchar](200) NULL,

	[NC_PageUrlM] [nvarchar](200) NULL,

	[NC_Time] [datetime] NULL,

	[NC_Read] [int] NULL,

	[NC_ReadOAID] [int] NULL,

	[NC_ReadTime] [datetime] NULL,

 CONSTRAINT [PK_Notification] PRIMARY KEY CLUSTERED 

(

	[NC_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].[OA_CheckinData]    Script Date: 2025/4/26 17:45:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[OA_CheckinData](

	[id] [int] IDENTITY(1,1) NOT NULL,

	[userid] [varchar](100) NULL,

	[groupname] [varchar](100) NULL,

	[checkin_type] [varchar](100) NULL,

	[exception_type] [varchar](100) NULL,

	[checkin_time] [datetime] NULL,

	[location_title] [varchar](200) NULL,

	[location_detail] [varchar](200) NULL,

	[wifiname] [varchar](200) NULL,

	[notes] [varchar](500) NULL,

	[wifimac] [varchar](200) NULL,

	[mediaids] [varchar](500) NULL,

	[lat] [varchar](50) NULL,

	[lng] [varchar](50) NULL,

	[deviceid] [varchar](100) NULL,

	[sch_checkin_time] [varchar](100) NULL,

	[groupid] [varchar](100) NULL,

	[schedule_id] [varchar](100) NULL,

	[timeline_id] [varchar](100) NULL,

	[update_time] [datetime] NULL,

 CONSTRAINT [PK_OA_CheckinData] 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 ANSI_PADDING OFF

GO

/****** Object:  Table [dbo].[OA_Competency]    Script Date: 2025/4/26 17:45:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[OA_Competency](

	[id] [int] IDENTITY(1,1) NOT NULL,

	[OA_CompetencyID] [int] NULL,

	[OA_CompetencyUserID] [int] NULL,

 CONSTRAINT [PK_OA_Competency_1] 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].[OA_Module]    Script Date: 2025/4/26 17:45:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[OA_Module](

	[id] [int] IDENTITY(1,1) NOT NULL,

	[ModuleID] [nvarchar](20) NULL,

	[ModuleName] [nvarchar](50) NULL,

	[ModuleReadme] [nvarchar](200) NULL,

	[ModuleLevel] [int] NULL,

 CONSTRAINT [PK_OA_Module] 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].[OA_NucleicAcid]    Script Date: 2025/4/26 17:45:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[OA_NucleicAcid](

	[id] [int] IDENTITY(1,1) NOT NULL,

	[NucleicAcid_OAID] [int] NULL,

	[NucleicAcid_Time] [datetime] NULL,

	[NucleicAcidUpTime] [datetime] NULL,

	[NucleicAcidUpOAID] [int] NULL,

 CONSTRAINT [PK_OA_NucleicAcid] 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].[OA_Running]    Script Date: 2025/4/26 17:45:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[OA_Running](

	[id] [bigint] IDENTITY(1,1) NOT NULL,

	[OAid] [int] NULL,

	[OA_IP] [nvarchar](50) NULL,

	[OA_Time] [datetime] NULL,

	[Running] [nvarchar](max) NULL,

	[Running_URL] [nvarchar](200) NULL,

	[Running_address] [nvarchar](100) NULL,

	[Running_ID] [nvarchar](50) NULL,

 CONSTRAINT [PK_OA_Running_1] 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] TEXTIMAGE_ON [PRIMARY]



GO

/****** Object:  Table [dbo].[OA_Schedules]    Script Date: 2025/4/26 17:45:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[OA_Schedules](

	[id] [int] IDENTITY(1,1) NOT NULL,

	[OAid] [int] NULL,

	[SchedulesDate] [date] NULL,

	[CompetencyID] [int] NULL,

	[SchedulesShiftID] [int] NULL,

	[SchedulesShiftTOP] [int] NULL,

	[SchedulesShiftSum] [int] NULL,

	[SchedulesOrders] [int] NULL,

	[SchedulesAdminID] [int] NULL,

	[SchedulesTypeManeuver] [int] NULL,

	[SchedulesTypeAM] [int] NULL,

	[SchedulesTypePM] [int] NULL,

 CONSTRAINT [PK_OA_Schedules] 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].[OA_Sterilize]    Script Date: 2025/4/26 17:45:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[OA_Sterilize](

	[id] [int] IDENTITY(1,1) NOT NULL,

	[Sterilize_OAID] [int] NULL,

	[Sterilize_CarLicense] [nvarchar](50) NULL,

	[Sterilize_Mode] [nvarchar](50) NULL,

	[Sterilize_DispatchOrdID] [bigint] NULL,

	[Sterilize_Time] [datetime] NULL,

	[SterilizeUPTime] [datetime] NULL,

	[SterilizeUPOAID] [int] NULL,

 CONSTRAINT [PK_OA_Sterilize] 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].[OA_User]    Script Date: 2025/4/26 17:45:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[OA_User](

	[OA_User_ID] [int] IDENTITY(1,1) NOT NULL,

	[OA_User] [nvarchar](50) NULL,

	[OA_Pass] [nvarchar](50) NULL,

	[OA_weixinUserID] [nvarchar](50) NULL,

	[OA_Name] [nvarchar](50) NULL,

	[OA_DepartmentID] [int] NULL,

	[OA_Position] [nvarchar](50) NULL,

	[OA_mobile] [nvarchar](50) NULL,

	[OA_gender] [int] NULL,

	[OA_email] [nvarchar](50) NULL,

	[OA_weixinID] [nvarchar](50) NULL,

	[OA_weixinAvatar] [nvarchar](200) NULL,

	[OA_weixinStatus] [int] NULL,

	[OA_Power] [nvarchar](max) NULL,

	[Endtime] [datetime] NULL,

	[OA_execLevel] [int] NULL,

	[OA_Province] [nvarchar](50) NULL,

	[OA_City] [nvarchar](50) NULL,

	[OA_OrderClass] [nvarchar](2000) NULL,

	[OA_Img] [nvarchar](50) NULL,

	[OA_Img_64] [nvarchar](50) NULL,

	[loginAuthorize] [nvarchar](10) NULL,

	[loginAuthorize1] [nvarchar](10) NULL,

	[loginAuthorize_Time] [datetime] NULL,

	[Post_Name] [nvarchar](50) NULL,

	[Post_MoneyP] [money] NULL,

	[Post_MoneyP1] [money] NULL,

	[OA_UserRemark] [nvarchar](50) NULL,

	[OA_IdentityCard] [nvarchar](50) NULL,

	[OA_EmployeeGroup] [int] NULL,

	[OA_DepartmentIDs] [nvarchar](255) NULL,

 CONSTRAINT [PK_OA_User] PRIMARY KEY CLUSTERED 

(

	[OA_User_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] TEXTIMAGE_ON [PRIMARY]



GO

/****** Object:  Table [dbo].[OrdData]    Script Date: 2025/4/26 17:45:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[OrdData](

	[DataID] [int] IDENTITY(1,1) NOT NULL,

	[SOrdID] [bigint] NULL,

	[SOrdClass] [nvarchar](4) NULL,

	[SOrdState] [int] NULL,

	[SOrdType] [int] NULL,

	[SOrdAreaType] [int] NULL,

	[DOrdID] [bigint] NULL,

	[DOrdClass] [nvarchar](4) NULL,

	[DOrdState] [int] NULL,

	[
g¡RUS÷S] [nvarchar](50) NULL,

	[¦^US÷S] [nvarchar](50) NULL,

	[§~+R] [nvarchar](50) NULL,

	[R:S] [nvarchar](50) NULL,

	[¦~{|W] [nvarchar](50) NULL,

	[
g¡RUS¶r`] [nvarchar](50) NULL,

	[¦^US¶r`] [nvarchar](50) NULL,

	[¢USöeô] [datetime] NULL,

	[¦^öeô] [datetime] NULL,

	[
g¡Rís!k] [nchar](10) NULL,

	[¦^ís!k] [nvarchar](50) NULL,

	[Tû|ºN] [nvarchar](50) NULL,

	[Tû|5uÝ] [nvarchar](50) NULL,

	[£`ÓY
T] [nvarchar](50) NULL,

	[.U] [nvarchar](50) NULL,

	[ËNÍ~ºN] [nvarchar](50) NULL,

	[¢[
g] [nvarchar](50) NULL,

	[¦^] [nvarchar](50) NULL,

	[egn] [nvarchar](50) NULL,

	[;`èNÑS] [nvarchar](50) NULL,

	[:SßW] [nvarchar](50) NULL,

	[{|W] [nvarchar](50) NULL,

	[úQÑSwýN] [nvarchar](50) NULL,

	[úQÑS^] [nvarchar](50) NULL,

	[úQÑS:S] [nvarchar](50) NULL,

	[lúQ;Sb] [nvarchar](50) NULL,

	[lúQÑy¤[] [nvarchar](50) NULL,

	[lúQ^MO] [nvarchar](50) NULL,

	[leQwýN] [nvarchar](50) NULL,

	[leQ^] [nvarchar](50) NULL,

	[leQ:S] [nvarchar](50) NULL,

	[leQ;Sb] [nvarchar](50) NULL,

	[leQÑy¤[] [nvarchar](50) NULL,

	[b¤N÷N] [money] NULL,

	[Ý»ylQÌ] [nvarchar](50) NULL,

	[/eØN¹e_] [nvarchar](50) NULL,

	[O(u|T8T:g] [nvarchar](50) NULL,

	[fLr] [nvarchar](50) NULL,

	[úQfbXT] [nvarchar](50) NULL,

	[;S¤búQföeôR] [nvarchar](50) NULL,

	[DataUPTime] [datetime] NULL,

 CONSTRAINT [PK_OrdData] PRIMARY KEY CLUSTERED 

(

	[DataID] 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].[OrdPriceSetting]    Script Date: 2025/4/26 17:45:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[OrdPriceSetting](

	[id] [int] IDENTITY(1,1) NOT NULL,

	[OPS_AreaClass] [nvarchar](50) NULL,

	[OPS_NursingLevel] [int] NULL,

	[OPS_StartingPrice] [money] NULL,

	[OPS_Price1] [money] NULL,

	[OPS_Price2] [money] NULL,

	[OPS_limit1] [int] NULL,

	[OPS_limit2] [int] NULL,

	[OPS_VentilatorCost] [money] NULL,

	[OPS_WarmBoxCost] [money] NULL,

	[OPS_LiftingCost] [money] NULL,

	[OPS_WaitingCost] [money] NULL,

	[OPS_FerryCost] [money] NULL,

 CONSTRAINT [PK_OrdPriceSetting] 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].[PaidMoney]    Script Date: 2025/4/26 17:45:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[PaidMoney](

	[id] [int] IDENTITY(1,1) NOT NULL,

	[PaidMoneyClass] [nvarchar](4) NULL,

	[ServiceOrdIDDt] [bigint] NULL,

	[DispatchOrdIDDt] [bigint] NULL,

	[PaidMoney] [money] NULL,

	[PaidMoneyType] [int] NULL,

	[PaidMoneyMono] [nvarchar](100) NULL,

	[PaidMoneyTime] [datetime] NULL,

	[PaidMoneyOaID] [int] NULL,

	[PaidMoneyUnitID] [int] NULL,

	[PaidMoney_AP_ID] [int] NULL,

	[PaidMoney_AP_Time] [datetime] NULL,

	[PaidMoney_AP_Check] [int] NULL,

	[PaidMoneyTimestamp] [nvarchar](20) NULL,

 CONSTRAINT [PK_PaidMoney] 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].[PaidMoney_Add]    Script Date: 2025/4/26 17:45:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[PaidMoney_Add](

	[id] [int] IDENTITY(1,1) NOT NULL,

	[ToServiceOrdID] [bigint] NULL,

	[ToDispatchOrdID] [bigint] NULL,

	[AddMoneyType] [int] NULL,

	[AddMoney] [money] NULL,

	[AddMoneyExplain] [nvarchar](100) NULL,

	[AddMoneyTime] [datetime] NULL,

	[AddMoneyOAID] [int] NULL,

 CONSTRAINT [PK_PaidMoney_Add] 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].[QR_activity]    Script Date: 2025/4/26 17:45:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[QR_activity](

	[id] [int] IDENTITY(1,1) NOT NULL,

	[QR_OpenID] [varchar](100) NULL,

	[QR_Key] [varchar](50) NULL,

	[QR_time] [datetime] NULL,

	[QR_activityInt] [int] NULL

) ON [PRIMARY]



GO

SET ANSI_PADDING OFF

GO

/****** Object:  Table [dbo].[ServiceOrd_Condition]    Script Date: 2025/4/26 17:45:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[ServiceOrd_Condition](

	[id] [int] IDENTITY(1,1) NOT NULL,

	[ServiceOrdCoID] [int] NULL,

	[ConditionID] [int] NULL,

 CONSTRAINT [PK_ServiceOrd_Condition1] 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].[ServiceOrd_Message]    Script Date: 2025/4/26 17:45:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[ServiceOrd_Message](

	[MID] [int] IDENTITY(1,1) NOT NULL,

	[ServiceOrdIDDt] [bigint] NULL,

	[MessageHeadline] [nvarchar](100) NULL,

	[MessageContents] [nvarchar](max) NULL,

	[MessageDate] [datetime] NULL,

	[MessageOAid] [int] NULL,

	[MessageState] [int] NULL,

	[MessageToOAid] [int] NULL,

	[MessageToState] [int] NULL,

	[MessageToStateTime] [datetime] NULL,

	[Phone_is] [int] NULL,

	[Phone_callid] [nvarchar](100) NULL,

 CONSTRAINT [PK_ServiceOrd_Message] PRIMARY KEY CLUSTERED 

(

	[MID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]



GO

/****** Object:  Table [dbo].[ServiceOrd_TransferMode]    Script Date: 2025/4/26 17:45:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[ServiceOrd_TransferMode](

	[id] [int] IDENTITY(1,1) NOT NULL,

	[ServiceOrdTMID] [int] NULL,

	[TransferModeID] [int] NULL,

 CONSTRAINT [PK_ServiceOrdTransferMode] 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].[ServiceOrder]    Script Date: 2025/4/26 17:45:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO



GO

SET ANSI_PADDING OFF

GO

/****** Object:  Table [dbo].[ServiceOrder_ICD]    Script Date: 2025/4/26 17:45:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[ServiceOrder_ICD](

	[idDt] [int] IDENTITY(1,1) NOT NULL,

	[icd_id] [int] NULL,

	[ServiceOrdIDDt] [bigint] NULL,

 CONSTRAINT [PK_ServiceOrder_ICD] PRIMARY KEY CLUSTERED 

(

	[idDt] 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].[ServiceOrder_Options]    Script Date: 2025/4/26 17:45:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[ServiceOrder_Options](

	[id] [int] IDENTITY(1,1) NOT NULL,

	[ServiceOrdSoID] [bigint] NULL,

	[ServiceOptionsID] [int] NULL,

	[ServiceOptionsValue] [nvarchar](500) NULL,

 CONSTRAINT [PK_ServiceOrder_Options] 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].[ServiceOrderCommissionDetails]    Script Date: 2025/4/26 17:45:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[ServiceOrderCommissionDetails](

	[ID] [int] IDENTITY(1,1) NOT NULL,

	[ServiceOrderID] [bigint] NOT NULL,

	[PersonID] [int] NOT NULL,

	[PersonName] [nvarchar](255) NOT NULL,

	[CommissionRatio] [decimal](5, 2) NOT NULL,

	[PersonType] [nvarchar](20) NOT NULL,

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].[SMS_Log]    Script Date: 2025/4/26 17:45:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[SMS_Log](

	[Send_ID] [int] IDENTITY(1,1) NOT NULL,

	[Log_Id] [nvarchar](20) NULL,

	[Send_Text] [nvarchar](500) NULL,

	[Send_Time] [datetime] NULL,

	[Send_Phone] [nvarchar](20) NULL,

	[Send_OA] [int] NULL,

	[Send_errMsg] [nvarchar](50) NULL,

	[Send_Remarks] [nvarchar](50) NULL,

 CONSTRAINT [PK_SMS_Log] PRIMARY KEY CLUSTERED 

(

	[Send_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].[tblStItm]    Script Date: 2025/4/26 17:45:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[tblStItm](

	[strItmID] [int] IDENTITY(1,1) NOT NULL,

	[strItmNo] [nvarchar](50) NULL,

	[strItmPinyin] [nvarchar](50) NULL,

	[strItmName] [nvarchar](100) NULL,

	[strItmUnit] [nvarchar](20) NULL,

	[PurchasePrice] [money] NULL,

	[SellingPrice] [money] NULL,

	[CreditsPrice] [money] NULL,

	[strItmClassID] [int] NULL,

	[strItmRemarks] [nvarchar](max) NULL,

	[strItmState] [int] NULL,

	[strItmBarcode] [nvarchar](50) NULL,

	[isCarStItm] [int] NULL,

	[strItmDesc] [nvarchar](max) NULL,

 CONSTRAINT [PK_tblStItm] PRIMARY KEY CLUSTERED 

(

	[strItmID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]



GO

/****** Object:  Table [dbo].[test_Ord]    Script Date: 2025/4/26 17:45:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[test_Ord](

	[testID] [int] IDENTITY(1,1) NOT NULL,

	[testName] [nvarchar](50) NULL,

	[testDate] [datetime] NULL,

	[test_is] [int] NULL,

 CONSTRAINT [PK_test_Ord] PRIMARY KEY CLUSTERED 

(

	[testID] 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].[test_OrdDt]    Script Date: 2025/4/26 17:45:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[test_OrdDt](

	[id] [int] IDENTITY(1,1) NOT NULL,

	[testIDDt] [int] NULL,

	[testOA_UserID] [int] NULL,

	[test_UserType] [nvarchar](50) NULL,

	[testWeixinState] [nvarchar](50) NULL,

	[testWeixinDate] [datetime] NULL,

 CONSTRAINT [PK_test_OrdDt] 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].[UserData]    Script Date: 2025/4/26 17:45:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[UserData](

	[UserID] [int] IDENTITY(1,1) NOT NULL,

	[UserName] [nvarchar](50) NULL,

	[UserPhone] [nvarchar](50) NULL,

	[UserLevel] [int] NULL,

	[UserRegisterTime] [datetime] NULL,

	[UserLoginTime] [datetime] NULL,

	[UserNickName] [nvarchar](50) NULL,

	[UserAvatarUrl] [nvarchar](200) NULL,

	[UserUnitID] [int] NULL,

	[UserSource] [nvarchar](50) NULL,

	[UserSourceTime] [datetime] NULL,

	[UserSourceTimeTerm] [int] NULL,

	[UserBranch] [nvarchar](50) NULL,

	[RecommendUserID] [int] NULL,

	[RecommendTime] [datetime] NULL,

	[RecommendTimeTerm] [int] NULL,

	[RecommendUserIDs] [nvarchar](max) NULL,

 CONSTRAINT [PK_UserData] PRIMARY KEY CLUSTERED 

(

	[UserID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]



GO

/****** Object:  Table [dbo].[UserInformation]    Script Date: 2025/4/26 17:45:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[UserInformation](

	[id] [int] IDENTITY(1,1) NOT NULL,

	[ToUserID] [int] NULL,

	[ToWxOpenID] [nvarchar](50) NULL,

	[UserPages] [nvarchar](100) NULL,

	[InformationTime] [datetime] NULL,

 CONSTRAINT [PK_UserInformation] 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].[UserPhone]    Script Date: 2025/4/26 17:45:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[UserPhone](

	[id] [int] IDENTITY(1,1) NOT NULL,

	[ToUserID] [int] NULL,

	[strPhone] [nvarchar](50) NULL,

	[strPhone_is] [int] NULL,

	[LoginTime] [datetime] NULL,

 CONSTRAINT [PK_UserPhone] 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].[UserPhoneVerify]    Script Date: 2025/4/26 17:45:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[UserPhoneVerify](

	[id] [int] IDENTITY(1,1) NOT NULL,

	[Phone] [nvarchar](50) NULL,

	[PhoneVerify] [nvarchar](50) NULL,

	[SendTime] [datetime] NULL,

	[SendID] [int] NULL,

 CONSTRAINT [PK_UserPhoneVerify] 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].[UserPoints]    Script Date: 2025/4/26 17:45:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[UserPoints](

	[Pid] [int] IDENTITY(1,1) NOT NULL,

	[ToUserID] [int] NULL,

	[Points_Score] [money] NULL,

	[Points_Type] [int] NULL,

	[Points_Time] [datetime] NULL,

	[Points_State] [int] NULL,

	[Points_Value1] [nvarchar](255) NULL,

	[Points_Value2] [nvarchar](255) NULL,

	[Points_Value3] [nvarchar](255) NULL,

	[ServiceOrdIDDt] [bigint] NULL,

	[AuditTime] [datetime] NULL,

	[AuditOAID] [int] NULL,

	[AuditMakeout] [nvarchar](255) NULL,

 CONSTRAINT [PK_UserPoints] PRIMARY KEY CLUSTERED 

(

	[Pid] 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].[UserRecommendNote]    Script Date: 2025/4/26 17:45:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[UserRecommendNote](

	[id] [int] IDENTITY(1,1) NOT NULL,

	[ToUserID] [int] NULL,

	[ToRUserID] [int] NULL,

	[NoteName] [nvarchar](50) NULL,

	[UpdateTime] [datetime] NULL,

 CONSTRAINT [PK_UserRecommendNote] 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].[UserUUID]    Script Date: 2025/4/26 17:45:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[UserUUID](

	[id] [int] IDENTITY(1,1) NOT NULL,

	[ToUserID] [int] NULL,

	[iuid] [nvarchar](128) NULL,

	[uuid] [nvarchar](128) NULL,

	[LoginTime] [datetime] NULL,

	[ToServiceOrdID] [bigint] NULL,

	[TritonshJson] [nvarchar](128) NULL,

	[TritonshTime] [datetime] NULL,

 CONSTRAINT [PK_UserUUID] 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].[weixinOpenID]    Script Date: 2025/4/26 17:45:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[weixinOpenID](

	[id] [int] IDENTITY(1,1) NOT NULL,

	[ToUserID] [int] NULL,

	[OriginalID] [nvarchar](50) NULL,

	[OpenID] [nvarchar](50) NULL,

	[UnionID] [nvarchar](50) NULL,

	[LoginTime] [datetime] NULL,

	[weixinState] [int] NULL,

 CONSTRAINT [PK_weixinOpenID] 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].[weixinOpenIDToPhone]    Script Date: 2025/4/26 17:45:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[weixinOpenIDToPhone](

	[wxID] [int] IDENTITY(1,1) NOT NULL,

	[weixinOpenID] [nvarchar](100) NULL,

	[UserPhone] [nvarchar](50) NULL,

	[UserName] [nvarchar](50) NULL,

	[LoginTime] [datetime] NULL,

	[weixinState] [int] NULL,

 CONSTRAINT [PK_weixinOpenIDToPhone] PRIMARY KEY CLUSTERED 

(

	[wxID] 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].[weixinQR]    Script Date: 2025/4/26 17:45:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[weixinQR](

	[id] [int] IDENTITY(1,1) NOT NULL,

	[QR_ID] [bigint] NULL,

	[QR_Name] [nvarchar](100) NULL,

	[QR_type] [int] NULL,

	[QR_ticket] [nvarchar](200) NULL,

	[QR_url] [nvarchar](200) NULL,

	[QR_Time] [datetime] NULL,

	[QR_ClickInt] [int] NULL,

	[QR_SubscribeInt] [int] NULL,

	[QR_Key] [nvarchar](50) NULL,

 CONSTRAINT [PK_weixinQR] 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].[weixinUserFormID]    Script Date: 2025/4/26 17:45:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[weixinUserFormID](

	[formID_id] [bigint] IDENTITY(1,1) NOT NULL,

	[formID_detail] [nvarchar](150) NULL,

	[formID_openId] [nvarchar](50) NULL,

	[formID_savetime] [datetime] NULL,

	[formID_UnitID] [int] NULL,

	[formID_UserID] [int] NULL,

	[formID_status] [tinyint] NULL,

	[formID_usetime] [datetime] NULL,

	[formID_SendType] [int] NULL,

 CONSTRAINT [PK_weixinUserFormID] PRIMARY KEY CLUSTERED 

(

	[formID_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

ALTER TABLE [dbo].[API_Json] ADD  CONSTRAINT [DF_API_Json_Json_time]  DEFAULT (getdate()) FOR [Json_time]

GO

ALTER TABLE [dbo].[API_Json] ADD  CONSTRAINT [DF_API_Json_is_Json]  DEFAULT ((0)) FOR [is_Json]

GO

ALTER TABLE [dbo].[API_Json] ADD  CONSTRAINT [DF_API_Json_is_Json_time]  DEFAULT (getdate()) FOR [is_Json_time]

GO

ALTER TABLE [dbo].[CallRecord] ADD  CONSTRAINT [DF_CallRecord_CallRecord_OAUserID]  DEFAULT ((0)) FOR [CallRecord_OAUserID]

GO

ALTER TABLE [dbo].[CallRecord] ADD  CONSTRAINT [DF_CallRecord_CallRecord_StartTime]  DEFAULT (getdate()) FOR [CallRecord_StartTime]

GO

ALTER TABLE [dbo].[CallRecord] ADD  CONSTRAINT [DF_CallRecord_CallRecord_Type]  DEFAULT ((0)) FOR [CallRecord_Type]

GO

ALTER TABLE [dbo].[CallRecord] ADD  CONSTRAINT [DF_CallRecord_CallRecord_OrdState]  DEFAULT ((0)) FOR [CallRecord_OrdClass]

GO

ALTER TABLE [dbo].[CallRecord] ADD  CONSTRAINT [DF_CallRecord_CallRecord_Source]  DEFAULT ((0)) FOR [CallRecord_Source]

GO

ALTER TABLE [dbo].[CallRecord] ADD  CONSTRAINT [DF_CallRecord_CallRecord_InAndOut]  DEFAULT ((0)) FOR [CallRecord_InAndOut]

GO

ALTER TABLE [dbo].[CarData] ADD  CONSTRAINT [DF_CarData_CarState]  DEFAULT ((0)) FOR [CarState]

GO

ALTER TABLE [dbo].[CarData] ADD  CONSTRAINT [DF_CarData_CarTop]  DEFAULT ((1000)) FOR [CarTop]

GO

ALTER TABLE [dbo].[CarGas] ADD  CONSTRAINT [DF_CarGas_GasVolume]  DEFAULT ((0)) FOR [GasVolume]

GO

ALTER TABLE [dbo].[CarGas] ADD  CONSTRAINT [DF_CarGas_GasPrice]  DEFAULT ((0)) FOR [GasPrice]

GO

ALTER TABLE [dbo].[CarGas] ADD  CONSTRAINT [DF_CarGas_GasMacSumPrice]  DEFAULT ((0)) FOR [GasMacSumPrice]

GO

ALTER TABLE [dbo].[CarGas] ADD  CONSTRAINT [DF_CarGas_GasSumPrice]  DEFAULT ((0)) FOR [GasSumPrice]

GO

ALTER TABLE [dbo].[CarGas] ADD  CONSTRAINT [DF_CarGas_OATime]  DEFAULT (getdate()) FOR [OATime]

GO

ALTER TABLE [dbo].[CarGas] ADD  CONSTRAINT [DF_CarGas_GasState]  DEFAULT ((0)) FOR [GasState]

GO

ALTER TABLE [dbo].[CarGas] ADD  CONSTRAINT [DF_CarGas_is_JumpGun]  DEFAULT ((0)) FOR [is_JumpGun]

GO

ALTER TABLE [dbo].[CarGPS] ADD  CONSTRAINT [DF_CarGPS_DataTime]  DEFAULT (getdate()) FOR [DataTime]

GO

ALTER TABLE [dbo].[CarGPS_Milestat] ADD  CONSTRAINT [DF_CarGPS_Milestat_GPS_milestat]  DEFAULT ((0)) FOR [GPS_milestat]

GO

ALTER TABLE [dbo].[CarGPS_Milestat] ADD  CONSTRAINT [DF_CarGPS_Milestat_GPS_outspeed]  DEFAULT ((0)) FOR [GPS_outspeed]

GO

ALTER TABLE [dbo].[CarGPS_Milestat] ADD  CONSTRAINT [DF_CarGPS_Milestat_GPS_outspeedlimit]  DEFAULT ((0)) FOR [GPS_outspeedlimit]

GO

ALTER TABLE [dbo].[CarGPS_Milestat] ADD  CONSTRAINT [DF_CarGPS_Milestat_GPS_stop]  DEFAULT ((0)) FOR [GPS_stop]

GO

ALTER TABLE [dbo].[CarGPS_Milestat] ADD  CONSTRAINT [DF_CarGPS_Milestat_DataTime]  DEFAULT (getdate()) FOR [DataTime]

GO

ALTER TABLE [dbo].[CarIllegal] ADD  CONSTRAINT [DF_CarIllegal_IllegalCarID]  DEFAULT ((0)) FOR [IllegalCarID]

GO

ALTER TABLE [dbo].[CarIllegal] ADD  CONSTRAINT [DF_CarIllegal_is_Payment]  DEFAULT ((0)) FOR [is_Payment]

GO

ALTER TABLE [dbo].[CarIllegal] ADD  CONSTRAINT [DF_CarIllegal_OATime]  DEFAULT (getdate()) FOR [OATime]

GO

ALTER TABLE [dbo].[CarIllegal] ADD  CONSTRAINT [DF_CarIllegal_IllegaState]  DEFAULT ((0)) FOR [IllegalState]

GO

ALTER TABLE [dbo].[CarInspection] ADD  CONSTRAINT [DF_CarInspection_InspectionCarID]  DEFAULT ((0)) FOR [InspectionCarID]

GO

ALTER TABLE [dbo].[CarInspection] ADD  CONSTRAINT [DF_CarInspection_DispatchOrdIDPK]  DEFAULT ((0)) FOR [DispatchOrdIDPK]

GO

ALTER TABLE [dbo].[CarInspection] ADD  CONSTRAINT [DF_CarInspection_InspectionDate]  DEFAULT (getdate()) FOR [InspectionDate]

GO

ALTER TABLE [dbo].[CarInspection] ADD  CONSTRAINT [DF_CarInspection_OAID]  DEFAULT ((0)) FOR [OAID]

GO

ALTER TABLE [dbo].[CarInspection] ADD  CONSTRAINT [DF_CarInspection_OATime]  DEFAULT (getdate()) FOR [OATime]

GO

ALTER TABLE [dbo].[CarInspection] ADD  CONSTRAINT [DF_CarInspection_InspectionState]  DEFAULT ((1)) FOR [InspectionState]

GO

ALTER TABLE [dbo].[CarRepair] ADD  CONSTRAINT [DF_CarRepair_MaintenancePlace]  DEFAULT ((0)) FOR [MaintenancePlace]

GO

ALTER TABLE [dbo].[CarRepair] ADD  CONSTRAINT [DF_CarRepair_UnitPrice]  DEFAULT ((0)) FOR [UnitPrice]

GO

ALTER TABLE [dbo].[CarRepair] ADD  CONSTRAINT [DF_CarRepair_UnitInt]  DEFAULT ((0)) FOR [UnitInt]

GO

ALTER TABLE [dbo].[CarRepair] ADD  CONSTRAINT [DF_CarRepair_MaterialMoney]  DEFAULT ((0)) FOR [MaterialMoney]

GO

ALTER TABLE [dbo].[CarRepair] ADD  CONSTRAINT [DF_CarRepair_ManHourMoney]  DEFAULT ((0)) FOR [ManHourMoney]

GO

ALTER TABLE [dbo].[CarRepair] ADD  CONSTRAINT [DF_CarRepair_OATime]  DEFAULT (getdate()) FOR [OATime]

GO

ALTER TABLE [dbo].[CarRepair] ADD  CONSTRAINT [DF_CarRepair_RepairState]  DEFAULT ((0)) FOR [RepairState]

GO

ALTER TABLE [dbo].[CarStItm] ADD  CONSTRAINT [DF_CarStItm_CarStItmInt]  DEFAULT ((1)) FOR [CarStItmInt]

GO

ALTER TABLE [dbo].[CarStItm] ADD  CONSTRAINT [DF_CarStItm_CarStItmType]  DEFAULT ((0)) FOR [CarStItmType]

GO

ALTER TABLE [dbo].[CarStItm] ADD  CONSTRAINT [DF_CarStItm_CarStItmTop]  DEFAULT ((100)) FOR [CarStItmTop]

GO

ALTER TABLE [dbo].[Coupon] ADD  CONSTRAINT [DF_Coupon_CouponMoney]  DEFAULT ((0)) FOR [CouponMoney]

GO

ALTER TABLE [dbo].[Coupon] ADD  CONSTRAINT [DF_Coupon_CouponDate]  DEFAULT (getdate()) FOR [CouponDate]

GO

ALTER TABLE [dbo].[Coupon] ADD  CONSTRAINT [DF_Coupon_CouponDate_Ent]  DEFAULT (getdate()+(1)) FOR [CouponDate_Ent]

GO

ALTER TABLE [dbo].[Coupon] ADD  CONSTRAINT [DF_Coupon_CouponState]  DEFAULT ((0)) FOR [CouponState]

GO

ALTER TABLE [dbo].[Coupon] ADD  CONSTRAINT [DF_Coupon_CouponOrdID]  DEFAULT ((0)) FOR [ServiceOrdIDPK]

GO

ALTER TABLE [dbo].[Coupon] ADD  CONSTRAINT [DF_Coupon_ToUserID]  DEFAULT ((0)) FOR [ToUserID]

GO

ALTER TABLE [dbo].[Coupon] ADD  CONSTRAINT [DF_Coupon_ToOAid]  DEFAULT ((0)) FOR [ToOAid]

GO

ALTER TABLE [dbo].[dictionary] ADD  CONSTRAINT [DF_dictionary_vID]  DEFAULT ((0)) FOR [vID]

GO

ALTER TABLE [dbo].[DispatchOrd] ADD  CONSTRAINT [DF_DispatchOrd_ServiceOrdIDDt]  DEFAULT ((0)) FOR [ServiceOrdIDDt]

GO

ALTER TABLE [dbo].[DispatchOrd] ADD  CONSTRAINT [DF_DispatchOrd_DispatchOrdState]  DEFAULT ((0)) FOR [DispatchOrdState]

GO

ALTER TABLE [dbo].[DispatchOrd] ADD  CONSTRAINT [DF_DispatchOrd_StateInt]  DEFAULT ((0)) FOR [StateInt]

GO

ALTER TABLE [dbo].[DispatchOrd] ADD  CONSTRAINT [DF_DispatchOrd_DispatchOrdStartDate]  DEFAULT (getdate()) FOR [DispatchOrdStartDate]

GO

ALTER TABLE [dbo].[DispatchOrd] ADD  CONSTRAINT [DF_Table_1_ServiceOrd_AP_Check]  DEFAULT ((0)) FOR [DispatchOrd_AP_Check]

GO

ALTER TABLE [dbo].[DispatchOrd] ADD  CONSTRAINT [DF_DispatchOrd_DispatchOrdTraStreetMileage]  DEFAULT ((0)) FOR [DispatchOrdTraStreetMileage]

GO

ALTER TABLE [dbo].[DispatchOrd] ADD  CONSTRAINT [DF_DispatchOrd_DispatchOrdTraEndMileage]  DEFAULT ((0)) FOR [DispatchOrdTraEndMileage]

GO

ALTER TABLE [dbo].[DispatchOrd] ADD  CONSTRAINT [DF_DispatchOrd_DispatchOrdMileage]  DEFAULT ((0)) FOR [DispatchOrdMileage]

GO

ALTER TABLE [dbo].[DispatchOrd] ADD  CONSTRAINT [DF_DispatchOrd_DispatchOrdGasoline]  DEFAULT ((0)) FOR [DispatchOrdGasoline]

GO

ALTER TABLE [dbo].[DispatchOrd] ADD  CONSTRAINT [DF_DispatchOrd_DispatchOrdLuqiaoFee]  DEFAULT ((0)) FOR [DispatchOrdLuqiaoFee]

GO

ALTER TABLE [dbo].[DispatchOrd] ADD  CONSTRAINT [DF_DispatchOrd_DispatchOrdGasolineFee]  DEFAULT ((0)) FOR [DispatchOrdGasolineFee]

GO

ALTER TABLE [dbo].[DispatchOrd] ADD  CONSTRAINT [DF_DispatchOrd_DispatchOrdTravelFee]  DEFAULT ((0)) FOR [DispatchOrdTravelFee]

GO

ALTER TABLE [dbo].[DispatchOrd] ADD  CONSTRAINT [DF_DispatchOrd_DispatchOrdOtherFee]  DEFAULT ((0)) FOR [DispatchOrdOtherFee]

GO

ALTER TABLE [dbo].[DispatchOrd] ADD  CONSTRAINT [DF_DispatchOrd_DispatchOrdIsEnd]  DEFAULT ((0)) FOR [DispatchOrdIsEnd]

GO

ALTER TABLE [dbo].[DispatchOrd] ADD  CONSTRAINT [DF_DispatchOrd_DispatchOrdNo]  DEFAULT ((1)) FOR [DispatchOrdNo]

GO

ALTER TABLE [dbo].[DispatchOrd] ADD  CONSTRAINT [DF_DispatchOrd_StretcherMoney]  DEFAULT ((0)) FOR [StretcherMoney]

GO

ALTER TABLE [dbo].[DispatchOrd] ADD  CONSTRAINT [DF_DispatchOrd_DispatchOrdPicUrl]  DEFAULT (N'0') FOR [DispatchOrdPicUrl]

GO

ALTER TABLE [dbo].[DispatchOrd] ADD  CONSTRAINT [DF_DispatchOrd_TimeLength_Program]  DEFAULT ((0)) FOR [TimeLength_Program]

GO

ALTER TABLE [dbo].[DispatchOrd] ADD  CONSTRAINT [DF_DispatchOrd_TimeLength_ICU]  DEFAULT ((0)) FOR [TimeLength_ICU]

GO

ALTER TABLE [dbo].[DispatchOrd] ADD  CONSTRAINT [DF_DispatchOrd_TimeLength_Wait]  DEFAULT ((0)) FOR [TimeLength_Wait]

GO

ALTER TABLE [dbo].[DispatchOrd] ADD  CONSTRAINT [DF_DispatchOrd_DispatchDoctor]  DEFAULT ((0)) FOR [DispatchDoctor]

GO

ALTER TABLE [dbo].[DispatchOrd] ADD  CONSTRAINT [DF_DispatchOrd_DispatchNurse]  DEFAULT ((0)) FOR [DispatchNurse]

GO

ALTER TABLE [dbo].[DispatchOrd] ADD  CONSTRAINT [DF_DispatchOrd_DispatchDriver]  DEFAULT ((0)) FOR [DispatchDriver]

GO

ALTER TABLE [dbo].[DispatchOrd] ADD  CONSTRAINT [DF_DispatchOrd_DispatchOrdUserUpdateOAid]  DEFAULT ((0)) FOR [DispatchOrdUpdateOAid]

GO

ALTER TABLE [dbo].[DispatchOrd] ADD  CONSTRAINT [DF_DispatchOrd_DispatchOrdUserUpdateTime]  DEFAULT (getdate()) FOR [DispatchOrdUpdateTime]

GO

ALTER TABLE [dbo].[DispatchOrd] ADD  CONSTRAINT [DF_DispatchOrd_DispatchEmployeeGroup]  DEFAULT ((0)) FOR [DispatchEmployeeGroup]

GO

ALTER TABLE [dbo].[DispatchOrd] ADD  CONSTRAINT [DF__DispatchO__Dispa__2BF46805]  DEFAULT ((-1)) FOR [DispatchOrd_FA_Check]

GO

ALTER TABLE [dbo].[DispatchOrd] ADD  CONSTRAINT [DF_DispatchOrd_IsLocking]  DEFAULT ((0)) FOR [IsLocking]

GO

ALTER TABLE [dbo].[DispatchOrd_Entourage] ADD  CONSTRAINT [DF_DispatchOrd_Entourage_DispatchOrdIDDt]  DEFAULT ((0)) FOR [DispatchOrdIDDt]

GO

ALTER TABLE [dbo].[DispatchOrd_Entourage] ADD  CONSTRAINT [DF_DispatchOrd_Entourage_EntourageState]  DEFAULT ((0)) FOR [EntourageState]

GO

ALTER TABLE [dbo].[DispatchOrd_Entourage] ADD  CONSTRAINT [DF_DispatchOrd_Entourage_EntourageLead]  DEFAULT ((0)) FOR [EntourageLead]

GO

ALTER TABLE [dbo].[DispatchOrd_Entourage] ADD  CONSTRAINT [DF_DispatchOrd_Entourage_EntourageOT_is]  DEFAULT ((0)) FOR [EntourageOT_is]

GO

ALTER TABLE [dbo].[DispatchOrd_Entourage] ADD  CONSTRAINT [DF_DispatchOrd_Entourage_EntourageOT2_is]  DEFAULT ((0)) FOR [EntourageOT2_is]

GO

ALTER TABLE [dbo].[DispatchOrd_Entourage] ADD  CONSTRAINT [DF_DispatchOrd_Entourage_EntourageLong_is]  DEFAULT ((0)) FOR [EntourageLong_is]

GO

ALTER TABLE [dbo].[DispatchOrd_Entourage] ADD  CONSTRAINT [DF_DispatchOrd_Entourage_EntourageBetimesHH]  DEFAULT ((0)) FOR [EntourageBetimesHH]

GO

ALTER TABLE [dbo].[DispatchOrd_Entourage] ADD  CONSTRAINT [DF_DispatchOrd_Entourage_EntourageDKP]  DEFAULT ((0)) FOR [EntourageDKP]

GO

ALTER TABLE [dbo].[DispatchOrd_Entourage] ADD  CONSTRAINT [DF_DispatchOrd_Entourage_EntourageDKPScale]  DEFAULT ((0)) FOR [EntourageDKPScale]

GO

ALTER TABLE [dbo].[DispatchOrd_Entourage] ADD  CONSTRAINT [DF_DispatchOrd_Entourage_Check_is]  DEFAULT ((1)) FOR [Check_is]

GO

ALTER TABLE [dbo].[DispatchOrd_Entourage] ADD  CONSTRAINT [DF_DispatchOrd_Entourage_Stretcher_is]  DEFAULT ((0)) FOR [Stretcher_is]

GO

ALTER TABLE [dbo].[DispatchOrd_Entourage] ADD  CONSTRAINT [DF_DispatchOrd_Entourage_Guest_Point]  DEFAULT ((0)) FOR [Guest_PointE]

GO

ALTER TABLE [dbo].[DispatchOrd_Entourage] ADD  CONSTRAINT [DF_DispatchOrd_Entourage_Guest_Point_1]  DEFAULT ((0)) FOR [Guest_Point_1]

GO

ALTER TABLE [dbo].[DispatchOrd_Entourage] ADD  CONSTRAINT [DF_DispatchOrd_Entourage_Guest_Point_2]  DEFAULT ((0)) FOR [Guest_Point_2]

GO

ALTER TABLE [dbo].[DispatchOrd_Entourage] ADD  CONSTRAINT [DF_DispatchOrd_Entourage_Guest_Point_3]  DEFAULT ((0)) FOR [Guest_Point_3]

GO

ALTER TABLE [dbo].[DispatchOrd_Entourage] ADD  CONSTRAINT [DF_DispatchOrd_Entourage_RV_PointE]  DEFAULT ((0)) FOR [RV_PointE]

GO

ALTER TABLE [dbo].[DispatchOrd_Entourage] ADD  CONSTRAINT [DF_DispatchOrd_Entourage_RV_Point_1]  DEFAULT ((0)) FOR [RV_Point_1]

GO

ALTER TABLE [dbo].[DispatchOrd_Entourage] ADD  CONSTRAINT [DF_DispatchOrd_Entourage_RV_Point_2]  DEFAULT ((0)) FOR [RV_Point_2]

GO

ALTER TABLE [dbo].[DispatchOrd_Entourage] ADD  CONSTRAINT [DF_DispatchOrd_Entourage_RV_Point_3]  DEFAULT ((0)) FOR [RV_Point_3]

GO

ALTER TABLE [dbo].[DispatchOrd_Entourage] ADD  CONSTRAINT [DF_DispatchOrd_Entourage_MileageFactor]  DEFAULT ((1)) FOR [EntourageMileageFactor]

GO

ALTER TABLE [dbo].[DispatchOrd_Entourage] ADD  CONSTRAINT [DF_DispatchOrd_Entourage_EntourageP1]  DEFAULT ((0)) FOR [EntourageP1]

GO

ALTER TABLE [dbo].[DispatchOrd_Entourage] ADD  CONSTRAINT [DF_DispatchOrd_Entourage_Condition_is]  DEFAULT ((0)) FOR [Condition_is]

GO

ALTER TABLE [dbo].[DispatchOrd_Entourage] ADD  CONSTRAINT [DF_DispatchOrd_Entourage_ConversionDistance]  DEFAULT ((0)) FOR [ConversionDistance]

GO

ALTER TABLE [dbo].[DispatchOrd_Entourage] ADD  CONSTRAINT [DF_DispatchOrd_Entourage_EntourageOT_Money]  DEFAULT ((0)) FOR [EntourageOT_Money]

GO

ALTER TABLE [dbo].[DispatchOrd_Entourage] ADD  CONSTRAINT [DF_DispatchOrd_Entourage_Stretcher_Money]  DEFAULT ((0)) FOR [Stretcher_Money]

GO

ALTER TABLE [dbo].[DispatchOrd_Entourage] ADD  CONSTRAINT [DF_DispatchOrd_Entourage_Condition_Money]  DEFAULT ((0)) FOR [Condition_Money]

GO

ALTER TABLE [dbo].[DispatchOrd_Entourage] ADD  CONSTRAINT [DF_DispatchOrd_Entourage_Entourage_Time]  DEFAULT (getdate()) FOR [Entourage_Time]

GO

ALTER TABLE [dbo].[DispatchOrd_Equipment] ADD  CONSTRAINT [DF_DispatchOrd_Equipment_DispatchOrdIDDt]  DEFAULT ((0)) FOR [DispatchOrdIDDt]

GO

ALTER TABLE [dbo].[DispatchOrd_Equipment] ADD  CONSTRAINT [DF_DispatchOrd_Equipment_EquipmentOAid]  DEFAULT ((0)) FOR [EquipmentOAid]

GO

ALTER TABLE [dbo].[DispatchOrd_Equipment] ADD  CONSTRAINT [DF_DispatchOrd_Equipment_EquipmentTime]  DEFAULT (getdate()) FOR [EquipmentTime]

GO

ALTER TABLE [dbo].[DispatchOrd_Equipment2] ADD  CONSTRAINT [DF_DispatchOrd_Equipment2_strItmIDPK]  DEFAULT ((0)) FOR [strItmIDPK]

GO

ALTER TABLE [dbo].[DispatchOrd_Equipment2] ADD  CONSTRAINT [DF_DispatchOrd_Equipment2_EquipmentPurchasePrice]  DEFAULT ((0)) FOR [EquipmentPurchasePrice]

GO

ALTER TABLE [dbo].[DispatchOrd_Equipment2] ADD  CONSTRAINT [DF_DispatchOrd_Equipment2_EquipmentOAid]  DEFAULT ((0)) FOR [EquipmentOAid]

GO

ALTER TABLE [dbo].[DispatchOrd_Equipment2] ADD  CONSTRAINT [DF_DispatchOrd_Equipment2_EquipmentTime]  DEFAULT (getdate()) FOR [EquipmentTime]

GO

ALTER TABLE [dbo].[DispatchOrd_Hotel] ADD  CONSTRAINT [DF_DispatchOrd_Hotel_HotelDate]  DEFAULT (getdate()) FOR [HotelDate]

GO

ALTER TABLE [dbo].[DispatchOrd_Hotel] ADD  CONSTRAINT [DF_DispatchOrd_Hotel_HotelPrice]  DEFAULT ((0)) FOR [HotelPrice]

GO

ALTER TABLE [dbo].[DispatchOrd_Hotel] ADD  CONSTRAINT [DF_DispatchOrd_Hotel_OA_Time]  DEFAULT (getdate()) FOR [Hotel_OATime]

GO

ALTER TABLE [dbo].[DispatchOrd_Running] ADD  CONSTRAINT [DF_DispatchOrd_Running_DispatchOrdState]  DEFAULT ((0)) FOR [DispatchOrdState]

GO

ALTER TABLE [dbo].[DispatchOrd_Running] ADD  CONSTRAINT [DF_DispatchOrd_Running_DispatchOrdStartDate]  DEFAULT (getdate()) FOR [DispatchOrdStartDate]

GO

ALTER TABLE [dbo].[DispatchOrd_Running] ADD  CONSTRAINT [DF_DispatchOrd_Running_DispatchOrdStartOA]  DEFAULT ((0)) FOR [DispatchOrdStartOA]

GO

ALTER TABLE [dbo].[DispatchOrd_Running] ADD  CONSTRAINT [DF_DispatchOrd_Running_OA_latitude]  DEFAULT ((0)) FOR [OA_latitude]

GO

ALTER TABLE [dbo].[DispatchOrd_Running] ADD  CONSTRAINT [DF_DispatchOrd_Running_OA_longitude]  DEFAULT ((0)) FOR [OA_longitude]

GO

ALTER TABLE [dbo].[DispatchOrd_StItm] ADD  CONSTRAINT [DF_DispatchOrd_StItm_DispatchStItmTime]  DEFAULT (getdate()) FOR [DispatchStItmTime]

GO

ALTER TABLE [dbo].[dwzURL] ADD  CONSTRAINT [DF_dwzURL_nTime]  DEFAULT (getdate()) FOR [nTime]

GO

ALTER TABLE [dbo].[HospData] ADD  CONSTRAINT [DF_HospData_HospUnitID]  DEFAULT ((0)) FOR [HospUnitID]

GO

ALTER TABLE [dbo].[HospData] ADD  CONSTRAINT [DF_Hosp_HospState]  DEFAULT ((1)) FOR [HospState]

GO

ALTER TABLE [dbo].[HospData] ADD  CONSTRAINT [DF_HospData_HospLevel]  DEFAULT ((0)) FOR [HospLevel]

GO

ALTER TABLE [dbo].[ICD10] ADD  CONSTRAINT [DF_ICD10_ICDState]  DEFAULT ((1)) FOR [ICDState]

GO

ALTER TABLE [dbo].[ImageData] ADD  CONSTRAINT [DF_ImageData_ImageType]  DEFAULT ((0)) FOR [ImageType]

GO

ALTER TABLE [dbo].[ImageData] ADD  CONSTRAINT [DF_ImageData_ImageDeg]  DEFAULT ((0)) FOR [ImageDeg]

GO

ALTER TABLE [dbo].[ImageData] ADD  CONSTRAINT [DF_Table_1_ImageTime]  DEFAULT (getdate()) FOR [UpImageTime]

GO

ALTER TABLE [dbo].[ImageData] ADD  CONSTRAINT [DF_ImageData_UpImageOAid]  DEFAULT ((0)) FOR [UpImageOAid]

GO

ALTER TABLE [dbo].[ImageData] ADD  CONSTRAINT [DF_ImageData_ImageDel]  DEFAULT ((0)) FOR [ImageDel]

GO

ALTER TABLE [dbo].[ImageData] ADD  CONSTRAINT [DF_ImageData_isAP]  DEFAULT ((0)) FOR [isAP]

GO

ALTER TABLE [dbo].[IntroducerData] ADD  CONSTRAINT [DF_IntroducerData_IntroducerUnitID]  DEFAULT ((0)) FOR [IntroducerUnitID]

GO

ALTER TABLE [dbo].[IntroducerData] ADD  CONSTRAINT [DF_IntroducerData_IntroducerState]  DEFAULT ((1)) FOR [IntroducerState]

GO

ALTER TABLE [dbo].[IntroducerData] ADD  CONSTRAINT [DF_IntroducerData_IntroducerAdminDate]  DEFAULT (getdate()) FOR [IntroducerAdminDate]

GO

ALTER TABLE [dbo].[IntroducerRegion] ADD  CONSTRAINT [DF_IntroducerRegion_IRUnitID]  DEFAULT ((0)) FOR [IRUnitID]

GO

ALTER TABLE [dbo].[IntroducerRegion] ADD  CONSTRAINT [DF_IntroducerRegion_IRPrice]  DEFAULT ((0)) FOR [IRPrice]

GO

ALTER TABLE [dbo].[IntroducerRegion] ADD  CONSTRAINT [DF_IntroducerRegion_IRNursingLevel]  DEFAULT ((0)) FOR [IRNursingLevel]

GO

ALTER TABLE [dbo].[IntroducerRegion] ADD  CONSTRAINT [DF_IntroducerRegion_IRPrice1]  DEFAULT ((0)) FOR [IRPrice1]

GO

ALTER TABLE [dbo].[IntroducerRegion] ADD  CONSTRAINT [DF_IntroducerRegion_IRPrice2]  DEFAULT ((0)) FOR [IRPrice2]

GO

ALTER TABLE [dbo].[IntroducerRegion] ADD  CONSTRAINT [DF_IntroducerRegion_IRPrice3]  DEFAULT ((0)) FOR [IRPrice3]

GO

ALTER TABLE [dbo].[IntroducerRegion] ADD  CONSTRAINT [DF_IntroducerRegion_IRlimit1]  DEFAULT ((0)) FOR [IRlimit1]

GO

ALTER TABLE [dbo].[IntroducerRegion] ADD  CONSTRAINT [DF_IntroducerRegion_IRlimit2]  DEFAULT ((0)) FOR [IRlimit2]

GO

ALTER TABLE [dbo].[IntroducerRegion] ADD  CONSTRAINT [DF_IntroducerRegion_IRlimit3]  DEFAULT ((0)) FOR [IRlimit3]

GO

ALTER TABLE [dbo].[IntroducerRegion] ADD  CONSTRAINT [DF_IntroducerRegion_IRVentilatorCost]  DEFAULT ((0)) FOR [IRVentilatorCost]

GO

ALTER TABLE [dbo].[IntroducerRegion] ADD  CONSTRAINT [DF_IntroducerRegion_iRWarmBoxCost]  DEFAULT ((0)) FOR [IRWarmBoxCost]

GO

ALTER TABLE [dbo].[IntroducerRegion] ADD  CONSTRAINT [DF_IntroducerRegion_IRLiftingCost]  DEFAULT ((0)) FOR [IRLiftingCost]

GO

ALTER TABLE [dbo].[IntroducerRegion] ADD  CONSTRAINT [DF_IntroducerRegion_IRWaitingCost]  DEFAULT ((0)) FOR [IRWaitingCost]

GO

ALTER TABLE [dbo].[IntroducerRegion] ADD  CONSTRAINT [DF_IntroducerRegion_IRFerryCost]  DEFAULT ((0)) FOR [IRFerryCost]

GO

ALTER TABLE [dbo].[IntroducerRegion] ADD  CONSTRAINT [DF_IntroducerRegion_IRState]  DEFAULT ((0)) FOR [IRState]

GO

ALTER TABLE [dbo].[IntroducerRegion] ADD  CONSTRAINT [DF_IntroducerRegion_IRwxState]  DEFAULT ((0)) FOR [IRwxState]

GO

ALTER TABLE [dbo].[IntroducerRegion] ADD  CONSTRAINT [DF_IntroducerRegion_Unitlimit]  DEFAULT ((0)) FOR [Unitlimit]

GO

ALTER TABLE [dbo].[IntroducerRegion] ADD  CONSTRAINT [DF_IntroducerRegion_UnitPrice]  DEFAULT ((0)) FOR [UnitPrice]

GO

ALTER TABLE [dbo].[IntroducerRegionDt] ADD  CONSTRAINT [DF_IntroducerRegionDt_IRDt_id]  DEFAULT ((0)) FOR [IRDt_id]

GO

ALTER TABLE [dbo].[IntroducerRegionDt] ADD  CONSTRAINT [DF_Table_1_IRPrice]  DEFAULT ((0)) FOR [IRDtPrice]

GO

ALTER TABLE [dbo].[IntroducerRegionDt] ADD  CONSTRAINT [DF_Table_1_IRlimit]  DEFAULT ((0)) FOR [IRDtlimit]

GO

ALTER TABLE [dbo].[IntroducerUnitData] ADD  CONSTRAINT [DF_IntroducerUnit_UnitState]  DEFAULT ((1)) FOR [UnitState]

GO

ALTER TABLE [dbo].[IntroducerUnitData] ADD  CONSTRAINT [DF_IntroducerUnitData_is_test]  DEFAULT ((0)) FOR [is_test]

GO

ALTER TABLE [dbo].[IntroducerUnitData] ADD  CONSTRAINT [DF_IntroducerUnitData_wx_access_tokenTime]  DEFAULT ('2019-1-1') FOR [wx_access_tokenTime]

GO

ALTER TABLE [dbo].[IntroducerUnitData] ADD  CONSTRAINT [DF_IntroducerUnitData_wx_jsapi_ticketTime]  DEFAULT ('2019-1-1') FOR [wx_jsapi_ticketTime]

GO

ALTER TABLE [dbo].[IntroducerUnitData] ADD  CONSTRAINT [DF_IntroducerUnitData_wxcx_access_tokenTime]  DEFAULT ('2019-1-1') FOR [wxcx_access_tokenTime]

GO

ALTER TABLE [dbo].[IntroducerUnitData] ADD  CONSTRAINT [DF_IntroducerUnitData_wxcx_jsapi_ticketTime]  DEFAULT ('2019-1-1') FOR [wxcx_jsapi_ticketTime]

GO

ALTER TABLE [dbo].[IntroducerUnitData] ADD  CONSTRAINT [DF_IntroducerUnitData_ServiceMinCost]  DEFAULT ((200)) FOR [ServiceMinPrice]

GO

ALTER TABLE [dbo].[IntroducerUnitData] ADD  CONSTRAINT [DF_IntroducerUnitData_ServiceUnitPrice]  DEFAULT ((10)) FOR [ServiceUnitPrice]

GO

ALTER TABLE [dbo].[IntroducerUnitData] ADD  CONSTRAINT [DF_IntroducerUnitData_ServiceLong]  DEFAULT ((250)) FOR [ServiceLong]

GO

ALTER TABLE [dbo].[IntroducerUnitData] ADD  CONSTRAINT [DF_IntroducerUnitData_ServiceAddress_lat]  DEFAULT ((0)) FOR [ServiceAddress_lat]

GO

ALTER TABLE [dbo].[IntroducerUnitData] ADD  CONSTRAINT [DF_IntroducerUnitData_ServiceAddress_lng]  DEFAULT ((0)) FOR [ServiceAddress_lng]

GO

ALTER TABLE [dbo].[IntroducerUnitData] ADD  DEFAULT ((1)) FOR [OrdDateMode]

GO

ALTER TABLE [dbo].[InvoiceData] ADD  CONSTRAINT [DF_InvoiceData_ServiceOrderIDPK]  DEFAULT ((0)) FOR [ServiceOrderIDPK]

GO

ALTER TABLE [dbo].[InvoiceData] ADD  CONSTRAINT [DF_InvoiceData_InvoiceType]  DEFAULT ((0)) FOR [InvoiceType]

GO

ALTER TABLE [dbo].[InvoiceData] ADD  CONSTRAINT [DF_InvoiceData_ApplicationTime]  DEFAULT (getdate()) FOR [ApplicationTime]

GO

ALTER TABLE [dbo].[InvoiceData] ADD  CONSTRAINT [DF_InvoiceData_AuditStatus]  DEFAULT ((0)) FOR [AuditStatus]

GO

ALTER TABLE [dbo].[InvoiceData] ADD  CONSTRAINT [DF__InvoiceDa__Audit__2DDCB077]  DEFAULT ((0)) FOR [AuditOAID]

GO

ALTER TABLE [dbo].[InvoiceData] ADD  CONSTRAINT [DF_InvoiceData_AuditMoney]  DEFAULT ((0)) FOR [InvoiceMoney]

GO

ALTER TABLE [dbo].[InvoiceData] ADD  CONSTRAINT [DF__InvoiceDa__Apply__2ED0D4B0]  DEFAULT ((0)) FOR [ApplyOAID]

GO

ALTER TABLE [dbo].[MRP_OrderApply] ADD  CONSTRAINT [DF_MRP_OrderSale_OrderTime]  DEFAULT (getdate()) FOR [OrderTime]

GO

ALTER TABLE [dbo].[MRP_OrderApply] ADD  CONSTRAINT [DF_MRP_OrderSale_TotalMoney]  DEFAULT ((0)) FOR [TotalMoney]

GO

ALTER TABLE [dbo].[MRP_OrderApply] ADD  CONSTRAINT [DF_MRP_OrderSale_TotalQty]  DEFAULT ((0)) FOR [TotalQty]

GO

ALTER TABLE [dbo].[MRP_OrderDetail] ADD  CONSTRAINT [DF_MRP_OrderDetail_OD_Qty]  DEFAULT ((0)) FOR [OD_Qty]

GO

ALTER TABLE [dbo].[MRP_OrderDetail] ADD  CONSTRAINT [DF_MRP_OrderDetail_OD_QtyA]  DEFAULT ((0)) FOR [OD_QtyA]

GO

ALTER TABLE [dbo].[MRP_OrderDetail] ADD  CONSTRAINT [DF_MRP_OrderDetail_OD_Price]  DEFAULT ((0)) FOR [OD_Price]

GO

ALTER TABLE [dbo].[MRP_OrderManoeuvre] ADD  CONSTRAINT [DF_MRP_OrderManoeuvre_OrderState]  DEFAULT ((0)) FOR [OrderState]

GO

ALTER TABLE [dbo].[MRP_OrderManoeuvre] ADD  CONSTRAINT [DF_MRP_OrderManoeuvre_OrderTime]  DEFAULT (getdate()) FOR [OrderTime]

GO

ALTER TABLE [dbo].[MRP_OrderManoeuvre] ADD  CONSTRAINT [DF_MRP_OrderManoeuvre_TotalMoney]  DEFAULT ((0)) FOR [TotalMoney]

GO

ALTER TABLE [dbo].[MRP_OrderManoeuvre] ADD  CONSTRAINT [DF_MRP_OrderManoeuvre_TotalQty]  DEFAULT ((0)) FOR [TotalQty]

GO

ALTER TABLE [dbo].[MRP_OrderPurchase] ADD  CONSTRAINT [DF_MRP_OrderPurchase_OrderState]  DEFAULT ((0)) FOR [OrderState]

GO

ALTER TABLE [dbo].[MRP_OrderPurchase] ADD  CONSTRAINT [DF_MRP_OrderPurchase_OrderTime]  DEFAULT (getdate()) FOR [OrderTime]

GO

ALTER TABLE [dbo].[MRP_OrderPurchase] ADD  CONSTRAINT [DF_MRP_OrderPurchase_TotalMoney]  DEFAULT ((0)) FOR [TotalMoney]

GO

ALTER TABLE [dbo].[MRP_OrderPurchase] ADD  CONSTRAINT [DF_MRP_OrderPurchase_TotalQty]  DEFAULT ((0)) FOR [TotalQty]

GO

ALTER TABLE [dbo].[MRP_OrderSale] ADD  CONSTRAINT [DF_MRP_OrderSale_OrderTime_1]  DEFAULT (getdate()) FOR [OrderTime]

GO

ALTER TABLE [dbo].[MRP_OrderSale] ADD  CONSTRAINT [DF_MRP_OrderSale_TotalMoney_1]  DEFAULT ((0)) FOR [TotalMoney]

GO

ALTER TABLE [dbo].[MRP_OrderSale] ADD  CONSTRAINT [DF_MRP_OrderSale_TotalQty_1]  DEFAULT ((0)) FOR [TotalQty]

GO

ALTER TABLE [dbo].[MRP_OrderStockAdjust] ADD  CONSTRAINT [DF_MRP_OrderStockAdjust_OrderState]  DEFAULT ((0)) FOR [OrderState]

GO

ALTER TABLE [dbo].[MRP_OrderStockAdjust] ADD  CONSTRAINT [DF_MRP_OrderStockAdjust_OrderTime]  DEFAULT (getdate()) FOR [OrderTime]

GO

ALTER TABLE [dbo].[MRP_OrderStockAdjust] ADD  CONSTRAINT [DF_MRP_OrderStockAdjust_TotalMoney]  DEFAULT ((0)) FOR [TotalMoney]

GO

ALTER TABLE [dbo].[MRP_OrderStockAdjust] ADD  CONSTRAINT [DF_MRP_OrderStockAdjust_TotalQty]  DEFAULT ((0)) FOR [TotalQty]

GO

ALTER TABLE [dbo].[MRP_Stock] ADD  CONSTRAINT [DF_MRP_Stock_StockQty]  DEFAULT ((0)) FOR [StockQty]

GO

ALTER TABLE [dbo].[MRP_Stock] ADD  CONSTRAINT [DF_MRP_Stock_StockTime]  DEFAULT (getdate()) FOR [StockTime]

GO

ALTER TABLE [dbo].[MRP_Supplier] ADD  CONSTRAINT [DF_MRP_Supplier_SupplierState]  DEFAULT ((0)) FOR [SupplierState]

GO

ALTER TABLE [dbo].[MRP_Warehouse] ADD  CONSTRAINT [DF_MRP_Warehouse_WarehouseType]  DEFAULT ((1)) FOR [WarehouseType]

GO

ALTER TABLE [dbo].[MRP_WarehouseShelves] ADD  CONSTRAINT [DF_MRP_WarehouseShelves_ShelvesID]  DEFAULT ((0)) FOR [ShelvesID]

GO

ALTER TABLE [dbo].[MRP_WarehouseShelves] ADD  CONSTRAINT [DF_MRP_WarehouseShelves_ItmID]  DEFAULT ((0)) FOR [ItmID]

GO

ALTER TABLE [dbo].[MRP_WarehouseShelves] ADD  CONSTRAINT [DF_MRP_WarehouseShelves_isShelves]  DEFAULT ((1)) FOR [isShelves]

GO

ALTER TABLE [dbo].[Notification] ADD  CONSTRAINT [DF_Notification_NC_OAID]  DEFAULT ((0)) FOR [NC_OAID]

GO

ALTER TABLE [dbo].[Notification] ADD  CONSTRAINT [DF_Notification_NC_Time]  DEFAULT (getdate()) FOR [NC_Time]

GO

ALTER TABLE [dbo].[Notification] ADD  CONSTRAINT [DF_Notification_NC_Read]  DEFAULT ((0)) FOR [NC_Read]

GO

ALTER TABLE [dbo].[Notification] ADD  CONSTRAINT [DF_Notification_NC_ReadOAID]  DEFAULT ((0)) FOR [NC_ReadOAID]

GO

ALTER TABLE [dbo].[OA_CheckinData] ADD  CONSTRAINT [DF_OA_CheckinData_update_time]  DEFAULT (getdate()) FOR [update_time]

GO

ALTER TABLE [dbo].[OA_NucleicAcid] ADD  CONSTRAINT [DF_Table_1_NucleicAcidTime]  DEFAULT (getdate()) FOR [NucleicAcid_Time]

GO

ALTER TABLE [dbo].[OA_NucleicAcid] ADD  CONSTRAINT [DF_OA_NucleicAcid_NucleicAcidUpTime]  DEFAULT (getdate()) FOR [NucleicAcidUpTime]

GO

ALTER TABLE [dbo].[OA_Running] ADD  CONSTRAINT [DF_OA_Running1_OA_Time]  DEFAULT (getdate()) FOR [OA_Time]

GO

ALTER TABLE [dbo].[OA_Schedules] ADD  CONSTRAINT [DF_OA_Schedules_SchedulesShiftTOP]  DEFAULT ((1)) FOR [SchedulesShiftTOP]

GO

ALTER TABLE [dbo].[OA_Schedules] ADD  CONSTRAINT [DF_OA_Schedules_SchedulesShiftSum]  DEFAULT ((0)) FOR [SchedulesShiftSum]

GO

ALTER TABLE [dbo].[OA_Schedules] ADD  CONSTRAINT [DF_OA_Schedules_SchedulesOrders]  DEFAULT ((0)) FOR [SchedulesOrders]

GO

ALTER TABLE [dbo].[OA_Schedules] ADD  CONSTRAINT [DF_OA_Schedules_SchedulesTypeManeuver]  DEFAULT ((2)) FOR [SchedulesTypeManeuver]

GO

ALTER TABLE [dbo].[OA_Schedules] ADD  CONSTRAINT [DF_OA_Schedules_SchedulesTypeAM]  DEFAULT ((0)) FOR [SchedulesTypeAM]

GO

ALTER TABLE [dbo].[OA_Schedules] ADD  CONSTRAINT [DF_OA_Schedules_SchedulesTypePM]  DEFAULT ((0)) FOR [SchedulesTypePM]

GO

ALTER TABLE [dbo].[OA_Sterilize] ADD  CONSTRAINT [DF_OA_Sterilize_Sterilize_OAID]  DEFAULT ((0)) FOR [Sterilize_OAID]

GO

ALTER TABLE [dbo].[OA_Sterilize] ADD  CONSTRAINT [DF_OA_Sterilize_Sterilize_DispatchOrdID]  DEFAULT ((0)) FOR [Sterilize_DispatchOrdID]

GO

ALTER TABLE [dbo].[OA_Sterilize] ADD  CONSTRAINT [DF_OA_Sterilize_Sterilize_Time]  DEFAULT (getdate()) FOR [Sterilize_Time]

GO

ALTER TABLE [dbo].[OA_Sterilize] ADD  CONSTRAINT [DF_OA_Sterilize_SterilizeUPTime]  DEFAULT (getdate()) FOR [SterilizeUPTime]

GO

ALTER TABLE [dbo].[OA_Sterilize] ADD  CONSTRAINT [DF_OA_Sterilize_SterilizeUPOAID]  DEFAULT ((0)) FOR [SterilizeUPOAID]

GO

ALTER TABLE [dbo].[OA_User] ADD  CONSTRAINT [DF_OA_User_OA_DepartmentID]  DEFAULT ((0)) FOR [OA_DepartmentID]

GO

ALTER TABLE [dbo].[OA_User] ADD  CONSTRAINT [DF_OA_User_OA_gender]  DEFAULT ((0)) FOR [OA_gender]

GO

ALTER TABLE [dbo].[OA_User] ADD  CONSTRAINT [DF_OA_User_OA_weixinStatus]  DEFAULT ((4)) FOR [OA_weixinStatus]

GO

ALTER TABLE [dbo].[OA_User] ADD  CONSTRAINT [DF_OA_User_Admin_execLevel]  DEFAULT ((0)) FOR [OA_execLevel]

GO

ALTER TABLE [dbo].[OA_User] ADD  CONSTRAINT [DF_OA_User_OA_OrderClass]  DEFAULT ('BF,AB,SA') FOR [OA_OrderClass]

GO

ALTER TABLE [dbo].[OA_User] ADD  CONSTRAINT [DF_OA_User_Post_MoneyP]  DEFAULT ((0)) FOR [Post_MoneyP]

GO

ALTER TABLE [dbo].[OA_User] ADD  CONSTRAINT [DF_OA_User_P1_Money]  DEFAULT ((0.5)) FOR [Post_MoneyP1]

GO

ALTER TABLE [dbo].[OA_User] ADD  CONSTRAINT [DF_OA_User_OA_EmployeeGroup]  DEFAULT ((0)) FOR [OA_EmployeeGroup]

GO

ALTER TABLE [dbo].[OrdData] ADD  CONSTRAINT [DF_OrdData_SOrdState]  DEFAULT ((0)) FOR [SOrdState]

GO

ALTER TABLE [dbo].[OrdData] ADD  CONSTRAINT [DF_OrdData_SOrdType]  DEFAULT ((0)) FOR [SOrdType]

GO

ALTER TABLE [dbo].[OrdData] ADD  CONSTRAINT [DF_OrdData_SOrdAreaType]  DEFAULT ((0)) FOR [SOrdAreaType]

GO

ALTER TABLE [dbo].[OrdData] ADD  CONSTRAINT [DF_OrdData_DOrdState]  DEFAULT ((0)) FOR [DOrdState]

GO

ALTER TABLE [dbo].[OrdData] ADD  CONSTRAINT [DF_OrdData_DataUPTime]  DEFAULT (getdate()) FOR [DataUPTime]

GO

ALTER TABLE [dbo].[OrdPriceSetting] ADD  CONSTRAINT [DF_OrdPriceSetting_OPS_NursingLevel]  DEFAULT ((0)) FOR [OPS_NursingLevel]

GO

ALTER TABLE [dbo].[OrdPriceSetting] ADD  CONSTRAINT [DF_OrdPriceSetting_OPS_StartingPrice]  DEFAULT ((0)) FOR [OPS_StartingPrice]

GO

ALTER TABLE [dbo].[OrdPriceSetting] ADD  CONSTRAINT [DF_OrdPriceSetting_OPS_Price1]  DEFAULT ((0)) FOR [OPS_Price1]

GO

ALTER TABLE [dbo].[OrdPriceSetting] ADD  CONSTRAINT [DF_OrdPriceSetting_OPS_Price2]  DEFAULT ((0)) FOR [OPS_Price2]

GO

ALTER TABLE [dbo].[OrdPriceSetting] ADD  CONSTRAINT [DF_OrdPriceSetting_OPS_limit1]  DEFAULT ((0)) FOR [OPS_limit1]

GO

ALTER TABLE [dbo].[OrdPriceSetting] ADD  CONSTRAINT [DF_OrdPriceSetting_OPS_limit2]  DEFAULT ((0)) FOR [OPS_limit2]

GO

ALTER TABLE [dbo].[OrdPriceSetting] ADD  CONSTRAINT [DF_OrdPriceSetting_OPS_WarmBoxCost]  DEFAULT ((0)) FOR [OPS_WarmBoxCost]

GO

ALTER TABLE [dbo].[OrdPriceSetting] ADD  CONSTRAINT [DF_OrdPriceSetting_OPS_LiftingCost]  DEFAULT ((0)) FOR [OPS_LiftingCost]

GO

ALTER TABLE [dbo].[OrdPriceSetting] ADD  CONSTRAINT [DF_OrdPriceSetting_OPS_WaitingCost]  DEFAULT ((0)) FOR [OPS_WaitingCost]

GO

ALTER TABLE [dbo].[OrdPriceSetting] ADD  CONSTRAINT [DF_OrdPriceSetting_OPS_FerryCost]  DEFAULT ((0)) FOR [OPS_FerryCost]

GO

ALTER TABLE [dbo].[PaidMoney] ADD  CONSTRAINT [DF_PaidMoney_ServiceOrdIDDt]  DEFAULT ((0)) FOR [ServiceOrdIDDt]

GO

ALTER TABLE [dbo].[PaidMoney] ADD  CONSTRAINT [DF_PaidMoney_DispatchOrdIDDt]  DEFAULT ((0)) FOR [DispatchOrdIDDt]

GO

ALTER TABLE [dbo].[PaidMoney] ADD  CONSTRAINT [DF_Table_1_PaidPrice]  DEFAULT ((0)) FOR [PaidMoney]

GO

ALTER TABLE [dbo].[PaidMoney] ADD  CONSTRAINT [DF_Table_1_PaidPriceType]  DEFAULT ((0)) FOR [PaidMoneyType]

GO

ALTER TABLE [dbo].[PaidMoney] ADD  CONSTRAINT [DF_Table_1_PaidPriceTime]  DEFAULT (getdate()) FOR [PaidMoneyTime]

GO

ALTER TABLE [dbo].[PaidMoney] ADD  CONSTRAINT [DF_PaidMoney_PaidMoneyUnitID]  DEFAULT ((0)) FOR [PaidMoneyUnitID]

GO

ALTER TABLE [dbo].[PaidMoney] ADD  CONSTRAINT [DF_Table_1_PaidPrice_AP_Check]  DEFAULT ((0)) FOR [PaidMoney_AP_Check]

GO

ALTER TABLE [dbo].[PaidMoney_Add] ADD  CONSTRAINT [DF_PaidMoney_Add_ToServiceOrdID]  DEFAULT ((0)) FOR [ToServiceOrdID]

GO

ALTER TABLE [dbo].[PaidMoney_Add] ADD  CONSTRAINT [DF_PaidMoney_Add_ToDispatchOrdID]  DEFAULT ((0)) FOR [ToDispatchOrdID]

GO

ALTER TABLE [dbo].[PaidMoney_Add] ADD  CONSTRAINT [DF_PaidMoney_Add_AddMoneyID]  DEFAULT ((0)) FOR [AddMoneyType]

GO

ALTER TABLE [dbo].[PaidMoney_Add] ADD  CONSTRAINT [DF_PaidMoney_Add_AddMoney]  DEFAULT ((0)) FOR [AddMoney]

GO

ALTER TABLE [dbo].[PaidMoney_Add] ADD  CONSTRAINT [DF_PaidMoney_Add_AddMoneyTime]  DEFAULT (getdate()) FOR [AddMoneyTime]

GO

ALTER TABLE [dbo].[QR_activity] ADD  CONSTRAINT [DF_QR_activity_QR_time]  DEFAULT (getdate()) FOR [QR_time]

GO

ALTER TABLE [dbo].[QR_activity] ADD  CONSTRAINT [DF_QR_activity_QR_activityInt]  DEFAULT ((0)) FOR [QR_activityInt]

GO

ALTER TABLE [dbo].[ServiceOrd_Message] ADD  CONSTRAINT [DF_ServiceOrd_Message_ServiceOrdIDDt]  DEFAULT ((0)) FOR [ServiceOrdIDDt]

GO

ALTER TABLE [dbo].[ServiceOrd_Message] ADD  CONSTRAINT [DF_ServiceOrd_Message_MessageDate]  DEFAULT (getdate()) FOR [MessageDate]

GO

ALTER TABLE [dbo].[ServiceOrd_Message] ADD  CONSTRAINT [DF_Table_1_MOAid]  DEFAULT ((0)) FOR [MessageOAid]

GO

ALTER TABLE [dbo].[ServiceOrd_Message] ADD  CONSTRAINT [DF_ServiceOrd_Message_MessageState]  DEFAULT ((1)) FOR [MessageState]

GO

ALTER TABLE [dbo].[ServiceOrd_Message] ADD  CONSTRAINT [DF_ServiceOrd_Message_MessageToOAid]  DEFAULT ((0)) FOR [MessageToOAid]

GO

ALTER TABLE [dbo].[ServiceOrd_Message] ADD  CONSTRAINT [DF_ServiceOrd_Message_MessageToState]  DEFAULT ((0)) FOR [MessageToState]

GO

ALTER TABLE [dbo].[ServiceOrd_Message] ADD  CONSTRAINT [DF_ServiceOrd_Message_Phone_is]  DEFAULT ((0)) FOR [Phone_is]

GO

ALTER TABLE [dbo].[ServiceOrd_TransferMode] ADD  CONSTRAINT [DF_ServiceOrdTransferMode_ServiceOrdTMID]  DEFAULT ((0)) FOR [ServiceOrdTMID]

GO

ALTER TABLE [dbo].[ServiceOrd_TransferMode] ADD  CONSTRAINT [DF_ServiceOrdTransferMode_TransferModeID]  DEFAULT ((0)) FOR [TransferModeID]

GO

ALTER TABLE [dbo].[ServiceOrder] ADD  CONSTRAINT [DF_ServiceOrder_ServiceOrdUserID]  DEFAULT ((0)) FOR [ServiceOrdUserID]

GO

ALTER TABLE [dbo].[ServiceOrder] ADD  CONSTRAINT [DF_ServiceOrder_ServiceOrderClass]  DEFAULT ('BF') FOR [ServiceOrdClass]

GO

ALTER TABLE [dbo].[ServiceOrder] ADD  CONSTRAINT [DF_ServiceOrder_ServiceOrderType]  DEFAULT ((20)) FOR [ServiceOrdType]

GO

ALTER TABLE [dbo].[ServiceOrder] ADD  CONSTRAINT [DF_ServiceOrder_ServiceOrderState]  DEFAULT ((1)) FOR [ServiceOrdState]

GO

ALTER TABLE [dbo].[ServiceOrder] ADD  CONSTRAINT [DF_ServiceOrder_OrderStartDate]  DEFAULT (getdate()) FOR [ServiceOrdStartDate]

GO

ALTER TABLE [dbo].[ServiceOrder] ADD  CONSTRAINT [DF_ServiceOrder_ServiceOrdPtAge]  DEFAULT ((0)) FOR [ServiceOrdPtAge]

GO

ALTER TABLE [dbo].[ServiceOrder] ADD  CONSTRAINT [DF_ServiceOrder_ServiceOrdPtOutHospID]  DEFAULT ((0)) FOR [ServiceOrdPtOutHospID]

GO

ALTER TABLE [dbo].[ServiceOrder] ADD  CONSTRAINT [DF_ServiceOrder_ServiceOrdPtOutHosp]  DEFAULT ((0)) FOR [ServiceOrdPtOutHosp]

GO

ALTER TABLE [dbo].[ServiceOrder] ADD  CONSTRAINT [DF_ServiceOrder_ServiceOrdPtInHospID]  DEFAULT ((0)) FOR [ServiceOrdPtInHospID]

GO

ALTER TABLE [dbo].[ServiceOrder] ADD  CONSTRAINT [DF_ServiceOrder_ServiceOrdPtInHosp]  DEFAULT ((0)) FOR [ServiceOrdPtInHosp]

GO

ALTER TABLE [dbo].[ServiceOrder] ADD  CONSTRAINT [DF_ServiceOrder_HospitalDepartmentID]  DEFAULT ((0)) FOR [ServiceOrdPtServicesID]

GO

ALTER TABLE [dbo].[ServiceOrder] ADD  CONSTRAINT [DF_ServiceOrder_ServiceOrdPtServicesID1]  DEFAULT ((0)) FOR [ServiceOrdPtInServicesID]

GO

ALTER TABLE [dbo].[ServiceOrder] ADD  CONSTRAINT [DF__ServiceOr__Servi__2A0C1F93]  DEFAULT (NULL) FOR [ServiceOrdTraStreet]

GO

ALTER TABLE [dbo].[ServiceOrder] ADD  CONSTRAINT [DF_ServiceOrder_ServiceOrdTraDistance]  DEFAULT ((0)) FOR [ServiceOrdTraDistance]

GO

ALTER TABLE [dbo].[ServiceOrder] ADD  CONSTRAINT [DF_ServiceOrder_ServiceOrdTraUnitPrice]  DEFAULT ((0)) FOR [ServiceOrdTraUnitPrice]

GO

ALTER TABLE [dbo].[ServiceOrder] ADD  CONSTRAINT [DF_ServiceOrder_ServiceOrdTraOfferPrice]  DEFAULT ((0)) FOR [ServiceOrdTraOfferPrice]

GO

ALTER TABLE [dbo].[ServiceOrder] ADD  CONSTRAINT [DF_ServiceOrder_ServiceOrdTraTxnPrice]  DEFAULT ((0)) FOR [ServiceOrdTraTxnPrice]

GO

ALTER TABLE [dbo].[ServiceOrder] ADD  CONSTRAINT [DF_ServiceOrder_ServiceOrdTraPaidType]  DEFAULT ((0)) FOR [ServiceOrdTraPaidType]

GO

ALTER TABLE [dbo].[ServiceOrder] ADD  CONSTRAINT [DF_ServiceOrder_ServiceOrdTraPaidPrice]  DEFAULT ((0)) FOR [ServiceOrdTraPaidPrice]

GO

ALTER TABLE [dbo].[ServiceOrder] ADD  CONSTRAINT [DF_ServiceOrder_ServiceOrdTraPrePayment]  DEFAULT ((0)) FOR [ServiceOrdTraPrePayment]

GO

ALTER TABLE [dbo].[ServiceOrder] ADD  CONSTRAINT [DF_ServiceOrder_SettlementPrice]  DEFAULT ((0)) FOR [SettlementPrice]

GO

ALTER TABLE [dbo].[ServiceOrder] ADD  CONSTRAINT [DF_ServiceOrder_ServiceOrd_CC_Time]  DEFAULT (getdate()) FOR [ServiceOrd_CC_Time]

GO

ALTER TABLE [dbo].[ServiceOrder] ADD  CONSTRAINT [DF_ServiceOrder_ServiceOrd_AP_Check]  DEFAULT ((0)) FOR [ServiceOrd_AP_Check]

GO

ALTER TABLE [dbo].[ServiceOrder] ADD  CONSTRAINT [DF_ServiceOrder_ServiceOrdNo]  DEFAULT ((1)) FOR [ServiceOrdNo]

GO

ALTER TABLE [dbo].[ServiceOrder] ADD  CONSTRAINT [DF_ServiceOrder_ServiceOrdVIP]  DEFAULT ((0)) FOR [ServiceOrdVIP]

GO

ALTER TABLE [dbo].[ServiceOrder] ADD  CONSTRAINT [DF_ServiceOrder_ServiceOrdUnitID]  DEFAULT ((0)) FOR [ServiceOrdUnitID]

GO

ALTER TABLE [dbo].[ServiceOrder] ADD  CONSTRAINT [DF_ServiceOrder_ServiceOrdSource]  DEFAULT ((0)) FOR [ServiceOrdSource]

GO

ALTER TABLE [dbo].[ServiceOrder] ADD  CONSTRAINT [DF_ServiceOrder_Guest_Score]  DEFAULT ((0)) FOR [Guest_Point]

GO

ALTER TABLE [dbo].[ServiceOrder] ADD  CONSTRAINT [DF_ServiceOrder_Guest_Reward]  DEFAULT ((0)) FOR [Guest_Reward]

GO

ALTER TABLE [dbo].[ServiceOrder] ADD  CONSTRAINT [DF_ServiceOrder_RV_Point]  DEFAULT ((0)) FOR [RV_Point]

GO

ALTER TABLE [dbo].[ServiceOrder] ADD  CONSTRAINT [DF_ServiceOrder_OrderLevel]  DEFAULT ((0)) FOR [OrderLevel]

GO

ALTER TABLE [dbo].[ServiceOrder] ADD  CONSTRAINT [DF_ServiceOrder_ConditionLevel]  DEFAULT ((0)) FOR [ConditionLevel]

GO

ALTER TABLE [dbo].[ServiceOrder] ADD  CONSTRAINT [DF_ServiceOrder_DirectionType]  DEFAULT ((0)) FOR [DirectionType]

GO

ALTER TABLE [dbo].[ServiceOrder] ADD  CONSTRAINT [DF_ServiceOrder_DirectionType2]  DEFAULT ((0)) FOR [DirectionType2]

GO

ALTER TABLE [dbo].[ServiceOrder] ADD  CONSTRAINT [DF_ServiceOrder_RecommendUserID]  DEFAULT ((0)) FOR [RecommendUserID]

GO

ALTER TABLE [dbo].[ServiceOrder] ADD  CONSTRAINT [DF_ServiceOrder_ServiceOrdUserUpdateTime]  DEFAULT (getdate()) FOR [ServiceOrdUserUpdateTime]

GO

ALTER TABLE [dbo].[ServiceOrder] ADD  CONSTRAINT [DF_ServiceOrder_AMV_is]  DEFAULT ((0)) FOR [AMV_is]

GO

ALTER TABLE [dbo].[ServiceOrder] ADD  CONSTRAINT [DF_ServiceOrder_FromHQ_is]  DEFAULT ((0)) FOR [FromHQ_is]

GO

ALTER TABLE [dbo].[ServiceOrder] ADD  CONSTRAINT [DF_ServiceOrder_FromHQ2_is]  DEFAULT ((0)) FOR [FromHQ2_is]

GO

ALTER TABLE [dbo].[ServiceOrder] ADD  CONSTRAINT [DF_ServiceOrder_ServiceOrdDepartureType]  DEFAULT ((0)) FOR [ServiceOrdDepartureType]

GO

ALTER TABLE [dbo].[ServiceOrder] ADD  CONSTRAINT [DF_ServiceOrder_ServiceOrd_MessageCountInt]  DEFAULT ((0)) FOR [ServiceOrd_MessageCountInt]

GO

ALTER TABLE [dbo].[ServiceOrder] ADD  CONSTRAINT [DF_ServiceOrder_ServiceOrdUpdateOAid]  DEFAULT ((0)) FOR [ServiceOrdUpdateOAid]

GO

ALTER TABLE [dbo].[ServiceOrder] ADD  CONSTRAINT [DF_ServiceOrder_ServiceOrdUpdateTime]  DEFAULT (getdate()) FOR [ServiceOrdUpdateTime]

GO

ALTER TABLE [dbo].[ServiceOrder] ADD  CONSTRAINT [DF__ServiceOr__Servi__2823D721]  DEFAULT ((1)) FOR [ServiceOrdAreaType]

GO

ALTER TABLE [dbo].[ServiceOrder] ADD  CONSTRAINT [DF_ServiceOrder_ToUserUUID]  DEFAULT ((0)) FOR [ToUserUUID]

GO

ALTER TABLE [dbo].[ServiceOrder] ADD  DEFAULT ((0)) FOR [ServiceOrdPoints]

GO

ALTER TABLE [dbo].[ServiceOrder] ADD  CONSTRAINT [DF_ServiceOrder_IsLocking]  DEFAULT ((0)) FOR [IsLocking]

GO

ALTER TABLE [dbo].[ServiceOrder] ADD  DEFAULT ((0)) FOR [ServiceOrd_work_is]

GO

ALTER TABLE [dbo].[ServiceOrder_ICD] ADD  CONSTRAINT [DF_ServiceOrder_ICD_icd_id]  DEFAULT ((0)) FOR [icd_id]

GO

ALTER TABLE [dbo].[ServiceOrder_ICD] ADD  CONSTRAINT [DF_ServiceOrder_ICD_ServiceOrdIDDt]  DEFAULT ((0)) FOR [ServiceOrdIDDt]

GO

ALTER TABLE [dbo].[ServiceOrder_Options] ADD  CONSTRAINT [DF_ServiceOrder_Options_ServiceOrdSoID]  DEFAULT ((0)) FOR [ServiceOrdSoID]

GO

ALTER TABLE [dbo].[ServiceOrder_Options] ADD  CONSTRAINT [DF_ServiceOrder_Options_ServiceOptionsID]  DEFAULT ((0)) FOR [ServiceOptionsID]

GO

ALTER TABLE [dbo].[SMS_Log] ADD  CONSTRAINT [DF_SMS_Log_Send_Time]  DEFAULT (getdate()) FOR [Send_Time]

GO

ALTER TABLE [dbo].[SMS_Log] ADD  CONSTRAINT [DF_SMS_Log_Send_OA]  DEFAULT ((0)) FOR [Send_OA]

GO

ALTER TABLE [dbo].[tblStItm] ADD  CONSTRAINT [DF_tblStItm_PurchasePrice]  DEFAULT ((0)) FOR [PurchasePrice]

GO

ALTER TABLE [dbo].[tblStItm] ADD  CONSTRAINT [DF_tblStItm_SellingPrice]  DEFAULT ((0)) FOR [SellingPrice]

GO

ALTER TABLE [dbo].[tblStItm] ADD  CONSTRAINT [DF_tblStItm_CreditsPrice]  DEFAULT ((0)) FOR [CreditsPrice]

GO

ALTER TABLE [dbo].[tblStItm] ADD  CONSTRAINT [DF_tblStItm_classid]  DEFAULT ((0)) FOR [strItmClassID]

GO

ALTER TABLE [dbo].[tblStItm] ADD  CONSTRAINT [DF_tblStItm_strItmState]  DEFAULT ((0)) FOR [strItmState]

GO

ALTER TABLE [dbo].[tblStItm] ADD  CONSTRAINT [DF_tblStItm_isCarStItm]  DEFAULT ((0)) FOR [isCarStItm]

GO

ALTER TABLE [dbo].[test_Ord] ADD  CONSTRAINT [DF_test_Ord_testDate]  DEFAULT (getdate()) FOR [testDate]

GO

ALTER TABLE [dbo].[test_Ord] ADD  CONSTRAINT [DF_test_Ord_test_is]  DEFAULT ((0)) FOR [test_is]

GO

ALTER TABLE [dbo].[test_OrdDt] ADD  CONSTRAINT [DF_test_OrdDt_testWeixinDate]  DEFAULT (getdate()) FOR [testWeixinDate]

GO

ALTER TABLE [dbo].[UserData] ADD  CONSTRAINT [DF_UserData_UserLevel]  DEFAULT ((1)) FOR [UserLevel]

GO

ALTER TABLE [dbo].[UserData] ADD  CONSTRAINT [DF_UserData_UserRegisterTime]  DEFAULT (getdate()) FOR [UserRegisterTime]

GO

ALTER TABLE [dbo].[UserData] ADD  CONSTRAINT [DF_UserData_UserLoginTime]  DEFAULT (getdate()) FOR [UserLoginTime]

GO

ALTER TABLE [dbo].[UserData] ADD  CONSTRAINT [DF_UserData_UserUnitID]  DEFAULT ((0)) FOR [UserUnitID]

GO

ALTER TABLE [dbo].[UserData] ADD  CONSTRAINT [DF_UserData_RecommendUserID]  DEFAULT ((0)) FOR [RecommendUserID]

GO

ALTER TABLE [dbo].[UserInformation] ADD  CONSTRAINT [DF_UserInformation_ToUserID]  DEFAULT ((0)) FOR [ToUserID]

GO

ALTER TABLE [dbo].[UserInformation] ADD  CONSTRAINT [DF_UserInformation_InformationTime]  DEFAULT (getdate()) FOR [InformationTime]

GO

ALTER TABLE [dbo].[UserPhone] ADD  CONSTRAINT [DF_UserPhone_ToUserID]  DEFAULT ((0)) FOR [ToUserID]

GO

ALTER TABLE [dbo].[UserPhone] ADD  CONSTRAINT [DF_UserPhone_strPhone_is]  DEFAULT ((0)) FOR [strPhone_is]

GO

ALTER TABLE [dbo].[UserPhone] ADD  CONSTRAINT [DF_UserPhone_LoginTime]  DEFAULT (getdate()) FOR [LoginTime]

GO

ALTER TABLE [dbo].[UserPhoneVerify] ADD  CONSTRAINT [DF_UserPhoneVerify_SendTime]  DEFAULT (getdate()) FOR [SendTime]

GO

ALTER TABLE [dbo].[UserPhoneVerify] ADD  CONSTRAINT [DF_UserPhoneVerify_SendID]  DEFAULT ((0)) FOR [SendID]

GO

ALTER TABLE [dbo].[UserPoints] ADD  CONSTRAINT [DF_UserPoints_ToUserID]  DEFAULT ((0)) FOR [ToUserID]

GO

ALTER TABLE [dbo].[UserPoints] ADD  CONSTRAINT [DF_UserPoints_Score]  DEFAULT ((0)) FOR [Points_Score]

GO

ALTER TABLE [dbo].[UserPoints] ADD  CONSTRAINT [DF_UserPoints_Points_Type]  DEFAULT ((0)) FOR [Points_Type]

GO

ALTER TABLE [dbo].[UserPoints] ADD  CONSTRAINT [DF_UserPoints_Points_Time]  DEFAULT (getdate()) FOR [Points_Time]

GO

ALTER TABLE [dbo].[UserPoints] ADD  CONSTRAINT [DF_UserPoints_Points_State]  DEFAULT ((0)) FOR [Points_State]

GO

ALTER TABLE [dbo].[UserPoints] ADD  CONSTRAINT [DF_UserPoints_ServiceOrdIDDt]  DEFAULT ((0)) FOR [ServiceOrdIDDt]

GO

ALTER TABLE [dbo].[UserRecommendNote] ADD  CONSTRAINT [DF_UserRecommendNote_ToUserID]  DEFAULT ((0)) FOR [ToUserID]

GO

ALTER TABLE [dbo].[UserRecommendNote] ADD  CONSTRAINT [DF_UserRecommendNote_ToRUserID]  DEFAULT ((0)) FOR [ToRUserID]

GO

ALTER TABLE [dbo].[UserRecommendNote] ADD  CONSTRAINT [DF_UserRecommendNote_UpdateTime]  DEFAULT (getdate()) FOR [UpdateTime]

GO

ALTER TABLE [dbo].[UserUUID] ADD  CONSTRAINT [DF_UserUUID_ToUserID]  DEFAULT ((0)) FOR [ToUserID]

GO

ALTER TABLE [dbo].[UserUUID] ADD  CONSTRAINT [DF_UserUUID_LoginTime]  DEFAULT (getdate()) FOR [LoginTime]

GO

ALTER TABLE [dbo].[weixinOpenID] ADD  CONSTRAINT [DF_weixinOpenID_ToUserID]  DEFAULT ((0)) FOR [ToUserID]

GO

ALTER TABLE [dbo].[weixinOpenID] ADD  CONSTRAINT [DF_weixinOpenID_LoginTime]  DEFAULT (getdate()) FOR [LoginTime]

GO

ALTER TABLE [dbo].[weixinOpenID] ADD  CONSTRAINT [DF_weixinOpenID_weixinState]  DEFAULT ((1)) FOR [weixinState]

GO

ALTER TABLE [dbo].[weixinOpenIDToPhone] ADD  CONSTRAINT [DF_weixinOpenIDToPhone_LoginTime]  DEFAULT (getdate()) FOR [LoginTime]

GO

ALTER TABLE [dbo].[weixinOpenIDToPhone] ADD  CONSTRAINT [DF_weixinOpenIDToPhone_weixinState]  DEFAULT ((1)) FOR [weixinState]

GO

ALTER TABLE [dbo].[weixinQR] ADD  CONSTRAINT [DF_weixinQR_QR_ID]  DEFAULT ((0)) FOR [QR_ID]

GO

ALTER TABLE [dbo].[weixinQR] ADD  CONSTRAINT [DF_weixinQR_QR_type]  DEFAULT ((0)) FOR [QR_type]

GO

ALTER TABLE [dbo].[weixinQR] ADD  CONSTRAINT [DF_weixinQR_QR_Time]  DEFAULT (getdate()) FOR [QR_Time]

GO

ALTER TABLE [dbo].[weixinQR] ADD  CONSTRAINT [DF_weixinQR_QR_ClickInt]  DEFAULT ((0)) FOR [QR_ClickInt]

GO

ALTER TABLE [dbo].[weixinQR] ADD  CONSTRAINT [DF_weixinQR_QR_SubscribeInt]  DEFAULT ((0)) FOR [QR_SubscribeInt]

GO

ALTER TABLE [dbo].[weixinUserFormID] ADD  CONSTRAINT [DF_weixinUserFormID_formID_savetime]  DEFAULT (getdate()) FOR [formID_savetime]

GO

ALTER TABLE [dbo].[weixinUserFormID] ADD  CONSTRAINT [DF_weixinUserFormID_formID_weixinAPPID]  DEFAULT ((0)) FOR [formID_UnitID]

GO

ALTER TABLE [dbo].[weixinUserFormID] ADD  CONSTRAINT [DF_weixinUserFormID_formID_UserID]  DEFAULT ((0)) FOR [formID_UserID]

GO

ALTER TABLE [dbo].[weixinUserFormID] ADD  CONSTRAINT [DF_weixinUserFormID_formID_SendType]  DEFAULT ((0)) FOR [formID_SendType]

GO

ALTER TABLE [dbo].[ServiceOrderCommissionDetails]  WITH CHECK ADD CHECK  (([CommissionRatio]>=(0) AND [CommissionRatio]<=(100)))

GO

ALTER TABLE [dbo].[ServiceOrderCommissionDetails]  WITH CHECK ADD CHECK  (([PersonType]='Follower' OR [PersonType]='Opener'))

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'nx¤
g¡RUSºNXTID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DispatchOrd', @level2type=N'COLUMN',@level2name=N'DispatchOrd_NS_ID'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¡[8hºNXTID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DispatchOrd', @level2type=N'COLUMN',@level2name=N'DispatchOrd_AP_ID'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'"¡R¡[8h' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DispatchOrd', @level2type=N'COLUMN',@level2name=N'DispatchOrd_FA_ID'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¬~¦^' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DispatchOrd_Running', @level2type=N'COLUMN',@level2name=N'OA_latitude'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Ï~¦^' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DispatchOrd_Running', @level2type=N'COLUMN',@level2name=N'OA_longitude'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'0W@WæÅ`ôf' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DispatchOrd_Running', @level2type=N'COLUMN',@level2name=N'OA_address'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'
g¡RUSID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ServiceOrder', @level2type=N'COLUMN',@level2name=N'ServiceOrdID'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'USnc{|W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ServiceOrder', @level2type=N'COLUMN',@level2name=N'ServiceOrdClass'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'
g¡RUS{|W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ServiceOrder', @level2type=N'COLUMN',@level2name=N'ServiceOrdType'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'
g¡RUS¶r`' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ServiceOrder', @level2type=N'COLUMN',@level2name=N'ServiceOrdState'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'_USåeg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ServiceOrder', @level2type=N'COLUMN',@level2name=N'ServiceOrdStartDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Tû|ºNÓY
T' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ServiceOrder', @level2type=N'COLUMN',@level2name=N'ServiceOrdCoName'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Tû|ºN5uÝ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ServiceOrder', @level2type=N'COLUMN',@level2name=N'ServiceOrdCoPhone'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Tû|ºNN£`sQû|' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ServiceOrder', @level2type=N'COLUMN',@level2name=N'ServiceOrdCoTies'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'£`ÓY
T' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ServiceOrder', @level2type=N'COLUMN',@level2name=N'ServiceOrdPtName'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'£`t^' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ServiceOrder', @level2type=N'COLUMN',@level2name=N'ServiceOrdPtAge'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'£`ýVM|' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ServiceOrder', @level2type=N'COLUMN',@level2name=N'ServiceOrdPtNat'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'lúQ;Sb' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ServiceOrder', @level2type=N'COLUMN',@level2name=N'ServiceOrdPtOutHosp'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Ñy¤[' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ServiceOrder', @level2type=N'COLUMN',@level2name=N'ServiceOrdPtServices'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Ñy¤[' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ServiceOrder', @level2type=N'COLUMN',@level2name=N'ServiceOrdPtInServices'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Ê­e' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ServiceOrder', @level2type=N'COLUMN',@level2name=N'ServiceOrdPtDiagnosis'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÅuÅ`Ïcð' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ServiceOrder', @level2type=N'COLUMN',@level2name=N'ServiceOrdPtCondition'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'£`;Su' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ServiceOrder', @level2type=N'COLUMN',@level2name=N'ServiceOrdPtDoctor'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'£`;Su5uÝ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ServiceOrder', @level2type=N'COLUMN',@level2name=N'ServiceOrdPtDoctorPhone'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'úQÑS0WwýN' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ServiceOrder', @level2type=N'COLUMN',@level2name=N'ServiceOrdTraProvince'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'úQÑS0WÎW^' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ServiceOrder', @level2type=N'COLUMN',@level2name=N'ServiceOrdTraCity'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'úQÑS0W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ServiceOrder', @level2type=N'COLUMN',@level2name=N'ServiceOrdTraStreet'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'úQÑS0WPWh' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ServiceOrder', @level2type=N'COLUMN',@level2name=N'ServiceOrdTraStreetCoo'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îvv0W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ServiceOrder', @level2type=N'COLUMN',@level2name=N'ServiceOrdTraEnd'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îvv0WPWh' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ServiceOrder', @level2type=N'COLUMN',@level2name=N'ServiceOrdTraEndCoo'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Ý»y(lQÌ)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ServiceOrder', @level2type=N'COLUMN',@level2name=N'ServiceOrdTraDistance'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¡Lzöeô' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ServiceOrder', @level2type=N'COLUMN',@level2name=N'ServiceOrdTraDuration'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ßbúQÑSöeô' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ServiceOrder', @level2type=N'COLUMN',@level2name=N'ServiceOrdTraSDTime'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'US÷N/lQÌ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ServiceOrder', @level2type=N'COLUMN',@level2name=N'ServiceOrdTraUnitPrice'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'hÆQ¥b÷N' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ServiceOrder', @level2type=N'COLUMN',@level2name=N'ServiceOrdTraOfferPrice'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'b¤N÷N' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ServiceOrder', @level2type=N'COLUMN',@level2name=N'ServiceOrdTraTxnPrice'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'î]÷NSàV' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ServiceOrder', @level2type=N'COLUMN',@level2name=N'ServiceOrdTraPriceReason'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N',{N!k¥cUSºNXTID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ServiceOrder', @level2type=N'COLUMN',@level2name=N'ServiceOrd_CC_ID'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'nx¤
g¡RUSºNXTID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ServiceOrder', @level2type=N'COLUMN',@level2name=N'ServiceOrd_NS_ID'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¡[8hºNXTID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ServiceOrder', @level2type=N'COLUMN',@level2name=N'ServiceOrd_AP_ID'

GO

