· 6 years ago · May 07, 2019, 01:02 PM
1/****** Object: Table [dbo].[TDU_ValoresRecolhidosMarcacao] Script Date: 07-05-2019 13:58:30 ******/
2SET ANSI_NULLS ON
3GO
4
5SET QUOTED_IDENTIFIER ON
6GO
7
8IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TDU_ValoresRecolhidosMarcacao]') AND type in (N'U'))
9BEGIN
10CREATE TABLE [dbo].[TDU_ValoresRecolhidosMarcacao](
11 [CDU_ID] [int] IDENTITY(1,1) NOT NULL,
12 [CDU_IDMARCACAO] [int] NULL,
13 [CDU_Fase] [uniqueidentifier] NULL,
14 [CDU_Zona] [int] NULL,
15 [CDU_Artigo] [nvarchar](48) NULL,
16 [CDU_Descricao] [nvarchar](512) NULL,
17 [CDU_Quantidade] [float] NULL,
18 [CDU_Unidade] [nvarchar](5) NULL,
19 [CDU_PrecoUnitario] [float] NULL,
20 [CDU_Desconto] [float] NULL,
21 [CDU_CodIva] [nvarchar](2) NULL,
22 [CDU_TaxaIva] [float] NULL,
23 [CDU_ValorIva] [float] NULL,
24 [CDU_ValorLiquido] [float] NULL,
25 [CDU_ValorBruto] [float] NULL,
26 [CDU_Confirmado] [bit] NULL,
27 [CDU_UtilizadorConfirmou] [int] NULL,
28 [CDU_DataConfirmacao] [datetime] NULL,
29 [CDU_Observacoes] [nvarchar](1000) NULL,
30 [CDU_Imagens] [nvarchar](4000) NULL,
31 [CDU_Anexos] [nvarchar](4000) NULL,
32 [DataInsercao] [datetime] NULL,
33 [UtilizadorInsercao] [int] NULL,
34 [DataAtualizacao] [datetime] NULL,
35 [UtilizadorAtualizacao] [int] NULL,
36 CONSTRAINT [PK_TDU_ValoresRecolhidosMarcacao] PRIMARY KEY CLUSTERED
37(
38 [CDU_ID] ASC
39)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
40) ON [PRIMARY]
41END
42GO
43
44IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[DF_TDU_ValoresRecolhidosMarcacao_DataInsercao]') AND type = 'D')
45BEGIN
46ALTER TABLE [dbo].[TDU_ValoresRecolhidosMarcacao] ADD CONSTRAINT [DF_TDU_ValoresRecolhidosMarcacao_DataInsercao] DEFAULT (getdate()) FOR [DataInsercao]
47END
48GO
49
50IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[DF_TDU_ValoresRecolhidosMarcacao_DataAtualizacao]') AND type = 'D')
51BEGIN
52ALTER TABLE [dbo].[TDU_ValoresRecolhidosMarcacao] ADD CONSTRAINT [DF_TDU_ValoresRecolhidosMarcacao_DataAtualizacao] DEFAULT (getdate()) FOR [DataAtualizacao]
53END
54GO
55
56IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_TDU_ValoresRecolhidosMarcacao_Artigo]') AND parent_object_id = OBJECT_ID(N'[dbo].[TDU_ValoresRecolhidosMarcacao]'))
57ALTER TABLE [dbo].[TDU_ValoresRecolhidosMarcacao] WITH CHECK ADD CONSTRAINT [FK_TDU_ValoresRecolhidosMarcacao_Artigo] FOREIGN KEY([CDU_Artigo])
58REFERENCES [dbo].[Artigo] ([Artigo])
59GO
60
61IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_TDU_ValoresRecolhidosMarcacao_Artigo]') AND parent_object_id = OBJECT_ID(N'[dbo].[TDU_ValoresRecolhidosMarcacao]'))
62ALTER TABLE [dbo].[TDU_ValoresRecolhidosMarcacao] CHECK CONSTRAINT [FK_TDU_ValoresRecolhidosMarcacao_Artigo]
63GO
64
65IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_TDU_ValoresRecolhidosMarcacao_COP_Obras]') AND parent_object_id = OBJECT_ID(N'[dbo].[TDU_ValoresRecolhidosMarcacao]'))
66ALTER TABLE [dbo].[TDU_ValoresRecolhidosMarcacao] WITH CHECK ADD CONSTRAINT [FK_TDU_ValoresRecolhidosMarcacao_COP_Obras] FOREIGN KEY([CDU_Fase])
67REFERENCES [dbo].[COP_Obras] ([ID])
68GO
69
70IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_TDU_ValoresRecolhidosMarcacao_COP_Obras]') AND parent_object_id = OBJECT_ID(N'[dbo].[TDU_ValoresRecolhidosMarcacao]'))
71ALTER TABLE [dbo].[TDU_ValoresRecolhidosMarcacao] CHECK CONSTRAINT [FK_TDU_ValoresRecolhidosMarcacao_COP_Obras]
72GO
73
74IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_TDU_ValoresRecolhidosMarcacao_Iva]') AND parent_object_id = OBJECT_ID(N'[dbo].[TDU_ValoresRecolhidosMarcacao]'))
75ALTER TABLE [dbo].[TDU_ValoresRecolhidosMarcacao] WITH CHECK ADD CONSTRAINT [FK_TDU_ValoresRecolhidosMarcacao_Iva] FOREIGN KEY([CDU_CodIva])
76REFERENCES [dbo].[Iva] ([Iva])
77GO
78
79IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_TDU_ValoresRecolhidosMarcacao_Iva]') AND parent_object_id = OBJECT_ID(N'[dbo].[TDU_ValoresRecolhidosMarcacao]'))
80ALTER TABLE [dbo].[TDU_ValoresRecolhidosMarcacao] CHECK CONSTRAINT [FK_TDU_ValoresRecolhidosMarcacao_Iva]
81GO
82
83IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_TDU_ValoresRecolhidosMarcacao_TDU_MarcacoesTarefas]') AND parent_object_id = OBJECT_ID(N'[dbo].[TDU_ValoresRecolhidosMarcacao]'))
84ALTER TABLE [dbo].[TDU_ValoresRecolhidosMarcacao] WITH CHECK ADD CONSTRAINT [FK_TDU_ValoresRecolhidosMarcacao_TDU_MarcacoesTarefas] FOREIGN KEY([CDU_IDMARCACAO])
85REFERENCES [dbo].[TDU_MarcacoesTarefas] ([CDU_Id])
86GO
87
88IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_TDU_ValoresRecolhidosMarcacao_TDU_MarcacoesTarefas]') AND parent_object_id = OBJECT_ID(N'[dbo].[TDU_ValoresRecolhidosMarcacao]'))
89ALTER TABLE [dbo].[TDU_ValoresRecolhidosMarcacao] CHECK CONSTRAINT [FK_TDU_ValoresRecolhidosMarcacao_TDU_MarcacoesTarefas]
90GO
91
92IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_TDU_ValoresRecolhidosMarcacao_TDU_Zonas]') AND parent_object_id = OBJECT_ID(N'[dbo].[TDU_ValoresRecolhidosMarcacao]'))
93ALTER TABLE [dbo].[TDU_ValoresRecolhidosMarcacao] WITH CHECK ADD CONSTRAINT [FK_TDU_ValoresRecolhidosMarcacao_TDU_Zonas] FOREIGN KEY([CDU_Zona])
94REFERENCES [dbo].[TDU_Zonas] ([CDU_ID])
95GO
96
97IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_TDU_ValoresRecolhidosMarcacao_TDU_Zonas]') AND parent_object_id = OBJECT_ID(N'[dbo].[TDU_ValoresRecolhidosMarcacao]'))
98ALTER TABLE [dbo].[TDU_ValoresRecolhidosMarcacao] CHECK CONSTRAINT [FK_TDU_ValoresRecolhidosMarcacao_TDU_Zonas]
99GO
100
101IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_TDU_ValoresRecolhidosMarcacao_Unidades]') AND parent_object_id = OBJECT_ID(N'[dbo].[TDU_ValoresRecolhidosMarcacao]'))
102ALTER TABLE [dbo].[TDU_ValoresRecolhidosMarcacao] WITH CHECK ADD CONSTRAINT [FK_TDU_ValoresRecolhidosMarcacao_Unidades] FOREIGN KEY([CDU_Unidade])
103REFERENCES [dbo].[Unidades] ([Unidade])
104GO
105
106IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_TDU_ValoresRecolhidosMarcacao_Unidades]') AND parent_object_id = OBJECT_ID(N'[dbo].[TDU_ValoresRecolhidosMarcacao]'))
107ALTER TABLE [dbo].[TDU_ValoresRecolhidosMarcacao] CHECK CONSTRAINT [FK_TDU_ValoresRecolhidosMarcacao_Unidades]
108GO
109
110IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_TDU_ValoresRecolhidosMarcacao_Users]') AND parent_object_id = OBJECT_ID(N'[dbo].[TDU_ValoresRecolhidosMarcacao]'))
111ALTER TABLE [dbo].[TDU_ValoresRecolhidosMarcacao] WITH CHECK ADD CONSTRAINT [FK_TDU_ValoresRecolhidosMarcacao_Users] FOREIGN KEY([CDU_UtilizadorConfirmou])
112REFERENCES [dbo].[Users] ([UserId])
113GO
114
115IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_TDU_ValoresRecolhidosMarcacao_Users]') AND parent_object_id = OBJECT_ID(N'[dbo].[TDU_ValoresRecolhidosMarcacao]'))
116ALTER TABLE [dbo].[TDU_ValoresRecolhidosMarcacao] CHECK CONSTRAINT [FK_TDU_ValoresRecolhidosMarcacao_Users]
117GO
118
119IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_TDU_ValoresRecolhidosMarcacao_Users1]') AND parent_object_id = OBJECT_ID(N'[dbo].[TDU_ValoresRecolhidosMarcacao]'))
120ALTER TABLE [dbo].[TDU_ValoresRecolhidosMarcacao] WITH CHECK ADD CONSTRAINT [FK_TDU_ValoresRecolhidosMarcacao_Users1] FOREIGN KEY([UtilizadorInsercao])
121REFERENCES [dbo].[Users] ([UserId])
122GO
123
124IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_TDU_ValoresRecolhidosMarcacao_Users1]') AND parent_object_id = OBJECT_ID(N'[dbo].[TDU_ValoresRecolhidosMarcacao]'))
125ALTER TABLE [dbo].[TDU_ValoresRecolhidosMarcacao] CHECK CONSTRAINT [FK_TDU_ValoresRecolhidosMarcacao_Users1]
126GO
127
128IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_TDU_ValoresRecolhidosMarcacao_Users2]') AND parent_object_id = OBJECT_ID(N'[dbo].[TDU_ValoresRecolhidosMarcacao]'))
129ALTER TABLE [dbo].[TDU_ValoresRecolhidosMarcacao] WITH CHECK ADD CONSTRAINT [FK_TDU_ValoresRecolhidosMarcacao_Users2] FOREIGN KEY([UtilizadorAtualizacao])
130REFERENCES [dbo].[Users] ([UserId])
131GO
132
133IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_TDU_ValoresRecolhidosMarcacao_Users2]') AND parent_object_id = OBJECT_ID(N'[dbo].[TDU_ValoresRecolhidosMarcacao]'))
134ALTER TABLE [dbo].[TDU_ValoresRecolhidosMarcacao] CHECK CONSTRAINT [FK_TDU_ValoresRecolhidosMarcacao_Users2]
135GO