USE [WID27]
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[Universe](
	[universe] [char](1) NOT NULL,
	[universedesc] [varchar](50) NULL,
 CONSTRAINT [PK_Universe] PRIMARY KEY CLUSTERED 
(
	[universe] 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



CREATE TABLE [dbo].[LaborForceDemographics](
	[StFips] [char](2) NOT NULL,
	[AreaType] [char](2) NOT NULL,
	[Area] [char](6) NOT NULL,
	[PeriodYear] [char](4) NOT NULL,
	[PeriodType] [char](2) NOT NULL,
	[Period] [char](2) NOT NULL,
	[PopSource] [char](1) NOT NULL,
	[Universe] [char](1) NOT NULL,
	[Gender] [char](1) NOT NULL,
	[Agegroup] [char](2) NOT NULL,
	[Education] [char](1) NOT NULL,
	[RaceEthn] [char](5) NOT NULL,
	[Total] [int] NULL,
	[LaborForce] [int] NULL,
	[ArmedForces] [int] NULL,
	[CivilianLaborForce] [int] NULL,
	[Employed] [int] NULL,
	[Unemployed] [int] NULL,
	[NotInLaborForce] [int] NULL,
	[TotalMOE] [int] NULL,
	[LaborForceMOE] [int] NULL,
	[ArmedForcesMOE] [int] NULL,
	[CivilianLaborForceMOE] [int] NULL,
	[EmployedMOE] [int] NULL,
	[UnemployedMOE] [int] NULL,
	[NotInLaborForceMOE] [int] NULL,
	[Calcd] [int] NULL,
 CONSTRAINT [PK_LaborForceDemographics] PRIMARY KEY CLUSTERED 
(
	[StFips] ASC,
	[AreaType] ASC,
	[Area] ASC,
	[PeriodYear] ASC,
	[PeriodType] ASC,
	[Period] ASC,
	[PopSource] ASC,
	[Universe] ASC,
	[Gender] ASC,
	[Agegroup] ASC,
	[Education] ASC,
	[RaceEthn] 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].[LaborForceDemographics]  WITH CHECK ADD  CONSTRAINT [FK_laborforcedemographics_agegroup] FOREIGN KEY([StFips], [Agegroup])
REFERENCES [dbo].[agegroup] ([stfips], [agegroup])
GO

ALTER TABLE [dbo].[LaborForceDemographics] CHECK CONSTRAINT [FK_laborforcedemographics_agegroup]
GO

ALTER TABLE [dbo].[LaborForceDemographics]  WITH CHECK ADD  CONSTRAINT [FK_laborforcedemographics_education] FOREIGN KEY([Education])
REFERENCES [dbo].[education] ([educat])
GO

ALTER TABLE [dbo].[LaborForceDemographics] CHECK CONSTRAINT [FK_laborforcedemographics_education]
GO

ALTER TABLE [dbo].[LaborForceDemographics]  WITH CHECK ADD  CONSTRAINT [FK_laborforcedemographics_gender] FOREIGN KEY([Gender])
REFERENCES [dbo].[gender] ([gender])
GO

ALTER TABLE [dbo].[LaborForceDemographics] CHECK CONSTRAINT [FK_laborforcedemographics_gender]
GO

ALTER TABLE [dbo].[LaborForceDemographics]  WITH CHECK ADD  CONSTRAINT [FK_laborforcedemographics_geog] FOREIGN KEY([StFips], [AreaType], [Area])
REFERENCES [dbo].[geog] ([stfips], [areatype], [area])
GO

ALTER TABLE [dbo].[LaborForceDemographics] CHECK CONSTRAINT [FK_laborforcedemographics_geog]
GO

ALTER TABLE [dbo].[LaborForceDemographics]  WITH CHECK ADD  CONSTRAINT [FK_laborforcedemographics_period] FOREIGN KEY([PeriodYear], [PeriodType], [Period])
REFERENCES [dbo].[period] ([periodyear], [periodtype], [period])
GO

ALTER TABLE [dbo].[LaborForceDemographics] CHECK CONSTRAINT [FK_laborforcedemographics_period]
GO

ALTER TABLE [dbo].[LaborForceDemographics]  WITH CHECK ADD  CONSTRAINT [FK_laborforcedemographics_popsource] FOREIGN KEY([StFips], [PopSource])
REFERENCES [dbo].[popsource] ([stfips], [popsource])
GO

ALTER TABLE [dbo].[LaborForceDemographics] CHECK CONSTRAINT [FK_laborforcedemographics_popsource]
GO

ALTER TABLE [dbo].[LaborForceDemographics]  WITH CHECK ADD  CONSTRAINT [FK_laborforcedemographics_raceethn] FOREIGN KEY([RaceEthn])
REFERENCES [dbo].[raceethn] ([raceethn])
GO

ALTER TABLE [dbo].[LaborForceDemographics] CHECK CONSTRAINT [FK_laborforcedemographics_raceethn]
GO

ALTER TABLE [dbo].[LaborForceDemographics]  WITH CHECK ADD  CONSTRAINT [FK_laborforcedemographics_universe] FOREIGN KEY([Universe])
REFERENCES [dbo].[Universe] ([universe])
GO

ALTER TABLE [dbo].[LaborForceDemographics] CHECK CONSTRAINT [FK_laborforcedemographics_universe]
GO