oa数据库字段对照表.doc

CREATE TABLE [dbo].[clientinfo]( [ID] [int] IDENTITY(1,1) NOT NULL, [name] [nvarchar](50) NOT NULL,用户名 [company] [nvarchar](50) NOT NULL,企业 [address] [nvarchar](50) NULL,地址 [project] [nvarchar](50) NULL CONSTRAINT [DF_clientinfo_project] DEFAULT (N空),项目 [tel] [nvarchar](50) NULL CONSTRAINT [DF_clientinfo_tel] DEFAULT (N空),电话 [callno] [nvarchar](50) NULL CONSTRAINT [DF_clientinfo_callno] DEFAULT (N空), [handset] [nvarchar](50) NULL CONSTRAINT [DF_clientinfo_handset] DEFAULT (N空), [fax] [nvarchar](50) NULL CONSTRAINT [DF_clientinfo_fax] DEFAULT (N空), [remark] [nvarchar](250) NULL CONSTRAINT [DF_clientinfo_remark] DEFAULT (N空), [email] [nvarchar](50) NULL CONSTRAINT [DF_clientinfo_email] DEFAULT (N空),邮箱 [postcard] [nvarchar](50) NULL CONSTRAINT [DF_clientinfo_postcard] DEFAULT (N空),邮编 [dept] [nvarchar](50) NULL CONSTRAINT [DF_clientinfo_dept] DEFAULT (N空), [sex] [nvarchar](50) NULL CONSTRAINT [DF_clientinfo_sex] DEFAULT (N空),性别 [position] [nvarchar](50) NULL CONSTRAINT [DF_clientinfo_position] DEFAULT (N空),部门 [lsuserid] [int] NULL CONSTRAINT [DF_clientinf_lsuserid] DEFAULT (0) ) ON [PRIMARY] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Directory]( [DirID] [int] IDENTITY(1,1) NOT NULL,目录ID [Name] [varchar](200) NULL,目录名 [ParentID] [int] NULL,上级目录ID [Contain] [int] NULL,文件大小 [FileCount] [int] NULL,文件总数 [DirCount] [int] NULL,目录数 [Flag] [bit] NULL, [CreateDate] [datetime] NULL,时间 [UsersID] [int] NULL用户ID ) ON [PRIMARY] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[forum](论坛表 [id] [int] IDENTITY(1,1) NOT NULL, [jd_name] [nvarchar](50) NULL, [jd_style] [nvarchar](50) NULL, [jd_top] [nvarchar](255) NULL, [jd_cls] [int] NULL, [jd_order] [int] NULL, [jd_bg] [nvarchar](255) NULL, [jd_ad] [nvarchar](255) NULL, [jd_rz] [nvarchar](250) NULL, [jd_upfilename] [nvarchar](50) NULL, [jd_fview] [int] NULL, [jd_liststyle] [int] NULL, [jd_height] [nvarchar](4) NULL, [jd_color] [nvarc