ÿþ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, [egn] [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, [leQwýN] [nvarchar](50) NULL, [leQ^] [nvarchar](50) NULL, [leQ:S] [nvarchar](50) NULL, [leQ;Sb–] [nvarchar](50) NULL, [leQÑ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, [fLr] [nvarchar](50) NULL, [úQfbXT] [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'îv„v0W' , @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'îv„v0WPWh' , @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'„˜¡‹Lˆ zö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'î]÷NŸSà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