51 lines
1.5 KiB
MySQL
51 lines
1.5 KiB
MySQL
|
|
|||
|
|
|
|||
|
|
/****** Object: Table [dbo].[ZZZ_SalesRportShareData] Script Date: 2025/3/19 10:16:46 ******/
|
|||
|
|
SET ANSI_NULLS ON
|
|||
|
|
GO
|
|||
|
|
|
|||
|
|
SET QUOTED_IDENTIFIER ON
|
|||
|
|
GO
|
|||
|
|
|
|||
|
|
CREATE TABLE [dbo].[ZZZ_SalesRportShareData](
|
|||
|
|
[<EFBFBD><EFBFBD><EFBFBD>۵<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ID] [INT] NULL,
|
|||
|
|
[<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID] [INT] NULL,
|
|||
|
|
[F_RecConditionId] [INT] NULL,
|
|||
|
|
[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ܶ<EFBFBD>] [DECIMAL](18, 2) NULL,
|
|||
|
|
[<EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ա] [NVARCHAR](50) NULL,
|
|||
|
|
[<EFBFBD><EFBFBD>̯<EFBFBD><EFBFBD><EFBFBD><EFBFBD>] [DECIMAL](18, 2) NULL,
|
|||
|
|
[<EFBFBD><EFBFBD>̯<EFBFBD><EFBFBD><EFBFBD><EFBFBD>] [DECIMAL](18, 6) NULL,
|
|||
|
|
[SBU] [NVARCHAR](200) NULL,
|
|||
|
|
[<EFBFBD><EFBFBD>ϸ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>] [NVARCHAR](100) NULL,
|
|||
|
|
[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>λ] [NVARCHAR](255) NULL,
|
|||
|
|
[<EFBFBD><EFBFBD>˾<EFBFBD><EFBFBD><EFBFBD><EFBFBD>] [NVARCHAR](255) NULL,
|
|||
|
|
[<EFBFBD>ͻ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] [NVARCHAR](255) NULL,
|
|||
|
|
[ֽ<EFBFBD>ʺ<EFBFBD>ͬ<EFBFBD><EFBFBD>] [NVARCHAR](1000) NULL,
|
|||
|
|
[<EFBFBD><EFBFBD>Ŀ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>] [NVARCHAR](255) NULL,
|
|||
|
|
[ǩ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] [NVARCHAR](10) NULL,
|
|||
|
|
[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] [DATETIME] NULL,
|
|||
|
|
[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] [DATETIME] NULL,
|
|||
|
|
[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ۼƷ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] [DECIMAL](38, 10) NULL,
|
|||
|
|
[<EFBFBD><EFBFBD>Ʊ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>] [DATETIME] NULL,
|
|||
|
|
[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ۼ<EFBFBD><EFBFBD>˻<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] [DECIMAL](38, 10) NULL,
|
|||
|
|
[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ۼƿ<EFBFBD>Ʊ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>] [DECIMAL](18, 6) NULL,
|
|||
|
|
[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ۼƵ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] [DECIMAL](38, 10) NULL,
|
|||
|
|
[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ܶ<EFBFBD>] [DECIMAL](18, 6) NULL,
|
|||
|
|
[<EFBFBD>ۼƷ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] [DECIMAL](18, 6) NULL,
|
|||
|
|
[<EFBFBD>ۼ<EFBFBD><EFBFBD>˻<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] [DECIMAL](18, 6) NULL,
|
|||
|
|
[<EFBFBD>ۼƿ<EFBFBD>Ʊ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>] [DECIMAL](18, 6) NULL,
|
|||
|
|
[Ӧ<EFBFBD>տ<EFBFBD><EFBFBD>ϼ<EFBFBD>] [DECIMAL](18, 6) NULL,
|
|||
|
|
[<EFBFBD>ۼƵ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] [DECIMAL](18, 6) NULL,
|
|||
|
|
[<EFBFBD><EFBFBD>֯ID] [INT] NULL,
|
|||
|
|
[<EFBFBD><EFBFBD><EFBFBD>۶<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] [NVARCHAR](500) NULL,
|
|||
|
|
[<EFBFBD>տ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ID] [INT] NULL,
|
|||
|
|
[<EFBFBD>տ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] [NVARCHAR](205) NULL,
|
|||
|
|
[Ӧ<EFBFBD>յ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] [DATETIME] NULL
|
|||
|
|
) ON [PRIMARY]
|
|||
|
|
GO
|
|||
|
|
|
|||
|
|
ALTER TABLE [dbo].[ZZZ_SalesRportShareData] ADD CONSTRAINT [DF_ZZZ_SalesRportShareData_<EFBFBD><EFBFBD>Ʊ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>] DEFAULT (NULL) FOR [<EFBFBD><EFBFBD>Ʊ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>]
|
|||
|
|
GO
|
|||
|
|
|
|||
|
|
|