⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 appwizard.sql

📁 OA编程 源代码
💻 SQL
📖 第 1 页 / 共 3 页
字号:
🔍
123 
insert into fieldinfo values('硬件方案','所需单位','1','0','225','1','0','','2')
insert into fieldinfo values('硬件方案','书写单位','1','0','225','1','0','','3')
insert into fieldinfo values('硬件方案','方案类型','1','0','100','1','0','','4')
insert into fieldinfo values('硬件方案','书写日期','1','0','100','1','0','','5')
insert into fieldinfo values('硬件方案','存档方式','1','0','100','0','0','','6')
insert into fieldinfo values('硬件方案','源文件','6','0','','0','0','','7')
insert into fieldinfo values('硬件方案','备注','7','0','','0','0','','8')
insert into fieldinfo values('参考方案','所需单位','1','0','225','1','0','','2')
insert into fieldinfo values('参考方案','书写单位','1','0','225','1','0','','3')
insert into fieldinfo values('参考方案','方案类型','1','0','100','1','0','','4')
insert into fieldinfo values('参考方案','书写日期','1','0','100','1','0','','5')
insert into fieldinfo values('参考方案','存档方式','1','0','100','0','0','','6')
insert into fieldinfo values('参考方案','源文件','6','0','','0','0','','7')
insert into fieldinfo values('参考方案','备注','7','0','','0','0','','8')
insert into fieldinfo values('书籍','名称','1','0','225','1','0','','1')
insert into fieldinfo values('光盘','名称','1','0','225','1','0','','1')
insert into fieldinfo values('光盘','类别','1','0','225','1','0','','2')
insert into fieldinfo values('书籍','类别','1','0','225','1','0','','2')
insert into fieldinfo values('光盘','清单','6','0','','0','0','','3')
insert into fieldinfo values('合成方案','项目名称','1','0','225','1','0','','1')
insert into fieldinfo values('合成方案','所需单位','1','0','225','1','0','','2')
insert into fieldinfo values('合成方案','书写单位','1','0','225','1','0','','3')
insert into fieldinfo values('合成方案','方案类型','1','0','225','1','0','','4')
insert into fieldinfo values('合成方案','书写日期','1','0','100','1','0','','5')
insert into fieldinfo values('合成方案','存档方式','1','0','100','1','0','','6')
insert into fieldinfo values('合成方案','源文件','6','0','','0','0','','7')
insert into fieldinfo values('合成方案','备注','7','0','','0','0','','8')

CREATE TABLE [dbo].[书籍] (
	[自动编号] [numeric](20, 0) NOT NULL ,
	[信息类型] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[名称] [varchar] (225) COLLATE Chinese_PRC_CI_AS NULL ,
	[类别] [varchar] (225) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]


CREATE TABLE [dbo].[会议安排] (
	[自动编号] [numeric](20, 0) NOT NULL ,
	[信息类型] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[会议名称] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[会议地点] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[召开时间] [smalldatetime] NULL ,
	[主要议题] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[会议内容] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[会议日程] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[主办人员] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[与会人员] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[联系人] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[联系电话] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]


CREATE TABLE [dbo].[会议记要] (
	[自动编号] [numeric](20, 0) NOT NULL ,
	[信息类型] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[举行地点] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[参加人] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[会议议题] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[承办单位] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[承办结果] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[记要员] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[承办时间] [smalldatetime] NULL ,
	[详细内容] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[举行时间] [smalldatetime] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]


CREATE TABLE [dbo].[值班安排] (
	[自动编号] [numeric](20, 0) NOT NULL ,
	[信息类型] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[日期] [smalldatetime] NULL ,
	[部门] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[值班人数] [int] NULL ,
	[任务] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]


CREATE TABLE [dbo].[光盘] (
	[自动编号] [numeric](20, 0) NOT NULL ,
	[信息类型] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[名称] [varchar] (225) COLLATE Chinese_PRC_CI_AS NULL ,
	[类别] [varchar] (225) COLLATE Chinese_PRC_CI_AS NULL ,
	[清单] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]


CREATE TABLE [dbo].[出差管理] (
	[自动编号] [numeric](20, 0) NOT NULL ,
	[信息类型] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[出差人员] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[所属部门] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[随身物品] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[离开时间] [smalldatetime] NULL ,
	[返回时间] [smalldatetime] NULL ,
	[出差事由] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[出差地点] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[交通工具] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[返回日程] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[审批人] [smalldatetime] NULL ,
	[备注] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]


