TB_BAT_MemberPoint.sql 815 B

123456789101112131415161718192021222324252627
  1. USE [iSTYLE24_MailBatch]
  2. GO
  3. /****** Object: Table [dbo].[TB_BAT_MemberPoint] Script Date: 2021-05-10 오후 1:48:35 ******/
  4. /*******회원의 최종 포인트*********/
  5. SET ANSI_NULLS ON
  6. GO
  7. SET QUOTED_IDENTIFIER ON
  8. GO
  9. CREATE TABLE [dbo].[TB_BAT_MemberPoint](
  10. [MemberGUID] [uniqueidentifier] NOT NULL,
  11. [LoginId] [nvarchar](100) NOT NULL, --로그인ID
  12. [Point] [int] NOT NULL, --하루전회원의 최종 포인트
  13. [Date] [datetime] NOT NULL, --하루전일
  14. CONSTRAINT [PK_TB_BAT_MemberPoint_MemberGUID] PRIMARY KEY CLUSTERED
  15. (
  16. [MemberGUID] ASC,
  17. [Date] ASC
  18. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 80, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
  19. ) ON [PRIMARY]
  20. GO