USE [YJ]
GO
/****** Object: Table [dbo].[T_OA_WDSTORE] Script Date: 04/16/2014 00:23:38 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[T_OA_WDSTORE](
[WDBH] [nvarchar](50) NOT NULL,
[APPBH] [nvarchar](50) NOT NULL,
[WDMC] [nvarchar](500) NOT NULL,
[WDLX] [nvarchar](50) NULL,
[WDSX] [nvarchar](50) NULL,
[WDDX] [nvarchar](50) NULL,
[WDYYR] [nvarchar](50) NULL,
[WDZT] [int] NULL,
[WDMS] [nvarchar](500) NULL,
[WDZZ] [nvarchar](50) NULL,
[WDLJ] [nvarchar](500) NULL,
[SYSTEMID] [nvarchar](50) NULL,
[WDBT] [nvarchar](200) NULL,
[DQBB] [decimal](9, 0) NULL,
[WDHZ] [nvarchar](50) NULL,
[CJSJ] [datetime] NULL,
[CJR] [nvarchar](50) NULL,
[XGSJ] [datetime] NULL,
[XGR] [nvarchar](50) NULL,
[ORGID] [nvarchar](20) NULL,
[SFZSGW] [char](1) NULL,
[MINORSID] [varchar](50) NULL,
CONSTRAINT [PK_T_OA_WDSTORE] PRIMARY KEY CLUSTERED
(
[WDBH] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
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'T_OA_WDSTORE', @level2type=N'COLUMN',@level2name=N'WDBH'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'应用程序组号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_OA_WDSTORE', @level2type=N'COLUMN',@level2name=N'APPBH'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'文档名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_OA_WDSTORE', @level2type=N'COLUMN',@level2name=N'WDMC'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'文档类型' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_OA_WDSTORE', @level2type=N'COLUMN',@level2name=N'WDLX'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'文档属性' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_OA_WDSTORE', @level2type=N'COLUMN',@level2name=N'WDSX'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'文档大小' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_OA_WDSTORE', @level2type=N'COLUMN',@level2name=N'WDDX'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'文档拥有人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_OA_WDSTORE', @level2type=N'COLUMN',@level2name=N'WDYYR'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'文档状态' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_OA_WDSTORE', @level2type=N'COLUMN',@level2name=N'WDZT'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'文档描述' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_OA_WDSTORE', @level2type=N'COLUMN',@level2name=N'WDMS'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'文档作者' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_OA_WDSTORE', @level2type=N'COLUMN',@level2name=N'WDZZ'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'文档路径' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_OA_WDSTORE', @level2type=N'COLUMN',@level2name=N'WDLJ'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'文档标题' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_OA_WDSTORE', @level2type=N'COLUMN',@level2name=N'WDBT'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'文档版本号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_OA_WDSTORE', @level2type=N'COLUMN',@level2name=N'DQBB'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'文档后缀' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_OA_WDSTORE', @level2type=N'COLUMN',@level2name=N'WDHZ'
GO
INSERT [dbo].[T_OA_WDSTORE] ([WDBH], [APPBH], [WDMC], [WDLX], [WDSX], [WDDX], [WDYYR], [WDZT], [WDMS], [WDZZ], [WDLJ], [SYSTEMID], [WDBT], [DQBB], [WDHZ], [CJSJ], [CJR], [XGSJ], [XGR], [ORGID], [SFZSGW], [MINORSID]) VALUES (N'20501583908163', N'20489514508208', N'539关于开展阳江市江城区对岸国家一级渔港建设项目环境影响评价的请示.doc', N'application/octet-stream', N'FWDJ', N'36 KB', NULL, 0, NULL, N'/yj', N'/UPLOAD_FILE/zhbg/FWDJ/20501583908163.doc', N'ebcmyj', N'20501583908163.doc', NULL, N'doc', CAST(0x0000A30D00D1D75E AS DateTime), N'陈镘如', CAST(0x0000A30D00D1D75E AS DateTime), N'陈镘如', N'441700', NULL, NULL)
INSERT [dbo].[T_OA_WDSTORE] ([WDBH], [APPBH], [WDMC], [WDLX], [WDSX], [WDDX], [WDYYR], [WDZT], [WDMS], [WDZZ], [WDLJ], [SYSTEMID], [WDBT], [DQBB], [WDHZ], [CJSJ], [CJR], [XGSJ], [XGR], [ORGID], [SFZSGW], [MINORSID]) VALUES (N'20501583908163sg', N'20489514508208', N'539关于开展阳江市江城区对岸国家一级渔港建设项目环境影响评价的请示(修改).doc', N'application/octet-stream', N'FWDJ', N'0KB', NULL, 0, NULL, N'/yj', N'/UPLOAD_FILE/zhbg/FWDJ/fwg/20501583908163sg.doc', N'ebcmyj', N'20501583908163sg.doc', NULL, N'doc', CAST(0x0000A30D00E065F1 AS DateTime), N'陈镘如', CAST(0x0000A30D00E065F1 AS DateTime), N'陈镘如', N'441700', NULL, NULL)
INSERT [dbo].[T_OA_WDSTORE] ([WDBH], [APPBH], [WDMC], [WDLX], [WDSX], [WDDX], [WDYYR], [WDZT], [WDMS], [WDZZ], [WDLJ], [SYSTEMID], [WDBT], [DQBB], [WDHZ], [CJSJ], [CJR], [XGSJ], [XGR], [ORGID], [SFZSGW], [MINORSID]) VALUES (N'20501583908163sgdg', N'20489514508208', N'539关于开展阳江市江城区对岸国家一级渔港建设项目环境影响评价的请示(成文).doc', N'application/octet-stream', N'FWDJ', N'0KB', NULL, 0, NULL, N'/yj', N'/UPLOAD_FILE/zhbg/FWDJ/fwg/20501583908163sgdg.doc', N'ebcmyj', N'20501583908163sgdg.doc', NULL, N'doc', CAST(0x0000A30D00E21A1A AS DateTime), N'林巾茹', CAST(0x0000A30D00E21A1A AS DateTime), N'林巾茹', N'441700', NULL, NULL)
INSERT [dbo].[T_OA_WDSTORE] ([WDBH], [APPBH], [WDMC], [WDLX], [WDSX], [WDDX], [WDYYR], [WDZT], [WDMS], [WDZZ], [WDLJ], [SYSTEMID], [WDBT], [DQBB], [WDHZ], [CJSJ], [CJR], [XGSJ], [XGR], [ORGID], [SFZSGW], [MINORSID]) VALUES (N'20501583908163sgdgsd', N'20489514508208', N'539关于开展阳江市江城区对岸国家一级渔港建设项目环境影响评价的请示(校对).doc', N'application/octet-stream', N'FWDJ', N'37376KB', NULL, 0, NULL, N'/yj', N'/UPLOAD_FILE/zhbg/FWDJ/fwg/20501583908163sgdgsd.doc', N'ebcmyj', N'20501583908163sgdgsd.doc', NULL, N'doc', CAST(0x0000A30D00E31FE0 AS DateTime), N'陈镘如', CAST(0x0000A30D00E3578F AS DateTime), N'陈镘如', N'441700', NULL, NULL)
INSERT [dbo].[T_OA_WDSTORE] ([WDBH], [APPBH], [WDMC], [WDLX], [WDSX], [WDDX], [WDYYR], [WDZT], [WDMS], [WDZZ], [WDLJ], [SYSTEMID], [WDBT], [DQBB], [WDHZ], [CJSJ], [CJR], [XGSJ], [XGR], [ORGID], [SFZSGW], [MINORSID]) VALUES (N'20762443673794', N'20742469511427', N'问题.docx', N'application/octet-stream', N'LWDJ', N'287 KB', NULL, 0, NULL, N'/yj', N'/UPLOAD_FILE/zhbg/LWDJ/20762443673794.docx', N'ebcmyj', N'20762443673794.docx', NULL, N'docx', CAST(0x0000A30D00D30912 AS DateTime), N'陈镘如', CAST(0x0000A30D00D30912 AS DateTime), N'陈镘如', N'441700', NULL, NULL)
INSERT [dbo].[T_OA_WDSTORE] ([WDBH], [APPBH], [WDMC], [WDLX], [WDSX], [WDDX], [WDYYR], [WDZT], [WDMS], [WDZZ], [WDLJ], [SYSTEMID], [WDBT], [DQBB], [WDHZ], [CJSJ], [CJR], [XGSJ], [XGR], [ORGID], [SFZSGW], [MINORSID]) VALUES (N'20803370358089', N'20742469511427', N'dss.doc', N'application/octet-stream', N'LWDJ', N'4 MB', NULL, 0, NULL, N'/yj', N'/UPLOAD_FILE/zhbg/LWDJ/20803370358089.doc', N'ebcmyj', N'20803370358089.doc', NULL, N'doc', CAST(0x0000A30D00D33908 AS DateTime), N'陈镘如', CAST(0x0000A30D00D33908 AS DateTime), N'陈镘如', N'441700', NULL, NULL)
INSERT [dbo].[T_OA_WDSTORE] ([WDBH], [APPBH], [WDMC], [WDLX], [WDSX], [WDDX], [WDYYR], [WDZT], [WDMS], [WDZZ], [WDLJ], [SYSTEMID], [WDBT], [DQBB], [WDHZ], [CJSJ], [CJR], [XGSJ], [XGR], [ORGID], [SFZSGW], [MINORSID]) VALUES (N'24779144486036', N'24763909876570', N'esb.doc', N'application/octet-stream', N'FWDJ', N'18 MB', NULL, 0, NULL, N'/yj', N'/UPLOAD_FILE/zhbg/FWDJ/24779144486036.doc', N'ebcmyj', N'24779144486036.doc', NULL, N'doc', CAST(0x0000A30D00E56C48 AS DateTime), N'林杰喜', CAST(0x0000A30D00E56C48 AS DateTime), N'林杰喜', N'441700', NULL, NULL)
INSERT [dbo].[T_OA_WDSTORE] ([WDBH], [APPBH], [WDMC], [WDLX], [WDSX], [WDDX], [WDYYR], [WDZT], [WDMS], [WDZZ], [WDLJ], [SYSTEMID], [WDBT], [DQBB], [WDHZ], [CJSJ], [CJR], [XGSJ], [XGR], [ORGID], [SFZSGW], [MINORSID]) VALUES (N'25794954173490', N'25775845090648', N'dss.doc', N'application/octet-stream', N'FWDJ', N'4 MB', NULL, 0, NULL, N'/yj', N'/UPLOAD_FILE/zhbg/FWDJ/25794954173490.doc', N'ebcmyj', N'25794954173490.doc', NULL, N'doc', CAST(0x0000A30D00EA12B5 AS DateTime), N'林杰喜', CAST(0x0000A30D00EA12B5 AS DateTime), N'林杰喜', N'441700', NULL, NULL)
INSERT [dbo].[T_OA_WDSTORE] ([WDBH], [APPBH], [WDMC], [WDLX], [WDSX], [WDDX], [WDYYR], [WDZT], [WDMS], [WDZZ], [WDLJ], [SYSTEMID], [WDBT], [DQBB], [WDHZ], [CJSJ], [CJR], [XGSJ], [XGR], [ORGID], [SFZSGW], [MINORSID]) VALUES (N'28123795556808', N'28098557269222', N'问题.docx', N'application/octet-stream', N'LWDJ', N'287 KB', NULL, 0, NULL, N'/yj', N'/UPLOAD_FILE/zhbg/LWDJ/28123795556808.docx', N'ebcmyj', N'28123795556808.docx', NULL, N'docx', CAST(0x0000A30D00F4BBE3 AS DateTime), N'陈镘如', CAST(0x0000A30D00F4BBE3 AS DateTime), N'陈镘如', N'441700', NULL, NULL)
INSERT [dbo].[T_OA_WDSTORE] ([WDBH], [APPBH], [WDMC], [WDLX], [WDSX], [WDDX], [WDYYR], [WDZT], [WDMS], [WDZZ], [WDLJ], [SYSTEMID], [WDBT], [DQBB], [WDHZ], [CJSJ], [CJR], [XGSJ], [XGR], [ORGID], [SFZSGW], [MINORSID]) VALUES (N'28169073586096', N'28153892823717', N'新建 Microsoft Word Document.docx', N'application/octet-stream', N'FWDJ', N'381 KB', NULL, 0, NULL, N'/yj', N'/UPLOAD_FILE/zhbg/FWDJ/28169073586096.docx', N'ebcmyj', N'28169073586096.docx', NULL, N'docx', CAST(0x0000A30D00F4F0F3 AS DateTime), N'陈镘如', CAST(0x0000A30D00F4F0F3 AS DateTime), N'陈镘如', N'441700', NULL, NULL)
INSERT [dbo].[T_OA_WDSTORE] ([WDBH], [APPBH], [WDMC], [WDLX], [WDSX], [WDDX], [WDYYR], [WDZT], [WDMS], [WDZZ], [WDLJ], [SYSTEMID], [WDBT], [DQBB], [WDHZ], [CJSJ], [CJR], [XGSJ], [XGR], [ORGID], [SFZSGW], [MINORSID]) VALUES (N'344989238435027', N'344881302319591', N'关于开展排污权有偿使用和交易试点改革近期工作情况的报告.wps', N'application/octet-stream', N'FWDJ', N'15 KB', NULL, 0, NULL, N'/yj', N'/UPLOAD_FILE/zhbg/FWDJ/344989238435027.wps', N'ebcmyj', N'344989238435027.wps', NULL, N'wps', CAST(0x0000A30D010654DA AS DateTime), N'吴成恩', CAST(0x0000A30D010654DA AS DateTime), N'吴成恩', N'441700', NULL, NULL)
INSERT [dbo].[T_OA_WDSTORE] ([WDBH], [APPBH], [WDMC], [WDLX], [WDSX], [WDDX], [WDYYR], [WDZT], [WDMS], [WDZZ], [WDLJ], [SYSTEMID], [WDBT], [DQBB], [WDHZ], [CJSJ], [CJR], [XGSJ], [XGR], [ORGID], [SFZSGW], [MINORSID]) VALUES (N'345829659410321', N'345778563567721', N'阳环函〔2014〕71号关于提供推动滨海新区建设的实施意见的复函.doc', N'application/octet-stream', N'FWDJ', N'20 KB', NULL, 0, NULL, N'/yj', N'/UPLOAD_FILE/zhbg/FWDJ/345829659410321.doc', N'ebcmyj', N'345829659410321.doc', NULL, N'doc', CAST(0x0000A30D010A2DA5 AS DateTime), N'张文琦', CAST(0x0000A30D010A2DA5 AS DateTime), N'张文琦', N'441700', NULL, NULL)
INSERT [dbo].[T_OA_WDSTORE] ([WDBH], [APPBH], [WDMC], [WDLX], [WDSX], [WDDX], [WDYYR], [WDZT], [WDMS], [WDZZ], [WDLJ], [SYSTEMID], [WDBT], [DQBB], [WDHZ], [CJSJ], [CJR], [XGSJ], [XGR], [ORGID], [SFZSGW], [MINORSID]) VALUES (N'345829659410321sg', N'345778563567721', N'阳环函〔2014〕71号关于提供推动滨海新区建设的实施意见的复函(修改).doc', N'application/octet-stream', N'FWDJ', N'24064KB', NULL, 0, NULL, N'/yj', N'/UPLOAD_FILE/zhbg/FWDJ/fwg/345829659410321sg.doc', N'ebcmyj', N'345829659410321sg.doc', NULL, N'doc', CAST(0x0000A30D010E9D10 AS DateTime), N'林良开', CAST(0x0000A30E00ACD2B7 AS DateTime), N'关少平', N'41700', NULL, NULL)
INSERT [dbo].[T_OA_WDSTORE] ([WDBH], [APPBH], [WDMC], [WDLX], [WDSX], [WDDX], [WDYYR], [WDZT], [WDMS], [WDZZ], [WDLJ], [SYSTEMID], [WDBT], [DQBB], [WDHZ], [CJSJ], [CJR], [XGSJ], [XGR], [ORGID], [SFZSGW], [MINORSID]) VALUES (N'430175500443659', N'430044033903992', N'转发省环境保护厅 省财政厅关于印发广东省排污权有偿使用和交易试点管理办法的通知（会签文）.doc', N'application/octet-stream', N'FWDJ', N'14 KB', NULL, 0, NULL, N'/yj', N'/UPLOAD_FILE/zhbg/FWDJ/430175500443659.doc', N'ebcmyj', N'430175500443659.doc', NULL, N'doc', CAST(0x0000A30E0100C860 AS DateTime), N'张文琦', CAST(0x0000A30E0100C860 AS DateTime), N'张文琦', N'441700', NULL, NULL)
INSERT [dbo].[T_OA_WDSTORE] ([WDBH], [APPBH], [WDMC], [WDLX], [WDSX], [WDDX], [WDYYR], [WDZT], [WDMS], [WDZZ], [WDLJ], [SYSTEMID], [WDBT], [DQBB], [WDHZ], [CJSJ], [CJR], [XGSJ], [XGR], [ORGID], [SFZSGW], [MINORSID]) VALUES (N'430175500443659sg', N'430044033903992', N'转发省环境保护厅 省财政厅关于印发广东省排污权有偿使用和交易试点管理办法的通知（会签文）(修改).doc', N'application/octet-stream', N'FWDJ', N'30208KB', NULL, 0, NULL, N'/yj', N'/UPLOAD_FILE/zhbg/FWDJ/fwg/430175500443659sg.doc', N'ebcmyj', N'430175500443659sg.doc', NULL, N'doc', CAST(0x0000A30E01034C38 AS DateTime), N'张文琦', CAST(0x0000A30E012116E4 AS DateTime), N'林杰喜', N'441700', NULL, NULL)
INSERT [dbo].[T_OA_WDSTORE] ([WDBH], [APPBH], [WDMC], [WDLX], [WDSX], [WDDX], [WDYYR], [WDZT], [WDMS], [WDZZ], [WDLJ], [SYSTEMID], [WDBT], [DQBB], [WDHZ], [CJSJ], [CJR], [XGSJ], [XGR], [ORGID], [SFZSGW], [MINORSID]) VALUES (N'430277156755258', N'430044033903992', N'广东省环境保护厅 广东省财政厅关于印发广东省排污权有偿使用和交易试点管理办法的通知（粤环[2014]21号）.pdf', N'application/octet-stream', N'FWDJ', N'2 MB', NULL, 0, NULL, N'/yj', N'/UPLOAD_FILE/zhbg/FWDJ/430277156755258.pdf', N'ebcmyj', N'430277156755258.pdf', NULL, N'pdf', CAST(0x0000A30E01013F68 AS DateTime), N'张文琦', CAST(0x0000A30E01013F68 AS DateTime), N'张文琦', N'441700', NULL, NULL)
