style24.doc/산출물/3.설계/03.인터페이스/넷퍼시메일/회원동기화테이블_ASIS/TB_BAT_MemberPoint.sql

USE [iSTYLE24_MailBatch]
GO

/****** Object:  Table [dbo].[TB_BAT_MemberPoint]    Script Date: 2021-05-10 오후 1:48:35 ******/
/*******회원의 최종 포인트*********/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[TB_BAT_MemberPoint](
	[MemberGUID] [uniqueidentifier] NOT NULL,
	[LoginId] [nvarchar](100) NOT NULL,       --로그인ID
	[Point] [int] NOT NULL,                   --하루전회원의 최종 포인트 
	[Date] [datetime] NOT NULL,               --하루전일
 CONSTRAINT [PK_TB_BAT_MemberPoint_MemberGUID] PRIMARY KEY CLUSTERED 
(
	[MemberGUID] ASC,
	[Date] ASC
)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]
) ON [PRIMARY]
GO