36 lines
895 B
Transact-SQL
36 lines
895 B
Transact-SQL
|
|
alter table dbo.DriverSub_DriverSubContact
|
|
add State int
|
|
go
|
|
|
|
exec sp_addextendedproperty 'MS_Description', N'分包状态', 'SCHEMA', 'dbo', 'TABLE', 'DriverSub_DriverSubContact',
|
|
'COLUMN', 'State'
|
|
go
|
|
|
|
|
|
alter table dbo.DriverSub_DriverSub
|
|
add SubContractName nvarchar(100)
|
|
go
|
|
|
|
exec sp_addextendedproperty 'MS_Description', N'开车分包名称', 'SCHEMA', 'dbo', 'TABLE', 'DriverSub_DriverSub',
|
|
'COLUMN', 'SubContractName'
|
|
go
|
|
|
|
alter table dbo.DriverSub_DriverSub
|
|
add DriverContractCode nvarchar(100)
|
|
go
|
|
|
|
exec sp_addextendedproperty 'MS_Description', N'开车合同号', 'SCHEMA', 'dbo', 'TABLE', 'DriverSub_DriverSub', 'COLUMN',
|
|
'DriverContractCode'
|
|
go
|
|
|
|
alter table dbo.DriverSub_DriverSub
|
|
add Evaluator nvarchar(100)
|
|
go
|
|
|
|
exec sp_addextendedproperty 'MS_Description', N'评价人', 'SCHEMA', 'dbo', 'TABLE', 'DriverSub_DriverSub', 'COLUMN',
|
|
'Evaluator'
|
|
go
|
|
|
|
|