USE [master] GO CREATE DATABASE [WID28] GO USE [WID28] GO --CORE CREATE TABLE [dbo].[stfipstb]( [stfips] [char](2) NOT NULL, [stname] [varchar](20) NULL, [abbrev] [char](2) NULL, CONSTRAINT [PK_stfipstb] PRIMARY KEY CLUSTERED ( [stfips] 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 --CORE CREATE TABLE [dbo].[areatype]( [stfips] [char](2) NOT NULL, [areatype] [char](2) NOT NULL, [areatyname] [varchar](40) NULL, CONSTRAINT [PK_AREATYPE] PRIMARY KEY CLUSTERED ( [stfips] ASC, [areatype] 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 --CORE CREATE TABLE [dbo].[geocode]( [geopcode] [char](1) NOT NULL, [geopdesc] [varchar](40) NULL, CONSTRAINT [PK_GEOCODE] PRIMARY KEY CLUSTERED ( [geopcode] 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 --CORE CREATE TABLE [dbo].[geog]( [stfips] [char](2) NOT NULL, [areatype] [char](2) NOT NULL, [area] [char](6) NOT NULL, [areaname] [varchar](60) NULL, [areadesc] [varchar](max) NULL, [latitude] [numeric](11, 6) NULL, [longitude] [numeric](11, 6) NULL, [geopcode] [char](1) NULL, CONSTRAINT [PK_GEOG] PRIMARY KEY CLUSTERED ( [stfips] ASC, [areatype] ASC, [area] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO CREATE TABLE [dbo].[subgeog]( [stfips] [char](2) NOT NULL, [areatype] [char](2) NOT NULL, [area] [char](6) NOT NULL, [substfips] [char](2) NOT NULL, [subareatyp] [char](2) NOT NULL, [subarea] [char](6) NOT NULL, CONSTRAINT [PK_SUBGEOG] PRIMARY KEY CLUSTERED ( [stfips] ASC, [areatype] ASC, [area] ASC, [substfips] ASC, [subareatyp] ASC, [subarea] 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 ALTER TABLE [dbo].[subgeog] WITH CHECK ADD CONSTRAINT [FK_SUBGEOG_GEOG_ST] FOREIGN KEY([stfips], [areatype], [area]) REFERENCES [dbo].[geog] ([stfips], [areatype], [area]) GO ALTER TABLE [dbo].[subgeog] CHECK CONSTRAINT [FK_SUBGEOG_GEOG_ST] GO ALTER TABLE [dbo].[subgeog] WITH CHECK ADD CONSTRAINT [FK_SUBGEOG_GEOG_SU] FOREIGN KEY([substfips], [subareatyp], [subarea]) REFERENCES [dbo].[geog] ([stfips], [areatype], [area]) GO ALTER TABLE [dbo].[subgeog] CHECK CONSTRAINT [FK_SUBGEOG_GEOG_SU] GO CREATE TABLE [dbo].[statelst]( [stfips] [char](2) NOT NULL, [statename] [varchar](20) NULL, [stateabbrv] [char](2) NULL, CONSTRAINT [PK_STATELST] PRIMARY KEY CLUSTERED ( [stfips] 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 ALTER TABLE [dbo].[statelst] WITH CHECK ADD CONSTRAINT [fk_statelst_stfipstb] FOREIGN KEY([stfips]) REFERENCES [dbo].[stfipstb] ([stfips]) GO ALTER TABLE [dbo].[statelst] CHECK CONSTRAINT [fk_statelst_stfipstb] GO --CORE CREATE TABLE [dbo].[periodty]( [periodtype] [char](2) NOT NULL, [pertypdesc] [varchar](40) NULL, CONSTRAINT [PK_PERIODTY] PRIMARY KEY CLUSTERED ( [periodtype] 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 --CORE CREATE TABLE [dbo].[period]( [periodyear] [char](4) NOT NULL, [periodtype] [char](2) NOT NULL, [period] [char](2) NOT NULL, CONSTRAINT [PK_PERIOD] PRIMARY KEY CLUSTERED ( [periodyear] ASC, [periodtype] ASC, [period] 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 ALTER TABLE [dbo].[period] WITH CHECK ADD CONSTRAINT [FK_PERIOD_PERIODTY] FOREIGN KEY([periodtype]) REFERENCES [dbo].[periodty] ([periodtype]) GO ALTER TABLE [dbo].[period] CHECK CONSTRAINT [FK_PERIOD_PERIODTY] GO --CORE CREATE TABLE [dbo].[periodid]( [stfips] [char](2) NOT NULL, [periodid] [char](2) NOT NULL, [periodtype] [char](2) NULL, [estyear] [char](4) NULL, [estperiod] [char](2) NULL, [projyear] [char](4) NULL, [projperiod] [char](2) NULL, [perioddesc] [varchar](60) NULL, CONSTRAINT [PK_PERIODID] PRIMARY KEY CLUSTERED ( [stfips] ASC, [periodid] 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 ALTER TABLE [dbo].[periodid] WITH CHECK ADD CONSTRAINT [FK_PERIODID_PERIOD_EST] FOREIGN KEY([estyear], [periodtype], [estperiod]) REFERENCES [dbo].[period] ([periodyear], [periodtype], [period]) GO ALTER TABLE [dbo].[periodid] CHECK CONSTRAINT [FK_PERIODID_PERIOD_EST] GO ALTER TABLE [dbo].[periodid] WITH CHECK ADD CONSTRAINT [FK_PERIODID_PERIOD_PRJ] FOREIGN KEY([projyear], [periodtype], [projperiod]) REFERENCES [dbo].[period] ([periodyear], [periodtype], [period]) GO ALTER TABLE [dbo].[periodid] CHECK CONSTRAINT [FK_PERIODID_PERIOD_PRJ] GO ALTER TABLE [dbo].[periodid] WITH CHECK ADD CONSTRAINT [FK_PERIODID_STFIPSTB] FOREIGN KEY([stfips]) REFERENCES [dbo].[stfipstb] ([stfips]) GO ALTER TABLE [dbo].[periodid] CHECK CONSTRAINT [FK_PERIODID_STFIPSTB] GO --DEPRECATED --CREATE TABLE [dbo].[jobfamly]( -- [jobfamily] [char](2) NOT NULL, -- [famtitle] [varchar](60) NULL, -- [familydesc] [varchar](max) NULL --) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] --GO CREATE TABLE [dbo].[benefit]( [stfips] [char](2) NOT NULL, [benefit] [char](1) NOT NULL, [benedesc] [varchar](40) NULL, CONSTRAINT [PK_BENEFIT] PRIMARY KEY CLUSTERED ( [stfips] ASC, [benefit] 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 ALTER TABLE [dbo].[benefit] WITH CHECK ADD CONSTRAINT [FK_BENEFIT_STFIPSTB] FOREIGN KEY([stfips]) REFERENCES [dbo].[stfipstb] ([stfips]) GO ALTER TABLE [dbo].[benefit] CHECK CONSTRAINT [FK_BENEFIT_STFIPSTB] GO CREATE TABLE [dbo].[careerclust]( [clustercode] [char](2) NOT NULL, [clustertitle] [varchar](80) NULL, [clusterdesc] [varchar](max) NULL, CONSTRAINT [PK_CAREERCLUST] PRIMARY KEY CLUSTERED ( [clustercode] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO CREATE TABLE [dbo].[careerpaths]( [pathcode] [char](4) NOT NULL, [pathtitle] [varchar](115) NULL, CONSTRAINT [PK_CAREERPATHS] PRIMARY KEY CLUSTERED ( [pathcode] 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 --CORE CREATE TABLE [dbo].[occtypes]( [codetype] [char](2) NOT NULL, [codetydesc] [varchar](40) NULL, CONSTRAINT [PK_OCCTYPES] PRIMARY KEY CLUSTERED ( [codetype] 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 --DEPRECATED --CREATE TABLE [dbo].[censcode]( -- [censcode] [char](4) NOT NULL, -- [codetype] [char](2) NOT NULL, -- [censtitle] [varchar](60) NULL, -- CONSTRAINT [PK_CENSCODE] PRIMARY KEY CLUSTERED --( -- [censcode] 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 --ALTER TABLE [dbo].[censcode] WITH CHECK ADD CONSTRAINT [FK_CENSCODE_OCCTYPES] FOREIGN KEY([codetype]) --REFERENCES [dbo].[occtypes] ([codetype]) --GO --ALTER TABLE [dbo].[censcode] CHECK CONSTRAINT [FK_CENSCODE_OCCTYPES] --GO CREATE TABLE [dbo].[edulevel]( [stfips] [char](2) NOT NULL, [edulevel] [char](1) NOT NULL, [edulvldesc] [varchar](40) NULL, CONSTRAINT [PK_EDULEVEL] PRIMARY KEY CLUSTERED ( [stfips] ASC, [edulevel] 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 ALTER TABLE [dbo].[edulevel] WITH CHECK ADD CONSTRAINT [FK_EDULEVEL_STFIPSTB] FOREIGN KEY([stfips]) REFERENCES [dbo].[stfipstb] ([stfips]) GO ALTER TABLE [dbo].[edulevel] CHECK CONSTRAINT [FK_EDULEVEL_STFIPSTB] GO CREATE TABLE [dbo].[education]( [educat] [char](1) NOT NULL, [educatdesc] [varchar](35) NULL, CONSTRAINT [PK_EDUCATION] PRIMARY KEY CLUSTERED ( [educat] 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].[experience]( [expercat] [char](1) NOT NULL, [expercatdesc] [varchar](20) NULL, CONSTRAINT [PK_EXPERIENCE] PRIMARY KEY CLUSTERED ( [expercat] 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].[training]( [trainingcat] [char](1) NOT NULL, [trainingdesc] [varchar](35) NULL, CONSTRAINT [PK_TRAINING] PRIMARY KEY CLUSTERED ( [trainingcat] 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 ---DEPRECATED --CREATE TABLE [dbo].[eeo1cat]( -- [eeo1cat] [char](2) NOT NULL, -- [eeo1title] [varchar](50) NULL --) ON [PRIMARY] --GO --DEPRECATED --CREATE TABLE [dbo].[eeostloc]( -- [eeostoc] [char](2) NOT NULL, -- [eeostloctl] [varchar](50) NULL, --PRIMARY KEY CLUSTERED --( -- [eeostoc] 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].[explevel]( [stfips] [char](2) NOT NULL, [explevel] [char](1) NOT NULL, [explvldesc] [varchar](40) NULL, CONSTRAINT [PK_EXPLEVEL] PRIMARY KEY CLUSTERED ( [stfips] ASC, [explevel] 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 ALTER TABLE [dbo].[explevel] WITH CHECK ADD CONSTRAINT [FK_EXPLEVEL_STFIPSTB] FOREIGN KEY([stfips]) REFERENCES [dbo].[stfipstb] ([stfips]) GO ALTER TABLE [dbo].[explevel] CHECK CONSTRAINT [FK_EXPLEVEL_STFIPSTB] GO CREATE TABLE [dbo].[itemcpi]( [CPIITEM] [char](9) NOT NULL, [ITEMDESC] [varchar](100) NULL, CONSTRAINT [PK_ITEMCPI] PRIMARY KEY CLUSTERED ( [CPIITEM] 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].[lengthopen]( [stfips] [char](2) NOT NULL, [lengthopen] [char](1) NOT NULL, [lodesc] [varchar](40) NULL, CONSTRAINT [PK_LENGTHOPEN] PRIMARY KEY CLUSTERED ( [stfips] ASC, [lengthopen] 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 ALTER TABLE [dbo].[lengthopen] WITH CHECK ADD CONSTRAINT [FK_LENGTHOPEN_STFIPSTB] FOREIGN KEY([stfips]) REFERENCES [dbo].[stfipstb] ([stfips]) GO ALTER TABLE [dbo].[lengthopen] CHECK CONSTRAINT [FK_LENGTHOPEN_STFIPSTB] GO CREATE TABLE [dbo].[oohtrntm]( [oohtrntm] [char](1) NOT NULL, [oohtmdesc] [varchar](60) NULL, CONSTRAINT [PK_OOHTRNTM] PRIMARY KEY CLUSTERED ( [oohtrntm] 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 --DEPRECATED --CREATE TABLE [dbo].[oesgroup]( -- [oesgroup1] [varchar](3) NOT NULL, -- [oesgroup2] [varchar](2) NOT NULL, -- [oesgroup3] [varchar](2) NOT NULL, -- [grpdesc] [nvarchar](90) NULL, -- CONSTRAINT [PK_oesgroup] PRIMARY KEY CLUSTERED --( -- [oesgroup1] ASC, -- [oesgroup2] ASC, -- [oesgroup3] 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 --DEPRECATED --CREATE TABLE [dbo].[oestrntm]( -- [oestrntm] [char](1) NOT NULL, -- [oestmdesc] [varchar](40) NULL, --PRIMARY KEY CLUSTERED --( -- [oestrntm] 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 --DEPRECATED --CREATE TABLE [dbo].[oescode]( -- [oescode] [char](5) NOT NULL, -- [oestitle] [varchar](60) NULL, -- [oesdesc] [varchar](max) NULL, -- [oestrntm] [char](1) NULL, -- [oestitles] [varchar](35) NULL, -- [oohtrntm] [char](1) NULL, -- [oesgroup1] [varchar](3) NULL, -- [oesgroup2] [varchar](2) NULL, -- [oesgroup3] [varchar](2) NULL, --PRIMARY KEY CLUSTERED --( -- [oescode] ASC --)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] --) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] --GO --CORE CREATE TABLE [dbo].[occsub]( [stfips] [char](2) NOT NULL, [subtot] [char](1) NOT NULL, [subtotdesc] [varchar](60) NULL, CONSTRAINT [PK_OCCSUB_2] PRIMARY KEY CLUSTERED ( [stfips] ASC, [subtot] 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 ALTER TABLE [dbo].[occsub] WITH CHECK ADD CONSTRAINT [FK_OCCSUB_STFIPSTB] FOREIGN KEY([stfips]) REFERENCES [dbo].[stfipstb] ([stfips]) GO ALTER TABLE [dbo].[occsub] CHECK CONSTRAINT [FK_OCCSUB_STFIPSTB] GO --CORE CREATE TABLE [dbo].[occdir]( [stfips] [char](2) NOT NULL, [matoccode] [char](10) NOT NULL, [periodid] [char](2) NOT NULL, [matoccodty] [char](1) NULL, [matocctitl] [varchar](200) NULL, [subtot] [char](1) NULL, CONSTRAINT [PK_OCCDIR] PRIMARY KEY CLUSTERED ( [stfips] ASC, [matoccode] ASC, [periodid] 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 ALTER TABLE [dbo].[occdir] WITH CHECK ADD CONSTRAINT [FK_OCCDIR_OCCSUB] FOREIGN KEY([stfips], [subtot]) REFERENCES [dbo].[occsub] ([stfips], [subtot]) GO ALTER TABLE [dbo].[occdir] CHECK CONSTRAINT [FK_OCCDIR_OCCSUB] GO ALTER TABLE [dbo].[occdir] WITH CHECK ADD CONSTRAINT [FK_OCCDIR_PERIODID] FOREIGN KEY([stfips], [periodid]) REFERENCES [dbo].[periodid] ([stfips], [periodid]) GO ALTER TABLE [dbo].[occdir] CHECK CONSTRAINT [FK_OCCDIR_PERIODID] GO CREATE TABLE [dbo].[stattype]( [stfips] [char](2) NOT NULL, [stattype] [char](2) NOT NULL, [stattydesc] [varchar](50) NULL, CONSTRAINT [PK_STATTYPE] PRIMARY KEY CLUSTERED ( [stfips] ASC, [stattype] 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 ALTER TABLE [dbo].[stattype] WITH CHECK ADD CONSTRAINT [FK_STATTYPE_STFIPSTB] FOREIGN KEY([stfips]) REFERENCES [dbo].[stfipstb] ([stfips]) GO ALTER TABLE [dbo].[stattype] CHECK CONSTRAINT [FK_STATTYPE_STFIPSTB] GO --CORE CREATE TABLE [dbo].[indtypes]( [codetype] [char](2) NOT NULL, [codetydesc] [varchar](40) NULL, CONSTRAINT [PK_INDTYPES] PRIMARY KEY CLUSTERED ( [codetype] 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].[qwisup]( [qwisup] [char](1) NOT NULL, [qwisupdesc] [varchar](75) NULL, CONSTRAINT [PK_QWISUP] PRIMARY KEY CLUSTERED ( [qwisup] 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].[qwitype]( [qwitype] [char](2) NOT NULL, [qwitypdesc] [varchar](75) NULL, CONSTRAINT [PK_QWITYPE] PRIMARY KEY CLUSTERED ( [qwitype] 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 --DEPRECATED --CREATE TABLE [dbo].[sicdiv]( -- [sicdiv] [char](1) NOT NULL, -- [divdesc] [varchar](40) NULL, -- CONSTRAINT [PK_SICDIV] PRIMARY KEY CLUSTERED --( -- [sicdiv] 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 --DEPRECATED --CREATE TABLE [dbo].[siclevel]( -- [siclevel] [char](1) NOT NULL, -- [leveldesc] [varchar](40) NULL, -- CONSTRAINT [PK_SICLEVEL] PRIMARY KEY CLUSTERED --( -- [siclevel] 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].[inddiv]( [inddiv] [char](3) NOT NULL, [indtitle] [varchar](60) NULL, CONSTRAINT [PK_INDDIV] PRIMARY KEY CLUSTERED ( [inddiv] 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 --DEPRECATED --CREATE TABLE [dbo].[siccode]( -- [siccode] [char](4) NOT NULL, -- [sictitle] [varchar](38) NULL, -- [sictitlel] [varchar](110) NULL, -- [sicdesc] [varchar](max) NULL, -- [sicdiv] [char](1) NULL, -- [siclevel] [char](1) NULL, -- [inddiv] [char](3) NULL, -- CONSTRAINT [PK_SICCODE] PRIMARY KEY CLUSTERED --( -- [siccode] ASC --)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] --) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] --GO --ALTER TABLE [dbo].[siccode] WITH CHECK ADD CONSTRAINT [FK_SICCODE_INDDIV] FOREIGN KEY([inddiv]) --REFERENCES [dbo].[inddiv] ([inddiv]) --GO --ALTER TABLE [dbo].[siccode] CHECK CONSTRAINT [FK_SICCODE_INDDIV] --GO --ALTER TABLE [dbo].[siccode] WITH CHECK ADD CONSTRAINT [FK_SICCODE_SICDIV] FOREIGN KEY([sicdiv]) --REFERENCES [dbo].[sicdiv] ([sicdiv]) --GO --ALTER TABLE [dbo].[siccode] CHECK CONSTRAINT [FK_SICCODE_SICDIV] --GO --ALTER TABLE [dbo].[siccode] WITH CHECK ADD CONSTRAINT [FK_SICCODE_SICLEVEL] FOREIGN KEY([siclevel]) --REFERENCES [dbo].[siclevel] ([siclevel]) --GO --ALTER TABLE [dbo].[siccode] CHECK CONSTRAINT [FK_SICCODE_SICLEVEL] --GO --CORE CREATE TABLE [dbo].[ratetype]( [ratetype] [char](1) NOT NULL, [ratetydesc] [varchar](40) NULL, CONSTRAINT [PK_RATETYPE] PRIMARY KEY CLUSTERED ( [ratetype] 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].[salestyp]( [stfips] [char](2) NOT NULL, [salestype] [char](2) NOT NULL, [saletydesc] [varchar](40) NULL, CONSTRAINT [PK_SALESTYP] PRIMARY KEY CLUSTERED ( [stfips] ASC, [salestype] 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 ALTER TABLE [dbo].[salestyp] WITH CHECK ADD CONSTRAINT [FK_SALESTYP_STFIPSTB] FOREIGN KEY([stfips]) REFERENCES [dbo].[stfipstb] ([stfips]) GO ALTER TABLE [dbo].[salestyp] CHECK CONSTRAINT [FK_SALESTYP_STFIPSTB] GO --CORE CREATE TABLE [dbo].[leveltyp]( [stfips] [char](2) NOT NULL, [leveltype] [char](1) NOT NULL, [lvldesc] [varchar](40) NULL, CONSTRAINT [PK_LEVELTYP] PRIMARY KEY CLUSTERED ( [stfips] ASC, [leveltype] 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 ALTER TABLE [dbo].[leveltyp] WITH CHECK ADD CONSTRAINT [FK_LEVELTYP_STFIPSTB] FOREIGN KEY([stfips]) REFERENCES [dbo].[stfipstb] ([stfips]) GO ALTER TABLE [dbo].[leveltyp] CHECK CONSTRAINT [FK_LEVELTYP_STFIPSTB] GO --CORE CREATE TABLE [dbo].[wgsource]( [stfips] [char](2) NOT NULL, [wagesource] [char](1) NOT NULL, [wagesrdesc] [varchar](60) NULL, CONSTRAINT [PK_WGSOURCE] PRIMARY KEY CLUSTERED ( [stfips] ASC, [wagesource] 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 ALTER TABLE [dbo].[wgsource] WITH CHECK ADD CONSTRAINT [FK_WGSOURCE_STFIPSTB] FOREIGN KEY([stfips]) REFERENCES [dbo].[stfipstb] ([stfips]) GO ALTER TABLE [dbo].[wgsource] CHECK CONSTRAINT [FK_WGSOURCE_STFIPSTB] GO --DEPRECATED --CREATE TABLE [dbo].[cenind]( -- [cenind] [char](4) NOT NULL, -- [codetype] [char](2) NOT NULL, -- [centitle] [varchar](140) NULL, -- CONSTRAINT [PK_CENIND] PRIMARY KEY CLUSTERED --( -- [CENIND] ASC, -- [CODETYPE] 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 --ALTER TABLE [dbo].[cenind] WITH CHECK ADD CONSTRAINT [FK_CENIND_INDTYPES] FOREIGN KEY([CODETYPE]) --REFERENCES [dbo].[indtypes] ([codetype]) --GO --ALTER TABLE [dbo].[cenind] CHECK CONSTRAINT [FK_CENIND_INDTYPES] --GO --CORE CREATE TABLE [dbo].[indsub]( [stfips] [char](2) NOT NULL, [subtot] [char](1) NOT NULL, [subtotdesc] [varchar](60) NULL, CONSTRAINT [PK_INDSUB_2] PRIMARY KEY CLUSTERED ( [stfips] ASC, [subtot] 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 ALTER TABLE [dbo].[indsub] WITH CHECK ADD CONSTRAINT [FK_INDSUB_STFIPSTB] FOREIGN KEY([stfips]) REFERENCES [dbo].[stfipstb] ([stfips]) GO ALTER TABLE [dbo].[indsub] CHECK CONSTRAINT [FK_INDSUB_STFIPSTB] GO CREATE TABLE [dbo].[popsource]( [stfips] [char](2) NOT NULL, [popsource] [char](1) NOT NULL, [popsrcdesc] [varchar](40) NULL, CONSTRAINT [PK_POPSOURCE] PRIMARY KEY CLUSTERED ( [stfips] ASC, [popsource] 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 ALTER TABLE [dbo].[popsource] WITH CHECK ADD CONSTRAINT [FK_POPSOURCE_STFIPSTB] FOREIGN KEY([stfips]) REFERENCES [dbo].[stfipstb] ([stfips]) GO ALTER TABLE [dbo].[popsource] CHECK CONSTRAINT [FK_POPSOURCE_STFIPSTB] GO CREATE TABLE [dbo].[unittype]( [stfips] [char](2) NOT NULL, [unittype] [char](2) NOT NULL, [typedesc] [varchar](40) NULL, CONSTRAINT [PK_UNITTYPE] PRIMARY KEY CLUSTERED ( [stfips] ASC, [unittype] 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 ALTER TABLE [dbo].[unittype] WITH CHECK ADD CONSTRAINT [FK_UNITTYPE_STFIPSTB] FOREIGN KEY([stfips]) REFERENCES [dbo].[stfipstb] ([stfips]) GO ALTER TABLE [dbo].[unittype] CHECK CONSTRAINT [FK_UNITTYPE_STFIPSTB] GO --CORE---CHANGES IN V2.8 CREATE TABLE [dbo].[cescode]( [stfips] [char](2) NOT NULL, [seriescode] [char](8) NOT NULL, [seriesdesc] [varchar](max) NULL, [seriesttls] [varchar](75) NULL, [seriesttll] [varchar](200) NULL, [serieslvl] [char](1) NULL, CONSTRAINT [PK_CESCODE] PRIMARY KEY CLUSTERED ( [stfips] ASC, [seriescode] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO ALTER TABLE [dbo].[cescode] WITH CHECK ADD CONSTRAINT [FK_CESCODE_STFIPSTB] FOREIGN KEY([stfips]) REFERENCES [dbo].[stfipstb] ([stfips]) GO ALTER TABLE [dbo].[cescode] CHECK CONSTRAINT [FK_CESCODE_STFIPSTB] GO CREATE TABLE [dbo].[cidscode]( [cidscode] [char](9) NOT NULL, [cidstitle] [varchar](40) NULL, [cidsdesc] [varchar](max) NULL, CONSTRAINT [PK_CIDSCODE] PRIMARY KEY CLUSTERED ( [cidscode] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO --CHANGES IN V2.8 CREATE TABLE [dbo].[cipcode]( [cipcode] [char](10) NOT NULL, [cipcodetype] [char](2) NULL, [ciptitle] [varchar](200) NULL, [cipdesc] [varchar](max) NULL, [ciptitls] [varchar](75) NULL, [ciplevel] [char](1) NULL, CONSTRAINT [PK_CIPCODE] PRIMARY KEY CLUSTERED ( [cipcode] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO ALTER TABLE [dbo].[cipcode] WITH CHECK ADD CONSTRAINT [FK_cipcode_occtypes] FOREIGN KEY([cipcodetype]) REFERENCES [dbo].[occtypes] ([codetype]) GO ALTER TABLE [dbo].[cipcode] CHECK CONSTRAINT [FK_cipcode_occtypes] GO CREATE TABLE [dbo].[cluscode]( [stfips] [char](2) NOT NULL, [cluscode] [char](10) NOT NULL, [clustitle] [varchar](60) NULL, [clusdesc] [varchar](max) NULL, CONSTRAINT [PK_CLUSCODE] PRIMARY KEY CLUSTERED ( [stfips] ASC, [cluscode] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO ALTER TABLE [dbo].[cluscode] WITH CHECK ADD CONSTRAINT [FK_CLUSCODE_STFIPSTB] FOREIGN KEY([stfips]) REFERENCES [dbo].[stfipstb] ([stfips]) GO ALTER TABLE [dbo].[cluscode] CHECK CONSTRAINT [FK_CLUSCODE_STFIPSTB] GO CREATE TABLE [dbo].[compltyp]( [stfips] [char](2) NOT NULL, [compltype] [char](2) NOT NULL, [compltitle] [varchar](40) NULL, [compldesc] [varchar](max) NULL, CONSTRAINT [PK_COMPLTYP] PRIMARY KEY CLUSTERED ( [stfips] ASC, [compltype] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO ALTER TABLE [dbo].[compltyp] WITH CHECK ADD CONSTRAINT [FK_COMPLTYP_STFIPSTB] FOREIGN KEY([stfips]) REFERENCES [dbo].[stfipstb] ([stfips]) GO ALTER TABLE [dbo].[compltyp] CHECK CONSTRAINT [FK_COMPLTYP_STFIPSTB] GO --DEPRECATED --CREATE TABLE [dbo].[dotcode]( -- [dotcode] [char](9) NOT NULL, -- [dottitle] [varchar](75) NULL, -- [gedr] [char](1) NULL, -- [gedm] [char](1) NULL, -- [gedl] [char](1) NULL, -- [svp] [char](1) NULL, --PRIMARY KEY CLUSTERED --( -- [dotcode] 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].[eventtyp]( [eventtype] [char](1) NOT NULL, [eventdesc] [varchar](40) NULL, CONSTRAINT [PK_EVENTTYP] PRIMARY KEY CLUSTERED ( [eventtype] 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].[gender]( [gender] [char](1) NOT NULL, [genderdesc] [varchar](12) NULL, CONSTRAINT [PK_GENDER] PRIMARY KEY CLUSTERED ( [gender] 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].[instown]( [instown] [char](1) NOT NULL, [instowndes] [varchar](40) NULL, CONSTRAINT [PK_INSTOWN] PRIMARY KEY CLUSTERED ( [instown] 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].[insttype]( [stfips] [char](2) NOT NULL, [insttype] [char](2) NOT NULL, [insttydesc] [varchar](50) NULL, CONSTRAINT [PK_INSTTYPE] PRIMARY KEY CLUSTERED ( [stfips] ASC, [insttype] 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 ALTER TABLE [dbo].[insttype] WITH CHECK ADD CONSTRAINT [FK_INSTTYPE_STFIPSTB] FOREIGN KEY([stfips]) REFERENCES [dbo].[stfipstb] ([stfips]) GO ALTER TABLE [dbo].[insttype] CHECK CONSTRAINT [FK_INSTTYPE_STFIPSTB] GO CREATE TABLE [dbo].[lentype]( [stfips] [char](2) NOT NULL, [lengthtype] [char](2) NOT NULL, [lentypdesc] [varchar](40) NULL, CONSTRAINT [PK_LENTYPE] PRIMARY KEY CLUSTERED ( [stfips] ASC, [lengthtype] 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 ALTER TABLE [dbo].[lentype] WITH CHECK ADD CONSTRAINT [FK_LENTYPE_STFIPSTB] FOREIGN KEY([stfips]) REFERENCES [dbo].[stfipstb] ([stfips]) GO ALTER TABLE [dbo].[lentype] CHECK CONSTRAINT [FK_LENTYPE_STFIPSTB] GO CREATE TABLE [dbo].[meeicode]( [meeicode] [char](1) NOT NULL, [meeidesc] [varchar](40) NULL, CONSTRAINT [PK_MEEICODE] PRIMARY KEY CLUSTERED ( [meeicode] 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 --DEPRECATED --CREATE TABLE [dbo].[mlssepcat]( -- [mlssepcategory] [char](4) NOT NULL, -- [mlssepcatdesc] [varchar](50) NULL, -- CONSTRAINT [PK_MLSSEPCAT] PRIMARY KEY CLUSTERED --( -- [mlssepcategory] 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 --DEPRECATED --CREATE TABLE [dbo].[mlssepcdtype]( -- [mlssepcodetype] [char](2) NOT NULL, -- [mlssepcdtypdesc] [varchar](50) NULL, -- [mlsseptypeffdate] [char](8) NULL, -- CONSTRAINT [PK_MLSSEPCDTYPE] PRIMARY KEY CLUSTERED --( -- [mlssepcodetype] 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 --DEPRECATED --CREATE TABLE [dbo].[mlssepcd]( -- [mlssepcodetype] [char](2) NOT NULL, -- [mlssepcd] [char](2) NOT NULL, -- [mlssepdesc] [varchar](40) NULL, -- [mlssepcategory] [char](4) NULL, -- CONSTRAINT [PK_MLSSEPCD] PRIMARY KEY CLUSTERED --( -- [mlssepcodetype] ASC, -- [mlssepcd] 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].[naicdom]( [naicdomain] [char](3) NOT NULL, [domaintitl] [varchar](25) NULL, CONSTRAINT [PK_NAICDOM] PRIMARY KEY CLUSTERED ( [naicdomain] 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].[naicsupr]( [naicsuper] [char](4) NOT NULL, [supertitle] [varchar](35) NULL, [naicdomain] [char](3) NULL, CONSTRAINT [PK_NAICSUPR] PRIMARY KEY CLUSTERED ( [naicsuper] 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 ALTER TABLE [dbo].[naicsupr] WITH CHECK ADD CONSTRAINT [FK_NAICSUPR_NAICDOM] FOREIGN KEY([naicdomain]) REFERENCES [dbo].[naicdom] ([naicdomain]) GO ALTER TABLE [dbo].[naicsupr] CHECK CONSTRAINT [FK_NAICSUPR_NAICDOM] GO CREATE TABLE [dbo].[naicsect]( [naicsect] [char](2) NOT NULL, [sectdesc] [varchar](45) NULL, [sectdescl] [varchar](120) NULL, [naicsuper] [char](4) NULL, CONSTRAINT [PK_NAICSECT] PRIMARY KEY CLUSTERED ( [naicsect] 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 ALTER TABLE [dbo].[naicsect] WITH CHECK ADD CONSTRAINT [FK_NAICSECT_NAICSUPR] FOREIGN KEY([naicsuper]) REFERENCES [dbo].[naicsupr] ([naicsuper]) GO ALTER TABLE [dbo].[naicsect] CHECK CONSTRAINT [FK_NAICSECT_NAICSUPR] GO CREATE TABLE [dbo].[naicslvl]( [naicslvl] [char](1) NOT NULL, [leveldesc] [varchar](40) NULL, CONSTRAINT [PK_NAICSLVL] PRIMARY KEY CLUSTERED ( [naicslvl] 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].[naiccode]( [naicscode] [char](6) NOT NULL, [naicstitle] [varchar](45) NULL, [naicstitll] [varchar](120) NULL, [naicsdesc] [varchar](max) NULL, [naicslvl] [char](1) NULL, [naicsect] [char](2) NULL, CONSTRAINT [PK_NAICCODE] PRIMARY KEY CLUSTERED ( [naicscode] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO ALTER TABLE [dbo].[naiccode] WITH CHECK ADD CONSTRAINT [FK_NAICCODE_NAICSECT] FOREIGN KEY([naicsect]) REFERENCES [dbo].[naicsect] ([naicsect]) GO ALTER TABLE [dbo].[naiccode] CHECK CONSTRAINT [FK_NAICCODE_NAICSECT] GO ALTER TABLE [dbo].[naiccode] WITH CHECK ADD CONSTRAINT [FK_NAICCODE_NAICSLVL] FOREIGN KEY([naicslvl]) REFERENCES [dbo].[naicslvl] ([naicslvl]) GO ALTER TABLE [dbo].[naiccode] CHECK CONSTRAINT [FK_NAICCODE_NAICSLVL] GO --DEPRECATED --CREATE TABLE [dbo].[oeslaytl]( -- [oescode] [char](5) NOT NULL, -- [laytitle] [varchar](80) NOT NULL, -- CONSTRAINT [PK_oeslaytl] PRIMARY KEY CLUSTERED --( -- [oescode] ASC, -- [laytitle] 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].[onetcode]( [onetcode] [char](8) NOT NULL, [onetyear] [char](4) NULL, [onetver] [char](6) NULL, [onettitle] [varchar](115) NULL, [onetdesc] [varchar](max) NULL, CONSTRAINT [PK_ONETCODE] PRIMARY KEY CLUSTERED ( [onetcode] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO --CORE CREATE TABLE [dbo].[ownershp]( [stfips] [char](2) NOT NULL, [ownership] [char](2) NOT NULL, [ownertitle] [varchar](40) NULL, [ownerdesc] [varchar](max) NULL, CONSTRAINT [PK_OWNERSHP] PRIMARY KEY CLUSTERED ( [stfips] ASC, [ownership] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO --CORE---CHANGES IN V2.8 CREATE TABLE [dbo].[inddir]( [stfips] [char](2) NOT NULL, [matincode] [char](15) NOT NULL, [periodid] [char](2) NOT NULL, [matincodty] [char](1) NULL, [matintitle] [varchar](200) NULL, [subtot] [char](1) NULL, [ownership] [char](2) NULL, CONSTRAINT [PK_INDDIR] PRIMARY KEY CLUSTERED ( [stfips] ASC, [matincode] ASC, [periodid] 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 ALTER TABLE [dbo].[inddir] WITH CHECK ADD CONSTRAINT [FK_INDDIR_INDSUB] FOREIGN KEY([stfips], [subtot]) REFERENCES [dbo].[indsub] ([stfips], [subtot]) GO ALTER TABLE [dbo].[inddir] CHECK CONSTRAINT [FK_INDDIR_INDSUB] GO ALTER TABLE [dbo].[inddir] WITH CHECK ADD CONSTRAINT [FK_INDDIR_PERIODID] FOREIGN KEY([stfips], [periodid]) REFERENCES [dbo].[periodid] ([stfips], [periodid]) GO ALTER TABLE [dbo].[inddir] CHECK CONSTRAINT [FK_INDDIR_PERIODID] GO ALTER TABLE [dbo].[inddir] WITH CHECK ADD CONSTRAINT [FK_INDDIR_OWNERSHP] FOREIGN KEY([stfips], [ownership]) REFERENCES [dbo].[ownershp] ([stfips], [ownership]) GO ALTER TABLE [dbo].[inddir] CHECK CONSTRAINT [FK_INDDIR_OWNERSHP] GO ALTER TABLE [dbo].[ownershp] WITH CHECK ADD CONSTRAINT [FK_OWNERSHP_STFIPSTB] FOREIGN KEY([stfips]) REFERENCES [dbo].[stfipstb] ([stfips]) GO ALTER TABLE [dbo].[ownershp] CHECK CONSTRAINT [FK_OWNERSHP_STFIPSTB] GO CREATE TABLE [dbo].[paytype]( [stfips] [char](2) NOT NULL, [paytype] [char](2) NOT NULL, [paytydesc] [varchar](40) NULL, CONSTRAINT [PK_PAYTYPE] PRIMARY KEY CLUSTERED ( [stfips] ASC, [paytype] 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 ALTER TABLE [dbo].[paytype] WITH CHECK ADD CONSTRAINT [FK_PAYTYPE_STFIPSTB] FOREIGN KEY([stfips]) REFERENCES [dbo].[stfipstb] ([stfips]) GO ALTER TABLE [dbo].[paytype] CHECK CONSTRAINT [FK_PAYTYPE_STFIPSTB] GO CREATE TABLE [dbo].[raceethn]( [raceethn] [char](5) NOT NULL, [racetitle] [varchar](75) NULL, CONSTRAINT [PK_RACEETHN] PRIMARY KEY CLUSTERED ( [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 CREATE TABLE [dbo].[sizeclas]( [stfips] [char](2) NOT NULL, [sizeclass] [char](2) NOT NULL, [sizedesc] [varchar](40) NULL, CONSTRAINT [PK_SIZECLAS] PRIMARY KEY CLUSTERED ( [stfips] ASC, [sizeclass] 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 ALTER TABLE [dbo].[sizeclas] WITH CHECK ADD CONSTRAINT [FK_SIZECLAS_STFIPSTB] FOREIGN KEY([stfips]) REFERENCES [dbo].[stfipstb] ([stfips]) GO ALTER TABLE [dbo].[sizeclas] CHECK CONSTRAINT [FK_SIZECLAS_STFIPSTB] GO --CHANGES IN V2.8 CREATE TABLE [dbo].[soccode]( [soccode] [char](6) NOT NULL, [soccodetype] [char](2) NOT NULL, [soctitle] [varchar](75) NULL, [soctitlel] [varchar](200) NULL, [socdesc] [varchar](max) NULL, [education] [char](1) NULL, [experience] [char](1) NULL, [training] [char](1) NULL, [oesflag] [char](1) NULL, [socparent] [char](6) NULL, [socparentcodetyp] [char](2) null, [oohtrntm] [char](1) NULL, CONSTRAINT [PK_SOCCODE] PRIMARY KEY CLUSTERED ( [soccode], [soccodetype] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO ALTER TABLE [dbo].[soccode] WITH CHECK ADD CONSTRAINT [FK_SOCCODE_EDUCATION] FOREIGN KEY([education]) REFERENCES [dbo].[education] ([educat]) GO ALTER TABLE [dbo].[soccode] CHECK CONSTRAINT [FK_SOCCODE_EDUCATION] GO ALTER TABLE [dbo].[soccode] WITH CHECK ADD CONSTRAINT [FK_SOCCODE_EXPERIENCE] FOREIGN KEY([experience]) REFERENCES [dbo].[experience] ([expercat]) GO ALTER TABLE [dbo].[soccode] CHECK CONSTRAINT [FK_SOCCODE_EXPERIENCE] GO ALTER TABLE [dbo].[soccode] WITH CHECK ADD CONSTRAINT [FK_SOCCODE_SOCCODE] FOREIGN KEY([socparent],[socparentcodetyp]) REFERENCES [dbo].[soccode] ([soccode],[soccodetype]) GO ALTER TABLE [dbo].[soccode] CHECK CONSTRAINT [FK_SOCCODE_SOCCODE] GO ALTER TABLE [dbo].[soccode] WITH CHECK ADD CONSTRAINT [FK_SOCCODE_TRAINING] FOREIGN KEY([training]) REFERENCES [dbo].[training] ([trainingcat]) GO ALTER TABLE [dbo].[soccode] CHECK CONSTRAINT [FK_SOCCODE_TRAINING] GO --CORE---CHANGES IN V2.8 CREATE TABLE [dbo].[occcodes]( [stfips] [char](2) NOT NULL, [CODETYPE] [char](2) NOT NULL, [CODE] [char](10) NOT NULL, [CODETITLE] [varchar](200) NULL, CONSTRAINT [PK_OCCCODES] PRIMARY KEY CLUSTERED ( [stfips] ASC, [CODETYPE] ASC, [CODE] 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 ALTER TABLE [dbo].[occcodes] WITH CHECK ADD CONSTRAINT [FK_OCCCODES_OCCTYPES] FOREIGN KEY([CODETYPE]) REFERENCES [dbo].[occtypes] ([codetype]) GO ALTER TABLE [dbo].[occcodes] CHECK CONSTRAINT [FK_OCCCODES_OCCTYPES] GO ALTER TABLE [dbo].[occcodes] WITH CHECK ADD CONSTRAINT [FK_OCCCODES_STFIPSTB] FOREIGN KEY([stfips]) REFERENCES [dbo].[stfipstb] ([stfips]) GO ALTER TABLE [dbo].[occcodes] CHECK CONSTRAINT [FK_OCCCODES_STFIPSTB] GO --CHANGES IN V2.8 CREATE TABLE [dbo].[stprogcd]( [stfips] [char](2) NOT NULL, [codetype] [char](2) NOT NULL, [code] [char](10) NOT NULL, [title] [varchar](200) NULL, [cipcode] [char](10) NULL, [cipcodetype] [char](2) NULL, [titldesc] [varchar](max) NULL, CONSTRAINT [PK_STPROGCD] PRIMARY KEY CLUSTERED ( [stfips] ASC, [codetype] ASC, [code] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO ALTER TABLE [dbo].[stprogcd] WITH CHECK ADD CONSTRAINT [FK_STPROGCD_OCCCODES] FOREIGN KEY([stfips], [codetype], [code]) REFERENCES [dbo].[occcodes] ([stfips], [CODETYPE], [CODE]) GO ALTER TABLE [dbo].[stprogcd] CHECK CONSTRAINT [FK_STPROGCD_OCCCODES] GO ALTER TABLE [dbo].[stprogcd] WITH CHECK ADD CONSTRAINT [FK_STPROGCD_STFIPSTB] FOREIGN KEY([stfips]) REFERENCES [dbo].[stfipstb] ([stfips]) GO ALTER TABLE [dbo].[stprogcd] CHECK CONSTRAINT [FK_STPROGCD_STFIPSTB] GO --CORE---CHANGES IN V2.8 CREATE TABLE [dbo].[indcodes]( [stfips] [char](2) NOT NULL, [codetype] [char](2) NOT NULL, [code] [char](6) NOT NULL, [codetitle] [varchar](200) NULL, CONSTRAINT [PK_INDCODES] PRIMARY KEY CLUSTERED ( [stfips] ASC, [codetype] ASC, [code] 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 ALTER TABLE [dbo].[indcodes] WITH CHECK ADD CONSTRAINT [FK_INDCODES_INDTYPES] FOREIGN KEY([codetype]) REFERENCES [dbo].[indtypes] ([codetype]) GO ALTER TABLE [dbo].[indcodes] CHECK CONSTRAINT [FK_INDCODES_INDTYPES] GO ALTER TABLE [dbo].[indcodes] WITH CHECK ADD CONSTRAINT [FK_INDCODES_STFIPSTB] FOREIGN KEY([stfips]) REFERENCES [dbo].[stfipstb] ([stfips]) GO ALTER TABLE [dbo].[indcodes] CHECK CONSTRAINT [FK_INDCODES_STFIPSTB] GO CREATE TABLE [dbo].[taxtype]( [stfips] [char](2) NOT NULL, [taxtype] [char](2) NOT NULL, [taxtypdesc] [varchar](40) NULL, CONSTRAINT [PK_TAXTYPE] PRIMARY KEY CLUSTERED ( [stfips] ASC, [taxtype] 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 ALTER TABLE [dbo].[taxtype] WITH CHECK ADD CONSTRAINT [FK_TAXTYPE_STFIPSTB] FOREIGN KEY([stfips]) REFERENCES [dbo].[stfipstb] ([stfips]) GO ALTER TABLE [dbo].[taxtype] CHECK CONSTRAINT [FK_TAXTYPE_STFIPSTB] GO --DEPRECATED --CREATE TABLE [dbo].[vetcode]( -- [veteran] [char](1) NOT NULL, -- [vetdesc] [varchar](60) NULL, -- CONSTRAINT [PK_VETCODE] PRIMARY KEY CLUSTERED --( -- [veteran] 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].[worksite]( [worksite] [char](1) NOT NULL, [wksitedesc] [varchar](90) NULL, CONSTRAINT [PK_WORKSITE] PRIMARY KEY CLUSTERED ( [worksite] 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].[addresty]( [addressty] [char](1) NOT NULL, [addresdesc] [varchar](60) NULL, CONSTRAINT [PK_ADDRESTY] PRIMARY KEY CLUSTERED ( [addressty] 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].[agegroup]( [stfips] [char](2) NOT NULL, [agegroup] [char](2) NOT NULL, [agegrpdesc] [char](20) NULL, CONSTRAINT [PK_AGEGROUP] PRIMARY KEY CLUSTERED ( [stfips] ASC, [agegroup] 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 ALTER TABLE [dbo].[agegroup] WITH CHECK ADD CONSTRAINT [FK_AGEGROUP_STFIPSTB] FOREIGN KEY([stfips]) REFERENCES [dbo].[stfipstb] ([stfips]) GO ALTER TABLE [dbo].[agegroup] CHECK CONSTRAINT [FK_AGEGROUP_STFIPSTB] GO --CORE CREATE TABLE [dbo].[annslflg]( [annsalflg] [char](1) NOT NULL, [annsadesc] [varchar](40) NULL, CONSTRAINT [PK_ANNSLFLG] PRIMARY KEY CLUSTERED ( [annsalflg] 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 --CORE CREATE TABLE [dbo].[annslrng]( [annsalrang] [char](2) NOT NULL, [salrngdesc] [varchar](20) NULL, CONSTRAINT [PK_ANNSLRNG] PRIMARY KEY CLUSTERED ( [annsalrang] 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 --CORE CREATE TABLE [dbo].[benmark]( [benchmark] [char](4) NOT NULL, [benchdesc] [varchar](60) NULL, CONSTRAINT [PK_BENMARK] PRIMARY KEY CLUSTERED ( [benchmark] 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 --DEPRECATED --CREATE TABLE [dbo].[clusgrad]( -- [stfips] [char](2) NOT NULL, -- [clusgrade] [char](1) NOT NULL, -- [clusgrdesc] [varchar](40) NULL, -- CONSTRAINT [PK_CLUSGRAD] PRIMARY KEY CLUSTERED --( -- [stfips] ASC, -- [clusgrade] 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 --ALTER TABLE [dbo].[clusgrad] WITH CHECK ADD CONSTRAINT [FK_CLUSGRAD_STFIPSTB] FOREIGN KEY([stfips]) --REFERENCES [dbo].[stfipstb] ([stfips]) --GO --ALTER TABLE [dbo].[clusgrad] CHECK CONSTRAINT [FK_CLUSGRAD_STFIPSTB] --GO CREATE TABLE [dbo].[cpitype]( [stfips] [char](2) NOT NULL, [cpitype] [char](2) NOT NULL, [cpititle] [varchar](55) NULL, [cpidesc] [varchar](200) NULL, CONSTRAINT [PK_CPITYPE] PRIMARY KEY CLUSTERED ( [stfips] ASC, [cpitype] 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 ALTER TABLE [dbo].[cpitype] WITH CHECK ADD CONSTRAINT [FK_CPITYPE_STFIPSTB] FOREIGN KEY([stfips]) REFERENCES [dbo].[stfipstb] ([stfips]) GO ALTER TABLE [dbo].[cpitype] CHECK CONSTRAINT [FK_CPITYPE_STFIPSTB] GO CREATE TABLE [dbo].[cpisource]( [stfips] [char](2) NOT NULL, [cpisource] [char](1) NOT NULL, [cpisrcdesc] [varchar](40) NULL, CONSTRAINT [PK_CPISOURCE] PRIMARY KEY CLUSTERED ( [stfips] ASC, [cpisource] 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 ALTER TABLE [dbo].[cpisource] WITH CHECK ADD CONSTRAINT [FK_CPISOURCE_STFIPSTB] FOREIGN KEY([stfips]) REFERENCES [dbo].[stfipstb] ([stfips]) GO ALTER TABLE [dbo].[cpisource] CHECK CONSTRAINT [FK_CPISOURCE_STFIPSTB] GO --CORE CREATE TABLE [dbo].[creditcd]( [creditcd] [char](1) NOT NULL, [creditdesc] [varchar](max) NULL, CONSTRAINT [PK_CREDITCD] PRIMARY KEY CLUSTERED ( [creditcd] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO --DEPRECATED --CREATE TABLE [dbo].[disabil]( -- [disabled] [char](1) NOT NULL, -- [disabldesc] [varchar](20) NULL, -- CONSTRAINT [PK_DISABIL] PRIMARY KEY CLUSTERED --( -- [disabled] 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 --DEPRECATED --CREATE TABLE [dbo].[disadvan]( -- [econdisadv] [char](1) NOT NULL, -- [ecodisdesc] [varchar](30) NULL, -- CONSTRAINT [PK_DISADVAN] PRIMARY KEY CLUSTERED --( -- [econdisadv] 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 --DEPRECATED --CREATE TABLE [dbo].[dislocat]( -- [dislocated] [char](1) NOT NULL, -- [dislocdesc] [varchar](20) NULL, -- CONSTRAINT [PK_DISLOCAT] PRIMARY KEY CLUSTERED --( -- [dislocated] 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 --DEPRECATED --CREATE TABLE [dbo].[dwvertyp]( -- [dwvertype] [char](1) NOT NULL, -- [dwevetdesc] [varchar](40) NULL, -- CONSTRAINT [PK_DWVERTYP] PRIMARY KEY CLUSTERED --( -- [dwvertype] 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 --CORE CREATE TABLE [dbo].[empszflg]( [empsizflg] [char](1) NOT NULL, [empflgdesc] [varchar](40) NULL, CONSTRAINT [PK_EMPSZFLG] PRIMARY KEY CLUSTERED ( [empsizflg] 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 --CORE CREATE TABLE [dbo].[empszrng]( [empsizrng] [char](2) NOT NULL, [emprngdesc] [varchar](40) NULL, CONSTRAINT [PK_EMPSZRNG] PRIMARY KEY CLUSTERED ( [empsizrng] 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 --CORE CREATE TABLE [dbo].[growcode]( [stfips] [char](2) NOT NULL, [growcode] [char](2) NOT NULL, [growdesc] [varchar](20) NULL, CONSTRAINT [PK_GROWCODE] PRIMARY KEY CLUSTERED ( [stfips] ASC, [growcode] 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 ALTER TABLE [dbo].[growcode] WITH CHECK ADD CONSTRAINT [FK_GROWCODE_STFIPSTB] FOREIGN KEY([stfips]) REFERENCES [dbo].[stfipstb] ([stfips]) GO ALTER TABLE [dbo].[growcode] CHECK CONSTRAINT [FK_GROWCODE_STFIPSTB] GO CREATE TABLE [dbo].[incsourc]( [stfips] [char](2) NOT NULL, [incsource] [char](1) NOT NULL, [incsrcdesc] [varchar](40) NULL, CONSTRAINT [PK_INCSOURC] PRIMARY KEY CLUSTERED ( [stfips] ASC, [incsource] 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 ALTER TABLE [dbo].[incsourc] WITH CHECK ADD CONSTRAINT [FK_INCSOURC_STFIPSTB] FOREIGN KEY([stfips]) REFERENCES [dbo].[stfipstb] ([stfips]) GO ALTER TABLE [dbo].[incsourc] CHECK CONSTRAINT [FK_INCSOURC_STFIPSTB] GO --CHANGES IN V2.8 CREATE TABLE [dbo].[incomtyp]( [stfips] [char](2) NOT NULL, [inctype] [char](2) NOT NULL, [incdesc] [varchar](75) NULL, CONSTRAINT [PK_INCOMTYP] PRIMARY KEY CLUSTERED ( [stfips] ASC, [inctype] 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 ALTER TABLE [dbo].[incomtyp] WITH CHECK ADD CONSTRAINT [FK_INCOMTYP_STFIPSTB] FOREIGN KEY([stfips]) REFERENCES [dbo].[stfipstb] ([stfips]) GO ALTER TABLE [dbo].[incomtyp] CHECK CONSTRAINT [FK_INCOMTYP_STFIPSTB] GO CREATE TABLE [dbo].[laytitle]( [laytlcode] [char](5) NOT NULL, [laytitle] [varchar](130) NULL, CONSTRAINT [PK_LAYTITLE] PRIMARY KEY CLUSTERED ( [laytlcode] 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].[licnumty]( [licnumtype] [char](2) NOT NULL, [licnumdesc] [varchar](50) NULL, CONSTRAINT [PK_LICNUMTY] PRIMARY KEY CLUSTERED ( [licnumtype] 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 --CORE CREATE TABLE [dbo].[locstat]( [locstat] [char](1) NOT NULL, [locstdesc] [varchar](40) NULL, CONSTRAINT [PK_LOCSTAT] PRIMARY KEY CLUSTERED ( [locstat] 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].[mpc]( [mpc] [char](1) NOT NULL, [mpcdesc] [varchar](70) NULL, CONSTRAINT [PK_MPC] PRIMARY KEY CLUSTERED ( [mpc] 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].[svc]( [svc] [char](1) NOT NULL, [svctitle] [varchar](130) NULL, CONSTRAINT [PK_SVC] PRIMARY KEY CLUSTERED ( [svc] 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].[moccode]( [svc] [char](1) NOT NULL, [mpc] [char](1) NOT NULL, [status] [char](1) NOT NULL, [moccode] [char](10) NOT NULL, [moctitle] [varchar](170) NULL, [mocdesc] [varchar](max) NULL, CONSTRAINT [PK_MOCCODE] PRIMARY KEY CLUSTERED ( [svc] ASC, [mpc] ASC, [status] ASC, [moccode] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO ALTER TABLE [dbo].[moccode] WITH CHECK ADD CONSTRAINT [FK_MOCCODE_MPC] FOREIGN KEY([mpc]) REFERENCES [dbo].[mpc] ([mpc]) GO ALTER TABLE [dbo].[moccode] CHECK CONSTRAINT [FK_MOCCODE_MPC] GO ALTER TABLE [dbo].[moccode] WITH CHECK ADD CONSTRAINT [FK_MOCCODE_SVC] FOREIGN KEY([svc]) REFERENCES [dbo].[svc] ([svc]) GO ALTER TABLE [dbo].[moccode] CHECK CONSTRAINT [FK_MOCCODE_SVC] GO --DEPRECATED --CREATE TABLE [dbo].[urltopic]( -- [stfips] [char](2) NOT NULL, -- [urltopic] [char](3) NOT NULL, -- [topicdesc] [varchar](40) NULL, -- CONSTRAINT [PK_urltopic] PRIMARY KEY CLUSTERED --( -- [stfips] ASC, -- [urltopic] 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 --CORE CREATE TABLE [dbo].[prvgovst]( [privgovsta] [char](1) NOT NULL, [prvgovdesc] [varchar](15) NULL, CONSTRAINT [PK_PRVGOCST] PRIMARY KEY CLUSTERED ( [privgovsta] 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].[schgrade]( [stfips] [char](2) NOT NULL, [highestgrd] [char](2) NOT NULL, [highgrdesc] [varchar](35) NULL, CONSTRAINT [PK_SCHGRADE] PRIMARY KEY CLUSTERED ( [stfips] ASC, [highestgrd] 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 ALTER TABLE [dbo].[schgrade] WITH CHECK ADD CONSTRAINT [FK_SCHGRADE_STFIPSTB] FOREIGN KEY([stfips]) REFERENCES [dbo].[stfipstb] ([stfips]) GO ALTER TABLE [dbo].[schgrade] CHECK CONSTRAINT [FK_SCHGRADE_STFIPSTB] GO --DEPRECATED --CREATE TABLE [dbo].[seasonal]( -- [seasonal] [char](1) NOT NULL, -- [seasondesc] [varchar](20) NULL, -- CONSTRAINT [PK_SEASONAL] PRIMARY KEY CLUSTERED --( -- [seasonal] 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].[bedtypes]( [bedtypcode] [char](1) NOT NULL, [bedtypdesc] [varchar](60) NULL, CONSTRAINT [PK_BEDTYPES] PRIMARY KEY CLUSTERED ( [bedtypcode] 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].[classtime]( [classtime] [char](1) NOT NULL, [classtimetitle] [varchar](40) NULL, CONSTRAINT [PK_CLASSTIME] PRIMARY KEY CLUSTERED ( [classtime] 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 --CORE CREATE TABLE [dbo].[contactpro]( [contactprotitle] [char](3) NOT NULL, [contactprodesc] [varchar](35) NULL, CONSTRAINT [PK_CONTACTPRO] PRIMARY KEY CLUSTERED ( [contactprotitle] 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 --CORE CREATE TABLE [dbo].[contacttitle]( [contacttitlecode] [char](1) NOT NULL, [contacttitledesc] [varchar](35) NULL, CONSTRAINT [PK_CONTACTTITLE] PRIMARY KEY CLUSTERED ( [contacttitlecode] 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].[stockexch]( [stockexchcode] [char](1) NOT NULL, [stockexchdesc] [varchar](40) NULL, CONSTRAINT [PK_STOCKEXCH] PRIMARY KEY CLUSTERED ( [stockexchcode] 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].[iospecialid]( [stfips] [char](2) NOT NULL, [indcodty] [char](2) NOT NULL, [indcode] [char](6) NOT NULL, [occodetype] [char](2) NOT NULL, [occcode] [char](10) NOT NULL, [green] [char](1) NULL, [pctgreen] [numeric](9, 3) NULL, CONSTRAINT [PK_IOSPECIALID] PRIMARY KEY CLUSTERED ( [stfips] ASC, [indcodty] ASC, [indcode] ASC, [occodetype] ASC, [occcode] 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 ALTER TABLE [dbo].[iospecialid] WITH CHECK ADD CONSTRAINT [FK_IOSPECIALID_INDCODES] FOREIGN KEY([stfips], [indcodty], [indcode]) REFERENCES [dbo].[indcodes] ([stfips], [codetype], [code]) GO ALTER TABLE [dbo].[iospecialid] CHECK CONSTRAINT [FK_IOSPECIALID_INDCODES] GO ALTER TABLE [dbo].[iospecialid] WITH CHECK ADD CONSTRAINT [FK_IOSPECIALID_OCCCODES] FOREIGN KEY([stfips], [occodetype], [occcode]) REFERENCES [dbo].[occcodes] ([stfips], [CODETYPE], [CODE]) GO ALTER TABLE [dbo].[iospecialid] CHECK CONSTRAINT [FK_IOSPECIALID_OCCCODES] GO --DEPRECATED --CREATE TABLE [dbo].[analysis]( -- [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, -- [cluscode] [char](10) NOT NULL, -- [analysis] [varchar](max) NULL, -- [clusgrade] [char](1) NULL, -- [placeclus] [varchar](max) NULL, -- CONSTRAINT [PK_ANALYSIS] PRIMARY KEY CLUSTERED --( -- [stfips] ASC, -- [areatype] ASC, -- [area] ASC, -- [periodyear] ASC, -- [periodtype] ASC, -- [period] ASC, -- [cluscode] ASC --)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] --) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] --GO --ALTER TABLE [dbo].[analysis] WITH CHECK ADD CONSTRAINT [FK_ANALYSIS_CLUSCODE] FOREIGN KEY([stfips], [cluscode]) --REFERENCES [dbo].[cluscode] ([stfips], [cluscode]) --GO --ALTER TABLE [dbo].[analysis] CHECK CONSTRAINT [FK_ANALYSIS_CLUSCODE] --GO --ALTER TABLE [dbo].[analysis] WITH CHECK ADD CONSTRAINT [FK_ANALYSIS_CLUSGRAD] FOREIGN KEY([stfips], [clusgrade]) --REFERENCES [dbo].[clusgrad] ([stfips], [clusgrade]) --GO --ALTER TABLE [dbo].[analysis] CHECK CONSTRAINT [FK_ANALYSIS_CLUSGRAD] --GO --ALTER TABLE [dbo].[analysis] WITH CHECK ADD CONSTRAINT [FK_ANALYSIS_GEOG] FOREIGN KEY([stfips], [areatype], [area]) --REFERENCES [dbo].[geog] ([stfips], [areatype], [area]) --GO --ALTER TABLE [dbo].[analysis] CHECK CONSTRAINT [FK_ANALYSIS_GEOG] --GO --ALTER TABLE [dbo].[analysis] WITH CHECK ADD CONSTRAINT [FK_ANALYSIS_PERIOD] FOREIGN KEY([periodyear], [periodtype], [period]) --REFERENCES [dbo].[period] ([periodyear], [periodtype], [period]) --GO --ALTER TABLE [dbo].[analysis] CHECK CONSTRAINT [FK_ANALYSIS_PERIOD] --GO CREATE TABLE [dbo].[bed]( [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, [indcodtype] [char](2) NOT NULL, [indcode] [char](6) NOT NULL, [adjusted] [char](1) NOT NULL, [bedtypcode] [char](1) NOT NULL, [bedemploy] [numeric](12, 0) NULL, [bedempperc] [numeric](4, 1) NULL, [bedestabs] [numeric](12, 0) NULL, [bedestperc] [numeric](4, 1) NULL, [suppress] [char](1) NULL, CONSTRAINT [PK_BED] PRIMARY KEY CLUSTERED ( [stfips] ASC, [areatype] ASC, [area] ASC, [periodyear] ASC, [periodtype] ASC, [period] ASC, [indcodtype] ASC, [indcode] ASC, [adjusted] ASC, [bedtypcode] 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 ALTER TABLE [dbo].[bed] WITH CHECK ADD CONSTRAINT [FK_BED_BEDTYPES] FOREIGN KEY([bedtypcode]) REFERENCES [dbo].[bedtypes] ([bedtypcode]) GO ALTER TABLE [dbo].[bed] CHECK CONSTRAINT [FK_BED_BEDTYPES] GO ALTER TABLE [dbo].[bed] WITH CHECK ADD CONSTRAINT [FK_BED_GEOG] FOREIGN KEY([stfips], [areatype], [area]) REFERENCES [dbo].[geog] ([stfips], [areatype], [area]) GO ALTER TABLE [dbo].[bed] CHECK CONSTRAINT [FK_BED_GEOG] GO ALTER TABLE [dbo].[bed] WITH CHECK ADD CONSTRAINT [FK_BED_INDCODES] FOREIGN KEY([stfips], [indcodtype], [indcode]) REFERENCES [dbo].[indcodes] ([stfips], [codetype], [code]) GO ALTER TABLE [dbo].[bed] CHECK CONSTRAINT [FK_BED_INDCODES] GO ALTER TABLE [dbo].[bed] WITH CHECK ADD CONSTRAINT [FK_BED_PERIOD] FOREIGN KEY([periodyear], [periodtype], [period]) REFERENCES [dbo].[period] ([periodyear], [periodtype], [period]) GO ALTER TABLE [dbo].[bed] CHECK CONSTRAINT [FK_BED_PERIOD] GO CREATE TABLE [dbo].[blding]( [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, [unittype] [char](2) NOT NULL, [units] [numeric](7, 0) NULL, [unitcost] [numeric](12, 0) NULL, CONSTRAINT [PK_BLDING] PRIMARY KEY CLUSTERED ( [stfips] ASC, [areatype] ASC, [area] ASC, [periodyear] ASC, [periodtype] ASC, [period] ASC, [unittype] 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 ALTER TABLE [dbo].[blding] WITH CHECK ADD CONSTRAINT [FK_BLDING_GEOG] FOREIGN KEY([stfips], [areatype], [area]) REFERENCES [dbo].[geog] ([stfips], [areatype], [area]) GO ALTER TABLE [dbo].[blding] CHECK CONSTRAINT [FK_BLDING_GEOG] GO ALTER TABLE [dbo].[blding] WITH CHECK ADD CONSTRAINT [FK_BLDING_PERIOD] FOREIGN KEY([periodyear], [periodtype], [period]) REFERENCES [dbo].[period] ([periodyear], [periodtype], [period]) GO ALTER TABLE [dbo].[blding] CHECK CONSTRAINT [FK_BLDING_PERIOD] GO ALTER TABLE [dbo].[blding] WITH CHECK ADD CONSTRAINT [FK_BLDING_UNITTYPE] FOREIGN KEY([stfips], [unittype]) REFERENCES [dbo].[unittype] ([stfips], [unittype]) GO ALTER TABLE [dbo].[blding] CHECK CONSTRAINT [FK_BLDING_UNITTYPE] GO --DEPRECATED --CREATE TABLE [dbo].[cenlabor]( -- [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, -- [censcode] [char](4) NOT NULL, -- [codetype] [char](2) NOT NULL, -- [femalelf] [numeric](8, 0) NULL, -- [malelf] [numeric](8, 0) NULL, -- CONSTRAINT [PK_CENLABOR] PRIMARY KEY CLUSTERED --( -- [stfips] ASC, -- [areatype] ASC, -- [area] ASC, -- [periodyear] ASC, -- [periodtype] ASC, -- [period] ASC, -- [censcode] ASC, -- [codetype] 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 --ALTER TABLE [dbo].[cenlabor] WITH CHECK ADD CONSTRAINT [FK_CENLABOR_CENSCODE] FOREIGN KEY([censcode]) --REFERENCES [dbo].[censcode] ([censcode]) --GO --ALTER TABLE [dbo].[cenlabor] CHECK CONSTRAINT [FK_CENLABOR_CENSCODE] --GO --ALTER TABLE [dbo].[cenlabor] WITH CHECK ADD CONSTRAINT [FK_CENLABOR_GEOG] FOREIGN KEY([stfips], [areatype], [area]) --REFERENCES [dbo].[geog] ([stfips], [areatype], [area]) --GO --ALTER TABLE [dbo].[cenlabor] CHECK CONSTRAINT [FK_CENLABOR_GEOG] --GO --ALTER TABLE [dbo].[cenlabor] WITH CHECK ADD CONSTRAINT [FK_CENLABOR_PERIOD] FOREIGN KEY([periodyear], [periodtype], [period]) --REFERENCES [dbo].[period] ([periodyear], [periodtype], [period]) --GO --ALTER TABLE [dbo].[cenlabor] CHECK CONSTRAINT [FK_CENLABOR_PERIOD] --GO --CORE CREATE TABLE [dbo].[ces]( [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, [seriescode] [char](8) NOT NULL, [adjusted] [char](1) NOT NULL, [benchmark] [char](4) NULL, [prelim] [char](1) NULL, [empces] [numeric](9, 0) NULL, [empprodwrk] [numeric](9, 0) NULL, [empfemale] [numeric](9, 0) NULL, [hours] [numeric](3, 1) NULL, [earnings] [numeric](8, 2) NULL, [hourearn] [numeric](6, 2) NULL, [supprecord] [char](1) NULL, [supphe] [char](1) NULL, [supppw] [char](1) NULL, [suppfem] [char](1) NULL, [hoursallwrkr] [numeric](3, 1) NULL, [earningsallwrkr] [numeric](8, 2) NULL, [hourearnallwrkr] [numeric](6, 2) NULL, [suppheallwrkr] [char](1) NULL, CONSTRAINT [PK_CES] PRIMARY KEY CLUSTERED ( [stfips] ASC, [areatype] ASC, [area] ASC, [periodyear] ASC, [periodtype] ASC, [period] ASC, [seriescode] ASC, [adjusted] 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 ALTER TABLE [dbo].[ces] WITH CHECK ADD CONSTRAINT [FK_CES_BENMARK] FOREIGN KEY([benchmark]) REFERENCES [dbo].[benmark] ([benchmark]) GO ALTER TABLE [dbo].[ces] CHECK CONSTRAINT [FK_CES_BENMARK] GO ALTER TABLE [dbo].[ces] WITH CHECK ADD CONSTRAINT [FK_CES_CESCODE] FOREIGN KEY([stfips], [seriescode]) REFERENCES [dbo].[cescode] ([stfips], [seriescode]) GO ALTER TABLE [dbo].[ces] CHECK CONSTRAINT [FK_CES_CESCODE] GO ALTER TABLE [dbo].[ces] WITH CHECK ADD CONSTRAINT [FK_CES_GEOG] FOREIGN KEY([stfips], [areatype], [area]) REFERENCES [dbo].[geog] ([stfips], [areatype], [area]) GO ALTER TABLE [dbo].[ces] CHECK CONSTRAINT [FK_CES_GEOG] GO ALTER TABLE [dbo].[ces] WITH CHECK ADD CONSTRAINT [FK_CES_PERIOD] FOREIGN KEY([periodyear], [periodtype], [period]) REFERENCES [dbo].[period] ([periodyear], [periodtype], [period]) GO ALTER TABLE [dbo].[ces] CHECK CONSTRAINT [FK_CES_PERIOD] GO CREATE TABLE [dbo].[commute]( [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, [wkstfips] [char](2) NOT NULL, [wkareaty] [char](2) NOT NULL, [wkarea] [char](6) NOT NULL, [workers] [numeric](8, 0) NULL, CONSTRAINT [PK_COMMUTE] PRIMARY KEY CLUSTERED ( [stfips] ASC, [areatype] ASC, [area] ASC, [periodyear] ASC, [periodtype] ASC, [period] ASC, [wkstfips] ASC, [wkareaty] ASC, [wkarea] 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 ALTER TABLE [dbo].[commute] WITH CHECK ADD CONSTRAINT [FK_COMMUTE_GEOG_ST] FOREIGN KEY([stfips], [areatype], [area]) REFERENCES [dbo].[geog] ([stfips], [areatype], [area]) GO ALTER TABLE [dbo].[commute] CHECK CONSTRAINT [FK_COMMUTE_GEOG_ST] GO ALTER TABLE [dbo].[commute] WITH CHECK ADD CONSTRAINT [FK_COMMUTE_GEOG_WK] FOREIGN KEY([wkstfips], [wkareaty], [wkarea]) REFERENCES [dbo].[geog] ([stfips], [areatype], [area]) GO ALTER TABLE [dbo].[commute] CHECK CONSTRAINT [FK_COMMUTE_GEOG_WK] GO ALTER TABLE [dbo].[commute] WITH CHECK ADD CONSTRAINT [FK_COMMUTE_PERIOD] FOREIGN KEY([periodyear], [periodtype], [period]) REFERENCES [dbo].[period] ([periodyear], [periodtype], [period]) GO ALTER TABLE [dbo].[commute] CHECK CONSTRAINT [FK_COMMUTE_PERIOD] GO CREATE TABLE [dbo].[cpi]( [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, [cpitype] [char](2) NOT NULL, [cpisource] [char](1) NOT NULL, [cpi] [numeric](8, 3) NULL, [pctchgy] [numeric](6, 1) NULL, [pctchgm] [numeric](6, 1) NULL, CONSTRAINT [PK_CPI] PRIMARY KEY CLUSTERED ( [stfips] ASC, [areatype] ASC, [area] ASC, [periodyear] ASC, [periodtype] ASC, [period] ASC, [cpitype] ASC, [cpisource] 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 ALTER TABLE [dbo].[cpi] WITH CHECK ADD CONSTRAINT [FK_CPI_CPISOURCE] FOREIGN KEY([stfips], [cpisource]) REFERENCES [dbo].[cpisource] ([stfips], [cpisource]) GO ALTER TABLE [dbo].[cpi] CHECK CONSTRAINT [FK_CPI_CPISOURCE] GO ALTER TABLE [dbo].[cpi] WITH CHECK ADD CONSTRAINT [FK_CPI_CPITYPE] FOREIGN KEY([stfips], [cpitype]) REFERENCES [dbo].[cpitype] ([stfips], [cpitype]) GO ALTER TABLE [dbo].[cpi] CHECK CONSTRAINT [FK_CPI_CPITYPE] GO ALTER TABLE [dbo].[cpi] WITH CHECK ADD CONSTRAINT [FK_CPI_GEOG] FOREIGN KEY([stfips], [areatype], [area]) REFERENCES [dbo].[geog] ([stfips], [areatype], [area]) GO ALTER TABLE [dbo].[cpi] CHECK CONSTRAINT [FK_CPI_GEOG] GO ALTER TABLE [dbo].[cpi] WITH CHECK ADD CONSTRAINT [FK_CPI_PERIOD] FOREIGN KEY([periodyear], [periodtype], [period]) REFERENCES [dbo].[period] ([periodyear], [periodtype], [period]) GO ALTER TABLE [dbo].[cpi] CHECK CONSTRAINT [FK_CPI_PERIOD] GO CREATE TABLE [dbo].[cpiplus]( [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, [ADJUSTED] [char](1) NOT NULL, [CPIINDEX] [char](1) NOT NULL, [CPIITEM] [char](9) NOT NULL, [CPISOURCE] [char](1) NOT NULL, [BASIS] [char](4) NOT NULL, [CPI] [numeric](8, 3) NULL, [PCTCHANGEY] [numeric](6, 1) NULL, [PCTCHANGEM] [numeric](6, 1) NULL, CONSTRAINT [PK_CPIPLUS] PRIMARY KEY CLUSTERED ( [STFIPS] ASC, [AREATYPE] ASC, [AREA] ASC, [PERIODYEAR] ASC, [PERIODTYPE] ASC, [PERIOD] ASC, [ADJUSTED] ASC, [CPIINDEX] ASC, [CPIITEM] ASC, [CPISOURCE] 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 ALTER TABLE [dbo].[cpiplus] WITH CHECK ADD CONSTRAINT [FK_CPIPLUS_CPISOURCE] FOREIGN KEY([STFIPS], [CPISOURCE]) REFERENCES [dbo].[cpisource] ([stfips], [cpisource]) GO ALTER TABLE [dbo].[cpiplus] CHECK CONSTRAINT [FK_CPIPLUS_CPISOURCE] GO ALTER TABLE [dbo].[cpiplus] WITH CHECK ADD CONSTRAINT [FK_CPIPLUS_GEOG] FOREIGN KEY([STFIPS], [AREATYPE], [AREA]) REFERENCES [dbo].[geog] ([stfips], [areatype], [area]) GO ALTER TABLE [dbo].[cpiplus] CHECK CONSTRAINT [FK_CPIPLUS_GEOG] GO ALTER TABLE [dbo].[cpiplus] WITH CHECK ADD CONSTRAINT [FK_CPIPLUS_ITEMCPI] FOREIGN KEY([CPIITEM]) REFERENCES [dbo].[itemcpi] ([CPIITEM]) GO ALTER TABLE [dbo].[cpiplus] CHECK CONSTRAINT [FK_CPIPLUS_ITEMCPI] GO ALTER TABLE [dbo].[cpiplus] WITH CHECK ADD CONSTRAINT [FK_CPIPLUS_PERIOD] FOREIGN KEY([PERIODYEAR], [PERIODTYPE], [PERIOD]) REFERENCES [dbo].[period] ([periodyear], [periodtype], [period]) GO ALTER TABLE [dbo].[cpiplus] CHECK CONSTRAINT [FK_CPIPLUS_PERIOD] GO --CHANGES IN V2.8 CREATE TABLE [dbo].[demographics]( [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, [population] [numeric](9, 0) NULL, [female] [numeric](9, 0) NULL, [male] [numeric](9, 0) NULL, [median] [numeric](4, 1) NULL, [medianmale] [numeric](4, 1) NULL, [medianfem] [numeric](4, 1) NULL, [totunder5] [numeric](9, 0) NULL, [femunder5] [numeric](9, 0) NULL, [maleunder5] [numeric](9, 0) NULL, [tot5to9] [numeric](9, 0) NULL, [fem5to9] [numeric](9, 0) NULL, [male5to9] [numeric](9, 0) NULL, [tot10to14] [numeric](9, 0) NULL, [fem10to14] [numeric](9, 0) NULL, [male10to14] [numeric](9, 0) NULL, [tot15to19] [numeric](9, 0) NULL, [fem15to19] [numeric](9, 0) NULL, [male15to19] [numeric](9, 0) NULL, [tot15to17] [numeric](9, 0) NULL, [fem15to17] [numeric](9, 0) NULL, [male15to17] [numeric](9, 0) NULL, [tot18to19] [numeric](9, 0) NULL, [fem18to19] [numeric](9, 0) NULL, [male18to19] [numeric](9, 0) NULL, [tot20to24] [numeric](9, 0) NULL, [fem20to24] [numeric](9, 0) NULL, [male20to24] [numeric](9, 0) NULL, [tot20] [numeric](9, 0) NULL, [fem20] [numeric](9, 0) NULL, [male20] [numeric](9, 0) NULL, [tot21] [numeric](9, 0) NULL, [fem21] [numeric](9, 0) NULL, [male21] [numeric](9, 0) NULL, [tot22to24] [numeric](9, 0) NULL, [fem22to24] [numeric](9, 0) NULL, [male22to24] [numeric](9, 0) NULL, [tot25to34] [numeric](9, 0) NULL, [fem25to34] [numeric](9, 0) NULL, [male25to34] [numeric](9, 0) NULL, [tot25to29] [numeric](9, 0) NULL, [fem25to29] [numeric](9, 0) NULL, [male25to29] [numeric](9, 0) NULL, [tot30to34] [numeric](9, 0) NULL, [fem30to34] [numeric](9, 0) NULL, [male30to34] [numeric](9, 0) NULL, [tot35to44] [numeric](9, 0) NULL, [fem35to44] [numeric](9, 0) NULL, [male35to44] [numeric](9, 0) NULL, [tot35to39] [numeric](9, 0) NULL, [fem35to39] [numeric](9, 0) NULL, [male35to39] [numeric](9, 0) NULL, [tot40to44] [numeric](9, 0) NULL, [fem40to44] [numeric](9, 0) NULL, [male40to44] [numeric](9, 0) NULL, [tot45to54] [numeric](9, 0) NULL, [fem45to54] [numeric](9, 0) NULL, [male45to54] [numeric](9, 0) NULL, [tot45to49] [numeric](9, 0) NULL, [fem45to49] [numeric](9, 0) NULL, [male45to49] [numeric](9, 0) NULL, [tot50to54] [numeric](9, 0) NULL, [fem50to54] [numeric](9, 0) NULL, [male50to54] [numeric](9, 0) NULL, [tot55to59] [numeric](9, 0) NULL, [fem55to59] [numeric](9, 0) NULL, [male55to59] [numeric](9, 0) NULL, [tot60to64] [numeric](9, 0) NULL, [fem60to64] [numeric](9, 0) NULL, [male60to64] [numeric](9, 0) NULL, [tot60to61] [numeric](9, 0) NULL, [fem60to61] [numeric](9, 0) NULL, [male60to61] [numeric](9, 0) NULL, [tot62to64] [numeric](9, 0) NULL, [fem62to64] [numeric](9, 0) NULL, [male62to64] [numeric](9, 0) NULL, [tot65to69] [numeric](9, 0) NULL, [fem65to69] [numeric](9, 0) NULL, [male65to69] [numeric](9, 0) NULL, [tot65to66] [numeric](9, 0) NULL, [fem65to66] [numeric](9, 0) NULL, [male65to66] [numeric](9, 0) NULL, [tot67to69] [numeric](9, 0) NULL, [fem67to69] [numeric](9, 0) NULL, [male67to69] [numeric](9, 0) NULL, [tot70to74] [numeric](9, 0) NULL, [fem70to74] [numeric](9, 0) NULL, [male70to74] [numeric](9, 0) NULL, [tot75to84] [numeric](9, 0) NULL, [fem75to84] [numeric](9, 0) NULL, [male75to84] [numeric](9, 0) NULL, [tot75to79] [numeric](9, 0) NULL, [fem75to79] [numeric](9, 0) NULL, [male75to79] [numeric](9, 0) NULL, [tot80to84] [numeric](9, 0) NULL, [fem80to84] [numeric](9, 0) NULL, [male80to84] [numeric](9, 0) NULL, [tot85xx] [numeric](9, 0) NULL, [fem85xx] [numeric](9, 0) NULL, [male85xx] [numeric](9, 0) NULL, [tot18xx] [numeric](9, 0) NULL, [fem18xx] [numeric](9, 0) NULL, [male18xx] [numeric](9, 0) NULL, [tot21xx] [numeric](9, 0) NULL, [fem21xx] [numeric](9, 0) NULL, [male21xx] [numeric](9, 0) NULL, [tot62xx] [numeric](9, 0) NULL, [fem62xx] [numeric](9, 0) NULL, [male62xx] [numeric](9, 0) NULL, [onerace] [numeric](9, 0) NULL, [white] [numeric](9, 0) NULL, [black] [numeric](9, 0) NULL, [naan] [numeric](9, 0) NULL, [asian] [numeric](9, 0) NULL, [pacisland] [numeric](9, 0) NULL, [other] [numeric](9, 0) NULL, [twomoraces] [numeric](9, 0) NULL, [hispanic] [numeric](9, 0) NULL, [hispwhite] [numeric](9, 0) NULL, [hispblack] [numeric](9, 0) NULL, [hispnaan] [numeric](9, 0) NULL, [hispasian] [numeric](9, 0) NULL, [hisppacisl] [numeric](9, 0) NULL, [hispother] [numeric](9, 0) NULL, [hisp2race] [numeric](9, 0) NULL, CONSTRAINT [PK_DEMOGRAPHICS] PRIMARY KEY CLUSTERED ( [stfips] ASC, [areatype] ASC, [area] ASC, [periodyear] ASC, [periodtype] ASC, [period] ASC, [popsource] 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 ALTER TABLE [dbo].[demographics] WITH CHECK ADD CONSTRAINT [FK_DEMOGRAPHICS_GEOG] FOREIGN KEY([stfips], [areatype], [area]) REFERENCES [dbo].[geog] ([stfips], [areatype], [area]) GO ALTER TABLE [dbo].[demographics] CHECK CONSTRAINT [FK_DEMOGRAPHICS_GEOG] GO ALTER TABLE [dbo].[demographics] WITH CHECK ADD CONSTRAINT [FK_DEMOGRAPHICS_PERIOD] FOREIGN KEY([periodyear], [periodtype], [period]) REFERENCES [dbo].[period] ([periodyear], [periodtype], [period]) GO ALTER TABLE [dbo].[demographics] CHECK CONSTRAINT [FK_DEMOGRAPHICS_PERIOD] GO ALTER TABLE [dbo].[demographics] WITH CHECK ADD CONSTRAINT [FK_DEMOGRAPHICS_POPSOURCE] FOREIGN KEY([stfips], [popsource]) REFERENCES [dbo].[popsource] ([stfips], [popsource]) GO ALTER TABLE [dbo].[demographics] CHECK CONSTRAINT [FK_DEMOGRAPHICS_POPSOURCE] GO --DEPRECATED --CREATE TABLE [dbo].[develop]( -- [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, -- [indcodty] [char](2) NOT NULL, -- [indcode] [char](6) NOT NULL, -- [newinvest] [numeric](10, 0) NULL, -- [newemply] [numeric](7, 0) NULL, -- [newfirms] [numeric](6, 0) NULL, -- [expinvest] [numeric](10, 0) NULL, -- [expemply] [numeric](7, 0) NULL, -- [expfirms] [numeric](6, 0) NULL, -- [invincent] [numeric](10, 0) NULL, -- CONSTRAINT [PK_DEVELOP] PRIMARY KEY CLUSTERED --( -- [stfips] ASC, -- [areatype] ASC, -- [area] ASC, -- [periodyear] ASC, -- [periodtype] ASC, -- [period] ASC, -- [indcodty] ASC, -- [indcode] 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 --ALTER TABLE [dbo].[develop] WITH CHECK ADD CONSTRAINT [FK_DEVELOP_GEOG] FOREIGN KEY([stfips], [areatype], [area]) --REFERENCES [dbo].[geog] ([stfips], [areatype], [area]) --GO --ALTER TABLE [dbo].[develop] CHECK CONSTRAINT [FK_DEVELOP_GEOG] --GO --ALTER TABLE [dbo].[develop] WITH CHECK ADD CONSTRAINT [FK_DEVELOP_INDCODES] FOREIGN KEY([stfips], [indcodty], [indcode]) --REFERENCES [dbo].[indcodes] ([stfips], [codetype], [code]) --GO --ALTER TABLE [dbo].[develop] CHECK CONSTRAINT [FK_DEVELOP_INDCODES] --GO --ALTER TABLE [dbo].[develop] WITH CHECK ADD CONSTRAINT [FK_DEVELOP_PERIOD] FOREIGN KEY([periodyear], [periodtype], [period]) --REFERENCES [dbo].[period] ([periodyear], [periodtype], [period]) --GO --ALTER TABLE [dbo].[develop] CHECK CONSTRAINT [FK_DEVELOP_PERIOD] --GO --CORE CREATE TABLE [dbo].[empdbinf]( [RELEASENO] [char](3) NOT NULL, [RELEASEMO] [char](2) NULL, [RELEASEYR] [char](4) NULL, [COPYRTYEAR] [char](4) NULL, [CONTRACTYR] [char](4) NULL, [EDITIONYR] [char](4) NULL, CONSTRAINT [PK_EMPDBINF] PRIMARY KEY CLUSTERED ( [RELEASENO] 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 --CORE CREATE TABLE [dbo].[empdb]( [stfips] [char](2) NULL, [areatype] [char](2) NULL, [area] [char](6) NULL, [uniqueid] [char](9) NOT NULL, [fein] [char](9) NULL, [lastupdate] [char](6) NULL, [name] [varchar](35) NULL, [addressp] [varchar](40) NULL, [cityp] [varchar](30) NULL, [statep] [char](2) NULL, [zipcodep] [char](5) NULL, [zipplusp] [char](4) NULL, [latitude] [numeric](11, 6) NULL, [longitude] [numeric](11, 6) NULL, [geopcode] [char](1) NULL, [censustract] [char](6) NULL, [censusblockgrp] [char](1) NULL, [addressm] [varchar](40) NULL, [citym] [varchar](30) NULL, [statem] [char](2) NULL, [zipcodem] [char](5) NULL, [zipplusm] [char](4) NULL, [addressl] [varchar](40) NULL, [cityl] [varchar](30) NULL, [statel] [char](2) NULL, [zipcodel] [char](5) NULL, [zipplusl] [char](4) NULL, [telenum] [char](10) NULL, [cntctlname] [varchar](30) NULL, [cntctfname] [varchar](30) NULL, [cntcttitle] [varchar](35) NULL, [contacttitlecode] [char](1) NULL, [contactprotitle] [char](3) NULL, [contactgender] [char](1) NULL, [contactemail] [varchar](60) NULL, [tollfreetele] [char](10) NULL, [faxnumber] [char](10) NULL, [weburl] [varchar](40) NULL, [busdesc] [varchar](45) NULL, [primarysic] [char](6) NULL, [sic2] [char](6) NULL, [sic3] [char](6) NULL, [sic4] [char](6) NULL, [sic5] [char](6) NULL, [primnaics] [char](8) NULL, [naics2] [char](8) NULL, [naics3] [char](8) NULL, [naics4] [char](8) NULL, [naics5] [char](8) NULL, [privgovsta] [char](1) NULL, [locstat] [char](1) NULL, [stockexchcode] [char](1) NULL, [stockticker] [char](6) NULL, [whitecollarpct] [numeric](4, 1) NULL, [whitecollarind] [char](1) NULL, [empsizrng] [char](2) NULL, [empsizval] [numeric](9, 0) NULL, [empsizflg] [char](1) NULL, [annsalrng] [char](2) NULL, [annsalval] [varchar](15) NULL, [annsalflg] [char](1) NULL, [yearest] [char](4) NULL, [creditcd] [char](1) NULL, [hdqtrsid] [char](9) NULL, [parentid] [char](9) NULL, [ultimateparentid] [char](9) NULL, [foreignparentind] [char](1) NULL, [exportimportind] [char](1) NULL, [businesstype] [char](1) NULL, [workathome] [char](1) NULL, [releaseno] [char](3) NULL, CONSTRAINT [PK_EMPDB] PRIMARY KEY CLUSTERED ( [uniqueid] 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 ALTER TABLE [dbo].[empdb] WITH CHECK ADD CONSTRAINT [FK_EMPDB_ANNSLFLG] FOREIGN KEY([annsalflg]) REFERENCES [dbo].[annslflg] ([annsalflg]) GO ALTER TABLE [dbo].[empdb] CHECK CONSTRAINT [FK_EMPDB_ANNSLFLG] GO ALTER TABLE [dbo].[empdb] WITH CHECK ADD CONSTRAINT [FK_EMPDB_ANNSLRNG] FOREIGN KEY([annsalrng]) REFERENCES [dbo].[annslrng] ([annsalrang]) GO ALTER TABLE [dbo].[empdb] CHECK CONSTRAINT [FK_EMPDB_ANNSLRNG] GO ALTER TABLE [dbo].[empdb] WITH CHECK ADD CONSTRAINT [FK_EMPDB_CONTACTPRO] FOREIGN KEY([contactprotitle]) REFERENCES [dbo].[contactpro] ([contactprotitle]) GO ALTER TABLE [dbo].[empdb] CHECK CONSTRAINT [FK_EMPDB_CONTACTPRO] GO ALTER TABLE [dbo].[empdb] WITH CHECK ADD CONSTRAINT [FK_EMPDB_CONTACTTITLE] FOREIGN KEY([contacttitlecode]) REFERENCES [dbo].[contacttitle] ([contacttitlecode]) GO ALTER TABLE [dbo].[empdb] CHECK CONSTRAINT [FK_EMPDB_CONTACTTITLE] GO ALTER TABLE [dbo].[empdb] WITH CHECK ADD CONSTRAINT [FK_EMPDB_CREDITCD] FOREIGN KEY([creditcd]) REFERENCES [dbo].[creditcd] ([creditcd]) GO ALTER TABLE [dbo].[empdb] CHECK CONSTRAINT [FK_EMPDB_CREDITCD] GO ALTER TABLE [dbo].[empdb] WITH CHECK ADD CONSTRAINT [FK_EMPDB_EMPDBINF] FOREIGN KEY([releaseno]) REFERENCES [dbo].[empdbinf] ([RELEASENO]) GO ALTER TABLE [dbo].[empdb] CHECK CONSTRAINT [FK_EMPDB_EMPDBINF] GO ALTER TABLE [dbo].[empdb] WITH CHECK ADD CONSTRAINT [FK_EMPDB_EMPSZFLG] FOREIGN KEY([empsizflg]) REFERENCES [dbo].[empszflg] ([empsizflg]) GO ALTER TABLE [dbo].[empdb] CHECK CONSTRAINT [FK_EMPDB_EMPSZFLG] GO ALTER TABLE [dbo].[empdb] WITH CHECK ADD CONSTRAINT [FK_EMPDB_EMPSZRNG] FOREIGN KEY([empsizrng]) REFERENCES [dbo].[empszrng] ([empsizrng]) GO ALTER TABLE [dbo].[empdb] CHECK CONSTRAINT [FK_EMPDB_EMPSZRNG] GO ALTER TABLE [dbo].[empdb] WITH CHECK ADD CONSTRAINT [FK_EMPDB_GEOCODE] FOREIGN KEY([geopcode]) REFERENCES [dbo].[geocode] ([geopcode]) GO ALTER TABLE [dbo].[empdb] CHECK CONSTRAINT [FK_EMPDB_GEOCODE] GO ALTER TABLE [dbo].[empdb] WITH CHECK ADD CONSTRAINT [FK_EMPDB_GEOG] FOREIGN KEY([stfips], [areatype], [area]) REFERENCES [dbo].[geog] ([stfips], [areatype], [area]) GO ALTER TABLE [dbo].[empdb] CHECK CONSTRAINT [FK_EMPDB_GEOG] GO ALTER TABLE [dbo].[empdb] WITH CHECK ADD CONSTRAINT [FK_EMPDB_LOCSTAT] FOREIGN KEY([locstat]) REFERENCES [dbo].[locstat] ([locstat]) GO ALTER TABLE [dbo].[empdb] CHECK CONSTRAINT [FK_EMPDB_LOCSTAT] GO ALTER TABLE [dbo].[empdb] WITH CHECK ADD CONSTRAINT [FK_EMPDB_PRV VST] FOREIGN KEY([privgovsta]) REFERENCES [dbo].[prvgovst] ([privgovsta]) GO ALTER TABLE [dbo].[empdb] CHECK CONSTRAINT [FK_EMPDB_PRV VST] GO ALTER TABLE [dbo].[empdb] WITH CHECK ADD CONSTRAINT [FK_EMPDB_STOCKEXCH] FOREIGN KEY([stockexchcode]) REFERENCES [dbo].[stockexch] ([stockexchcode]) GO ALTER TABLE [dbo].[empdb] CHECK CONSTRAINT [FK_EMPDB_STOCKEXCH] GO --DEPRECATED --CREATE TABLE [dbo].[eeolabfac]( -- [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, -- [gender] [char](1) NOT NULL, -- [raceethn] [char](5) NOT NULL, -- [lffact] [numeric](9, 8) NULL, -- [empfact] [numeric](9, 8) NULL, -- [unempfact] [numeric](9, 8) NULL, -- CONSTRAINT [PK_EEOLABFAC_2] PRIMARY KEY CLUSTERED --( -- [stfips] ASC, -- [areatype] ASC, -- [area] ASC, -- [periodyear] ASC, -- [periodtype] ASC, -- [period] ASC, -- [gender] 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 --ALTER TABLE [dbo].[eeolabfac] WITH CHECK ADD CONSTRAINT [FK_EEOLABFAC_GENDER] FOREIGN KEY([gender]) --REFERENCES [dbo].[gender] ([gender]) --GO --ALTER TABLE [dbo].[eeolabfac] CHECK CONSTRAINT [FK_EEOLABFAC_GENDER] --GO --ALTER TABLE [dbo].[eeolabfac] WITH CHECK ADD CONSTRAINT [FK_EEOLABFAC_GEOG] FOREIGN KEY([stfips], [areatype], [area]) --REFERENCES [dbo].[geog] ([stfips], [areatype], [area]) --GO --ALTER TABLE [dbo].[eeolabfac] CHECK CONSTRAINT [FK_EEOLABFAC_GEOG] --GO --ALTER TABLE [dbo].[eeolabfac] WITH CHECK ADD CONSTRAINT [FK_EEOLABFAC_PERIOD] FOREIGN KEY([periodyear], [periodtype], [period]) --REFERENCES [dbo].[period] ([periodyear], [periodtype], [period]) --GO --ALTER TABLE [dbo].[eeolabfac] CHECK CONSTRAINT [FK_EEOLABFAC_PERIOD] --GO --ALTER TABLE [dbo].[eeolabfac] WITH CHECK ADD CONSTRAINT [FK_EEOLABFAC_RACEETHN] FOREIGN KEY([raceethn]) --REFERENCES [dbo].[raceethn] ([raceethn]) --GO --ALTER TABLE [dbo].[eeolabfac] CHECK CONSTRAINT [FK_EEOLABFAC_RACEETHN] --GO --DEPRECATED --CREATE TABLE [dbo].[eeolabfor]( -- [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, -- [gender] [char](1) NOT NULL, -- [raceethn] [char](5) NOT NULL, -- [laborforce] [numeric](9, 0) NULL, -- [emplab] [numeric](9, 0) NULL, -- [unemp] [numeric](9, 0) NULL, -- [unemprate] [numeric](5, 1) NULL, -- CONSTRAINT [PK_EEOLABFOR] PRIMARY KEY CLUSTERED --( -- [stfips] ASC, -- [areatype] ASC, -- [area] ASC, -- [periodyear] ASC, -- [periodtype] ASC, -- [period] ASC, -- [gender] 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 --ALTER TABLE [dbo].[eeolabfor] WITH CHECK ADD CONSTRAINT [FK_EEOLABFOR_GENDER] FOREIGN KEY([gender]) --REFERENCES [dbo].[gender] ([gender]) --GO --ALTER TABLE [dbo].[eeolabfor] CHECK CONSTRAINT [FK_EEOLABFOR_GENDER] --GO --ALTER TABLE [dbo].[eeolabfor] WITH CHECK ADD CONSTRAINT [FK_EEOLABFOR_GEOG] FOREIGN KEY([stfips], [areatype], [area]) --REFERENCES [dbo].[geog] ([stfips], [areatype], [area]) --GO --ALTER TABLE [dbo].[eeolabfor] CHECK CONSTRAINT [FK_EEOLABFOR_GEOG] --GO --ALTER TABLE [dbo].[eeolabfor] WITH CHECK ADD CONSTRAINT [FK_EEOLABFOR_PERIOD] FOREIGN KEY([periodyear], [periodtype], [period]) --REFERENCES [dbo].[period] ([periodyear], [periodtype], [period]) --GO --ALTER TABLE [dbo].[eeolabfor] CHECK CONSTRAINT [FK_EEOLABFOR_PERIOD] --GO --ALTER TABLE [dbo].[eeolabfor] WITH CHECK ADD CONSTRAINT [FK_EEOLABFOR_RACEETHN] FOREIGN KEY([raceethn]) --REFERENCES [dbo].[raceethn] ([raceethn]) --GO --ALTER TABLE [dbo].[eeolabfor] CHECK CONSTRAINT [FK_EEOLABFOR_RACEETHN] --GO --DEPRECATED --CREATE TABLE [dbo].[eeoocc]( -- [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, -- [gender] [char](1) NOT NULL, -- [raceethn] [char](5) NOT NULL, -- [occodetype] [char](2) NOT NULL, -- [occcode] [char](10) NOT NULL, -- [explabfor] [numeric](10, 0) NULL, -- CONSTRAINT [PK_EEOOCC] PRIMARY KEY CLUSTERED --( -- [stfips] ASC, -- [areatype] ASC, -- [area] ASC, -- [periodyear] ASC, -- [periodtype] ASC, -- [period] ASC, -- [gender] ASC, -- [raceethn] ASC, -- [occodetype] ASC, -- [occcode] 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 --ALTER TABLE [dbo].[eeoocc] WITH CHECK ADD CONSTRAINT [FK_EEOOCC_GENDER] FOREIGN KEY([gender]) --REFERENCES [dbo].[gender] ([gender]) --GO --ALTER TABLE [dbo].[eeoocc] CHECK CONSTRAINT [FK_EEOOCC_GENDER] --GO --ALTER TABLE [dbo].[eeoocc] WITH CHECK ADD CONSTRAINT [FK_EEOOCC_GEOG] FOREIGN KEY([stfips], [areatype], [area]) --REFERENCES [dbo].[geog] ([stfips], [areatype], [area]) --GO --ALTER TABLE [dbo].[eeoocc] CHECK CONSTRAINT [FK_EEOOCC_GEOG] --GO --ALTER TABLE [dbo].[eeoocc] WITH CHECK ADD CONSTRAINT [FK_EEOOCC_OCCCODES] FOREIGN KEY([stfips], [occodetype], [occcode]) --REFERENCES [dbo].[occcodes] ([stfips], [CODETYPE], [CODE]) --GO --ALTER TABLE [dbo].[eeoocc] CHECK CONSTRAINT [FK_EEOOCC_OCCCODES] --GO --ALTER TABLE [dbo].[eeoocc] WITH CHECK ADD CONSTRAINT [FK_EEOOCC_PERIOD] FOREIGN KEY([periodyear], [periodtype], [period]) --REFERENCES [dbo].[period] ([periodyear], [periodtype], [period]) --GO --ALTER TABLE [dbo].[eeoocc] CHECK CONSTRAINT [FK_EEOOCC_PERIOD] --GO --ALTER TABLE [dbo].[eeoocc] WITH CHECK ADD CONSTRAINT [FK_EEOOCC_RACEETHN] FOREIGN KEY([raceethn]) --REFERENCES [dbo].[raceethn] ([raceethn]) --GO --ALTER TABLE [dbo].[eeoocc] CHECK CONSTRAINT [FK_EEOOCC_RACEETHN] --GO --DEPRECATED --CREATE TABLE [dbo].[eeopop]( -- [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, -- [gender] [char](1) NOT NULL, -- [raceethn] [char](5) NOT NULL, -- [population] [numeric](10, 0) NULL, -- CONSTRAINT [PK_EEOPOP] PRIMARY KEY CLUSTERED --( -- [stfips] ASC, -- [areatype] ASC, -- [area] ASC, -- [periodyear] ASC, -- [periodtype] ASC, -- [period] ASC, -- [gender] 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 --ALTER TABLE [dbo].[eeopop] WITH CHECK ADD CONSTRAINT [FK_EEOPOP_GENDER] FOREIGN KEY([gender]) --REFERENCES [dbo].[gender] ([gender]) --GO --ALTER TABLE [dbo].[eeopop] CHECK CONSTRAINT [FK_EEOPOP_GENDER] --GO --ALTER TABLE [dbo].[eeopop] WITH CHECK ADD CONSTRAINT [FK_EEOPOP_GEOG] FOREIGN KEY([stfips], [areatype], [area]) --REFERENCES [dbo].[geog] ([stfips], [areatype], [area]) --GO --ALTER TABLE [dbo].[eeopop] CHECK CONSTRAINT [FK_EEOPOP_GEOG] --GO --ALTER TABLE [dbo].[eeopop] WITH CHECK ADD CONSTRAINT [FK_EEOPOP_PERIOD] FOREIGN KEY([periodyear], [periodtype], [period]) --REFERENCES [dbo].[period] ([periodyear], [periodtype], [period]) --GO --ALTER TABLE [dbo].[eeopop] CHECK CONSTRAINT [FK_EEOPOP_PERIOD] --GO --ALTER TABLE [dbo].[eeopop] WITH CHECK ADD CONSTRAINT [FK_EEOPOP_RACEETHN] FOREIGN KEY([raceethn]) --REFERENCES [dbo].[raceethn] ([raceethn]) --GO --ALTER TABLE [dbo].[eeopop] CHECK CONSTRAINT [FK_EEOPOP_RACEETHN] --GO --DEPRECATED --CREATE TABLE [dbo].[esapplic1]( -- [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, -- [occodetype] [char](2) NOT NULL, -- [occcode] [char](10) NOT NULL, -- [agegroup] [char](2) NOT NULL, -- [gender] [char](1) NOT NULL, -- [raceethn] [char](5) NOT NULL, -- [highestgrd] [char](2) NOT NULL, -- [esapplicid] [int] NULL, -- [applicants] [numeric](8, 0) NULL, -- CONSTRAINT [PK_esapplic1] PRIMARY KEY CLUSTERED --( -- [stfips] ASC, -- [areatype] ASC, -- [area] ASC, -- [periodyear] ASC, -- [periodtype] ASC, -- [period] ASC, -- [occodetype] ASC, -- [occcode] ASC, -- [agegroup] ASC, -- [gender] ASC, -- [raceethn] ASC, -- [highestgrd] 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 --ALTER TABLE [dbo].[esapplic1] WITH CHECK ADD CONSTRAINT [FK_ESAPPLIC1_AGEGROUP] FOREIGN KEY([stfips], [agegroup]) --REFERENCES [dbo].[agegroup] ([stfips], [agegroup]) --GO --ALTER TABLE [dbo].[esapplic1] CHECK CONSTRAINT [FK_ESAPPLIC1_AGEGROUP] --GO --ALTER TABLE [dbo].[esapplic1] WITH CHECK ADD CONSTRAINT [FK_ESAPPLIC1_GENDER] FOREIGN KEY([gender]) --REFERENCES [dbo].[gender] ([gender]) --GO --ALTER TABLE [dbo].[esapplic1] CHECK CONSTRAINT [FK_ESAPPLIC1_GENDER] --GO --ALTER TABLE [dbo].[esapplic1] WITH CHECK ADD CONSTRAINT [FK_ESAPPLIC1_GEOG] FOREIGN KEY([stfips], [areatype], [area]) --REFERENCES [dbo].[geog] ([stfips], [areatype], [area]) --GO --ALTER TABLE [dbo].[esapplic1] CHECK CONSTRAINT [FK_ESAPPLIC1_GEOG] --GO --ALTER TABLE [dbo].[esapplic1] WITH CHECK ADD CONSTRAINT [FK_ESAPPLIC1_OCCCODES] FOREIGN KEY([stfips], [occodetype], [occcode]) --REFERENCES [dbo].[occcodes] ([stfips], [CODETYPE], [CODE]) --GO --ALTER TABLE [dbo].[esapplic1] CHECK CONSTRAINT [FK_ESAPPLIC1_OCCCODES] --GO --ALTER TABLE [dbo].[esapplic1] WITH CHECK ADD CONSTRAINT [FK_ESAPPLIC1_PERIOD] FOREIGN KEY([periodyear], [periodtype], [period]) --REFERENCES [dbo].[period] ([periodyear], [periodtype], [period]) --GO --ALTER TABLE [dbo].[esapplic1] CHECK CONSTRAINT [FK_ESAPPLIC1_PERIOD] --GO --ALTER TABLE [dbo].[esapplic1] WITH CHECK ADD CONSTRAINT [FK_ESAPPLIC1_RACEETHN] FOREIGN KEY([raceethn]) --REFERENCES [dbo].[raceethn] ([raceethn]) --GO --ALTER TABLE [dbo].[esapplic1] CHECK CONSTRAINT [FK_ESAPPLIC1_RACEETHN] --GO --ALTER TABLE [dbo].[esapplic1] WITH CHECK ADD CONSTRAINT [FK_ESAPPLIC1_SCHGRADE] FOREIGN KEY([stfips], [highestgrd]) --REFERENCES [dbo].[schgrade] ([stfips], [highestgrd]) --GO --ALTER TABLE [dbo].[esapplic1] CHECK CONSTRAINT [FK_ESAPPLIC1_SCHGRADE] --GO --DEPRECATED --CREATE TABLE [dbo].[esapplic2]( -- [stfips] [char](2) NOT NULL, -- [esapplicid] [int] NOT NULL, -- [veteran] [char](1) NOT NULL, -- [disabled] [char](1) NOT NULL, -- [seasonal] [char](1) NOT NULL, -- [econdisadv] [char](1) NOT NULL, -- [dislocated] [char](1) NOT NULL, -- [applicants] [numeric](8, 0) NULL, -- CONSTRAINT [PK_ESAPPLIC2] PRIMARY KEY CLUSTERED --( -- [stfips] ASC, -- [esapplicid] ASC, -- [veteran] ASC, -- [disabled] ASC, -- [seasonal] ASC, -- [econdisadv] ASC, -- [dislocated] 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 --ALTER TABLE [dbo].[esapplic2] WITH CHECK ADD CONSTRAINT [FK_ESAPPLIC2_DISABIL] FOREIGN KEY([disabled]) --REFERENCES [dbo].[disabil] ([disabled]) --GO --ALTER TABLE [dbo].[esapplic2] CHECK CONSTRAINT [FK_ESAPPLIC2_DISABIL] --GO --ALTER TABLE [dbo].[esapplic2] WITH CHECK ADD CONSTRAINT [FK_ESAPPLIC2_DISADVAN] FOREIGN KEY([econdisadv]) --REFERENCES [dbo].[disadvan] ([econdisadv]) --GO --ALTER TABLE [dbo].[esapplic2] CHECK CONSTRAINT [FK_ESAPPLIC2_DISADVAN] --GO --ALTER TABLE [dbo].[esapplic2] WITH CHECK ADD CONSTRAINT [FK_ESAPPLIC2_DISLOCAT] FOREIGN KEY([dislocated]) --REFERENCES [dbo].[dislocat] ([dislocated]) --GO --ALTER TABLE [dbo].[esapplic2] CHECK CONSTRAINT [FK_ESAPPLIC2_DISLOCAT] --GO --ALTER TABLE [dbo].[esapplic2] WITH CHECK ADD CONSTRAINT [FK_ESAPPLIC2_SEASONAL] FOREIGN KEY([seasonal]) --REFERENCES [dbo].[seasonal] ([seasonal]) --GO --ALTER TABLE [dbo].[esapplic2] CHECK CONSTRAINT [FK_ESAPPLIC2_SEASONAL] --GO --ALTER TABLE [dbo].[esapplic2] WITH CHECK ADD CONSTRAINT [FK_ESAPPLIC2_VETCODE] FOREIGN KEY([veteran]) --REFERENCES [dbo].[vetcode] ([veteran]) --GO --ALTER TABLE [dbo].[esapplic2] CHECK CONSTRAINT [FK_ESAPPLIC2_VETCODE] --GO CREATE TABLE [dbo].[esdata]( [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, [occodetype] [char](2) NOT NULL, [occcode] [char](10) NOT NULL, [stattype] [char](2) NOT NULL, [eswage] [numeric](9, 2) NULL, [esorders] [numeric](9, 0) NULL, [esopen] [numeric](8, 0) NULL, [esapps] [numeric](8, 0) NULL, [newapps] [numeric](8, 0) NULL, [referrals] [numeric](8, 0) NULL, [ratetype] [char](1) NOT NULL, CONSTRAINT [PK_ESDATA] PRIMARY KEY CLUSTERED ( [stfips] ASC, [areatype] ASC, [area] ASC, [periodyear] ASC, [periodtype] ASC, [period] ASC, [occodetype] ASC, [occcode] ASC, [stattype] ASC, [ratetype] 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 ALTER TABLE [dbo].[esdata] WITH CHECK ADD CONSTRAINT [FK_ESDATA_GEOG] FOREIGN KEY([stfips], [areatype], [area]) REFERENCES [dbo].[geog] ([stfips], [areatype], [area]) GO ALTER TABLE [dbo].[esdata] CHECK CONSTRAINT [FK_ESDATA_GEOG] GO ALTER TABLE [dbo].[esdata] WITH CHECK ADD CONSTRAINT [FK_ESDATA_OCCCODES] FOREIGN KEY([stfips], [occodetype], [occcode]) REFERENCES [dbo].[occcodes] ([stfips], [CODETYPE], [CODE]) GO ALTER TABLE [dbo].[esdata] CHECK CONSTRAINT [FK_ESDATA_OCCCODES] GO ALTER TABLE [dbo].[esdata] WITH CHECK ADD CONSTRAINT [FK_ESDATA_PERIOD] FOREIGN KEY([periodyear], [periodtype], [period]) REFERENCES [dbo].[period] ([periodyear], [periodtype], [period]) GO ALTER TABLE [dbo].[esdata] CHECK CONSTRAINT [FK_ESDATA_PERIOD] GO ALTER TABLE [dbo].[esdata] WITH CHECK ADD CONSTRAINT [FK_ESDATA_STATTYPE] FOREIGN KEY([stfips], [stattype]) REFERENCES [dbo].[stattype] ([stfips], [stattype]) GO ALTER TABLE [dbo].[esdata] CHECK CONSTRAINT [FK_ESDATA_STATTYPE] GO --CHANGES IN V2.8 CREATE TABLE [dbo].[income]( [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, [inctype] [char](2) NOT NULL, [incsource] [char](1) NOT NULL, [income] [numeric](14, 0) NULL, [incrank] [numeric](3, 0) NULL, [population] [numeric](10, 0) NULL, [releasedate] [char](8) NULL, CONSTRAINT [PK_INCOME] PRIMARY KEY CLUSTERED ( [stfips] ASC, [areatype] ASC, [area] ASC, [periodyear] ASC, [periodtype] ASC, [period] ASC, [inctype] ASC, [incsource] 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 ALTER TABLE [dbo].[income] WITH CHECK ADD CONSTRAINT [FK_INCOME_GEOG] FOREIGN KEY([stfips], [areatype], [area]) REFERENCES [dbo].[geog] ([stfips], [areatype], [area]) GO ALTER TABLE [dbo].[income] CHECK CONSTRAINT [FK_INCOME_GEOG] GO ALTER TABLE [dbo].[income] WITH CHECK ADD CONSTRAINT [FK_INCOME_INCOMTYP] FOREIGN KEY([stfips], [inctype]) REFERENCES [dbo].[incomtyp] ([stfips], [inctype]) GO ALTER TABLE [dbo].[income] CHECK CONSTRAINT [FK_INCOME_INCOMTYP] GO ALTER TABLE [dbo].[income] WITH CHECK ADD CONSTRAINT [FK_INCOME_PERIOD] FOREIGN KEY([periodyear], [periodtype], [period]) REFERENCES [dbo].[period] ([periodyear], [periodtype], [period]) GO ALTER TABLE [dbo].[income] CHECK CONSTRAINT [FK_INCOME_PERIOD] GO ALTER TABLE dbo.income WITH CHECK ADD CONSTRAINT [FK_INCOME_INCSOURC] FOREIGN KEY(stfips, incsource) REFERENCES dbo.incsourc (stfips, incsource) GO ALTER TABLE dbo.income CHECK CONSTRAINT [FK_INCOME_INCSOURC] GO --DEPRECATED --CREATE TABLE [dbo].[indprj]( -- [stfips] [char](2) NOT NULL, -- [areatype] [char](2) NOT NULL, -- [area] [char](6) NOT NULL, -- [periodid] [char](2) NOT NULL, -- [matincode] [char](15) NOT NULL, -- [estindprj] [numeric](9, 0) NULL, -- [projindprj] [numeric](9, 0) NULL, -- [grrate] [numeric](7, 4) NULL, -- [nchg] [numeric](9, 0) NULL, -- [pchg] [numeric](7, 4) NULL, -- [growcode] [char](2) NULL, -- [suppress] [char](1) NULL, -- CONSTRAINT [PK_INDSUB] PRIMARY KEY CLUSTERED --( -- [stfips] ASC, -- [areatype] ASC, -- [area] ASC, -- [periodid] ASC, -- [matincode] 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 --ALTER TABLE [dbo].[indprj] WITH CHECK ADD CONSTRAINT [FK_indprj_GEOG] FOREIGN KEY([stfips], [areatype], [area]) --REFERENCES [dbo].[geog] ([stfips], [areatype], [area]) --GO --ALTER TABLE [dbo].[indprj] CHECK CONSTRAINT [FK_indprj_GEOG] --GO --ALTER TABLE [dbo].[indprj] WITH CHECK ADD CONSTRAINT [FK_indprj_growcode] FOREIGN KEY([stfips], [growcode]) --REFERENCES [dbo].[growcode] ([stfips], [growcode]) --GO --ALTER TABLE [dbo].[indprj] CHECK CONSTRAINT [FK_indprj_growcode] --GO --ALTER TABLE [dbo].[indprj] WITH CHECK ADD CONSTRAINT [FK_indprj_inddir] FOREIGN KEY([stfips], [matincode], [periodid]) --REFERENCES [dbo].[inddir] ([stfips], [matincode], [periodid]) --GO --ALTER TABLE [dbo].[indprj] CHECK CONSTRAINT [FK_indprj_inddir] --GO CREATE TABLE [dbo].[indsum]( [stfips] [char](2) NOT NULL, [areatype] [char](2) NOT NULL, [area] [char](6) NOT NULL, [indcodetyp] [char](2) NOT NULL, [indcode] [char](6) NOT NULL, [indsource] [char](1) NOT NULL, [employers] [numeric](5, 0) NULL, CONSTRAINT [PK_INDSUM] PRIMARY KEY CLUSTERED ( [stfips] ASC, [areatype] ASC, [area] ASC, [indcodetyp] ASC, [indcode] ASC, [indsource] 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 ALTER TABLE [dbo].[indsum] WITH CHECK ADD CONSTRAINT [FK_INDSUM_GEOG] FOREIGN KEY([stfips], [areatype], [area]) REFERENCES [dbo].[geog] ([stfips], [areatype], [area]) GO ALTER TABLE [dbo].[indsum] CHECK CONSTRAINT [FK_INDSUM_GEOG] GO ALTER TABLE [dbo].[indsum] WITH CHECK ADD CONSTRAINT [FK_INDSUM_INDCODES] FOREIGN KEY([stfips], [indcodetyp], [indcode]) REFERENCES [dbo].[indcodes] ([stfips], [codetype], [code]) GO ALTER TABLE [dbo].[indsum] CHECK CONSTRAINT [FK_INDSUM_INDCODES] GO --CORE CREATE TABLE [dbo].[industry]( [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, [indcodty] [char](2) NOT NULL, [indcode] [char](6) NOT NULL, [ownership] [char](2) NOT NULL, [prelim] [char](1) NULL, [firms] [numeric](8, 0) NULL, [estab] [numeric](8, 0) NULL, [avgemp] [numeric](9, 0) NULL, [mnth1emp] [numeric](9, 0) NULL, [mnth2emp] [numeric](9, 0) NULL, [mnth3emp] [numeric](9, 0) NULL, [topempav] [numeric](9, 0) NULL, [totwage] [numeric](14, 0) NULL, [avgwkwage] [numeric](8, 0) NULL, [taxwage] [numeric](14, 0) NULL, [contrib] [numeric](12, 0) NULL, [suppress] [char](1) NULL, CONSTRAINT [PK_INDUSTRY] PRIMARY KEY CLUSTERED ( [stfips] ASC, [areatype] ASC, [area] ASC, [periodyear] ASC, [periodtype] ASC, [period] ASC, [indcodty] ASC, [indcode] ASC, [ownership] 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 ALTER TABLE [dbo].[industry] WITH CHECK ADD CONSTRAINT [FK_INDUSTRY_GEOG] FOREIGN KEY([stfips], [areatype], [area]) REFERENCES [dbo].[geog] ([stfips], [areatype], [area]) GO ALTER TABLE [dbo].[industry] CHECK CONSTRAINT [FK_INDUSTRY_GEOG] GO ALTER TABLE [dbo].[industry] WITH CHECK ADD CONSTRAINT [FK_INDUSTRY_INDCODES] FOREIGN KEY([stfips], [indcodty], [indcode]) REFERENCES [dbo].[indcodes] ([stfips], [codetype], [code]) GO ALTER TABLE [dbo].[industry] CHECK CONSTRAINT [FK_INDUSTRY_INDCODES] GO ALTER TABLE [dbo].[industry] WITH CHECK ADD CONSTRAINT [FK_INDUSTRY_OWNERSHP] FOREIGN KEY([stfips], [ownership]) REFERENCES [dbo].[ownershp] ([stfips], [ownership]) GO ALTER TABLE [dbo].[industry] CHECK CONSTRAINT [FK_INDUSTRY_OWNERSHP] GO ALTER TABLE [dbo].[industry] WITH CHECK ADD CONSTRAINT [FK_INDUSTRY_PERIOD] FOREIGN KEY([periodyear], [periodtype], [period]) REFERENCES [dbo].[period] ([periodyear], [periodtype], [period]) GO ALTER TABLE [dbo].[industry] CHECK CONSTRAINT [FK_INDUSTRY_PERIOD] GO --CORE CREATE TABLE [dbo].[iomatrix]( [stfips] [char](2) NOT NULL, [areatype] [char](2) NOT NULL, [area] [char](6) NOT NULL, [periodid] [char](2) NOT NULL, [matincode] [char](15) NOT NULL, [matoccode] [char](10) NOT NULL, [estemp] [numeric](9, 0) NULL, [projemp] [numeric](9, 0) NULL, [pctestind] [numeric](6, 2) NULL, [pctestocc] [numeric](6, 2) NULL, [pctprojind] [numeric](6, 2) NULL, [pctprojocc] [numeric](6, 2) NULL, [nchg] [numeric](9, 0) NULL, [pchg] [numeric](7, 4) NULL, [growrate] [numeric](7, 4) NULL, [growcode] [char](2) NULL, [aopeng] [numeric](9, 0) NULL, [aopenr] [numeric](9, 0) NULL, [aopent] [numeric](9, 0) NULL, [exits] [numeric](9, 0) NULL, [annualexits] [numeric](9, 0) NULL, [transfers] [numeric](9, 0) NULL, [annualtransfers] [numeric](9, 0) NULL, [change] [numeric](9, 0) NULL, [annualchange] [numeric](9, 0) NULL, [openings] [numeric](9, 0) NULL, [annualopenings] [numeric](9, 0) NULL, [suppress] [char](1) NULL, CONSTRAINT [PK_IOMATRIX] PRIMARY KEY CLUSTERED ( [stfips] ASC, [areatype] ASC, [area] ASC, [periodid] ASC, [matincode] ASC, [matoccode] 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 ALTER TABLE [dbo].[iomatrix] WITH CHECK ADD CONSTRAINT [FK_IOMATRIX_GEOG] FOREIGN KEY([stfips], [areatype], [area]) REFERENCES [dbo].[geog] ([stfips], [areatype], [area]) GO ALTER TABLE [dbo].[iomatrix] CHECK CONSTRAINT [FK_IOMATRIX_GEOG] GO ALTER TABLE [dbo].[iomatrix] WITH CHECK ADD CONSTRAINT [FK_IOMATRIX_GROWCODE] FOREIGN KEY([stfips], [growcode]) REFERENCES [dbo].[growcode] ([stfips], [growcode]) GO ALTER TABLE [dbo].[iomatrix] CHECK CONSTRAINT [FK_IOMATRIX_GROWCODE] GO ALTER TABLE [dbo].[iomatrix] WITH CHECK ADD CONSTRAINT [FK_IOMATRIX_INDDIR] FOREIGN KEY([stfips], [matincode], [periodid]) REFERENCES [dbo].[inddir] ([stfips], [matincode], [periodid]) GO ALTER TABLE [dbo].[iomatrix] CHECK CONSTRAINT [FK_IOMATRIX_INDDIR] GO ALTER TABLE [dbo].[iomatrix] WITH CHECK ADD CONSTRAINT [FK_IOMATRIX_OCCDIR] FOREIGN KEY([stfips], [matoccode], [periodid]) REFERENCES [dbo].[occdir] ([stfips], [matoccode], [periodid]) GO ALTER TABLE [dbo].[iomatrix] CHECK CONSTRAINT [FK_IOMATRIX_OCCDIR] GO --CORE CREATE TABLE [dbo].[labforce]( [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, [adjusted] [char](1) NOT NULL, [prelim] [char](1) NOT NULL, [benchmark] [char](4) NULL, [laborforce] [numeric](9, 0) NULL, [emplab] [numeric](9, 0) NULL, [unemp] [numeric](9, 0) NULL, [unemprate] [numeric](5, 1) NULL, [clfprate] [numeric](5, 1) NULL, [emppopratio] [numeric](5, 1) NULL, CONSTRAINT [PK_LABFORCE] PRIMARY KEY CLUSTERED ( [stfips] ASC, [areatype] ASC, [area] ASC, [periodyear] ASC, [periodtype] ASC, [period] ASC, [adjusted] ASC, [prelim] 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 ALTER TABLE [dbo].[labforce] WITH CHECK ADD CONSTRAINT [FK_LABFORCE_BENMARK] FOREIGN KEY([benchmark]) REFERENCES [dbo].[benmark] ([benchmark]) GO ALTER TABLE [dbo].[labforce] CHECK CONSTRAINT [FK_LABFORCE_BENMARK] GO ALTER TABLE [dbo].[labforce] WITH CHECK ADD CONSTRAINT [FK_LABFORCE_GEOG] FOREIGN KEY([stfips], [areatype], [area]) REFERENCES [dbo].[geog] ([stfips], [areatype], [area]) GO ALTER TABLE [dbo].[labforce] CHECK CONSTRAINT [FK_LABFORCE_GEOG] GO ALTER TABLE [dbo].[labforce] WITH CHECK ADD CONSTRAINT [FK_LABFORCE_PERIOD] FOREIGN KEY([periodyear], [periodtype], [period]) REFERENCES [dbo].[period] ([periodyear], [periodtype], [period]) GO ALTER TABLE [dbo].[labforce] CHECK CONSTRAINT [FK_LABFORCE_PERIOD] GO CREATE TABLE [dbo].[jvs]( [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, [OWNERSHIP] [char](2) NOT NULL, [INDCODTY] [char](2) NOT NULL, [INDCODE] [char](6) NOT NULL, [OCCODETYPE] [char](2) NOT NULL, [OCCCODE] [char](10) NOT NULL, [SIZECLASS] [char](2) NOT NULL, [JVSCELLID] [int] NULL, [VACANCIES] [numeric](7, 0) NULL, [VACANRATE] [numeric](3, 1) NULL, [MEDIANWAGE] [numeric](9, 2) NULL, [MEANWAGE] [numeric](9, 2) NULL, [MINWAGE] [numeric](9, 2) NULL, [MAXWAGE] [numeric](9, 2) NULL, [SUPPRESS] [char](1) NULL, CONSTRAINT [PK_JVS] PRIMARY KEY CLUSTERED ( [STFIPS] ASC, [AREATYPE] ASC, [AREA] ASC, [PERIODYEAR] ASC, [PERIODTYPE] ASC, [PERIOD] ASC, [INDCODTY] ASC, [INDCODE] ASC, [OCCODETYPE] ASC, [OCCCODE] ASC, [SIZECLASS] 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 ALTER TABLE [dbo].[jvs] WITH CHECK ADD CONSTRAINT [FK_JVS_GEOG] FOREIGN KEY([STFIPS], [AREATYPE], [AREA]) REFERENCES [dbo].[geog] ([stfips], [areatype], [area]) GO ALTER TABLE [dbo].[jvs] CHECK CONSTRAINT [FK_JVS_GEOG] GO ALTER TABLE [dbo].[jvs] WITH CHECK ADD CONSTRAINT [FK_JVS_INDCODES] FOREIGN KEY([STFIPS], [INDCODTY], [INDCODE]) REFERENCES [dbo].[indcodes] ([stfips], [codetype], [code]) GO ALTER TABLE [dbo].[jvs] CHECK CONSTRAINT [FK_JVS_INDCODES] GO ALTER TABLE [dbo].[jvs] WITH CHECK ADD CONSTRAINT [FK_JVS_OCCCODES] FOREIGN KEY([STFIPS], [OCCODETYPE], [OCCCODE]) REFERENCES [dbo].[occcodes] ([stfips], [CODETYPE], [CODE]) GO ALTER TABLE [dbo].[jvs] CHECK CONSTRAINT [FK_JVS_OCCCODES] GO ALTER TABLE [dbo].[jvs] WITH CHECK ADD CONSTRAINT [FK_JVS_OWNERSHP] FOREIGN KEY([STFIPS], [OWNERSHIP]) REFERENCES [dbo].[ownershp] ([stfips], [ownership]) GO ALTER TABLE [dbo].[jvs] CHECK CONSTRAINT [FK_JVS_OWNERSHP] GO ALTER TABLE [dbo].[jvs] WITH CHECK ADD CONSTRAINT [FK_JVS_PERIOD] FOREIGN KEY([PERIODYEAR], [PERIODTYPE], [PERIOD]) REFERENCES [dbo].[period] ([periodyear], [periodtype], [period]) GO ALTER TABLE [dbo].[jvs] CHECK CONSTRAINT [FK_JVS_PERIOD] GO ALTER TABLE [dbo].[jvs] WITH CHECK ADD CONSTRAINT [FK_JVS_SIZECLAS] FOREIGN KEY([STFIPS], [SIZECLASS]) REFERENCES [dbo].[sizeclas] ([stfips], [sizeclass]) GO ALTER TABLE [dbo].[jvs] CHECK CONSTRAINT [FK_JVS_SIZECLAS] GO CREATE TABLE [dbo].[jvsaddit]( [STFIPS] [char](2) NOT NULL, [JVSCELLID] [int] NOT NULL, [PARTFULL] [char](1) NOT NULL, [PERMSEAS] [char](1) NOT NULL, [LENGTHOPEN] [char](1) NOT NULL, [EDULEVEL] [char](1) NOT NULL, [EXPLEVEL] [char](1) NOT NULL, [CERTREQ] [char](1) NOT NULL, [BENEFIT] [char](1) NOT NULL, [PERCENTOPN] [numeric](3, 0) NULL, [SUPPRESS] [char](1) NULL, CONSTRAINT [PK_JVSADDIT] PRIMARY KEY CLUSTERED ( [STFIPS] ASC, [JVSCELLID] ASC, [PARTFULL] ASC, [PERMSEAS] ASC, [LENGTHOPEN] ASC, [EDULEVEL] ASC, [EXPLEVEL] ASC, [CERTREQ] ASC, [BENEFIT] 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 ALTER TABLE [dbo].[jvsaddit] WITH CHECK ADD CONSTRAINT [FK_JVSADDIT_BENEFIT] FOREIGN KEY([STFIPS], [BENEFIT]) REFERENCES [dbo].[benefit] ([stfips], [benefit]) GO ALTER TABLE [dbo].[jvsaddit] CHECK CONSTRAINT [FK_JVSADDIT_BENEFIT] GO ALTER TABLE [dbo].[jvsaddit] WITH CHECK ADD CONSTRAINT [FK_JVSADDIT_EDULEVEL] FOREIGN KEY([STFIPS], [EDULEVEL]) REFERENCES [dbo].[edulevel] ([stfips], [edulevel]) GO ALTER TABLE [dbo].[jvsaddit] CHECK CONSTRAINT [FK_JVSADDIT_EDULEVEL] GO ALTER TABLE [dbo].[jvsaddit] WITH CHECK ADD CONSTRAINT [FK_JVSADDIT_EXPLEVEL] FOREIGN KEY([STFIPS], [EXPLEVEL]) REFERENCES [dbo].[explevel] ([stfips], [explevel]) GO ALTER TABLE [dbo].[jvsaddit] CHECK CONSTRAINT [FK_JVSADDIT_EXPLEVEL] GO ALTER TABLE [dbo].[jvsaddit] WITH CHECK ADD CONSTRAINT [FK_JVSADDIT_LENGTHOPEN] FOREIGN KEY([STFIPS], [LENGTHOPEN]) REFERENCES [dbo].[lengthopen] ([stfips], [lengthopen]) GO ALTER TABLE [dbo].[jvsaddit] CHECK CONSTRAINT [FK_JVSADDIT_LENGTHOPEN] GO --CORE---NEW TABLES V2.8 CREATE TABLE [dbo].[licensetypes]( [licensetype] [char](1) NOT NULL, [licensetypedesc] [varchar](50) NULL, CONSTRAINT [PK_LICENSETYPES] PRIMARY KEY CLUSTERED ( [licensetype] 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].[licenseexams]( [licenseexam] [char](1) NOT NULL, [examdesc] [varchar](50) NULL, CONSTRAINT [PK_LICENSEEXAMS] PRIMARY KEY CLUSTERED ( [licenseexam] 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].[licenseeducation]( [licenseeducation] [char](1) NOT NULL, [educationdesc] [varchar](25) NULL, CONSTRAINT [PK_LICENSEEDUCATION] PRIMARY KEY CLUSTERED ( [licenseeducation] 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].[liccontinuingedu]( [licensecontinuingedu] [char](1) NOT NULL, [continuingedudesc] [varchar](50) NULL, CONSTRAINT [PK_LICCONTINUINGEDU] PRIMARY KEY CLUSTERED ( [licensecontinuingedu] 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].[licensecertification]( [licensecertification] [char](1) NOT NULL, [licensecertdesc] [varchar](60) NULL, CONSTRAINT [PK_LICENSECERTIFICATION] PRIMARY KEY CLUSTERED ( [licensecertification] 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].[licenseexperience]( [licenseexperience] [char](1) NOT NULL, [experiencedesc] [varchar](30) NULL, CONSTRAINT [PK_LICENSEEXPERIENCE] PRIMARY KEY CLUSTERED ( [licenseexperience] 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].[licensecriminal]( [licensecriminal] [char](1) NOT NULL, [licensecriminaldesc] [varchar](50) NULL, CONSTRAINT [PK_LICENSECRIMINAL] PRIMARY KEY CLUSTERED ( [licensecriminal] 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].[licensephysicalreqs]( [licensephysical] [char](1) NOT NULL, [physicaldesc] [varchar](50) NULL, CONSTRAINT [PK_LICENSEPHYSICALREQS] PRIMARY KEY CLUSTERED ( [licensephysical] 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].[licenseactivestatus]( [licensestatus] [char](1) NOT NULL, [licensestatusdesc] [varchar](25) NULL, CONSTRAINT [PK_LICENSEACTIVESTATUS] PRIMARY KEY CLUSTERED ( [licensestatus] 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].[licenseveteran]( [licveteran] [char](1) NOT NULL, [licveterandesc] [varchar](75) NULL, CONSTRAINT [PK_LICENSEVETERAN] PRIMARY KEY CLUSTERED ( [licveteran] 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 --CORE---CHANGES IN V2.8 CREATE TABLE [dbo].[licauth]( [stfips] [char](2) NOT NULL, [areatype] [char](2) NOT NULL, [area] [char](6) NOT NULL, [licauthid] [char](3) NOT NULL, [department] [varchar](255) NULL, [division] [varchar](255) NULL, [board] [varchar](255) NULL, [address1] [varchar](75) NULL, [address2] [varchar](75) NULL, [city] [varchar](30) NULL, [st] [char](2) NULL, [zip] [char](5) NULL, [zipext] [char](4) NULL, [latitude] [numeric](11, 6) NULL, [longitude] [numeric](11, 6) NULL, [geopcode] [char](1) NULL, [telephone] [varchar](10) NULL, [teleext] [varchar](10) NULL, [fax] [varchar](10) NULL, [contact] [varchar](50) NULL, [email] [varchar](70) NULL, [url] [varchar](200) NULL, CONSTRAINT [PK_LICAUTH] PRIMARY KEY CLUSTERED ( [stfips] ASC, [areatype] ASC, [area] ASC, [licauthid] 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 ALTER TABLE [dbo].[licauth] WITH CHECK ADD CONSTRAINT [FK_LICAUTH_GEOCODE] FOREIGN KEY([geopcode]) REFERENCES [dbo].[geocode] ([geopcode]) GO ALTER TABLE [dbo].[licauth] CHECK CONSTRAINT [FK_LICAUTH_GEOCODE] GO ALTER TABLE [dbo].[licauth] WITH CHECK ADD CONSTRAINT [FK_LICAUTH_GEOG] FOREIGN KEY([stfips], [areatype], [area]) REFERENCES [dbo].[geog] ([stfips], [areatype], [area]) GO ALTER TABLE [dbo].[licauth] CHECK CONSTRAINT [FK_LICAUTH_GEOG] GO --CORE---CHANGES IN V2.8 CREATE TABLE [dbo].[license]( [stfips] [char](2) NOT NULL, [areatype] [char](2) NULL, [area] [char](6) NULL, [licenseid] [varchar](10) NOT NULL, [licauthid] [char](3) NULL, [lictitle] [varchar](200) NULL, [licdesc] [varchar](max) NULL, [licensetype] char(1) null, [exam] char(1) null, [education] char(1) null, [continuingedu] char(1) null, [certification] char(1) null, [experience] char(1) null, [criminal] char(1) null, [physical] char(1) null, [veteran] char(1) null, [inactive] char(1) null, [licenseurl] [varchar](200) NULL, [licenseupdated] char(8) null, CONSTRAINT [PK_LICENSE] PRIMARY KEY CLUSTERED ( [stfips] ASC, [licenseid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO ALTER TABLE [dbo].[license] WITH CHECK ADD CONSTRAINT [FK_LICENSE_LICAUTH] FOREIGN KEY([stfips], [areatype], [area], [licauthid]) REFERENCES [dbo].[licauth] ([stfips], [areatype], [area], [licauthid]) GO ALTER TABLE [dbo].[license] CHECK CONSTRAINT [FK_LICENSE_LICAUTH] GO ALTER TABLE [dbo].[license] WITH CHECK ADD CONSTRAINT [FK_LICENSE_licensetype] FOREIGN KEY([licensetype]) REFERENCES [dbo].[licensetypes] ([licensetype]) GO ALTER TABLE [dbo].[license] CHECK CONSTRAINT [FK_LICENSE_licensetype] GO ALTER TABLE [dbo].[license] WITH CHECK ADD CONSTRAINT [FK_LICENSE_LICENSEEXAMS] FOREIGN KEY([exam]) REFERENCES [dbo].[licenseexams] ([licenseexam]) GO ALTER TABLE [dbo].[license] CHECK CONSTRAINT [FK_LICENSE_LICENSEEXAMS] GO ALTER TABLE [dbo].[license] WITH CHECK ADD CONSTRAINT [FK_LICENSE_LICENSEEDUCATION] FOREIGN KEY([education]) REFERENCES [dbo].[licenseeducation] ([licenseeducation]) GO ALTER TABLE [dbo].[license] CHECK CONSTRAINT [FK_LICENSE_LICENSEEDUCATION] GO ALTER TABLE [dbo].[license] WITH CHECK ADD CONSTRAINT [FK_LICENSE_LICCONTINUINGEDU] FOREIGN KEY([continuingedu]) REFERENCES [dbo].[liccontinuingedu] ([licensecontinuingedu]) GO ALTER TABLE [dbo].[license] CHECK CONSTRAINT [FK_LICENSE_LICCONTINUINGEDU] GO ALTER TABLE [dbo].[license] WITH CHECK ADD CONSTRAINT [FK_LICENSE_CERTIFICATION] FOREIGN KEY([certification]) REFERENCES [dbo].[licensecertification] ([licensecertification]) GO ALTER TABLE [dbo].[license] CHECK CONSTRAINT [FK_LICENSE_CERTIFICATION] GO ALTER TABLE [dbo].[license] WITH CHECK ADD CONSTRAINT [FK_LICENSE_EXPERIENCE] FOREIGN KEY([experience]) REFERENCES [dbo].[licenseexperience] ([licenseexperience]) GO ALTER TABLE [dbo].[license] CHECK CONSTRAINT [FK_LICENSE_EXPERIENCE] GO ALTER TABLE [dbo].[license] WITH CHECK ADD CONSTRAINT [FK_LICENSE_CRIMINAL] FOREIGN KEY([criminal]) REFERENCES [dbo].[licensecriminal] ([licensecriminal]) GO ALTER TABLE [dbo].[license] CHECK CONSTRAINT [FK_LICENSE_CRIMINAL] GO ALTER TABLE [dbo].[license] WITH CHECK ADD CONSTRAINT [FK_LICENSE_PHYSICAL] FOREIGN KEY([physical]) REFERENCES [dbo].[licensephysicalreqs] ([licensephysical]) GO ALTER TABLE [dbo].[license] CHECK CONSTRAINT [FK_LICENSE_PHYSICAL] GO ALTER TABLE [dbo].[license] WITH CHECK ADD CONSTRAINT [FK_LICENSE_VETERAN] FOREIGN KEY([veteran]) REFERENCES [dbo].[licenseveteran] ([licveteran]) GO ALTER TABLE [dbo].[license] CHECK CONSTRAINT [FK_LICENSE_VETERAN] GO ALTER TABLE [dbo].[license] WITH CHECK ADD CONSTRAINT [FK_LICENSE_INACTIVE] FOREIGN KEY([inactive]) REFERENCES [dbo].[licenseactivestatus] ([licensestatus]) GO ALTER TABLE [dbo].[license] CHECK CONSTRAINT [FK_LICENSE_INACTIVE] GO CREATE TABLE [dbo].[lichist]( [stfips] [char](2) NOT NULL, [areatype] [char](2) NULL, [area] [char](6) NULL, [periodyear] [char](4) NOT NULL, [periodtype] [char](2) NOT NULL, [period] [char](2) NOT NULL, [licenseid] [varchar](10) NOT NULL, [licnumtype] [char](2) NOT NULL, [licnum] [numeric](9, 0) NULL, CONSTRAINT [PK_LICHIST] PRIMARY KEY CLUSTERED ( [stfips] ASC, [periodyear] ASC, [periodtype] ASC, [period] ASC, [licenseid] ASC, [licnumtype] 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 ALTER TABLE [dbo].[lichist] WITH CHECK ADD CONSTRAINT [FK_LICHIST_GEOG] FOREIGN KEY([stfips], [areatype], [area]) REFERENCES [dbo].[geog] ([stfips], [areatype], [area]) GO ALTER TABLE [dbo].[lichist] CHECK CONSTRAINT [FK_LICHIST_GEOG] GO ALTER TABLE [dbo].[lichist] WITH CHECK ADD CONSTRAINT [FK_LICHIST_LICENSE] FOREIGN KEY([stfips], [licenseid]) REFERENCES [dbo].[license] ([stfips], [licenseid]) GO ALTER TABLE [dbo].[lichist] CHECK CONSTRAINT [FK_LICHIST_LICENSE] GO ALTER TABLE [dbo].[lichist] WITH CHECK ADD CONSTRAINT [FK_LICHIST_LICNUMTY] FOREIGN KEY([licnumtype]) REFERENCES [dbo].[licnumty] ([licnumtype]) GO ALTER TABLE [dbo].[lichist] CHECK CONSTRAINT [FK_LICHIST_LICNUMTY] GO ALTER TABLE [dbo].[lichist] WITH CHECK ADD CONSTRAINT [FK_LICHIST_PERIOD] FOREIGN KEY([periodyear], [periodtype], [period]) REFERENCES [dbo].[period] ([periodyear], [periodtype], [period]) GO ALTER TABLE [dbo].[lichist] CHECK CONSTRAINT [FK_LICHIST_PERIOD] GO --DEPRECATED --CREATE TABLE [dbo].[mls]( -- [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, -- [indcodty] [char](2) NOT NULL, -- [indcode] [char](6) NOT NULL, -- [ownership] [char](2) NOT NULL, -- [gender] [char](1) NOT NULL, -- [raceethn] [char](5) NOT NULL, -- [agegroup] [char](2) NOT NULL, -- [veteran] [char](1) NOT NULL, -- [worksite] [char](1) NOT NULL, -- [prisepcodetype] [char](2) NOT NULL, -- [prisepcd] [char](2) NOT NULL, -- [separat] [numeric](6, 0) NULL, -- [claimants] [numeric](6, 0) NULL, -- [events] [numeric](4, 0) NULL, -- [suppress] [char](1) NULL, -- CONSTRAINT [PK_MLS] PRIMARY KEY CLUSTERED --( -- [stfips] ASC, -- [areatype] ASC, -- [area] ASC, -- [periodyear] ASC, -- [periodtype] ASC, -- [period] ASC, -- [indcodty] ASC, -- [indcode] ASC, -- [ownership] ASC, -- [gender] ASC, -- [raceethn] ASC, -- [agegroup] ASC, -- [veteran] ASC, -- [worksite] ASC, -- [prisepcodetype] ASC, -- [prisepcd] 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 --ALTER TABLE [dbo].[mls] WITH CHECK ADD CONSTRAINT [FK_MLS_AGEGROUP] FOREIGN KEY([stfips], [agegroup]) --REFERENCES [dbo].[agegroup] ([stfips], [agegroup]) --GO --ALTER TABLE [dbo].[mls] CHECK CONSTRAINT [FK_MLS_AGEGROUP] --GO --ALTER TABLE [dbo].[mls] WITH CHECK ADD CONSTRAINT [FK_MLS_GENDER] FOREIGN KEY([gender]) --REFERENCES [dbo].[gender] ([gender]) --GO --ALTER TABLE [dbo].[mls] CHECK CONSTRAINT [FK_MLS_GENDER] --GO --ALTER TABLE [dbo].[mls] WITH CHECK ADD CONSTRAINT [FK_MLS_GEOG] FOREIGN KEY([stfips], [areatype], [area]) --REFERENCES [dbo].[geog] ([stfips], [areatype], [area]) --GO --ALTER TABLE [dbo].[mls] CHECK CONSTRAINT [FK_MLS_GEOG] --GO --ALTER TABLE [dbo].[mls] WITH CHECK ADD CONSTRAINT [FK_MLS_INDCODES] FOREIGN KEY([stfips], [indcodty], [indcode]) --REFERENCES [dbo].[indcodes] ([stfips], [codetype], [code]) --GO --ALTER TABLE [dbo].[mls] CHECK CONSTRAINT [FK_MLS_INDCODES] --GO --ALTER TABLE [dbo].[mls] WITH CHECK ADD CONSTRAINT [FK_MLS_MLSSEPCD] FOREIGN KEY([prisepcodetype], [prisepcd]) --REFERENCES [dbo].[mlssepcd] ([mlssepcodetype], [mlssepcd]) --GO --ALTER TABLE [dbo].[mls] CHECK CONSTRAINT [FK_MLS_MLSSEPCD] --GO --ALTER TABLE [dbo].[mls] WITH CHECK ADD CONSTRAINT [FK_MLS_OWNERSHP] FOREIGN KEY([stfips], [ownership]) --REFERENCES [dbo].[ownershp] ([stfips], [ownership]) --GO --ALTER TABLE [dbo].[mls] CHECK CONSTRAINT [FK_MLS_OWNERSHP] --GO --ALTER TABLE [dbo].[mls] WITH CHECK ADD CONSTRAINT [FK_MLS_PERIOD] FOREIGN KEY([periodyear], [periodtype], [period]) --REFERENCES [dbo].[period] ([periodyear], [periodtype], [period]) --GO --ALTER TABLE [dbo].[mls] CHECK CONSTRAINT [FK_MLS_PERIOD] --GO --ALTER TABLE [dbo].[mls] WITH CHECK ADD CONSTRAINT [FK_MLS_RACEETHN] FOREIGN KEY([raceethn]) --REFERENCES [dbo].[raceethn] ([raceethn]) --GO --ALTER TABLE [dbo].[mls] CHECK CONSTRAINT [FK_MLS_RACEETHN] --GO --ALTER TABLE [dbo].[mls] WITH CHECK ADD CONSTRAINT [FK_MLS_VETCODE] FOREIGN KEY([veteran]) --REFERENCES [dbo].[vetcode] ([veteran]) --GO --ALTER TABLE [dbo].[mls] CHECK CONSTRAINT [FK_MLS_VETCODE] --GO --ALTER TABLE [dbo].[mls] WITH CHECK ADD CONSTRAINT [FK_MLS_WORKSITE] FOREIGN KEY([worksite]) --REFERENCES [dbo].[worksite] ([worksite]) --GO --ALTER TABLE [dbo].[mls] CHECK CONSTRAINT [FK_MLS_WORKSITE] --GO --DEPRECATED --CREATE TABLE [dbo].[mlsevent]( -- [stfips] [char](2) NOT NULL, -- [areatype] [char](2) NULL, -- [area] [char](6) NULL, -- [periodyear] [char](4) NULL, -- [periodtype] [char](2) NULL, -- [period] [char](2) NULL, -- [uiaccount] [char](10) NOT NULL, -- [eventid] [char](3) NOT NULL, -- [siccode] [char](4) NULL, -- [naicscode] [char](6) NULL, -- [ownership] [char](2) NULL, -- [name1] [varchar](35) NULL, -- [name2] [varchar](35) NULL, -- [address1] [varchar](35) NULL, -- [city] [varchar](30) NULL, -- [st] [char](2) NULL, -- [zip] [char](9) NULL, -- [meeicode] [char](1) NULL, -- [telephone] [char](10) NULL, -- [teleext] [varchar](6) NULL, -- [worksite] [char](1) NULL, -- [preemp] [numeric](6, 0) NULL, -- [separat] [numeric](6, 0) NULL, -- [prisepcodetype] [char](7) NULL, -- [prisepcd] [char](2) NULL, -- [secsepcodetype] [char](8) NULL, -- [secsepcd] [char](2) NULL, -- [layweek] [datetime] NULL, -- [eventtype] [char](1) NULL, -- [dwvertype] [char](1) NULL, -- CONSTRAINT [PK_MLSEVENT] PRIMARY KEY CLUSTERED --( -- [stfips] ASC, -- [uiaccount] ASC, -- [eventid] 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 --ALTER TABLE [dbo].[mlsevent] WITH CHECK ADD CONSTRAINT [FK_MLSEVENT_DWVERTYP] FOREIGN KEY([dwvertype]) --REFERENCES [dbo].[dwvertyp] ([dwvertype]) --GO --ALTER TABLE [dbo].[mlsevent] CHECK CONSTRAINT [FK_MLSEVENT_DWVERTYP] --GO --ALTER TABLE [dbo].[mlsevent] WITH CHECK ADD CONSTRAINT [FK_MLSEVENT_EVENTTYP] FOREIGN KEY([eventtype]) --REFERENCES [dbo].[eventtyp] ([eventtype]) --GO --ALTER TABLE [dbo].[mlsevent] CHECK CONSTRAINT [FK_MLSEVENT_EVENTTYP] --GO --ALTER TABLE [dbo].[mlsevent] WITH CHECK ADD CONSTRAINT [FK_MLSEVENT_GEOG] FOREIGN KEY([stfips], [areatype], [area]) --REFERENCES [dbo].[geog] ([stfips], [areatype], [area]) --GO --ALTER TABLE [dbo].[mlsevent] CHECK CONSTRAINT [FK_MLSEVENT_GEOG] --GO --ALTER TABLE [dbo].[mlsevent] WITH CHECK ADD CONSTRAINT [FK_MLSEVENT_MEEICODE] FOREIGN KEY([meeicode]) --REFERENCES [dbo].[meeicode] ([meeicode]) --GO --ALTER TABLE [dbo].[mlsevent] CHECK CONSTRAINT [FK_MLSEVENT_MEEICODE] --GO --DEPRECATED --CREATE TABLE [dbo].[mlsclaim]( -- [stfips] [char](2) NOT NULL, -- [areatype] [char](2) NULL, -- [area] [char](6) NULL, -- [periodyear] [char](4) NULL, -- [periodtype] [char](2) NULL, -- [period] [char](2) NULL, -- [uiaccount] [char](10) NOT NULL, -- [eventid] [char](3) NOT NULL, -- [ssn] [char](9) NOT NULL, -- [gender] [char](1) NULL, -- [raceethn] [char](5) NULL, -- [birthday] [date] NULL, -- [veteran] [char](1) NULL, -- [finalpay] [char](1) NULL, -- [claimtype] [char](1) NULL, -- [finalweek] [date] NULL, -- CONSTRAINT [PK_MLSCLAIM] PRIMARY KEY CLUSTERED --( -- [stfips] ASC, -- [uiaccount] ASC, -- [eventid] ASC, -- [ssn] 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 --ALTER TABLE [dbo].[mlsclaim] WITH CHECK ADD CONSTRAINT [FK_MLSCLAIM_GENDER] FOREIGN KEY([gender]) --REFERENCES [dbo].[gender] ([gender]) --GO --ALTER TABLE [dbo].[mlsclaim] CHECK CONSTRAINT [FK_MLSCLAIM_GENDER] --GO --ALTER TABLE [dbo].[mlsclaim] WITH CHECK ADD CONSTRAINT [FK_MLSCLAIM_GEOG] FOREIGN KEY([stfips], [areatype], [area]) --REFERENCES [dbo].[geog] ([stfips], [areatype], [area]) --GO --ALTER TABLE [dbo].[mlsclaim] CHECK CONSTRAINT [FK_MLSCLAIM_GEOG] --GO --ALTER TABLE [dbo].[mlsclaim] WITH CHECK ADD CONSTRAINT [FK_MLSCLAIM_MLSEVENT] FOREIGN KEY([stfips], [uiaccount], [eventid]) --REFERENCES [dbo].[mlsevent] ([stfips], [uiaccount], [eventid]) --GO --ALTER TABLE [dbo].[mlsclaim] CHECK CONSTRAINT [FK_MLSCLAIM_MLSEVENT] --GO --ALTER TABLE [dbo].[mlsclaim] WITH CHECK ADD CONSTRAINT [FK_MLSCLAIM_PERIOD] FOREIGN KEY([periodyear], [periodtype], [period]) --REFERENCES [dbo].[period] ([periodyear], [periodtype], [period]) --GO --ALTER TABLE [dbo].[mlsclaim] CHECK CONSTRAINT [FK_MLSCLAIM_PERIOD] --GO --ALTER TABLE [dbo].[mlsclaim] WITH CHECK ADD CONSTRAINT [FK_MLSCLAIM_RACEETHN] FOREIGN KEY([raceethn]) --REFERENCES [dbo].[raceethn] ([raceethn]) --GO --ALTER TABLE [dbo].[mlsclaim] CHECK CONSTRAINT [FK_MLSCLAIM_RACEETHN] --GO --ALTER TABLE [dbo].[mlsclaim] WITH CHECK ADD CONSTRAINT [FK_MLSCLAIM_VETCODE] FOREIGN KEY([veteran]) --REFERENCES [dbo].[vetcode] ([veteran]) --GO --ALTER TABLE [dbo].[mlsclaim] CHECK CONSTRAINT [FK_MLSCLAIM_VETCODE] --GO --DEPRECATED --CREATE TABLE [dbo].[occprj]( -- [stfips] [char](2) NOT NULL, -- [areatype] [char](2) NOT NULL, -- [area] [char](6) NOT NULL, -- [periodid] [char](2) NOT NULL, -- [matoccode] [char](10) NOT NULL, -- [estoccprj] [numeric](9, 0) NULL, -- [projoccprj] [numeric](9, 0) NULL, -- [grrate] [numeric](7, 4) NULL, -- [nchg] [numeric](9, 0) NULL, -- [pchg] [numeric](7, 4) NULL, -- [aopeng] [numeric](9, 0) NULL, -- [aopenr] [numeric](9, 0) NULL, -- [aopent] [numeric](9, 0) NULL, -- [growcode] [char](2) NULL, -- [suppress] [char](1) NULL, -- CONSTRAINT [PK_OCCSUB] PRIMARY KEY CLUSTERED --( -- [stfips] ASC, -- [areatype] ASC, -- [area] ASC, -- [periodid] ASC, -- [matoccode] 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 --ALTER TABLE [dbo].[occprj] WITH CHECK ADD CONSTRAINT [FK_occprj_GEOG] FOREIGN KEY([stfips], [areatype], [area]) --REFERENCES [dbo].[geog] ([stfips], [areatype], [area]) --GO --ALTER TABLE [dbo].[occprj] CHECK CONSTRAINT [FK_occprj_GEOG] --GO --ALTER TABLE [dbo].[occprj] WITH CHECK ADD CONSTRAINT [FK_occprj_growcode] FOREIGN KEY([stfips], [growcode]) --REFERENCES [dbo].[growcode] ([stfips], [growcode]) --GO --ALTER TABLE [dbo].[occprj] CHECK CONSTRAINT [FK_occprj_growcode] --GO --ALTER TABLE [dbo].[occprj] WITH CHECK ADD CONSTRAINT [FK_occprj_occdir] FOREIGN KEY([stfips], [matoccode], [periodid]) --REFERENCES [dbo].[occdir] ([stfips], [matoccode], [periodid]) --GO --ALTER TABLE [dbo].[occprj] CHECK CONSTRAINT [FK_occprj_occdir] --GO --CORE CREATE TABLE [dbo].[iowage]( [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, [indcodty] [char](2) NOT NULL, [indcode] [char](6) NOT NULL, [occodetype] [char](2) NOT NULL, [occcode] [char](10) NOT NULL, [wagesource] [char](1) NOT NULL, [ratetype] [char](1) NOT NULL, [empcount] [numeric](10, 0) NULL, [response] [numeric](6, 0) NULL, [mean] [numeric](9, 2) NULL, [entrywg] [numeric](9, 2) NULL, [experience] [numeric](9, 2) NULL, [pct10] [numeric](9, 2) NULL, [pct25] [numeric](9, 2) NULL, [median] [numeric](9, 2) NULL, [pct75] [numeric](9, 2) NULL, [pct90] [numeric](9, 2) NULL, [udpct] [numeric](3, 0) NULL, [upctwage] [numeric](9, 2) NULL, [udrnglopct] [numeric](3, 0) NULL, [udrnghipct] [numeric](3, 0) NULL, [udrngmean] [numeric](9, 2) NULL, [wpctrelerr] [numeric](6, 2) NULL, [epctrelerr] [numeric](6, 2) NULL, [panelcode] [char](6) NULL, [suppressall] [char](1) NULL, [suppressemp] [char](1) NULL, [suppresswage] [char](1) NULL, CONSTRAINT [PK_IOWAGE] PRIMARY KEY CLUSTERED ( [stfips] ASC, [areatype] ASC, [area] ASC, [periodyear] ASC, [periodtype] ASC, [period] ASC, [indcodty] ASC, [indcode] ASC, [occodetype] ASC, [occcode] ASC, [wagesource] ASC, [ratetype] 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 ALTER TABLE [dbo].[iowage] WITH CHECK ADD CONSTRAINT [FK_IOWAGE_GEOG] FOREIGN KEY([stfips], [areatype], [area]) REFERENCES [dbo].[geog] ([stfips], [areatype], [area]) GO ALTER TABLE [dbo].[iowage] CHECK CONSTRAINT [FK_IOWAGE_GEOG] GO ALTER TABLE [dbo].[iowage] WITH CHECK ADD CONSTRAINT [FK_IOWAGE_INDCODES] FOREIGN KEY([stfips], [indcodty], [indcode]) REFERENCES [dbo].[indcodes] ([stfips], [codetype], [code]) GO ALTER TABLE [dbo].[iowage] CHECK CONSTRAINT [FK_IOWAGE_INDCODES] GO ALTER TABLE [dbo].[iowage] WITH CHECK ADD CONSTRAINT [FK_IOWAGE_OCCCODES] FOREIGN KEY([stfips], [occodetype], [occcode]) REFERENCES [dbo].[occcodes] ([stfips], [CODETYPE], [CODE]) GO ALTER TABLE [dbo].[iowage] CHECK CONSTRAINT [FK_IOWAGE_OCCCODES] GO ALTER TABLE [dbo].[iowage] WITH CHECK ADD CONSTRAINT [FK_IOWAGE_PERIOD] FOREIGN KEY([periodyear], [periodtype], [period]) REFERENCES [dbo].[period] ([periodyear], [periodtype], [period]) GO ALTER TABLE [dbo].[iowage] CHECK CONSTRAINT [FK_IOWAGE_PERIOD] GO ALTER TABLE [dbo].[iowage] WITH CHECK ADD CONSTRAINT [FK_IOWAGE_RATETYPE] FOREIGN KEY([ratetype]) REFERENCES [dbo].[ratetype] ([ratetype]) GO ALTER TABLE [dbo].[iowage] CHECK CONSTRAINT [FK_IOWAGE_RATETYPE] GO ALTER TABLE [dbo].[iowage] WITH CHECK ADD CONSTRAINT [FK_IOWAGE_WGSOURCE] FOREIGN KEY([stfips], [wagesource]) REFERENCES [dbo].[wgsource] ([stfips], [wagesource]) GO ALTER TABLE [dbo].[iowage] CHECK CONSTRAINT [FK_IOWAGE_WGSOURCE] GO --DEPRECATED --CREATE TABLE [dbo].[oeswage]( -- [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, -- [indcodty] [char](2) NOT NULL, -- [indcode] [char](6) NOT NULL, -- [occodetype] [char](2) NOT NULL, -- [occcode] [char](10) NOT NULL, -- [wagesource] [char](1) NOT NULL, -- [ratetype] [char](1) NOT NULL, -- [empcount] [numeric](10, 0) NULL, -- [response] [numeric](6, 0) NULL, -- [mean] [numeric](9, 2) NULL, -- [entrywg] [numeric](9, 2) NULL, -- [experience] [numeric](9, 2) NULL, -- [pct10] [numeric](9, 2) NULL, -- [pct25] [numeric](9, 2) NULL, -- [median] [numeric](9, 2) NULL, -- [pct75] [numeric](9, 2) NULL, -- [pct90] [numeric](9, 2) NULL, -- [udpct] [numeric](3, 0) NULL, -- [upctwage] [numeric](9, 2) NULL, -- [udrnglopct] [numeric](3, 0) NULL, -- [udrnghipct] [numeric](3, 0) NULL, -- [udrngmean] [numeric](9, 2) NULL, -- [wpctrelerr] [numeric](6, 2) NULL, -- [epctrelerr] [numeric](6, 2) NULL, -- [panelcode] [char](6) NULL, -- [suppress] [char](1) NULL, -- [meansup] [char](1) NULL, -- [entrywgsup] [char](1) NULL, -- [experiencesup] [char](1) NULL, -- [pct10sup] [char](1) NULL, -- [pct25sup] [char](1) NULL, -- [mediansup] [char](1) NULL, -- [pct75sup] [char](1) NULL, -- [pct90sup] [char](1) NULL, -- [udpctwagesup] [char](1) NULL, -- [udrngmeansup] [char](1) NULL, -- CONSTRAINT [PK_oeswage] PRIMARY KEY CLUSTERED --( -- [stfips] ASC, -- [areatype] ASC, -- [area] ASC, -- [periodyear] ASC, -- [periodtype] ASC, -- [period] ASC, -- [indcodty] ASC, -- [indcode] ASC, -- [occodetype] ASC, -- [occcode] ASC, -- [wagesource] ASC, -- [ratetype] 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 --ALTER TABLE [dbo].[oeswage] WITH CHECK ADD CONSTRAINT [FK_OESWAGE_GEOG] FOREIGN KEY([stfips], [areatype], [area]) --REFERENCES [dbo].[geog] ([stfips], [areatype], [area]) --GO --ALTER TABLE [dbo].[oeswage] CHECK CONSTRAINT [FK_OESWAGE_GEOG] --GO --ALTER TABLE [dbo].[oeswage] WITH CHECK ADD CONSTRAINT [FK_OESWAGE_INDCODES] FOREIGN KEY([stfips], [indcodty], [indcode]) --REFERENCES [dbo].[indcodes] ([stfips], [codetype], [code]) --GO --ALTER TABLE [dbo].[oeswage] CHECK CONSTRAINT [FK_OESWAGE_INDCODES] --GO --ALTER TABLE [dbo].[oeswage] WITH CHECK ADD CONSTRAINT [FK_OESWAGE_OCCCODES] FOREIGN KEY([stfips], [occodetype], [occcode]) --REFERENCES [dbo].[occcodes] ([stfips], [CODETYPE], [CODE]) --GO --ALTER TABLE [dbo].[oeswage] CHECK CONSTRAINT [FK_OESWAGE_OCCCODES] --GO --ALTER TABLE [dbo].[oeswage] WITH CHECK ADD CONSTRAINT [FK_OESWAGE_PERIOD] FOREIGN KEY([periodyear], [periodtype], [period]) --REFERENCES [dbo].[period] ([periodyear], [periodtype], [period]) --GO --ALTER TABLE [dbo].[oeswage] CHECK CONSTRAINT [FK_OESWAGE_PERIOD] --GO --ALTER TABLE [dbo].[oeswage] WITH CHECK ADD CONSTRAINT [FK_OESWAGE_RATETYPE] FOREIGN KEY([ratetype]) --REFERENCES [dbo].[ratetype] ([ratetype]) --GO --ALTER TABLE [dbo].[oeswage] CHECK CONSTRAINT [FK_OESWAGE_RATETYPE] --GO --ALTER TABLE [dbo].[oeswage] WITH CHECK ADD CONSTRAINT [FK_OESWAGE_WGSOURCE] FOREIGN KEY([stfips], [wagesource]) --REFERENCES [dbo].[wgsource] ([stfips], [wagesource]) --GO --ALTER TABLE [dbo].[oeswage] CHECK CONSTRAINT [FK_OESWAGE_WGSOURCE] --GO CREATE TABLE [dbo].[payment]( [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, [paytype] [char](2) NOT NULL, [amountpaid] [numeric](10, 0) NULL, CONSTRAINT [PK_PAYMENT] PRIMARY KEY CLUSTERED ( [stfips] ASC, [areatype] ASC, [area] ASC, [periodyear] ASC, [periodtype] ASC, [period] ASC, [paytype] 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 ALTER TABLE [dbo].[payment] WITH CHECK ADD CONSTRAINT [FK_PAYMENT_GEOG] FOREIGN KEY([stfips], [areatype], [area]) REFERENCES [dbo].[geog] ([stfips], [areatype], [area]) GO ALTER TABLE [dbo].[payment] CHECK CONSTRAINT [FK_PAYMENT_GEOG] GO ALTER TABLE [dbo].[payment] WITH CHECK ADD CONSTRAINT [FK_PAYMENT_PAYTYPE] FOREIGN KEY([stfips], [paytype]) REFERENCES [dbo].[paytype] ([stfips], [paytype]) GO ALTER TABLE [dbo].[payment] CHECK CONSTRAINT [FK_PAYMENT_PAYTYPE] GO ALTER TABLE [dbo].[payment] WITH CHECK ADD CONSTRAINT [FK_PAYMENT_PERIOD] FOREIGN KEY([periodyear], [periodtype], [period]) REFERENCES [dbo].[period] ([periodyear], [periodtype], [period]) GO ALTER TABLE [dbo].[payment] CHECK CONSTRAINT [FK_PAYMENT_PERIOD] GO CREATE TABLE [dbo].[populatn]( [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, [population] [numeric](10, 0) NULL, [releasedate] [char](8) NULL, CONSTRAINT [PK_POPULATN] PRIMARY KEY CLUSTERED ( [stfips] ASC, [areatype] ASC, [area] ASC, [periodyear] ASC, [periodtype] ASC, [period] ASC, [popsource] 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 ALTER TABLE [dbo].[populatn] WITH CHECK ADD CONSTRAINT [FK_POPULATN_GEOG] FOREIGN KEY([stfips], [areatype], [area]) REFERENCES [dbo].[geog] ([stfips], [areatype], [area]) GO ALTER TABLE [dbo].[populatn] CHECK CONSTRAINT [FK_POPULATN_GEOG] GO ALTER TABLE [dbo].[populatn] WITH CHECK ADD CONSTRAINT [FK_POPULATN_PERIOD] FOREIGN KEY([periodyear], [periodtype], [period]) REFERENCES [dbo].[period] ([periodyear], [periodtype], [period]) GO ALTER TABLE [dbo].[populatn] CHECK CONSTRAINT [FK_POPULATN_PERIOD] GO ALTER TABLE [dbo].[populatn] WITH CHECK ADD CONSTRAINT [FK_POPULATN_POPSOURC] FOREIGN KEY([stfips], [popsource]) REFERENCES [dbo].[popsource] ([stfips], [popsource]) GO ALTER TABLE [dbo].[populatn] CHECK CONSTRAINT [FK_POPULATN_POPSOURC] GO CREATE TABLE [dbo].[schools]( [stfips] [char](2) NOT NULL, [areatype] [char](2) NULL, [area] [char](6) NULL, [instcode] [char](10) NOT NULL, [insttype] [char](2) NULL, [instown] [char](1) NULL, [instname1] [varchar](80) NULL, [instname2] [varchar](80) NULL, [address1] [varchar](35) NULL, [address2] [varchar](35) NULL, [city] [varchar](30) NULL, [st] [char](2) NULL, [zip] [char](5) NULL, [zipext] [char](4) NULL, [latitude] [numeric](11, 6) NULL, [longitude] [numeric](11, 6) NULL, [geopcode] [char](1) NULL, [telephone] [char](10) NULL, [teleext] [varchar](10) NULL, [fax] [char](10) NULL, [url] [varchar](200) NULL, [contact] [varchar](50) NULL, [distancelearn] [char](1) NULL, [satellitecampus] [char](1) NULL, CONSTRAINT [PK_SCHOOLS] PRIMARY KEY CLUSTERED ( [stfips] ASC, [instcode] 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 ALTER TABLE [dbo].[schools] WITH CHECK ADD CONSTRAINT [FK_SCHOOLS_GEOCODE] FOREIGN KEY([geopcode]) REFERENCES [dbo].[geocode] ([geopcode]) GO ALTER TABLE [dbo].[schools] CHECK CONSTRAINT [FK_SCHOOLS_GEOCODE] GO ALTER TABLE [dbo].[schools] WITH CHECK ADD CONSTRAINT [FK_SCHOOLS_GEOG] FOREIGN KEY([stfips], [areatype], [area]) REFERENCES [dbo].[geog] ([stfips], [areatype], [area]) GO ALTER TABLE [dbo].[schools] CHECK CONSTRAINT [FK_SCHOOLS_GEOG] GO ALTER TABLE [dbo].[schools] WITH CHECK ADD CONSTRAINT [FK_SCHOOLS_INSTOWN] FOREIGN KEY([instown]) REFERENCES [dbo].[instown] ([instown]) GO ALTER TABLE [dbo].[schools] CHECK CONSTRAINT [FK_SCHOOLS_INSTOWN] GO ALTER TABLE [dbo].[schools] WITH CHECK ADD CONSTRAINT [FK_SCHOOLS_INSTTYPE] FOREIGN KEY([stfips], [insttype]) REFERENCES [dbo].[insttype] ([stfips], [insttype]) GO ALTER TABLE [dbo].[schools] CHECK CONSTRAINT [FK_SCHOOLS_INSTTYPE] GO CREATE TABLE [dbo].[progcomp]( [stfips] [char](2) NOT NULL, [areatype] [char](2) NULL, [area] [char](6) NULL, [instcode] [char](10) NOT NULL, [periodyear] [char](4) NOT NULL, [periodtype] [char](2) NOT NULL, [period] [char](2) NOT NULL, [codetype] [char](2) NOT NULL, [code] [char](10) NOT NULL, [compltype] [char](2) NOT NULL, [completers] [numeric](8, 0) NULL, [placecomp] [varchar](max) NULL, CONSTRAINT [PK_PROGCOMP] PRIMARY KEY CLUSTERED ( [stfips] ASC, [instcode] ASC, [periodyear] ASC, [periodtype] ASC, [period] ASC, [codetype] ASC, [code] ASC, [compltype] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO ALTER TABLE [dbo].[progcomp] WITH CHECK ADD CONSTRAINT [FK_PROGCOMP_COMPLTYP] FOREIGN KEY([stfips], [compltype]) REFERENCES [dbo].[compltyp] ([stfips], [compltype]) GO ALTER TABLE [dbo].[progcomp] CHECK CONSTRAINT [FK_PROGCOMP_COMPLTYP] GO ALTER TABLE [dbo].[progcomp] WITH CHECK ADD CONSTRAINT [FK_PROGCOMP_GEOG] FOREIGN KEY([stfips], [areatype], [area]) REFERENCES [dbo].[geog] ([stfips], [areatype], [area]) GO ALTER TABLE [dbo].[progcomp] CHECK CONSTRAINT [FK_PROGCOMP_GEOG] GO ALTER TABLE [dbo].[progcomp] WITH CHECK ADD CONSTRAINT [FK_PROGCOMP_OCCCODES] FOREIGN KEY([stfips], [codetype], [code]) REFERENCES [dbo].[occcodes] ([stfips], [CODETYPE], [CODE]) GO ALTER TABLE [dbo].[progcomp] CHECK CONSTRAINT [FK_PROGCOMP_OCCCODES] GO ALTER TABLE [dbo].[progcomp] WITH CHECK ADD CONSTRAINT [FK_PROGCOMP_PERIOD] FOREIGN KEY([periodyear], [periodtype], [period]) REFERENCES [dbo].[period] ([periodyear], [periodtype], [period]) GO ALTER TABLE [dbo].[progcomp] CHECK CONSTRAINT [FK_PROGCOMP_PERIOD] GO ALTER TABLE [dbo].[progcomp] WITH CHECK ADD CONSTRAINT [FK_PROGCOMP_SCHOOLS] FOREIGN KEY([stfips], [instcode]) REFERENCES [dbo].[schools] ([stfips], [instcode]) GO ALTER TABLE [dbo].[progcomp] CHECK CONSTRAINT [FK_PROGCOMP_SCHOOLS] GO --CHANGES IN V2.8 CREATE TABLE [dbo].[programs]( [stfips] [char](2) NOT NULL, [areatype] [char](2) NULL, [area] [char](6) NULL, [instcode] [char](10) NOT NULL, [codetype] [char](2) NOT NULL, [code] [char](10) NOT NULL, [compltype] [char](2) NOT NULL, [length] [numeric](4, 0) NULL, [lengthtype] [char](2) NULL, [progcost] [numeric](6, 0) NULL, [progtitle] [varchar](200) NULL, [progdesc] [varchar](max) NULL, [cipcodetype] [char](2) NULL, [cipcode] [char](10) NULL, [url] [varchar](200) NULL, [classroom] [char](1) NULL, [online] [char](1) NULL, [classtime] [char](1) NULL, [etplapproval] CHAR(1) NULL, CONSTRAINT [PK_PROGRAMS] PRIMARY KEY CLUSTERED ( [stfips] ASC, [instcode] ASC, [codetype] ASC, [code] ASC, [compltype] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO ALTER TABLE [dbo].[programs] WITH CHECK ADD CONSTRAINT [FK_PROGRAMS_CIPCODE] FOREIGN KEY([cipcode]) REFERENCES [dbo].[cipcode] ([cipcode]) GO ALTER TABLE [dbo].[programs] CHECK CONSTRAINT [FK_PROGRAMS_CIPCODE] GO ALTER TABLE [dbo].[programs] WITH CHECK ADD CONSTRAINT [FK_PROGRAMS_CLASSTIME] FOREIGN KEY([classtime]) REFERENCES [dbo].[classtime] ([classtime]) GO ALTER TABLE [dbo].[programs] CHECK CONSTRAINT [FK_PROGRAMS_CLASSTIME] GO ALTER TABLE [dbo].[programs] WITH CHECK ADD CONSTRAINT [FK_PROGRAMS_COMPLTYP] FOREIGN KEY([stfips], [compltype]) REFERENCES [dbo].[compltyp] ([stfips], [compltype]) GO ALTER TABLE [dbo].[programs] CHECK CONSTRAINT [FK_PROGRAMS_COMPLTYP] GO ALTER TABLE [dbo].[programs] WITH CHECK ADD CONSTRAINT [FK_PROGRAMS_GEOG] FOREIGN KEY([stfips], [areatype], [area]) REFERENCES [dbo].[geog] ([stfips], [areatype], [area]) GO ALTER TABLE [dbo].[programs] CHECK CONSTRAINT [FK_PROGRAMS_GEOG] GO ALTER TABLE [dbo].[programs] WITH CHECK ADD CONSTRAINT [FK_PROGRAMS_LENTYPE] FOREIGN KEY([stfips], [lengthtype]) REFERENCES [dbo].[lentype] ([stfips], [lengthtype]) GO ALTER TABLE [dbo].[programs] CHECK CONSTRAINT [FK_PROGRAMS_LENTYPE] GO ALTER TABLE [dbo].[programs] WITH CHECK ADD CONSTRAINT [FK_PROGRAMS_OCCCODES] FOREIGN KEY([stfips], [codetype], [code]) REFERENCES [dbo].[occcodes] ([stfips], [CODETYPE], [CODE]) GO ALTER TABLE [dbo].[programs] CHECK CONSTRAINT [FK_PROGRAMS_OCCCODES] GO ALTER TABLE [dbo].[programs] WITH CHECK ADD CONSTRAINT [FK_PROGRAMS_SCHOOLS] FOREIGN KEY([stfips], [instcode]) REFERENCES [dbo].[schools] ([stfips], [instcode]) GO ALTER TABLE [dbo].[programs] CHECK CONSTRAINT [FK_PROGRAMS_SCHOOLS] GO --DEPRECATED --CREATE TABLE [dbo].[propval]( -- [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, -- [taxtype] [char](2) NOT NULL, -- [propvalue] [numeric](15, 0) NULL, -- [taxvalue] [numeric](15, 0) NULL, -- [millrate] [numeric](6, 4) NULL, -- CONSTRAINT [PK_PROPVAL] PRIMARY KEY CLUSTERED --( -- [stfips] ASC, -- [areatype] ASC, -- [area] ASC, -- [periodyear] ASC, -- [periodtype] ASC, -- [period] ASC, -- [taxtype] 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 --ALTER TABLE [dbo].[propval] WITH CHECK ADD CONSTRAINT [FK_PROPVAL_GEOG] FOREIGN KEY([stfips], [areatype], [area]) --REFERENCES [dbo].[geog] ([stfips], [areatype], [area]) --GO --ALTER TABLE [dbo].[propval] CHECK CONSTRAINT [FK_PROPVAL_GEOG] --GO --ALTER TABLE [dbo].[propval] WITH CHECK ADD CONSTRAINT [FK_PROPVAL_PERIOD] FOREIGN KEY([periodyear], [periodtype], [period]) --REFERENCES [dbo].[period] ([periodyear], [periodtype], [period]) --GO --ALTER TABLE [dbo].[propval] CHECK CONSTRAINT [FK_PROPVAL_PERIOD] --GO --ALTER TABLE [dbo].[propval] WITH CHECK ADD CONSTRAINT [FK_PROPVAL_TAXTYPE] FOREIGN KEY([stfips], [taxtype]) --REFERENCES [dbo].[taxtype] ([stfips], [taxtype]) --GO --ALTER TABLE [dbo].[propval] CHECK CONSTRAINT [FK_PROPVAL_TAXTYPE] --GO CREATE TABLE [dbo].[qwichar]( [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, [INDCODTY] [char](2) NOT NULL, [INDCODE] [char](6) NOT NULL, [OWNERSHIP] [char](2) NOT NULL, [GENDER] [char](1) NOT NULL, [AGEGROUP] [char](2) NOT NULL, [QWIID] [int] NULL, CONSTRAINT [PK_QWICHAR] PRIMARY KEY CLUSTERED ( [STFIPS] ASC, [AREATYPE] ASC, [AREA] ASC, [PERIODYEAR] ASC, [PERIODTYPE] ASC, [PERIOD] ASC, [INDCODTY] ASC, [INDCODE] ASC, [OWNERSHIP] ASC, [GENDER] ASC, [AGEGROUP] 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 ALTER TABLE [dbo].[qwichar] WITH CHECK ADD CONSTRAINT [FK_QWICHAR_AGEGROUP] FOREIGN KEY([STFIPS], [AGEGROUP]) REFERENCES [dbo].[agegroup] ([stfips], [agegroup]) GO ALTER TABLE [dbo].[qwichar] CHECK CONSTRAINT [FK_QWICHAR_AGEGROUP] GO ALTER TABLE [dbo].[qwichar] WITH CHECK ADD CONSTRAINT [FK_QWICHAR_GENDER] FOREIGN KEY([GENDER]) REFERENCES [dbo].[gender] ([gender]) GO ALTER TABLE [dbo].[qwichar] CHECK CONSTRAINT [FK_QWICHAR_GENDER] GO ALTER TABLE [dbo].[qwichar] WITH CHECK ADD CONSTRAINT [FK_QWICHAR_GEOG] FOREIGN KEY([STFIPS], [AREATYPE], [AREA]) REFERENCES [dbo].[geog] ([stfips], [areatype], [area]) GO ALTER TABLE [dbo].[qwichar] CHECK CONSTRAINT [FK_QWICHAR_GEOG] GO ALTER TABLE [dbo].[qwichar] WITH CHECK ADD CONSTRAINT [FK_QWICHAR_INDCODES] FOREIGN KEY([STFIPS], [INDCODTY], [INDCODE]) REFERENCES [dbo].[indcodes] ([stfips], [codetype], [code]) GO ALTER TABLE [dbo].[qwichar] CHECK CONSTRAINT [FK_QWICHAR_INDCODES] GO ALTER TABLE [dbo].[qwichar] WITH CHECK ADD CONSTRAINT [FK_QWICHAR_OWNERSHP] FOREIGN KEY([STFIPS], [OWNERSHIP]) REFERENCES [dbo].[ownershp] ([stfips], [ownership]) GO ALTER TABLE [dbo].[qwichar] CHECK CONSTRAINT [FK_QWICHAR_OWNERSHP] GO ALTER TABLE [dbo].[qwichar] WITH CHECK ADD CONSTRAINT [FK_QWICHAR_PERIOD] FOREIGN KEY([PERIODYEAR], [PERIODTYPE], [PERIOD]) REFERENCES [dbo].[period] ([periodyear], [periodtype], [period]) GO ALTER TABLE [dbo].[qwichar] CHECK CONSTRAINT [FK_QWICHAR_PERIOD] GO CREATE TABLE [dbo].[qwidata]( [STFIPS] [char](2) NOT NULL, [QWIID] [int] NOT NULL, [QWITYPE] [char](2) NOT NULL, [QWIVAQLUE] [numeric](16, 2) NULL, [QWISUP] [char](1) NULL, CONSTRAINT [PK_QWIDATA] PRIMARY KEY CLUSTERED ( [STFIPS] ASC, [QWIID] ASC, [QWITYPE] 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 ALTER TABLE [dbo].[qwidata] WITH CHECK ADD CONSTRAINT [FK_QWIDATA_QWISUP] FOREIGN KEY([QWISUP]) REFERENCES [dbo].[qwisup] ([qwisup]) GO ALTER TABLE [dbo].[qwidata] CHECK CONSTRAINT [FK_QWIDATA_QWISUP] GO ALTER TABLE [dbo].[qwidata] WITH CHECK ADD CONSTRAINT [FK_QWIDATA_QWITYPE] FOREIGN KEY([QWITYPE]) REFERENCES [dbo].[qwitype] ([qwitype]) GO ALTER TABLE [dbo].[qwidata] CHECK CONSTRAINT [FK_QWIDATA_QWITYPE] GO CREATE TABLE [dbo].[sales]( [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, [salestype] [char](2) NOT NULL, [sales] [numeric](15, 0) NULL, CONSTRAINT [PK_SALES] PRIMARY KEY CLUSTERED ( [stfips] ASC, [areatype] ASC, [area] ASC, [periodyear] ASC, [periodtype] ASC, [period] ASC, [salestype] 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 ALTER TABLE [dbo].[sales] WITH CHECK ADD CONSTRAINT [FK_SALES_GEOG] FOREIGN KEY([stfips], [areatype], [area]) REFERENCES [dbo].[geog] ([stfips], [areatype], [area]) GO ALTER TABLE [dbo].[sales] CHECK CONSTRAINT [FK_SALES_GEOG] GO ALTER TABLE [dbo].[sales] WITH CHECK ADD CONSTRAINT [FK_SALES_PERIOD] FOREIGN KEY([periodyear], [periodtype], [period]) REFERENCES [dbo].[period] ([periodyear], [periodtype], [period]) GO ALTER TABLE [dbo].[sales] CHECK CONSTRAINT [FK_SALES_PERIOD] GO ALTER TABLE [dbo].[sales] WITH CHECK ADD CONSTRAINT [FK_SALES_SALESTYP] FOREIGN KEY([stfips], [salestype]) REFERENCES [dbo].[salestyp] ([stfips], [salestype]) GO ALTER TABLE [dbo].[sales] CHECK CONSTRAINT [FK_SALES_SALESTYP] GO --CHANGES IN V2.8 CREATE TABLE [dbo].[stfirms]( [stfips] [char](2) NOT NULL, [areatype] [char](2) NULL, [area] [char](6) NULL, [uiaccount] [char](10) NOT NULL, [reptunit] [char](5) NOT NULL, [yrqtr] [char](6) NULL, [name1] [varchar](35) NULL, [name2] [varchar](35) NULL, [address1] [varchar](35) NULL, [address2] [varchar](35) NULL, [city] [varchar](30) NULL, [st] [char](2) NULL, [zip] [char](5) NULL, [zipext] [char](4) NULL, [addressty] [char](1) NULL, [latitude] [numeric](11, 6) NULL, [longitude] [numeric](11, 6) NULL, [geopcode] [char](1) NULL, [telephone] [varchar](10) NULL, [teleext] [varchar](10) NULL, [employment] [numeric](8, 0) NULL, [indcodetype] [char](2) NULL, [indcode] [char](6) NULL, [ownership] [char](2) NULL, [sizeclass] [char](2) NULL, [busdesc] [varchar](max) NULL, CONSTRAINT [PK_STFIRMS] PRIMARY KEY CLUSTERED ( [stfips] ASC, [uiaccount] ASC, [reptunit] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO ALTER TABLE [dbo].[stfirms] WITH CHECK ADD CONSTRAINT [FK_STFIRMS_ADDRESTY] FOREIGN KEY([addressty]) REFERENCES [dbo].[addresty] ([addressty]) GO ALTER TABLE [dbo].[stfirms] CHECK CONSTRAINT [FK_STFIRMS_ADDRESTY] GO ALTER TABLE [dbo].[stfirms] WITH CHECK ADD CONSTRAINT [FK_STFIRMS_GEOCODE] FOREIGN KEY([geopcode]) REFERENCES [dbo].[geocode] ([geopcode]) GO ALTER TABLE [dbo].[stfirms] CHECK CONSTRAINT [FK_STFIRMS_GEOCODE] GO ALTER TABLE [dbo].[stfirms] WITH CHECK ADD CONSTRAINT [FK_STFIRMS_GEOG] FOREIGN KEY([stfips], [areatype], [area]) REFERENCES [dbo].[geog] ([stfips], [areatype], [area]) GO ALTER TABLE [dbo].[stfirms] CHECK CONSTRAINT [FK_STFIRMS_GEOG] GO ALTER TABLE [dbo].[stfirms] WITH CHECK ADD CONSTRAINT [FK_STFIRMS_INDCODES] FOREIGN KEY([stfips], [indcodetype], [indcode]) REFERENCES [dbo].[indcodes] ([stfips], [codetype], [code]) GO ALTER TABLE [dbo].[stfirms] CHECK CONSTRAINT [FK_STFIRMS_INDCODES] GO ALTER TABLE [dbo].[stfirms] WITH CHECK ADD CONSTRAINT [FK_STFIRMS_OWNERSHP] FOREIGN KEY([stfips], [ownership]) REFERENCES [dbo].[ownershp] ([stfips], [ownership]) GO ALTER TABLE [dbo].[stfirms] CHECK CONSTRAINT [FK_STFIRMS_OWNERSHP] GO ALTER TABLE [dbo].[stfirms] WITH CHECK ADD CONSTRAINT [FK_STFIRMS_SIZECLAS] FOREIGN KEY([stfips], [sizeclass]) REFERENCES [dbo].[sizeclas] ([stfips], [sizeclass]) GO ALTER TABLE [dbo].[stfirms] CHECK CONSTRAINT [FK_STFIRMS_SIZECLAS] GO --DEPRECATED --CREATE TABLE [dbo].[stindprj]( -- [stfips] [char](2) NOT NULL, -- [areatype] [char](2) NOT NULL, -- [area] [char](6) NOT NULL, -- [periodid] [char](2) NOT NULL, -- [matincode] [char](15) NOT NULL, -- [estindst] [numeric](9, 0) NULL, -- [projindst] [numeric](9, 0) NULL, -- [nchg] [numeric](9, 0) NULL, -- [grrate] [numeric](7, 4) NULL, -- [growcode] [char](2) NULL, -- [suppress] [char](1) NULL, -- CONSTRAINT [PK_stindprj] PRIMARY KEY CLUSTERED --( -- [stfips] ASC, -- [areatype] ASC, -- [area] ASC, -- [periodid] ASC, -- [matincode] 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 --DEPRECATED --CREATE TABLE [dbo].[stoccprj]( -- [stfips] [char](2) NOT NULL, -- [areatype] [char](2) NOT NULL, -- [area] [char](6) NOT NULL, -- [periodid] [char](2) NOT NULL, -- [matoccode] [char](10) NOT NULL, -- [estoccst] [numeric](9, 0) NULL, -- [projoccst] [numeric](9, 0) NULL, -- [nchg] [numeric](9, 0) NULL, -- [grrate] [numeric](7, 4) NULL, -- [aopeng] [numeric](9, 0) NULL, -- [aopenr] [numeric](9, 0) NULL, -- [aopent] [numeric](9, 0) NULL, -- [growcode] [char](2) NULL, -- [suppress] [char](1) NULL --) ON [PRIMARY] --GO CREATE TABLE [dbo].[supply]( [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, [insttype] [char](2) NOT NULL, [instown] [char](1) NOT NULL, [codetype] [char](2) NOT NULL, [code] [char](10) NOT NULL, [compltype] [char](2) NOT NULL, [completers] [numeric](8, 0) NULL, CONSTRAINT [PK_SUPPLY] PRIMARY KEY CLUSTERED ( [stfips] ASC, [areatype] ASC, [area] ASC, [periodyear] ASC, [periodtype] ASC, [period] ASC, [insttype] ASC, [instown] ASC, [codetype] ASC, [code] ASC, [compltype] 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 ALTER TABLE [dbo].[supply] WITH CHECK ADD CONSTRAINT [FK_SUPPLY_COMPLTYP] FOREIGN KEY([stfips], [compltype]) REFERENCES [dbo].[compltyp] ([stfips], [compltype]) GO ALTER TABLE [dbo].[supply] CHECK CONSTRAINT [FK_SUPPLY_COMPLTYP] GO ALTER TABLE [dbo].[supply] WITH CHECK ADD CONSTRAINT [FK_SUPPLY_GEOG] FOREIGN KEY([stfips], [areatype], [area]) REFERENCES [dbo].[geog] ([stfips], [areatype], [area]) GO ALTER TABLE [dbo].[supply] CHECK CONSTRAINT [FK_SUPPLY_GEOG] GO ALTER TABLE [dbo].[supply] WITH CHECK ADD CONSTRAINT [FK_SUPPLY_INSTOWN] FOREIGN KEY([instown]) REFERENCES [dbo].[instown] ([instown]) GO ALTER TABLE [dbo].[supply] CHECK CONSTRAINT [FK_SUPPLY_INSTOWN] GO ALTER TABLE [dbo].[supply] WITH CHECK ADD CONSTRAINT [FK_SUPPLY_INSTTYPE] FOREIGN KEY([stfips], [insttype]) REFERENCES [dbo].[insttype] ([stfips], [insttype]) GO ALTER TABLE [dbo].[supply] CHECK CONSTRAINT [FK_SUPPLY_INSTTYPE] GO ALTER TABLE [dbo].[supply] WITH CHECK ADD CONSTRAINT [FK_SUPPLY_OCCCODES] FOREIGN KEY([stfips], [codetype], [code]) REFERENCES [dbo].[occcodes] ([stfips], [CODETYPE], [CODE]) GO ALTER TABLE [dbo].[supply] CHECK CONSTRAINT [FK_SUPPLY_OCCCODES] GO ALTER TABLE [dbo].[supply] WITH CHECK ADD CONSTRAINT [FK_SUPPLY_PERIOD] FOREIGN KEY([periodyear], [periodtype], [period]) REFERENCES [dbo].[period] ([periodyear], [periodtype], [period]) GO ALTER TABLE [dbo].[supply] CHECK CONSTRAINT [FK_SUPPLY_PERIOD] GO CREATE TABLE [dbo].[tax]( [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, [taxtype] [char](2) NOT NULL, [taxrevenue] [numeric](15, 0) NULL, CONSTRAINT [PK_TAX] PRIMARY KEY CLUSTERED ( [stfips] ASC, [areatype] ASC, [area] ASC, [periodyear] ASC, [periodtype] ASC, [period] ASC, [taxtype] 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 ALTER TABLE [dbo].[tax] WITH CHECK ADD CONSTRAINT [FK_TAX_GEOG] FOREIGN KEY([stfips], [areatype], [area]) REFERENCES [dbo].[geog] ([stfips], [areatype], [area]) GO ALTER TABLE [dbo].[tax] CHECK CONSTRAINT [FK_TAX_GEOG] GO ALTER TABLE [dbo].[tax] WITH CHECK ADD CONSTRAINT [FK_TAX_PERIOD] FOREIGN KEY([periodyear], [periodtype], [period]) REFERENCES [dbo].[period] ([periodyear], [periodtype], [period]) GO ALTER TABLE [dbo].[tax] CHECK CONSTRAINT [FK_TAX_PERIOD] GO ALTER TABLE [dbo].[tax] WITH CHECK ADD CONSTRAINT [FK_TAX_TAXTYPE] FOREIGN KEY([stfips], [taxtype]) REFERENCES [dbo].[taxtype] ([stfips], [taxtype]) GO ALTER TABLE [dbo].[tax] CHECK CONSTRAINT [FK_TAX_TAXTYPE] GO --CHANGES IN V2.8 CREATE TABLE [dbo].[uiclaims]( [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, [claimtype] [char](1) NOT NULL, [occodetype] [char](2) NOT NULL, [occcode] [char](10) NOT NULL, [indcodty] [char](2) NOT NULL, [indcode] [char](6) NOT NULL, [agegroup] [char](2) NOT NULL, [raceethn] [char](5) NOT NULL, [gender] [char](1) NOT NULL, [claimants] [numeric](8, 0) NULL, [weekscomp] [numeric](8, 0) NULL, [firstpayments] [numeric](8, 0) NULL, [duration] [numeric](4, 1) NULL, CONSTRAINT [PK_UICLAIMS] PRIMARY KEY CLUSTERED ( [stfips] ASC, [areatype] ASC, [area] ASC, [periodyear] ASC, [periodtype] ASC, [period] ASC, [claimtype] ASC, [occodetype] ASC, [occcode] ASC, [indcodty] ASC, [indcode] ASC, [agegroup] ASC, [raceethn] ASC, [gender] 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 ALTER TABLE [dbo].[uiclaims] WITH CHECK ADD CONSTRAINT [FK_UICLAIMS_AGEGROUP] FOREIGN KEY([stfips], [agegroup]) REFERENCES [dbo].[agegroup] ([stfips], [agegroup]) GO ALTER TABLE [dbo].[uiclaims] CHECK CONSTRAINT [FK_UICLAIMS_AGEGROUP] GO ALTER TABLE [dbo].[uiclaims] WITH CHECK ADD CONSTRAINT [FK_UICLAIMS_GENDER] FOREIGN KEY([gender]) REFERENCES [dbo].[gender] ([gender]) GO ALTER TABLE [dbo].[uiclaims] CHECK CONSTRAINT [FK_UICLAIMS_GENDER] GO ALTER TABLE [dbo].[uiclaims] WITH CHECK ADD CONSTRAINT [FK_UICLAIMS_GEOG] FOREIGN KEY([stfips], [areatype], [area]) REFERENCES [dbo].[geog] ([stfips], [areatype], [area]) GO ALTER TABLE [dbo].[uiclaims] CHECK CONSTRAINT [FK_UICLAIMS_GEOG] GO ALTER TABLE [dbo].[uiclaims] WITH CHECK ADD CONSTRAINT [FK_UICLAIMS_INDCODES] FOREIGN KEY([stfips], [indcodty], [indcode]) REFERENCES [dbo].[indcodes] ([stfips], [codetype], [code]) GO ALTER TABLE [dbo].[uiclaims] CHECK CONSTRAINT [FK_UICLAIMS_INDCODES] GO ALTER TABLE [dbo].[uiclaims] WITH CHECK ADD CONSTRAINT [FK_UICLAIMS_OCCCODES] FOREIGN KEY([stfips], [occodetype], [occcode]) REFERENCES [dbo].[occcodes] ([stfips], [CODETYPE], [CODE]) GO ALTER TABLE [dbo].[uiclaims] CHECK CONSTRAINT [FK_UICLAIMS_OCCCODES] GO ALTER TABLE [dbo].[uiclaims] WITH CHECK ADD CONSTRAINT [FK_UICLAIMS_PERIOD] FOREIGN KEY([periodyear], [periodtype], [period]) REFERENCES [dbo].[period] ([periodyear], [periodtype], [period]) GO ALTER TABLE [dbo].[uiclaims] CHECK CONSTRAINT [FK_UICLAIMS_PERIOD] GO ALTER TABLE [dbo].[uiclaims] WITH CHECK ADD CONSTRAINT [FK_UICLAIMS_RACEETHN] FOREIGN KEY([raceethn]) REFERENCES [dbo].[raceethn] ([raceethn]) GO ALTER TABLE [dbo].[uiclaims] CHECK CONSTRAINT [FK_UICLAIMS_RACEETHN] GO --DEPRECATED --CREATE TABLE [dbo].[url]( -- [urlid] [char](5) NOT NULL, -- [url] [char](200) NULL, -- [urlname] [varchar](100) NULL, -- [urldesc] [varchar](max) NULL, --PRIMARY KEY CLUSTERED --( -- [urlid] ASC --)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] --) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] --GO --DEPRECATED --CREATE TABLE [dbo].[urllinks]( -- [urlid] [char](5) NOT NULL, -- [stfips] [char](2) NOT NULL, -- [areatype] [char](2) NULL, -- [area] [char](6) NULL, -- [urltopic] [char](3) NULL, -- CONSTRAINT [PK_UNITlinks] PRIMARY KEY CLUSTERED --( -- [urlid] ASC, -- [stfips] 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 --DEPRECATED --CREATE TABLE [dbo].[wage]( -- [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, -- [indcodty] [char](2) NOT NULL, -- [indcode] [char](6) NOT NULL, -- [occodetype] [char](2) NOT NULL, -- [occcode] [char](10) NOT NULL, -- [wagesource] [char](1) NOT NULL, -- [ratetype] [char](1) NOT NULL, -- [leveltype] [char](1) NOT NULL, -- [stattype] [char](2) NOT NULL, -- [wage] [numeric](9, 2) NULL, -- [respondent] [numeric](6, 0) NULL, -- [empcount] [numeric](7, 0) NULL, -- CONSTRAINT [PK_wage] PRIMARY KEY CLUSTERED --( -- [stfips] ASC, -- [areatype] ASC, -- [area] ASC, -- [periodyear] ASC, -- [periodtype] ASC, -- [period] ASC, -- [indcodty] ASC, -- [indcode] ASC, -- [occodetype] ASC, -- [occcode] ASC, -- [wagesource] ASC, -- [ratetype] ASC, -- [leveltype] ASC, -- [stattype] 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 --DEPRECATED --CREATE TABLE [dbo].[workstop]( -- [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, -- [indcodty] [char](2) NOT NULL, -- [indcode] [char](6) NOT NULL, -- [ownership] [char](2) NOT NULL, -- [stopstatus] [char](1) NOT NULL, -- [firms] [numeric](4, 0) NULL, -- [workers] [numeric](10, 0) NULL, -- [daysidle] [numeric](6, 0) NULL, -- CONSTRAINT [PK_WORKSTOP] PRIMARY KEY CLUSTERED --( -- [stfips] ASC, -- [areatype] ASC, -- [area] ASC, -- [periodyear] ASC, -- [periodtype] ASC, -- [period] ASC, -- [indcodty] ASC, -- [indcode] ASC, -- [ownership] ASC, -- [stopstatus] 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 --ALTER TABLE [dbo].[workstop] WITH CHECK ADD CONSTRAINT [FK_WORKSTOP_GEOG] FOREIGN KEY([stfips], [areatype], [area]) --REFERENCES [dbo].[geog] ([stfips], [areatype], [area]) --GO --ALTER TABLE [dbo].[workstop] CHECK CONSTRAINT [FK_WORKSTOP_GEOG] --GO --ALTER TABLE [dbo].[workstop] WITH CHECK ADD CONSTRAINT [FK_WORKSTOP_INDCODES] FOREIGN KEY([stfips], [indcodty], [indcode]) --REFERENCES [dbo].[indcodes] ([stfips], [codetype], [code]) --GO --ALTER TABLE [dbo].[workstop] CHECK CONSTRAINT [FK_WORKSTOP_INDCODES] --GO --ALTER TABLE [dbo].[workstop] WITH CHECK ADD CONSTRAINT [FK_WORKSTOP_OWNERSHP] FOREIGN KEY([stfips], [ownership]) --REFERENCES [dbo].[ownershp] ([stfips], [ownership]) --GO --ALTER TABLE [dbo].[workstop] CHECK CONSTRAINT [FK_WORKSTOP_OWNERSHP] --GO --ALTER TABLE [dbo].[workstop] WITH CHECK ADD CONSTRAINT [FK_WORKSTOP_PERIOD] FOREIGN KEY([periodyear], [periodtype], [period]) --REFERENCES [dbo].[period] ([periodyear], [periodtype], [period]) --GO --ALTER TABLE [dbo].[workstop] CHECK CONSTRAINT [FK_WORKSTOP_PERIOD] --GO CREATE TABLE [dbo].[occxocc]( [stfips] [char](2) NOT NULL, [codetype] [char](2) NOT NULL, [code] [char](10) NOT NULL, [codetype2] [char](2) NOT NULL, [code2] [char](10) NOT NULL, CONSTRAINT [PK_OCCXOCC] PRIMARY KEY CLUSTERED ( [stfips] ASC, [codetype] ASC, [code] ASC, [codetype2] ASC, [code2] 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 ALTER TABLE [dbo].[occxocc] WITH CHECK ADD CONSTRAINT [FK_OCCXOCC_OCCCODES] FOREIGN KEY([stfips], [codetype], [code]) REFERENCES [dbo].[occcodes] ([stfips], [CODETYPE], [CODE]) GO ALTER TABLE [dbo].[occxocc] CHECK CONSTRAINT [FK_OCCXOCC_OCCCODES] GO ALTER TABLE [dbo].[occxocc] WITH CHECK ADD CONSTRAINT [FK_OCCXOCC_OCCCODES_2] FOREIGN KEY([stfips], [codetype2], [code2]) REFERENCES [dbo].[occcodes] ([stfips], [CODETYPE], [CODE]) GO ALTER TABLE [dbo].[occxocc] CHECK CONSTRAINT [FK_OCCXOCC_OCCCODES_2] GO CREATE TABLE [dbo].[indxind]( [stfips] [char](2) NOT NULL, [codetype] [char](2) NOT NULL, [code] [char](6) NOT NULL, [codetype2] [char](2) NOT NULL, [code2] [char](6) NOT NULL, CONSTRAINT [PK_INDXIND] PRIMARY KEY CLUSTERED ( [stfips] ASC, [codetype] ASC, [code] ASC, [codetype2] ASC, [code2] 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 ALTER TABLE [dbo].[indxind] WITH CHECK ADD CONSTRAINT [FK_INDXIND_INDCODES] FOREIGN KEY([stfips], [codetype], [code]) REFERENCES [dbo].[indcodes] ([stfips], [codetype], [code]) GO ALTER TABLE [dbo].[indxind] CHECK CONSTRAINT [FK_INDXIND_INDCODES] GO ALTER TABLE [dbo].[indxind] WITH CHECK ADD CONSTRAINT [FK_INDXIND_INDCODES_2] FOREIGN KEY([stfips], [codetype2], [code2]) REFERENCES [dbo].[indcodes] ([stfips], [codetype], [code]) GO ALTER TABLE [dbo].[indxind] CHECK CONSTRAINT [FK_INDXIND_INDCODES_2] GO --DEPRECATED --CREATE TABLE [dbo].[matxoes]( -- [stfips] [char](2) NOT NULL, -- [matoccode] [char](10) NOT NULL, -- [periodid] [char](2) NOT NULL, -- [oescode] [char](5) NOT NULL, -- [subtot] [char](1) NULL, -- CONSTRAINT [PK_MATXOes] PRIMARY KEY CLUSTERED --( -- [stfips] ASC, -- [matoccode] ASC, -- [periodid] ASC, -- [oescode] 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 --ALTER TABLE [dbo].[matxoes] WITH CHECK ADD CONSTRAINT [FK_matxoes_occdir] FOREIGN KEY([stfips], [matoccode], [periodid]) --REFERENCES [dbo].[occdir] ([stfips], [matoccode], [periodid]) --GO --ALTER TABLE [dbo].[matxoes] CHECK CONSTRAINT [FK_matxoes_occdir] --GO --ALTER TABLE [dbo].[matxoes] WITH CHECK ADD CONSTRAINT [FK_matxoes_OCCSUB] FOREIGN KEY([stfips], [subtot]) --REFERENCES [dbo].[occsub] ([stfips], [subtot]) --GO --ALTER TABLE [dbo].[matxoes] CHECK CONSTRAINT [FK_matxoes_OCCSUB] --GO --ALTER TABLE [dbo].[matxoes] WITH CHECK ADD CONSTRAINT [FK_matxoes_oescode] FOREIGN KEY([oescode]) --REFERENCES [dbo].[oescode] ([oescode]) --GO --ALTER TABLE [dbo].[matxoes] CHECK CONSTRAINT [FK_matxoes_oescode] --GO --DEPRECATED --CREATE TABLE [dbo].[matxsic]( -- [stfips] [char](2) NOT NULL, -- [matincode] [char](15) NOT NULL, -- [periodid] [char](2) NOT NULL, -- [siccode] [char](4) NOT NULL, -- [subtot] [char](1) NULL, -- CONSTRAINT [PK_MATXsic] PRIMARY KEY CLUSTERED --( -- [stfips] ASC, -- [matincode] ASC, -- [periodid] ASC, -- [siccode] 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 --ALTER TABLE [dbo].[matxsic] WITH CHECK ADD CONSTRAINT [FK_matxsic_inddir] FOREIGN KEY([stfips], [matincode], [periodid]) --REFERENCES [dbo].[inddir] ([stfips], [matincode], [periodid]) --GO --ALTER TABLE [dbo].[matxsic] CHECK CONSTRAINT [FK_matxsic_inddir] --GO --ALTER TABLE [dbo].[matxsic] WITH CHECK ADD CONSTRAINT [FK_matxsic_indsub] FOREIGN KEY([stfips], [subtot]) --REFERENCES [dbo].[indsub] ([stfips], [subtot]) --GO --ALTER TABLE [dbo].[matxsic] CHECK CONSTRAINT [FK_matxsic_indsub] --GO --ALTER TABLE [dbo].[matxsic] WITH CHECK ADD CONSTRAINT [FK_matxsic_siccode] FOREIGN KEY([siccode]) --REFERENCES [dbo].[siccode] ([siccode]) --GO --ALTER TABLE [dbo].[matxsic] CHECK CONSTRAINT [FK_matxsic_siccode] --GO CREATE TABLE [dbo].[clsxproj]( [stfips] [char](2) NOT NULL, [areatype] [char](2) NOT NULL, [area] [char](6) NOT NULL, [cluscode] [char](10) NOT NULL, [occodetype] [char](2) NOT NULL, [occcode] [char](10) NOT NULL, [alloc] [numeric](5, 2) NULL, CONSTRAINT [PK_CLSXPROJ] PRIMARY KEY CLUSTERED ( [stfips] ASC, [areatype] ASC, [area] ASC, [cluscode] ASC, [occodetype] ASC, [occcode] 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 ALTER TABLE [dbo].[clsxproj] WITH CHECK ADD CONSTRAINT [FK_CLSXPROJ_CLUSCODE] FOREIGN KEY([stfips], [cluscode]) REFERENCES [dbo].[cluscode] ([stfips], [cluscode]) GO ALTER TABLE [dbo].[clsxproj] CHECK CONSTRAINT [FK_CLSXPROJ_CLUSCODE] GO ALTER TABLE [dbo].[clsxproj] WITH CHECK ADD CONSTRAINT [FK_CLSXPROJ_GEOG] FOREIGN KEY([stfips], [areatype], [area]) REFERENCES [dbo].[geog] ([stfips], [areatype], [area]) GO ALTER TABLE [dbo].[clsxproj] CHECK CONSTRAINT [FK_CLSXPROJ_GEOG] GO ALTER TABLE [dbo].[clsxproj] WITH CHECK ADD CONSTRAINT [FK_CLSXPROJ_OCCCODES] FOREIGN KEY([stfips], [occodetype], [occcode]) REFERENCES [dbo].[occcodes] ([stfips], [CODETYPE], [CODE]) GO ALTER TABLE [dbo].[clsxproj] CHECK CONSTRAINT [FK_CLSXPROJ_OCCCODES] GO CREATE TABLE [dbo].[clsxsupl]( [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, [cluscode] [char](10) NOT NULL, [codetype] [char](2) NOT NULL, [code] [char](10) NOT NULL, [compltype] [char](2) NOT NULL, CONSTRAINT [PK_CLSXSUPL] PRIMARY KEY CLUSTERED ( [stfips] ASC, [areatype] ASC, [area] ASC, [periodyear] ASC, [periodtype] ASC, [period] ASC, [cluscode] ASC, [codetype] ASC, [code] ASC, [compltype] 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 ALTER TABLE [dbo].[clsxsupl] WITH CHECK ADD CONSTRAINT [FK_CLSXSUPL_CLUSCODE] FOREIGN KEY([stfips], [cluscode]) REFERENCES [dbo].[cluscode] ([stfips], [cluscode]) GO ALTER TABLE [dbo].[clsxsupl] CHECK CONSTRAINT [FK_CLSXSUPL_CLUSCODE] GO ALTER TABLE [dbo].[clsxsupl] WITH CHECK ADD CONSTRAINT [FK_CLSXSUPL_COMPLTYP] FOREIGN KEY([stfips], [compltype]) REFERENCES [dbo].[compltyp] ([stfips], [compltype]) GO ALTER TABLE [dbo].[clsxsupl] CHECK CONSTRAINT [FK_CLSXSUPL_COMPLTYP] GO ALTER TABLE [dbo].[clsxsupl] WITH CHECK ADD CONSTRAINT [FK_CLSXSUPL_GEOG] FOREIGN KEY([stfips], [areatype], [area]) REFERENCES [dbo].[geog] ([stfips], [areatype], [area]) GO ALTER TABLE [dbo].[clsxsupl] CHECK CONSTRAINT [FK_CLSXSUPL_GEOG] GO ALTER TABLE [dbo].[clsxsupl] WITH CHECK ADD CONSTRAINT [FK_CLSXSUPL_OCCCODES] FOREIGN KEY([stfips], [codetype], [code]) REFERENCES [dbo].[occcodes] ([stfips], [CODETYPE], [CODE]) GO ALTER TABLE [dbo].[clsxsupl] CHECK CONSTRAINT [FK_CLSXSUPL_OCCCODES] GO ALTER TABLE [dbo].[clsxsupl] WITH CHECK ADD CONSTRAINT [FK_CLSXSUPL_PERIOD] FOREIGN KEY([periodyear], [periodtype], [period]) REFERENCES [dbo].[period] ([periodyear], [periodtype], [period]) GO ALTER TABLE [dbo].[clsxsupl] CHECK CONSTRAINT [FK_CLSXSUPL_PERIOD] GO --DEPRECATED --CREATE TABLE [dbo].[clusxpath]( -- [clustercode] [char](2) NOT NULL, -- [pathcode] [char](4) NOT NULL, -- CONSTRAINT [PK_CLUSXPATH] PRIMARY KEY CLUSTERED --( -- [clustercode] ASC, -- [pathcode] 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 --ALTER TABLE [dbo].[clusxpath] WITH CHECK ADD CONSTRAINT [FK_CLUSXPATH_CAREERCLUST] FOREIGN KEY([clustercode]) --REFERENCES [dbo].[careerclust] ([clustercode]) --GO --ALTER TABLE [dbo].[clusxpath] CHECK CONSTRAINT [FK_CLUSXPATH_CAREERCLUST] --GO --ALTER TABLE [dbo].[clusxpath] WITH CHECK ADD CONSTRAINT [FK_CLUSXPATH_CAREERPATHS] FOREIGN KEY([pathcode]) --REFERENCES [dbo].[careerpaths] ([pathcode]) --GO --ALTER TABLE [dbo].[clusxpath] CHECK CONSTRAINT [FK_CLUSXPATH_CAREERPATHS] --GO --DEPRECATED --CREATE TABLE [dbo].[clusxcip]( -- [stfips] [char](2) NOT NULL, -- [codetype] [char](2) NOT NULL, -- [code] [char](10) NOT NULL, -- [clustercode] [char](2) NOT NULL, -- CONSTRAINT [PK_CLUSXCIP] PRIMARY KEY CLUSTERED --( -- [stfips] ASC, -- [codetype] ASC, -- [code] ASC, -- [clustercode] 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 --ALTER TABLE [dbo].[clusxcip] WITH CHECK ADD CONSTRAINT [FK_CLUSXCIP_CAREERCLUST] FOREIGN KEY([clustercode]) --REFERENCES [dbo].[careerclust] ([clustercode]) --GO --ALTER TABLE [dbo].[clusxcip] CHECK CONSTRAINT [FK_CLUSXCIP_CAREERCLUST] --GO --ALTER TABLE [dbo].[clusxcip] WITH CHECK ADD CONSTRAINT [FK_CLUSXCIP_OCCCODES] FOREIGN KEY([stfips], [codetype], [code]) --REFERENCES [dbo].[occcodes] ([stfips], [CODETYPE], [CODE]) --GO --ALTER TABLE [dbo].[clusxcip] CHECK CONSTRAINT [FK_CLUSXCIP_OCCCODES] --GO --DEPRECATED --CREATE TABLE [dbo].[dotxcip]( -- [dotcode] [char](9) NOT NULL, -- [cipcode] [char](10) NOT NULL, -- [cipcodetype] [char](2) NOT NULL, -- CONSTRAINT [PK_Dotxcip] PRIMARY KEY CLUSTERED --( -- [dotcode] ASC, -- [cipcode] ASC, -- [cipcodetype] 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 --ALTER TABLE [dbo].[dotxcip] WITH CHECK ADD CONSTRAINT [FK_dotxcip_dotcode] FOREIGN KEY([dotcode]) --REFERENCES [dbo].[dotcode] ([dotcode]) --GO --ALTER TABLE [dbo].[dotxcip] CHECK CONSTRAINT [FK_dotxcip_dotcode] --GO --DEPRECATED --CREATE TABLE [dbo].[oesxcens]( -- [oescode] [char](5) NOT NULL, -- [censcode] [char](4) NOT NULL, -- [codetype] [char](2) NOT NULL, -- CONSTRAINT [PK_oesxcens] PRIMARY KEY CLUSTERED --( -- [oescode] ASC, -- [censcode] ASC, -- [codetype] 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 --DEPRECATED --CREATE TABLE [dbo].[oesxcids]( -- [oescode] [char](5) NOT NULL, -- [cidscode] [char](9) NOT NULL, -- CONSTRAINT [PK_oesxcids] PRIMARY KEY CLUSTERED --( -- [oescode] ASC, -- [cidscode] 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 --DEPRECATED --CREATE TABLE [dbo].[oesxcip]( -- [oescode] [char](5) NOT NULL, -- [cipcode] [char](10) NOT NULL, -- [cipcodetype] [char](2) NOT NULL, -- CONSTRAINT [PK_oesxcip] PRIMARY KEY CLUSTERED --( -- [oescode] ASC, -- [cipcode] ASC, -- [cipcodetype] 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 --DEPRECATED --CREATE TABLE [dbo].[oesxdot]( -- [oescode] [char](5) NOT NULL, -- [dotcode] [char](9) NOT NULL, -- CONSTRAINT [PK_oesxdot] PRIMARY KEY CLUSTERED --( -- [oescode] ASC, -- [dotcode] 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 --DEPRECATED --CREATE TABLE [dbo].[sicxnaic]( -- [siccode] [char](4) NOT NULL, -- [naicscode] [char](6) NOT NULL, -- CONSTRAINT [PK_sicxnaic] PRIMARY KEY CLUSTERED --( -- [siccode] ASC, -- [naicscode] 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 --DEPRECATED --CREATE TABLE [dbo].[oesxonet]( -- [oescode] [char](5) NOT NULL, -- [onetcode] [char](8) NOT NULL, -- CONSTRAINT [PK_oesxonet] PRIMARY KEY CLUSTERED --( -- [oescode] ASC, -- [onetcode] 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 --OESXJOB --CREATE TABLE [dbo].[oesxjob]( -- [oescode] [char](5) NOT NULL, -- [jobfamily] [char](2) NOT NULL, -- CONSTRAINT [PK_oesxjob] PRIMARY KEY CLUSTERED --( -- [oescode] ASC, -- [jobfamily] 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].[laytxocc]( [stfips] [char](2) NOT NULL, [occodetype] [char](2) NOT NULL, [occcode] [char](10) NOT NULL, [laytlcode] [char](5) NOT NULL, CONSTRAINT [PK_LAYTXOCC] PRIMARY KEY CLUSTERED ( [stfips] ASC, [occodetype] ASC, [occcode] ASC, [laytlcode] 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 ALTER TABLE [dbo].[laytxocc] WITH CHECK ADD CONSTRAINT [FK_LAYTXOCC_LAYTITLE] FOREIGN KEY([laytlcode]) REFERENCES [dbo].[laytitle] ([laytlcode]) GO ALTER TABLE [dbo].[laytxocc] CHECK CONSTRAINT [FK_LAYTXOCC_LAYTITLE] GO ALTER TABLE [dbo].[laytxocc] WITH CHECK ADD CONSTRAINT [FK_LAYTXOCC_OCCCODES] FOREIGN KEY([stfips], [occodetype], [occcode]) REFERENCES [dbo].[occcodes] ([stfips], [CODETYPE], [CODE]) GO ALTER TABLE [dbo].[laytxocc] CHECK CONSTRAINT [FK_LAYTXOCC_OCCCODES] GO --CORE CREATE TABLE [dbo].[licxocc]( [stfips] [char](2) NOT NULL, [licenseid] [varchar](10) NOT NULL, [occodetype] [char](2) NOT NULL, [occcode] [char](10) NOT NULL, CONSTRAINT [PK_LICXOCC] PRIMARY KEY CLUSTERED ( [stfips] ASC, [licenseid] ASC, [occodetype] ASC, [occcode] 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 ALTER TABLE [dbo].[licxocc] WITH CHECK ADD CONSTRAINT [FK_LICXOCC_LICENSE] FOREIGN KEY([stfips], [licenseid]) REFERENCES [dbo].[license] ([stfips], [licenseid]) GO ALTER TABLE [dbo].[licxocc] CHECK CONSTRAINT [FK_LICXOCC_LICENSE] GO ALTER TABLE [dbo].[licxocc] WITH CHECK ADD CONSTRAINT [FK_LICXOCC_OCCCODES] FOREIGN KEY([stfips], [occodetype], [occcode]) REFERENCES [dbo].[occcodes] ([stfips], [CODETYPE], [CODE]) GO ALTER TABLE [dbo].[licxocc] CHECK CONSTRAINT [FK_LICXOCC_OCCCODES] GO ALTER TABLE [dbo].[licxocc] WITH CHECK ADD CONSTRAINT [FK_LICXOCC_STFIPSTB] FOREIGN KEY([stfips]) REFERENCES [dbo].[stfipstb] ([stfips]) GO ALTER TABLE [dbo].[licxocc] CHECK CONSTRAINT [FK_LICXOCC_STFIPSTB] GO --DEPRECATED --CREATE TABLE [dbo].[matxnaic]( -- [stfips] [char](2) NOT NULL, -- [matincode] [char](15) NOT NULL, -- [periodid] [char](2) NOT NULL, -- [naicscode] [char](6) NOT NULL, -- [subtot] [char](1) NULL, -- CONSTRAINT [PK_MATXnaic] PRIMARY KEY CLUSTERED --( -- [stfips] ASC, -- [matincode] ASC, -- [periodid] ASC, -- [naicscode] 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 --ALTER TABLE [dbo].[matxnaic] WITH CHECK ADD CONSTRAINT [FK_MATXnaic_inddir] FOREIGN KEY([stfips], [matincode], [periodid]) --REFERENCES [dbo].[inddir] ([stfips], [matincode], [periodid]) --GO --ALTER TABLE [dbo].[matxnaic] CHECK CONSTRAINT [FK_MATXnaic_inddir] --GO --ALTER TABLE [dbo].[matxnaic] WITH CHECK ADD CONSTRAINT [FK_MATXnaic_INDSUB] FOREIGN KEY([stfips], [subtot]) --REFERENCES [dbo].[indsub] ([stfips], [subtot]) --GO --ALTER TABLE [dbo].[matxnaic] CHECK CONSTRAINT [FK_MATXnaic_INDSUB] --GO --ALTER TABLE [dbo].[matxnaic] WITH CHECK ADD CONSTRAINT [FK_MATXnaic_naiccode] FOREIGN KEY([naicscode]) --REFERENCES [dbo].[naiccode] ([naicscode]) --GO --ALTER TABLE [dbo].[matxnaic] CHECK CONSTRAINT [FK_MATXnaic_naiccode] --GO --CORE CREATE TABLE [dbo].[matxind]( [stfips] [char](2) NOT NULL, [matincode] [char](15) NOT NULL, [periodid] [char](2) NOT NULL, [indcodetype] [char](2) NOT NULL, [indcode] [char](6) NOT NULL, [subtot] [char](1) NULL, CONSTRAINT [PK_MATXIND] PRIMARY KEY CLUSTERED ( [stfips] ASC, [matincode] ASC, [periodid] ASC, [indcodetype] ASC, [indcode] 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 ALTER TABLE [dbo].[matxind] WITH CHECK ADD CONSTRAINT [FK_MATXIND_INDCODES] FOREIGN KEY([stfips], [indcodetype], [indcode]) REFERENCES [dbo].[indcodes] ([stfips], [codetype], [code]) GO ALTER TABLE [dbo].[matxind] CHECK CONSTRAINT [FK_MATXIND_INDCODES] GO ALTER TABLE [dbo].[matxind] WITH CHECK ADD CONSTRAINT [FK_MATXIND_INDDIR] FOREIGN KEY([stfips], [matincode], [periodid]) REFERENCES [dbo].[inddir] ([stfips], [matincode], [periodid]) GO ALTER TABLE [dbo].[matxind] CHECK CONSTRAINT [FK_MATXIND_INDDIR] GO ALTER TABLE [dbo].[matxind] WITH CHECK ADD CONSTRAINT [FK_MATXIND_INDSUB] FOREIGN KEY([stfips], [subtot]) REFERENCES [dbo].[indsub] ([stfips], [subtot]) GO ALTER TABLE [dbo].[matxind] CHECK CONSTRAINT [FK_MATXIND_INDSUB] GO --CORE CREATE TABLE [dbo].[matxocc]( [stfips] [char](2) NOT NULL, [matoccode] [char](10) NOT NULL, [periodid] [char](2) NOT NULL, [occodetype] [char](2) NOT NULL, [occcode] [char](10) NOT NULL, [subtot] [char](1) NULL, CONSTRAINT [PK_MATXOCC] PRIMARY KEY CLUSTERED ( [stfips] ASC, [matoccode] ASC, [periodid] ASC, [occodetype] ASC, [occcode] 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 ALTER TABLE [dbo].[matxocc] WITH CHECK ADD CONSTRAINT [FK_MATXOCC_OCCCODES] FOREIGN KEY([stfips], [occodetype], [occcode]) REFERENCES [dbo].[occcodes] ([stfips], [CODETYPE], [CODE]) GO ALTER TABLE [dbo].[matxocc] CHECK CONSTRAINT [FK_MATXOCC_OCCCODES] GO ALTER TABLE [dbo].[matxocc] WITH CHECK ADD CONSTRAINT [FK_MATXOCC_OCCDIR] FOREIGN KEY([stfips], [matoccode], [periodid]) REFERENCES [dbo].[occdir] ([stfips], [matoccode], [periodid]) GO ALTER TABLE [dbo].[matxocc] CHECK CONSTRAINT [FK_MATXOCC_OCCDIR] GO ALTER TABLE [dbo].[matxocc] WITH CHECK ADD CONSTRAINT [FK_MATXOCC_OCCSUB] FOREIGN KEY([stfips], [subtot]) REFERENCES [dbo].[occsub] ([stfips], [subtot]) GO ALTER TABLE [dbo].[matxocc] CHECK CONSTRAINT [FK_MATXOCC_OCCSUB] GO --DEPRECATED --CREATE TABLE [dbo].[matxsoc]( -- [stfips] [char](2) NOT NULL, -- [matoccode] [char](10) NOT NULL, -- [periodid] [char](2) NOT NULL, -- [soccode] [char](6) NOT NULL, -- [subtot] [char](1) NULL, -- CONSTRAINT [PK_MATXsoc] PRIMARY KEY CLUSTERED --( -- [stfips] ASC, -- [matoccode] ASC, -- [periodid] ASC, -- [soccode] 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 --ALTER TABLE [dbo].[matxsoc] WITH CHECK ADD CONSTRAINT [FK_matxsoc_OCCDIR] FOREIGN KEY([stfips], [matoccode], [periodid]) --REFERENCES [dbo].[occdir] ([stfips], [matoccode], [periodid]) --GO --ALTER TABLE [dbo].[matxsoc] CHECK CONSTRAINT [FK_matxsoc_OCCDIR] --GO --ALTER TABLE [dbo].[matxsoc] WITH CHECK ADD CONSTRAINT [FK_matxsoc_OCCSUB] FOREIGN KEY([stfips], [subtot]) --REFERENCES [dbo].[occsub] ([stfips], [subtot]) --GO --ALTER TABLE [dbo].[matxsoc] CHECK CONSTRAINT [FK_matxsoc_OCCSUB] --GO --ALTER TABLE [dbo].[matxsoc] WITH CHECK ADD CONSTRAINT [FK_matxsoc_soccode] FOREIGN KEY([soccode]) --REFERENCES [dbo].[soccode] ([soccode]) --GO --ALTER TABLE [dbo].[matxsoc] CHECK CONSTRAINT [FK_matxsoc_soccode] --GO --CHANGES IN V2.8 CREATE TABLE [dbo].[mocxocc]( [stfips] [char](2) NOT NULL, [codetype] [char](2) NOT NULL, [code] [char](10) NOT NULL, [svc] [char](1) NOT NULL, [mpc] [char](1) NOT NULL, [status] [char](1) NOT NULL, [moccode] [char](10) NOT NULL, CONSTRAINT [PK_MOCxocc] PRIMARY KEY CLUSTERED ( [stfips] ASC, [codetype] ASC, [code] ASC, [svc] ASC, [mpc] ASC, [status] ASC, [moccode] 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 ALTER TABLE [dbo].[mocxocc] WITH CHECK ADD CONSTRAINT [FK_mocxocc_moccode] FOREIGN KEY([svc], [mpc], [status], [moccode]) REFERENCES [dbo].[moccode] ([svc], [mpc], [status], [moccode]) GO ALTER TABLE [dbo].[mocxocc] CHECK CONSTRAINT [FK_mocxocc_moccode] GO ALTER TABLE [dbo].[mocxocc] WITH CHECK ADD CONSTRAINT [FK_mocxocc_OCCCODES] FOREIGN KEY([stfips], [codetype], [code]) REFERENCES [dbo].[occcodes] ([stfips], [CODETYPE], [CODE]) GO ALTER TABLE [dbo].[mocxocc] CHECK CONSTRAINT [FK_mocxocc_OCCCODES] GO --DEPRECATED --CREATE TABLE [dbo].[oesxsoc]( -- [oescode] [char](5) NOT NULL, -- [soccode] [char](6) NOT NULL, -- [soccodetype] [char](2) NOT NULL, -- CONSTRAINT [PK_oesxsoc] PRIMARY KEY CLUSTERED --( -- [oescode] ASC, -- [soccode] ASC, -- [soccodetype] 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 --DEPRECATED --CREATE TABLE [dbo].[socxcens]( -- [stfips] [char](2) NOT NULL, -- [codetype] [char](2) NOT NULL, -- [code] [char](10) NOT NULL, -- [censcode] [char](4) NOT NULL, -- [censcodetype] [char](2) NOT NULL, -- CONSTRAINT [PK_socxcens] PRIMARY KEY CLUSTERED --( -- [stfips] ASC, -- [codetype] ASC, -- [code] ASC, -- [censcode] ASC, -- [censcodetype] 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 --DEPRECATED --CREATE TABLE [dbo].[socxcids]( -- [stfips] [char](2) NOT NULL, -- [codetype] [char](2) NOT NULL, -- [code] [char](10) NOT NULL, -- [cidscode] [char](9) NOT NULL, -- CONSTRAINT [PK_socxcids] PRIMARY KEY CLUSTERED --( -- [stfips] ASC, -- [codetype] ASC, -- [code] ASC, -- [cidscode] 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 --DEPRECATED --CREATE TABLE [dbo].[socxcip]( -- [stfips] [char](2) NOT NULL, -- [codetype] [char](2) NOT NULL, -- [code] [char](10) NOT NULL, -- [cipcode] [char](10) NOT NULL, -- [cipcodetype] [char](2) NOT NULL, -- CONSTRAINT [PK_socxcip] PRIMARY KEY CLUSTERED --( -- [stfips] ASC, -- [codetype] ASC, -- [code] ASC, -- [cipcode] ASC, -- [cipcodetype] 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 --DEPRECATED --CREATE TABLE [dbo].[socxdot]( -- [soccode] [char](6) NOT NULL, -- [soccodetype] [char](2) NOT NULL, -- [dotcode] [char](9) NOT NULL, -- CONSTRAINT [PK_socxdot] PRIMARY KEY CLUSTERED --( -- [soccode] ASC, -- [soccodetype] ASC, -- [dotcode] 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 --DEPRECATED --CREATE TABLE [dbo].[socxjob]( -- [soccode] [char](6) NOT NULL, -- [soccodetype] [char](2) NOT NULL, -- [jobfamily] [char](2) NOT NULL, -- CONSTRAINT [PK_SOCxjob] PRIMARY KEY CLUSTERED --( -- [soccode] ASC, -- [soccodetype] ASC, -- [jobfamily] 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 --DEPRECATED --CREATE TABLE [dbo].[socxonet]( -- [stfips] [char](2) NOT NULL, -- [codetype] [char](2) NOT NULL, -- [code] [char](10) NOT NULL, -- [onetcode] [char](8) NOT NULL, -- CONSTRAINT [PK_SOCxonet] PRIMARY KEY CLUSTERED --( -- [stfips] ASC, -- [codetype] ASC, -- [code] ASC, -- [onetcode] 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 --DEPRECATED --CREATE TABLE [dbo].[eeo1xcens]( -- [eeo1cat] [char](2) NOT NULL, -- [censcode] [char](4) NOT NULL, -- [censcodetype] [char](2) NOT NULL, -- CONSTRAINT [PK_EEOLABFAC] PRIMARY KEY CLUSTERED --( -- [eeo1cat] ASC, -- [censcode] ASC, -- [censcodetype] 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 --DEPRECATED --CREATE TABLE [dbo].[eeosxcens]( -- [eeostloc] [char](2) NOT NULL, -- [censcode] [char](4) NOT NULL, -- [censcodetype] [char](2) NOT NULL, -- CONSTRAINT [PK_eeosxcens] PRIMARY KEY CLUSTERED --( -- [eeostloc] ASC, -- [censcode] ASC, -- [censcodetype] 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 --ALTER TABLE [dbo].[eeosxcens] WITH CHECK ADD CONSTRAINT [FK_eeosxcens_eeostloc] FOREIGN KEY([eeostloc]) --REFERENCES [dbo].[eeostloc] ([eeostoc]) --GO --ALTER TABLE [dbo].[eeosxcens] CHECK CONSTRAINT [FK_eeosxcens_eeostloc] --GO --CREATE TABLE [dbo].[datasess]( -- [appl] [char](8) NOT NULL, -- [session] [varchar](32) NOT NULL, -- [sessdesc] [varchar](60) NULL, -- [suppavail] [char](1) NULL, -- CONSTRAINT [PK_DATASESS] PRIMARY KEY CLUSTERED --( -- [appl] ASC, -- [session] 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].[source]( -- [stfips] [char](2) NOT NULL, -- [appl] [char](8) NOT NULL, -- [session] [varchar](32) NOT NULL, -- [source] [varchar](max) NULL, -- CONSTRAINT [PK_SOURCE] PRIMARY KEY CLUSTERED --( -- [stfips] ASC, -- [appl] ASC, -- [session] ASC --)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] --) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] --GO --ALTER TABLE [dbo].[source] WITH CHECK ADD CONSTRAINT [FK_SOURCE_DATASESS] FOREIGN KEY([appl], [session]) --REFERENCES [dbo].[datasess] ([appl], [session]) --GO --ALTER TABLE [dbo].[source] CHECK CONSTRAINT [FK_SOURCE_DATASESS] --GO --ALTER TABLE [dbo].[source] WITH CHECK ADD CONSTRAINT [FK_SOURCE_STFIPSTB] FOREIGN KEY([stfips]) --REFERENCES [dbo].[stfipstb] ([stfips]) --GO --ALTER TABLE [dbo].[source] CHECK CONSTRAINT [FK_SOURCE_STFIPSTB] --GO --CREATE TABLE [dbo].[maplist]( -- [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, -- [mapname] [varchar](32) NOT NULL, -- [mapdesc] [varchar](60) NULL, -- [mapimage] [image] NULL, -- CONSTRAINT [PK_MAPLIST] PRIMARY KEY CLUSTERED --( -- [stfips] ASC, -- [areatype] ASC, -- [area] ASC, -- [periodyear] ASC, -- [periodtype] ASC, -- [period] ASC, -- [mapname] ASC --)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] --) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] --GO --ALTER TABLE [dbo].[maplist] WITH CHECK ADD CONSTRAINT [FK_MAPLIST_GEOG] FOREIGN KEY([stfips], [areatype], [area]) --REFERENCES [dbo].[geog] ([stfips], [areatype], [area]) --GO --ALTER TABLE [dbo].[maplist] CHECK CONSTRAINT [FK_MAPLIST_GEOG] --GO --ALTER TABLE [dbo].[maplist] WITH CHECK ADD CONSTRAINT [FK_MAPLIST_PERIOD] FOREIGN KEY([periodyear], [periodtype], [period]) --REFERENCES [dbo].[period] ([periodyear], [periodtype], [period]) --GO --ALTER TABLE [dbo].[maplist] CHECK CONSTRAINT [FK_MAPLIST_PERIOD] --GO CREATE TABLE [dbo].[tabllist]( [tablename] [varchar](32) NOT NULL, [tabledesc] [varchar](60) NULL, [tabletype] [char](1) NULL, CONSTRAINT [PK_TABLLIST] PRIMARY KEY CLUSTERED ( [tablename] 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].[sesstabl]( -- [appl] [char](8) NOT NULL, -- [session] [varchar](32) NOT NULL, -- [tablename] [varchar](32) NOT NULL, -- CONSTRAINT [PK_SESSTABL] PRIMARY KEY CLUSTERED --( -- [appl] ASC, -- [session] ASC, -- [tablename] 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 --ALTER TABLE [dbo].[sesstabl] WITH CHECK ADD CONSTRAINT [FK_SESSTABL_DATASESS] FOREIGN KEY([appl], [session]) --REFERENCES [dbo].[datasess] ([appl], [session]) --GO --ALTER TABLE [dbo].[sesstabl] CHECK CONSTRAINT [FK_SESSTABL_DATASESS] --GO --ALTER TABLE [dbo].[sesstabl] WITH CHECK ADD CONSTRAINT [FK_SESSTABL_TABLLIST] FOREIGN KEY([tablename]) --REFERENCES [dbo].[tabllist] ([tablename]) --GO --ALTER TABLE [dbo].[sesstabl] CHECK CONSTRAINT [FK_SESSTABL_TABLLIST] --GO CREATE TABLE [dbo].[tablsrce]( [stfips] [char](2) NOT NULL, [tablename] [varchar](32) NOT NULL, [supplier] [varchar](60) NULL, [contact] [varchar](30) NULL, [telephone] [char](10) NULL, [teleext] [varchar](10) NULL, [lastupdate] [date] NULL, [nextupdate] [date] NULL, [filetype] [varchar](10) NULL, [info] [varchar](max) NULL, CONSTRAINT [PK_TABLSRCE] PRIMARY KEY CLUSTERED ( [stfips] ASC, [tablename] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO ALTER TABLE [dbo].[tablsrce] WITH CHECK ADD CONSTRAINT [FK_TABLSRCE_STFIPSTB] FOREIGN KEY([stfips]) REFERENCES [dbo].[stfipstb] ([stfips]) GO ALTER TABLE [dbo].[tablsrce] CHECK CONSTRAINT [FK_TABLSRCE_STFIPSTB] GO ALTER TABLE [dbo].[tablsrce] WITH CHECK ADD CONSTRAINT [FK_TABLSRCE_TABLLIST] FOREIGN KEY([tablename]) REFERENCES [dbo].[tabllist] ([tablename]) GO ALTER TABLE [dbo].[tablsrce] CHECK CONSTRAINT [FK_TABLSRCE_TABLLIST] GO