USE [SysetiSFI]
GO
/****** Object:  Table [dbo].[SDNEntryType]    Script Date: 10/02/2014 04:41:06 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[SDNEntryType](
	[EntryTypeID] [int] IDENTITY(1,1) NOT NULL,
	[Name] [varchar](50) NULL,
	[Description] [varchar](50) NULL,
 CONSTRAINT [PK_ListEntryType] PRIMARY KEY CLUSTERED 
(
	[EntryTypeID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[SDNKnownAsCategory]    Script Date: 10/02/2014 04:41:07 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[SDNKnownAsCategory](
	[KnownAsCategoryID] [int] IDENTITY(1,1) NOT NULL,
	[Name] [varchar](50) NULL,
	[Description] [varchar](255) NULL,
 CONSTRAINT [PK_KnownAsCategory] PRIMARY KEY CLUSTERED 
(
	[KnownAsCategoryID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[SDNKnownAsType]    Script Date: 10/02/2014 04:41:07 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[SDNKnownAsType](
	[KnownAsTypeID] [int] IDENTITY(1,1) NOT NULL,
	[Name] [varchar](50) NULL,
	[Description] [varchar](255) NULL,
 CONSTRAINT [PK_KnownAsType] PRIMARY KEY CLUSTERED 
(
	[KnownAsTypeID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[SDNList]    Script Date: 10/02/2014 04:41:07 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[SDNList](
	[ListID] [int] IDENTITY(1,1) NOT NULL,
	[Name] [varchar](50) NULL,
	[PublishDate] [datetime] NOT NULL,
	[RecordCount] [int] NULL,
	[Active] [bit] NOT NULL,
	[idProceso] [int] NULL,
	[idTipoLista] [int] NOT NULL,
 CONSTRAINT [PK_List] PRIMARY KEY CLUSTERED 
(
	[ListID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[SDNListEntry]    Script Date: 10/02/2014 04:41:07 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[SDNListEntry](
	[ListID] [int] NOT NULL,
	[ListEntryID] [int] IDENTITY(1,1) NOT NULL,
	[EntryTypeID] [int] NOT NULL,
	[UID] [int] NULL,
	[LastName] [varchar](255) NULL,
	[FirstName] [varchar](255) NULL,
	[Title] [varchar](255) NULL,
	[Remarks] [varchar](255) NULL,
	[FullName]  AS (([FirstName]+' ')+[LastName]),
	[Observacion] [varchar](200) NOT NULL,
 CONSTRAINT [PK_SDNListEntry] PRIMARY KEY CLUSTERED 
(
	[ListID] ASC,
	[ListEntryID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[SDNListEntryKnownAs]    Script Date: 10/02/2014 04:41:07 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[SDNListEntryKnownAs](
	[ListID] [int] NOT NULL,
	[ListEntryID] [int] NOT NULL,
	[ListEntryKnownAsID] [int] IDENTITY(1,1) NOT NULL,
	[EntryTypeID] [int] NOT NULL,
	[KnownAsTypeID] [int] NOT NULL,
	[KnownAsCategoryID] [int] NOT NULL,
	[LastName] [varchar](255) NULL,
	[FirstName] [varchar](255) NULL,
	[FullName]  AS (([FirstName]+' ')+[LastName]),
	[UID] [int] NULL,
 CONSTRAINT [PK_SDNListEntryKnownAs] PRIMARY KEY CLUSTERED 
(
	[ListID] ASC,
	[ListEntryID] ASC,
	[ListEntryKnownAsID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[SDNListEntry]  WITH CHECK ADD  CONSTRAINT [FK_ListEntry_EntryType] FOREIGN KEY([EntryTypeID])
REFERENCES [dbo].[SDNEntryType] ([EntryTypeID])
GO
ALTER TABLE [dbo].[SDNListEntry] CHECK CONSTRAINT [FK_ListEntry_EntryType]
GO
ALTER TABLE [dbo].[SDNListEntryKnownAs]  WITH CHECK ADD  CONSTRAINT [FK_ListEntryKnownAs_KnownAsCategory] FOREIGN KEY([KnownAsCategoryID])
REFERENCES [dbo].[SDNKnownAsCategory] ([KnownAsCategoryID])
GO
ALTER TABLE [dbo].[SDNListEntryKnownAs] CHECK CONSTRAINT [FK_ListEntryKnownAs_KnownAsCategory]
GO
ALTER TABLE [dbo].[SDNListEntryKnownAs]  WITH CHECK ADD  CONSTRAINT [FK_ListEntryKnownAs_KnownAsType] FOREIGN KEY([KnownAsTypeID])
REFERENCES [dbo].[SDNKnownAsType] ([KnownAsTypeID])
GO
ALTER TABLE [dbo].[SDNListEntryKnownAs] CHECK CONSTRAINT [FK_ListEntryKnownAs_KnownAsType]
GO
ALTER TABLE [dbo].[SDNListEntryKnownAs]  WITH CHECK ADD  CONSTRAINT [FK_SDNListEntryKnownAs_SDNEntryType] FOREIGN KEY([EntryTypeID])
REFERENCES [dbo].[SDNEntryType] ([EntryTypeID])
GO
ALTER TABLE [dbo].[SDNListEntryKnownAs] CHECK CONSTRAINT [FK_SDNListEntryKnownAs_SDNEntryType]
GO