Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- GO
- /****** Object: Table [dbo].[Price] Script Date: 10/03/2013 18:40:55 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- SET ANSI_PADDING ON
- GO
- CREATE TABLE [dbo].[Price](
- [id_service] [SMALLINT] NOT NULL,
- [id_city] [INT] NOT NULL,
- [id_firm] [INT] NOT NULL,
- [id_price] [INT] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
- [id_rqp] [INT] NULL,
- [id_user] [SMALLINT] NULL,
- [id_producer_goods] [tinyint] NOT NULL,
- [id_group] [SMALLINT] NOT NULL,
- [id_subgroup] [SMALLINT] NOT NULL,
- [id_application] [tinyint] NOT NULL,
- [id_producer_country] [SMALLINT] NOT NULL,
- [time_stamp] [TIMESTAMP] NOT NULL,
- [datetime] [smalldatetime] NOT NULL,
- [deadline] [smalldatetime] NULL,
- [priority] [tinyint] NOT NULL,
- [include] [tinyint] NOT NULL,
- [dispetcher] [tinyint] NOT NULL,
- [global] [tinyint] NOT NULL,
- [region] [tinyint] NOT NULL,
- [internet] [tinyint] NOT NULL,
- [publish] [tinyint] NOT NULL,
- [edit] [dbo].[bit_set_0] NOT NULL,
- [blocked] [dbo].[bit_set_0] NOT NULL,
- [exist_image] [dbo].[bit_set_0] NOT NULL,
- [name] [VARCHAR](256) NULL,
- [name_original] [VARCHAR](256) NULL,
- [manufacture] [VARCHAR](64) NULL,
- [unit] [VARCHAR](32) NULL,
- [pack] [VARCHAR](32) NULL,
- [info] [VARCHAR](3000) NULL,
- [image] [image] NULL,
- [extended] [CHAR](4) NULL,
- [dispetcher_on_another] [bit] NULL,
- [image_small] [image] NULL,
- [exist_image_small] [bit] NULL,
- [extended_image_small] [CHAR](4) NULL,
- [discount_yes] [bit] NULL,
- [discount_values] [DECIMAL](11, 2) NULL,
- [id_hist_image] [INT] NULL,
- [id_description] [INT] NULL,
- [id_hist_image_kupon] [INT] NULL,
- CONSTRAINT [PK__Price__2334397B] PRIMARY KEY CLUSTERED
- (
- [id_service] ASC,
- [id_city] ASC,
- [id_firm] ASC,
- [id_price] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 70) ON [PRIMARY]
- ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
- GO
- SET ANSI_PADDING OFF
- GO
- ALTER TABLE [dbo].[Price] WITH NOCHECK ADD CONSTRAINT [FK__Price__3BCADD1B] FOREIGN KEY([id_group], [id_subgroup])
- REFERENCES [dbo].[Subgroup] ([id_group], [id_subgroup])
- GO
- ALTER TABLE [dbo].[Price] CHECK CONSTRAINT [FK__Price__3BCADD1B]
- GO
- ALTER TABLE [dbo].[Price] WITH NOCHECK ADD CONSTRAINT [FK__Price__3DB3258D] FOREIGN KEY([id_service], [id_firm], [id_city])
- REFERENCES [dbo].[Firm] ([id_service], [id_firm], [id_city])
- GO
- ALTER TABLE [dbo].[Price] CHECK CONSTRAINT [FK__Price__3DB3258D]
- GO
- ALTER TABLE [dbo].[Price] WITH NOCHECK ADD CONSTRAINT [FK__Price__id_applic__3AD6B8E2] FOREIGN KEY([id_application])
- REFERENCES [dbo].[Application] ([id_application])
- GO
- ALTER TABLE [dbo].[Price] CHECK CONSTRAINT [FK__Price__id_applic__3AD6B8E2]
- GO
- ALTER TABLE [dbo].[Price] WITH NOCHECK ADD CONSTRAINT [FK__Price__id_produc__3F9B6DFF] FOREIGN KEY([id_producer_goods])
- REFERENCES [dbo].[Producer_goods] ([id_producer_goods])
- GO
- ALTER TABLE [dbo].[Price] CHECK CONSTRAINT [FK__Price__id_produc__3F9B6DFF]
- GO
- ALTER TABLE [dbo].[Price] WITH NOCHECK ADD CONSTRAINT [FK__Price__id_rqp__3CBF0154] FOREIGN KEY([id_rqp])
- REFERENCES [dbo].[Rqp] ([id_rqp])
- GO
- ALTER TABLE [dbo].[Price] CHECK CONSTRAINT [FK__Price__id_rqp__3CBF0154]
- GO
- ALTER TABLE [dbo].[Price] WITH NOCHECK ADD CONSTRAINT [FK_Price_id_user] FOREIGN KEY([id_user])
- REFERENCES [dbo].[Users] ([id_user])
- GO
- ALTER TABLE [dbo].[Price] CHECK CONSTRAINT [FK_Price_id_user]
- GO
- ALTER TABLE [dbo].[Price] WITH NOCHECK ADD CONSTRAINT [R_152] FOREIGN KEY([id_producer_country])
- REFERENCES [dbo].[Producer_country] ([id_producer_country])
- GO
- ALTER TABLE [dbo].[Price] CHECK CONSTRAINT [R_152]
- GO
- ALTER TABLE [dbo].[Price] ADD CONSTRAINT [NULL62] DEFAULT (NULL) FOR [deadline]
- GO
- USE [ratiss]
- GO
- /****** Object: Table [dbo].[Price] Script Date: 10/03/2013 18:40:55 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- SET ANSI_PADDING ON
- GO
- CREATE TABLE [dbo].[Price](
- [id_service] [SMALLINT] NOT NULL,
- [id_city] [INT] NOT NULL,
- [id_firm] [INT] NOT NULL,
- [id_price] [INT] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
- [id_rqp] [INT] NULL,
- [id_user] [SMALLINT] NULL,
- [id_producer_goods] [tinyint] NOT NULL,
- [id_group] [SMALLINT] NOT NULL,
- [id_subgroup] [SMALLINT] NOT NULL,
- [id_application] [tinyint] NOT NULL,
- [id_producer_country] [SMALLINT] NOT NULL,
- [time_stamp] [TIMESTAMP] NOT NULL,
- [datetime] [smalldatetime] NOT NULL,
- [deadline] [smalldatetime] NULL,
- [priority] [tinyint] NOT NULL,
- [include] [tinyint] NOT NULL,
- [dispetcher] [tinyint] NOT NULL,
- [global] [tinyint] NOT NULL,
- [region] [tinyint] NOT NULL,
- [internet] [tinyint] NOT NULL,
- [publish] [tinyint] NOT NULL,
- [edit] [dbo].[bit_set_0] NOT NULL,
- [blocked] [dbo].[bit_set_0] NOT NULL,
- [exist_image] [dbo].[bit_set_0] NOT NULL,
- [name] [VARCHAR](256) NULL,
- [name_original] [VARCHAR](256) NULL,
- [manufacture] [VARCHAR](64) NULL,
- [unit] [VARCHAR](32) NULL,
- [pack] [VARCHAR](32) NULL,
- [info] [VARCHAR](3000) NULL,
- [image] [image] NULL,
- [extended] [CHAR](4) NULL,
- [dispetcher_on_another] [bit] NULL,
- [image_small] [image] NULL,
- [exist_image_small] [bit] NULL,
- [extended_image_small] [CHAR](4) NULL,
- [discount_yes] [bit] NULL,
- [discount_values] [DECIMAL](11, 2) NULL,
- [id_hist_image] [INT] NULL,
- [id_description] [INT] NULL,
- [id_hist_image_kupon] [INT] NULL,
- CONSTRAINT [PK__Price__2334397B] PRIMARY KEY CLUSTERED
- (
- [id_service] ASC,
- [id_city] ASC,
- [id_firm] ASC,
- [id_price] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 70) ON [PRIMARY]
- ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
- GO
- SET ANSI_PADDING OFF
- GO
- ALTER TABLE [dbo].[Price] WITH NOCHECK ADD CONSTRAINT [FK__Price__3BCADD1B] FOREIGN KEY([id_group], [id_subgroup])
- REFERENCES [dbo].[Subgroup] ([id_group], [id_subgroup])
- GO
- ALTER TABLE [dbo].[Price] CHECK CONSTRAINT [FK__Price__3BCADD1B]
- GO
- ALTER TABLE [dbo].[Price] WITH NOCHECK ADD CONSTRAINT [FK__Price__3DB3258D] FOREIGN KEY([id_service], [id_firm], [id_city])
- REFERENCES [dbo].[Firm] ([id_service], [id_firm], [id_city])
- GO
- ALTER TABLE [dbo].[Price] CHECK CONSTRAINT [FK__Price__3DB3258D]
- GO
- ALTER TABLE [dbo].[Price] WITH NOCHECK ADD CONSTRAINT [FK__Price__id_applic__3AD6B8E2] FOREIGN KEY([id_application])
- REFERENCES [dbo].[Application] ([id_application])
- GO
- ALTER TABLE [dbo].[Price] CHECK CONSTRAINT [FK__Price__id_applic__3AD6B8E2]
- GO
- ALTER TABLE [dbo].[Price] WITH NOCHECK ADD CONSTRAINT [FK__Price__id_produc__3F9B6DFF] FOREIGN KEY([id_producer_goods])
- REFERENCES [dbo].[Producer_goods] ([id_producer_goods])
- GO
- ALTER TABLE [dbo].[Price] CHECK CONSTRAINT [FK__Price__id_produc__3F9B6DFF]
- GO
- ALTER TABLE [dbo].[Price] WITH NOCHECK ADD CONSTRAINT [FK__Price__id_rqp__3CBF0154] FOREIGN KEY([id_rqp])
- REFERENCES [dbo].[Rqp] ([id_rqp])
- GO
- ALTER TABLE [dbo].[Price] CHECK CONSTRAINT [FK__Price__id_rqp__3CBF0154]
- GO
- ALTER TABLE [dbo].[Price] WITH NOCHECK ADD CONSTRAINT [FK_Price_id_user] FOREIGN KEY([id_user])
- REFERENCES [dbo].[Users] ([id_user])
- GO
- ALTER TABLE [dbo].[Price] CHECK CONSTRAINT [FK_Price_id_user]
- GO
- ALTER TABLE [dbo].[Price] WITH NOCHECK ADD CONSTRAINT [R_152] FOREIGN KEY([id_producer_country])
- REFERENCES [dbo].[Producer_country] ([id_producer_country])
- GO
- ALTER TABLE [dbo].[Price] CHECK CONSTRAINT [R_152]
- GO
- ALTER TABLE [dbo].[Price] ADD CONSTRAINT [NULL62] DEFAULT (NULL) FOR [deadline]
- GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement