

alter table dbo.InApproveManager_EquipmentInItem
    add InDate datetime
go

exec sp_addextendedproperty 'MS_Description', N'进场时间', 'SCHEMA', 'dbo', 'TABLE', 'InApproveManager_EquipmentInItem',
     'COLUMN', 'InDate'
go

alter table dbo.InApproveManager_EquipmentInItem
    add EququalityExpireDate datetime
go

exec sp_addextendedproperty 'MS_Description', N'设备资质有效期', 'SCHEMA', 'dbo', 'TABLE',
     'InApproveManager_EquipmentInItem', 'COLUMN', 'EququalityExpireDate'
go

alter table dbo.InApproveManager_EquipmentInItem
    add InsuredAmount decimal
go

exec sp_addextendedproperty 'MS_Description', N'保额', 'SCHEMA', 'dbo', 'TABLE', 'InApproveManager_EquipmentInItem',
     'COLUMN', 'InsuredAmount'
go

alter table dbo.InApproveManager_EquipmentInItem
    add OperatorName nvarchar(50)
go

exec sp_addextendedproperty 'MS_Description', N'操作人员姓名', 'SCHEMA', 'dbo', 'TABLE',
     'InApproveManager_EquipmentInItem', 'COLUMN', 'OperatorName'
go

alter table dbo.InApproveManager_EquipmentInItem
    add OperatorIdentityCard nvarchar(50)
go

exec sp_addextendedproperty 'MS_Description', N'操作人员身份证号', 'SCHEMA', 'dbo', 'TABLE',
     'InApproveManager_EquipmentInItem', 'COLUMN', 'OperatorIdentityCard'
go

alter table dbo.InApproveManager_EquipmentInItem
    add OperatorQualityExpireDate datetime
go

exec sp_addextendedproperty 'MS_Description', N'操作人员资质有效期', 'SCHEMA', 'dbo', 'TABLE',
     'InApproveManager_EquipmentInItem', 'COLUMN', 'OperatorQualityExpireDate'
go

alter table dbo.InApproveManager_EquipmentInItem
    add CertificationDepartment nvarchar(50)
go

exec sp_addextendedproperty 'MS_Description', N'发证部门', 'SCHEMA', 'dbo', 'TABLE', 'InApproveManager_EquipmentInItem',
     'COLUMN', 'CertificationDepartment'
go

alter table dbo.Administrative_CarManager
    add DriverName nvarchar(50)
go
alter table dbo.Administrative_CarManager
    add DriverCode nvarchar(50)
go

alter table dbo.Administrative_CarManager
    add DrivingDate datetime
go


exec sp_addextendedproperty 'MS_Description', N' 姓名', 'SCHEMA', 'dbo', 'TABLE', 'Administrative_CarManager', 'COLUMN',
     'DriverName'
go

exec sp_addextendedproperty 'MS_Description', N'驾驶证号', 'SCHEMA', 'dbo', 'TABLE', 'Administrative_CarManager',
     'COLUMN', 'DriverCode'
go

exec sp_addextendedproperty 'MS_Description', N'发证日期', 'SCHEMA', 'dbo', 'TABLE', 'Administrative_CarManager',
     'COLUMN', 'DrivingDate'
go