CREATE TABLE [dbo].[F_SetUfidaCode] (
[AutoID] [int] IDENTITY (1, 1) NOT NULL ,
[SetType] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[BillType] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[ProdID] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[AccID] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[U_CodeID] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[U_CodeName] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[U_YFCodeID] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[U_YFCodeName] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[U_CGTaxCodeID] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[U_CGTaxCodeName] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[U_CGYHCodeID] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[U_CGYHCodeName] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[U_YSCodeID] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[U_YSCodeName] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[U_XSTaxCodeID] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[U_XSTaxCodeName] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[U_XSYHCodeID] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[U_XSYHCodeName] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[U_VipCardCodeID] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[U_VipCardCodeName] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[U_DJJCodeID] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[U_DJJCodeName] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[U_DJJCECodeID] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[U_DJJCECodeName] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
CREATE CLUSTERED INDEX [IX_SetUfidaCode] ON [dbo].[F_SetUfidaCode]([SetType]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[F_PZList] ADD
CONSTRAINT [DF_F_PZList_Bill_Type_Sale] DEFAULT ('') FOR [BillType_Sale],
CONSTRAINT [DF_F_PZList_MoneyJF] DEFAULT (0) FOR [MoneyJF],
CONSTRAINT [DF_F_PZList_MoneyDF] DEFAULT (0) FOR [MoneyDF],
CONSTRAINT [DF_F_PZList_NumJF] DEFAULT (0) FOR [NumJF],
CONSTRAINT [DF_F_PZList_NumDF] DEFAULT (0) FOR [NumDF],
CONSTRAINT [DF_F_PZList_ZS] DEFAULT (0) FOR [ZS],
CONSTRAINT [DF_F_PZList_PZFlag] DEFAULT (0) FOR [PZFlag]
GO
ALTER TABLE [dbo].[F_SetUfidaCode] ADD
CONSTRAINT [DF_SetUfidaCode_SetType] DEFAULT ('') FOR [SetType],
CONSTRAINT [DF_SetUfidaCode_BillType] DEFAULT ('') FOR [BillType],
CONSTRAINT [DF_SetUfidaCode_ProdID] DEFAULT ('') FOR [ProdID],
CONSTRAINT [DF_SetUfidaCode_AccID] DEFAULT ('') FOR [AccID],
CONSTRAINT [DF_SetUfidaCode_U_CodeID] DEFAULT ('') FOR [U_CodeID],
CONSTRAINT [DF_SetUfidaCode_U_CodeName] DEFAULT ('') FOR [U_CodeName],
CONSTRAINT [DF_SetUfidaCode_U_YFCodeID] DEFAULT ('') FOR [U_YFCodeID],
CONSTRAINT [DF_SetUfidaCode_U_YFCodeName] DEFAULT ('') FOR [U_YFCodeName],
CONSTRAINT [DF_SetUfidaCode_U_CGTaxCodeID] DEFAULT ('') FOR [U_CGTaxCodeID],
CONSTRAINT [DF_SetUfidaCode_U_CGTaxCodeName] DEFAULT ('') FOR [U_CGTaxCodeName],
CONSTRAINT [DF_SetUfidaCode_U_CGYHCodeID] DEFAULT ('') FOR [U_CGYHCodeID],
CONSTRAINT [DF_SetUfidaCode_U_CGYHCodeName] DEFAULT ('') FOR [U_CGYHCodeName],
CONSTRAINT [DF_SetUfidaCode_U_YSCodeID] DEFAULT ('') FOR [U_YSCodeID],
CONSTRAINT [DF_SetUfidaCode_U_YSCodeName] DEFAULT ('') FOR [U_YSCodeName],
CONSTRAINT [DF_SetUfidaCode_U_XSTaxCodeID] DEFAULT ('') FOR [U_XSTaxCodeID],
CONSTRAINT [DF_SetUfidaCode_U_XSTaxCodeName] DEFAULT ('') FOR [U_XSTaxCodeName],
CONSTRAINT [DF_SetUfidaCode_U_XSYHCodeID] DEFAULT ('') FOR [U_XSYHCodeID],
CONSTRAINT [DF_SetUfidaCode_U_XSYHCodeName] DEFAULT ('') FOR [U_XSYHCodeName],
CONSTRAINT [DF_SetUfidaCode_U_VipCardCodeID] DEFAULT ('') FOR [U_VipCardCodeID],
CONSTRAINT [DF_SetUfidaCode_U_VipCardCodeName] DEFAULT ('') FOR [U_VipCardCodeName],
CONSTRAINT [DF_SetUfidaCode_U_DJJCodeID] DEFAULT ('') FOR [U_DJJCodeID],
CONSTRAINT [DF_SetUfidaCode_U_DJJCodeName] DEFAULT ('') FOR [U_DJJCodeName]
GO
CREATE TABLE [dbo].[F_StorBill] (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[FullID] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[ChoiceID] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[Bill_SID] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[Bill_SN] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[BillType] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[ChoiceID_XSCB_QT] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[ChoiceID_XSSR] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[ChoiceID_XSCB_QT_Flag] [bit] NOT NULL ,
[ChoiceID_XSSR_Flag] [bit] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[F_StorBill] WITH NOCHECK ADD
CONSTRAINT [PK_F_StorBill] PRIMARY KEY CLUSTERED
(
[ID]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[F_StorBill] ADD
CONSTRAINT [DF_F_StorBill_BillType] DEFAULT ('') FOR [BillType],
CONSTRAINT [DF_F_StorBill_ChoiceID_XSCB_QT_Flag] DEFAULT (0) FOR [ChoiceID_XSCB_QT_Flag],
CONSTRAINT [DF_F_StorBill_ChoiceID_XSSR_Flag] DEFAULT (0) FOR [ChoiceID_XSSR_Flag]
GO
