lyfz_repos/经典版源码/document/数据库表脚本/dindan字段注释.sql


// 为每个字段生成注释
GO
SET ANSI_PADDING OFF
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'订单号' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'id'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'money1' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'money1'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'money2' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'money2'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'加挑金额(选片)' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'money3'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'男宾/家长' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'name1'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'女宾/宝宝' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'name2'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'套系ID' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'taoxiid'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'套系名' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'taoxiname'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'套系价格' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'taoxijiage'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'套系张数:入底\入册' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'taoxizs'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'预约时间' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'time1'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'拍照日期' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'time2'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'婚庆时间' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'time3'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'开单人部门' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'bm'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'开单人' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'ren'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'折扣' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'discount'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'预约收款' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'payed1'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'payed2' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'payed2'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'payed3' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'payed3'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'后期实际收款' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'payed4'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'全部实际收款' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'payed5'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'选片日期' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'time4'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'取件日期' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'time5'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'拍摄张数' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'takezs'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'加挑张数' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'choosezs'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'拍照状态' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'status'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'外景' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'clothescount2'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'内景' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'outside2'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'喜爱格调' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'style'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'payed3time' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'payed3time'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'payed4ren' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'payed4ren'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'payed4time' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'payed4time'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'选片状态' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'status2'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'取件状态' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'status3'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'摄影师' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'waiter1'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'化妆师' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'waiter2'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'选片师' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'waiter3'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'设计师' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'waiter4'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'备注' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'bz'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'拍照时间' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'taketime'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'服装套数' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'clothescount'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'造型' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'outside'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'看设计备注' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'bz2'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'bz3' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'bz3'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'加急状态' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'urgent'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'初修状态' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'status4'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'设计状态' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'status5'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'初修师' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'waiter5'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'接单人' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'waiter6'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'姓名1拼音' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'pinyin1'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'姓名2拼音' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'pinyin2'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'精修师' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'waiter7'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'精修状态' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'status6'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'电话1' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'phone1'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'电话2' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'phone2'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'刻录状态' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'status7'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'memberno' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'memberno'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'看设计人' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'waiter8'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'看样日期' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'time6'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'看设计状态' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'status8'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'刻录次数' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'bruncount'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'tichenren1' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'tichenren1'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'tichenren2' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'tichenren2'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'tichenren3' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'tichenren3'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'tichenren4' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'tichenren4'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'tichenren5' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'tichenren5'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'send1' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'send1'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'send2' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'send2'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'send3' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'send3'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'选片时间' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'datetime4'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'取件时间' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'datetime5'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'看样时间' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'datetime6'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'摄影师助理' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'waiter12'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'化妆师助理' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'waiter22'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'waiter1rate' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'waiter1rate'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'waiter2rate' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'waiter2rate'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'waiter13' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'waiter13'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'waiter14' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'waiter14'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'waiter23' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'waiter23'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'waiter24' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'waiter24'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'waiter12rate' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'waiter12rate'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'waiter13rate' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'waiter13rate'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'waiter14rate' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'waiter14rate'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'waiter22rate' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'waiter22rate'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'waiter23rate' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'waiter23rate'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'waiter24rate' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'waiter24rate'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'ren2' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'ren2'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'renrate' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'renrate'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'ren2rate' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'ren2rate'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'套系类别名称' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'txtype'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'选片删除的相片' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'delphotos'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'growthtxselname' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'growthtxselname'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'选样删除的相片' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'delphotos2'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'designno' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'designno'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'designreplaceno' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'designreplaceno'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'size' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'size'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'dindantype' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'dindantype'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'contractno1' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'contractno1'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'contractno2' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'contractno2'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'cfno' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'cfno'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'calldate' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'calldate'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'客户来源' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'from'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'reason' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'reason'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'time7' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'time7'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'初修日期' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'time8'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'精修时间' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'time9'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'设计时间' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'time10'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'授权' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'authorize'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'折扣后' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'discount2'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'授权后' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'authorize2'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'bz4' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'bz4'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'接待满意度' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'satisfaction1'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'化妆满意度' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'satisfaction2'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'摄影满意度' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'satisfaction3'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'数码满意度' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'satisfaction4'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'选片满意度' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'satisfaction5'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'进度满意度' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'satisfaction6'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'产品满意度' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'satisfaction7'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'bz5' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'bz5'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'send4' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'send4'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'send5' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'send5'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'waiter9' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'waiter9'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'satisfaction8' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'satisfaction8'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'visitpeople1' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'visitpeople1'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'visitpeople2' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'visitpeople2'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'visitpeople3' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'visitpeople3'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'visitpeople4' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'visitpeople4'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'visitpeople5' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'visitpeople5'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'visitpeople6' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'visitpeople6'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'visitpeople7' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'visitpeople7'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'visitpeople8' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'visitpeople8'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'visittime1' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'visittime1'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'visittime2' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'visittime2'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'visittime3' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'visittime3'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'visittime4' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'visittime4'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'visittime5' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'visittime5'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'visittime6' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'visittime6'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'visittime7' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'visittime7'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'visittime8' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'visittime8'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'相片编号' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'curno'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'录入人' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'xplrr'
GO
EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'录入时间' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'dindan', 
@level2type=N'COLUMN',
@level2name=N'xplrtime'