Lucky Draw Data structure

/****** object:table [dbo].    [Sweepstakes] Script date:12/15/2014 08:50:41 ******/set ansi_nulls ongoset quoted_identifier ongocreate TABLE [dbo]. [Sweepstakes] ([ID] [int] IDENTITY (n) not null,[title] [nvarchar] (NO) null,[detail] [ntext] not null,[starttime] [datetime] Not N Ull,[endtime] [datetime] not Null,[ihit] [int.] NOT Null,[participatetimes] [int.] not Null,[modifytime] [datetime] Not NULL , [bactive] [bit] not null,[keyword] [nvarchar] (NO) null,[daytrytimes] [int] not null,[itotaltime] [int.] Not NULL, CON STRAINT [Pk_sweepstakes] PRIMARY KEY CLUSTERED ([id] 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]goexec sys.sp_ Addextendedproperty @name =n ' ms_description ', @value =n ' activity name ', @level0type =n ' SCHEMA ', @level0name =n ' dbo ', @level1type =n ' TABLE ', @level1name =n ' sweepstakes ', @level2type =n ' COLUMN ', @level2name =n ' title ' Goexec Sys.sp_addextendedpropertY @name =n ' ms_description ', @value =n ' activity details ', @level0type =n ' SCHEMA ', @level0name =n ' dbo ', @level1type =n ' TABLE ', @ Level1name=n ' Sweepstakes ', @level2type =n ' COLUMN ', @level2name =n ' detail ' goexec sys.sp_addextendedproperty @name =n ' Ms_description ', @value =n ' activity start time ', @level0type =n ' SCHEMA ', @level0name =n ' dbo ', @level1type =n ' TABLE ', @level1name =n ' Sweepstakes ', @level2type =n ' COLUMN ', @level2name =n ' startTime ' goexec sys.sp_addextendedproperty @name =n ' Ms_ Description ', @value =n ' activity end Time ', @level0type =n ' SCHEMA ', @level0name =n ' dbo ', @level1type =n ' TABLE ', @level1name =n ' Sweepstakes ', @level2type =n ' COLUMN ', @level2name =n ' endTime ' goexec sys.sp_addextendedproperty @name =n ' Ms_ Description ', @value =n ' hits ', @level0type =n ' SCHEMA ', @level0name =n ' dbo ', @level1type =n ' TABLE ', @level1name =n ' Sweepstakes ', @level2type =n ' COLUMN ', @level2name =n ' ihit ' goexec sys.sp_addextendedproperty @name =n ' ms_description ', @value =n ' participant ', @level0type =n ' SCHEMA ', @level0name =n ' dbo ', @level1type =n ' TABLE ', @level1name =n ' sweepstakes ', @ Level2type=n ' COLUMN', @level2name =n ' participatetimes ' goexec sys.sp_addextendedproperty @name =n ' ms_description ', @value =n ' last edit time ', @ Level0type=n ' SCHEMA ', @level0name =n ' dbo ', @level1type =n ' TABLE ', @level1name =n ' sweepstakes ', @level2type =n ' COLUMN ', @level2name =n ' modifytime ' goexec sys.sp_addextendedproperty @name =n ' ms_description ', @value =n ' is enabled ', @level0type =n ' SCHEMA ', @level0name =n ' dbo ', @level1type =n ' TABLE ', @level1name =n ' sweepstakes ', @level2type =n ' COLUMN ', @level2name =n ' bactive ' goexec sys.sp_addextendedproperty @name =n ' ms_description ', @value =n ' sweepstakes keyword ', @level0type =n ' SCHEMA ', @ Level0name=n ' dbo ', @level1type =n ' TABLE ', @level1name =n ' sweepstakes ', @level2type =n ' COLUMN ', @level2name =n ' keyword ' Goexec sys.sp_addextendedproperty @name =n ' ms_description ', @value =n ' per person per day (1 means no limit) ', @level0type =n ' SCHEMA ', @ Level0name=n ' dbo ', @level1type =n ' TABLE ', @level1name =n ' sweepstakes ', @level2type =n ' COLUMN ', @level2name =n ' Daytrytimes ' goexec sys.sp_addextendedproperty @name =n ' ms_description ', @value =n ' total number of draws (-1 means no limit) ', @level0tyPe=n ' SCHEMA ', @level0name =n ' dbo ', @level1type =n ' TABLE ', @level1name =n ' sweepstakes ', @level2type =n ' COLUMN ', @ Level2name=n ' itotaltime ' goalter TABLE [dbo]. [Sweepstakes] ADD CONSTRAINT [Df_sweepstakes_title] DEFAULT (N ') for [Title]goalter TABLE [dbo]. [Sweepstakes] ADD CONSTRAINT [Df_sweepstakes_detail] DEFAULT (N ') for [Detail]goalter TABLE [dbo]. [Sweepstakes] ADD CONSTRAINT [df_sweepstakes_bactive] DEFAULT ((0)) for [Bactive]goalter TABLE [dbo]. [Sweepstakes] ADD CONSTRAINT [Df_sweepstakes_daytrytimes] DEFAULT ((1)) for [Daytrytimes]goalter TABLE [dbo]. [Sweepstakes] ADD CONSTRAINT [Df_sweepstakes_itotaltime] DEFAULT (( -1)) for [itotaltime]go/****** object:table [dbo]. [Sweepstakesitem] Script date:12/15/2014 08:52:21 ******/set ansi_nulls ongoset quoted_identifier ongocreate TABLE [dbo]. [Sweepstakesitem] ([ID] [int] IDENTITY (a) not NULL,[ISWEEPSTAKESID] [int.] not null,[itemname] [nvarchar] (a) not null,[prize] [nvarchar] ( () not null,[prizepic] [nvarchar] (+) not Null,[probabIlity] [decimal] (9) not Null,[maxcount] [int.] NOT Null,[iorder] [int.] Not Null,constraint [Pk_sweepstakesitem] PRIMARY KEY CLUSTERED ([id] ASC) with (Pad_index = off, Statistics_norecompute = off, Ignore_dup_key = off, Allow_row_locks = ON, Allow_page_locks = ON) on [PRIMARY]) on [primary]goexec sys.sp_addextendedproperty @name =n ' ms_description ', @value =n ' Prize name ', @level0type =n ' SCHEMA ', @level0name =n ' dbo ', @level1type =n ' TABLE ', @level1name =n ' Sweepstakesitem ', @level2type =n ' COLUMN ', @level2name =n ' itemname ' goexec sys.sp_addextendedproperty @name =n ' ms_description ', @value =n ' prizes ', @ Level0type=n ' SCHEMA ', @level0name =n ' dbo ', @level1type =n ' TABLE ', @level1name =n ' Sweepstakesitem ', @level2type =n ' COLUMN ', @level2name =n ' Prize ' goexec sys.sp_addextendedproperty @name =n ' ms_description ', @value =n ' prize picture ', @level0type =n ' SCHEMA ', @level0name =n ' dbo ', @level1type =n ' TABLE ', @level1name =n ' Sweepstakesitem ', @level2type =n ' COLUMN ', @ Level2name=n ' prizepic ' goexec sys.sp_addextendedproperty @name =n ' ms_description ', @valuE=n ' odds of winning ', @level0type =n ' SCHEMA ', @level0name =n ' dbo ', @level1type =n ' TABLE ', @level1name =n ' Sweepstakesitem ', @ Level2type=n ' COLUMN ', @level2name =n ' probability ' goexec sys.sp_addextendedproperty @name =n ' ms_description ', @value = N ' award max number ', @level0type =n ' SCHEMA ', @level0name =n ' dbo ', @level1type =n ' TABLE ', @level1name =n ' Sweepstakesitem ', @ Level2type=n ' COLUMN ', @level2name =n ' MaxCount ' goexec sys.sp_addextendedproperty @name =n ' ms_description ', @value =n ' Sort ', @level0type =n ' SCHEMA ', @level0name =n ' dbo ', @level1type =n ' TABLE ', @level1name =n ' Sweepstakesitem ', @level2type =n ' COLUMN ', @level2name =n ' Iorder ' goalter TABLE [dbo]. [Sweepstakesitem] ADD CONSTRAINT [Df_sweepstakesitem_itemname] DEFAULT (N ') for [Itemname]goalter TABLE [dbo]. [Sweepstakesitem] ADD CONSTRAINT [df_sweepstakesitem_prize] DEFAULT (N ') for [Prize]goalter TABLE [dbo]. [Sweepstakesitem] ADD CONSTRAINT [Df_sweepstakesitem_prizepic] DEFAULT (N ') for [Prizepic]goalter TABLE [dbo]. [Sweepstakesitem] ADD CONSTRAINT [df_sweepstakesitem_probability] DEFAULT ((0)) for [Probability]goalter TABLE [dbo]. [Sweepstakesitem] ADD CONSTRAINT [Df_sweepstakesitem_maxcount] DEFAULT ((0)) for [Maxcount]goalter TABLE [dbo]. [Sweepstakesitem] ADD CONSTRAINT [Df_sweepstakesitem_iorder] DEFAULT ((0)) for [iorder]go use [db_shopbest]go/****** object:table [dbo]. [Sweepstakesrecord] Script date:12/15/2014 08:52:31 ******/set ansi_nulls ongoset quoted_identifier ongocreate TABLE [dbo]. [Sweepstakesrecord] ([id] [bigint] IDENTITY (max) not null,[man] [nvarchar] (+) not null,[manip] [nvarchar] (NO) null,[isweepstakesid] [in T] null,[date] [datetime] not NULL) on [primary]goexec sys.sp_addextendedproperty @name =n ' ms_description ', @value =n ' Participant ', @level0type =n ' SCHEMA ', @level0name =n ' dbo ', @level1type =n ' TABLE ', @level1name =n ' Sweepstakesrecord ', @ Level2type=n ' COLUMN ', @level2name =n ' man ' goexec sys.sp_addextendedproperty @name =n ' ms_description ', @value =n ' participant IP ' , @level0type =n ' SCHEMA ', @level0name =n ' dbo ', @level1type =n ' TABLE ', @level1name =n ' Sweepstakesrecord ', @Level2type=n ' COLUMN ', @level2name =n ' ManIP ' goexec sys.sp_addextendedproperty @name =n ' ms_description ', @value =n ' Raffle ID ', @level0type =n ' SCHEMA ', @level0name =n ' dbo ', @level1type =n ' TABLE ', @level1name =n ' Sweepstakesrecord ', @ Level2type=n ' COLUMN ', @level2name =n ' isweepstakesid ' goexec sys.sp_addextendedproperty @name =n ' ms_description ', @ Value=n ' Draw Date ', @level0type =n ' SCHEMA ', @level0name =n ' dbo ', @level1type =n ' TABLE ', @level1name =n ' Sweepstakesrecord ', @ Level2type=n ' COLUMN ', @level2name =n ' date ' goalter TABLE [dbo]. [Sweepstakesrecord] ADD CONSTRAINT [df_sweepstakesrecord_date] DEFAULT (GETDATE ()) for [date]go use [db_shopbest]go/****** object:table [dbo] ]. [Sweepstakeswinning] Script date:12/15/2014 08:52:39 ******/set ansi_nulls ongoset quoted_identifier ongocreate TABLE [dbo]. [Sweepstakeswinning] ([ID] [int] IDENTITY () not null,[winningman] [nvarchar] (a) not null,[winningnumber] [nvarchar] (NO) null,[ ISWEEPSTAKESID] [int] not NULL,[IITEMID] [int.] not Null,[winningtime] [datetime] not null,[bused] [Bit] Not null,[busedtime] [datetime] null,[busedip] [nvarchar] (a) not null,constraint [pk_sweepstakeswinning] PRIMARY KEY CLUSTERED ([id] ASC) with (Pad_index = off, Statistics_norecompute = off, Ignore_dup_key = off, Allow_row_locks = ON, allow _page_locks = ON) on [PRIMARY]) on [primary]goexec sys.sp_addextendedproperty @name =n ' ms_description ', @value =n ' winner ', @l Evel0type=n ' SCHEMA ', @level0name =n ' dbo ', @level1type =n ' TABLE ', @level1name =n ' sweepstakeswinning ', @level2type =n ' COLUMN ', @level2name =n ' Winningman ' goexec sys.sp_addextendedproperty @name =n ' ms_description ', @value =n ' winning password ', @ Level0type=n ' SCHEMA ', @level0name =n ' dbo ', @level1type =n ' TABLE ', @level1name =n ' sweepstakeswinning ', @level2type =n ' COLUMN ', @level2name =n ' winningnumber ' goexec sys.sp_addextendedproperty @name =n ' ms_description ', @value =n ' activity id ', @ Level0type=n ' SCHEMA ', @level0name =n ' dbo ', @level1type =n ' TABLE ', @level1name =n ' sweepstakeswinning ', @level2type =n ' COLUMN ', @level2name =n ' isweepstakesid ' goexec sys.sp_addextendedproperty @name =N ' ms_description ', @value =n ' prize id ', @level0type =n ' SCHEMA ', @level0name =n ' dbo ', @level1type =n ' TABLE ', @level1name =n ' Sweepstakeswinning ', @level2type =n ' COLUMN ', @level2name =n ' iitemid ' goexec sys.sp_addextendedproperty @name =n ' Ms_ Description ', @value =n ' winning time ', @level0type =n ' SCHEMA ', @level0name =n ' dbo ', @level1type =n ' TABLE ', @level1name =n ' Sweepstakeswinning ', @level2type =n ' COLUMN ', @level2name =n ' winningtime ' goexec sys.sp_addextendedproperty @name =n ' MS _description ', @value =n ' password is used ', @level0type =n ' SCHEMA ', @level0name =n ' dbo ', @level1type =n ' TABLE ', @level1name =n ' Sweepstakeswinning ', @level2type =n ' COLUMN ', @level2name =n ' bused ' goexec sys.sp_addextendedproperty @name =n ' Ms_ Description ', @value =n ' password used time ', @level0type =n ' SCHEMA ', @level0name =n ' dbo ', @level1type =n ' TABLE ', @level1name =n ' Sweepstakeswinning ', @level2type =n ' COLUMN ', @level2name =n ' busedtime ' goexec sys.sp_addextendedproperty @name =n ' Ms_ Description ', @value =n ' used IP ', @level0type =n ' SCHEMA ', @level0name =n ' dbo ', @level1type =n ' TABLE ', @level1name =n ' SweePstakeswinning ', @level2type =n ' COLUMN ', @level2name =n ' Busedip ' goalter TABLE [dbo]. [Sweepstakeswinning] ADD CONSTRAINT [Df_sweepstakeswinning_winningman] DEFAULT (N ') for [Winningman]goalter TABLE [dbo]. [Sweepstakeswinning] 　　 ADD CONSTRAINT [Df_sweepstakeswinning_busedip] DEFAULT (N ") for [Busedip]go

　　

Lucky Draw Data structure