CREATE TABLE [dbo].[ServiceOrder](
	[ServiceOrdID] [bigint] IDENTITY(1016003200,1) NOT NULL,
	[ServiceOrdUserID] [int] NULL,
	[ServiceOrdClass] [nvarchar](4) NULL,
	[ServiceOrdType] [int] NULL,
	[ServiceOrdState] [int] NULL,
	[ServiceOrdStartDate] [datetime] NULL,
	[ServiceOrdApptDate] [datetime] NULL,
	[ServiceOrdCoName] [nvarchar](50) NULL,
	[ServiceOrdCoPhone] [nvarchar](50) NULL,
	[ServiceOrdCoTies] [nvarchar](50) NULL,
	[ServiceOrdPtName] [nvarchar](50) NULL,
	[ServiceOrdPtAge] [nvarchar](50) NULL,
	[ServiceOrdPtSex] [nvarchar](10) NULL,
	[ServiceOrdPtKG] [nvarchar](50) NULL,
	[ServiceOrdPtNat] [nvarchar](50) NULL,
	[ServiceOrdPtIDCard] [nvarchar](50) NULL,
	[ServiceOrdPtOutHospID] [int] NULL,
	[ServiceOrdPtOutHosp] [int] NULL,
	[ServiceOrdPtInHospID] [int] NULL,
	[ServiceOrdPtInHosp] [int] NULL,
	[ServiceOrdPtServices] [nvarchar](50) NULL,
	[ServiceOrdPtServicesID] [int] NULL,
	[ServiceOrdPtInServices] [nvarchar](50) NULL,
	[ServiceOrdPtInServicesID] [int] NULL,
	[ServiceOrdPtDiagnosis] [nvarchar](1000) NULL,
	[ServiceOrdPtCondition] [nvarchar](1000) NULL,
	[ServiceOrdPtDoctor] [nvarchar](50) NULL,
	[ServiceOrdPtDoctorPhone] [nvarchar](50) NULL,
	[ServiceOrdTraProvince] [nvarchar](50) NULL,
	[ServiceOrdTraCity] [nvarchar](50) NULL,
	[ServiceOrdTraStreet] [nvarchar](200) NULL,
	[ServiceOrdTraStreetCoo] [nvarchar](50) NULL,
	[ServiceOrdTraEnd] [nvarchar](200) NULL,
	[ServiceOrdTraEndCoo] [nvarchar](50) NULL,
	[ServiceOrdTraVia] [nvarchar](500) NULL,
	[ServiceOrdViaDistance] [nvarchar](50) NULL,
	[ServiceOrdTraDistance] [nvarchar](50) NULL,
	[ServiceOrdTraDuration] [nvarchar](50) NULL,
	[ServiceOrdTraSDTime] [datetime] NULL,
	[ServiceOrdTraUnitPrice] [money] NULL,
	[ServiceOrdTraOfferPrice] [money] NULL,
	[ServiceOrdTraTxnPrice] [money] NULL,
	[ServiceOrdTraPaidType] [int] NULL,
	[ServiceOrdTraPaidPrice] [money] NULL,
	[ServiceOrdTraPrePayment] [money] NULL,
	[ServiceOrdTraPriceReason] [nvarchar](200) NULL,
	[SettlementPrice] [money] NULL,
	[ServiceOrd_CC_ID] [int] NULL,
	[ServiceOrd_CC_Time] [datetime] NULL,
	[ServiceOrd_NS_ID] [int] NULL,
	[ServiceOrd_NS_Time] [datetime] NULL,
	[ServiceOrd_AP_ID] [int] NULL,
	[ServiceOrd_AP_Time] [datetime] NULL,
	[ServiceOrd_AP_Check] [int] NULL,
	[ServiceOrdNo] [int] NULL,
	[ServiceOrd_Sale_ID] [int] NULL,
	[ServiceOrdIntroducer] [nvarchar](50) NULL,
	[ServiceOrdCancelReason] [int] NULL,
	[ServiceOrdCancelReasonTXT] [nvarchar](200) NULL,
	[ServiceOrdVIP] [int] NULL,
	[ServiceOrdUnitID] [int] NULL,
	[ServiceOrdUnitRemarks] [nvarchar](2000) NULL,
	[ServiceOrdReturnChannel] [nvarchar](50) NULL,
	[ServiceOrdVisit] [nvarchar](max) NULL,
	[ServiceOrdVisit_time] [datetime] NULL,
	[ServiceOrdVisit_ID] [int] NULL,
	[ServiceOrdSource] [int] NULL,
	[ServiceOrdOperationRemarks] [nvarchar](1000) NULL,
	[ServiceOrdEstimatedOrderDate] [datetime] NULL,
	[PayQRcodeURL] [nvarchar](200) NULL,
	[Guest_openid] [nvarchar](100) NULL,
	[Guest_Point] [int] NULL,
	[Guest_Impression] [nvarchar](100) NULL,
	[Guest_Evaluate] [nvarchar](500) NULL,
	[Guest_Reward] [money] NULL,
	[Guest_Time] [datetime] NULL,
	[RV_Point] [int] NULL,
	[OrdAuthorize] [nvarchar](10) NULL,
	[OrdAuthorize_Time] [datetime] NULL,
	[OrderLevel] [int] NULL,
	[ConditionLevel] [int] NULL,
	[DirectionType] [int] NULL,
	[DirectionType2] [int] NULL,
	[RecommendUserID] [int] NULL,
	[ServiceOrdUserUpdateTime] [datetime] NULL,
	[AMV_is] [int] NULL,
	[FromHQ_is] [int] NULL,
	[FromHQ2_is] [int] NULL,
	[ServiceOrdDepartureType] [int] NULL,
	[ServiceOrdTaskRemarks] [nvarchar](500) NULL,
	[ServiceOrd_MessageCountInt] [int] NULL,
	[ServiceOrdUpdateOAid] [int] NULL,
	[ServiceOrdUpdateTime] [datetime] NULL,
	[ServiceOrdOnlineOAName] [nchar](100) NULL,
	[ServiceOrdAreaType] [int] NULL,
	[ToUserUUID] [int] NULL,
	[ServiceOrdPoints] [money] NULL,
	[IsLocking] [int] NULL,
	[IsLocking_Time] [datetime] NULL,
	[IsSterilize_OAID] [int] NULL,
	[OrderPrice_Auto] [money] NULL,
	[ServiceOrdVisit_Dict] [nvarchar](100) NULL,
	[ServiceOrd_work_ID] [int] NULL,
	[ServiceOrd_work_IDs] [varchar](255) NULL,
	[ServiceOrd_work_is] [int] NULL,
	[CommissionScenarioID] [int] NULL,
 CONSTRAINT [PK_ServiceOrder] PRIMARY KEY CLUSTERED 
(
	[ServiceOrdID] 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]
