|
|
|
|
|
delete from TableColumnDef where TableName='DeckSlabCondition'
|
|
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('DeckSlabCondition','BMS.DeckSlabCondition','BridgeCode','DeckSlabCondition',1,'BMS','BridgeCode');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('DeckSlabCondition','BMS.DeckSlabCondition','SurveyYear','DeckSlabCondition',2,'BMS','SurveyYear');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('DeckSlabCondition','BMS.DeckSlabCondition','SpanNo','DeckSlabCondition',3,'BMS','SpanNo');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('DeckSlabCondition','BMS.DeckSlabCondition','CrackType','DeckSlabCondition',4,'BMS','CrackType');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('DeckSlabCondition','BMS.DeckSlabCondition','CrackLen','DeckSlabCondition',5,'BMS','CrackLen');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('DeckSlabCondition','BMS.DeckSlabCondition','CrackWidth','DeckSlabCondition',6,'BMS','CrackWidth');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('DeckSlabCondition','BMS.DeckSlabCondition','NumberofSpalls','DeckSlabCondition',7,'BMS','NumberofSpalls');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('DeckSlabCondition','BMS.DeckSlabCondition','SpallingArea','DeckSlabCondition',8,'BMS','SpallingArea');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('DeckSlabCondition','BMS.DeckSlabCondition','SpallingDepth','DeckSlabCondition',9,'BMS','SpallingDepth');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('DeckSlabCondition','BMS.DeckSlabCondition','Corrosionofreinforcement','DeckSlabCondition',10,'BMS','Corrosionofreinforcement');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('DeckSlabCondition','BMS.DeckSlabCondition','CorrPerc','DeckSlabCondition',11,'BMS','CorrPerc');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('DeckSlabCondition','BMS.DeckSlabCondition','PitCorrosion','DeckSlabCondition',12,'BMS','PitCorrosion');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('DeckSlabCondition','BMS.DeckSlabCondition','ReinfrcCorrLoc','DeckSlabCondition',13,'BMS','ReinfrcCorrLoc');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('DeckSlabCondition','BMS.DeckSlabCondition','VisibleDeflectionsCnt','DeckSlabCondition',14,'BMS','VisibleDeflectionsCnt');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('DeckSlabCondition','BMS.DeckSlabCondition','pondingofwater','DeckSlabCondition',15,'BMS','pondingofwater');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('DeckSlabCondition','BMS.DeckSlabCondition','DiscolouredLoc','DeckSlabCondition',16,'BMS','DiscolouredLoc');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('DeckSlabCondition','BMS.DeckSlabCondition','CrssPreStressAnchrg','DeckSlabCondition',17,'BMS','CrssPreStressAnchrg');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('DeckSlabCondition','BMS.DeckSlabCondition','DamagedAnchrgCnt','DeckSlabCondition',18,'BMS','DamagedAnchrgCnt');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('DeckSlabCondition','BMS.DeckSlabCondition','DmgDesc','DeckSlabCondition',19,'BMS','DmgDesc');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('DeckSlabCondition','BMS.DeckSlabCondition','AnchgCorrEndDegree','DeckSlabCondition',20,'BMS','AnchgCorrEndDegree');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('DeckSlabCondition','BMS.DeckSlabCondition','DamagedDuctsDtls','DeckSlabCondition',21,'BMS','DamagedDuctsDtls');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('DeckSlabCondition','BMS.DeckSlabCondition','InspectedNtMsrd','DeckSlabCondition',22,'BMS','InspectedNtMsrd');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('DeckSlabCondition','BMS.DeckSlabCondition','ModerateDeflect','DeckSlabCondition',23,'BMS','ModerateDeflect');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('DeckSlabCondition','BMS.DeckSlabCondition','ExcessiveDeflect','DeckSlabCondition',24,'BMS','ExcessiveDeflect');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('DeckSlabCondition','BMS.DeckSlabCondition','DeckSlabGirdersJointCond','DeckSlabCondition',25,'BMS','DeckSlabGirdersJointCond');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('DeckSlabCondition','BMS.DeckSlabCondition','SlabConditionSever','DeckSlabCondition',26,'BMS','SlabConditionSever');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('DeckSlabCondition','BMS.DeckSlabCondition','SlabconditionExt','DeckSlabCondition',27,'BMS','SlabconditionExt');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('DeckSlabCondition','BMS.DeckSlabCondition','DripCourseExistence','DeckSlabCondition',29,'BMS','DripCourseExistence');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('DeckSlabCondition','BMS.DeckSlabCondition','MetallicSoundLocCnt','DeckSlabCondition',30,'BMS','MetallicSoundLocCnt');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('DeckSlabCondition','BMS.DeckSlabCondition','HallowSoundLocCnt','DeckSlabCondition',31,'BMS','HallowSoundLocCnt');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('DeckSlabCondition','BMS.DeckSlabCondition','IsConcreteSpalling','DeckSlabCondition',32,'BMS','IsConcreteSpalling');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('DeckSlabCondition','BMS.DeckSlabCondition','EffectedLocCnt','DeckSlabCondition',33,'BMS','EffectedLocCnt');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('DeckSlabCondition','BMS.DeckSlabCondition','IsCracked','DeckSlabCondition',34,'BMS','IsCracked');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('DeckSlabCondition','BMS.DeckSlabCondition','CrackPerc','DeckSlabCondition',35,'BMS','CrackPerc');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('DeckSlabCondition','BMS.DeckSlabCondition','CrackFoundSection','DeckSlabCondition',36,'BMS','CrackFoundSection');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('DeckSlabCondition','BMS.DeckSlabCondition','ExposedReinfLocCnt','DeckSlabCondition',37,'BMS','ExposedReinfLocCnt');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('DeckSlabCondition','BMS.DeckSlabCondition','PreStressWrCorrDegree','DeckSlabCondition',38,'BMS','PreStressWrCorrDegree');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('DeckSlabCondition','BMS.DeckSlabCondition','Remarks','DeckSlabCondition',39,'BMS','Remarks');
|
|
|
|
|
|
delete from TableColumnDef where TableName='GirderCondition'
|
|
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('GirderCondition','BMS.GirderCondition','BridgeCode','GirderCondition',1,'BMS','BridgeCode');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('GirderCondition','BMS.GirderCondition','SurveyYear','GirderCondition',2,'BMS','SurveyYear');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('GirderCondition','BMS.GirderCondition','SpanNo','GirderCondition',3,'BMS','SpanNo');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('GirderCondition','BMS.GirderCondition','CrckType','GirderCondition',4,'BMS','CrckType');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('GirderCondition','BMS.GirderCondition','CrckLength','GirderCondition',5,'BMS','CrckLength');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('GirderCondition','BMS.GirderCondition','CrckWidth','GirderCondition',6,'BMS','CrckWidth');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('GirderCondition','BMS.GirderCondition','Spalling','GirderCondition',7,'BMS','Spalling');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('GirderCondition','BMS.GirderCondition','NoOfbarsexposedNum','GirderCondition',8,'BMS','NoOfbarsexposedNum');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('GirderCondition','BMS.GirderCondition','CorrReinfrc','GirderCondition',9,'BMS','CorrReinfrc');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('GirderCondition','BMS.GirderCondition','VisibleDeflectionsCnt','GirderCondition',10,'BMS','VisibleDeflectionsCnt');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('GirderCondition','BMS.GirderCondition','CrssPreStressAnchrg','GirderCondition',11,'BMS','CrssPreStressAnchrg');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('GirderCondition','BMS.GirderCondition','DamagedAnchrgCnt','GirderCondition',12,'BMS','DamagedAnchrgCnt');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('GirderCondition','BMS.GirderCondition','AnchgCorrDegree','GirderCondition',13,'BMS','AnchgCorrDegree');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('GirderCondition','BMS.GirderCondition','DescofDmgofDucts','GirderCondition',14,'BMS','DescofDmgofDucts');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('GirderCondition','BMS.GirderCondition','InspectedNtMsrd','GirderCondition',15,'BMS','InspectedNtMsrd');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('GirderCondition','BMS.GirderCondition','SpallsinaSpan','GirderCondition',16,'BMS','SpallsinaSpan');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('GirderCondition','BMS.GirderCondition','SpallLocCnt','GirderCondition',17,'BMS','SpallLocCnt');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('GirderCondition','BMS.GirderCondition','CorrdExposedBarsCnt','GirderCondition',18,'BMS','CorrdExposedBarsCnt');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('GirderCondition','BMS.GirderCondition','PercCorr','GirderCondition',19,'BMS','PercCorr');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('GirderCondition','BMS.GirderCondition','GirderCondSev','GirderCondition',20,'BMS','GirderCondSev');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('GirderCondition','BMS.GirderCondition','GirderCondExt','GirderCondition',21,'BMS','GirderCondExt');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('GirderCondition','BMS.GirderCondition','MetallicSoundLocCnt','GirderCondition',23,'BMS','MetallicSoundLocCnt');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('GirderCondition','BMS.GirderCondition','HallowSoundLocCnt','GirderCondition',24,'BMS','HallowSoundLocCnt');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('GirderCondition','BMS.GirderCondition','IsConcreteSpalling','GirderCondition',25,'BMS','IsConcreteSpalling');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('GirderCondition','BMS.GirderCondition','SpallingDepth','GirderCondition',26,'BMS','SpallingDepth');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('GirderCondition','BMS.GirderCondition','IsCracked','GirderCondition',27,'BMS','IsCracked');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('GirderCondition','BMS.GirderCondition','CrackPerc','GirderCondition',28,'BMS','CrackPerc');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('GirderCondition','BMS.GirderCondition','CrackFoundSection','GirderCondition',29,'BMS','CrackFoundSection');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('GirderCondition','BMS.GirderCondition','PitCorrosion','GirderCondition',30,'BMS','PitCorrosion');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('GirderCondition','BMS.GirderCondition','ModerateDeflect','GirderCondition',31,'BMS','ModerateDeflect');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('GirderCondition','BMS.GirderCondition','ExcessiveDeflect','GirderCondition',32,'BMS','ExcessiveDeflect');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('GirderCondition','BMS.GirderCondition','DmgDesc','GirderCondition',33,'BMS','DmgDesc');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('GirderCondition','BMS.GirderCondition','AnchgCorrEndDegree','GirderCondition',34,'BMS','AnchgCorrEndDegree');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('GirderCondition','BMS.GirderCondition','Remarks','GirderCondition',35,'BMS','Remarks');
|
|
|
|
|
|
delete from TableColumnDef where TableName='CrossGirderCondition'
|
|
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('CrossGirderCondition','BMS.CrossGirderCondition','BridgeCode','CrossGirderCondition',1,'BMS','BridgeCode');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('CrossGirderCondition','BMS.CrossGirderCondition','SurveyYear','CrossGirderCondition',2,'BMS','SurveyYear');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('CrossGirderCondition','BMS.CrossGirderCondition','SpanNo','CrossGirderCondition',3,'BMS','SpanNo');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('CrossGirderCondition','BMS.CrossGirderCondition','CrckType','CrossGirderCondition',4,'BMS','CrckType');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('CrossGirderCondition','BMS.CrossGirderCondition','CrckLength','CrossGirderCondition',5,'BMS','CrckLength');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('CrossGirderCondition','BMS.CrossGirderCondition','CrckWidth','CrossGirderCondition',6,'BMS','CrckWidth');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('CrossGirderCondition','BMS.CrossGirderCondition','NoofBarsExposed','CrossGirderCondition',7,'BMS','NoofBarsExposed');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('CrossGirderCondition','BMS.CrossGirderCondition','ReinfrcCorr','CrossGirderCondition',8,'BMS','ReinfrcCorr');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('CrossGirderCondition','BMS.CrossGirderCondition','LocationofCorrosion','CrossGirderCondition',9,'BMS','LocationofCorrosion');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('CrossGirderCondition','BMS.CrossGirderCondition','MetallicSoundLocCnt','CrossGirderCondition',11,'BMS','MetallicSoundLocCnt');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('CrossGirderCondition','BMS.CrossGirderCondition','HallowSoundLocCnt','CrossGirderCondition',12,'BMS','HallowSoundLocCnt');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('CrossGirderCondition','BMS.CrossGirderCondition','IsConcreteSpalling','CrossGirderCondition',13,'BMS','IsConcreteSpalling');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('CrossGirderCondition','BMS.CrossGirderCondition','NumberofSpalls','CrossGirderCondition',14,'BMS','NumberofSpalls');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('CrossGirderCondition','BMS.CrossGirderCondition','SpallingArea','CrossGirderCondition',15,'BMS','SpallingArea');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('CrossGirderCondition','BMS.CrossGirderCondition','SpallingDepth','CrossGirderCondition',16,'BMS','SpallingDepth');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('CrossGirderCondition','BMS.CrossGirderCondition','EffectedLocCnt','CrossGirderCondition',17,'BMS','EffectedLocCnt');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('CrossGirderCondition','BMS.CrossGirderCondition','IsCracked','CrossGirderCondition',18,'BMS','IsCracked');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('CrossGirderCondition','BMS.CrossGirderCondition','CrackPerc','CrossGirderCondition',19,'BMS','CrackPerc');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('CrossGirderCondition','BMS.CrossGirderCondition','CrackFoundSection','CrossGirderCondition',20,'BMS','CrackFoundSection');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('CrossGirderCondition','BMS.CrossGirderCondition','ExposedReinfLocCnt','CrossGirderCondition',21,'BMS','ExposedReinfLocCnt');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('CrossGirderCondition','BMS.CrossGirderCondition','PitCorrosion','CrossGirderCondition',22,'BMS','PitCorrosion');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('CrossGirderCondition','BMS.CrossGirderCondition','VisibleDeflectionsCnt','CrossGirderCondition',23,'BMS','VisibleDeflectionsCnt');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('CrossGirderCondition','BMS.CrossGirderCondition','ModerateDeflect','CrossGirderCondition',3,'BMS','ModerateDeflect');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('CrossGirderCondition','BMS.CrossGirderCondition','ExcessiveDeflect','CrossGirderCondition',24,'BMS','ExcessiveDeflect');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('CrossGirderCondition','BMS.CrossGirderCondition','CrssPreStressAnchrg','CrossGirderCondition',25,'BMS','CrssPreStressAnchrg');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('CrossGirderCondition','BMS.CrossGirderCondition','NoOfanchordamagedinspan','CrossGirderCondition',26,'BMS','NoOfanchordamagedinspan');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('CrossGirderCondition','BMS.CrossGirderCondition','DamagedAnchrgCnt','CrossGirderCondition',27,'BMS','DamagedAnchrgCnt');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('CrossGirderCondition','BMS.CrossGirderCondition','AnchgCorrEndDegree','CrossGirderCondition',28,'BMS','AnchgCorrEndDegree');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('CrossGirderCondition','BMS.CrossGirderCondition','DescofDmgofDucts','CrossGirderCondition',29,'BMS','DescofDmgofDucts');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('CrossGirderCondition','BMS.CrossGirderCondition','AnchgCorrDegree','CrossGirderCondition',30,'BMS','AnchgCorrDegree');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('CrossGirderCondition','BMS.CrossGirderCondition','InspectedNtMsrd','CrossGirderCondition',31,'BMS','InspectedNtMsrd');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('CrossGirderCondition','BMS.CrossGirderCondition','CrsGirderCondSev','CrossGirderCondition',32,'BMS','CrsGirderCondSev');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('CrossGirderCondition','BMS.CrossGirderCondition','CrsGirderCondExt','CrossGirderCondition',33,'BMS','CrsGirderCondExt');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('CrossGirderCondition','BMS.CrossGirderCondition','Remarks','CrossGirderCondition',34,'BMS','Remarks');
|
|
|
|
|
|
|
|
|
|
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('SuperStructureCond','BMS.SuperStructureCond','BridgeCode','SuperStructureCond',1,'BMS','BridgeCode');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('SuperStructureCond','BMS.SuperStructureCond','SurveyYear','SuperStructureCond',3,'BMS','SurveyYear');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('SuperStructureCond','BMS.SuperStructureCond','SpanNo','SuperStructureCond',4,'BMS','SpanNo');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('SuperStructureCond','BMS.SuperStructureCond','ConnectionType','SuperStructureCond',5,'BMS','ConnectionType');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('SuperStructureCond','BMS.SuperStructureCond','ConnectionCond','SuperStructureCond',6,'BMS','ConnectionCond');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('SuperStructureCond','BMS.SuperStructureCond','PaintCond','SuperStructureCond',7,'BMS','PaintCond');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('SuperStructureCond','BMS.SuperStructureCond','SteelMemCond','SuperStructureCond',8,'BMS','SteelMemCond');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('SuperStructureCond','BMS.SuperStructureCond','Dimsteelmem','SuperStructureCond',9,'BMS','Dimsteelmem');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('SuperStructureCond','BMS.SuperStructureCond','Corrosion','SuperStructureCond',10,'BMS','Corrosion');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('SuperStructureCond','BMS.SuperStructureCond','CorrReinfrc','SuperStructureCond',11,'BMS','CorrReinfrc');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('SuperStructureCond','BMS.SuperStructureCond','ExposedReinfLocCnt','SuperStructureCond',12,'BMS','ExposedReinfLocCnt');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('SuperStructureCond','BMS.SuperStructureCond','CorrReinfrcLoc','SuperStructureCond',13,'BMS','CorrReinfrcLoc');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('SuperStructureCond','BMS.SuperStructureCond','PercOfCorr','SuperStructureCond',14,'BMS','PercOfCorr');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('SuperStructureCond','BMS.SuperStructureCond','PitCorrosion','SuperStructureCond',15,'BMS','PitCorrosion');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('SuperStructureCond','BMS.SuperStructureCond','VisibleDeflectionsCnt','SuperStructureCond',16,'BMS','VisibleDeflectionsCnt');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('SuperStructureCond','BMS.SuperStructureCond','ModerateDeflect','SuperStructureCond',17,'BMS','ModerateDeflect');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('SuperStructureCond','BMS.SuperStructureCond','ExcessiveDeflect','SuperStructureCond',18,'BMS','ExcessiveDeflect');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('SuperStructureCond','BMS.SuperStructureCond','InspectedNtMsrd','SuperStructureCond',19,'BMS','InspectedNtMsrd');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('SuperStructureCond','BMS.SuperStructureCond','SupStuctrCondSev','SuperStructureCond',20,'BMS','SupStuctrCondSev');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('SuperStructureCond','BMS.SuperStructureCond','SupStuctrCondExt','SuperStructureCond',21,'BMS','SupStuctrCondExt');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('SuperStructureCond','BMS.SuperStructureCond','LseJntCnt','SuperStructureCond',22,'BMS','LseJntCnt');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('SuperStructureCond','BMS.SuperStructureCond','MtrlLsJntCnt','SuperStructureCond',23,'BMS','MtrlLsJntCnt');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('SuperStructureCond','BMS.SuperStructureCond','LseStonesLocCnt','SuperStructureCond',24,'BMS','LseStonesLocCnt');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('SuperStructureCond','BMS.SuperStructureCond','PlstrCond','SuperStructureCond',25,'BMS','PlstrCond');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('SuperStructureCond','BMS.SuperStructureCond','SpiltLocCnt','SuperStructureCond',26,'BMS','SpiltLocCnt');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('SuperStructureCond','BMS.SuperStructureCond','VegGrwJnt','SuperStructureCond',27,'BMS','VegGrwJnt');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('SuperStructureCond','BMS.SuperStructureCond','MsnrArchInspectedNtMsrd','SuperStructureCond',28,'BMS','MsnrArchInspectedNtMsrd');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('SuperStructureCond','BMS.SuperStructureCond','MsnrArchCondSev','SuperStructureCond',29,'BMS','MsnrArchCondSev');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('SuperStructureCond','BMS.SuperStructureCond','MsnrArchCondExt','SuperStructureCond',30,'BMS','MsnrArchCondExt');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('SuperStructureCond','BMS.SuperStructureCond','DSDrngSpoutsCondSev','SuperStructureCond',31,'BMS','DSDrngSpoutsCondSev');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('SuperStructureCond','BMS.SuperStructureCond','DSDrngSpoutsCondExt','SuperStructureCond',32,'BMS','DSDrngSpoutsCondExt');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('SuperStructureCond','BMS.SuperStructureCond','DSFPCondSev','SuperStructureCond',33,'BMS','DSFPCondSev');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('SuperStructureCond','BMS.SuperStructureCond','DSFPCondExt','SuperStructureCond',34,'BMS','DSFPCondExt');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('SuperStructureCond','BMS.SuperStructureCond','DSRailDmgdLen','SuperStructureCond',35,'BMS','DSRailDmgdLen');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('SuperStructureCond','BMS.SuperStructureCond','DSRailCondSev','SuperStructureCond',36,'BMS','DSRailCondSev');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('SuperStructureCond','BMS.SuperStructureCond','DSRailCondExt','SuperStructureCond',37,'BMS','DSRailCondExt');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('SuperStructureCond','BMS.SuperStructureCond','DSCrckArea','SuperStructureCond',38,'BMS','DSCrckArea');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('SuperStructureCond','BMS.SuperStructureCond','DeprsnArea','SuperStructureCond',39,'BMS','DeprsnArea');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('SuperStructureCond','BMS.SuperStructureCond','PotArea','SuperStructureCond',40,'BMS','PotArea');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('SuperStructureCond','BMS.SuperStructureCond','DSSrvcLnDmgd','SuperStructureCond',41,'BMS','DSSrvcLnDmgd');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('SuperStructureCond','BMS.SuperStructureCond','DSSrvcLnCondSev','SuperStructureCond',42,'BMS','DSSrvcLnCondSev');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('SuperStructureCond','BMS.SuperStructureCond','DSSrvcLnCondExt','SuperStructureCond',43,'BMS','DSSrvcLnCondExt');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('SuperStructureCond','BMS.SuperStructureCond','Remarks','SuperStructureCond',44,'BMS','Remarks');
|
|
|
|
|
|
|
|
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('PipeCond','BMS.PipeCond','BridgeCode','PipeCond',1,'BMS','BridgeCode');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('PipeCond','BMS.PipeCond','SurveyYear','PipeCond',3,'BMS','SurveyYear');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('PipeCond','BMS.PipeCond','PipeCond','PipeCond',4,'BMS','PipeCond');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('PipeCond','BMS.PipeCond','PipeCondSev','PipeCond',5,'BMS','PipeCondSev');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('PipeCond','BMS.PipeCond','PipeCondExt','PipeCond',6,'BMS','PipeCondExt');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('PipeCond','BMS.PipeCond','HWPartialCollapse','PipeCond',7,'BMS','HWPartialCollapse');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('PipeCond','BMS.PipeCond','IsSpalling','PipeCond',8,'BMS','IsSpalling');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('PipeCond','BMS.PipeCond','SpallingArea','PipeCond',9,'BMS','SpallingArea');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('PipeCond','BMS.PipeCond','SpallingLocCnt','PipeCond',10,'BMS','SpallingLocCnt');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('PipeCond','BMS.PipeCond','CorrReinfrc','PipeCond',11,'BMS','CorrReinfrc');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('PipeCond','BMS.PipeCond','CorrExposedDtls','PipeCond',12,'BMS','CorrExposedDtls');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('PipeCond','BMS.PipeCond','LseJntCnt','PipeCond',13,'BMS','LseJntCnt');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('PipeCond','BMS.PipeCond','MtrlLsJntCnt','PipeCond',14,'BMS','MtrlLsJntCnt');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('PipeCond','BMS.PipeCond','LseStonesLocCnt','PipeCond',15,'BMS','LseStonesLocCnt');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('PipeCond','BMS.PipeCond','PlstrCond','PipeCond',16,'BMS','PlstrCond');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('PipeCond','BMS.PipeCond','SpiltLocCnt','PipeCond',17,'BMS','SpiltLocCnt');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('PipeCond','BMS.PipeCond','VegJnts','PipeCond',18,'BMS','VegJnts');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('PipeCond','BMS.PipeCond','InspectedNtMsrd','PipeCond',19,'BMS','InspectedNtMsrd');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('PipeCond','BMS.PipeCond','OvrlPipeCondSev','PipeCond',20,'BMS','OvrlPipeCondSev');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('PipeCond','BMS.PipeCond','OvrlPipeCondExt','PipeCond',21,'BMS','OvrlPipeCondExt');
|
|
INSERT INTO TableColumnDef(TableName,TableNameDescription,DBColumnName,Caption,Seq, SchemaName,ExcelCaption)
|
|
VALUES('PipeCond','BMS.PipeCond','Remarks','PipeCond',22,'BMS','Remarks');
|
|
|