sql

/** * File    : Cord Projects Database Extended Properties * Author  : Jeff O'Toole * Date    : Saturday, June 30th, 2007 * Purpose : This Script is for adding Extended Properties to *           all the Tables and their respective Columns to better *           define the data dictionay for .NetTiers **//** 1 TracerTest **/EXEC sp_addextendedproperty 'MS_Description', 'Weld Management System Tracer Test Table Child to both Weld and Weld Test Tables', 'user', 'dbo', 'table', 'TracerTest'GOEXEC sp_addextendedproperty 'MS_Description', 'Tracer Id Primary Key for Tracer Test Talbe', 'user', 'dbo', 'table', 'TracerTest', 'column', 'TracerId'GOEXEC sp_addextendedproperty 'MS_Description', 'Reference to Weld Test Table', 'user', 'dbo', 'table', 'TracerTest', 'column', 'WeldTestId'GOEXEC sp_addextendedproperty 'MS_Description', 'Reference to Weld Table', 'user', 'dbo', 'table', 'TracerTest', 'column', 'WeldId'GO/** 2 HydroMedium **/EXEC sp_addextendedproperty 'MS_Description', 'Weld Management System Hydro Test Medium Defination Table Parent to Hydro Test Table', 'user', 'dbo', 'table', 'HydroMedium'GOEXEC sp_addextendedproperty 'MS_Description', 'Hydro Medium Table Unique ID and Primary Key for Hydro Medium Table', 'user', 'dbo', 'table', 'HydroMedium', 'column', 'HydroMediumId'GOEXEC sp_addextendedproperty 'MS_Description', 'Name of Hydro Test Medium', 'user', 'dbo', 'table', 'HydroMedium', 'column', 'Medium'GO/** 3 HydroTestDrawing **/EXEC sp_addextendedproperty 'MS_Description', 'Weld Management System Hydro Test Drawings Table', 'user', 'dbo', 'table', 'HydroTestDrawing'GOEXEC sp_addextendedproperty 'MS_Description', 'Hydrotest Drawing Partial Primary Key for and reference to the Hydro Test Table', 'user', 'dbo', 'table', 'HydroTestDrawing', 'column', 'HydroTestId'GOEXEC sp_addextendedproperty 'MS_Description', 'Hydrotest Drawing Partial Primary Key for and reference to the Drawing Table', 'user', 'dbo', 'table', 'HydroTestDrawing', 'column', 'DrawingId'GO/** 4 DrawingRevision **/EXEC sp_addextendedproperty 'MS_Description', 'Weld Management System Drawing Revisions Table each Drawing can have many Drawing Revisions', 'user', 'dbo', 'table', 'DrawingRevision'GOEXEC sp_addextendedproperty 'MS_Description', 'Drawing Revision Unique ID and Partial Primary Key for Drawing Revision Table', 'user', 'dbo', 'table', 'DrawingRevision', 'column', 'DrawingId'GOEXEC sp_addextendedproperty 'MS_Description', 'Drawing Revision Unique ID and Partial Primary Key for Drawing Revision Table', 'user', 'dbo', 'table', 'DrawingRevision', 'column', 'DrawingRevisionNumber'GOEXEC sp_addextendedproperty 'MS_Description', 'Date of Drawing Revision', 'user', 'dbo', 'table', 'DrawingRevision', 'column', 'Date'GO/** 5 Drawing **/EXEC sp_addextendedproperty 'MS_Description', 'Weld Management System Drawing Table', 'user', 'dbo', 'table', 'Drawing'GOEXEC sp_addextendedproperty 'MS_Description', 'Drawing Unique ID and Primary Key for Drawing Table', 'user', 'dbo', 'table', 'Drawing', 'column', 'DrawingId'GOEXEC sp_addextendedproperty 'MS_Description', 'Drawing Revision Number', 'user', 'dbo', 'table', 'Drawing', 'column', 'RevisionNumber'GOEXEC sp_addextendedproperty 'MS_Description', 'Reference to the Drawings Project', 'user', 'dbo', 'table', 'Drawing', 'column', 'ProjectId'GOEXEC sp_addextendedproperty 'MS_Description', 'Reference to the Drawings Drawing Type', 'user', 'dbo', 'table', 'Drawing', 'column', 'DrawingTypeId'GOEXEC sp_addextendedproperty 'MS_Description', 'Partial Reference to the Drawings Parent Drawing via the Drawing Id', 'user', 'dbo', 'table', 'Drawing', 'column', 'ParentDrawingId'GOEXEC sp_addextendedproperty 'MS_Description', 'Partial Reference to the Drawings Parent Drawing via the Revision Number', 'user', 'dbo', 'table', 'Drawing', 'column', 'ParentRevisionNumber'GOEXEC sp_addextendedproperty 'MS_Description', 'Cord Projects Unique Internal Drawing Number', 'user', 'dbo', 'table', 'Drawing', 'column', 'InternalDrawingNumber'GOEXEC sp_addextendedproperty 'MS_Description', 'The Drawing may span Multiple Modules, this can be searched', 'user', 'dbo', 'table', 'Drawing', 'column', 'ModuleId'GO/** 6 TestColumnObjectLayout **/EXEC sp_addextendedproperty 'MS_Description', 'Weld Management System Table of Test Column Object Parent of Test Column Object Date and Child to Specification Test Column this table is the Sub Column for tests in a Specification Matrix Template Table Only', 'user', 'dbo', 'table', 'TestColumnObjectLayout'GOEXEC sp_addextendedproperty 'MS_Description', 'Primary Key for the Test Column Object Layout Table', 'user', 'dbo', 'table', 'TestColumnObjectLayout', 'column', 'TestColumnObjectIdLayout'GOEXEC sp_addextendedproperty 'MS_Description', 'Reference to the Specification Test Column Layout', 'user', 'dbo', 'table', 'TestColumnObjectLayout', 'column', 'SpecificationTestColumnIdLayout'GOEXEC sp_addextendedproperty 'MS_Description', 'Name of the Test Column Object', 'user', 'dbo', 'table', 'TestColumnObjectLayout', 'column', 'NameLayout'GOEXEC sp_addextendedproperty 'MS_Description', 'A boolean value to let the user know if this object is for a weld if so the name will be an abbreviation of the Weld Type', 'user', 'dbo', 'table', 'TestColumnObjectLayout', 'column', 'IsObjectWeldLayout'GO/** 7 SpecificationMatrixDataColumnLayout **/EXEC sp_addextendedproperty 'MS_Description', 'Weld Management System Table of Specification Matrix Data Column Layout is a Container for Supplementary Data within a Specification Matrix Template Layout.  Child of Specification Matrix Template Layout Template Table Only', 'user', 'dbo', 'table', 'SpecificationMatrixDataColumnLayout'GOEXEC sp_addextendedproperty 'MS_Description', 'Specification Matrix Data Column Id Layout is the Primary Key for the Specification Matrix Data Column Layout Table', 'user', 'dbo', 'table', 'SpecificationMatrixDataColumnLayout', 'column', 'SpecificationMatrixDataColumnIdLayout'GOEXEC sp_addextendedproperty 'MS_Description', 'Template Id Layout id the Refenence ot the Specification Matrix Template', 'user', 'dbo', 'table', 'SpecificationMatrixDataColumnLayout', 'column', 'TemplateIdLayout'GOEXEC sp_addextendedproperty 'MS_Description', 'Name of the Data Coulmn', 'user', 'dbo', 'table', 'SpecificationMatrixDataColumnLayout', 'column', 'NameLayout'GO/** 8 SpecificationTestColumnLayout **/EXEC sp_addextendedproperty 'MS_Description', 'Weld Management System Table of Specification Test Column Parent to Test Column Objects and Child of both Specification Matrix Template Layout and Weld Test Types this table Defines all the Weld Tests within a Specification Matrix Template Table Only', 'user', 'dbo', 'table', 'SpecificationTestColumnLayout'GOEXEC sp_addextendedproperty 'MS_Description', 'Primary Key for Specification Test Column Layout Table', 'user', 'dbo', 'table', 'SpecificationTestColumnLayout', 'column', 'SpecificationTestColumnIdLayout'GOEXEC sp_addextendedproperty 'MS_Description', 'Refenence to the Weld Test Type Table', 'user', 'dbo', 'table', 'SpecificationTestColumnLayout', 'column', 'WeldTestTypeId'GOEXEC sp_addextendedproperty 'MS_Description', 'Refenence ot the Specification Matrix Template', 'user', 'dbo', 'table', 'SpecificationTestColumnLayout', 'column', 'TemplateIdLayout'GO/** 9 SpecificationMatrixTemplateLayout **/EXEC sp_addextendedproperty 'MS_Description', 'Weld Management System Specification Matrix Template Layout Table, just a set of containers to hold Specification Matrix Templates', 'user', 'dbo', 'table', 'SpecificationMatrixTemplateLayout'GOEXEC sp_addextendedproperty 'MS_Description', 'Primary Key for Specification Template Matrix Layout', 'user', 'dbo', 'table', 'SpecificationMatrixTemplateLayout', 'column', 'TemplateIdLayout'GOEXEC sp_addextendedproperty 'MS_Description', 'Cord Projects Specification Code', 'user', 'dbo', 'table', 'SpecificationMatrixTemplateLayout', 'column', 'SpecificationCodeLayout'GO/** 10 SpoolRevision **/EXEC sp_addextendedproperty 'MS_Description', 'Weld Management System Project Spool Revision Table child of Spool Table', 'user', 'dbo', 'table', 'SpoolRevision'GOEXEC sp_addextendedproperty 'MS_Description', 'Combined Primary Key for the Spool Revision and Reference to parent table Spool', 'user', 'dbo', 'table', 'SpoolRevision', 'column', 'SpoolId'GOEXEC sp_addextendedproperty 'MS_Description', 'Combined Primary Key for the Spool Revision and Reference to parent table Spool', 'user', 'dbo', 'table', 'SpoolRevision', 'column', 'SpoolRevisionNumber'GOEXEC sp_addextendedproperty 'MS_Description', 'Date of Spool Revision', 'user', 'dbo', 'table', 'SpoolRevision', 'column', 'Date'GO/** 11 TestColumnObjectData **/EXEC sp_addextendedproperty 'MS_Description', 'Weld Management System Table of Test Column Object Data Child to both Test Column Objects and Specifications Contains all the Data to Populate the Cells of a Specification Matrix for Test Columns', 'user', 'dbo', 'table', 'TestColumnObjectData'GOEXEC sp_addextendedproperty 'MS_Description', 'Reference to the Test Column Object Table', 'user', 'dbo', 'table', 'TestColumnObjectData', 'column', 'TestColumnObjectId'GOEXEC sp_addextendedproperty 'MS_Description', 'Refenence to the Specification Table', 'user', 'dbo', 'table', 'TestColumnObjectData', 'column', 'SpecificationId'GOEXEC sp_addextendedproperty 'MS_Description', 'This Will be an integer if the Test Column Object ObjectWeld is True', 'user', 'dbo', 'table', 'TestColumnObjectData', 'column', 'Data'GO/** 12 TestColumnObject **/EXEC sp_addextendedproperty 'MS_Description', 'Weld Management System Table of Test Column Object Parent of Test Column Object Date and Child to Specification Test Column this table is the Sub Column for tests in a Specification Matrix', 'user', 'dbo', 'table', 'TestColumnObject'GOEXEC sp_addextendedproperty 'MS_Description', 'Primary Key for Test Column Object Table', 'user', 'dbo', 'table', 'TestColumnObject', 'column', 'TestColumnObjectId'GOEXEC sp_addextendedproperty 'MS_Description', 'Reference to the Specification Test Column', 'user', 'dbo', 'table', 'TestColumnObject', 'column', 'SpecificationTestColumnId'GOEXEC sp_addextendedproperty 'MS_Description', 'Name of the Test Column Object can be either Weld Type Abbreviation or Manually Specified', 'user', 'dbo', 'table', 'TestColumnObject', 'column', 'Name'GOEXEC sp_addextendedproperty 'MS_Description', 'A boolean value to let the user know if this object is for a weld if so the name will be an abbreviation of the Weld Type', 'user', 'dbo', 'table', 'TestColumnObject', 'column', 'IsObjectWeld'GO/** 13 SpecificationTestColumn **/EXEC sp_addextendedproperty 'MS_Description', 'Weld Management System Table of Specification Test Column Parent to Test Column Objects and Child of both Specification Matrix and Weld Test Types this table Defines all the Weld Tests within a Specification Matrix', 'user', 'dbo', 'table', 'SpecificationTestColumn'GOEXEC sp_addextendedproperty 'MS_Description', 'Primary Key for Specification Test Column Table', 'user', 'dbo', 'table', 'SpecificationTestColumn', 'column', 'SpecificationTestColumnId'GOEXEC sp_addextendedproperty 'MS_Description', 'Refenence to the Weld Test Type Table', 'user', 'dbo', 'table', 'SpecificationTestColumn', 'column', 'WeldTestTypeId'GOEXEC sp_addextendedproperty 'MS_Description', 'Reference to the Specification Matrix', 'user', 'dbo', 'table', 'SpecificationTestColumn', 'column', 'SpecificationMatrixId'GO/** 14 SpecificationMatrixDataColumnSpecification **/EXEC sp_addextendedproperty 'MS_Description', 'Weld Management System Table of Specification Matrix Data Column Specification or Cells with will house al the Specification Matrix Supplementary Data. Child to both Specification and Specification Matrix Data Columns', 'user', 'dbo', 'table', 'SpecificationMatrixDataColumnSpecification'GOEXEC sp_addextendedproperty 'MS_Description', 'Referance to the Specification Id', 'user', 'dbo', 'table', 'SpecificationMatrixDataColumnSpecification', 'column', 'SpecificationMatrixDataColumnId'GOEXEC sp_addextendedproperty 'MS_Description', 'Refenence to the Specification Table', 'user', 'dbo', 'table', 'SpecificationMatrixDataColumnSpecification', 'column', 'SpecificationId'GOEXEC sp_addextendedproperty 'MS_Description', 'Data Cell for the Data Column at the Appropriate Specification', 'user', 'dbo', 'table', 'SpecificationMatrixDataColumnSpecification', 'column', 'SpecificationData'GO/** 15 SpecificationMatrixDataColumn **/EXEC sp_addextendedproperty 'MS_Description', 'Weld Management System Table of Specification Matrix Data Column is a Container for Supplementary Data within a Specification Matrix.  Child of Specification Matrix and Parent of Specification Matrix Data Column Specification', 'user', 'dbo', 'table', 'SpecificationMatrixDataColumn'GOEXEC sp_addextendedproperty 'MS_Description', 'SpecificationMatrixDataColumnId identifies SpecificationMatrixDataColumn', 'user', 'dbo', 'table', 'SpecificationMatrixDataColumn', 'column', 'SpecificationMatrixDataColumnId'GOEXEC sp_addextendedproperty 'MS_Description', 'Name of the Specification Matrix Data Column', 'user', 'dbo', 'table', 'SpecificationMatrixDataColumn', 'column', 'Name'GOEXEC sp_addextendedproperty 'MS_Description', 'SpecificationMatrixId is of SpecificationMatrixDataColumn', 'user', 'dbo', 'table', 'SpecificationMatrixDataColumn', 'column', 'SpecificationMatrixId'GO/** 16 ProjectSpecificationMatrix **/EXEC sp_addextendedproperty 'MS_Description', 'Weld Management System Project Specification Matrix Table Chile of both Project and Specification Tables', 'user', 'dbo', 'table', 'ProjectSpecificationMatrix'GOEXEC sp_addextendedproperty 'MS_Description', 'Reference to the Projects Table', 'user', 'dbo', 'table', 'ProjectSpecificationMatrix', 'column', 'ProjectId'GOEXEC sp_addextendedproperty 'MS_Description', 'Reference to the Specification Matrix Table', 'user', 'dbo', 'table', 'ProjectSpecificationMatrix', 'column', 'SpecificationMatrixId'GO/** 17 SpecificationMatrixSpecification **/EXEC sp_addextendedproperty 'MS_Description', 'Weld Management System  Table of SpecificationMatrixSpecification', 'user', 'dbo', 'table', 'SpecificationMatrixSpecification'GOEXEC sp_addextendedproperty 'MS_Description', 'Referance to Specification Matrix Table', 'user', 'dbo', 'table', 'SpecificationMatrixSpecification', 'column', 'SpecificationMatrixId'GOEXEC sp_addextendedproperty 'MS_Description', 'Reference to the Specification', 'user', 'dbo', 'table', 'SpecificationMatrixSpecification', 'column', 'SpecificationId'GO/** 18 SpecificationMatrix **/EXEC sp_addextendedproperty 'MS_Description', 'Weld Management System  Contains all the specification requirements for a project.', 'user', 'dbo', 'table', 'SpecificationMatrix'GOEXEC sp_addextendedproperty 'MS_Description', 'Specification Matrix Id partly Specification Matrix', 'user', 'dbo', 'table', 'SpecificationMatrix', 'column', 'SpecificationMatrixId'GOEXEC sp_addextendedproperty 'MS_Description', 'Internal Cord Specification Matrix Id', 'user', 'dbo', 'table', 'SpecificationMatrix', 'column', 'SpecMatrixId'GOEXEC sp_addextendedproperty 'MS_Description', 'Specification Codeof Specification Matrix', 'user', 'dbo', 'table', 'SpecificationMatrix', 'column', 'SpecificationCode'GOEXEC sp_addextendedproperty 'MS_Description', 'Revision Number of Specification Matrix', 'user', 'dbo', 'table', 'SpecificationMatrix', 'column', 'RevisionNumber'GO/** 19 Specification **/EXEC sp_addextendedproperty 'MS_Description', 'Weld Management System Specification Table Parent to Specification Matrix and both of its Data Column Tables, Child of Weld Procedures', 'user', 'dbo', 'table', 'Specification'GOEXEC sp_addextendedproperty 'MS_Description', 'Name of Specification', 'user', 'dbo', 'table', 'Specification', 'column', 'SpecificationId'GOEXEC sp_addextendedproperty 'MS_Description', 'Referance to the Weld Procedure Table', 'user', 'dbo', 'table', 'Specification', 'column', 'WeldProcedureId'GOEXEC sp_addextendedproperty 'MS_Description', 'Pipe Class of Specification', 'user', 'dbo', 'table', 'Specification', 'column', 'PipeClass'GO/** 20 HydroTestSpool **/EXEC sp_addextendedproperty 'MS_Description', 'Weld Management System Hydro Test Spools Table', 'user', 'dbo', 'table', 'HydroTestSpool'GOEXEC sp_addextendedproperty 'MS_Description', 'Hydrotest Spool Partial Primary Key for and reference to the Hydro Test Table', 'user', 'dbo', 'table', 'HydroTestSpool', 'column', 'HydroTestId'GOEXEC sp_addextendedproperty 'MS_Description', 'Hydrotest Spool Partial Primary Key for and reference to the Spool Table', 'user', 'dbo', 'table', 'HydroTestSpool', 'column', 'SpoolId'GO/** 21 HydroTest **/EXEC sp_addextendedproperty 'MS_Description', 'Weld Management System Hydro Tests Table', 'user', 'dbo', 'table', 'HydroTest'GOEXEC sp_addextendedproperty 'MS_Description', 'Hydro Test Table Unique ID and Primary Key for Hydro Test Table', 'user', 'dbo', 'table', 'HydroTest', 'column', 'HydroTestId'GOEXEC sp_addextendedproperty 'MS_Description', 'Referance to Test Result Table', 'user', 'dbo', 'table', 'HydroTest', 'column', 'TestResultId'GOEXEC sp_addextendedproperty 'MS_Description', 'Date of Hydro Test', 'user', 'dbo', 'table', 'HydroTest', 'column', 'TestDate'GOEXEC sp_addextendedproperty 'MS_Description', 'Reference to the Hydro Test Medium', 'user', 'dbo', 'table', 'HydroTest', 'column', 'HydroMediumId'GOEXEC sp_addextendedproperty 'MS_Description', 'Procedure is of HydroTest', 'user', 'dbo', 'table', 'HydroTest', 'column', 'Procedure'GO/** 22 WeldTestType **/EXEC sp_addextendedproperty 'MS_Description', 'Weld Management System Weld Test Type Parent to Weld Test, Specification Test Column Layout and Specification Test Column Tables', 'user', 'dbo', 'table', 'WeldTestType'GOEXEC sp_addextendedproperty 'MS_Description', 'Primary Key for Weld Test Type Table', 'user', 'dbo', 'table', 'WeldTestType', 'column', 'WeldTestTypeId'GOEXEC sp_addextendedproperty 'MS_Description', 'TestTypeName is of WeldTestType', 'user', 'dbo', 'table', 'WeldTestType', 'column', 'TestTypeName'GOEXEC sp_addextendedproperty 'MS_Description', 'Abbreviation is of WeldTestType', 'user', 'dbo', 'table', 'WeldTestType', 'column', 'Abbreviation'GO/** 23 WeldTest **/EXEC sp_addextendedproperty 'MS_Description', 'Weld Management System Weld Test Child to Weld Test Type, Test Result and Weld Tables. Parent to Tracer Test Table', 'user', 'dbo', 'table', 'WeldTest'GOEXEC sp_addextendedproperty 'MS_Description', 'Primary Key for Weld Test Table', 'user', 'dbo', 'table', 'WeldTest', 'column', 'WeldTestId'GOEXEC sp_addextendedproperty 'MS_Description', 'Referanc to Weld Table', 'user', 'dbo', 'table', 'WeldTest', 'column', 'WeldId'GOEXEC sp_addextendedproperty 'MS_Description', 'Referance to Weld Test Type', 'user', 'dbo', 'table', 'WeldTest', 'column', 'WeldTestTypeId'GOEXEC sp_addextendedproperty 'MS_Description', 'Date of Weld Test', 'user', 'dbo', 'table', 'WeldTest', 'column', 'TestDate'GOEXEC sp_addextendedproperty 'MS_Description', 'Referance to Test Result Table', 'user', 'dbo', 'table', 'WeldTest', 'column', 'TestResultId'GO/** 24 TestResult **/EXEC sp_addextendedproperty 'MS_Description', 'Weld Management System Test Result Defination Table parent to both Hydro Test and Weld Test Tables.', 'user', 'dbo', 'table', 'TestResult'GOEXEC sp_addextendedproperty 'MS_Description', 'Test Result Table Unique ID and Primary Key for Test Result Table', 'user', 'dbo', 'table', 'TestResult', 'column', 'TestResultId'GOEXEC sp_addextendedproperty 'MS_Description', 'Test Result Name', 'user', 'dbo', 'table', 'TestResult', 'column', 'Result'GO/** 25 WeldStatus **/EXEC sp_addextendedproperty 'MS_Description', 'Table of WeldStatus', 'user', 'dbo', 'table', 'WeldStatus'GOEXEC sp_addextendedproperty 'MS_Description', 'Primary Key for Weld Status Table', 'user', 'dbo', 'table', 'WeldStatus', 'column', 'WeldStatusId'GOEXEC sp_addextendedproperty 'MS_Description', 'Name of Weld Status', 'user', 'dbo', 'table', 'WeldStatus', 'column', 'StatusName'GO/** 26 WeldActivityLog **/EXEC sp_addextendedproperty 'MS_Description', 'Weld Management System Weld Activity Log Table child of Weld Status and Weld Tables', 'user', 'dbo', 'table', 'WeldActivityLog'GOEXEC sp_addextendedproperty 'MS_Description', 'Weld Activity Log Table Unique ID and Primary Key for Weld Activity Log', 'user', 'dbo', 'table', 'WeldActivityLog', 'column', 'WeldActivityLogId'GOEXEC sp_addextendedproperty 'MS_Description', 'Reference to the Weld Table', 'user', 'dbo', 'table', 'WeldActivityLog', 'column', 'WeldId'GOEXEC sp_addextendedproperty 'MS_Description', 'Reference to the Weld Status Table', 'user', 'dbo', 'table', 'WeldActivityLog', 'column', 'WeldStatusId'GOEXEC sp_addextendedproperty 'MS_Description', 'Date of Log Entry', 'user', 'dbo', 'table', 'WeldActivityLog', 'column', 'LogDate'GOEXEC sp_addextendedproperty 'MS_Description', 'Comment of Log', 'user', 'dbo', 'table', 'WeldActivityLog', 'column', 'Comment'GO/** 27 Weld **/EXEC sp_addextendedproperty 'MS_Description', 'Weld Management System Welds Table Child of Welder, Drawing Revision, Spool Revision, Weld Type and Weld Table.  Parent of Weld Activity Log, Tracer Test and Weld Test Table', 'user', 'dbo', 'table', 'Weld'GOEXEC sp_addextendedproperty 'MS_Description', 'Primary Key of Weld Table', 'user', 'dbo', 'table', 'Weld', 'column', 'WeldId'GOEXEC sp_addextendedproperty 'MS_Description', 'Referance to Weld Type Table', 'user', 'dbo', 'table', 'Weld', 'column', 'WeldTypeId'GOEXEC sp_addextendedproperty 'MS_Description', 'Referance to Weld Table if Weld is a Replacement Weld', 'user', 'dbo', 'table', 'Weld', 'column', 'ParentId'GOEXEC sp_addextendedproperty 'MS_Description', 'Referance to the Welder Table', 'user', 'dbo', 'table', 'Weld', 'column', 'WelderId'GOEXEC sp_addextendedproperty 'MS_Description', 'Referance to the Weld Procedure Table', 'user', 'dbo', 'table', 'Weld', 'column', 'WeldProcedureId'GOEXEC sp_addextendedproperty 'MS_Description', 'Partial Reference to the Welds Parent Spool Revision via the Spool Id', 'user', 'dbo', 'table', 'Weld', 'column', 'SpoolId'GOEXEC sp_addextendedproperty 'MS_Description', 'Partial Reference to the Welds Parent Spool Revision via the Spool Revision Number', 'user', 'dbo', 'table', 'Weld', 'column', 'SpoolRevisionNumber'GOEXEC sp_addextendedproperty 'MS_Description', 'Size of Weld (Metric)', 'user', 'dbo', 'table', 'Weld', 'column', 'Size'GOEXEC sp_addextendedproperty 'MS_Description', 'Wall Strength', 'user', 'dbo', 'table', 'Weld', 'column', 'Wall'GOEXEC sp_addextendedproperty 'MS_Description', 'Common on Weld', 'user', 'dbo', 'table', 'Weld', 'column', 'Comment'GOEXEC sp_addextendedproperty 'MS_Description', 'Date of Weld', 'user', 'dbo', 'table', 'Weld', 'column', 'WeldDate'GOEXEC sp_addextendedproperty 'MS_Description', 'Cords Internal Weld Name', 'user', 'dbo', 'table', 'Weld', 'column', 'WeldTag'GOEXEC sp_addextendedproperty 'MS_Description', 'Partial Reference to the Welds Parent Drawing Revision via the Drawing Id', 'user', 'dbo', 'table', 'Weld', 'column', 'DrawingId'GOEXEC sp_addextendedproperty 'MS_Description', 'Partial Reference to the Welds Parent Drawing Revision via the Revision Number', 'user', 'dbo', 'table', 'Weld', 'column', 'DrawingRevisionNumber'GO/** 28 WeldType **/EXEC sp_addextendedproperty 'MS_Description', 'Weld Management System Weld Test Type Defination Table', 'user', 'dbo', 'table', 'WeldType'GOEXEC sp_addextendedproperty 'MS_Description', 'Weld Type Table Unique ID and Primary Key for Weld Type Table', 'user', 'dbo', 'table', 'WeldType', 'column', 'WeldTypeId'GOEXEC sp_addextendedproperty 'MS_Description', 'Unique Name of Weld Type', 'user', 'dbo', 'table', 'WeldType', 'column', 'WeldTypeName'GOEXEC sp_addextendedproperty 'MS_Description', 'Unique Abbreviation of Weld Type', 'user', 'dbo', 'table', 'WeldType', 'column', 'Abbreviation'GO/** 29 Spool **/EXEC sp_addextendedproperty 'MS_Description', 'Spools are also known as Cut Sheets and their SpoolId or identifiers are know internally as Mark Numbers', 'user', 'dbo', 'table', 'Spool'GOEXEC sp_addextendedproperty 'MS_Description', 'Spool Table Unique ID and Primary Key for Spool Table', 'user', 'dbo', 'table', 'Spool', 'column', 'SpoolId'GOEXEC sp_addextendedproperty 'MS_Description', 'Referanc Numbe for Spool Drawing', 'user', 'dbo', 'table', 'Spool', 'column', 'SpoolNo'GOEXEC sp_addextendedproperty 'MS_Description', 'The Spool may span Multiple Modules, this can be searched', 'user', 'dbo', 'table', 'Spool', 'column', 'ModuleId'GOEXEC sp_addextendedproperty 'MS_Description', 'Cord Projects internal Control Number of Spool', 'user', 'dbo', 'table', 'Spool', 'column', 'ControlNumber'GOEXEC sp_addextendedproperty 'MS_Description', 'Partial Reference to the Spools Parent Drawing Revision via the Drawing Id', 'user', 'dbo', 'table', 'Spool', 'column', 'DrawingId'GOEXEC sp_addextendedproperty 'MS_Description', 'Partial Reference to the Spools Parent Drawing Revision via the Revision Number', 'user', 'dbo', 'table', 'Spool', 'column', 'DrawingRevisionNumber'GO/** 30 DrawingType **/EXEC sp_addextendedproperty 'MS_Description', 'Weld Management System Project Drawing Type Table', 'user', 'dbo', 'table', 'DrawingType'GOEXEC sp_addextendedproperty 'MS_Description', 'Work Package Type Unique ID and Primary Key for Work Package Type Table', 'user', 'dbo', 'table', 'DrawingType', 'column', 'DrawingTypeId'GOEXEC sp_addextendedproperty 'MS_Description', 'Name of Work Package Type', 'user', 'dbo', 'table', 'DrawingType', 'column', 'DrawingTypeName'GO/** 31 WeldProcedure **/EXEC sp_addextendedproperty 'MS_Description', 'Weld Management System Weld Procedure Defination Table Parent to Weld, Procedure Qualification Weld Procedure and Specification Table, can be child of Customer Table', 'user', 'dbo', 'table', 'WeldProcedure'GOEXEC sp_addextendedproperty 'MS_Description', 'Weld Procedure Table Unique ID and Primary Key for Weld Procedure Table', 'user', 'dbo', 'table', 'WeldProcedure', 'column', 'WeldProcedureId'GOEXEC sp_addextendedproperty 'MS_Description', 'Name of Weld Procedure', 'user', 'dbo', 'table', 'WeldProcedure', 'column', 'ProcedureName'GOEXEC sp_addextendedproperty 'MS_Description', 'Reference to Client Table for the Client who provided this Weld Procedure', 'user', 'dbo', 'table', 'WeldProcedure', 'column', 'CustomerId'GO/** 32 ProcedureQualificationWeldProcedure **/EXEC sp_addextendedproperty 'MS_Description', 'Weld Management System Procedure Qualification Weld Procedures Child of both Weld Procedure and Procedure Qualification Record Tables', 'user', 'dbo', 'table', 'ProcedureQualificationWeldProcedure'GOEXEC sp_addextendedproperty 'MS_Description', 'Referance to ProcedureQualification Table', 'user', 'dbo', 'table', 'ProcedureQualificationWeldProcedure', 'column', 'ProcedureQualificationId'GOEXEC sp_addextendedproperty 'MS_Description', 'Referance to Weld Procedure Table', 'user', 'dbo', 'table', 'ProcedureQualificationWeldProcedure', 'column', 'WeldProcedureId'GO/** 33 ProcedureQualification **/EXEC sp_addextendedproperty 'MS_Description', 'Weld Management System Procedure Qualification Table Parent to both Procedure Qualification Weld Procedure and Welder Procedure Qualification Record Tables', 'user', 'dbo', 'table', 'ProcedureQualification'GOEXEC sp_addextendedproperty 'MS_Description', 'Primary Key for Procedure Qualification Record Type', 'user', 'dbo', 'table', 'ProcedureQualification', 'column', 'ProcedureQualificationId'GOEXEC sp_addextendedproperty 'MS_Description', 'Name of Procedure Qualification', 'user', 'dbo', 'table', 'ProcedureQualification', 'column', 'QualificationName'GO/** 34 WelderProcedureQualificationRecord **/EXEC sp_addextendedproperty 'MS_Description', 'Weld Management System Welder Procedure Qualification Record Child of both Procedure Qualification Record and Welder Tables', 'user', 'dbo', 'table', 'WelderProcedureQualificationRecord'GOEXEC sp_addextendedproperty 'MS_Description', 'Primary Key for Welder Qualification Record', 'user', 'dbo', 'table', 'WelderProcedureQualificationRecord', 'column', 'WelderProcedureQualificationRecordId'GOEXEC sp_addextendedproperty 'MS_Description', 'Referance to Procedure Qualification Type', 'user', 'dbo', 'table', 'WelderProcedureQualificationRecord', 'column', 'ProcedureQualificationId'GOEXEC sp_addextendedproperty 'MS_Description', 'Date Record Expires', 'user', 'dbo', 'table', 'WelderProcedureQualificationRecord', 'column', 'QualificationExpiryDate'GOEXEC sp_addextendedproperty 'MS_Description', 'Referance to the Welder Table', 'user', 'dbo', 'table', 'WelderProcedureQualificationRecord', 'column', 'WelderId'GO/** 35 Welder **/EXEC sp_addextendedproperty 'MS_Description', 'Weld Management System Project Welder Table Child of Employee Table and Parent to both Weld and Weld Procedure Qualification Record Table', 'user', 'dbo', 'table', 'Welder'GOEXEC sp_addextendedproperty 'MS_Description', 'Employee Unique ID and Primary Key for Welder Table', 'user', 'dbo', 'table', 'Welder', 'column', 'WelderId'GOEXEC sp_addextendedproperty 'MS_Description', 'Reference to parent table Employee', 'user', 'dbo', 'table', 'Welder', 'column', 'EmployeeId'GO/** 36 EmployeePosition **/EXEC sp_addextendedproperty 'MS_Description', 'Weld Management System Employee Position Table', 'user', 'dbo', 'table', 'EmployeePosition'GOEXEC sp_addextendedproperty 'MS_Description', 'Employee Position Unique ID and Primary Key for Employee Position Table', 'user', 'dbo', 'table', 'EmployeePosition', 'column', 'EmployeePositionId'GOEXEC sp_addextendedproperty 'MS_Description', 'Name of Employee Position', 'user', 'dbo', 'table', 'EmployeePosition', 'column', 'PositionName'GO/** 37 Employee **/EXEC sp_addextendedproperty 'MS_Description', 'Weld Management System Employee Table Child of Employee Position Table', 'user', 'dbo', 'table', 'Employee'GOEXEC sp_addextendedproperty 'MS_Description', 'Employee Unique ID and Primary Key for Employee Table', 'user', 'dbo', 'table', 'Employee', 'column', 'EmployeeId'GOEXEC sp_addextendedproperty 'MS_Description', 'First Name of Employee', 'user', 'dbo', 'table', 'Employee', 'column', 'FirstName'GOEXEC sp_addextendedproperty 'MS_Description', 'Last Name of Employee', 'user', 'dbo', 'table', 'Employee', 'column', 'LastName'GOEXEC sp_addextendedproperty 'MS_Description', 'Reference to parent table Employee Position', 'user', 'dbo', 'table', 'Employee', 'column', 'EmployeePositionId'GOEXEC sp_addextendedproperty 'MS_Description', 'Status of the Employee whether it is active or not', 'user', 'dbo', 'table', 'Employee', 'column', 'Status'GO/** 38 ProjectEmployee **/EXEC sp_addextendedproperty 'MS_Description', 'Weld Management System Project Employee Table Child of both Employee and Project Table', 'user', 'dbo', 'table', 'ProjectEmployee'GOEXEC sp_addextendedproperty 'MS_Description', 'Reference to parent table Project', 'user', 'dbo', 'table', 'ProjectEmployee', 'column', 'ProjectId'GOEXEC sp_addextendedproperty 'MS_Description', 'Reference to parent table Employee', 'user', 'dbo', 'table', 'ProjectEmployee', 'column', 'EmployeeId'GO/** 39 Customer **/EXEC sp_addextendedproperty 'MS_Description', 'Weld Management System Client Table Parent of Project and Weld Procedure Tables', 'user', 'dbo', 'table', 'Customer'GOEXEC sp_addextendedproperty 'MS_Description', 'Customer Table Unique ID and Primary Key for Customer', 'user', 'dbo', 'table', 'Customer', 'column', 'CustomerId'GOEXEC sp_addextendedproperty 'MS_Description', 'Name of Customer Company', 'user', 'dbo', 'table', 'Customer', 'column', 'CustomerName'GO/** 40 Project **/EXEC sp_addextendedproperty 'MS_Description', 'Weld Management System Project Table Child of Client Table and Patent of Project Specification, Project Employee and Drawing Tables', 'user', 'dbo', 'table', 'Project'GOEXEC sp_addextendedproperty 'MS_Description', 'Project Unique ID and Primary Key for Project Table', 'user', 'dbo', 'table', 'Project', 'column', 'ProjectId'GOEXEC sp_addextendedproperty 'MS_Description', 'Name of Customer Project', 'user', 'dbo', 'table', 'Project', 'column', 'ProjectName'GOEXEC sp_addextendedproperty 'MS_Description', 'Reference to parent table Customer', 'user', 'dbo', 'table', 'Project', 'column', 'CustomerId'GOEXEC sp_addextendedproperty 'MS_Description', 'Status of the Project whether it is active or not', 'user', 'dbo', 'table', 'Project', 'column', 'Status'GO