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]
|
