1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71
| USE [D_EAF_ETL]
GO
/****** Object: Table [dbo].[PCS_PROVIDERCITYSERVICE] Script Date: 04/08/2010 18:02:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[PCS_PROVIDERCITYSERVICE](
[ID] [int] IDENTITY(1,1) NOT NULL,
[PVD_EXTERNAL_ID] [varchar](36) NOT NULL,
[SRV_EXTERNAL_ID] [varchar](36) NOT NULL,
[INSEE_CODE] [varchar](10) NOT NULL,
[PVD_ID] [int] NULL,
[SRV_ID] [int] NULL,
[GEO_ID] [int] NULL,
[TO_CREATE] [bit] NOT NULL CONSTRAINT [DF_PCS_PROVIDERCITYSERVICE_TO_CREATE] DEFAULT ((0)),
[TO_UPDATE] [bit] NOT NULL CONSTRAINT [DF_PCS_PROVIDERCITYSERVICE_TO_UPDATE] DEFAULT ((0)),
[TO_DELETE] [bit] NOT NULL CONSTRAINT [DF_PCS_PROVIDERCITYSERVICE_TO_DELETE] DEFAULT ((0)),
[CREATION_DATE] [datetime] NOT NULL CONSTRAINT [DF_PCS_PROVIDERCITYSERVICE_CREATION_DATE] DEFAULT (getdate()),
[UPDATE_DATE] [datetime] NOT NULL CONSTRAINT [DF_PCS_PROVIDERCITYSERVICE_UPDATE_DATE] DEFAULT (getdate()),
CONSTRAINT [PK_PCS_PROVIDERCITYSERVICE] 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
ALTER TABLE [dbo].[PCS_PROVIDERCITYSERVICE] WITH CHECK ADD CONSTRAINT [FK_PCS_PROVIDERCITYSERVICE_GEO_GEOGRAPHY] FOREIGN KEY([GEO_ID])
REFERENCES [dbo].[GEO_GEOGRAPHY] ([ID])
GO
ALTER TABLE [dbo].[PCS_PROVIDERCITYSERVICE] CHECK CONSTRAINT [FK_PCS_PROVIDERCITYSERVICE_GEO_GEOGRAPHY]
GO
ALTER TABLE [dbo].[PCS_PROVIDERCITYSERVICE] WITH CHECK ADD CONSTRAINT [FK_PCS_PROVIDERCITYSERVICE_PVD_PROVIDER] FOREIGN KEY([PVD_ID])
REFERENCES [dbo].[PVD_PROVIDER] ([ID])
GO
ALTER TABLE [dbo].[PCS_PROVIDERCITYSERVICE] CHECK CONSTRAINT [FK_PCS_PROVIDERCITYSERVICE_PVD_PROVIDER]
GO
ALTER TABLE [dbo].[PCS_PROVIDERCITYSERVICE] WITH CHECK ADD CONSTRAINT [FK_PCS_PROVIDERCITYSERVICE_SRV_SERVICE] FOREIGN KEY([SRV_ID])
REFERENCES [dbo].[SRV_SERVICE] ([ID])
GO
ALTER TABLE [dbo].[PCS_PROVIDERCITYSERVICE] CHECK CONSTRAINT [FK_PCS_PROVIDERCITYSERVICE_SRV_SERVICE]
USE [D_EAF_ETL]
GO
/****** Object: Table [dbo].[PCS_PROVIDERCITYSERVICE_TEMP] Script Date: 04/08/2010 18:02:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[PCS_PROVIDERCITYSERVICE_TEMP](
[ID] [int] IDENTITY(1,1) NOT NULL,
[PVD_EXTERNAL_ID] [varchar](36) NOT NULL,
[SRV_EXTERNAL_ID] [varchar](36) NOT NULL,
[INSEE_CODE] [varchar](10) NOT NULL,
[PCT_STATUS] [smallint] NOT NULL,
[PSH_STATUS] [smallint] NOT NULL,
[CREATION_DATE] [datetime] NOT NULL CONSTRAINT [DF_PCS_PROVIDERCITYSERVICE_TEMP_CREATION_DATE] DEFAULT (getdate()),
CONSTRAINT [PK_PCS_PROVIDERCITYSERVICE_TEMP] 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 |
Partager