SQLize Online / PHPize Online  /  SQLtest Online

/****** Object: Table [dbo].[Circuit] Script Date: 5/15/2023 10:45:39 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Circuit]( [Id] [int] IDENTITY(1,1) NOT NULL, [ProjectID] [int] NOT NULL, [EQUIPSEQNO] [numeric](8, 0) NULL, [CIRCUITSEQNO] [numeric](8, 0) NULL, [UNITID] [varchar](50) NOT NULL, [EQUIPID] [varchar](50) NOT NULL, [EQHISTNO] [numeric](5, 0) NOT NULL, [CIRCUITID] [varchar](40) NOT NULL, [CIHISTNO] [numeric](5, 0) NOT NULL, [CLASS] [varchar](10) NULL, [CLASSBASIS] [varchar](50) NULL, [COMPLEXITY] [varchar](50) NULL, [CUIPOTENTL] [char](1) NULL, [DESCRIPT] [varchar](50) NULL, [DESIGNPRES] [numeric](5, 0) NULL, [DESIGNTEMP] [numeric](5, 0) NULL, [ENVIRONMNT] [varchar](50) NULL, [ESTRPRTIME] [numeric](4, 1) NULL, [EXTRATE] [numeric](9, 5) NULL, [INSCOND] [varchar](50) NULL, [FlowOrder] [numeric](9, 6) NULL, [INSULATION] [varchar](50) NULL, [INTCTL1] [varchar](50) NULL, [INTCTL2] [varchar](50) NULL, [LIFEBASIS] [varchar](50) NULL, [MATERIAL] [varchar](50) NULL, [MAXINSPINT] [numeric](5, 0) NULL, [MDMTEMP] [numeric](5, 0) NULL, [NOTES] [varchar](4000) NULL, [OPERATPRES] [numeric](9, 4) NULL, [OPERATTEMP] [numeric](4, 0) NULL, [OPERTMPOUT] [numeric](5, 0) NULL, [PLANDATE] [datetime] NULL, [PWHT] [char](1) NULL, [RBICURRATE] [varchar](50) NULL, [RBISTARTDT] [datetime] NULL, [RBISTAT] [varchar](50) NULL, [RBIDESC] [varchar](255) NULL, [RBIINSPINT] [numeric](5, 0) NULL, [REDRPRRAT] [numeric](5, 0) NULL, [RELQTY] [numeric](10, 2) NULL, [RSECURTYUS] [varchar](50) NULL, [SERVICE] [varchar](50) NULL, [SUGGRATE] [numeric](8, 5) NULL, [SUGRATEBAS] [varchar](25) NULL, [SYSTEMID] [varchar](50) NULL, [TMINCALC] [varchar](10) NULL, [USECORRALL] [char](1) NULL, [USEFORMULA] [char](1) NULL, [USERBI] [char](1) NULL, [USETABLE] [char](1) NULL, [USETMIN] [char](1) NULL, [PHVALUE] [numeric](3, 1) NULL, [CALCLEVEL] [varchar](50) NULL, [COMPMASTER] [varchar](50) NULL, [FLUIDSTATE] [varchar](15) NULL, [FLOWVELOC] [numeric](7, 2) NULL, [HEATTRACE] [char](1) NULL, [INJECTION] [char](1) NULL, [PIPINGSPEC] [varchar](50) NULL, [SOILAIR] [char](1) NULL, [SUBMERGEYN] [char](1) NULL, [SYSGOVERN] [varchar](50) NULL, [USEUNITSD] [char](1) NULL, [VAPLIQRAT] [numeric](7, 4) NULL, [VIBSUSYN] [char](1) NULL, [WDJTSTREFT] [numeric](3, 2) NULL, [PIPEPENYN] [char](1) NULL, [MONITOR] [varchar](50) NULL, [DEADLEG] [char](1) NULL, [CYCLIC] [char](1) NULL, [HCMIXPOINT] [char](1) NULL, [HITEMPSULF] [char](1) NULL, [HUMANHAZRD] [char](1) NULL, [HYDROMATYN] [char](1) NULL, [AUTOIGNITE] [varchar](1) NULL, [AIRH2OYN] [varchar](1) NULL, [BURIEDYN] [varchar](1) NULL, [MAL_ID] [int] NULL, [FLODD100YR] [varchar](1) NULL, [FLOOD50YR] [varchar](1) NULL, [ADJCNHTRSY] [varchar](1) NULL, [ALUSHITMRT] [varchar](50) NULL, [BACKFLLTYP] [varchar](50) NULL, [BASEBASIS] [varchar](50) NULL, [BASEPOF] [float] NULL, [BASEPBR] [varchar](50) NULL, [BASERKAMT] [numeric](12, 2) NULL, [BASERRK] [varchar](50) NULL, [BLCPWDPRSN] [varchar](1) NULL, [CSDCRSSNGS] [varchar](50) NULL, [CTHDPRTCTN] [varchar](50) NULL, [CQAMT] [numeric](12, 2) NULL, [CQBASIS] [varchar](50) NULL, [CQRANK] [varchar](50) NULL, [CRRSNINHBT] [varchar](50) NULL, [CRITICALIT] [varchar](50) NULL, [CRITCALCYN] [varchar](1) NULL, [CURRBASIS] [varchar](50) NULL, [CURRPOF] [float] NULL, [CURRPBR] [varchar](50) NULL, [CURRRKAMT] [numeric](12, 2) NULL, [CURRRRK] [varchar](50) NULL, [DLTTRGGACT] [varchar](6) NULL, [DEPTHOCOVR] [numeric](6, 3) NULL, [DESIGNFCTR] [varchar](50) NULL, [DESISTRESS] [numeric](7, 1) NULL, [ERLYSHRTRT] [varchar](50) NULL, [ERLSHRRTRD] [datetime] NULL, [EARTHQUAKE] [varchar](1) NULL, [EARTHQKBSC] [varchar](25) NULL, [ELCTRCLISL] [varchar](50) NULL, [FAULTLINE] [varchar](1) NULL, [FLANGERAT] [numeric](9, 4) NULL, [FUTBASIS] [varchar](50) NULL, [FUTPOF] [float] NULL, [FUTPBR] [varchar](50) NULL, [FUTRISKAMT] [numeric](12, 2) NULL, [FUTRRK] [varchar](50) NULL, [FUTINSPBAS] [varchar](50) NULL, [FUTINSPPOF] [float] NULL, [FUTINSPPBR] [varchar](50) NULL, [FUTINSPAMT] [numeric](12, 2) NULL, [FUTINSPRRK] [varchar](50) NULL, [GEOTECH] [varchar](1) NULL, [GRWTOLPCT] [numeric](3, 0) NULL, [GRWTOLTHK] [numeric](6, 3) NULL, [H2RELEASQT] [numeric](7, 0) NULL, [HISTREASON] [varchar](4) NULL, [ACTOVRSUGG] [varchar](50) NULL, [INSTRGGACT] [varchar](50) NULL, [INTREXTRDS] [varchar](50) NULL, [LJOINTEFF] [numeric](3, 2) NULL, [LANDSLIDE] [varchar](1) NULL, [LOCATION] [numeric](2, 0) NULL, [LOCCLASS] [varchar](50) NULL, [LOCFACTRCI] [varchar](50) NULL, [LOSSTOLPCT] [numeric](3, 0) NULL, [LOSSTOLTHK] [numeric](6, 3) NULL, [MFGTOLRNCE] [numeric](7, 4) NULL, [MFGTOLRNOP] [varchar](1) NULL, [MINEXPOSE] [numeric](3, 2) NULL, [EQTRAFFIC] [varchar](50) NULL, [SOILPRES] [varchar](25) NULL, [RACONRANK] [varchar](50) NULL, [RARKRANK] [varchar](50) NULL, [RBICALCDT] [datetime] NULL, [CALCRBIYN] [varchar](1) NULL, [RBITARGDT] [datetime] NULL, [RCRITICLTY] [varchar](1000) NULL, [REACTMATYN] [varchar](1) NULL, [SLTCONDTNS] [varchar](50) NULL, [SOILSTRNGT] [varchar](25) NULL, [SUGSAFEFAC] [numeric](5, 2) NULL, [SYSGRPCODE] [varchar](50) NULL, [TARGRKVAL] [numeric](12, 2) NULL, [UPDTRGGACT] [varchar](6) NULL, [UTLTYCRSSN] [varchar](1) NULL, [CIRCSEQNO] [numeric](8, 0) NULL, [ADDDT] [datetime] NULL, [CHGDT] [datetime] NULL, [CIRSAFEFAC] [numeric](5, 2) NULL, [SAFEFACBAS] [varchar](3) NULL, [ERLRETTML] [varchar](40) NULL, [ERLRETDATE] [datetime] NULL, [ERLINSPTML] [varchar](40) NULL, [ERLINSDATE] [datetime] NULL, [ERRORSIGMA] [numeric](9, 5) NULL, [FRMADJRBAS] [varchar](3) NULL, [HALFLIFEDT] [datetime] NULL, [HLDATETML] [varchar](40) NULL, [HALFLIFINT] [numeric](3, 0) NULL, [HLINTTML] [varchar](40) NULL, [IDR] [numeric](5, 2) NULL, [LASTRDDATE] [datetime] NULL, [MXVOLLGRAT] [numeric](9, 5) NULL, [MXVOLSHRAT] [numeric](9, 5) NULL, [MAXLNGRATE] [numeric](9, 5) NULL, [MAXLNGRTPT] [varchar](40) NULL, [MAXSHORATE] [numeric](9, 5) NULL, [MAXSHORTPT] [varchar](40) NULL, [MAXAVRATIO] [numeric](5, 2) NULL, [MINCIRRATE] [numeric](9, 5) NULL, [NEEDRECALC] [varchar](1) NULL, [NOTMLS] [numeric](8, 0) NULL, [NOPMISCO] [numeric](8, 0) NULL, [NOGROWTHS] [numeric](8, 0) NULL, [NOHISTREC] [numeric](8, 0) NULL, [NOPMISNC] [numeric](8, 0) NULL, [NOPMIS] [numeric](8, 0) NULL, [NOPMISDE] [numeric](8, 0) NULL, [NOPMISWR] [numeric](8, 0) NULL, [NOPOSRATE] [numeric](8, 0) NULL, [NOZEROS] [numeric](8, 0) NULL, [PMIPCTCP] [numeric](3, 0) NULL, [PMIPCTCD] [numeric](3, 0) NULL, [RAPROBRANK] [varchar](1000) NULL, [RATESIGMA] [numeric](9, 5) NULL, [TMDSGNCHNG] [varchar](1) NULL, [RISKLEVEL] [numeric](5, 2) NULL, [RLSAFEFACT] [numeric](5, 2) NULL, [TOTCIREXP] [numeric](10, 3) NULL, [TOTCIRLOSS] [numeric](8, 3) NULL, [Becht_Notes] [varchar](4000) NULL, [Active] [bit] NOT NULL, [CreateDate] [datetime] NOT NULL, [timestamp] [timestamp] NULL, [Status_Becht] [varchar](55) NOT NULL, [Status_User] [varchar](50) NULL, [Status_Date] [datetime] NULL, [PID_Drawing] [varchar](255) NULL, [CALAVGRATE] [numeric](9, 5) NULL, [FRMADJRATE] [numeric](9, 5) NULL, [RepFluid_ID_FK] [int] NULL, [EquipLink] AS (((CONVERT([varchar](10),[ProjectID])+[UNITID])+[EQUIPID])+CONVERT([varchar](10),[EQHISTNO])) PERSISTED, [UnitLink] AS (CONVERT([varchar](10),[ProjectID])+[UNITID]) PERSISTED, [MAL_Comment] [varchar](255) NULL, CONSTRAINT [PK_Circuit] PRIMARY KEY CLUSTERED ( [ProjectID] ASC, [UNITID] ASC, [EQUIPID] ASC, [EQHISTNO] ASC, [CIRCUITID] ASC, [CIHISTNO] ASC )WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY], CONSTRAINT [IX_Circuit] UNIQUE NONCLUSTERED ( [Id] ASC )WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY], CONSTRAINT [IX_Circuit_MultipleKeys] UNIQUE NONCLUSTERED ( [ProjectID] ASC, [UNITID] ASC, [EQUIPID] ASC, [EQHISTNO] ASC, [CIRCUITID] ASC, [CIHISTNO] ASC )WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[circuit_consequence] Script Date: 5/15/2023 10:45:39 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[circuit_consequence]( [Id] [int] IDENTITY(1,1) NOT NULL, [ProjectID] [int] NOT NULL, [UNITID] [varchar](50) NOT NULL, [EQUIPID] [varchar](50) NOT NULL, [EQHISTNO] [numeric](5, 0) NOT NULL, [CIRCUITID] [varchar](40) NOT NULL, [CIHISTNO] [numeric](5, 0) NOT NULL, [NAME] [varchar](50) NOT NULL, [ACTUALAMT] [numeric](12, 2) NULL, [ACTUALBASS] [varchar](255) NULL, [BASECQR] [varchar](255) NULL, [AMOUNT] [numeric](12, 2) NULL, [BASIS] [varchar](255) NULL, [CONSEQ] [varchar](50) NULL, [CONSIDERTN] [varchar](50) NULL, [CURRCONS] [varchar](50) NULL, [FLUDPRPRTY] [varchar](255) NULL, [OVERRIDE] [varchar](1) NULL, [OVERRIDEAM] [numeric](12, 2) NULL, [OVERJUST] [varchar](255) NULL, [OVERUSER] [varchar](40) NULL, [RELEASEQTY] [numeric](10, 2) NULL, [CICQSEQNO] [numeric](8, 0) NULL, [PCMSOWNED] [varchar](1) NULL, [USEDINCALC] [varchar](1) NULL, [Active] [bit] NOT NULL, [CreateDate] [datetime] NOT NULL, [Timestamp] [timestamp] NULL, CONSTRAINT [PK_circuit_consequence] PRIMARY KEY CLUSTERED ( [ProjectID] ASC, [UNITID] ASC, [EQUIPID] ASC, [EQHISTNO] ASC, [CIRCUITID] ASC, [CIHISTNO] ASC, [NAME] ASC )WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[CML] Script Date: 5/15/2023 10:45:39 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[CML]( [Id] [int] IDENTITY(1,1) NOT NULL, [ProjectID] [int] NOT NULL, [UNITID] [varchar](50) NOT NULL, [EQUIPID] [varchar](50) NOT NULL, [EQHISTNO] [numeric](5, 0) NOT NULL, [CIRCUITID] [varchar](40) NOT NULL, [CIHISTNO] [numeric](5, 0) NOT NULL, [TMLID] [varchar](40) NOT NULL, [TMHISTNO] [numeric](5, 0) NOT NULL, [ACCESSMETH] [varchar](25) NULL, [CATEGORY] [varchar](8) NULL, [CMINSGDSEQ] [nvarchar](255) NULL, [COMPONENID] [varchar](40) NULL, [COUPONAREA] [numeric](9, 3) NULL, [COUPNACRRT] [numeric](9, 5) NULL, [COUPNCRRRT] [numeric](9, 5) NULL, [COUPNDNSTY] [numeric](6, 3) NULL, [CCORRCTNVL] [nvarchar](255) NULL, [CELECTRDTY] [nvarchar](255) NULL, [CMLTPLCTNF] [nvarchar](255) NULL, [CNTVPOTNTL] [nvarchar](255) NULL, [CREFRNCCTH] [nvarchar](255) NULL, [CUIACTUAL] [varchar](1) NULL, [CUIPOTENTL] [varchar](1) NULL, [DEADLEG] [varchar](1) NULL, [DESCRIPT] [varchar](50) NULL, [PPSCHEDLCD] [varchar](5) NULL, [DOCUMENTID] [varchar](16) NULL, [EVENTNO] [varchar](20) NULL, [EXPJOINT] [varchar](1) NULL, [EXTERNCORR] [varchar](1) NULL, [HCMIXPOINT] [varchar](1) NULL, [HEATTRACE] [varchar](1) NULL, [HISTREASON] [varchar](4) NULL, [INITLLOCTN] [nvarchar](255) NULL, [INTRTMPRTR] [nvarchar](255) NULL, [INTLUNCRRR] [nvarchar](255) NULL, [INJECTION] [varchar](1) NULL, [INSULATION] [varchar](50) NULL, [INTERNAL] [varchar](1) NULL, [INTCTL1] [varchar](50) NULL, [INTCTL2] [varchar](50) NULL, [INTCTL3] [varchar](50) NULL, [JOINTEFF] [numeric](3, 2) NULL, [REPLACDATE] [datetime] NULL, [LTSTLOCATN] [nvarchar](255) NULL, [LTRTEMPRTR] [nvarchar](255) NULL, [LTSUNCRRCR] [nvarchar](255) NULL, [LATITUDETM] [numeric](8, 6) NULL, [LINENO] [varchar](25) NULL, [LONGITUDTM] [numeric](9, 6) NULL, [RETLIMMAN] [numeric](6, 3) NULL, [RETBASMAN] [varchar](50) NULL, [MSTRSCHDLR] [varchar](20) NULL, [MATERIAL] [varchar](50) NULL, [MAXINTERVL] [numeric](3, 0) NULL, [MEASURE] [numeric](12, 2) NULL, [NOMINAL] [numeric](6, 3) NULL, [NOTES] [varchar](2500) NULL, [ORGCORALOW] [numeric](6, 3) NULL, [BASEREPLDT] [datetime] NULL, [OVRDCITMIN] [varchar](1) NULL, [OVRRIDEDT] [datetime] NULL, [OVRRIDEDSC] [varchar](255) NULL, [OVRREAS] [varchar](10) NULL, [PIDDRAWING] [varchar](40) NULL, [PARTTYPE] [varchar](20) NULL, [PIPESCHED] [varchar](10) NULL, [PIPESIZE] [numeric](6, 2) NULL, [PRVLOCATIN] [varchar](5) NULL, [PRTEMPERTR] [numeric](4, 0) NULL, [PRUNCRRCTR] [numeric](6, 3) NULL, [RDTEMPLATH] [nvarchar](255) NULL, [REPLNEXTTA] [varchar](1) NULL, [REPLCOUNT] [numeric](3, 0) NULL, [REQINSMETH] [varchar](1) NULL, [RLMTMANLST] [varchar](1) NULL, [USETMINMAN] [varchar](1) NULL, [TMTOLRNCAL] [nvarchar](255) NULL, [ROUTE] [numeric](16, 0) NULL, [SCHNXTRDDT] [datetime] NULL, [SCHREPLDAT] [datetime] NULL, [SKETCHID] [varchar](255) NULL, [SLEEVED] [varchar](1) NULL, [SOILAIR] [varchar](1) NULL, [SPECINSTR] [varchar](255) NULL, [SPECPROCHR] [varchar](50) NULL, [SPECIFMATL] [nvarchar](255) NULL, [SPECIFMATL_MATLGRADE] [nvarchar](255) NULL, [SPECIFMATL_NAME] [nvarchar](255) NULL, [TAPLANNING] [varchar](50) NULL, [TEMPREP] [varchar](1) NULL, [THREADED] [varchar](1) NULL, [USEB31G] [varchar](1) NULL, [USEDMGRDYN] [varchar](1) NULL, [USETMINCA] [varchar](1) NULL, [USETMINFRM] [varchar](1) NULL, [USETMINTBL] [varchar](1) NULL, [VALVEORFIT] [varchar](1) NULL, [TMLSEQNO] [numeric](8, 0) NULL, [HALFLIFEDT] [datetime] NULL, [QTRLIFEDT] [datetime] NULL, [THQTLIFEDT] [datetime] NULL, [ADDDT] [datetime] NULL, [CALCINSPDT] [datetime] NULL, [CALCINSPBS] [nvarchar](255) NULL, [CHGDT] [datetime] NULL, [NEEDRECALC] [varchar](1) NULL, [DESGNSTRSS] [numeric](7, 1) NULL, [DSGNSTRSBS] [varchar](100) NULL, [ESTTHICK] [nvarchar](255) NULL, [ESTTHCKBAS] [nvarchar](255) NULL, [FULLLIFEDT] [datetime] NULL, [FIRSTQA] [nvarchar](255) NULL, [FIRSTDATE] [datetime] NULL, [FIRSTINSP] [nvarchar](255) NULL, [FIRSTMETH] [nvarchar](255) NULL, [FIRSTREAD] [varchar](50) NULL, [LATESTB31G] [nvarchar](255) NULL, [LTCPIPSTR] [nvarchar](255) NULL, [LTCCCSEQNO] [nvarchar](255) NULL, [LATESTCORR] [nvarchar](255) NULL, [LTDMGFTSQN] [nvarchar](255) NULL, [LTINSPRSQN] [nvarchar](255) NULL, [LTPITDEPTH] [nvarchar](255) NULL, [LASTQA] [varchar](1) NULL, [LASTDATE] [datetime] NULL, [LASTINSP] [varchar](40) NULL, [LASTMETH] [varchar](1) NULL, [LASTREAD] [nvarchar](255) NULL, [LTWLLOSPCT] [nvarchar](255) NULL, [LONGRATE] [numeric](9, 5) NULL, [RETIREDATE] [datetime] NULL, [RETDATEBAS] [nvarchar](255) NULL, [MAWP] [numeric](9, 4) NULL, [MAWPBASIS] [varchar](50) NULL, [INSPECDATE] [datetime] NULL, [INSDATEBAS] [varchar](3) NULL, [NOREADINGS] [numeric](8, 0) NULL, [OVRRIDEUSR] [varchar](40) NULL, [PREVQA] [varchar](1) NULL, [PREVDATE] [datetime] NULL, [PREVINSP] [varchar](40) NULL, [PREVMETH] [varchar](1) NULL, [PREVREAD] [numeric](6, 3) NULL, [LNRTREDNG1] [nvarchar](255) NULL, [SHRRTRDNG1] [nvarchar](255) NULL, [LONGRATED2] [nvarchar](255) NULL, [LNRTHCKNS2] [nvarchar](255) NULL, [SHORTRATD2] [nvarchar](255) NULL, [SHRTHCKNS2] [nvarchar](255) NULL, [RETLMTB31] [numeric](6, 3) NULL, [RETBASCA] [varchar](100) NULL, [RETBASFRM] [varchar](100) NULL, [RETBASTBL] [varchar](100) NULL, [RETLIMCA] [numeric](6, 3) NULL, [RETLIMFRM] [numeric](6, 3) NULL, [RETLIMTBL] [nvarchar](255) NULL, [RETLIMIT] [numeric](6, 3) NULL, [RETLIMBAS] [varchar](50) NULL, [TMDSGNCHNG] [nvarchar](255) NULL, [RETLIMSTAT] [varchar](2) NULL, [RFFCIRCID] [nvarchar](255) NULL, [RFFCMLID] [nvarchar](255) NULL, [SHORTRATE] [numeric](9, 5) NULL, [SHRTRETDAT] [datetime] NULL, [USRTFMHINO] [nvarchar](255) NULL, [VOLLONGRAT] [numeric](9, 5) NULL, [VOLSHRTRAT] [numeric](9, 5) NULL, [ERETDATE] [datetime] NULL, [ERETDATBAS] [varchar](3) NULL, [Timestamp] [timestamp] NULL, [Active] [bit] NOT NULL, [CreateDate] [datetime] NOT NULL, CONSTRAINT [PK_CML] PRIMARY KEY CLUSTERED ( [ProjectID] ASC, [UNITID] ASC, [EQUIPID] ASC, [EQHISTNO] ASC, [CIRCUITID] ASC, [CIHISTNO] ASC, [TMLID] ASC, [TMHISTNO] ASC )WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY], CONSTRAINT [IX_CML] UNIQUE NONCLUSTERED ( [Id] ASC )WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[COMPONENT] Script Date: 5/15/2023 10:45:39 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[COMPONENT]( [Id] [int] IDENTITY(1,1) NOT NULL, [ProjectID] [int] NOT NULL, [UNITID] [varchar](50) NOT NULL, [EQUIPID] [varchar](50) NOT NULL, [EQHISTNO] [numeric](5, 0) NOT NULL, [COMPONENID] [varchar](40) NULL, [COHISTNO] [numeric](5, 0) NOT NULL, [PIDDRAWING] [varchar](40) NULL, [ACCESSMETH] [varchar](25) NULL, [ADJPLTTHCK] [varchar](500) NULL, [COALTREGNO] [varchar](500) NULL, [AMBSTRESS] [varchar](500) NULL, [AMBSTRBSIS] [varchar](500) NULL, [COAMPERE] [varchar](500) NULL, [APEXANGLE] [varchar](500) NULL, [ASSETCOM] [varchar](500) NULL, [ASSETNO] [varchar](500) NULL, [ATTACHFACT] [varchar](500) NULL, [AVGTHICK] [numeric](6, 3) NULL, [COINIBBRDS] [varchar](500) NULL, [COINOBBRDS] [varchar](500) NULL, [COOUTIBBRD] [varchar](500) NULL, [COOUTOBBRD] [varchar](500) NULL, [BOLTED] [varchar](500) NULL, [BUYNCYANCH] [varchar](500) NULL, [CLADMATERL] [varchar](500) NULL, [CLADINSTDT] [varchar](500) NULL, [CLADPRESNT] [varchar](500) NULL, [CLADSPCMTL] [varchar](500) NULL, [CLADTHICK] [varchar](500) NULL, [CLEANMETH] [varchar](500) NULL, [COATING] [varchar](500) NULL, [COILAREA] [varchar](500) NULL, [DEPTH] [varchar](500) NULL, [LENGTH] [varchar](500) NULL, [COMPMASTER] [varchar](50) NULL, [ORIENT] [varchar](500) NULL, [COLENGTH] [varchar](500) NULL, [CONCRTJCKT] [varchar](500) NULL, [MINTENSTR] [varchar](500) NULL, [MINYLDSTR] [varchar](500) NULL, [COURSENO] [varchar](500) NULL, [RIVETED] [varchar](500) NULL, [CRITICALIT] [varchar](500) NULL, [CRITCALCYN] [varchar](500) NULL, [CROWNIRAD] [varchar](500) NULL, [CROWNORAD] [varchar](500) NULL, [COBUILDDT] [datetime] NULL, [DESCRIPT] [varchar](500) NULL, [DESIGNFCTR] [varchar](500) NULL, [SYSGOVERN] [varchar](500) NULL, [DINTEMP] [varchar](500) NULL, [DOUTTEMP] [varchar](500) NULL, [CODESIGNP] [varchar](500) NULL, [CODESNRPM] [varchar](500) NULL, [STRESBASIS] [varchar](500) NULL, [CODESIGNT] [varchar](500) NULL, [CODRAINTYP] [varchar](500) NULL, [DUTYCYCLE] [varchar](500) NULL, [EPZRADIUS] [varchar](500) NULL, [ENVIRONMEN] [varchar](500) NULL, [EXCAVTNDMG] [varchar](500) NULL, [EXTCOATDT] [varchar](500) NULL, [EXTCOATTHK] [varchar](500) NULL, [FABRICATNT] [varchar](500) NULL, [FLDJNTPRMR] [varchar](500) NULL, [FILDJONTTY] [varchar](500) NULL, [FIREPROOF] [varchar](500) NULL, [FLAMEOUT] [varchar](500) NULL, [FLANGECLAS] [varchar](500) NULL, [FLANGERAT] [numeric](9, 4) NULL, [FLANGEBAS] [varchar](500) NULL, [FLANGEMATL] [varchar](500) NULL, [FLOWCOAT] [varchar](500) NULL, [FOLLOWNGWL] [varchar](500) NULL, [FULLVAC] [varchar](500) NULL, [FNCTNIMPRT] [varchar](500) NULL, [GASKTBLTLD] [varchar](500) NULL, [GASKMOMARM] [varchar](500) NULL, [COGRRATIO] [varchar](500) NULL, [GOVERNCODE] [varchar](500) NULL, [HMINORAXIS] [varchar](500) NULL, [HEADGEOM] [varchar](500) NULL, [HDRBXINHGT] [varchar](500) NULL, [HDRBXINWDT] [varchar](500) NULL, [HEATNUMBER] [varchar](500) NULL, [HEATTRACE] [varchar](500) NULL, [COMPHEIGHT] [varchar](500) NULL, [HISTREASON] [varchar](500) NULL, [COHORSEPWR] [varchar](500) NULL, [HYDROPRESS] [varchar](500) NULL, [HYDROTEMP] [varchar](500) NULL, [ILILNYN] [varchar](500) NULL, [INLETPRES] [varchar](500) NULL, [INLETTEMP] [varchar](500) NULL, [COINGRSPD] [varchar](500) NULL, [INSERVDT] [datetime] NULL, [INNERDIAM] [varchar](500) NULL, [INSTALLDAT] [datetime] NULL, [COINSCLASS] [varchar](500) NULL, [INSULDT] [varchar](500) NULL, [INSULDEN] [varchar](500) NULL, [INSULTHK] [varchar](500) NULL, [INSULATION] [varchar](500) NULL, [COINTRSHSP] [varchar](500) NULL, [INTCTL1] [varchar](50) NULL, [INTCTL2] [varchar](50) NULL, [INTCTL3] [varchar](50) NULL, [INVCTRL] [varchar](500) NULL, [JOINTEFF] [numeric](3, 2) NULL, [KNUCKLERAD] [varchar](500) NULL, [LATITUDECO] [varchar](500) NULL, [LINEFROM] [varchar](500) NULL, [LINETO] [varchar](500) NULL, [LINMATERL] [varchar](500) NULL, [LINGINSTDT] [varchar](500) NULL, [LINPRESENT] [varchar](500) NULL, [LINSPECMTL] [varchar](500) NULL, [LINTHICK] [varchar](500) NULL, [LOCCLASS] [varchar](500) NULL, [LOCFACTRCO] [varchar](500) NULL, [LONGITUDCO] [varchar](500) NULL, [COLUBTEYPE] [varchar](500) NULL, [OSRESOURCE] [varchar](500) NULL, [COMATERIAL] [varchar](500) NULL, [MAWP] [numeric](9, 4) NULL, [MAWPLTD] [varchar](500) NULL, [MAWT] [numeric](4, 0) NULL, [MAXSTRESS] [varchar](500) NULL, [MDMTEMP] [numeric](4, 0) NULL, [MDWTEMP] [varchar](500) NULL, [MCHNCLCPLR] [varchar](500) NULL, [MCRBLGCLCR] [varchar](500) NULL, [MINALTHSTS] [varchar](500) NULL, [MODELNO] [varchar](500) NULL, [COMTRFRMDS] [varchar](500) NULL, [NOPASS] [varchar](500) NULL, [NOTUBEPLGD] [varchar](500) NULL, [NOTUBES] [varchar](500) NULL, [NOTES] [varchar](2500) NULL, [CONOLUBPNT] [varchar](500) NULL, [CONOPHASES] [varchar](500) NULL, [CONOSHAFTS] [varchar](500) NULL, [ONPADFLAG] [varchar](500) NULL, [OPERATPRES] [numeric](9, 4) NULL, [COOPRPM] [varchar](500) NULL, [OPERATSTAT] [varchar](500) NULL, [OPERATTEMP] [numeric](4, 0) NULL, [ORIGMFGFOR] [varchar](500) NULL, [ORGCORALOW] [numeric](6, 3) NULL, [ORIGTHICK] [varchar](500) NULL, [OUTERDIAM] [numeric](8, 3) NULL, [OUTLETPRES] [varchar](500) NULL, [OUTLETTEMP] [varchar](500) NULL, [COOUTGRSPD] [varchar](500) NULL, [OVERRDASTR] [varchar](500) NULL, [OVERFLANGE] [varchar](500) NULL, [OVRDSTRESS] [varchar](500) NULL, [PARENTCOMP] [varchar](500) NULL, [PIGTYPE] [varchar](500) NULL, [PIGBLELN] [varchar](500) NULL, [PILOTFUEL] [varchar](500) NULL, [PIPESPEC] [varchar](16) NULL, [PRESSRBLLD] [varchar](500) NULL, [PREVIOSWLD] [varchar](500) NULL, [SERVICE] [varchar](50) NULL, [PWHT] [varchar](500) NULL, [RACONRANK] [varchar](500) NULL, [RARKRANK] [varchar](500) NULL, [RCRITICLTY] [varchar](500) NULL, [RCMRANK] [varchar](500) NULL, [RRNCALCLTD] [varchar](500) NULL, [REGISTRNO] [varchar](500) NULL, [REGULARHED] [varchar](500) NULL, [USERRESP] [varchar](500) NULL, [SERIALNO] [varchar](500) NULL, [SRVCCONDTN] [varchar](500) NULL, [SOSRVFCDSN] [varchar](500) NULL, [SHELLENGTH] [varchar](500) NULL, [COMPSIZE] [varchar](500) NULL, [SPECMATL] [varchar](500) NULL, [SPECMATL_MATLGRADE] [varchar](500) NULL, [SPECMATL_NAME] [varchar](500) NULL, [STRTFOOTGE] [varchar](500) NULL, [STATIONNGE] [varchar](500) NULL, [STATINNGST] [varchar](500) NULL, [STCOMPOSTN] [varchar](500) NULL, [STOPFOOTGE] [varchar](500) NULL, [STORVOL] [numeric](10, 2) NULL, [STYLE] [varchar](500) NULL, [SUPPTYPE] [varchar](50) NULL, [SYSHDBXCMP] [varchar](500) NULL, [SYSTEMID] [varchar](50) NULL, [TMINDMNSEQ] [varchar](500) NULL, [TNKROOFTYP] [varchar](500) NULL, [SEALTYPE] [varchar](500) NULL, [TKSECSEAL] [varchar](500) NULL, [TEMPCOEFNT] [varchar](500) NULL, [TESTMED] [varchar](500) NULL, [THKFTEXTEN] [varchar](500) NULL, [TUBEFUNC] [varchar](500) NULL, [TUBEGAUGE] [varchar](500) NULL, [TUBELENGTH] [varchar](500) NULL, [TUBEPITCH] [varchar](500) NULL, [TUBSIDPRES] [varchar](500) NULL, [TUBSIDTEMP] [varchar](500) NULL, [U1ONFILE] [varchar](500) NULL, [UNDERWATYN] [varchar](500) NULL, [VEHICLDAMG] [varchar](500) NULL, [COVOLTAGE] [varchar](500) NULL, [WGTEMPTY] [varchar](500) NULL, [WGTFULL] [varchar](500) NULL, [WDJTSTREFT] [numeric](3, 2) NULL, [WLDNGPRCSS] [varchar](500) NULL, [WELDINGTYP] [varchar](500) NULL, [COMPSEQNO] [numeric](8, 0) NULL, [ADDDT] [datetime] NULL, [CHGDT] [datetime] NULL, [MAXHYDROHT] [varchar](500) NULL, [MAXPRODHT] [varchar](500) NULL, [NOTMLS] [numeric](8, 0) NULL, [RAPROBRANK] [varchar](500) NULL, [RETLIMIT] [numeric](6, 3) NULL, [BechtNotes] [varchar](1500) NULL, [Timestamp] [timestamp] NULL, [Active] [bit] NOT NULL, [CreateDate] [datetime] NOT NULL, [EquipLink] AS (((CONVERT([varchar](10),[ProjectID])+[UNITID])+[EQUIPID])+CONVERT([varchar](10),[EQHISTNO])) PERSISTED, [ComponentLink] AS (((((CONVERT([varchar](10),[ProjectID])+[UNITID])+[EQUIPID])+CONVERT([varchar](10),[EQHISTNO]))+[COMPONENID])+CONVERT([varchar](10),[COHISTNO])) PERSISTED, [UnitLink] AS (CONVERT([varchar](10),[ProjectID])+[UNITID]) PERSISTED, [MAWP2] [varchar](500) NULL, CONSTRAINT [PK_COMPONENT] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY], CONSTRAINT [IX_COMPONENT_UniqueComponent] UNIQUE NONCLUSTERED ( [ProjectID] ASC, [UNITID] ASC, [EQUIPID] ASC, [EQHISTNO] ASC, [COMPONENID] ASC, [COHISTNO] ASC )WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[component_attach] Script Date: 5/15/2023 10:45:39 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[component_attach]( [ID] [int] IDENTITY(1,1) NOT NULL, [ProjectID] [int] NOT NULL, [UNITID] [varchar](50) NOT NULL, [EQUIPID] [varchar](50) NOT NULL, [EQHISTNO] [numeric](5, 0) NOT NULL, [COMPONENID] [varchar](40) NOT NULL, [COHISTNO] [numeric](5, 0) NOT NULL, [SORTKEY] [numeric](8, 0) NOT NULL, [CAPTION] [varchar](255) NULL, [FILENAME] [varchar](2083) NULL, [HEADLINE] [varchar](80) NULL, [NOTEDT] [datetime] NULL, [NOTESFORMT] [varchar](10) NULL, [NOTESTYPE] [varchar](10) NULL, [STORAGEIND] [varchar](1) NULL, [USER] [varchar](40) NULL, [COMPNNTNSQ] [numeric](8, 0) NULL, [Active] [bit] NOT NULL, [CreateDate] [datetime] NOT NULL, [Timestamp] [timestamp] NULL, [UnitLink] AS (CONVERT([varchar](10),[ProjectID])+[UNITID]) PERSISTED, [EquipLink] AS (((CONVERT([varchar](10),[ProjectID])+[UNITID])+[EQUIPID])+CONVERT([varchar](10),[EQHISTNO])) PERSISTED, [ComponentLink] AS (((((CONVERT([varchar](10),[ProjectID])+[UNITID])+[EQUIPID])+CONVERT([varchar](10),[EQHISTNO]))+[COMPONENID])+CONVERT([varchar](10),[COHISTNO])) PERSISTED, CONSTRAINT [PK_component_attach] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY], CONSTRAINT [IX_component_attach] UNIQUE NONCLUSTERED ( [ID] ASC )WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[DamageMechanisms] Script Date: 5/15/2023 10:45:39 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[DamageMechanisms]( [ProjectID] [int] NOT NULL, [UNITID] [varchar](50) NOT NULL, [EQUIPID] [varchar](50) NOT NULL, [EQHISTNO] [numeric](5, 0) NOT NULL, [CIRCUITID] [varchar](40) NOT NULL, [DAMAGEMECH] [varchar](50) NOT NULL, [BASEBASIS] [varchar](50) NULL, [BASECRRRAT] [numeric](9, 5) NULL, [BASEPBR] [varchar](25) NULL, [BSPROBBLTY] [float] NULL, [BTCHNCSBFC] [numeric](5, 0) NULL, [CALCBASIS] [varchar](50) NULL, [CLPROBBLTY] [float] NULL, [CURRPROB] [varchar](25) NULL, [DAMAGETYPE] [varchar](50) NULL, [DESCRIPT] [varchar](255) NULL, [GNRPRBBLTY] [float] NULL, [INSPCATG] [varchar](50) NULL, [INTINSTR] [varchar](255) NULL, [LASTEVDT] [datetime] NULL, [LASTCATG] [varchar](50) NULL, [MSTRSCHDLR] [varchar](20) NULL, [NOINTINSTR] [varchar](255) NULL, [OVERRIDE] [varchar](1) NULL, [OVERJUST] [varchar](50) NULL, [RISKLEVEL] [varchar](25) NULL, [USER] [varchar](40) NULL, [PCMSOWNED] [varchar](1) NULL, [PROJTARGTD] [datetime] NULL, [PROJTRGDTA] [datetime] NULL, [PROJTRGDTB] [datetime] NULL, [PROJTRGDTC] [datetime] NULL, [TARGETDT] [datetime] NULL, [SCRENNGBSS] [varchar](200) NULL, [SPPROCEDRH] [varchar](100) NULL, [SUSCEPTIBL] [varchar](1) NULL, [TCHNCSBFCT] [numeric](5, 0) NULL, [USEDINCALC] [varchar](1) NULL, [CIDMSEQNO] [numeric](8, 0) NULL, [CreateDate] [datetime] NOT NULL, [Timestamp] [timestamp] NULL, [Active] [bit] NOT NULL, [CIHISTNO] [numeric](5, 0) NOT NULL, [Becht_Notes] [varchar](2000) NULL, [ID] [int] IDENTITY(1,1) NOT NULL, [Becht_OVERJUST] [varchar](50) NULL, [Becht_RISKLEVEL] [varchar](25) NULL, [Becht_CorrosionRate] [numeric](9, 5) NULL, [UnitLink] AS (CONVERT([varchar](10),[ProjectID])+[UNITID]) PERSISTED, [EquipLink] AS (((CONVERT([varchar](10),[ProjectID])+[UNITID])+[EQUIPID])+CONVERT([varchar](10),[EQHISTNO])) PERSISTED, [CircuitLink] AS (((((CONVERT([varchar](10),[ProjectID])+[UNITID])+[EQUIPID])+CONVERT([varchar](10),[EQHISTNO]))+[CIRCUITID])+CONVERT([varchar](10),[CIHISTNO])) PERSISTED, [Becht_OVERRIDE] [bit] NOT NULL, [Becht_SUSCEPTIBL] [bit] NOT NULL, [Calc_Sort] AS (case when [Becht_SUSCEPTIBL]=(1) OR [SUSCEPTIBL]='Y' then (1) when [BECHT_OVERRIDE]=(1) then (9) when [OVERRIDE]='Y' AND [RISKLEVEL]='NEGLIGIBLE' AND [SUSCEPTIBL]='N' then (10) else (99) end) PERSISTED NOT NULL, [DamageMechanismStatus_ID_FK] [bigint] NULL, [Becht_DAMAGETYPE] [varchar](50) NULL, [SUSCEPTIBL_POSTLOAD] [varchar](1) NULL, CONSTRAINT [PK_DamageMechanisms] PRIMARY KEY CLUSTERED ( [ProjectID] ASC, [UNITID] ASC, [EQUIPID] ASC, [EQHISTNO] ASC, [CIRCUITID] ASC, [DAMAGEMECH] ASC, [CIHISTNO] ASC )WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY], CONSTRAINT [IX_DamageMechanisms_ID] UNIQUE NONCLUSTERED ( [ID] ASC )WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[DamageMechanismStatus] Script Date: 5/15/2023 10:45:39 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[DamageMechanismStatus]( [ID] [bigint] IDENTITY(1,1) NOT NULL, [Status] [varchar](50) NOT NULL, [Description] [varchar](255) NULL, CONSTRAINT [PK_DamageMechanismStatus] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY], CONSTRAINT [IX_DamageMech_Status] UNIQUE NONCLUSTERED ( [ID] ASC )WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[equip_attach] Script Date: 5/15/2023 10:45:39 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[equip_attach]( [ID] [int] IDENTITY(1,1) NOT NULL, [ProjectID] [int] NOT NULL, [UNITID] [varchar](50) NOT NULL, [EQUIPID] [varchar](50) NOT NULL, [EQHISTNO] [numeric](5, 0) NOT NULL, [SORTKEY] [numeric](8, 0) NOT NULL, [CAPTION] [varchar](255) NULL, [FILENAME] [varchar](2083) NULL, [HEADLINE] [varchar](80) NULL, [NOTEDT] [datetime] NULL, [NOTESFORMT] [varchar](10) NULL, [NOTESTYPE] [varchar](10) NULL, [STORAGEIND] [varchar](1) NULL, [USER] [varchar](40) NULL, [EQUPNOTSQN] [numeric](8, 0) NULL, [Active] [bit] NOT NULL, [CreateDate] [datetime] NOT NULL, [Timestamp] [timestamp] NULL, [UnitLink] AS (CONVERT([varchar](10),[ProjectID])+[UNITID]) PERSISTED, [EquipLink] AS (((CONVERT([varchar](10),[ProjectID])+[UNITID])+[EQUIPID])+CONVERT([varchar](10),[EQHISTNO])) PERSISTED, CONSTRAINT [PK_equip_attach] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY], CONSTRAINT [IX_equip_attach] UNIQUE NONCLUSTERED ( [ProjectID] ASC, [UNITID] ASC, [EQUIPID] ASC, [EQHISTNO] ASC, [SORTKEY] ASC )WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[Equipment] Script Date: 5/15/2023 10:45:39 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Equipment]( [Id] [int] IDENTITY(1,1) NOT NULL, [ProjectID] [int] NOT NULL, [EQUIPSEQNO] [numeric](8, 0) NULL, [UNITID] [varchar](50) NOT NULL, [EQUIPID] [varchar](50) NOT NULL, [EQHISTNO] [numeric](5, 0) NOT NULL, [DESCRIPT] [varchar](50) NULL, [EQUIPTYPE] [varchar](50) NULL, [MAL_ID] [int] NOT NULL, [PM_AddDt] [datetime] NULL, [CLASS] [varchar](10) NULL, [CLASSBASIS] [varchar](50) NULL, [BUILDDT] [datetime] NULL, [ENVIRONMEN] [varchar](50) NULL, [DESIGNPRES] [numeric](9, 4) NULL, [DESIGNTEMP] [numeric](5, 0) NULL, [INSERVICDT] [datetime] NULL, [INSTALLDT] [datetime] NULL, [INSULATION] [varchar](50) NULL, [GOVERNCODE] [varchar](50) NULL, [GRADE] [varchar](50) NULL, [HAZOP] [varchar](20) NULL, [INTCTL1] [varchar](50) NULL, [INTCTL2] [varchar](50) NULL, [INTCTL3] [varchar](50) NULL, [OUTSIDERES] [varchar](50) NULL, [MATERIAL] [varchar](50) NULL, [MAWP] [numeric](9, 4) NULL, [MAWT] [numeric](4, 0) NULL, [MDMTEMP] [numeric](4, 0) NULL, [ACCESSMETH] [varchar](25) NULL, [MODELNO] [varchar](50) NULL, [FOUNDATION] [varchar](50) NULL, [DRAINTYPE] [varchar](50) NULL, [COSTCENTER] [varchar](16) NULL, [ASSETNO] [varchar](50) NULL, [ALTREGISNO] [varchar](50) NULL, [AREA] [varchar](50) NULL, [OPERATPRES] [numeric](9, 4) NULL, [OPERATTEMP] [numeric](4, 0) NULL, [OPERATSTAT] [varchar](50) NULL, [ORIENT] [varchar](10) NULL, [ORIGMFGFOR] [varchar](50) NULL, [PIDDRAWING] [varchar](50) NULL, [PARENTEQ] [varchar](50) NULL, [REGISTRNO] [varchar](50) NULL, [PROCIMPACT] [varchar](16) NULL, [SERVICE] [varchar](50) NULL, [EQATCHPATH] [varchar](64) NULL, [SERIALNO] [varchar](50) NULL, [SYSTEM] [varchar](50) NULL, [TAPLANNING] [varchar](50) NULL, [AREAINSP] [varchar](40) NULL, [NOTES] [varchar](4000) NULL, [ASSETCOM] [varchar](4000) NULL, [CLEANMETH] [varchar](50) NULL, [COATING] [varchar](50) NULL, [CODESTAMP] [varchar](1) NULL, [EQHEIGHT] [numeric](6, 3) NULL, [EQLENGTH] [numeric](10, 3) NULL, [EQWIDTH] [numeric](6, 3) NULL, [FIREPROOF] [varchar](1) NULL, [FLOORMATL] [varchar](50) NULL, [FLRSPCMATL] [varchar](50) NULL, [FREEDRAIN] [varchar](1) NULL, [FULLVAC] [varchar](1) NULL, [HVAC] [varchar](1) NULL, [HEATTRACE] [varchar](1) NULL, [INDOORSYN] [varchar](1) NULL, [LINENO] [varchar](25) NULL, [LINESPEC] [varchar](50) NULL, [MTBF] [varchar](50) NULL, [OPERATTYPE] [varchar](50) NULL, [OUTERDIAM] [numeric](8, 3) NULL, [PRODUCTNYN] [varchar](1) NULL, [PWHT] [char](1) NULL, [BARRIER] [varchar](50) NULL, [SAPEQUIPNO] [varchar](50) NULL, [STORVOL] [numeric](10, 2) NULL, [STRUCTURE] [varchar](50) NULL, [STYLE] [varchar](100) NULL, [SEALTYPE] [varchar](50) NULL, [ACMAINMCCN] [varchar](50) NULL, [ACSUBMCCBN] [varchar](50) NULL, [ADEQCONTYN] [varchar](50) NULL, [EQUIPAREA] [varchar](50) NULL, [ASLCOMPTYP] [varchar](50) NULL, [HISTREASON] [varchar](4) NULL, [RCFMECONFG] [varchar](50) NULL, [ATGRADEYN] [varchar](50) NULL, [BOTHOLELSD] [varchar](50) NULL, [CIRCSTRYN] [varchar](50) NULL, [CLDWLLEQUP] [varchar](50) NULL, [CONECTTYPE] [varchar](50) NULL, [CORRALLOW] [varchar](50) NULL, [CAINFRQNCY] [varchar](50) NULL, [CAINPTPHAS] [varchar](50) NULL, [CAINPVOLTG] [varchar](50) NULL, [CPOUTA] [numeric](5, 2) NULL, [CPOUTV] [numeric](5, 2) NULL, [CPANODES] [varchar](50) NULL, [COTPRTNCRR] [varchar](50) NULL, [COTPRTNVLT] [varchar](50) NULL, [CPCOARSE] [numeric](1, 0) NULL, [CPCOARSMAX] [varchar](50) NULL, [CPFINE] [numeric](1, 0) NULL, [CPFINEMAX] [varchar](50) NULL, [CPTYPE] [varchar](50) NULL, [CRITICALIT] [varchar](50) NULL, [CRITCALCYN] [varchar](50) NULL, [CTVFLANGE] [varchar](50) NULL, [CUIPOTENTL] [varchar](50) NULL, [CYCLIC] [varchar](50) NULL, [DCOUTPTMCN] [varchar](50) NULL, [DLTTRGGACT] [varchar](50) NULL, [DIKECAP] [varchar](50) NULL, [DOT] [varchar](50) NULL, [DUTYCYCLE] [varchar](50) NULL, [ENCAPMEM] [varchar](50) NULL, [ENCLOSURE] [varchar](50) NULL, [ESTRPRTIME] [numeric](4, 1) NULL, [EXTEQUIPID] [varchar](50) NULL, [EXTUNITID] [varchar](50) NULL, [FEQEQPSTTS] [varchar](50) NULL, [FREQUENCY] [varchar](50) NULL, [FNCTNIMPRT] [varchar](50) NULL, [HEATOUTPUT] [varchar](50) NULL, [HACDSERVIC] [varchar](50) NULL, [HGPRRTYPPN] [varchar](50) NULL, [HYDROPRES] [varchar](50) NULL, [HYDROTEMP] [varchar](50) NULL, [INSTRGGACT] [varchar](50) NULL, [INVCTRL] [varchar](50) NULL, [LATITUDEEQ] [varchar](50) NULL, [LONGITUDEQ] [varchar](50) NULL, [MAXLIQLEVL] [varchar](50) NULL, [MODULENO] [varchar](50) NULL, [NOLEVELS] [varchar](50) NULL, [OCAPCTYVLM] [varchar](50) NULL, [OCAPCTYWGH] [varchar](50) NULL, [OVFPTNSQNO] [varchar](50) NULL, [PONO] [varchar](50) NULL, [PHASE] [varchar](50) NULL, [PORTMOBYN] [varchar](50) NULL, [POSSEAL] [varchar](50) NULL, [PRODZONEFR] [varchar](50) NULL, [PRODZONETO] [varchar](50) NULL, [RACONRANK] [varchar](50) NULL, [RARKRANK] [varchar](50) NULL, [RBITARGETD] [datetime] NULL, [RCRITICLTY] [varchar](50) NULL, [RCMRANK] [varchar](50) NULL, [RANKCALCYN] [varchar](50) NULL, [RECALCFILL] [varchar](50) NULL, [REDRPRRAT] [numeric](5, 0) NULL, [REQRELFCAP] [varchar](50) NULL, [RQRLCAPUOM] [varchar](50) NULL, [RERATEDYN] [varchar](50) NULL, [USERRESP] [varchar](50) NULL, [TMDSGNCHNG] [varchar](50) NULL, [SRVCCONDTN] [varchar](50) NULL, [SHRTNN2CRR] [varchar](50) NULL, [SHRTNN2VLT] [varchar](50) NULL, [SPCC] [varchar](50) NULL, [SUBSTATINN] [varchar](50) NULL, [SUPPTYPE] [varchar](50) NULL, [SURFACELSD] [varchar](50) NULL, [SWGRNO] [varchar](50) NULL, [TNKCTDNSTY] [varchar](50) NULL, [TANKNOMDIA] [varchar](50) NULL, [TANKNOMHT] [varchar](50) NULL, [TNKROOFTYP] [varchar](25) NULL, [TKSECSEAL] [varchar](50) NULL, [TANKSPECGR] [varchar](50) NULL, [TEMA] [varchar](5) NULL, [TMPRATNGMX] [varchar](50) NULL, [TMPRATNGMN] [varchar](50) NULL, [TESTMED] [varchar](50) NULL, [TRCHANNELN] [varchar](50) NULL, [TRCHANNELS] [varchar](50) NULL, [TDOTPSHRTC] [varchar](50) NULL, [TDOTPSHRTV] [varchar](50) NULL, [TYPICOOLNG] [varchar](50) NULL, [U1ONFILE] [varchar](50) NULL, [UPDTRGGACT] [varchar](50) NULL, [USCG] [varchar](50) NULL, [WGTEMPTY] [varchar](50) NULL, [WGTFULL] [varchar](50) NULL, [WORSTCRRRR] [varchar](50) NULL, [WRSTRCIRCT] [varchar](50) NULL, [ADDDT] [datetime] NULL, [ALLOWLEVEL] [varchar](50) NULL, [CHGDT] [datetime] NULL, [ERLYHLCIRC] [varchar](50) NULL, [ERLYHLTML] [varchar](50) NULL, [ERLYHLDATE] [datetime] NULL, [ERLRETCIRC] [varchar](50) NULL, [ERLRETTML] [varchar](50) NULL, [ERLRETDATE] [datetime] NULL, [ERLINSPCIR] [varchar](50) NULL, [ERLINSPTML] [varchar](50) NULL, [ERLINSPDAT] [datetime] NULL, [HYDROTSTHT] [varchar](50) NULL, [NEEDRECALC] [varchar](50) NULL, [NXTEXTINSP] [varchar](50) NULL, [NXTINTINSP] [varchar](50) NULL, [NOCIRCUITS] [numeric](8, 0) NULL, [NOTMLS] [numeric](8, 0) NULL, [TIMESREPL] [varchar](50) NULL, [RAPROBRANK] [varchar](50) NULL, [RECALCDATS] [varchar](50) NULL, [SHORTHLCIR] [varchar](50) NULL, [SHORTHLTML] [varchar](50) NULL, [SHORTHLINT] [varchar](50) NULL, [TNKFLRTPSN] [varchar](50) NULL, [BechtNotes] [varchar](4000) NULL, [Timestamp] [timestamp] NULL, [Active] [bit] NOT NULL, [CreateDate] [datetime] NOT NULL, [Status_Becht] [varchar](55) NOT NULL, [Status_User] [varchar](50) NULL, [Status_Date] [datetime] NULL, [UnitLink] AS (CONVERT([varchar](10),[ProjectID])+[UNITID]) PERSISTED, [EquipLink] AS (((CONVERT([varchar](10),[ProjectID])+[UNITID])+[EQUIPID])+CONVERT([varchar](10),[EQHISTNO])) PERSISTED, CONSTRAINT [PK_Equipment] PRIMARY KEY CLUSTERED ( [ProjectID] ASC, [UNITID] ASC, [EQUIPID] ASC, [EQHISTNO] ASC )WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY], CONSTRAINT [IX_Equipment] UNIQUE NONCLUSTERED ( [Id] ASC )WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[EVENT] Script Date: 5/15/2023 10:45:39 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[EVENT]( [Id] [int] IDENTITY(1,1) NOT NULL, [ProjectID] [int] NOT NULL, [UNITID] [varchar](50) NOT NULL, [EQUIPID] [varchar](50) NOT NULL, [EQHISTNO] [numeric](5, 0) NOT NULL, [EVENTTYPE] [varchar](50) NOT NULL, [EVENTDATE] [datetime] NOT NULL, [CIRCUITID] [varchar](40) NULL, [COMPONENID] [varchar](40) NULL, [ACCESSDESC] [varchar](50) NULL, [EVACTUCOST] [numeric](12, 2) NULL, [EVACTUHOUR] [numeric](8, 2) NULL, [HISTRYRESN] [nvarchar](255) NULL, [EVBDGTCOST] [nvarchar](255) NULL, [EVBDGTHOUR] [nvarchar](255) NULL, [CERTRECDDT] [nvarchar](255) NULL, [CLENNGMTHD] [varchar](50) NULL, [CLOSEBY] [varchar](40) NULL, [CONDITION] [nvarchar](255) NULL, [CPOUTA] [numeric](5, 2) NULL, [CPOUTV] [numeric](5, 2) NULL, [CPCOARSE] [numeric](1, 0) NULL, [CPFINE] [numeric](1, 0) NULL, [DTFLWSTATS] [varchar](12) NULL, [DLTTRGGACT] [varchar](6) NULL, [INSPIFDIF] [varchar](40) NULL, [DISRGRDINC] [varchar](1) NULL, [DONOTUSDSC] [varchar](200) NULL, [DONOTUSINS] [varchar](40) NULL, [ENTEREDBY] [varchar](40) NULL, [CLOSEDT] [datetime] NULL, [EVNTCMMNTS] [varchar](255) NULL, [HISTORYNO] [numeric](8, 0) NULL, [EVENTNO] [varchar](20) NULL, [STATUS] [varchar](8) NULL, [FAILRCNSEQ] [varchar](50) NULL, [FAILRCNSPL] [varchar](50) NULL, [FAILRCNSQU] [varchar](50) NULL, [FAILURETYP] [varchar](25) NULL, [ALPURPOSDT] [varchar](50) NULL, [HEADLINE] [varchar](80) NULL, [INSTRGGACT] [varchar](6) NULL, [INSCOMPLET] [varchar](1) NULL, [INSPPRIOR] [varchar](15) NULL, [INTACCESS] [varchar](10) NULL, [IOR] [varchar](40) NULL, [JURICERTYN] [varchar](1) NULL, [MAINTPLANR] [varchar](40) NULL, [GRADE] [varchar](16) NULL, [NOTES] [varchar](4000) NULL, [OPENDT] [datetime] NULL, [ORIGTMXINT] [numeric](3, 0) NULL, [TESTREASON] [varchar](50) NULL, [REASONDESC] [varchar](200) NULL, [RELFORAPP] [varchar](1) NULL, [REPAIRPERF] [varchar](50) NULL, [REPORTNO] [varchar](25) NULL, [SCHEDEVNTD] [datetime] NULL, [SPCINSTRCT] [varchar](500) NULL, [TESTMEDIUM] [varchar](20) NULL, [TESTPRES] [numeric](10, 5) NULL, [TESTTEMP] [numeric](4, 0) NULL, [TRACKINGNO] [varchar](50) NULL, [VSLSTATUS] [nvarchar](255) NULL, [TRANSMITDT] [datetime] NULL, [UPDTRGGACT] [varchar](6) NULL, [WFLSTATUS] [varchar](100) NULL, [WFLSTSCALC] [varchar](1) NULL, [EVENTSEQNO] [numeric](8, 0) NULL, [ORIGDUEDT] [datetime] NULL, [RBIINTERVL] [numeric](3, 0) NULL, [RISKRANK] [varchar](25) NULL, [CIHISTNO] [numeric](5, 0) NULL, [COHISTNO] [numeric](5, 0) NULL, [BechtNotes] [varchar](1500) NULL, [Timestamp] [timestamp] NULL, [Active] [bit] NOT NULL, [CreateDate] [datetime] NOT NULL, [Status_Becht] [varchar](55) NOT NULL, [Status_User] [varchar](50) NULL, [Status_Date] [datetime] NULL, [UnitLink] AS (CONVERT([varchar](10),[ProjectID])+[UNITID]) PERSISTED, [EquipLink] AS (((CONVERT([varchar](10),[ProjectID])+[UNITID])+[EQUIPID])+CONVERT([varchar](10),[EQHISTNO])) PERSISTED, [CircuitLink] AS (((((CONVERT([varchar](10),[ProjectID])+[UNITID])+[EQUIPID])+CONVERT([varchar](10),[EQHISTNO]))+[CIRCUITID])+CONVERT([varchar](10),[CIHISTNO])) PERSISTED, [ComponentLink] AS (((((CONVERT([varchar](10),[ProjectID])+[UNITID])+[EQUIPID])+CONVERT([varchar](10),[EQHISTNO]))+[COMPONENID])+CONVERT([varchar](10),[COHISTNO])) PERSISTED, CONSTRAINT [PK_EVENT] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY], CONSTRAINT [IX_EVENT_UniqueKeys] UNIQUE NONCLUSTERED ( [ProjectID] ASC, [UNITID] ASC, [EQUIPID] ASC, [EQHISTNO] ASC, [EVENTTYPE] ASC, [EVENTDATE] ASC, [CIRCUITID] ASC, [CIHISTNO] ASC, [COMPONENID] ASC, [COHISTNO] ASC )WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[event_attach] Script Date: 5/15/2023 10:45:39 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[event_attach]( [Id] [int] IDENTITY(1,1) NOT NULL, [ProjectID] [int] NOT NULL, [UNITID] [varchar](50) NOT NULL, [EQUIPID] [varchar](50) NOT NULL, [EQHISTNO] [numeric](5, 0) NOT NULL, [EVENTTYPE] [varchar](50) NOT NULL, [EVENTDATE] [datetime] NOT NULL, [CIRCUITID] [varchar](40) NULL, [CIHISTNO] [numeric](5, 0) NULL, [COMPONENID] [varchar](50) NULL, [COHISTNO] [numeric](5, 0) NULL, [SORTKEY] [numeric](8, 0) NULL, [CAPTION] [varchar](255) NULL, [EVENTNO] [varchar](20) NULL, [FILENAME] [varchar](2083) NULL, [HEADLINE] [varchar](80) NULL, [NOTEDT] [datetime] NULL, [NOTESFORMT] [varchar](10) NOT NULL, [NOTESTYPE] [varchar](10) NULL, [STORAGEIND] [varchar](1) NOT NULL, [USER] [varchar](40) NULL, [EVNTNOTSQN] [numeric](8, 0) NULL, [Timestamp] [timestamp] NULL, [Active] [bit] NOT NULL, [CreateDate] [datetime] NOT NULL, [EquipLink] AS (((CONVERT([varchar](10),[ProjectID])+[UNITID])+[EQUIPID])+CONVERT([varchar](10),[EQHISTNO])) PERSISTED, [CircuitLink] AS (((((CONVERT([varchar](10),[ProjectID])+[UNITID])+[EQUIPID])+CONVERT([varchar](10),[EQHISTNO]))+[CIRCUITID])+CONVERT([varchar](10),[CIHISTNO])) PERSISTED, [ComponentLink] AS (((((CONVERT([varchar](10),[ProjectID])+[UNITID])+[EQUIPID])+CONVERT([varchar](10),[EQHISTNO]))+[COMPONENID])+CONVERT([varchar](10),[COHISTNO])) PERSISTED, CONSTRAINT [PK_event_attach] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY], CONSTRAINT [IX_event_attach] UNIQUE NONCLUSTERED ( [ProjectID] ASC, [UNITID] ASC, [EQUIPID] ASC, [EQHISTNO] ASC, [EVENTTYPE] ASC, [EVENTDATE] ASC, [CIRCUITID] ASC, [CIHISTNO] ASC, [COMPONENID] ASC, [COHISTNO] ASC, [SORTKEY] ASC )WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[EVENT_REPORT] Script Date: 5/15/2023 10:45:39 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[EVENT_REPORT]( [Id] [int] IDENTITY(1,1) NOT NULL, [ProjectID] [int] NOT NULL, [UNITID] [varchar](50) NOT NULL, [EQUIPID] [varchar](50) NOT NULL, [EQHISTNO] [numeric](5, 0) NOT NULL, [EVENTTYPE] [varchar](50) NOT NULL, [EVENTDATE] [datetime] NOT NULL, [CIRCUITID] [varchar](40) NULL, [COMPONENID] [varchar](40) NULL, [MSTCHKLSTG] [varchar](50) NULL, [NAME] [varchar](100) NULL, [EVCCPARENT] [varchar](100) NULL, [SUMMARYCTG] [varchar](1) NULL, [ACTUALCOST] [numeric](12, 2) NULL, [ACTUALHRS] [numeric](8, 2) NULL, [ACTINSPCTG] [varchar](50) NULL, [AVGPITDPTH] [numeric](6, 3) NULL, [BUDGETCOST] [numeric](12, 2) NULL, [BUDGETHRS] [numeric](8, 2) NULL, [COMPNNTMST] [varchar](50) NULL, [CONDITION] [varchar](150) NULL, [DLTTRGGACT] [varchar](6) NULL, [EVENTNO] [varchar](20) NULL, [INSTRGGACT] [varchar](6) NULL, [MSTCHKLSCT] [varchar](100) NULL, [MAXPITDPTH] [numeric](6, 3) NULL, [NOTBSPLGGD] [numeric](8, 0) NULL, [NOTES] [varchar](4000) NULL, [OK] [varchar](1) NULL, [PART] [nvarchar](255) NULL, [RECMINSCTG] [varchar](50) NULL, [SORTKEY] [numeric](8, 0) NULL, [SPCINSTRCT] [varchar](1000) NULL, [UPDTRGGACT] [varchar](6) NULL, [EVNCHKLCSQ] [numeric](8, 0) NULL, [Timestamp] [timestamp] NULL, [Active] [bit] NOT NULL, [CreateDate] [datetime] NOT NULL, [Becht_Notes] [varchar](1000) NULL, [Status_Becht] [varchar](55) NOT NULL, [Status_User] [varchar](50) NULL, [Status_Date] [datetime] NULL, [UnitLink] AS (CONVERT([varchar](10),[ProjectID])+[UNITID]) PERSISTED, [EquipLink] AS (((CONVERT([varchar](10),[ProjectID])+[UNITID])+[EQUIPID])+CONVERT([varchar](10),[EQHISTNO])) PERSISTED, [CIHISTNO] [numeric](5, 0) NULL, [COHISTNO] [numeric](5, 0) NULL, CONSTRAINT [IX_EVENT_REPORT_EVNCHKLCSQ] UNIQUE NONCLUSTERED ( [ProjectID] ASC, [EVNCHKLCSQ] ASC )WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY], CONSTRAINT [IX_EVENT_REPORT_ID] UNIQUE NONCLUSTERED ( [Id] ASC )WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[EXP_SERVICE] Script Date: 5/15/2023 10:45:39 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[EXP_SERVICE]( [Id] [bigint] IDENTITY(1,1) NOT NULL, [SERVICE] [varchar](50) NOT NULL, [COMMENTS] [varchar](255) NULL, [SVCPCTTYPE] [varchar](10) NULL, [STREAMNO] [varchar](50) NULL, [TOTLACNMBR] [numeric](7, 4) NULL, [SERVICSEQN] [numeric](8, 0) NULL, [Active] [bit] NOT NULL, [CreateDate] [datetime] NOT NULL, [Timestamp] [timestamp] NULL, [ProjectID] [int] NOT NULL, [ServiceNotes_Becht] [varchar](4000) NULL, [RepFluid_ID_FK] [int] NULL, [ServiceLink] AS (CONVERT([varchar](10),[ProjectID])+[SERVICE]) PERSISTED, CONSTRAINT [PK_EXP_SERVICE] PRIMARY KEY CLUSTERED ( [SERVICE] ASC, [ProjectID] ASC )WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY], CONSTRAINT [IX_EXP_SERVICE_ID] UNIQUE NONCLUSTERED ( [Id] ASC )WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[FieldStatus] Script Date: 5/15/2023 10:45:39 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[FieldStatus]( [FieldStatusID] [int] IDENTITY(1,1) NOT NULL, [TableName] [varchar](50) NOT NULL, [FieldName] [varchar](50) NOT NULL, [PrimaryKey] [int] NOT NULL, [FieldStatusType_ID] [int] NOT NULL, [Active] [bit] NOT NULL, [AddDt] [datetime] NOT NULL, [AddUser] [varchar](50) NOT NULL, [ProjectID] [int] NOT NULL, [CreateDate] [datetime] NOT NULL, [Timestamp] [timestamp] NULL, CONSTRAINT [PK_FieldStatus] PRIMARY KEY CLUSTERED ( [FieldStatusID] ASC )WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[FieldStatusType] Script Date: 5/15/2023 10:45:39 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[FieldStatusType]( [Id] [int] IDENTITY(1,1) NOT NULL, [Status] [varchar](50) NOT NULL, [Active] [bit] NOT NULL, [CreateDate] [datetime] NOT NULL, [Timestamp] [timestamp] NULL, CONSTRAINT [PK_FieldStatusType] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[IWR] Script Date: 5/15/2023 10:45:39 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[IWR]( [Id] [bigint] IDENTITY(1,1) NOT NULL, [UNITID] [varchar](50) NOT NULL, [EQUIPID] [varchar](50) NOT NULL, [EQHISTNO] [numeric](5, 0) NOT NULL, [IWRTYPE] [varchar](10) NOT NULL, [HEADLINE] [varchar](80) NOT NULL, [OPENDT] [datetime] NULL, [CIRCUITID] [varchar](40) NULL, [COMPONENID] [varchar](40) NULL, [APPROVEBY] [varchar](40) NULL, [ASSETLOCI] [varchar](1) NULL, [CLOSEBY] [varchar](40) NULL, [COMPLEX] [varchar](50) NULL, [DLTTRGGACT] [varchar](6) NULL, [EVENTCATG] [varchar](200) NULL, [EVENTNO] [varchar](20) NULL, [INSTRGGACT] [varchar](6) NULL, [APPROVEDT] [datetime] NULL, [IWRCATEGRY] [varchar](50) NULL, [IWRCAUSE] [varchar](15) NULL, [CLOSEDT] [datetime] NULL, [IWRCONSTRA] [varchar](16) NULL, [IWRCRIT] [varchar](50) NULL, [IWRINTSTAT] [varchar](10) NULL, [IWRISSUTYP] [varchar](15) NULL, [IWRJOBPLAN] [varchar](25) NULL, [SYSWORKORD] [varchar](16) NULL, [IWRNOTIFYT] [varchar](16) NULL, [IWRPRIORIT] [varchar](8) NULL, [RELEASEDFO] [varchar](1) NULL, [REQCOMPDT] [datetime] NULL, [IWRROUTETO] [varchar](16) NULL, [STATUS] [varchar](8) NULL, [LATITUDEIW] [numeric](8, 6) NULL, [SENDEXTSYS] [varchar](1) NULL, [LONGITUDIW] [numeric](9, 6) NULL, [MGMTCHGNO] [varchar](50) NULL, [NOTIFDT] [datetime] NULL, [NOTIFNO] [varchar](16) NULL, [NOTSTATUSC] [varchar](200) NULL, [OPENBY] [varchar](40) NULL, [PERPETUAL] [varchar](1) NULL, [SUPDTSPNDN] [varchar](1) NULL, [SCHEDULENO] [varchar](20) NULL, [SCOPE] [varchar](4000) NULL, [UPDTRGGACT] [varchar](6) NULL, [SAPLONGTXT] [varchar](4000) NULL, [XFERDT] [datetime] NULL, [XFERSTATUS] [varchar](20) NULL, [MNTWRKORDT] [datetime] NULL, [MNTWRKORNO] [varchar](16) NULL, [WOFINISHDT] [datetime] NULL, [WOSTATUSCO] [varchar](200) NULL, [WORKTYPE] [varchar](50) NULL, [FINDINGS] [varchar](4000) NULL, [NOTES] [varchar](4000) NULL, [IWRSEQNO] [numeric](8, 0) NULL, [ADDDT] [datetime] NULL, [CHGDT] [datetime] NULL, [ProjectID] [int] NOT NULL, [Active] [bit] NOT NULL, [CreateDate] [datetime] NULL, [Becht_Notes] [varchar](1500) NULL, [Status_Becht] [varchar](55) NOT NULL, [Status_User] [varchar](50) NULL, [Status_Date] [datetime] NULL, [EquipLink] AS (((CONVERT([varchar](10),[ProjectID])+[UNITID])+[EQUIPID])+CONVERT([varchar](10),[EQHISTNO])) PERSISTED, [UnitLink] AS (CONVERT([varchar](10),[ProjectID])+[UNITID]) PERSISTED, CONSTRAINT [PK_IWR] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[MasterAssetList] Script Date: 5/15/2023 10:45:39 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[MasterAssetList]( [MAL_ID] [int] IDENTITY(1,1) NOT NULL, [MAL] [varchar](50) NOT NULL, [InScopeYN] [char](1) NULL, [Notes] [varchar](max) NULL, [add_dt] [datetime] NULL, [Timestamp] [timestamp] NULL, [Active] [bit] NOT NULL, [CreateDate] [datetime] NOT NULL, CONSTRAINT [PK_MasterAssetList] PRIMARY KEY CLUSTERED ( [MAL_ID] ASC )WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO /****** Object: Table [dbo].[MOC] Script Date: 5/15/2023 10:45:39 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[MOC]( [MOC_ID] [int] IDENTITY(1,1) NOT NULL, [MOC] [varchar](50) NOT NULL, [Title] [varchar](255) NULL, [Description] [varchar](2500) NULL, [Basis] [varchar](2500) NULL, [AddDt] [datetime] NULL, [MOC_Status_ID] [int] NOT NULL, [ProjectID] [int] NOT NULL, [BechtNotes] [varchar](1500) NULL, [Timestamp] [timestamp] NULL, [Active] [bit] NOT NULL, [CreateDate] [datetime] NOT NULL, [Status_Becht] [varchar](55) NOT NULL, [Status_User] [varchar](50) NULL, [Status_Date] [datetime] NULL, [MOC_Type_ID_FK] [int] NOT NULL, [MOC_OpenDate] [datetime] NULL, [MOC_StartDate] [datetime] NULL, [MOC_ClosedDate] [datetime] NULL, [UnitID] [int] NULL, CONSTRAINT [PK_MOC] PRIMARY KEY CLUSTERED ( [MOC_ID] ASC )WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY], CONSTRAINT [IX_MOC] UNIQUE NONCLUSTERED ( [ProjectID] ASC, [MOC] ASC )WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[MOC_Assoc] Script Date: 5/15/2023 10:45:39 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[MOC_Assoc]( [MOC_Assoc_ID] [int] IDENTITY(1,1) NOT NULL, [MOC_ID] [int] NOT NULL, [EquipID] [int] NOT NULL, [CircuitID] [int] NULL, [Timestamp] [timestamp] NULL, [Active] [bit] NOT NULL, [CreateDate] [datetime] NOT NULL, [Status_Becht] [varchar](55) NOT NULL, [Status_User] [varchar](50) NULL, [Status_Date] [datetime] NULL, [Becht_Notes] [varchar](500) NULL, CONSTRAINT [PK_MOC_Assoc] PRIMARY KEY CLUSTERED ( [MOC_Assoc_ID] ASC )WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY], CONSTRAINT [IX_MOC_Assoc_Column] UNIQUE NONCLUSTERED ( [MOC_ID] ASC, [EquipID] ASC, [CircuitID] ASC )WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[MOC_Status] Script Date: 5/15/2023 10:45:39 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[MOC_Status]( [ID] [int] IDENTITY(1,1) NOT NULL, [MOC_Status] [varchar](50) NOT NULL, [MOC_Status_Desc] [varchar](255) NULL, [Comp_yn] [bit] NOT NULL, [Timestamp] [timestamp] NULL, [Active] [bit] NOT NULL, [CreateDate] [datetime] NOT NULL, CONSTRAINT [PK_MOC_Status] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[MOC_Type] Script Date: 5/15/2023 10:45:39 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[MOC_Type]( [MOC_Type_ID] [int] IDENTITY(1,1) NOT NULL, [name] [varchar](50) NOT NULL, CONSTRAINT [PK_MOC_Type] PRIMARY KEY CLUSTERED ( [MOC_Type_ID] ASC )WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[Notes] Script Date: 5/15/2023 10:45:39 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Notes]( [Id] [bigint] IDENTITY(1,1) NOT NULL, [Note] [varchar](500) NULL, [CreatedBy] [varchar](50) NULL, [Notes_Type_ID] [bigint] NOT NULL, [CreateDate] [datetime] NOT NULL, [Timestamp] [timestamp] NULL, [Active] [bit] NOT NULL, CONSTRAINT [PK_Notes] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[Notes_Type] Script Date: 5/15/2023 10:45:39 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Notes_Type]( [Id] [bigint] IDENTITY(1,1) NOT NULL, [Notes_Type] [varchar](100) NOT NULL, [Active] [bit] NOT NULL, [CreatedBy] [varchar](50) NULL, [CreateDate] [datetime] NOT NULL, [Timestamp] [timestamp] NULL, CONSTRAINT [PK_Notes_Type] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[Project] Script Date: 5/15/2023 10:45:39 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Project]( [ID] [bigint] IDENTITY(1,1) NOT NULL, [ProjectID] [int] NOT NULL, [name] [varchar](50) NOT NULL, [description] [text] NULL, [start_dt] [datetime] NULL, [comp_dt] [datetime] NULL, [start_dt_plan] [datetime] NULL, [comp_dt_plan] [datetime] NULL, [Timestamp] [timestamp] NULL, [Active] [bit] NOT NULL, [CreateDate] [datetime] NOT NULL, [Path] [varchar](255) NULL, [ProjectNo] [varchar](255) NULL, [BudgetCost] [numeric](10, 2) NULL, CONSTRAINT [PK_Project] PRIMARY KEY CLUSTERED ( [ProjectID] ASC )WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY], CONSTRAINT [IX_Project] UNIQUE NONCLUSTERED ( [name] ASC )WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY], CONSTRAINT [IX_Project_ID_UNIQUE] UNIQUE NONCLUSTERED ( [ID] ASC )WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO /****** Object: Table [dbo].[ProjectLinks] Script Date: 5/15/2023 10:45:39 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[ProjectLinks]( [ProjectLinks_ID] [int] IDENTITY(1,1) NOT NULL, [ProjectID_FK] [int] NOT NULL, [LinkPath] [varchar](500) NOT NULL, [Description] [varchar](255) NOT NULL, [Timestamp] [timestamp] NULL ) ON [PRIMARY] GO /****** Object: Table [dbo].[reading] Script Date: 5/15/2023 10:45:39 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[reading]( [ProjectID] [int] NOT NULL, [UNITID] [varchar](50) NOT NULL, [EQUIPID] [varchar](50) NOT NULL, [EQHISTNO] [numeric](5, 0) NOT NULL, [CIRCUITID] [varchar](40) NOT NULL, [TMLID] [varchar](40) NOT NULL, [TMHISTNO] [numeric](5, 0) NOT NULL, [READDATE] [datetime] NOT NULL, [AVGTHICK] [numeric](6, 3) NULL, [CMLCONDCOD] [varchar](5) NULL, [CORROSLENG] [numeric](6, 3) NULL, [CANODVOLTG] [numeric](6, 3) NULL, [COFCORRCTD] [numeric](5, 0) NULL, [CPOFFDREAD] [numeric](5, 0) NULL, [COCORRECTD] [numeric](5, 0) NULL, [CPONDREAD] [numeric](5, 0) NULL, [COTPTCRRNT] [numeric](5, 2) NULL, [DAMGFTPRNT] [varchar](25) NULL, [DESCRIPT] [varchar](4000) NULL, [EVENTNO] [varchar](20) NULL, [FIELDREAD] [numeric](6, 3) NULL, [FLOWVOL] [numeric](8, 0) NULL, [INSTRGGACT] [varchar](6) NULL, [INSPREASON] [varchar](50) NULL, [INSPECTOR] [varchar](40) NULL, [LOCATION] [varchar](5) NULL, [MATERIAL] [varchar](50) NULL, [MINTHICK] [numeric](6, 3) NULL, [OVERCPSYN] [varchar](1) NULL, [OVERCPSJST] [varchar](50) NULL, [OVERCPSUSR] [varchar](40) NULL, [OVERCPSVAL] [numeric](7, 1) NULL, [PITDEPTH] [numeric](6, 3) NULL, [QUALITYIND] [varchar](1) NULL, [RADEXP] [numeric](10, 2) NULL, [RADEXPUOM] [varchar](10) NULL, [METHOD] [varchar](1) NULL, [REMAINSTRE] [numeric](3, 0) NULL, [RMNSTRBASI] [varchar](100) NULL, [SAFETYFCTR] [numeric](3, 2) NULL, [SFD] [numeric](6, 3) NULL, [TEMP] [numeric](4, 0) NULL, [UPDTRGGACT] [varchar](6) NULL, [ENTEREDBY] [varchar](40) NULL, [WEIGHT] [numeric](9, 4) NULL, [ADDDT] [datetime] NULL, [B31G] [numeric](9, 4) NULL, [CLCPIPSTR] [numeric](7, 1) NULL, [CHGDT] [datetime] NULL, [CODES] [varchar](10) NULL, [CORRRATE] [numeric](9, 5) NULL, [GROWTH] [varchar](1) NULL, [LNGRATBASS] [varchar](1) NULL, [MAWP] [numeric](9, 4) NULL, [SHRTRATBSS] [varchar](1) NULL, [THICKNESS] [numeric](6, 3) NULL, [WALLLOSPCT] [numeric](3, 0) NULL, [Timestamp] [timestamp] NULL, [Active] [bit] NOT NULL, [CreateDate] [datetime] NOT NULL, [Id] [int] IDENTITY(1,1) NOT NULL, [CIHISTNO] [numeric](5, 0) NOT NULL, [UnitLink] AS (CONVERT([varchar](10),[ProjectID])+[UNITID]) PERSISTED, CONSTRAINT [PK_Reading] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY], CONSTRAINT [UK_Reading] UNIQUE NONCLUSTERED ( [ProjectID] ASC, [UNITID] ASC, [EQUIPID] ASC, [EQHISTNO] ASC, [CIRCUITID] ASC, [CIHISTNO] ASC, [TMLID] ASC, [TMHISTNO] ASC, [READDATE] ASC )WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[Relief_Valve] Script Date: 5/15/2023 10:45:39 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Relief_Valve]( [Id] [int] IDENTITY(1,1) NOT NULL, [ProjectID] [int] NOT NULL, [UNITID] [varchar](50) NOT NULL, [EQUIPID] [varchar](50) NOT NULL, [EQHISTNO] [numeric](8, 0) NOT NULL, [ACCSSRYOTH] [varchar](500) NULL, [ACTDIR] [varchar](500) NULL, [ACTFAIL] [varchar](500) NULL, [ACTOPEN] [varchar](500) NULL, [ACTPNEUM] [varchar](500) NULL, [ACTRETRACT] [varchar](500) NULL, [BOLTSET] [varchar](500) NULL, [ABLSPOSTNU] [varchar](500) NULL, [AIRSET] [varchar](500) NULL, [CALCAREA] [varchar](500) NULL, [SELECTAREA] [varchar](500) NULL, [BCFLPRVNTR] [varchar](500) NULL, [BAROMPRES] [varchar](500) NULL, [BELLOWTYPE] [varchar](500) NULL, [BLKVALVDN] [varchar](500) NULL, [BLKVALVUP] [varchar](500) NULL, [BLOWDOWN] [varchar](500) NULL, [BODYRAT] [varchar](500) NULL, [BONNETSTYL] [varchar](500) NULL, [BUGVENT] [varchar](500) NULL, [BLTUBPRSSR] [varchar](500) NULL, [CLCCAPACTY] [varchar](500) NULL, [CLCCAPCTYU] [varchar](500) NULL, [CAMNBR] [varchar](500) NULL, [CAPTYPE] [varchar](500) NULL, [COLDPRES] [varchar](500) NULL, [COMPFACTZ] [varchar](500) NULL, [CBACKPRES] [varchar](500) NULL, [DEEDPILOTS] [varchar](500) NULL, [DESIGNTYPE] [varchar](500) NULL, [DPHTHCKNSS] [varchar](500) NULL, [DPHTHCKNSU] [varchar](500) NULL, [DIFTSSTPRE] [varchar](500) NULL, [DISCHRGDEX] [varchar](500) NULL, [DISCHARGDS] [varchar](500) NULL, [DISKFIG] [varchar](500) NULL, [HASVACUUM] [varchar](500) NULL, [DISKHLDMAN] [varchar](500) NULL, [HOLDSIZE] [varchar](500) NULL, [HOLDERTYPE] [varchar](500) NULL, [DISKMATL] [varchar](500) NULL, [DISKMODEL] [varchar](500) NULL, [DISKSERIAL] [varchar](500) NULL, [DISKSERIES] [varchar](500) NULL, [DISKSIZE] [varchar](500) NULL, [DISKTYPE] [varchar](500) NULL, [DUALPILOTS] [varchar](500) NULL, [EQPROTCMNT] [varchar](500) NULL, [EQUIPTYPE] [varchar](500) NULL, [FILTERS] [varchar](500) NULL, [FLANGERATE] [varchar](500) NULL, [FLUIDSTATE] [varchar](500) NULL, [FRAGMENT] [varchar](500) NULL, [GAGGED] [varchar](500) NULL, [GUIDESET] [varchar](500) NULL, [GUDSPOSTNU] [varchar](500) NULL, [HANDWHEEL] [varchar](500) NULL, [HSBYPSVLYN] [varchar](500) NULL, [HTVAPRATIO] [varchar](500) NULL, [HTEXCHNGRS] [varchar](500) NULL, [HYDRORPRES] [varchar](500) NULL, [HYDROTIME] [varchar](500) NULL, [INLETLEN] [varchar](500) NULL, [INLTFLNGTM] [varchar](500) NULL, [INLETRATE] [varchar](500) NULL, [INLETSIZE] [varchar](500) NULL, [INLETTYPE] [varchar](500) NULL, [IPSET] [varchar](500) NULL, [ISRUPTDISK] [varchar](500) NULL, [LATENTHEAT] [varchar](500) NULL, [SPRINGRANG] [varchar](500) NULL, [LEVERTYPE] [varchar](500) NULL, [MANLBLWDWN] [varchar](500) NULL, [MAXTSTPRES] [varchar](500) NULL, [MOLECWGT] [varchar](500) NULL, [MSDSREFNO] [varchar](500) NULL, [NOZZLETYPE] [varchar](500) NULL, [OPERATVISC] [varchar](500) NULL, [OPRTNVSCSU] [varchar](500) NULL, [ORIFICDESG] [varchar](500) NULL, [ORIFICESIZ] [varchar](500) NULL, [OUTLETRATE] [varchar](500) NULL, [OUTLETSIZE] [varchar](500) NULL, [OUTLETTYPE] [varchar](500) NULL, [OVERPRESFA] [varchar](500) NULL, [OVERPRESPC] [varchar](500) NULL, [PALLTWGPRS] [varchar](500) NULL, [PALLTWPRSU] [varchar](500) NULL, [PALLETWGVC] [varchar](500) NULL, [PALLTWGVCU] [varchar](500) NULL, [PILOTACTIN] [varchar](500) NULL, [PILOTVENT] [varchar](500) NULL, [PORTCV] [varchar](500) NULL, [SETPOS] [varchar](500) NULL, [POSMODEL] [varchar](500) NULL, [POSSET] [varchar](500) NULL, [POSSETUOM] [varchar](500) NULL, [PROTLINING] [varchar](500) NULL, [RATDCAPCTY] [varchar](500) NULL, [RTDCAPCTYU] [varchar](500) NULL, [RTDVCAPCTY] [varchar](500) NULL, [RTDVCPCTYU] [varchar](500) NULL, [RBIMETHOD] [varchar](500) NULL, [RELIEVNGTM] [varchar](500) NULL, [REMOTSNSNG] [varchar](500) NULL, [REQCAPACTY] [varchar](500) NULL, [RQCAPACTYU] [varchar](500) NULL, [RQVCCAPCTY] [varchar](500) NULL, [RQVCAPCTYU] [varchar](500) NULL, [REQDCAP] [varchar](500) NULL, [RUPTPRES] [varchar](500) NULL, [RUPTPRES72] [varchar](500) NULL, [SEATLKRAT] [varchar](500) NULL, [SEATLKUOM] [varchar](500) NULL, [SEATRQPRES] [varchar](500) NULL, [STPOSITINU] [varchar](500) NULL, [HOTPRES] [varchar](500) NULL, [SHOPNO] [varchar](500) NULL, [SOLENOID] [varchar](500) NULL, [SPECIFCGRV] [varchar](500) NULL, [SPRNGCOTNG] [varchar](500) NULL, [SPRINGFREE] [varchar](500) NULL, [SPRINGNO] [varchar](500) NULL, [SPRNGRNGHG] [varchar](500) NULL, [SPRNGRANGL] [varchar](500) NULL, [SPRNGRNGUN] [varchar](500) NULL, [SPRESSRDMN] [varchar](500) NULL, [SRVSTYLE] [varchar](500) NULL, [STOREACCT] [varchar](500) NULL, [TELLTALE] [varchar](500) NULL, [TEMPCORRFC] [varchar](500) NULL, [TESTMED] [varchar](500) NULL, [DISKTORQUE] [varchar](500) NULL, [TOTALBACK] [varchar](500) NULL, [TRIMLINE] [varchar](500) NULL, [UPDTRGGACT] [varchar](500) NULL, [VACFLDSETP] [varchar](500) NULL, [VARBACK] [varchar](500) NULL, [WEIGHTPCT] [varchar](500) NULL, [ADDDT] [datetime] NULL, [CHGDT] [datetime] NULL, [CreateDate] [datetime] NOT NULL, [Timestamp] [timestamp] NULL, [Active] [bit] NOT NULL, CONSTRAINT [PK_Relief_Valve] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY], CONSTRAINT [IX_Relief_Valve] UNIQUE NONCLUSTERED ( [ProjectID] ASC, [UNITID] ASC, [EQUIPID] ASC, [EQHISTNO] ASC )WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[RepFluid] Script Date: 5/15/2023 10:45:39 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[RepFluid]( [Id] [int] IDENTITY(1,1) NOT NULL, [RepFluid] [varchar](50) NOT NULL, [ExampleMaterial] [varchar](150) NULL, [mol_wt] [numeric](6, 3) NULL, [liq_density] [numeric](6, 3) NULL, [gas_density] [numeric](6, 5) NULL, [ambient_state] [varchar](25) NULL, [fluid_type] [varchar](25) NULL, [boiling_point] [numeric](6, 2) NULL, CONSTRAINT [PK_RepFluid] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY], CONSTRAINT [IX_RepFluid] UNIQUE NONCLUSTERED ( [RepFluid] ASC )WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[SCHEDULE] Script Date: 5/15/2023 10:45:39 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[SCHEDULE]( [ProjectID] [int] NOT NULL, [Id] [int] IDENTITY(1,1) NOT NULL, [UNITID] [varchar](50) NOT NULL, [EQUIPID] [varchar](50) NOT NULL, [EQHISTNO] [numeric](5, 0) NOT NULL, [EVENTTYPE] [varchar](50) NULL, [CIRCUITID] [varchar](40) NULL, [COMPONENID] [varchar](40) NULL, [SCBDGTCOST] [numeric](12, 2) NULL, [SCBDGTHOUR] [numeric](8, 2) NULL, [DEFERBY] [varchar](40) NULL, [DEFERJUST] [varchar](255) NULL, [MAXINT] [numeric](3, 0) NULL, [OVRRIDEDT] [datetime] NULL, [EVENT] [varchar](20) NULL, [INSTRGGACT] [varchar](6) NULL, [INTACCESS] [varchar](50) NULL, [INTERVLFMT] [varchar](50) NULL, [LFBSSOVRRD] [varchar](1) NULL, [MAINTPLANN] [varchar](12) NULL, [RBIMAXINT] [numeric](3, 0) NULL, [RBIMININT] [numeric](3, 0) NULL, [NEXTEVENT] [varchar](20) NULL, [NXTOVERRDD] [datetime] NULL, [NXOVERRDUS] [varchar](40) NULL, [NXMEVINTRV] [varchar](255) NULL, [NXOVERRDJS] [varchar](255) NULL, [NOTES] [varchar](2500) NULL, [OVRRIDEDSC] [varchar](255) NULL, [OVRREAS] [varchar](10) NULL, [NXOVERRDSC] [varchar](255) NULL, [RBIBASIS] [varchar](25) NULL, [REASON] [varchar](50) NULL, [FOLLUPUSER] [varchar](40) NULL, [MSTSCHDLRN] [varchar](20) NULL, [SPECINSTR] [varchar](4000) NULL, [OVRRMTINTR] [numeric](3, 0) NULL, [OVERRDMTRJ] [varchar](255) NULL, [SLFBSSMTHD] [varchar](50) NULL, [TAPLANNING] [varchar](50) NULL, [USMSTCNVYN] [varchar](1) NULL, [USERBI] [varchar](1) NULL, [OVERRDUMTR] [varchar](1) NULL, [USEUNITSD] [varchar](1) NULL, [SCHEDSEQNO] [numeric](8, 0) NULL, [BASEDT] [datetime] NULL, [BASDATBASS] [varchar](25) NULL, [CALCBASIS] [varchar](25) NULL, [CALCRBIINT] [numeric](3, 0) NULL, [CALCULTDBS] [varchar](25) NULL, [MTHDRVSCHD] [varchar](25) NULL, [EVENTDUEDT] [datetime] NULL, [EVNOVERRDU] [varchar](40) NULL, [LIFBASISDT] [datetime] NULL, [LIFBSDTTML] [varchar](40) NULL, [NEDDEFERRL] [varchar](1) NULL, [NEEDRECALC] [varchar](1) NULL, [RBITARGETD] [datetime] NULL, [RECMNXTIND] [datetime2](0) NULL, [RLBSDINTRV] [numeric](3, 0) NULL, [RLBSDINTRF] [varchar](10) NULL, [SCHEDDATE] [datetime] NULL, [SRMATRXBSS] [varchar](25) NULL, [SMTRXINTRV] [numeric](3, 0) NULL, [Timestamp] [timestamp] NULL, [Active] [bit] NOT NULL, [CreateDate] [datetime] NOT NULL, CONSTRAINT [IX_SCHEDULE_ID] UNIQUE NONCLUSTERED ( [Id] ASC )WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY], CONSTRAINT [IX_SCHEDULE_ProjUnitEquipEqHist] UNIQUE NONCLUSTERED ( [ProjectID] ASC, [UNITID] ASC, [EQUIPID] ASC, [EQHISTNO] ASC, [CIRCUITID] ASC, [COMPONENID] ASC, [EVENTTYPE] ASC )WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[Service_Components] Script Date: 5/15/2023 10:45:39 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Service_Components]( [Id] [bigint] IDENTITY(1,1) NOT NULL, [SERVICE] [varchar](50) NOT NULL, [FLUDPRPRTY] [varchar](50) NOT NULL, [SERVICEPCT] [numeric](7, 4) NULL, [SRVCCMPNNS] [numeric](8, 0) NULL, [Active] [bit] NOT NULL, [CreateDate] [datetime] NOT NULL, [Timestamp] [timestamp] NULL, [ProjectID] [int] NOT NULL, [ServiceCompNotes_Becht] [varchar](4000) NULL, [ServiceLink] AS (CONVERT([varchar](10),[ProjectID])+[SERVICE]) PERSISTED, CONSTRAINT [PK_Service_Components] PRIMARY KEY CLUSTERED ( [SERVICE] ASC, [FLUDPRPRTY] ASC, [ProjectID] ASC )WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY], CONSTRAINT [IX_Service_Components_ID] UNIQUE NONCLUSTERED ( [Id] ASC )WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[Status_Becht] Script Date: 5/15/2023 10:45:39 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Status_Becht]( [Status] [varchar](55) NOT NULL, [CompleteYN] [varchar](1) NOT NULL, [CreatedDate] [datetime] NOT NULL, [Active] [bit] NOT NULL, [RowVersion] [timestamp] NULL, [OrderIndex] [bigint] NOT NULL, CONSTRAINT [PK_Status_Becht] PRIMARY KEY CLUSTERED ( [Status] ASC )WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY], CONSTRAINT [IX_Status_Becht] UNIQUE NONCLUSTERED ( [OrderIndex] ASC )WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[sys_picklist_tables] Script Date: 5/15/2023 10:45:39 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[sys_picklist_tables]( [ID] [int] IDENTITY(1,1) NOT NULL, [table_name] [varchar](150) NOT NULL, [display_name] [varchar](150) NOT NULL, [description] [varchar](255) NULL, [Active] [bit] NOT NULL, [CreateDate] [datetime] NOT NULL, [Timestamp] [timestamp] NULL, CONSTRAINT [PK_sys_picklist_tables] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[sys_SqlToPowerQuery_DataTypeMapping] Script Date: 5/15/2023 10:45:39 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[sys_SqlToPowerQuery_DataTypeMapping]( [ID] [int] IDENTITY(1,1) NOT NULL, [SqlDataType] [varchar](25) NOT NULL, [PQDataType] [varchar](25) NOT NULL, CONSTRAINT [PK_sys_SqlToPowerQuery_DataTypeMapping] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY], CONSTRAINT [UX_SqlDataType_PQDataType] UNIQUE NONCLUSTERED ( [SqlDataType] ASC, [PQDataType] ASC )WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[TableFields] Script Date: 5/15/2023 10:45:39 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[TableFields]( [Id] [int] IDENTITY(1,1) NOT NULL, [TableName] [varchar](50) NOT NULL, [Description] [varchar](1000) NULL, [DBF] [varchar](50) NOT NULL, [FriendlyName] [varchar](50) NOT NULL, [DbName] [varchar](50) NOT NULL, [FieldType] [varchar](50) NULL, CONSTRAINT [PK_TableFields] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[Unit] Script Date: 5/15/2023 10:45:39 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Unit]( [ID] [int] IDENTITY(1,1) NOT NULL, [ProjectID] [int] NOT NULL, [UNITID] [varchar](50) NOT NULL, [CADDRAWDIR] [varchar](255) NULL, [CAPACITYUN] [varchar](50) NULL, [COMPLEX] [varchar](50) NULL, [DESCRIPT] [varchar](50) NULL, [EXTPLNTCOD] [varchar](10) NULL, [EXTUNITID] [varchar](50) NULL, [FACILITY] [varchar](50) NULL, [GRWTOLPCT] [numeric](3, 0) NULL, [GRWTOLTHK] [numeric](6, 3) NULL, [HYDRTSTNGD] [varchar](50) NULL, [UNITINSP] [varchar](40) NULL, [LATITUDEUN] [numeric](8, 6) NULL, [LONGITUDUN] [numeric](9, 6) NULL, [LOSSTOLPCT] [numeric](3, 0) NULL, [LOSSTOLTHK] [numeric](6, 3) NULL, [MARGIN] [numeric](12, 2) NULL, [SYSMEASURE] [varchar](25) NULL, [MINEXPOSE] [numeric](3, 2) NULL, [NOTES] [varchar](2500) NULL, [OTSDRESRCS] [varchar](50) NULL, [UNATCHPATH] [varchar](255) NULL, [SHUTDOWNDT] [datetime] NULL, [SHUTDOWN2] [datetime] NULL, [SHOP] [varchar](1) NULL, [OPERSUPR] [varchar](40) NULL, [CAPACITY] [numeric](8, 0) NULL, [INSTALLDT] [datetime] NULL, [UNITTYPE] [varchar](60) NULL, [WAREHOUSE] [varchar](1) NULL, [UNITSEQNO] [numeric](8, 0) NULL, [LASTMODDT] [datetime] NULL, [LASTPALBUD] [datetime] NULL, [NEEDRECALC] [varchar](1) NULL, [NOCIRCUITS] [numeric](8, 0) NULL, [NOTMLS] [numeric](8, 0) NULL, [NOEQUIPS] [int] NULL, [RECALCDATS] [varchar](1) NULL, [Timestamp] [timestamp] NULL, [Active] [bit] NOT NULL, [CreateDate] [datetime] NOT NULL, [UnitLink] AS (CONVERT([varchar](10),[ProjectID])+[UNITID]) PERSISTED, CONSTRAINT [PK_Unit] PRIMARY KEY CLUSTERED ( [ProjectID] ASC, [UNITID] ASC )WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY], CONSTRAINT [IX_Unit] UNIQUE NONCLUSTERED ( [ID] ASC )WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[UnitSetting] Script Date: 5/15/2023 10:45:39 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[UnitSetting]( [UnitSettingID_PK] [int] IDENTITY(1,1) NOT NULL, [Unit_ID_FK] [int] NOT NULL, [Setting] [varchar](255) NOT NULL, [Value] [varchar](255) NOT NULL, CONSTRAINT [PK_UnitSetting] PRIMARY KEY CLUSTERED ( [UnitSettingID_PK] ASC )WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY], CONSTRAINT [IX_UnitSetting] UNIQUE NONCLUSTERED ( [Unit_ID_FK] ASC, [Setting] ASC )WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[UnitSettingType] Script Date: 5/15/2023 10:45:39 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[UnitSettingType]( [UnitSetting_PK] [varchar](255) NOT NULL, [Description] [varchar](255) NOT NULL, CONSTRAINT [PK_UnitSettingType] PRIMARY KEY CLUSTERED ( [UnitSetting_PK] ASC )WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO ALTER TABLE [dbo].[Circuit] ADD CONSTRAINT [DF_Circuit_EQHISTNO] DEFAULT ((0)) FOR [EQHISTNO] GO ALTER TABLE [dbo].[Circuit] ADD CONSTRAINT [DF_Circuit_CIHISTNO] DEFAULT ((0)) FOR [CIHISTNO] GO ALTER TABLE [dbo].[Circuit] ADD CONSTRAINT [DF_Circuit_MAL_ID] DEFAULT ((5)) FOR [MAL_ID] GO ALTER TABLE [dbo].[Circuit] ADD CONSTRAINT [DF_Circuit_Active] DEFAULT ((1)) FOR [Active] GO ALTER TABLE [dbo].[Circuit] ADD CONSTRAINT [DF_Circuit_CreateDate] DEFAULT (getdate()) FOR [CreateDate] GO ALTER TABLE [dbo].[Circuit] ADD CONSTRAINT [DF_Circuit_Status_Becht] DEFAULT ('Not Started') FOR [Status_Becht] GO ALTER TABLE [dbo].[circuit_consequence] ADD CONSTRAINT [DF_circuit_consequence_CIHISTNO] DEFAULT ((0)) FOR [CIHISTNO] GO ALTER TABLE [dbo].[circuit_consequence] ADD CONSTRAINT [DF_circuit_consequence_Active] DEFAULT ((1)) FOR [Active] GO ALTER TABLE [dbo].[circuit_consequence] ADD CONSTRAINT [DF_circuit_consequence_CreateDate] DEFAULT (getdate()) FOR [CreateDate] GO ALTER TABLE [dbo].[CML] ADD CONSTRAINT [DF_CML_CIHISTNO] DEFAULT ((0)) FOR [CIHISTNO] GO ALTER TABLE [dbo].[CML] ADD CONSTRAINT [DF_CML_Active] DEFAULT ((1)) FOR [Active] GO ALTER TABLE [dbo].[CML] ADD CONSTRAINT [DF_CML_CreateDate] DEFAULT (getdate()) FOR [CreateDate] GO ALTER TABLE [dbo].[COMPONENT] ADD CONSTRAINT [DF_COMPONENT_Active] DEFAULT ((1)) FOR [Active] GO ALTER TABLE [dbo].[COMPONENT] ADD CONSTRAINT [DF_COMPONENT_CreateDate] DEFAULT (getdate()) FOR [CreateDate] GO ALTER TABLE [dbo].[component_attach] ADD CONSTRAINT [DF_component_attach_Active] DEFAULT ((1)) FOR [Active] GO ALTER TABLE [dbo].[component_attach] ADD CONSTRAINT [DF_component_attach_CreateDate] DEFAULT (getdate()) FOR [CreateDate] GO ALTER TABLE [dbo].[DamageMechanisms] ADD CONSTRAINT [DF_DamageMechanisms_CreateDate] DEFAULT (getdate()) FOR [CreateDate] GO ALTER TABLE [dbo].[DamageMechanisms] ADD CONSTRAINT [DF_DamageMechanisms_Active] DEFAULT ((1)) FOR [Active] GO ALTER TABLE [dbo].[DamageMechanisms] ADD CONSTRAINT [DF_DamageMechanisms_CIHISTNO] DEFAULT ((0)) FOR [CIHISTNO] GO ALTER TABLE [dbo].[DamageMechanisms] ADD CONSTRAINT [DF_DamageMechanisms_Becht_OVERRIDE] DEFAULT ((0)) FOR [Becht_OVERRIDE] GO ALTER TABLE [dbo].[DamageMechanisms] ADD CONSTRAINT [DF_DamageMechanisms_Becht_SUSCEPTIBL] DEFAULT ((0)) FOR [Becht_SUSCEPTIBL] GO ALTER TABLE [dbo].[equip_attach] ADD CONSTRAINT [DF_equip_attach_Active] DEFAULT ((1)) FOR [Active] GO ALTER TABLE [dbo].[equip_attach] ADD CONSTRAINT [DF_equip_attach_CreateDate] DEFAULT (getdate()) FOR [CreateDate] GO ALTER TABLE [dbo].[Equipment] ADD CONSTRAINT [DF_Equipment_EQHISTNO] DEFAULT ((0)) FOR [EQHISTNO] GO ALTER TABLE [dbo].[Equipment] ADD CONSTRAINT [DF_Equipment_MAL_ID] DEFAULT ((5)) FOR [MAL_ID] GO ALTER TABLE [dbo].[Equipment] ADD CONSTRAINT [DF_Equipment_Active] DEFAULT ((1)) FOR [Active] GO ALTER TABLE [dbo].[Equipment] ADD CONSTRAINT [DF_Equipment_CreateDate] DEFAULT (getdate()) FOR [CreateDate] GO ALTER TABLE [dbo].[Equipment] ADD CONSTRAINT [DF_Equipment_Status_Becht] DEFAULT ('Not Started') FOR [Status_Becht] GO ALTER TABLE [dbo].[EVENT] ADD CONSTRAINT [DF_EVENT_CIHISTNO] DEFAULT ((0)) FOR [CIHISTNO] GO ALTER TABLE [dbo].[EVENT] ADD CONSTRAINT [DF_EVENT_COHISTNO] DEFAULT ((0)) FOR [COHISTNO] GO ALTER TABLE [dbo].[EVENT] ADD CONSTRAINT [DF_EVENT_Active] DEFAULT ((1)) FOR [Active] GO ALTER TABLE [dbo].[EVENT] ADD CONSTRAINT [DF_EVENT_CreateDate] DEFAULT (getdate()) FOR [CreateDate] GO ALTER TABLE [dbo].[EVENT] ADD CONSTRAINT [DF_EVENT_Status_Becht] DEFAULT ('Not Started') FOR [Status_Becht] GO ALTER TABLE [dbo].[event_attach] ADD CONSTRAINT [DF_event_attach_Active] DEFAULT ((1)) FOR [Active] GO ALTER TABLE [dbo].[event_attach] ADD CONSTRAINT [DF_event_attach_CreateDate] DEFAULT (getdate()) FOR [CreateDate] GO ALTER TABLE [dbo].[EVENT_REPORT] ADD CONSTRAINT [DF_EVENT_REPORT_Active] DEFAULT ((1)) FOR [Active] GO ALTER TABLE [dbo].[EVENT_REPORT] ADD CONSTRAINT [DF_EVENT_REPORT_CreateDate] DEFAULT (getdate()) FOR [CreateDate] GO ALTER TABLE [dbo].[EVENT_REPORT] ADD CONSTRAINT [DF_EVENT_REPORT_Status_Becht] DEFAULT ('Not Started') FOR [Status_Becht] GO ALTER TABLE [dbo].[EVENT_REPORT] ADD CONSTRAINT [DF_EVENT_REPORT_CIHISTNO] DEFAULT ((0)) FOR [CIHISTNO] GO ALTER TABLE [dbo].[EVENT_REPORT] ADD CONSTRAINT [DF_EVENT_REPORT_COHISTNO] DEFAULT ((0)) FOR [COHISTNO] GO ALTER TABLE [dbo].[EXP_SERVICE] ADD CONSTRAINT [DF_EXP_SERVICE_Active] DEFAULT ((1)) FOR [Active] GO ALTER TABLE [dbo].[EXP_SERVICE] ADD CONSTRAINT [DF_EXP_SERVICE_CreateDate] DEFAULT (getdate()) FOR [CreateDate] GO ALTER TABLE [dbo].[FieldStatus] ADD CONSTRAINT [DF_FieldStatus_Active] DEFAULT ((1)) FOR [Active] GO ALTER TABLE [dbo].[FieldStatus] ADD CONSTRAINT [DF_FieldStatus_AddDt] DEFAULT (getdate()) FOR [AddDt] GO ALTER TABLE [dbo].[FieldStatus] ADD CONSTRAINT [DF_FieldStatus_CreateDate] DEFAULT (getdate()) FOR [CreateDate] GO ALTER TABLE [dbo].[FieldStatusType] ADD CONSTRAINT [DF_FieldStatusType_Active] DEFAULT ((1)) FOR [Active] GO ALTER TABLE [dbo].[FieldStatusType] ADD CONSTRAINT [DF_FieldStatusType_CreateDate] DEFAULT (getdate()) FOR [CreateDate] GO ALTER TABLE [dbo].[IWR] ADD CONSTRAINT [DF_IWR_Active] DEFAULT ((1)) FOR [Active] GO ALTER TABLE [dbo].[IWR] ADD CONSTRAINT [DF_IWR_CreateDate] DEFAULT (getdate()) FOR [CreateDate] GO ALTER TABLE [dbo].[IWR] ADD CONSTRAINT [DF_IWR_Status_Becht] DEFAULT ('Not Started') FOR [Status_Becht] GO ALTER TABLE [dbo].[MasterAssetList] ADD CONSTRAINT [DF_MasterAssetList_InScopeYN] DEFAULT ('Y') FOR [InScopeYN] GO ALTER TABLE [dbo].[MasterAssetList] ADD CONSTRAINT [DF_MasterAssetList_add_dt] DEFAULT (getdate()) FOR [add_dt] GO ALTER TABLE [dbo].[MasterAssetList] ADD CONSTRAINT [DF_MasterAssetList_Active] DEFAULT ((1)) FOR [Active] GO ALTER TABLE [dbo].[MasterAssetList] ADD CONSTRAINT [DF_MasterAssetList_CreateDate] DEFAULT (getdate()) FOR [CreateDate] GO ALTER TABLE [dbo].[MOC] ADD CONSTRAINT [DF_MOC_AddDt] DEFAULT (getdate()) FOR [AddDt] GO ALTER TABLE [dbo].[MOC] ADD CONSTRAINT [DF_MOC_Active] DEFAULT ((1)) FOR [Active] GO ALTER TABLE [dbo].[MOC] ADD CONSTRAINT [DF_MOC_CreateDate] DEFAULT (getdate()) FOR [CreateDate] GO ALTER TABLE [dbo].[MOC] ADD CONSTRAINT [DF_MOC_Status_Becht] DEFAULT ('Not Started') FOR [Status_Becht] GO ALTER TABLE [dbo].[MOC] ADD CONSTRAINT [DF_MOC_MOC_Type_ID_FK] DEFAULT ((1)) FOR [MOC_Type_ID_FK] GO ALTER TABLE [dbo].[MOC_Assoc] ADD CONSTRAINT [DF_MOC_Assoc_Active] DEFAULT ((1)) FOR [Active] GO ALTER TABLE [dbo].[MOC_Assoc] ADD CONSTRAINT [DF_MOC_Assoc_CreateDate] DEFAULT (getdate()) FOR [CreateDate] GO ALTER TABLE [dbo].[MOC_Assoc] ADD CONSTRAINT [DF_MOC_Assoc_Status_Becht] DEFAULT ('Not Started') FOR [Status_Becht] GO ALTER TABLE [dbo].[MOC_Status] ADD CONSTRAINT [DF_MOC_Status_Active] DEFAULT ((1)) FOR [Active] GO ALTER TABLE [dbo].[MOC_Status] ADD CONSTRAINT [DF_MOC_Status_CreateDate] DEFAULT (getdate()) FOR [CreateDate] GO ALTER TABLE [dbo].[Notes] ADD CONSTRAINT [DF_Notes_CreateDate] DEFAULT (getdate()) FOR [CreateDate] GO ALTER TABLE [dbo].[Notes] ADD CONSTRAINT [DF_Notes_Active] DEFAULT ((1)) FOR [Active] GO ALTER TABLE [dbo].[Notes_Type] ADD CONSTRAINT [DF_Notes_Type_Active] DEFAULT ((1)) FOR [Active] GO ALTER TABLE [dbo].[Notes_Type] ADD CONSTRAINT [DF_Notes_Type_CreateDate] DEFAULT (getdate()) FOR [CreateDate] GO ALTER TABLE [dbo].[Project] ADD CONSTRAINT [DF_Project_Active] DEFAULT ((1)) FOR [Active] GO ALTER TABLE [dbo].[Project] ADD CONSTRAINT [DF_Project_CreateDate] DEFAULT (getdate()) FOR [CreateDate] GO ALTER TABLE [dbo].[reading] ADD CONSTRAINT [DF_reading_Active] DEFAULT ((1)) FOR [Active] GO ALTER TABLE [dbo].[reading] ADD CONSTRAINT [DF_reading_CreateDate] DEFAULT (getdate()) FOR [CreateDate] GO ALTER TABLE [dbo].[reading] ADD CONSTRAINT [DF_reading_CIHISTNO] DEFAULT ((0)) FOR [CIHISTNO] GO ALTER TABLE [dbo].[Relief_Valve] ADD CONSTRAINT [DF_Relief_Valve_CreateDate] DEFAULT (getdate()) FOR [CreateDate] GO ALTER TABLE [dbo].[Relief_Valve] ADD CONSTRAINT [DF_Relief_Valve_Active] DEFAULT ((1)) FOR [Active] GO ALTER TABLE [dbo].[SCHEDULE] ADD CONSTRAINT [DF_SCHEDULE_Active] DEFAULT ((1)) FOR [Active] GO ALTER TABLE [dbo].[SCHEDULE] ADD CONSTRAINT [DF_SCHEDULE_CreateDate] DEFAULT (getdate()) FOR [CreateDate] GO ALTER TABLE [dbo].[Service_Components] ADD CONSTRAINT [DF_Service_Components_Active] DEFAULT ((1)) FOR [Active] GO ALTER TABLE [dbo].[Service_Components] ADD CONSTRAINT [DF_Service_Components_CreateDate] DEFAULT (getdate()) FOR [CreateDate] GO ALTER TABLE [dbo].[Status_Becht] ADD CONSTRAINT [DF_Status_Becht_CompleteYN] DEFAULT ('N') FOR [CompleteYN] GO ALTER TABLE [dbo].[Status_Becht] ADD CONSTRAINT [DF_Status_Becht_CreatedDate] DEFAULT (getdate()) FOR [CreatedDate] GO ALTER TABLE [dbo].[Status_Becht] ADD CONSTRAINT [DF_Status_Becht_Active] DEFAULT ((1)) FOR [Active] GO ALTER TABLE [dbo].[sys_picklist_tables] ADD CONSTRAINT [DF_sys_picklist_tables_Active] DEFAULT ((1)) FOR [Active] GO ALTER TABLE [dbo].[sys_picklist_tables] ADD CONSTRAINT [DF_sys_picklist_tables_CreateDate] DEFAULT (getdate()) FOR [CreateDate] GO ALTER TABLE [dbo].[Unit] ADD CONSTRAINT [DF_Unit_Active] DEFAULT ((1)) FOR [Active] GO ALTER TABLE [dbo].[Unit] ADD CONSTRAINT [DF_Unit_CreateDate] DEFAULT (getdate()) FOR [CreateDate] GO ALTER TABLE [dbo].[Circuit] WITH NOCHECK ADD CONSTRAINT [FK_Circuit_environment] FOREIGN KEY([ProjectID], [ENVIRONMNT]) REFERENCES [pcms].[Environment] ([ProjectID], [name]) GO ALTER TABLE [dbo].[Circuit] CHECK CONSTRAINT [FK_Circuit_environment] GO ALTER TABLE [dbo].[Circuit] WITH NOCHECK ADD CONSTRAINT [FK_Circuit_Equipment] FOREIGN KEY([ProjectID], [UNITID], [EQUIPID], [EQHISTNO]) REFERENCES [dbo].[Equipment] ([ProjectID], [UNITID], [EQUIPID], [EQHISTNO]) ON UPDATE CASCADE GO ALTER TABLE [dbo].[Circuit] CHECK CONSTRAINT [FK_Circuit_Equipment] GO ALTER TABLE [dbo].[Circuit] WITH NOCHECK ADD CONSTRAINT [FK_Circuit_EXP_SERVICE] FOREIGN KEY([SERVICE], [ProjectID]) REFERENCES [dbo].[EXP_SERVICE] ([SERVICE], [ProjectID]) ON UPDATE CASCADE GO ALTER TABLE [dbo].[Circuit] CHECK CONSTRAINT [FK_Circuit_EXP_SERVICE] GO ALTER TABLE [dbo].[Circuit] WITH NOCHECK ADD CONSTRAINT [FK_Circuit_MasterAssetList] FOREIGN KEY([MAL_ID]) REFERENCES [dbo].[MasterAssetList] ([MAL_ID]) GO ALTER TABLE [dbo].[Circuit] CHECK CONSTRAINT [FK_Circuit_MasterAssetList] GO ALTER TABLE [dbo].[Circuit] WITH NOCHECK ADD CONSTRAINT [FK_Circuit_Project] FOREIGN KEY([ProjectID]) REFERENCES [dbo].[Project] ([ProjectID]) GO ALTER TABLE [dbo].[Circuit] CHECK CONSTRAINT [FK_Circuit_Project] GO ALTER TABLE [dbo].[Circuit] WITH NOCHECK ADD CONSTRAINT [FK_Circuit_RepFluid] FOREIGN KEY([RepFluid_ID_FK]) REFERENCES [dbo].[RepFluid] ([Id]) GO ALTER TABLE [dbo].[Circuit] CHECK CONSTRAINT [FK_Circuit_RepFluid] GO ALTER TABLE [dbo].[Circuit] WITH NOCHECK ADD CONSTRAINT [FK_Circuit_Status_Becht] FOREIGN KEY([Status_Becht]) REFERENCES [dbo].[Status_Becht] ([Status]) GO ALTER TABLE [dbo].[Circuit] CHECK CONSTRAINT [FK_Circuit_Status_Becht] GO ALTER TABLE [dbo].[Circuit] WITH NOCHECK ADD CONSTRAINT [FK_Circuit_system] FOREIGN KEY([SYSTEMID], [ProjectID]) REFERENCES [pcms].[system] ([system_code], [ProjectID]) GO ALTER TABLE [dbo].[Circuit] CHECK CONSTRAINT [FK_Circuit_system] GO ALTER TABLE [dbo].[circuit_consequence] WITH NOCHECK ADD CONSTRAINT [FK_circuit_consequence_Circuit] FOREIGN KEY([ProjectID], [UNITID], [EQUIPID], [EQHISTNO], [CIRCUITID], [CIHISTNO]) REFERENCES [dbo].[Circuit] ([ProjectID], [UNITID], [EQUIPID], [EQHISTNO], [CIRCUITID], [CIHISTNO]) ON UPDATE CASCADE GO ALTER TABLE [dbo].[circuit_consequence] CHECK CONSTRAINT [FK_circuit_consequence_Circuit] GO ALTER TABLE [dbo].[circuit_consequence] WITH NOCHECK ADD CONSTRAINT [FK_circuit_consequence_Project] FOREIGN KEY([ProjectID]) REFERENCES [dbo].[Project] ([ProjectID]) GO ALTER TABLE [dbo].[circuit_consequence] CHECK CONSTRAINT [FK_circuit_consequence_Project] GO ALTER TABLE [dbo].[CML] WITH NOCHECK ADD CONSTRAINT [FK_CML_access_method] FOREIGN KEY([ACCESSMETH], [ProjectID]) REFERENCES [pcms].[access_method] ([name], [ProjectID]) GO ALTER TABLE [dbo].[CML] CHECK CONSTRAINT [FK_CML_access_method] GO ALTER TABLE [dbo].[CML] WITH NOCHECK ADD CONSTRAINT [FK_CML_Circuit] FOREIGN KEY([ProjectID], [UNITID], [EQUIPID], [EQHISTNO], [CIRCUITID], [CIHISTNO]) REFERENCES [dbo].[Circuit] ([ProjectID], [UNITID], [EQUIPID], [EQHISTNO], [CIRCUITID], [CIHISTNO]) ON UPDATE CASCADE GO ALTER TABLE [dbo].[CML] CHECK CONSTRAINT [FK_CML_Circuit] GO ALTER TABLE [dbo].[CML] WITH NOCHECK ADD CONSTRAINT [FK_CML_insulation_type] FOREIGN KEY([ProjectID], [INSULATION]) REFERENCES [pcms].[insulation_type] ([ProjectID], [name]) GO ALTER TABLE [dbo].[CML] CHECK CONSTRAINT [FK_CML_insulation_type] GO ALTER TABLE [dbo].[CML] WITH NOCHECK ADD CONSTRAINT [FK_CML_material] FOREIGN KEY([MATERIAL], [ProjectID]) REFERENCES [pcms].[material] ([name], [ProjectID]) GO ALTER TABLE [dbo].[CML] CHECK CONSTRAINT [FK_CML_material] GO ALTER TABLE [dbo].[CML] WITH NOCHECK ADD CONSTRAINT [FK_CML_override_reason] FOREIGN KEY([ProjectID], [OVRREAS]) REFERENCES [pcms].[override_reason] ([ProjectID], [override_reason_code]) ON UPDATE CASCADE GO ALTER TABLE [dbo].[CML] CHECK CONSTRAINT [FK_CML_override_reason] GO ALTER TABLE [dbo].[CML] WITH NOCHECK ADD CONSTRAINT [FK_CML_pipe_schedule] FOREIGN KEY([ProjectID], [PIPESCHED]) REFERENCES [pcms].[pipe_schedule] ([ProjectID], [code]) GO ALTER TABLE [dbo].[CML] CHECK CONSTRAINT [FK_CML_pipe_schedule] GO ALTER TABLE [dbo].[CML] WITH NOCHECK ADD CONSTRAINT [FK_CML_Project] FOREIGN KEY([ProjectID]) REFERENCES [dbo].[Project] ([ProjectID]) GO ALTER TABLE [dbo].[CML] CHECK CONSTRAINT [FK_CML_Project] GO ALTER TABLE [dbo].[CML] WITH NOCHECK ADD CONSTRAINT [FK_CML_ta_planning] FOREIGN KEY([TAPLANNING], [ProjectID]) REFERENCES [pcms].[ta_planning] ([name], [ProjectID]) GO ALTER TABLE [dbo].[CML] CHECK CONSTRAINT [FK_CML_ta_planning] GO ALTER TABLE [dbo].[COMPONENT] WITH NOCHECK ADD CONSTRAINT [FK_COMPONENT_access_method] FOREIGN KEY([ACCESSMETH], [ProjectID]) REFERENCES [pcms].[access_method] ([name], [ProjectID]) GO ALTER TABLE [dbo].[COMPONENT] CHECK CONSTRAINT [FK_COMPONENT_access_method] GO ALTER TABLE [dbo].[COMPONENT] WITH NOCHECK ADD CONSTRAINT [FK_COMPONENT_component_master] FOREIGN KEY([ProjectID], [COMPMASTER]) REFERENCES [pcms].[component_master] ([ProjectID], [name]) GO ALTER TABLE [dbo].[COMPONENT] CHECK CONSTRAINT [FK_COMPONENT_component_master] GO ALTER TABLE [dbo].[COMPONENT] WITH NOCHECK ADD CONSTRAINT [FK_COMPONENT_Equipment] FOREIGN KEY([ProjectID], [UNITID], [EQUIPID], [EQHISTNO]) REFERENCES [dbo].[Equipment] ([ProjectID], [UNITID], [EQUIPID], [EQHISTNO]) ON UPDATE CASCADE GO ALTER TABLE [dbo].[COMPONENT] CHECK CONSTRAINT [FK_COMPONENT_Equipment] GO ALTER TABLE [dbo].[COMPONENT] WITH NOCHECK ADD CONSTRAINT [FK_COMPONENT_exp_service] FOREIGN KEY([SERVICE], [ProjectID]) REFERENCES [dbo].[EXP_SERVICE] ([SERVICE], [ProjectID]) ON UPDATE CASCADE GO ALTER TABLE [dbo].[COMPONENT] CHECK CONSTRAINT [FK_COMPONENT_exp_service] GO ALTER TABLE [dbo].[COMPONENT] WITH NOCHECK ADD CONSTRAINT [FK_COMPONENT_pipe_spec] FOREIGN KEY([ProjectID], [PIPESPEC]) REFERENCES [pcms].[pipe_spec] ([ProjectID], [name]) GO ALTER TABLE [dbo].[COMPONENT] CHECK CONSTRAINT [FK_COMPONENT_pipe_spec] GO ALTER TABLE [dbo].[COMPONENT] WITH NOCHECK ADD CONSTRAINT [FK_COMPONENT_Project] FOREIGN KEY([ProjectID]) REFERENCES [dbo].[Project] ([ProjectID]) GO ALTER TABLE [dbo].[COMPONENT] CHECK CONSTRAINT [FK_COMPONENT_Project] GO ALTER TABLE [dbo].[COMPONENT] WITH NOCHECK ADD CONSTRAINT [FK_COMPONENT_support_type] FOREIGN KEY([SUPPTYPE], [ProjectID]) REFERENCES [pcms].[support_type] ([name], [ProjectID]) GO ALTER TABLE [dbo].[COMPONENT] CHECK CONSTRAINT [FK_COMPONENT_support_type] GO ALTER TABLE [dbo].[COMPONENT] WITH NOCHECK ADD CONSTRAINT [FK_COMPONENT_system] FOREIGN KEY([SYSTEMID], [ProjectID]) REFERENCES [pcms].[system] ([system_code], [ProjectID]) GO ALTER TABLE [dbo].[COMPONENT] CHECK CONSTRAINT [FK_COMPONENT_system] GO ALTER TABLE [dbo].[component_attach] WITH CHECK ADD CONSTRAINT [FK_component_attach_Project] FOREIGN KEY([ProjectID]) REFERENCES [dbo].[Project] ([ProjectID]) GO ALTER TABLE [dbo].[component_attach] CHECK CONSTRAINT [FK_component_attach_Project] GO ALTER TABLE [dbo].[DamageMechanisms] WITH NOCHECK ADD CONSTRAINT [FK_DamageMechanisms_Circuit] FOREIGN KEY([ProjectID], [UNITID], [EQUIPID], [EQHISTNO], [CIRCUITID], [CIHISTNO]) REFERENCES [dbo].[Circuit] ([ProjectID], [UNITID], [EQUIPID], [EQHISTNO], [CIRCUITID], [CIHISTNO]) ON UPDATE CASCADE GO ALTER TABLE [dbo].[DamageMechanisms] CHECK CONSTRAINT [FK_DamageMechanisms_Circuit] GO ALTER TABLE [dbo].[DamageMechanisms] WITH NOCHECK ADD CONSTRAINT [FK_DamageMechanisms_damage_mechanism] FOREIGN KEY([ProjectID], [DAMAGEMECH]) REFERENCES [pcms].[damage_mechanism] ([ProjectID], [name]) GO ALTER TABLE [dbo].[DamageMechanisms] CHECK CONSTRAINT [FK_DamageMechanisms_damage_mechanism] GO ALTER TABLE [dbo].[DamageMechanisms] WITH NOCHECK ADD CONSTRAINT [FK_DamageMechanisms_damage_type] FOREIGN KEY([ProjectID], [DAMAGETYPE]) REFERENCES [pcms].[damage_type] ([ProjectID], [damage_type]) GO ALTER TABLE [dbo].[DamageMechanisms] CHECK CONSTRAINT [FK_DamageMechanisms_damage_type] GO ALTER TABLE [dbo].[DamageMechanisms] WITH NOCHECK ADD CONSTRAINT [FK_DamageMechanisms_damage_type_BechtDT] FOREIGN KEY([ProjectID], [Becht_DAMAGETYPE]) REFERENCES [pcms].[damage_type] ([ProjectID], [damage_type]) ON UPDATE CASCADE GO ALTER TABLE [dbo].[DamageMechanisms] CHECK CONSTRAINT [FK_DamageMechanisms_damage_type_BechtDT] GO ALTER TABLE [dbo].[DamageMechanisms] WITH NOCHECK ADD CONSTRAINT [FK_DamageMechanisms_DamageMechanismStatus] FOREIGN KEY([DamageMechanismStatus_ID_FK]) REFERENCES [dbo].[DamageMechanismStatus] ([ID]) GO ALTER TABLE [dbo].[DamageMechanisms] CHECK CONSTRAINT [FK_DamageMechanisms_DamageMechanismStatus] GO ALTER TABLE [dbo].[DamageMechanisms] WITH NOCHECK ADD CONSTRAINT [FK_DamageMechanisms_Project] FOREIGN KEY([ProjectID]) REFERENCES [dbo].[Project] ([ProjectID]) GO ALTER TABLE [dbo].[DamageMechanisms] CHECK CONSTRAINT [FK_DamageMechanisms_Project] GO ALTER TABLE [dbo].[DamageMechanisms] WITH NOCHECK ADD CONSTRAINT [FK_DamageMechanisms_risk_level] FOREIGN KEY([ProjectID], [RISKLEVEL]) REFERENCES [pcms].[risk_level] ([ProjectID], [name]) GO ALTER TABLE [dbo].[DamageMechanisms] CHECK CONSTRAINT [FK_DamageMechanisms_risk_level] GO ALTER TABLE [dbo].[DamageMechanisms] WITH NOCHECK ADD CONSTRAINT [FK_DamageMechanisms_risk_level_BECHT] FOREIGN KEY([ProjectID], [Becht_RISKLEVEL]) REFERENCES [pcms].[risk_level] ([ProjectID], [name]) GO ALTER TABLE [dbo].[DamageMechanisms] CHECK CONSTRAINT [FK_DamageMechanisms_risk_level_BECHT] GO ALTER TABLE [dbo].[DamageMechanisms] WITH NOCHECK ADD CONSTRAINT [FK_DamageMechanisms_security_user] FOREIGN KEY([USER], [ProjectID]) REFERENCES [pcms].[security_user] ([picklist_name], [ProjectID]) GO ALTER TABLE [dbo].[DamageMechanisms] CHECK CONSTRAINT [FK_DamageMechanisms_security_user] GO ALTER TABLE [dbo].[equip_attach] WITH CHECK ADD CONSTRAINT [FK_equip_attach_Equipment] FOREIGN KEY([ProjectID], [UNITID], [EQUIPID], [EQHISTNO]) REFERENCES [dbo].[Equipment] ([ProjectID], [UNITID], [EQUIPID], [EQHISTNO]) GO ALTER TABLE [dbo].[equip_attach] CHECK CONSTRAINT [FK_equip_attach_Equipment] GO ALTER TABLE [dbo].[equip_attach] WITH CHECK ADD CONSTRAINT [FK_equip_attach_Project] FOREIGN KEY([ProjectID]) REFERENCES [dbo].[Project] ([ProjectID]) GO ALTER TABLE [dbo].[equip_attach] CHECK CONSTRAINT [FK_equip_attach_Project] GO ALTER TABLE [dbo].[Equipment] WITH NOCHECK ADD CONSTRAINT [FK_Equipment_access_method] FOREIGN KEY([ACCESSMETH], [ProjectID]) REFERENCES [pcms].[access_method] ([name], [ProjectID]) GO ALTER TABLE [dbo].[Equipment] CHECK CONSTRAINT [FK_Equipment_access_method] GO ALTER TABLE [dbo].[Equipment] WITH NOCHECK ADD CONSTRAINT [FK_Equipment_area] FOREIGN KEY([ProjectID], [AREA]) REFERENCES [pcms].[area] ([ProjectID], [area_id]) ON UPDATE CASCADE GO ALTER TABLE [dbo].[Equipment] CHECK CONSTRAINT [FK_Equipment_area] GO ALTER TABLE [dbo].[Equipment] WITH NOCHECK ADD CONSTRAINT [FK_Equipment_class] FOREIGN KEY([ProjectID], [CLASS]) REFERENCES [pcms].[class] ([ProjectID], [class_code]) GO ALTER TABLE [dbo].[Equipment] CHECK CONSTRAINT [FK_Equipment_class] GO ALTER TABLE [dbo].[Equipment] WITH NOCHECK ADD CONSTRAINT [FK_Equipment_cost_center] FOREIGN KEY([ProjectID], [COSTCENTER]) REFERENCES [pcms].[cost_center] ([ProjectID], [cost_center_code]) ON UPDATE CASCADE GO ALTER TABLE [dbo].[Equipment] CHECK CONSTRAINT [FK_Equipment_cost_center] GO ALTER TABLE [dbo].[Equipment] WITH NOCHECK ADD CONSTRAINT [FK_Equipment_drain_type] FOREIGN KEY([DRAINTYPE], [ProjectID]) REFERENCES [pcms].[drain_type] ([name], [ProjectID]) ON UPDATE CASCADE GO ALTER TABLE [dbo].[Equipment] CHECK CONSTRAINT [FK_Equipment_drain_type] GO ALTER TABLE [dbo].[Equipment] WITH NOCHECK ADD CONSTRAINT [FK_Equipment_equip_type] FOREIGN KEY([ProjectID], [EQUIPTYPE]) REFERENCES [pcms].[equip_type] ([ProjectID], [name]) ON UPDATE CASCADE GO ALTER TABLE [dbo].[Equipment] CHECK CONSTRAINT [FK_Equipment_equip_type] GO ALTER TABLE [dbo].[Equipment] WITH NOCHECK ADD CONSTRAINT [FK_Equipment_foundation_type] FOREIGN KEY([FOUNDATION], [ProjectID]) REFERENCES [pcms].[foundation_type] ([name], [ProjectID]) GO ALTER TABLE [dbo].[Equipment] CHECK CONSTRAINT [FK_Equipment_foundation_type] GO ALTER TABLE [dbo].[Equipment] WITH NOCHECK ADD CONSTRAINT [FK_Equipment_governing_code] FOREIGN KEY([GOVERNCODE], [ProjectID]) REFERENCES [pcms].[governing_code] ([name], [ProjectID]) GO ALTER TABLE [dbo].[Equipment] CHECK CONSTRAINT [FK_Equipment_governing_code] GO ALTER TABLE [dbo].[Equipment] WITH NOCHECK ADD CONSTRAINT [FK_Equipment_insulation_type] FOREIGN KEY([ProjectID], [INSULATION]) REFERENCES [pcms].[insulation_type] ([ProjectID], [name]) ON UPDATE CASCADE GO ALTER TABLE [dbo].[Equipment] CHECK CONSTRAINT [FK_Equipment_insulation_type] GO ALTER TABLE [dbo].[Equipment] WITH NOCHECK ADD CONSTRAINT [FK_Equipment_MasterAssetList] FOREIGN KEY([MAL_ID]) REFERENCES [dbo].[MasterAssetList] ([MAL_ID]) GO ALTER TABLE [dbo].[Equipment] CHECK CONSTRAINT [FK_Equipment_MasterAssetList] GO ALTER TABLE [dbo].[Equipment] WITH NOCHECK ADD CONSTRAINT [FK_Equipment_operating_status] FOREIGN KEY([ProjectID], [OPERATSTAT]) REFERENCES [pcms].[operating_status] ([ProjectID], [name]) ON UPDATE CASCADE GO ALTER TABLE [dbo].[Equipment] CHECK CONSTRAINT [FK_Equipment_operating_status] GO ALTER TABLE [dbo].[Equipment] WITH NOCHECK ADD CONSTRAINT [FK_Equipment_process_impact] FOREIGN KEY([ProjectID], [PROCIMPACT]) REFERENCES [pcms].[process_impact] ([ProjectID], [process_impact_code]) ON UPDATE CASCADE GO ALTER TABLE [dbo].[Equipment] CHECK CONSTRAINT [FK_Equipment_process_impact] GO ALTER TABLE [dbo].[Equipment] WITH NOCHECK ADD CONSTRAINT [FK_Equipment_Project] FOREIGN KEY([ProjectID]) REFERENCES [dbo].[Project] ([ProjectID]) GO ALTER TABLE [dbo].[Equipment] CHECK CONSTRAINT [FK_Equipment_Project] GO ALTER TABLE [dbo].[Equipment] WITH NOCHECK ADD CONSTRAINT [FK_Equipment_security_user] FOREIGN KEY([AREAINSP], [ProjectID]) REFERENCES [pcms].[security_user] ([picklist_name], [ProjectID]) GO ALTER TABLE [dbo].[Equipment] CHECK CONSTRAINT [FK_Equipment_security_user] GO ALTER TABLE [dbo].[Equipment] WITH NOCHECK ADD CONSTRAINT [FK_Equipment_service] FOREIGN KEY([SERVICE], [ProjectID]) REFERENCES [pcms].[service] ([name], [ProjectID]) GO ALTER TABLE [dbo].[Equipment] CHECK CONSTRAINT [FK_Equipment_service] GO ALTER TABLE [dbo].[Equipment] WITH NOCHECK ADD CONSTRAINT [FK_Equipment_Status_Becht] FOREIGN KEY([Status_Becht]) REFERENCES [dbo].[Status_Becht] ([Status]) ON UPDATE CASCADE GO ALTER TABLE [dbo].[Equipment] CHECK CONSTRAINT [FK_Equipment_Status_Becht] GO ALTER TABLE [dbo].[Equipment] WITH NOCHECK ADD CONSTRAINT [FK_Equipment_structure] FOREIGN KEY([ProjectID], [STRUCTURE]) REFERENCES [pcms].[structure] ([ProjectID], [name]) ON UPDATE CASCADE GO ALTER TABLE [dbo].[Equipment] CHECK CONSTRAINT [FK_Equipment_structure] GO ALTER TABLE [dbo].[Equipment] WITH NOCHECK ADD CONSTRAINT [FK_Equipment_style] FOREIGN KEY([STYLE], [ProjectID]) REFERENCES [pcms].[style] ([name], [ProjectID]) ON UPDATE CASCADE GO ALTER TABLE [dbo].[Equipment] CHECK CONSTRAINT [FK_Equipment_style] GO ALTER TABLE [dbo].[Equipment] WITH NOCHECK ADD CONSTRAINT [FK_Equipment_support_type] FOREIGN KEY([SUPPTYPE], [ProjectID]) REFERENCES [pcms].[support_type] ([name], [ProjectID]) GO ALTER TABLE [dbo].[Equipment] CHECK CONSTRAINT [FK_Equipment_support_type] GO ALTER TABLE [dbo].[Equipment] WITH NOCHECK ADD CONSTRAINT [FK_Equipment_system] FOREIGN KEY([SYSTEM], [ProjectID]) REFERENCES [pcms].[system] ([system_code], [ProjectID]) GO ALTER TABLE [dbo].[Equipment] CHECK CONSTRAINT [FK_Equipment_system] GO ALTER TABLE [dbo].[Equipment] WITH NOCHECK ADD CONSTRAINT [FK_Equipment_ta_planning] FOREIGN KEY([TAPLANNING], [ProjectID]) REFERENCES [pcms].[ta_planning] ([name], [ProjectID]) GO ALTER TABLE [dbo].[Equipment] CHECK CONSTRAINT [FK_Equipment_ta_planning] GO ALTER TABLE [dbo].[Equipment] WITH NOCHECK ADD CONSTRAINT [FK_Equipment_tank_roof_type] FOREIGN KEY([TNKROOFTYP], [ProjectID]) REFERENCES [pcms].[tank_roof_type] ([tank_roof_type], [ProjectID]) ON UPDATE CASCADE GO ALTER TABLE [dbo].[Equipment] CHECK CONSTRAINT [FK_Equipment_tank_roof_type] GO ALTER TABLE [dbo].[Equipment] WITH NOCHECK ADD CONSTRAINT [FK_Equipment_tank_seal_type] FOREIGN KEY([SEALTYPE], [ProjectID]) REFERENCES [pcms].[tank_seal_type] ([name], [ProjectID]) ON UPDATE CASCADE GO ALTER TABLE [dbo].[Equipment] CHECK CONSTRAINT [FK_Equipment_tank_seal_type] GO ALTER TABLE [dbo].[Equipment] WITH NOCHECK ADD CONSTRAINT [FK_Equipment_tema] FOREIGN KEY([TEMA], [ProjectID]) REFERENCES [pcms].[tema] ([tema_id], [ProjectID]) ON UPDATE CASCADE GO ALTER TABLE [dbo].[Equipment] CHECK CONSTRAINT [FK_Equipment_tema] GO ALTER TABLE [dbo].[Equipment] WITH NOCHECK ADD CONSTRAINT [FK_Equipment_Unit] FOREIGN KEY([ProjectID], [UNITID]) REFERENCES [dbo].[Unit] ([ProjectID], [UNITID]) ON UPDATE CASCADE GO ALTER TABLE [dbo].[Equipment] CHECK CONSTRAINT [FK_Equipment_Unit] GO ALTER TABLE [dbo].[EVENT] WITH NOCHECK ADD CONSTRAINT [FK_EVENT_Circuit] FOREIGN KEY([ProjectID], [UNITID], [EQUIPID], [EQHISTNO], [CIRCUITID], [CIHISTNO]) REFERENCES [dbo].[Circuit] ([ProjectID], [UNITID], [EQUIPID], [EQHISTNO], [CIRCUITID], [CIHISTNO]) ON UPDATE CASCADE GO ALTER TABLE [dbo].[EVENT] CHECK CONSTRAINT [FK_EVENT_Circuit] GO ALTER TABLE [dbo].[EVENT] WITH NOCHECK ADD CONSTRAINT [FK_EVENT_cleaning_method] FOREIGN KEY([CLENNGMTHD], [ProjectID]) REFERENCES [pcms].[cleaning_method] ([name], [ProjectID]) ON UPDATE CASCADE GO ALTER TABLE [dbo].[EVENT] CHECK CONSTRAINT [FK_EVENT_cleaning_method] GO ALTER TABLE [dbo].[EVENT] WITH NOCHECK ADD CONSTRAINT [FK_EVENT_Equipment] FOREIGN KEY([ProjectID], [UNITID], [EQUIPID], [EQHISTNO]) REFERENCES [dbo].[Equipment] ([ProjectID], [UNITID], [EQUIPID], [EQHISTNO]) GO ALTER TABLE [dbo].[EVENT] CHECK CONSTRAINT [FK_EVENT_Equipment] GO ALTER TABLE [dbo].[EVENT] WITH NOCHECK ADD CONSTRAINT [FK_EVENT_event_type] FOREIGN KEY([EVENTTYPE], [ProjectID]) REFERENCES [pcms].[event_type] ([name], [ProjectID]) GO ALTER TABLE [dbo].[EVENT] CHECK CONSTRAINT [FK_EVENT_event_type] GO ALTER TABLE [dbo].[EVENT] WITH NOCHECK ADD CONSTRAINT [FK_EVENT_grade] FOREIGN KEY([GRADE], [ProjectID]) REFERENCES [pcms].[grade] ([grade_code], [ProjectID]) GO ALTER TABLE [dbo].[EVENT] CHECK CONSTRAINT [FK_EVENT_grade] GO ALTER TABLE [dbo].[EVENT] WITH NOCHECK ADD CONSTRAINT [FK_EVENT_Project] FOREIGN KEY([ProjectID]) REFERENCES [dbo].[Project] ([ProjectID]) GO ALTER TABLE [dbo].[EVENT] CHECK CONSTRAINT [FK_EVENT_Project] GO ALTER TABLE [dbo].[EVENT] WITH NOCHECK ADD CONSTRAINT [FK_EVENT_security_user_CLOSEBY] FOREIGN KEY([CLOSEBY], [ProjectID]) REFERENCES [pcms].[security_user] ([picklist_name], [ProjectID]) GO ALTER TABLE [dbo].[EVENT] CHECK CONSTRAINT [FK_EVENT_security_user_CLOSEBY] GO ALTER TABLE [dbo].[EVENT] WITH NOCHECK ADD CONSTRAINT [FK_EVENT_security_user_ENTEREDBY] FOREIGN KEY([ENTEREDBY], [ProjectID]) REFERENCES [pcms].[security_user] ([picklist_name], [ProjectID]) GO ALTER TABLE [dbo].[EVENT] CHECK CONSTRAINT [FK_EVENT_security_user_ENTEREDBY] GO ALTER TABLE [dbo].[EVENT] WITH NOCHECK ADD CONSTRAINT [FK_EVENT_security_user_IOR] FOREIGN KEY([IOR], [ProjectID]) REFERENCES [pcms].[security_user] ([picklist_name], [ProjectID]) GO ALTER TABLE [dbo].[EVENT] CHECK CONSTRAINT [FK_EVENT_security_user_IOR] GO ALTER TABLE [dbo].[EVENT] WITH NOCHECK ADD CONSTRAINT [FK_EVENT_Status_Becht] FOREIGN KEY([Status_Becht]) REFERENCES [dbo].[Status_Becht] ([Status]) GO ALTER TABLE [dbo].[EVENT] CHECK CONSTRAINT [FK_EVENT_Status_Becht] GO ALTER TABLE [dbo].[EVENT] WITH NOCHECK ADD CONSTRAINT [FK_EVENT_sys_event_status] FOREIGN KEY([STATUS], [ProjectID]) REFERENCES [pcms].[sys_event_status] ([sys_event_status_code], [ProjectID]) GO ALTER TABLE [dbo].[EVENT] CHECK CONSTRAINT [FK_EVENT_sys_event_status] GO ALTER TABLE [dbo].[EVENT_REPORT] WITH NOCHECK ADD CONSTRAINT [FK_EVENT RPT_ActualInspCatg] FOREIGN KEY([ACTINSPCTG], [ProjectID]) REFERENCES [pcms].[inspection_category] ([name], [ProjectID]) GO ALTER TABLE [dbo].[EVENT_REPORT] CHECK CONSTRAINT [FK_EVENT RPT_ActualInspCatg] GO ALTER TABLE [dbo].[EVENT_REPORT] WITH NOCHECK ADD CONSTRAINT [FK_EVENT RPT_RecomInspCatg] FOREIGN KEY([RECMINSCTG], [ProjectID]) REFERENCES [pcms].[inspection_category] ([name], [ProjectID]) GO ALTER TABLE [dbo].[EVENT_REPORT] CHECK CONSTRAINT [FK_EVENT RPT_RecomInspCatg] GO ALTER TABLE [dbo].[EVENT_REPORT] WITH NOCHECK ADD CONSTRAINT [FK_EVENT_REPORT_EVENT] FOREIGN KEY([ProjectID], [UNITID], [EQUIPID], [EQHISTNO], [EVENTTYPE], [EVENTDATE], [CIRCUITID], [CIHISTNO], [COMPONENID], [COHISTNO]) REFERENCES [dbo].[EVENT] ([ProjectID], [UNITID], [EQUIPID], [EQHISTNO], [EVENTTYPE], [EVENTDATE], [CIRCUITID], [CIHISTNO], [COMPONENID], [COHISTNO]) ON UPDATE CASCADE GO ALTER TABLE [dbo].[EVENT_REPORT] CHECK CONSTRAINT [FK_EVENT_REPORT_EVENT] GO ALTER TABLE [dbo].[EVENT_REPORT] WITH NOCHECK ADD CONSTRAINT [FK_EVENT_REPORT_event_type] FOREIGN KEY([EVENTTYPE], [ProjectID]) REFERENCES [pcms].[event_type] ([name], [ProjectID]) ON UPDATE CASCADE GO ALTER TABLE [dbo].[EVENT_REPORT] CHECK CONSTRAINT [FK_EVENT_REPORT_event_type] GO ALTER TABLE [dbo].[EVENT_REPORT] WITH NOCHECK ADD CONSTRAINT [FK_EVENT_REPORT_Project] FOREIGN KEY([ProjectID]) REFERENCES [dbo].[Project] ([ProjectID]) GO ALTER TABLE [dbo].[EVENT_REPORT] CHECK CONSTRAINT [FK_EVENT_REPORT_Project] GO ALTER TABLE [dbo].[EXP_SERVICE] WITH NOCHECK ADD CONSTRAINT [FK_EXP_SERVICE_Project] FOREIGN KEY([ProjectID]) REFERENCES [dbo].[Project] ([ProjectID]) GO ALTER TABLE [dbo].[EXP_SERVICE] CHECK CONSTRAINT [FK_EXP_SERVICE_Project] GO ALTER TABLE [dbo].[EXP_SERVICE] WITH NOCHECK ADD CONSTRAINT [FK_EXP_SERVICE_RepFluid] FOREIGN KEY([RepFluid_ID_FK]) REFERENCES [dbo].[RepFluid] ([Id]) GO ALTER TABLE [dbo].[EXP_SERVICE] CHECK CONSTRAINT [FK_EXP_SERVICE_RepFluid] GO ALTER TABLE [dbo].[EXP_SERVICE] WITH NOCHECK ADD CONSTRAINT [FK_EXP_SERVICE_sys_service_pct_typ] FOREIGN KEY([SVCPCTTYPE], [ProjectID]) REFERENCES [pcms].[sys_service_pct_typ] ([code], [ProjectID]) GO ALTER TABLE [dbo].[EXP_SERVICE] CHECK CONSTRAINT [FK_EXP_SERVICE_sys_service_pct_typ] GO ALTER TABLE [dbo].[FieldStatus] WITH CHECK ADD CONSTRAINT [FK_FieldStatus_FieldStatusType] FOREIGN KEY([FieldStatusType_ID]) REFERENCES [dbo].[FieldStatusType] ([Id]) GO ALTER TABLE [dbo].[FieldStatus] CHECK CONSTRAINT [FK_FieldStatus_FieldStatusType] GO ALTER TABLE [dbo].[IWR] WITH NOCHECK ADD CONSTRAINT [FK_IWR_Equipment] FOREIGN KEY([ProjectID], [UNITID], [EQUIPID], [EQHISTNO]) REFERENCES [dbo].[Equipment] ([ProjectID], [UNITID], [EQUIPID], [EQHISTNO]) ON UPDATE CASCADE GO ALTER TABLE [dbo].[IWR] CHECK CONSTRAINT [FK_IWR_Equipment] GO ALTER TABLE [dbo].[IWR] WITH NOCHECK ADD CONSTRAINT [FK_IWR_iwr_category] FOREIGN KEY([IWRCATEGRY], [ProjectID]) REFERENCES [pcms].[iwr_category] ([name], [ProjectID]) ON UPDATE CASCADE GO ALTER TABLE [dbo].[IWR] CHECK CONSTRAINT [FK_IWR_iwr_category] GO ALTER TABLE [dbo].[IWR] WITH NOCHECK ADD CONSTRAINT [FK_IWR_iwr_cause] FOREIGN KEY([IWRCAUSE], [ProjectID]) REFERENCES [pcms].[iwr_cause] ([code], [ProjectID]) ON UPDATE CASCADE GO ALTER TABLE [dbo].[IWR] CHECK CONSTRAINT [FK_IWR_iwr_cause] GO ALTER TABLE [dbo].[IWR] WITH NOCHECK ADD CONSTRAINT [FK_IWR_iwr_criticality] FOREIGN KEY([IWRCRIT], [ProjectID]) REFERENCES [pcms].[iwr_criticality] ([name], [ProjectID]) ON UPDATE CASCADE GO ALTER TABLE [dbo].[IWR] CHECK CONSTRAINT [FK_IWR_iwr_criticality] GO ALTER TABLE [dbo].[IWR] WITH NOCHECK ADD CONSTRAINT [FK_IWR_iwr_interim_status] FOREIGN KEY([IWRINTSTAT], [ProjectID]) REFERENCES [pcms].[iwr_interim_status] ([iwr_interim_status_code], [ProjectID]) ON UPDATE CASCADE GO ALTER TABLE [dbo].[IWR] CHECK CONSTRAINT [FK_IWR_iwr_interim_status] GO ALTER TABLE [dbo].[IWR] WITH NOCHECK ADD CONSTRAINT [FK_IWR_iwr_issue_type] FOREIGN KEY([IWRISSUTYP], [ProjectID]) REFERENCES [pcms].[iwr_issue_type] ([code], [ProjectID]) ON UPDATE CASCADE GO ALTER TABLE [dbo].[IWR] CHECK CONSTRAINT [FK_IWR_iwr_issue_type] GO ALTER TABLE [dbo].[IWR] WITH NOCHECK ADD CONSTRAINT [FK_IWR_iwr_priority] FOREIGN KEY([IWRPRIORIT], [ProjectID]) REFERENCES [pcms].[iwr_priority] ([priority_code], [ProjectID]) ON UPDATE CASCADE GO ALTER TABLE [dbo].[IWR] CHECK CONSTRAINT [FK_IWR_iwr_priority] GO ALTER TABLE [dbo].[IWR] WITH NOCHECK ADD CONSTRAINT [FK_IWR_iwr_type] FOREIGN KEY([IWRTYPE], [ProjectID]) REFERENCES [pcms].[iwr_type] ([code], [ProjectID]) ON UPDATE CASCADE GO ALTER TABLE [dbo].[IWR] CHECK CONSTRAINT [FK_IWR_iwr_type] GO ALTER TABLE [dbo].[IWR] WITH NOCHECK ADD CONSTRAINT [FK_IWR_Project] FOREIGN KEY([ProjectID]) REFERENCES [dbo].[Project] ([ProjectID]) GO ALTER TABLE [dbo].[IWR] CHECK CONSTRAINT [FK_IWR_Project] GO ALTER TABLE [dbo].[IWR] WITH NOCHECK ADD CONSTRAINT [FK_IWR_security_user_ClosedBy] FOREIGN KEY([CLOSEBY], [ProjectID]) REFERENCES [pcms].[security_user] ([picklist_name], [ProjectID]) GO ALTER TABLE [dbo].[IWR] CHECK CONSTRAINT [FK_IWR_security_user_ClosedBy] GO ALTER TABLE [dbo].[IWR] WITH NOCHECK ADD CONSTRAINT [FK_IWR_security_user_OpenBy] FOREIGN KEY([OPENBY], [ProjectID]) REFERENCES [pcms].[security_user] ([picklist_name], [ProjectID]) GO ALTER TABLE [dbo].[IWR] CHECK CONSTRAINT [FK_IWR_security_user_OpenBy] GO ALTER TABLE [dbo].[IWR] WITH NOCHECK ADD CONSTRAINT [FK_IWR_Status_Becht] FOREIGN KEY([Status_Becht]) REFERENCES [dbo].[Status_Becht] ([Status]) GO ALTER TABLE [dbo].[IWR] CHECK CONSTRAINT [FK_IWR_Status_Becht] GO ALTER TABLE [dbo].[IWR] WITH NOCHECK ADD CONSTRAINT [FK_IWR_sys_event_status] FOREIGN KEY([STATUS], [ProjectID]) REFERENCES [pcms].[sys_event_status] ([sys_event_status_code], [ProjectID]) GO ALTER TABLE [dbo].[IWR] CHECK CONSTRAINT [FK_IWR_sys_event_status] GO ALTER TABLE [dbo].[IWR] WITH NOCHECK ADD CONSTRAINT [FK_IWR_work_type] FOREIGN KEY([WORKTYPE], [ProjectID]) REFERENCES [pcms].[work_type] ([name], [ProjectID]) ON UPDATE CASCADE GO ALTER TABLE [dbo].[IWR] CHECK CONSTRAINT [FK_IWR_work_type] GO ALTER TABLE [dbo].[MOC] WITH CHECK ADD CONSTRAINT [FK_MOC_MOC_Status] FOREIGN KEY([MOC_Status_ID]) REFERENCES [dbo].[MOC_Status] ([ID]) GO ALTER TABLE [dbo].[MOC] CHECK CONSTRAINT [FK_MOC_MOC_Status] GO ALTER TABLE [dbo].[MOC] WITH CHECK ADD CONSTRAINT [FK_MOC_MOC_Type] FOREIGN KEY([MOC_Type_ID_FK]) REFERENCES [dbo].[MOC_Type] ([MOC_Type_ID]) GO ALTER TABLE [dbo].[MOC] CHECK CONSTRAINT [FK_MOC_MOC_Type] GO ALTER TABLE [dbo].[MOC] WITH CHECK ADD CONSTRAINT [FK_MOC_Project] FOREIGN KEY([ProjectID]) REFERENCES [dbo].[Project] ([ProjectID]) GO ALTER TABLE [dbo].[MOC] CHECK CONSTRAINT [FK_MOC_Project] GO ALTER TABLE [dbo].[MOC] WITH CHECK ADD CONSTRAINT [FK_MOC_Status_Becht] FOREIGN KEY([Status_Becht]) REFERENCES [dbo].[Status_Becht] ([Status]) ON UPDATE CASCADE GO ALTER TABLE [dbo].[MOC] CHECK CONSTRAINT [FK_MOC_Status_Becht] GO ALTER TABLE [dbo].[MOC] WITH CHECK ADD CONSTRAINT [FK_MOC_Unit] FOREIGN KEY([UnitID]) REFERENCES [dbo].[Unit] ([ID]) GO ALTER TABLE [dbo].[MOC] CHECK CONSTRAINT [FK_MOC_Unit] GO ALTER TABLE [dbo].[MOC_Assoc] WITH CHECK ADD CONSTRAINT [FK_MOC_Assoc_Circuit] FOREIGN KEY([CircuitID]) REFERENCES [dbo].[Circuit] ([Id]) GO ALTER TABLE [dbo].[MOC_Assoc] CHECK CONSTRAINT [FK_MOC_Assoc_Circuit] GO ALTER TABLE [dbo].[MOC_Assoc] WITH CHECK ADD CONSTRAINT [FK_MOC_Assoc_Equipment] FOREIGN KEY([EquipID]) REFERENCES [dbo].[Equipment] ([Id]) GO ALTER TABLE [dbo].[MOC_Assoc] CHECK CONSTRAINT [FK_MOC_Assoc_Equipment] GO ALTER TABLE [dbo].[MOC_Assoc] WITH CHECK ADD CONSTRAINT [FK_MOC_Assoc_MOC] FOREIGN KEY([MOC_ID]) REFERENCES [dbo].[MOC] ([MOC_ID]) ON DELETE CASCADE GO ALTER TABLE [dbo].[MOC_Assoc] CHECK CONSTRAINT [FK_MOC_Assoc_MOC] GO ALTER TABLE [dbo].[Notes] WITH CHECK ADD CONSTRAINT [FK_Notes_Notes_Type] FOREIGN KEY([Notes_Type_ID]) REFERENCES [dbo].[Notes_Type] ([Id]) GO ALTER TABLE [dbo].[Notes] CHECK CONSTRAINT [FK_Notes_Notes_Type] GO ALTER TABLE [dbo].[ProjectLinks] WITH CHECK ADD CONSTRAINT [FK_ProjectLinks_Project] FOREIGN KEY([ProjectID_FK]) REFERENCES [dbo].[Project] ([ProjectID]) GO ALTER TABLE [dbo].[ProjectLinks] CHECK CONSTRAINT [FK_ProjectLinks_Project] GO ALTER TABLE [dbo].[reading] WITH NOCHECK ADD CONSTRAINT [FK_reading_CML] FOREIGN KEY([ProjectID], [UNITID], [EQUIPID], [EQHISTNO], [CIRCUITID], [CIHISTNO], [TMLID], [TMHISTNO]) REFERENCES [dbo].[CML] ([ProjectID], [UNITID], [EQUIPID], [EQHISTNO], [CIRCUITID], [CIHISTNO], [TMLID], [TMHISTNO]) ON UPDATE CASCADE GO ALTER TABLE [dbo].[reading] CHECK CONSTRAINT [FK_reading_CML] GO ALTER TABLE [dbo].[reading] WITH NOCHECK ADD CONSTRAINT [FK_reading_location] FOREIGN KEY([ProjectID], [LOCATION]) REFERENCES [pcms].[location] ([ProjectID], [code]) ON UPDATE CASCADE GO ALTER TABLE [dbo].[reading] CHECK CONSTRAINT [FK_reading_location] GO ALTER TABLE [dbo].[reading] WITH NOCHECK ADD CONSTRAINT [FK_reading_Project] FOREIGN KEY([ProjectID]) REFERENCES [dbo].[Project] ([ProjectID]) GO ALTER TABLE [dbo].[reading] CHECK CONSTRAINT [FK_reading_Project] GO ALTER TABLE [dbo].[reading] WITH NOCHECK ADD CONSTRAINT [FK_reading_security_user_EnteredBy] FOREIGN KEY([ENTEREDBY], [ProjectID]) REFERENCES [pcms].[security_user] ([picklist_name], [ProjectID]) GO ALTER TABLE [dbo].[reading] CHECK CONSTRAINT [FK_reading_security_user_EnteredBy] GO ALTER TABLE [dbo].[reading] WITH NOCHECK ADD CONSTRAINT [FK_reading_security_user_INSPECTOR] FOREIGN KEY([INSPECTOR], [ProjectID]) REFERENCES [pcms].[security_user] ([picklist_name], [ProjectID]) GO ALTER TABLE [dbo].[reading] CHECK CONSTRAINT [FK_reading_security_user_INSPECTOR] GO ALTER TABLE [dbo].[Relief_Valve] WITH CHECK ADD CONSTRAINT [FK_Relief_Valve_Project] FOREIGN KEY([ProjectID]) REFERENCES [dbo].[Project] ([ProjectID]) GO ALTER TABLE [dbo].[Relief_Valve] CHECK CONSTRAINT [FK_Relief_Valve_Project] GO ALTER TABLE [dbo].[SCHEDULE] WITH NOCHECK ADD CONSTRAINT [FK_SCHEDULE_Equipment] FOREIGN KEY([ProjectID], [UNITID], [EQUIPID], [EQHISTNO]) REFERENCES [dbo].[Equipment] ([ProjectID], [UNITID], [EQUIPID], [EQHISTNO]) ON UPDATE CASCADE GO ALTER TABLE [dbo].[SCHEDULE] CHECK CONSTRAINT [FK_SCHEDULE_Equipment] GO ALTER TABLE [dbo].[SCHEDULE] WITH NOCHECK ADD CONSTRAINT [FK_SCHEDULE_override_reason] FOREIGN KEY([ProjectID], [OVRREAS]) REFERENCES [pcms].[override_reason] ([ProjectID], [override_reason_code]) ON UPDATE CASCADE GO ALTER TABLE [dbo].[SCHEDULE] CHECK CONSTRAINT [FK_SCHEDULE_override_reason] GO ALTER TABLE [dbo].[SCHEDULE] WITH NOCHECK ADD CONSTRAINT [FK_SCHEDULE_Project] FOREIGN KEY([ProjectID]) REFERENCES [dbo].[Project] ([ProjectID]) GO ALTER TABLE [dbo].[SCHEDULE] CHECK CONSTRAINT [FK_SCHEDULE_Project] GO ALTER TABLE [dbo].[SCHEDULE] WITH NOCHECK ADD CONSTRAINT [FK_Schedule_security_user] FOREIGN KEY([DEFERBY], [ProjectID]) REFERENCES [pcms].[security_user] ([picklist_name], [ProjectID]) GO ALTER TABLE [dbo].[SCHEDULE] CHECK CONSTRAINT [FK_Schedule_security_user] GO ALTER TABLE [dbo].[SCHEDULE] WITH NOCHECK ADD CONSTRAINT [FK_Schedule_security_user_EVNOVERRDU] FOREIGN KEY([EVNOVERRDU], [ProjectID]) REFERENCES [pcms].[security_user] ([picklist_name], [ProjectID]) GO ALTER TABLE [dbo].[SCHEDULE] CHECK CONSTRAINT [FK_Schedule_security_user_EVNOVERRDU] GO ALTER TABLE [dbo].[SCHEDULE] WITH NOCHECK ADD CONSTRAINT [FK_Schedule_security_user_FOLLOWUPUSER] FOREIGN KEY([FOLLUPUSER], [ProjectID]) REFERENCES [pcms].[security_user] ([picklist_name], [ProjectID]) GO ALTER TABLE [dbo].[SCHEDULE] CHECK CONSTRAINT [FK_Schedule_security_user_FOLLOWUPUSER] GO ALTER TABLE [dbo].[SCHEDULE] WITH NOCHECK ADD CONSTRAINT [FK_SCHEDULE_ta_planning] FOREIGN KEY([TAPLANNING], [ProjectID]) REFERENCES [pcms].[ta_planning] ([name], [ProjectID]) GO ALTER TABLE [dbo].[SCHEDULE] CHECK CONSTRAINT [FK_SCHEDULE_ta_planning] GO ALTER TABLE [dbo].[SCHEDULE] WITH NOCHECK ADD CONSTRAINT [FK_SCHEDULE_test_reason] FOREIGN KEY([REASON], [ProjectID]) REFERENCES [pcms].[test_reason] ([name], [ProjectID]) GO ALTER TABLE [dbo].[SCHEDULE] CHECK CONSTRAINT [FK_SCHEDULE_test_reason] GO ALTER TABLE [dbo].[Service_Components] WITH NOCHECK ADD CONSTRAINT [FK_Service_Components_EXP_SERVICE] FOREIGN KEY([SERVICE], [ProjectID]) REFERENCES [dbo].[EXP_SERVICE] ([SERVICE], [ProjectID]) ON UPDATE CASCADE GO ALTER TABLE [dbo].[Service_Components] CHECK CONSTRAINT [FK_Service_Components_EXP_SERVICE] GO ALTER TABLE [dbo].[Service_Components] WITH NOCHECK ADD CONSTRAINT [FK_Service_Components_fluid_property] FOREIGN KEY([FLUDPRPRTY], [ProjectID]) REFERENCES [pcms].[fluid_property] ([name], [ProjectID]) GO ALTER TABLE [dbo].[Service_Components] CHECK CONSTRAINT [FK_Service_Components_fluid_property] GO ALTER TABLE [dbo].[Service_Components] WITH NOCHECK ADD CONSTRAINT [FK_Service_Components_Project] FOREIGN KEY([ProjectID]) REFERENCES [dbo].[Project] ([ProjectID]) GO ALTER TABLE [dbo].[Service_Components] CHECK CONSTRAINT [FK_Service_Components_Project] GO ALTER TABLE [dbo].[Unit] WITH NOCHECK ADD CONSTRAINT [FK_Unit_complex] FOREIGN KEY([ProjectID], [COMPLEX]) REFERENCES [pcms].[complex] ([ProjectID], [name]) ON UPDATE CASCADE GO ALTER TABLE [dbo].[Unit] CHECK CONSTRAINT [FK_Unit_complex] GO ALTER TABLE [dbo].[Unit] WITH NOCHECK ADD CONSTRAINT [FK_Unit_facility] FOREIGN KEY([ProjectID], [FACILITY]) REFERENCES [pcms].[facility] ([ProjectID], [facility_id]) ON UPDATE CASCADE GO ALTER TABLE [dbo].[Unit] CHECK CONSTRAINT [FK_Unit_facility] GO ALTER TABLE [dbo].[Unit] WITH NOCHECK ADD CONSTRAINT [FK_Unit_outside_resource] FOREIGN KEY([OTSDRESRCS], [ProjectID]) REFERENCES [pcms].[outside_resource] ([name], [ProjectID]) GO ALTER TABLE [dbo].[Unit] CHECK CONSTRAINT [FK_Unit_outside_resource] GO ALTER TABLE [dbo].[Unit] WITH NOCHECK ADD CONSTRAINT [FK_Unit_Project] FOREIGN KEY([ProjectID]) REFERENCES [dbo].[Project] ([ProjectID]) GO ALTER TABLE [dbo].[Unit] CHECK CONSTRAINT [FK_Unit_Project] GO ALTER TABLE [dbo].[Unit] WITH NOCHECK ADD CONSTRAINT [FK_Unit_security_OPERSUPR] FOREIGN KEY([OPERSUPR], [ProjectID]) REFERENCES [pcms].[security_user] ([picklist_name], [ProjectID]) GO ALTER TABLE [dbo].[Unit] CHECK CONSTRAINT [FK_Unit_security_OPERSUPR] GO ALTER TABLE [dbo].[Unit] WITH NOCHECK ADD CONSTRAINT [FK_Unit_unit_type] FOREIGN KEY([UNITTYPE], [ProjectID]) REFERENCES [pcms].[unit_type] ([name], [ProjectID]) GO ALTER TABLE [dbo].[Unit] CHECK CONSTRAINT [FK_Unit_unit_type] GO ALTER TABLE [dbo].[Unit] WITH NOCHECK ADD CONSTRAINT [FK_Unit_UNITINSP] FOREIGN KEY([UNITINSP], [ProjectID]) REFERENCES [pcms].[security_user] ([picklist_name], [ProjectID]) GO ALTER TABLE [dbo].[Unit] CHECK CONSTRAINT [FK_Unit_UNITINSP] GO ALTER TABLE [dbo].[UnitSetting] WITH CHECK ADD CONSTRAINT [FK_UnitSetting_Unit] FOREIGN KEY([Unit_ID_FK]) REFERENCES [dbo].[Unit] ([ID]) GO ALTER TABLE [dbo].[UnitSetting] CHECK CONSTRAINT [FK_UnitSetting_Unit] GO ALTER TABLE [dbo].[UnitSetting] WITH CHECK ADD CONSTRAINT [FK_UnitSetting_UnitSettingType] FOREIGN KEY([Setting]) REFERENCES [dbo].[UnitSettingType] ([UnitSetting_PK]) ON UPDATE CASCADE GO ALTER TABLE [dbo].[UnitSetting] CHECK CONSTRAINT [FK_UnitSetting_UnitSettingType] GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'P&ID Drawing ID for linking to drawings.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Circuit', @level2type=N'COLUMN',@level2name=N'PID_Drawing' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[UNITID]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'UNITID' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[EQUIPID]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'EQUIPID' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[EQHISTNO]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'EQHISTNO' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[CIRCUITID]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'CIRCUITID' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[TMLID]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'TMLID' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[TMHISTNO]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'TMHISTNO' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Access Method Picklist' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'ACCESSMETH' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[ACCESSMETH]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'ACCESSMETH' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[CATEGORY]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'CATEGORY' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[CMINSGDSEQ]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'CMINSGDSEQ' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Link to a component on the same equipment.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'COMPONENID' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[COMPONENID]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'COMPONENID' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[COUPONAREA]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'COUPONAREA' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[COUPNACRRT]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'COUPNACRRT' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[COUPNCRRRT]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'COUPNCRRRT' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[COUPNDNSTY]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'COUPNDNSTY' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[CCORRCTNVL]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'CCORRCTNVL' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[CELECTRDTY]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'CELECTRDTY' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[CMLTPLCTNF]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'CMLTPLCTNF' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[CNTVPOTNTL]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'CNTVPOTNTL' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[CREFRNCCTH]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'CREFRNCCTH' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[CUIACTUAL]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'CUIACTUAL' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[CUIPOTENTL]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'CUIPOTENTL' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[DEADLEG]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'DEADLEG' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[DESCRIPT]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'DESCRIPT' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[PPSCHEDLCD]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'PPSCHEDLCD' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[DOCUMENTID]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'DOCUMENTID' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[EVENTNO]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'EVENTNO' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[EXPJOINT]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'EXPJOINT' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[EXTERNCORR]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'EXTERNCORR' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[HCMIXPOINT]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'HCMIXPOINT' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[HEATTRACE]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'HEATTRACE' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[HISTREASON]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'HISTREASON' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[INITLLOCTN]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'INITLLOCTN' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[INTRTMPRTR]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'INTRTMPRTR' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[INTLUNCRRR]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'INTLUNCRRR' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[INJECTION]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'INJECTION' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Insulation Type Lookup' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'INSULATION' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[INSULATION]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'INSULATION' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[INTERNAL]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'INTERNAL' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[INTCTL1]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'INTCTL1' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[INTCTL2]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'INTCTL2' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[INTCTL3]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'INTCTL3' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[JOINTEFF]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'JOINTEFF' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[REPLACDATE]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'REPLACDATE' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[LTSTLOCATN]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'LTSTLOCATN' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[LTRTEMPRTR]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'LTRTEMPRTR' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[LTSUNCRRCR]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'LTSUNCRRCR' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[LATITUDETM]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'LATITUDETM' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[LINENO]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'LINENO' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[LONGITUDTM]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'LONGITUDTM' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[RETLIMMAN]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'RETLIMMAN' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[RETBASMAN]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'RETBASMAN' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[MSTRSCHDLR]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'MSTRSCHDLR' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Gerneral Material' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'MATERIAL' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[MATERIAL]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'MATERIAL' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[MAXINTERVL]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'MAXINTERVL' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[MEASURE]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'MEASURE' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[NOMINAL]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'NOMINAL' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[NOTES]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'NOTES' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[ORGCORALOW]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'ORGCORALOW' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[BASEREPLDT]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'BASEREPLDT' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[OVRDCITMIN]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'OVRDCITMIN' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[OVRRIDEDT]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'OVRRIDEDT' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[OVRRIDEDSC]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'OVRRIDEDSC' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[OVRREAS]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'OVRREAS' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[PIDDRAWING]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'PIDDRAWING' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[PARTTYPE]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'PARTTYPE' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[PIPESCHED]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'PIPESCHED' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[PIPESIZE]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'PIPESIZE' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[PRVLOCATIN]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'PRVLOCATIN' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[PRTEMPERTR]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'PRTEMPERTR' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[PRUNCRRCTR]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'PRUNCRRCTR' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[RDTEMPLATH]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'RDTEMPLATH' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[REPLNEXTTA]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'REPLNEXTTA' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[REPLCOUNT]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'REPLCOUNT' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Required Inspection Method Lookup' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'REQINSMETH' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[REQINSMETH]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'REQINSMETH' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[RLMTMANLST]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'RLMTMANLST' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[USETMINMAN]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'USETMINMAN' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[TMTOLRNCAL]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'TMTOLRNCAL' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[ROUTE]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'ROUTE' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[SCHNXTRDDT]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'SCHNXTRDDT' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[SCHREPLDAT]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'SCHREPLDAT' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[SKETCHID]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'SKETCHID' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[SLEEVED]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'SLEEVED' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[SOILAIR]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'SOILAIR' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Special Instructions' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'SPECINSTR' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[SPECINSTR]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'SPECINSTR' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Special Procedure Header Lookup' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'SPECPROCHR' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[SPECPROCHR]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'SPECPROCHR' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Specific Material' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'SPECIFMATL' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[SPECIFMATL]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'SPECIFMATL' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Specific Material Grade' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'SPECIFMATL_MATLGRADE' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[SPECIFMATL_MATLGRADE]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'SPECIFMATL_MATLGRADE' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Specific Material Name' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'SPECIFMATL_NAME' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[SPECIFMATL_NAME]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'SPECIFMATL_NAME' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Turnaround Planning Lookup' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'TAPLANNING' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[TAPLANNING]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'TAPLANNING' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Temporary Repair YN' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'TEMPREP' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[TEMPREP]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'TEMPREP' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Threaded YN' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'THREADED' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[THREADED]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'THREADED' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[USEB31G]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'USEB31G' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[USEDMGRDYN]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'USEDMGRDYN' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[USETMINCA]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'USETMINCA' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[USETMINFRM]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'USETMINFRM' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[USETMINTBL]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'USETMINTBL' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[VALVEORFIT]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'VALVEORFIT' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[TMLSEQNO]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'TMLSEQNO' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[HALFLIFEDT]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'HALFLIFEDT' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[QTRLIFEDT]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'QTRLIFEDT' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[THQTLIFEDT]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'THQTLIFEDT' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[ADDDT]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'ADDDT' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[CALCINSPDT]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'CALCINSPDT' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[CALCINSPBS]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'CALCINSPBS' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[CHGDT]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'CHGDT' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[NEEDRECALC]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'NEEDRECALC' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[DESGNSTRSS]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'DESGNSTRSS' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[DSGNSTRSBS]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'DSGNSTRSBS' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[ESTTHICK]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'ESTTHICK' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[ESTTHCKBAS]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'ESTTHCKBAS' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[FULLLIFEDT]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'FULLLIFEDT' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[FIRSTQA]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'FIRSTQA' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[FIRSTDATE]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'FIRSTDATE' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[FIRSTINSP]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'FIRSTINSP' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[FIRSTMETH]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'FIRSTMETH' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[FIRSTREAD]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'FIRSTREAD' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[LATESTB31G]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'LATESTB31G' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[LTCPIPSTR]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'LTCPIPSTR' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[LTCCCSEQNO]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'LTCCCSEQNO' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[LATESTCORR]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'LATESTCORR' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[LTDMGFTSQN]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'LTDMGFTSQN' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[LTINSPRSQN]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'LTINSPRSQN' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[LTPITDEPTH]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'LTPITDEPTH' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[LASTQA]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'LASTQA' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[LASTDATE]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'LASTDATE' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[LASTINSP]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'LASTINSP' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[LASTMETH]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'LASTMETH' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[LASTREAD]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'LASTREAD' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[LTWLLOSPCT]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'LTWLLOSPCT' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[LONGRATE]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'LONGRATE' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[RETIREDATE]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'RETIREDATE' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[RETDATEBAS]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'RETDATEBAS' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[MAWP]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'MAWP' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[MAWPBASIS]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'MAWPBASIS' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[INSPECDATE]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'INSPECDATE' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[INSDATEBAS]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'INSDATEBAS' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[NOREADINGS]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'NOREADINGS' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[OVRRIDEUSR]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'OVRRIDEUSR' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[PREVQA]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'PREVQA' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[PREVDATE]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'PREVDATE' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[PREVINSP]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'PREVINSP' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[PREVMETH]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'PREVMETH' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[PREVREAD]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'PREVREAD' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[LNRTREDNG1]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'LNRTREDNG1' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[SHRRTRDNG1]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'SHRRTRDNG1' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[LONGRATED2]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'LONGRATED2' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[LNRTHCKNS2]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'LNRTHCKNS2' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[SHORTRATD2]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'SHORTRATD2' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[SHRTHCKNS2]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'SHRTHCKNS2' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[RETLMTB31]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'RETLMTB31' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[RETBASCA]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'RETBASCA' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[RETBASFRM]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'RETBASFRM' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[RETBASTBL]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'RETBASTBL' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[RETLIMCA]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'RETLIMCA' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[RETLIMFRM]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'RETLIMFRM' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[RETLIMTBL]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'RETLIMTBL' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[RETLIMIT]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'RETLIMIT' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[RETLIMBAS]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'RETLIMBAS' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[TMDSGNCHNG]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'TMDSGNCHNG' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[RETLIMSTAT]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'RETLIMSTAT' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[RFFCIRCID]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'RFFCIRCID' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[RFFCMLID]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'RFFCMLID' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[SHORTRATE]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'SHORTRATE' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[SHRTRETDAT]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'SHRTRETDAT' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[USRTFMHINO]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'USRTFMHINO' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[VOLLONGRAT]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'VOLLONGRAT' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[VOLSHRTRAT]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'VOLSHRTRAT' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[ERETDATE]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'ERETDATE' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML].[ERETDATBAS]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML', @level2type=N'COLUMN',@level2name=N'ERETDATBAS' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[CML]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CML' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Unique key for the component in this database' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'COMPONENT', @level2type=N'COLUMN',@level2name=N'Id' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Calculated Column added to allow for the proper sorting of the damage mechanisms' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DamageMechanisms', @level2type=N'COLUMN',@level2name=N'Calc_Sort' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Maximum Allowable Working Pressure' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Equipment', @level2type=N'COLUMN',@level2name=N'MAWP' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Maximum Allowable Working Temperature' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Equipment', @level2type=N'COLUMN',@level2name=N'MAWT' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Cleaning Method' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'EVENT', @level2type=N'COLUMN',@level2name=N'CLENNGMTHD' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Delete Trigger Action' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'EVENT', @level2type=N'COLUMN',@level2name=N'DLTTRGGACT' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Entered By' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'EVENT', @level2type=N'COLUMN',@level2name=N'ENTEREDBY' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Event Close Dt' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'EVENT', @level2type=N'COLUMN',@level2name=N'CLOSEDT' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Event Comments' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'EVENT', @level2type=N'COLUMN',@level2name=N'EVNTCMMNTS' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Insert Trigger Action' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'EVENT', @level2type=N'COLUMN',@level2name=N'INSTRGGACT' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Test Reason Picklist' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'EVENT', @level2type=N'COLUMN',@level2name=N'TESTREASON' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Special Instructions' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'EVENT', @level2type=N'COLUMN',@level2name=N'SPCINSTRCT' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Test Medium Picklist' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'EVENT', @level2type=N'COLUMN',@level2name=N'TESTMEDIUM' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Update Trigger Action' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'EVENT', @level2type=N'COLUMN',@level2name=N'UPDTRGGACT' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Master Checklist Category' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'EVENT_REPORT', @level2type=N'COLUMN',@level2name=N'MSTCHKLSTG' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Summary YN' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'EVENT_REPORT', @level2type=N'COLUMN',@level2name=N'SUMMARYCTG' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'COMPONENT MASTER' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'EVENT_REPORT', @level2type=N'COLUMN',@level2name=N'COMPNNTMST' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'lookup to condition table' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'EVENT_REPORT', @level2type=N'COLUMN',@level2name=N'CONDITION' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'DELETE TRIGGER ACTION' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'EVENT_REPORT', @level2type=N'COLUMN',@level2name=N'DLTTRGGACT' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'INSERT TRIGGER ACTION' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'EVENT_REPORT', @level2type=N'COLUMN',@level2name=N'INSTRGGACT' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'MASTER CHECKLIST CATEGORY' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'EVENT_REPORT', @level2type=N'COLUMN',@level2name=N'MSTCHKLSCT' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Number of tubes plugged' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'EVENT_REPORT', @level2type=N'COLUMN',@level2name=N'NOTBSPLGGD' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'OK YN' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'EVENT_REPORT', @level2type=N'COLUMN',@level2name=N'OK' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'REC INSP CATG (LOOKUP)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'EVENT_REPORT', @level2type=N'COLUMN',@level2name=N'RECMINSCTG' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Special Instructions' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'EVENT_REPORT', @level2type=N'COLUMN',@level2name=N'SPCINSTRCT' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Update Trigger Action' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'EVENT_REPORT', @level2type=N'COLUMN',@level2name=N'UPDTRGGACT' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'EVENT_REPORT' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[reading].[UNITID]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'reading', @level2type=N'COLUMN',@level2name=N'UNITID' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[reading].[EQUIPID]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'reading', @level2type=N'COLUMN',@level2name=N'EQUIPID' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[reading].[EQHISTNO]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'reading', @level2type=N'COLUMN',@level2name=N'EQHISTNO' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[reading].[CIRCUITID]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'reading', @level2type=N'COLUMN',@level2name=N'CIRCUITID' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[reading].[TMLID]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'reading', @level2type=N'COLUMN',@level2name=N'TMLID' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[reading].[TMHISTNO]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'reading', @level2type=N'COLUMN',@level2name=N'TMHISTNO' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[reading].[READDATE]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'reading', @level2type=N'COLUMN',@level2name=N'READDATE' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[reading].[AVGTHICK]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'reading', @level2type=N'COLUMN',@level2name=N'AVGTHICK' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[reading].[CMLCONDCOD]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'reading', @level2type=N'COLUMN',@level2name=N'CMLCONDCOD' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[reading].[CORROSLENG]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'reading', @level2type=N'COLUMN',@level2name=N'CORROSLENG' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[reading].[CANODVOLTG]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'reading', @level2type=N'COLUMN',@level2name=N'CANODVOLTG' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[reading].[COFCORRCTD]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'reading', @level2type=N'COLUMN',@level2name=N'COFCORRCTD' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[reading].[CPOFFDREAD]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'reading', @level2type=N'COLUMN',@level2name=N'CPOFFDREAD' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[reading].[COCORRECTD]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'reading', @level2type=N'COLUMN',@level2name=N'COCORRECTD' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[reading].[CPONDREAD]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'reading', @level2type=N'COLUMN',@level2name=N'CPONDREAD' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[reading].[COTPTCRRNT]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'reading', @level2type=N'COLUMN',@level2name=N'COTPTCRRNT' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[reading].[DAMGFTPRNT]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'reading', @level2type=N'COLUMN',@level2name=N'DAMGFTPRNT' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[reading].[DESCRIPT]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'reading', @level2type=N'COLUMN',@level2name=N'DESCRIPT' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[reading].[EVENTNO]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'reading', @level2type=N'COLUMN',@level2name=N'EVENTNO' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[reading].[FIELDREAD]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'reading', @level2type=N'COLUMN',@level2name=N'FIELDREAD' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[reading].[FLOWVOL]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'reading', @level2type=N'COLUMN',@level2name=N'FLOWVOL' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[reading].[INSTRGGACT]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'reading', @level2type=N'COLUMN',@level2name=N'INSTRGGACT' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[reading].[INSPREASON]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'reading', @level2type=N'COLUMN',@level2name=N'INSPREASON' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[reading].[INSPECTOR]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'reading', @level2type=N'COLUMN',@level2name=N'INSPECTOR' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[reading].[LOCATION]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'reading', @level2type=N'COLUMN',@level2name=N'LOCATION' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[reading].[MATERIAL]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'reading', @level2type=N'COLUMN',@level2name=N'MATERIAL' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[reading].[MINTHICK]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'reading', @level2type=N'COLUMN',@level2name=N'MINTHICK' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[reading].[OVERCPSYN]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'reading', @level2type=N'COLUMN',@level2name=N'OVERCPSYN' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[reading].[OVERCPSJST]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'reading', @level2type=N'COLUMN',@level2name=N'OVERCPSJST' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[reading].[OVERCPSUSR]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'reading', @level2type=N'COLUMN',@level2name=N'OVERCPSUSR' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[reading].[OVERCPSVAL]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'reading', @level2type=N'COLUMN',@level2name=N'OVERCPSVAL' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[reading].[PITDEPTH]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'reading', @level2type=N'COLUMN',@level2name=N'PITDEPTH' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[reading].[QUALITYIND]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'reading', @level2type=N'COLUMN',@level2name=N'QUALITYIND' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[reading].[RADEXP]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'reading', @level2type=N'COLUMN',@level2name=N'RADEXP' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[reading].[RADEXPUOM]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'reading', @level2type=N'COLUMN',@level2name=N'RADEXPUOM' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[reading].[METHOD]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'reading', @level2type=N'COLUMN',@level2name=N'METHOD' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[reading].[REMAINSTRE]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'reading', @level2type=N'COLUMN',@level2name=N'REMAINSTRE' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[reading].[RMNSTRBASI]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'reading', @level2type=N'COLUMN',@level2name=N'RMNSTRBASI' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[reading].[SAFETYFCTR]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'reading', @level2type=N'COLUMN',@level2name=N'SAFETYFCTR' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[reading].[SFD]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'reading', @level2type=N'COLUMN',@level2name=N'SFD' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[reading].[TEMP]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'reading', @level2type=N'COLUMN',@level2name=N'TEMP' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[reading].[UPDTRGGACT]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'reading', @level2type=N'COLUMN',@level2name=N'UPDTRGGACT' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[reading].[ENTEREDBY]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'reading', @level2type=N'COLUMN',@level2name=N'ENTEREDBY' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[reading].[WEIGHT]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'reading', @level2type=N'COLUMN',@level2name=N'WEIGHT' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[reading].[ADDDT]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'reading', @level2type=N'COLUMN',@level2name=N'ADDDT' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[reading].[B31G]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'reading', @level2type=N'COLUMN',@level2name=N'B31G' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[reading].[CLCPIPSTR]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'reading', @level2type=N'COLUMN',@level2name=N'CLCPIPSTR' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[reading].[CHGDT]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'reading', @level2type=N'COLUMN',@level2name=N'CHGDT' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[reading].[CODES]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'reading', @level2type=N'COLUMN',@level2name=N'CODES' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[reading].[CORRRATE]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'reading', @level2type=N'COLUMN',@level2name=N'CORRRATE' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[reading].[GROWTH]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'reading', @level2type=N'COLUMN',@level2name=N'GROWTH' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[reading].[LNGRATBASS]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'reading', @level2type=N'COLUMN',@level2name=N'LNGRATBASS' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[reading].[MAWP]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'reading', @level2type=N'COLUMN',@level2name=N'MAWP' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[reading].[SHRTRATBSS]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'reading', @level2type=N'COLUMN',@level2name=N'SHRTRATBSS' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[reading].[THICKNESS]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'reading', @level2type=N'COLUMN',@level2name=N'THICKNESS' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[reading].[WALLLOSPCT]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'reading', @level2type=N'COLUMN',@level2name=N'WALLLOSPCT' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[reading]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'reading' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[SCHEDULE].[UNITID]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SCHEDULE', @level2type=N'COLUMN',@level2name=N'UNITID' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[SCHEDULE].[EQUIPID]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SCHEDULE', @level2type=N'COLUMN',@level2name=N'EQUIPID' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[SCHEDULE].[EQHISTNO]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SCHEDULE', @level2type=N'COLUMN',@level2name=N'EQHISTNO' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[SCHEDULE].[EVENTTYPE]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SCHEDULE', @level2type=N'COLUMN',@level2name=N'EVENTTYPE' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[SCHEDULE].[CIRCUITID]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SCHEDULE', @level2type=N'COLUMN',@level2name=N'CIRCUITID' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[SCHEDULE].[COMPONENID]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SCHEDULE', @level2type=N'COLUMN',@level2name=N'COMPONENID' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[SCHEDULE].[SCBDGTCOST]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SCHEDULE', @level2type=N'COLUMN',@level2name=N'SCBDGTCOST' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[SCHEDULE].[SCBDGTHOUR]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SCHEDULE', @level2type=N'COLUMN',@level2name=N'SCBDGTHOUR' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[SCHEDULE].[DEFERBY]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SCHEDULE', @level2type=N'COLUMN',@level2name=N'DEFERBY' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[SCHEDULE].[DEFERJUST]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SCHEDULE', @level2type=N'COLUMN',@level2name=N'DEFERJUST' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[SCHEDULE].[MAXINT]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SCHEDULE', @level2type=N'COLUMN',@level2name=N'MAXINT' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[SCHEDULE].[OVRRIDEDT]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SCHEDULE', @level2type=N'COLUMN',@level2name=N'OVRRIDEDT' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'EVENT NO' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SCHEDULE', @level2type=N'COLUMN',@level2name=N'EVENT' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[SCHEDULE].[EVENT]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SCHEDULE', @level2type=N'COLUMN',@level2name=N'EVENT' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[SCHEDULE].[INSTRGGACT]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SCHEDULE', @level2type=N'COLUMN',@level2name=N'INSTRGGACT' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[SCHEDULE].[INTACCESS]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SCHEDULE', @level2type=N'COLUMN',@level2name=N'INTACCESS' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[SCHEDULE].[INTERVLFMT]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SCHEDULE', @level2type=N'COLUMN',@level2name=N'INTERVLFMT' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[SCHEDULE].[LFBSSOVRRD]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SCHEDULE', @level2type=N'COLUMN',@level2name=N'LFBSSOVRRD' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[SCHEDULE].[MAINTPLANN]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SCHEDULE', @level2type=N'COLUMN',@level2name=N'MAINTPLANN' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[SCHEDULE].[RBIMAXINT]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SCHEDULE', @level2type=N'COLUMN',@level2name=N'RBIMAXINT' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[SCHEDULE].[RBIMININT]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SCHEDULE', @level2type=N'COLUMN',@level2name=N'RBIMININT' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[SCHEDULE].[NEXTEVENT]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SCHEDULE', @level2type=N'COLUMN',@level2name=N'NEXTEVENT' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Next Event Override Dt' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SCHEDULE', @level2type=N'COLUMN',@level2name=N'NXTOVERRDD' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[SCHEDULE].[NXTOVERRDD]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SCHEDULE', @level2type=N'COLUMN',@level2name=N'NXTOVERRDD' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[SCHEDULE].[NXOVERRDUS]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SCHEDULE', @level2type=N'COLUMN',@level2name=N'NXOVERRDUS' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[SCHEDULE].[NXMEVINTRV]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SCHEDULE', @level2type=N'COLUMN',@level2name=N'NXMEVINTRV' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[SCHEDULE].[NXOVERRDJS]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SCHEDULE', @level2type=N'COLUMN',@level2name=N'NXOVERRDJS' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[SCHEDULE].[NOTES]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SCHEDULE', @level2type=N'COLUMN',@level2name=N'NOTES' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[SCHEDULE].[OVRRIDEDSC]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SCHEDULE', @level2type=N'COLUMN',@level2name=N'OVRRIDEDSC' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'FK to override reason table' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SCHEDULE', @level2type=N'COLUMN',@level2name=N'OVRREAS' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[SCHEDULE].[OVRREAS]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SCHEDULE', @level2type=N'COLUMN',@level2name=N'OVRREAS' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[SCHEDULE].[NXOVERRDSC]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SCHEDULE', @level2type=N'COLUMN',@level2name=N'NXOVERRDSC' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[SCHEDULE].[RBIBASIS]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SCHEDULE', @level2type=N'COLUMN',@level2name=N'RBIBASIS' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[SCHEDULE].[REASON]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SCHEDULE', @level2type=N'COLUMN',@level2name=N'REASON' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[SCHEDULE].[FOLLUPUSER]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SCHEDULE', @level2type=N'COLUMN',@level2name=N'FOLLUPUSER' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[SCHEDULE].[MSTSCHDLRN]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SCHEDULE', @level2type=N'COLUMN',@level2name=N'MSTSCHDLRN' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[SCHEDULE].[SPECINSTR]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SCHEDULE', @level2type=N'COLUMN',@level2name=N'SPECINSTR' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'SRD MATRIX INTERVAL OVERRIDE' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SCHEDULE', @level2type=N'COLUMN',@level2name=N'OVRRMTINTR' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[SCHEDULE].[OVRRMTINTR]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SCHEDULE', @level2type=N'COLUMN',@level2name=N'OVRRMTINTR' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[SCHEDULE].[OVERRDMTRJ]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SCHEDULE', @level2type=N'COLUMN',@level2name=N'OVERRDMTRJ' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[SCHEDULE].[SLFBSSMTHD]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SCHEDULE', @level2type=N'COLUMN',@level2name=N'SLFBSSMTHD' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[SCHEDULE].[TAPLANNING]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SCHEDULE', @level2type=N'COLUMN',@level2name=N'TAPLANNING' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[SCHEDULE].[USMSTCNVYN]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SCHEDULE', @level2type=N'COLUMN',@level2name=N'USMSTCNVYN' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[SCHEDULE].[USERBI]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SCHEDULE', @level2type=N'COLUMN',@level2name=N'USERBI' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[SCHEDULE].[OVERRDUMTR]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SCHEDULE', @level2type=N'COLUMN',@level2name=N'OVERRDUMTR' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[SCHEDULE].[USEUNITSD]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SCHEDULE', @level2type=N'COLUMN',@level2name=N'USEUNITSD' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[SCHEDULE].[SCHEDSEQNO]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SCHEDULE', @level2type=N'COLUMN',@level2name=N'SCHEDSEQNO' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[SCHEDULE].[BASEDT]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SCHEDULE', @level2type=N'COLUMN',@level2name=N'BASEDT' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[SCHEDULE].[BASDATBASS]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SCHEDULE', @level2type=N'COLUMN',@level2name=N'BASDATBASS' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[SCHEDULE].[CALCBASIS]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SCHEDULE', @level2type=N'COLUMN',@level2name=N'CALCBASIS' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[SCHEDULE].[CALCRBIINT]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SCHEDULE', @level2type=N'COLUMN',@level2name=N'CALCRBIINT' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[SCHEDULE].[CALCULTDBS]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SCHEDULE', @level2type=N'COLUMN',@level2name=N'CALCULTDBS' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[SCHEDULE].[MTHDRVSCHD]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SCHEDULE', @level2type=N'COLUMN',@level2name=N'MTHDRVSCHD' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[SCHEDULE].[EVENTDUEDT]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SCHEDULE', @level2type=N'COLUMN',@level2name=N'EVENTDUEDT' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[SCHEDULE].[EVNOVERRDU]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SCHEDULE', @level2type=N'COLUMN',@level2name=N'EVNOVERRDU' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[SCHEDULE].[LIFBASISDT]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SCHEDULE', @level2type=N'COLUMN',@level2name=N'LIFBASISDT' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[SCHEDULE].[LIFBSDTTML]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SCHEDULE', @level2type=N'COLUMN',@level2name=N'LIFBSDTTML' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[SCHEDULE].[NEDDEFERRL]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SCHEDULE', @level2type=N'COLUMN',@level2name=N'NEDDEFERRL' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[SCHEDULE].[NEEDRECALC]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SCHEDULE', @level2type=N'COLUMN',@level2name=N'NEEDRECALC' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[SCHEDULE].[RBITARGETD]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SCHEDULE', @level2type=N'COLUMN',@level2name=N'RBITARGETD' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[SCHEDULE].[RECMNXTIND]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SCHEDULE', @level2type=N'COLUMN',@level2name=N'RECMNXTIND' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[SCHEDULE].[RLBSDINTRV]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SCHEDULE', @level2type=N'COLUMN',@level2name=N'RLBSDINTRV' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[SCHEDULE].[RLBSDINTRF]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SCHEDULE', @level2type=N'COLUMN',@level2name=N'RLBSDINTRF' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'SCHEDULE DATE' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SCHEDULE', @level2type=N'COLUMN',@level2name=N'SCHEDDATE' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[SCHEDULE].[SCHEDDATE]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SCHEDULE', @level2type=N'COLUMN',@level2name=N'SCHEDDATE' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[SCHEDULE].[SRMATRXBSS]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SCHEDULE', @level2type=N'COLUMN',@level2name=N'SRMATRXBSS' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[SCHEDULE].[SMTRXINTRV]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SCHEDULE', @level2type=N'COLUMN',@level2name=N'SMTRXINTRV' GO EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'PCMSPM-Test.[SCHEDULE]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SCHEDULE' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'MANUFACTURER OR OUTSIDE RESOURCE' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Unit', @level2type=N'COLUMN',@level2name=N'OTSDRESRCS' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'SHOP YN' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Unit', @level2type=N'COLUMN',@level2name=N'SHOP' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'WAREHOUSE YN' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Unit', @level2type=N'COLUMN',@level2name=N'WAREHOUSE' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'NEEDS RECALC' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Unit', @level2type=N'COLUMN',@level2name=N'NEEDRECALC' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'NEED RECALC DATES' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Unit', @level2type=N'COLUMN',@level2name=N'RECALCDATS' GO