appwizard.sql

OA编程 源代码

CREATE TABLE [dbo].[Fieldinfo] (
	[TableName] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[FieldName] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[FieldType] [int] NOT NULL ,
	[FieldIndex] [int] NULL ,
	[FieldLength] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[FieldSearch] [int] NULL ,
	[FieldProperty] [int] NOT NULL ,
	[FieldOther] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[FieldOrder] [int] NULL 
) ON [PRIMARY]

CREATE TABLE [dbo].[Tableinfo] (
	[TableName] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[remark] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]


insert into tableinfo values('会议记要','')
insert into tableinfo values('出差管理','')
insert into tableinfo values('工作日志','')
insert into tableinfo values('派车单','')
insert into tableinfo values('投诉登记','')
insert into tableinfo values('会议安排','')
insert into tableinfo values('客户信息','')
insert into tableinfo values('名片夹','')                        
insert into tableinfo values('物管清单','')                      
insert into tableinfo values('礼品清单','')                      
insert into tableinfo values('值班安排','')                      
insert into tableinfo values('请假条 ','')
insert into tableinfo values('部门收入','')
insert into tableinfo values('部门 ','')                         
insert into tableinfo values('招标书    ','')                    
insert into tableinfo values('参考招投标书   ','')               
insert into tableinfo values('员工档案       ','')               
insert into tableinfo values('绩效考核       ','')               
insert into tableinfo values('软件方案       ','')               
insert into tableinfo values('硬件合同       ','')               
insert into tableinfo values('投标书         ','')               
insert into tableinfo values('硬件方案       ','')               
insert into tableinfo values('参考方案       ','')               
insert into tableinfo values('书籍           ','')               
insert into tableinfo values('光盘           ','')               
insert into tableinfo values('合成方案 	     ','')	


