(Felipe)
Olá pessoal,
Eu e o Gabriel terminamos de acertar os últimos detalhes da estrutura do Banco de dados e já o fizemos. Eu criei e organizei o Diagrama. Segue o Diagrama e o script completo em cinza (do que temos hoje). A imagem e o script estão após o final do post.
Qualquer dúvida ou SUGESTÃO fale comigo ou com o Gabriel.
Boa noite a todos,
Felipe Campos
Diagrama
Script
CREATE DATABASE [GraphMatic] GO USE [GraphMatic] GO /****** Object: Table [dbo].[Usuario] Script Date: 05/13/2009 00:08:53 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[Usuario]( [Id] [int] IDENTITY(1,1) NOT NULL, [Nome] [char](25) NOT NULL, [Login] [char](25) NOT NULL, [Senha] [char](32) NOT NULL, [Dica] [char](25) NULL, [IdExcluido] [bit] NOT NULL CONSTRAINT [DF_Usuario_IdExcluido] DEFAULT ((0)), [Tipo] [char](1) NOT NULL, CONSTRAINT [PK_Usuario] 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] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[Log] Script Date: 05/13/2009 00:08:53 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[Log]( [Id] [bigint] IDENTITY(1,1) NOT NULL, [IdUsuario] [int] NOT NULL, [Data] [datetime] NOT NULL, [Tabela] [varchar](30) NOT NULL, [Campo] [varchar](30) NOT NULL, [IdRegistro] [int] NOT NULL, [ValorAnterior] [varchar](500) NOT NULL, CONSTRAINT [PK_Log] 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] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[Pergunta] Script Date: 05/13/2009 00:08:53 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[Pergunta]( [Id] [int] IDENTITY(1,1) NOT NULL, [IdQuestionario] [int] NOT NULL, [Nome] [char](200) NOT NULL, [TipoPergunta] [char](1) NOT NULL, [NumPergunta] [int] NOT NULL, [NumAlternativa] [int] NOT NULL, [Excluido] [bit] NOT NULL CONSTRAINT [DF_Pergunta_Excluido] DEFAULT ((0)), CONSTRAINT [PK_Pergunta] 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] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[Questionario] Script Date: 05/13/2009 00:08:53 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Questionario]( [Id] [int] IDENTITY(1,1) NOT NULL, [IdPesquisa] [int] NOT NULL, [NumPerguntas] [int] NOT NULL, [NumRespostas] [int] NOT NULL, [Excluido] [bit] NOT NULL CONSTRAINT [DF_Questionario_Excluido] DEFAULT ((0)), CONSTRAINT [PK_Questionario] 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] GO /****** Object: Table [dbo].[RespostaALT] Script Date: 05/13/2009 00:08:53 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[RespostaALT]( [Id] [int] IDENTITY(1,1) NOT NULL, [IdPergunta] [int] NOT NULL, [Alternativa] [int] NOT NULL, [Excluido] [bit] NOT NULL CONSTRAINT [DF_RespostaALT_Excluido] DEFAULT ((0)), CONSTRAINT [PK_RespostaALT] 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] GO /****** Object: Table [dbo].[AlternativaQL] Script Date: 05/13/2009 00:08:53 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[AlternativaQL]( [Id] [int] IDENTITY(1,1) NOT NULL, [IdPergunta] [int] NOT NULL, [Qualidade] [char](50) NOT NULL, [Excluido] [bit] NOT NULL CONSTRAINT [DF_AlternativaQL_Excluido] DEFAULT ((0)), CONSTRAINT [PK_AlternativaQL] 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] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[AlternativaQT] Script Date: 05/13/2009 00:08:53 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[AlternativaQT]( [Id] [int] IDENTITY(1,1) NOT NULL, [IdPergunta] [int] NOT NULL, [Quantidade] [float] NOT NULL, [Excluido] [bit] NOT NULL CONSTRAINT [DF_AlternativaQT_Excluido] DEFAULT ((0)), CONSTRAINT [PK_AlternativaQT] 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] GO /****** Object: Table [dbo].[RespostaDIS] Script Date: 05/13/2009 00:08:53 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[RespostaDIS]( [Id] [int] IDENTITY(1,1) NOT NULL, [IdPergunta] [int] NOT NULL, [Resposta] [char](500) NOT NULL, [Excluido] [bit] NOT NULL CONSTRAINT [DF_RespostaDIS_Excluido] DEFAULT ((0)), CONSTRAINT [PK_RespostaDIS] 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] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[IntegrantesGrupo] Script Date: 05/13/2009 00:08:53 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[IntegrantesGrupo]( [Id] [int] NOT NULL, [IdUsuario] [int] NOT NULL, [IdGrupo] [int] NOT NULL, CONSTRAINT [PK_IntegrantesGrupo] 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] GO /****** Object: Table [dbo].[Grupo] Script Date: 05/13/2009 00:08:53 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[Grupo]( [Id] [int] IDENTITY(1,1) NOT NULL, [Nome] [char](30) NOT NULL, [Descricao] [char](200) NOT NULL, [Excluido] [bit] NOT NULL CONSTRAINT [DF_Grupo_Excluido] DEFAULT ((0)), [IdOrientador] [int] NOT NULL, CONSTRAINT [PK_Grupo] 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] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[Pesquisa] Script Date: 05/13/2009 00:08:53 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[Pesquisa]( [Id] [int] IDENTITY(1,1) NOT NULL, [IdGrupo] [int] NOT NULL, [Nome] [char](30) NOT NULL, [Descricao] [char](200) NOT NULL, [IdPublic] [char](1) NOT NULL, [Excluido] [bit] NOT NULL CONSTRAINT [DF_Pesquisa_Excluido] DEFAULT ((0)), CONSTRAINT [PK_Pesquisa] 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] GO SET ANSI_PADDING OFF GO /****** Object: ForeignKey [FK_AlternativaQL_Pergunta] Script Date: 05/13/2009 00:08:53 ******/ ALTER TABLE [dbo].[AlternativaQL] WITH CHECK ADD CONSTRAINT [FK_AlternativaQL_Pergunta] FOREIGN KEY([IdPergunta]) REFERENCES [dbo].[Pergunta] ([Id]) GO ALTER TABLE [dbo].[AlternativaQL] CHECK CONSTRAINT [FK_AlternativaQL_Pergunta] GO /****** Object: ForeignKey [FK_AlternativaQT_Pergunta] Script Date: 05/13/2009 00:08:53 ******/ ALTER TABLE [dbo].[AlternativaQT] WITH CHECK ADD CONSTRAINT [FK_AlternativaQT_Pergunta] FOREIGN KEY([IdPergunta]) REFERENCES [dbo].[Pergunta] ([Id]) GO ALTER TABLE [dbo].[AlternativaQT] CHECK CONSTRAINT [FK_AlternativaQT_Pergunta] GO /****** Object: ForeignKey [FK_Grupo_Usuario] Script Date: 05/13/2009 00:08:53 ******/ ALTER TABLE [dbo].[Grupo] WITH CHECK ADD CONSTRAINT [FK_Grupo_Usuario] FOREIGN KEY([IdOrientador]) REFERENCES [dbo].[Usuario] ([Id]) GO ALTER TABLE [dbo].[Grupo] CHECK CONSTRAINT [FK_Grupo_Usuario] GO /****** Object: ForeignKey [FK_IntegrantesGrupo_Grupo] Script Date: 05/13/2009 00:08:53 ******/ ALTER TABLE [dbo].[IntegrantesGrupo] WITH CHECK ADD CONSTRAINT [FK_IntegrantesGrupo_Grupo] FOREIGN KEY([IdGrupo]) REFERENCES [dbo].[Grupo] ([Id]) GO ALTER TABLE [dbo].[IntegrantesGrupo] CHECK CONSTRAINT [FK_IntegrantesGrupo_Grupo] GO /****** Object: ForeignKey [FK_IntegrantesGrupo_Usuario] Script Date: 05/13/2009 00:08:53 ******/ ALTER TABLE [dbo].[IntegrantesGrupo] WITH CHECK ADD CONSTRAINT [FK_IntegrantesGrupo_Usuario] FOREIGN KEY([IdUsuario]) REFERENCES [dbo].[Usuario] ([Id]) GO ALTER TABLE [dbo].[IntegrantesGrupo] CHECK CONSTRAINT [FK_IntegrantesGrupo_Usuario] GO /****** Object: ForeignKey [FK_Pergunta_Questionario] Script Date: 05/13/2009 00:08:53 ******/ ALTER TABLE [dbo].[Pergunta] WITH CHECK ADD CONSTRAINT [FK_Pergunta_Questionario] FOREIGN KEY([IdQuestionario]) REFERENCES [dbo].[Questionario] ([Id]) GO ALTER TABLE [dbo].[Pergunta] CHECK CONSTRAINT [FK_Pergunta_Questionario] GO /****** Object: ForeignKey [FK_Pesquisa_Grupo] Script Date: 05/13/2009 00:08:53 ******/ ALTER TABLE [dbo].[Pesquisa] WITH CHECK ADD CONSTRAINT [FK_Pesquisa_Grupo] FOREIGN KEY([IdGrupo]) REFERENCES [dbo].[Grupo] ([Id]) GO ALTER TABLE [dbo].[Pesquisa] CHECK CONSTRAINT [FK_Pesquisa_Grupo] GO /****** Object: ForeignKey [FK_Questionario_Pesquisa] Script Date: 05/13/2009 00:08:53 ******/ ALTER TABLE [dbo].[Questionario] WITH CHECK ADD CONSTRAINT [FK_Questionario_Pesquisa] FOREIGN KEY([IdPesquisa]) REFERENCES [dbo].[Pesquisa] ([Id]) GO ALTER TABLE [dbo].[Questionario] CHECK CONSTRAINT [FK_Questionario_Pesquisa] GO /****** Object: ForeignKey [FK_RespostaALT_Pergunta] Script Date: 05/13/2009 00:08:53 ******/ ALTER TABLE [dbo].[RespostaALT] WITH CHECK ADD CONSTRAINT [FK_RespostaALT_Pergunta] FOREIGN KEY([IdPergunta]) REFERENCES [dbo].[Pergunta] ([Id]) GO ALTER TABLE [dbo].[RespostaALT] CHECK CONSTRAINT [FK_RespostaALT_Pergunta] GO /****** Object: ForeignKey [FK_RespostaDIS_Pergunta] Script Date: 05/13/2009 00:08:53 ******/ ALTER TABLE [dbo].[RespostaDIS] WITH CHECK ADD CONSTRAINT [FK_RespostaDIS_Pergunta] FOREIGN KEY([IdPergunta]) REFERENCES [dbo].[Pergunta] ([Id]) GO ALTER TABLE [dbo].[RespostaDIS] CHECK CONSTRAINT [FK_RespostaDIS_Pergunta] GO