CREATE TABLE [dbo].[参考招投标书] (
	[自动编号] [numeric](20, 0) NOT NULL ,
	[信息类型] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[项目名称] [varchar] (225) COLLATE Chinese_PRC_CI_AS NULL ,
	[招标编号] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[招标单位] [varchar] (225) COLLATE Chinese_PRC_CI_AS NULL ,
	[投标单位] [varchar] (225) COLLATE Chinese_PRC_CI_AS NULL ,
	[标书类型] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[存档类型] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[日期] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[源文件] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[备注] [text] COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]


CREATE TABLE [dbo].[参考方案] (
	[自动编号] [numeric](20, 0) NOT NULL ,
	[信息类型] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[项目名称] [varchar] (225) COLLATE Chinese_PRC_CI_AS NULL ,
	[所需单位] [varchar] (225) COLLATE Chinese_PRC_CI_AS NULL ,
	[书写单位] [varchar] (225) COLLATE Chinese_PRC_CI_AS NULL ,
	[方案类型] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[书写日期] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[存档方式] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[源文件] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[备注] [text] COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]


CREATE TABLE [dbo].[合成方案] (
	[自动编号] [numeric](20, 0) NOT NULL ,
	[信息类型] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[项目名称] [varchar] (225) COLLATE Chinese_PRC_CI_AS NULL ,
	[所需单位] [varchar] (225) COLLATE Chinese_PRC_CI_AS NULL ,
	[书写单位] [varchar] (225) COLLATE Chinese_PRC_CI_AS NULL ,
	[方案类型] [varchar] (225) COLLATE Chinese_PRC_CI_AS NULL ,
	[书写日期] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[存档方式] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[源文件] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[备注] [text] COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]


CREATE TABLE [dbo].[名片夹] (
	[自动编号] [numeric](20, 0) NOT NULL ,
	[信息类型] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[姓名] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[公司] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[职务] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[电话] [varchar] (15) COLLATE Chinese_PRC_CI_AS NULL ,
	[地址] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[部门] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[附件] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[简历] [text] COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]


CREATE TABLE [dbo].[员工档案] (
	[自动编号] [numeric](20, 0) NOT NULL ,
	[信息类型] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[姓名] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[性别] [varchar] (4) COLLATE Chinese_PRC_CI_AS NULL ,
	[籍贯] [varchar] (225) COLLATE Chinese_PRC_CI_AS NULL ,
	[民族] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[出生日期] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[健康状况] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[身份证号] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[学历及专业] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[婚姻状况] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[毕业院校] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[外语语种] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[熟练程度] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[家庭住址] [varchar] (225) COLLATE Chinese_PRC_CI_AS NULL ,
	[联系方式] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[个人简历] [varchar] (225) COLLATE Chinese_PRC_CI_AS NULL ,
	[亲属简况] [varchar] (225) COLLATE Chinese_PRC_CI_AS NULL ,
	[其他技能] [varchar] (225) COLLATE Chinese_PRC_CI_AS NULL ,
	[爱好特长] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[身份证] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[毕业证] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[技能证书] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[至本公司时间] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[部门] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[职位] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[晋升] [varchar] (225) COLLATE Chinese_PRC_CI_AS NULL ,
	[处罚] [varchar] (225) COLLATE Chinese_PRC_CI_AS NULL ,
	[备注] [text] COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]


CREATE TABLE [dbo].[客户信息] (
	[自动编号] [numeric](20, 0) NOT NULL ,
	[信息类型] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[客户代号] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[客户名称] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[联系人] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[联系电话] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[客户地址] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[合作经历] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[客户分类] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[备注] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[统计人] [varchar] (12) COLLATE Chinese_PRC_CI_AS NULL ,
	[提成比例] [numeric](10, 2) NULL 
) ON [PRIMARY]


CREATE TABLE [dbo].[工作日志] (
	[自动编号] [numeric](20, 0) NOT NULL ,
	[信息类型] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[业务员] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[日期] [smalldatetime] NULL ,
	[工作内容] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[备注] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]


CREATE TABLE [dbo].[投标书] (
	[自动编号] [numeric](20, 0) NOT NULL ,
	[信息类型] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[项目名称] [varchar] (225) COLLATE Chinese_PRC_CI_AS NULL ,
	[招标编号] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[招标单位] [varchar] (225) COLLATE Chinese_PRC_CI_AS NULL ,
	[投标单位] [varchar] (225) COLLATE Chinese_PRC_CI_AS NULL ,
	[存档类型] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[源文件] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[备注] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[中标情况] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]


CREATE TABLE [dbo].[投诉登记] (
	[自动编号] [numeric](20, 0) NOT NULL ,
	[信息类型] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[部门] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[姓名] [varchar] (8) COLLATE Chinese_PRC_CI_AS NULL ,
	[原因] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[接待时间] [smalldatetime] NULL ,
	[接待人] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[解决部门] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
123

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -