/**
 * 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'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Tracer Id Primary Key for Tracer Test Talbe', 'user', 'dbo', 'table', 'TracerTest', 'column', 'TracerId'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Reference to Weld Test Table', 'user', 'dbo', 'table', 'TracerTest', 'column', 'WeldTestId'
GO
EXEC 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'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Hydro Medium Table Unique ID and Primary Key for Hydro Medium Table', 'user', 'dbo', 'table', 'HydroMedium', 'column', 'HydroMediumId'
GO
EXEC 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'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Hydrotest Drawing Partial Primary Key for and reference to the Hydro Test Table', 'user', 'dbo', 'table', 'HydroTestDrawing', 'column', 'HydroTestId'
GO
EXEC 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'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Drawing Revision Unique ID and Partial Primary Key for Drawing Revision Table', 'user', 'dbo', 'table', 'DrawingRevision', 'column', 'DrawingId'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Drawing Revision Unique ID and Partial Primary Key for Drawing Revision Table', 'user', 'dbo', 'table', 'DrawingRevision', 'column', 'DrawingRevisionNumber'
GO
EXEC 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'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Drawing Unique ID and Primary Key for Drawing Table', 'user', 'dbo', 'table', 'Drawing', 'column', 'DrawingId'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Drawing Revision Number', 'user', 'dbo', 'table', 'Drawing', 'column', 'RevisionNumber'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Reference to the Drawings Project', 'user', 'dbo', 'table', 'Drawing', 'column', 'ProjectId'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Reference to the Drawings Drawing Type', 'user', 'dbo', 'table', 'Drawing', 'column', 'DrawingTypeId'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Partial Reference to the Drawings Parent Drawing via the Drawing Id', 'user', 'dbo', 'table', 'Drawing', 'column', 'ParentDrawingId'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Partial Reference to the Drawings Parent Drawing via the Revision Number', 'user', 'dbo', 'table', 'Drawing', 'column', 'ParentRevisionNumber'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Cord Projects Unique Internal Drawing Number', 'user', 'dbo', 'table', 'Drawing', 'column', 'InternalDrawingNumber'
GO
EXEC 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'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Primary Key for the Test Column Object Layout Table', 'user', 'dbo', 'table', 'TestColumnObjectLayout', 'column', 'TestColumnObjectIdLayout'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Reference to the Specification Test Column Layout', 'user', 'dbo', 'table', 'TestColumnObjectLayout', 'column', 'SpecificationTestColumnIdLayout'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Name of the Test Column Object', 'user', 'dbo', 'table', 'TestColumnObjectLayout', 'column', 'NameLayout'
GO
EXEC 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'
GO
EXEC 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'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Template Id Layout id the Refenence ot the Specification Matrix Template', 'user', 'dbo', 'table', 'SpecificationMatrixDataColumnLayout', 'column', 'TemplateIdLayout'
GO
EXEC 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'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Primary Key for Specification Test Column Layout Table', 'user', 'dbo', 'table', 'SpecificationTestColumnLayout', 'column', 'SpecificationTestColumnIdLayout'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Refenence to the Weld Test Type Table', 'user', 'dbo', 'table', 'SpecificationTestColumnLayout', 'column', 'WeldTestTypeId'
GO
EXEC 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'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Primary Key for Specification Template Matrix Layout', 'user', 'dbo', 'table', 'SpecificationMatrixTemplateLayout', 'column', 'TemplateIdLayout'
GO
EXEC 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'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Combined Primary Key for the Spool Revision and Reference to parent table Spool', 'user', 'dbo', 'table', 'SpoolRevision', 'column', 'SpoolId'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Combined Primary Key for the Spool Revision and Reference to parent table Spool', 'user', 'dbo', 'table', 'SpoolRevision', 'column', 'SpoolRevisionNumber'
GO
EXEC 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'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Reference to the Test Column Object Table', 'user', 'dbo', 'table', 'TestColumnObjectData', 'column', 'TestColumnObjectId'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Refenence to the Specification Table', 'user', 'dbo', 'table', 'TestColumnObjectData', 'column', 'SpecificationId'
GO
EXEC 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'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Primary Key for Test Column Object Table', 'user', 'dbo', 'table', 'TestColumnObject', 'column', 'TestColumnObjectId'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Reference to the Specification Test Column', 'user', 'dbo', 'table', 'TestColumnObject', 'column', 'SpecificationTestColumnId'
GO
EXEC 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'
GO
EXEC 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'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Primary Key for Specification Test Column Table', 'user', 'dbo', 'table', 'SpecificationTestColumn', 'column', 'SpecificationTestColumnId'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Refenence to the Weld Test Type Table', 'user', 'dbo', 'table', 'SpecificationTestColumn', 'column', 'WeldTestTypeId'
GO
EXEC 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'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Referance to the Specification Id', 'user', 'dbo', 'table', 'SpecificationMatrixDataColumnSpecification', 'column', 'SpecificationMatrixDataColumnId'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Refenence to the Specification Table', 'user', 'dbo', 'table', 'SpecificationMatrixDataColumnSpecification', 'column', 'SpecificationId'
GO
EXEC 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'
GO
EXEC sp_addextendedproperty 'MS_Description', 'SpecificationMatrixDataColumnId identifies SpecificationMatrixDataColumn', 'user', 'dbo', 'table', 'SpecificationMatrixDataColumn', 'column', 'SpecificationMatrixDataColumnId'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Name of the Specification Matrix Data Column', 'user', 'dbo', 'table', 'SpecificationMatrixDataColumn', 'column', 'Name'
GO
EXEC 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'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Reference to the Projects Table', 'user', 'dbo', 'table', 'ProjectSpecificationMatrix', 'column', 'ProjectId'
GO
EXEC 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'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Referance to Specification Matrix Table', 'user', 'dbo', 'table', 'SpecificationMatrixSpecification', 'column', 'SpecificationMatrixId'
GO
EXEC 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'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Specification Matrix Id partly Specification Matrix', 'user', 'dbo', 'table', 'SpecificationMatrix', 'column', 'SpecificationMatrixId'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Internal Cord Specification Matrix Id', 'user', 'dbo', 'table', 'SpecificationMatrix', 'column', 'SpecMatrixId'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Specification Codeof Specification Matrix', 'user', 'dbo', 'table', 'SpecificationMatrix', 'column', 'SpecificationCode'
GO
EXEC 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'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Name of Specification', 'user', 'dbo', 'table', 'Specification', 'column', 'SpecificationId'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Referance to the Weld Procedure Table', 'user', 'dbo', 'table', 'Specification', 'column', 'WeldProcedureId'
GO
EXEC 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'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Hydrotest Spool Partial Primary Key for and reference to the Hydro Test Table', 'user', 'dbo', 'table', 'HydroTestSpool', 'column', 'HydroTestId'
GO
EXEC 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'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Hydro Test Table Unique ID and Primary Key for Hydro Test Table', 'user', 'dbo', 'table', 'HydroTest', 'column', 'HydroTestId'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Referance to Test Result Table', 'user', 'dbo', 'table', 'HydroTest', 'column', 'TestResultId'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Date of Hydro Test', 'user', 'dbo', 'table', 'HydroTest', 'column', 'TestDate'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Reference to the Hydro Test Medium', 'user', 'dbo', 'table', 'HydroTest', 'column', 'HydroMediumId'
GO
EXEC 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'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Primary Key for Weld Test Type Table', 'user', 'dbo', 'table', 'WeldTestType', 'column', 'WeldTestTypeId'
GO
EXEC sp_addextendedproperty 'MS_Description', 'TestTypeName is of WeldTestType', 'user', 'dbo', 'table', 'WeldTestType', 'column', 'TestTypeName'
GO
EXEC 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'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Primary Key for Weld Test Table', 'user', 'dbo', 'table', 'WeldTest', 'column', 'WeldTestId'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Referanc to Weld Table', 'user', 'dbo', 'table', 'WeldTest', 'column', 'WeldId'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Referance to Weld Test Type', 'user', 'dbo', 'table', 'WeldTest', 'column', 'WeldTestTypeId'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Date of Weld Test', 'user', 'dbo', 'table', 'WeldTest', 'column', 'TestDate'
GO
EXEC 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'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Test Result Table Unique ID and Primary Key for Test Result Table', 'user', 'dbo', 'table', 'TestResult', 'column', 'TestResultId'
GO
EXEC 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'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Primary Key for Weld Status Table', 'user', 'dbo', 'table', 'WeldStatus', 'column', 'WeldStatusId'
GO
EXEC 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'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Weld Activity Log Table Unique ID and Primary Key for Weld Activity Log', 'user', 'dbo', 'table', 'WeldActivityLog', 'column', 'WeldActivityLogId'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Reference to the Weld Table', 'user', 'dbo', 'table', 'WeldActivityLog', 'column', 'WeldId'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Reference to the Weld Status Table', 'user', 'dbo', 'table', 'WeldActivityLog', 'column', 'WeldStatusId'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Date of Log Entry', 'user', 'dbo', 'table', 'WeldActivityLog', 'column', 'LogDate'
GO
EXEC 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'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Primary Key of Weld Table', 'user', 'dbo', 'table', 'Weld', 'column', 'WeldId'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Referance to Weld Type Table', 'user', 'dbo', 'table', 'Weld', 'column', 'WeldTypeId'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Referance to Weld Table if Weld is a Replacement Weld', 'user', 'dbo', 'table', 'Weld', 'column', 'ParentId'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Referance to the Welder Table', 'user', 'dbo', 'table', 'Weld', 'column', 'WelderId'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Referance to the Weld Procedure Table', 'user', 'dbo', 'table', 'Weld', 'column', 'WeldProcedureId'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Partial Reference to the Welds Parent Spool Revision via the Spool Id', 'user', 'dbo', 'table', 'Weld', 'column', 'SpoolId'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Partial Reference to the Welds Parent Spool Revision via the Spool Revision Number', 'user', 'dbo', 'table', 'Weld', 'column', 'SpoolRevisionNumber'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Size of Weld (Metric)', 'user', 'dbo', 'table', 'Weld', 'column', 'Size'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Wall Strength', 'user', 'dbo', 'table', 'Weld', 'column', 'Wall'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Common on Weld', 'user', 'dbo', 'table', 'Weld', 'column', 'Comment'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Date of Weld', 'user', 'dbo', 'table', 'Weld', 'column', 'WeldDate'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Cords Internal Weld Name', 'user', 'dbo', 'table', 'Weld', 'column', 'WeldTag'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Partial Reference to the Welds Parent Drawing Revision via the Drawing Id', 'user', 'dbo', 'table', 'Weld', 'column', 'DrawingId'
GO
EXEC 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'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Weld Type Table Unique ID and Primary Key for Weld Type Table', 'user', 'dbo', 'table', 'WeldType', 'column', 'WeldTypeId'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Unique Name of Weld Type', 'user', 'dbo', 'table', 'WeldType', 'column', 'WeldTypeName'
GO
EXEC 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'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Spool Table Unique ID and Primary Key for Spool Table', 'user', 'dbo', 'table', 'Spool', 'column', 'SpoolId'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Referanc Numbe for Spool Drawing', 'user', 'dbo', 'table', 'Spool', 'column', 'SpoolNo'
GO
EXEC sp_addextendedproperty 'MS_Description', 'The Spool may span Multiple Modules, this can be searched', 'user', 'dbo', 'table', 'Spool', 'column', 'ModuleId'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Cord Projects internal Control Number of Spool', 'user', 'dbo', 'table', 'Spool', 'column', 'ControlNumber'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Partial Reference to the Spools Parent Drawing Revision via the Drawing Id', 'user', 'dbo', 'table', 'Spool', 'column', 'DrawingId'
GO
EXEC 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'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Work Package Type Unique ID and Primary Key for Work Package Type Table', 'user', 'dbo', 'table', 'DrawingType', 'column', 'DrawingTypeId'
GO
EXEC 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'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Weld Procedure Table Unique ID and Primary Key for Weld Procedure Table', 'user', 'dbo', 'table', 'WeldProcedure', 'column', 'WeldProcedureId'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Name of Weld Procedure', 'user', 'dbo', 'table', 'WeldProcedure', 'column', 'ProcedureName'
GO
EXEC 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'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Referance to ProcedureQualification Table', 'user', 'dbo', 'table', 'ProcedureQualificationWeldProcedure', 'column', 'ProcedureQualificationId'
GO
EXEC 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'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Primary Key for Procedure Qualification Record Type', 'user', 'dbo', 'table', 'ProcedureQualification', 'column', 'ProcedureQualificationId'
GO
EXEC 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'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Primary Key for Welder Qualification Record', 'user', 'dbo', 'table', 'WelderProcedureQualificationRecord', 'column', 'WelderProcedureQualificationRecordId'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Referance to Procedure Qualification Type', 'user', 'dbo', 'table', 'WelderProcedureQualificationRecord', 'column', 'ProcedureQualificationId'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Date Record Expires', 'user', 'dbo', 'table', 'WelderProcedureQualificationRecord', 'column', 'QualificationExpiryDate'
GO
EXEC 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'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Employee Unique ID and Primary Key for Welder Table', 'user', 'dbo', 'table', 'Welder', 'column', 'WelderId'
GO
EXEC 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'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Employee Position Unique ID and Primary Key for Employee Position Table', 'user', 'dbo', 'table', 'EmployeePosition', 'column', 'EmployeePositionId'
GO
EXEC 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'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Employee Unique ID and Primary Key for Employee Table', 'user', 'dbo', 'table', 'Employee', 'column', 'EmployeeId'
GO
EXEC sp_addextendedproperty 'MS_Description', 'First Name of Employee', 'user', 'dbo', 'table', 'Employee', 'column', 'FirstName'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Last Name of Employee', 'user', 'dbo', 'table', 'Employee', 'column', 'LastName'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Reference to parent table Employee Position', 'user', 'dbo', 'table', 'Employee', 'column', 'EmployeePositionId'
GO
EXEC 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'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Reference to parent table Project', 'user', 'dbo', 'table', 'ProjectEmployee', 'column', 'ProjectId'
GO
EXEC 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'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Customer Table Unique ID and Primary Key for Customer', 'user', 'dbo', 'table', 'Customer', 'column', 'CustomerId'
GO
EXEC 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'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Project Unique ID and Primary Key for Project Table', 'user', 'dbo', 'table', 'Project', 'column', 'ProjectId'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Name of Customer Project', 'user', 'dbo', 'table', 'Project', 'column', 'ProjectName'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Reference to parent table Customer', 'user', 'dbo', 'table', 'Project', 'column', 'CustomerId'
GO
EXEC sp_addextendedproperty 'MS_Description', 'Status of the Project whether it is active or not', 'user', 'dbo', 'table', 'Project', 'column', 'Status'
GO