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
|
CREATE TABLE [dbo].[Fact_MedicalStatistics](
[Health_Care_Facility_ID] [int] NOT NULL,
[Week_ID] [char](10) NOT NULL,
[Month_ID] [char](7) NOT NULL,
[ville_ID] [int] NOT NULL,
[Sex] [nvarchar](1) NOT NULL,
[age_range] [nchar](6) NOT NULL,
[X] [real] NULL,
CONSTRAINT [PK_Fact_MedicalStatistics] PRIMARY KEY CLUSTERED
(
[Health_Care_Facility_ID] ASC,
[Week_ID] ASC,
[Month_ID] ASC,
[Sex] ASC,
[age_range] ASC
[ville_ID] ASC
)
CREATE TABLE [dbo].[Dim_Week](
[Week_ID] [char](10) NOT NULL,
[Month_ID] [char](7) NOT NULL,
CONSTRAINT [PK_Dim.Week] PRIMARY KEY CLUSTERED
(
[Week_ID] ASC,
[Month_ID] ASC
)
CREATE TABLE [dbo].[Dim_Health_Care_Facility](
[Health_Care_Facility_ID] [int] NOT NULL,
[Health_Care_Facility] [nvarchar](20) NULL,
[Adress] [nvarchar](30) NULL,
[ville_ID] [int] NOT NULL,
CONSTRAINT [PK_Dim.Health_Care_Facility] PRIMARY KEY CLUSTERED
(
[Health_Care_Facility_ID] ASC
)
CREATE TABLE [dbo].[Dim_Age_range](
[age_range] [nchar](6) NOT NULL,
CONSTRAINT [PK_Age_group] PRIMARY KEY CLUSTERED
(
[age_range] ASC
)
CREATE TABLE [dbo].[Dim_Sex](
[Sex] [nvarchar](1) NOT NULL,
CONSTRAINT [PK_Dim_Sex] PRIMARY KEY CLUSTERED
(
[Sex] ASC
) |
Partager