insert into fieldinfo values('出差管理','出差人员','1','0','10','1','0','','1')
insert into fieldinfo values('出差管理','所属部门','1','0','20','1','0','','2')
insert into fieldinfo values('出差管理','随身物品','1','0','100','1','0','','3')
insert into fieldinfo values('出差管理','离开时间','3','0','','1','0','','4')
insert into fieldinfo values('出差管理','返回时间','3','1','','1','0','','5')
insert into fieldinfo values('出差管理','出差事由','1','0','100','1','0','','6')
insert into fieldinfo values('出差管理','出差地点','1','0','50','1','0','','7')
insert into fieldinfo values('出差管理','交通工具','1','0','50','1','1','交通工具','8')
insert into fieldinfo values('出差管理','返回日程','1','0','20','0','0','','9')
insert into fieldinfo values('出差管理','审批人','3','0','','1','0','','10')
insert into fieldinfo values('出差管理','备注','1','0','10','1','0','','11')
insert into fieldinfo values('派车单','日期','3','1','','1','0','','1')
insert into fieldinfo values('派车单','审批人','1','1','20','1','0','','2')
insert into fieldinfo values('派车单','车号','1','1','10','1','0','','3')
insert into fieldinfo values('派车单','驾驶员','1','0','10','1','0','','4')
insert into fieldinfo values('派车单','目的地','1','0','50','1','0','','5')
insert into fieldinfo values('派车单','公里数','2','0','','0','0','','6')
insert into fieldinfo values('派车单','用车部门','1','0','20','1','0','','7')
insert into fieldinfo values('派车单','用车人','1','0','10','1','0','','8')
insert into fieldinfo values('派车单','运输物品','1','0','20','0','0','','9')
insert into fieldinfo values('投诉登记','部门','1','0','20','1','0','','1')
insert into fieldinfo values('投诉登记','姓名','1','0','8','1','0','','2')
insert into fieldinfo values('投诉登记','原因','1','0','50','0','2','6','3')
insert into fieldinfo values('投诉登记','接待时间','3','0','','1','0','','4')
insert into fieldinfo values('投诉登记','接待人','1','0','10','1','0','','5')
insert into fieldinfo values('投诉登记','解决部门','1','0','10','0','0','','6')
insert into fieldinfo values('投诉登记','经办人','1','0','8','1','0','','7')
insert into fieldinfo values('投诉登记','解决进度','1','0','50','0','2','6','8')
insert into fieldinfo values('投诉登记','解决结果','1','0','20','0','0','','9')
insert into fieldinfo values('投诉登记','投诉人意见','1','0','20','0','0','','10')
insert into fieldinfo values('投诉登记','备注','1','0','50','0','2','6','11')
insert into fieldinfo values('会议安排','会议名称','1','0','50','1','0','','1')
insert into fieldinfo values('会议安排','会议地点','1','0','50','1','0','','2')
insert into fieldinfo values('会议安排','召开时间','3','1','','1','0','','3')
insert into fieldinfo values('会议安排','主要议题','1','0','200','1','2','3','4')
insert into fieldinfo values('会议安排','会议内容','1','0','200','0','2','3','5')
insert into fieldinfo values('会议安排','会议日程','1','0','50','0','0','','6')
insert into fieldinfo values('会议安排','主办人员','1','0','50','1','0','','7')
insert into fieldinfo values('会议安排','与会人员','1','0','20','1','0','','8')
insert into fieldinfo values('会议安排','联系人','1','0','20','0','0','','9')
insert into fieldinfo values('会议安排','联系电话','1','0','10','1','0','','10')
insert into fieldinfo values('客户信息','联系电话','1','0','50','0','0','','4')
insert into fieldinfo values('礼品清单','礼品编号','1','1','20','1','0','','1')
insert into fieldinfo values('工作日志','业务员','1','0','50','1','0','','1')
insert into fieldinfo values('工作日志','日期','3','1','','1','0','','2')
insert into fieldinfo values('礼品清单','礼品名称','1','0','20','1','0','','2')
insert into fieldinfo values('礼品清单','礼品价值','4','0','8,2','1','0','','3')
insert into fieldinfo values('礼品清单','保管人','1','0','10','1','0','','7')
insert into fieldinfo values('礼品清单','a5','1','0','50','0','0','','13')
insert into fieldinfo values('名片夹','姓名','1','0','20','1','0','','1')
insert into fieldinfo values('名片夹','公司','1','0','100','1','0','','2')
insert into fieldinfo values('名片夹','电话','1','0','15','0','0','','4')
insert into fieldinfo values('名片夹','地址','1','0','30','0','2','2','5')
insert into fieldinfo values('名片夹','附件','6','0','255','1','0','','7')
insert into fieldinfo values('名片夹','简历','7','0','','0','2','5','8')
insert into fieldinfo values('物管清单','设施编号','1','1','20','1','0','','1')
insert into fieldinfo values('物管清单','设施名称','1','0','20','1','0','','2')
insert into fieldinfo values('物管清单','设施面积','2','0','','0','0','','3')
insert into fieldinfo values('物管清单','最大容量','2','0','','0','0','','4')
insert into fieldinfo values('物管清单','使用情况','1','0','50','1','0','','5')
insert into fieldinfo values('物管清单','主要用途','1','0','50','1','0','','6')
insert into fieldinfo values('物管清单','使用部门','1','0','20','1','0','','7')
insert into fieldinfo values('物管清单','负责人','1','0','10','1','0','','8')
insert into fieldinfo values('物管清单','备注','1','0','50','0','0','','9')
insert into fieldinfo values('礼品清单','a6','1','0','60','0','0','','14')
insert into fieldinfo values('礼品清单','a8','1','0','80','0','0','','16')
insert into fieldinfo values('客户信息','客户分类','1','0','20','1','0','','7')
insert into fieldinfo values('客户信息','备注','6','0','255','1','0','','8')
insert into fieldinfo values('客户信息','提成比例','4','0','10,2','0','0','','10')
insert into fieldinfo values('值班安排','日期','3','0','','1','0','','1')
insert into fieldinfo values('值班安排','部门','1','0','10','1','1','部门名称','2')
insert into fieldinfo values('值班安排','值班人数','2','0','','1','0','','3')
insert into fieldinfo values('值班安排','任务','1','1','50','1','2','2','4')
insert into fieldinfo values('会议记要','举行地点','1','0','100','0','0','','1')
insert into fieldinfo values('会议记要','参加人','1','0','100','0','0','','2')
insert into fieldinfo values('会议记要','会议议题','1','0','255','1','2','3','3')
insert into fieldinfo values('会议记要','承办单位','1','0','100','1','1','部门名称','4')
insert into fieldinfo values('会议记要','承办结果','7','0','','0','2','3','5')
insert into fieldinfo values('会议记要','记要员','1','0','100','0','0','','6')
insert into fieldinfo values('会议记要','承办时间','3','0','','0','0','','7')
insert into fieldinfo values('会议记要','详细内容','6','0','','0','0','','8')
insert into fieldinfo values('会议记要','举行时间','3','0','','1','0','','9')
insert into fieldinfo values('请假条','申请人','1','1','12','1','0','','1')
insert into fieldinfo values('请假条','请假事由','1','1','255','0','2','5','2')
insert into fieldinfo values('请假条','批准人','1','1','12','0','0','','3')
insert into fieldinfo values('请假条','请假日','3','0','','0','0','','4')
insert into fieldinfo values('员工档案','姓名','1','0','20','1','0','','1')
insert into fieldinfo values('员工档案','性别','1','0','4','1','0','','2')
insert into fieldinfo values('员工档案','民族','1','0','10','1','0','','4')
insert into fieldinfo values('员工档案','身份证号','1','0','20','0','0','','7')
insert into fieldinfo values('员工档案','学历及专业','1','0','50','0','0','','8')
insert into fieldinfo values('员工档案','婚姻状况','1','0','20','0','0','','10')
insert into fieldinfo values('员工档案','外语语种','1','0','200','0','0','','12')
insert into fieldinfo values('员工档案','家庭住址','1','0','225','0','0','','14')
insert into fieldinfo values('员工档案','联系方式','1','0','30','0','0','','15')
insert into fieldinfo values('部门收入','序号','1','0','9','0','0','','1')
insert into fieldinfo values('部门收入','姓名','1','0','12','1','0','','2')
insert into fieldinfo values('部门收入','项目名称','1','0','20','1','0','','3')
insert into fieldinfo values('部门收入','类别','1','0','7','1','0','','4')
insert into fieldinfo values('部门收入','部门经理','1','0','12','1','0','','5')
insert into fieldinfo values('部门收入','进帐时间','3','0','','1','0','','6')
insert into fieldinfo values('部门收入','整理报告','4','0','10,2','1','0','','7')
insert into fieldinfo values('部门收入','收费总额','4','0','10,2','1','0','','8')
insert into fieldinfo values('部门收入','预收总额','4','0','10,2','1','0','','9')
insert into fieldinfo values('部门','部门名称','1','0','30','1','1','部门名称','2')
insert into fieldinfo values('部门','类别','1','0','20','0','1','类别','5')
insert into fieldinfo values('部门','实收金额','4','0','20,2','1','0','','6')
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','0','0','','17')
insert into fieldinfo values('员工档案','爱好特长','1','0','200','0','0','','19')
insert into fieldinfo values('绩效考核','姓名','1','0','20','1','0','','1')
insert into fieldinfo values('部门','序号','1','0','10','1','0','','1')
insert into fieldinfo values('部门','项目名称','1','0','50','1','0','','3')
insert into fieldinfo values('部门','是否归档','1','0','10','1','0','','4')
insert into fieldinfo values('部门','日期','3','0','','1','0','','7')
insert into fieldinfo values('部门','备注','1','0','50','0','0','','8')
insert into fieldinfo values('bk软件合同','合同名称','1','0','225','1','0','','1')
insert into fieldinfo values('bk软件合同','甲方','1','0','225','1','0','','2')
insert into fieldinfo values('客户信息','客户代号','1','1','50','1','0','','1')
insert into fieldinfo values('客户信息','客户名称','1','0','50','1','0','','2')
insert into fieldinfo values('客户信息','联系人','1','0','50','1','0','','3')
insert into fieldinfo values('客户信息','客户地址','1','0','50','0','0','','5')
insert into fieldinfo values('客户信息','合作经历','1','0','50','0','0','','6')
insert into fieldinfo values('客户信息','统计人','1','0','12','1','1','统计人','9')
insert into fieldinfo values('员工档案','籍贯','1','0','225','1','0','','3')
insert into fieldinfo values('员工档案','出生日期','1','0','30','0','0','','5')
insert into fieldinfo values('员工档案','健康状况','1','0','20','0','0','','6')
insert into fieldinfo values('礼品清单','主要用途','1','0','50','1','0','','4')
insert into fieldinfo values('礼品清单','现有数量','2','0','','0','0','','5')
insert into fieldinfo values('礼品清单','审批人','1','0','10','1','0','','6')
insert into fieldinfo values('工作日志','工作内容','1','0','255','1','2','4','3')
insert into fieldinfo values('工作日志','备注','1','0','255','1','2','3','4')
insert into fieldinfo values('礼品清单','备注','1','0','10','1','0','','8')
insert into fieldinfo values('礼品清单','a1','1','0','10','0','0','','9')
insert into fieldinfo values('礼品清单','a2','1','0','20','0','0','','10')
insert into fieldinfo values('礼品清单','a3','1','0','30','0','0','','11')
insert into fieldinfo values('礼品清单','a4','1','0','40','0','0','','12')
insert into fieldinfo values('礼品清单','a7','1','0','70','0','0','','15')
insert into fieldinfo values('名片夹','职务','1','0','200','1','0','','3')
insert into fieldinfo values('名片夹','部门','1','0','10','0','0','','6')
insert into fieldinfo values('员工档案','毕业院校','1','0','100','0','0','','11')
insert into fieldinfo values('员工档案','熟练程度','1','0','20','0','0','','13')
insert into fieldinfo values('员工档案','个人简历','1','0','225','0','0','','16')
insert into fieldinfo values('员工档案','其他技能','1','0','225','0','0','','18')
insert into fieldinfo values('员工档案','身份证','6','0','','0','0','','21')
insert into fieldinfo values('员工档案','毕业证','6','0','','0','0','','22')
insert into fieldinfo values('员工档案','技能证书','6','0','','0','0','','23')
insert into fieldinfo values('员工档案','至本公司时间','1','0','50','0','0','','24')
insert into fieldinfo values('员工档案','部门','1','0','20','1','0','','25')
insert into fieldinfo values('员工档案','职位','1','0','20','1','0','','26')
insert into fieldinfo values('绩效考核','部门','1','0','20','1','0','','2')
insert into fieldinfo values('绩效考核','职位','1','0','50','1','0','','3')
insert into fieldinfo values('员工档案','晋升','1','0','225','0','0','','27')
insert into fieldinfo values('员工档案','处罚','1','0','225','0','0','','28')
insert into fieldinfo values('员工档案','备注','7','0','','0','0','','29')
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','','1')
insert into fieldinfo values('硬件合同','乙方','1','0','225','1','0','','3')
insert into fieldinfo values('硬件合同','合同编号','1','0','50','1','0','','4')
insert into fieldinfo values('硬件合同','签定日期','1','0','100','1','0','','5')
insert into fieldinfo values('硬件合同','存档类型','1','0','50','1','0','','6')
insert into fieldinfo values('硬件合同','备注','1','0','225','0','0','','7')
insert into fieldinfo values('硬件合同','源文件','6','0','','0','0','','8')
insert into fieldinfo values('投标书','招标编号','1','0','100','1','0','','2')
insert into fieldinfo values('投标书','招标单位','1','0','225','1','0','','3')
insert into fieldinfo values('投标书','投标单位','1','0','225','0','0','','4')
insert into fieldinfo values('投标书','存档类型','1','0','100','1','0','','5')
insert into fieldinfo values('投标书','源文件','6','0','','0','0','','7')
insert into fieldinfo values('投标书','备注','7','0','','0','0','','8')
insert into fieldinfo values('招标书','招标编号','1','0','100','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','0','0','','5')
insert into fieldinfo values('招标书','源文件','1','0','100','0','0','','6')
insert into fieldinfo values('招标书','备注','1','0','100','0','0','','7')
insert into fieldinfo values('参考招投标书','招标编号','1','0','100','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','0','0','','6')
insert into fieldinfo values('参考招投标书','日期','1','0','100','1','0','','7')
insert into fieldinfo values('参考招投标书','源文件','6','0','','0','0','','8')
insert into fieldinfo values('参考招投标书','备注','7','0','','0','0','','9')
insert into fieldinfo values('投标书','中标情况','1','0','100','0','0','','6')
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','','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')