?? oa.sql

?? 極限OA開源系統
?? SQL
?? 第 1 頁 / 共 2 頁
字號:
12 下一頁
# MySQL-Front Dump 2.2
#
# Host: oa.xsp.cn   Database: oa
#--------------------------------------------------------
# Server version 4.0.11-gamma-nt


#
# Table structure for table 'oa_addresslist'
#

CREATE TABLE `oa_addresslist` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `username` varchar(15) NOT NULL default '0',
  `sex` char(2) NOT NULL default '',
  `birth` date NOT NULL default '0000-00-00',
  `duty` varchar(20) default NULL,
  `zip` varchar(8) NOT NULL default '',
  `fax` varchar(18) default NULL,
  `tel` varchar(20) NOT NULL default '',
  `mobile` varchar(20) NOT NULL default '',
  `email` varchar(30) NOT NULL default '',
  `work` varchar(30) NOT NULL default '0',
  `address` varchar(50) NOT NULL default '',
  `memo` text,
  `mid` mediumint(8) unsigned NOT NULL default '0',
  `time` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `username` (`sex`),
  FULLTEXT KEY `log` (`memo`,`address`)
) TYPE=MyISAM COMMENT='通訊錄表';

#
# Table structure for table 'oa_bulletin'
#

CREATE TABLE `oa_bulletin` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `type` varchar(4) NOT NULL default '公告',
  `title` varchar(30) NOT NULL default '0',
  `content` text NOT NULL,
  `keyword` varchar(30) NOT NULL default '',
  `tdate` date NOT NULL default '0000-00-00',
  `time` int(11) unsigned NOT NULL default '0',
  `daynum` tinyint(2) unsigned NOT NULL default '0',
  `time2` int(11) unsigned NOT NULL default '0',
  `scope` smallint(6) unsigned NOT NULL default '0',
  `mid` mediumint(8) unsigned NOT NULL default '0',
  `admin` varchar(30) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM COMMENT='任務表';

#
# Table structure for table 'oa_cli_note'
#

CREATE TABLE `oa_cli_note` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `cid` int(11) unsigned NOT NULL default '0',
  `type` varchar(15) NOT NULL default '',
  `des` text,
  `time` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`id`),
  KEY `username` (`type`),
  FULLTEXT KEY `log` (`des`)
) TYPE=MyISAM COMMENT='客戶拜訪記錄表';

#
# Table structure for table 'oa_client'
#

CREATE TABLE `oa_client` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `type` tinyint(1) unsigned NOT NULL default '0',
  `contactor` varchar(15) NOT NULL default '',
  `corpname` varchar(60) default NULL,
  `tel` varchar(40) default NULL,
  `fax` varchar(20) default NULL,
  `email` varchar(40) default NULL,
  `province` varchar(20) NOT NULL default '',
  `city` varchar(20) NOT NULL default '',
  `address` varchar(40) NOT NULL default '',
  `url` varchar(50) NOT NULL default '0',
  `des` text NOT NULL,
  `log` text,
  `mid` mediumint(8) unsigned NOT NULL default '0',
  `time` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `username` (`contactor`),
  FULLTEXT KEY `log` (`log`,`des`)
) TYPE=MyISAM COMMENT='客戶數據表';

#
# Table structure for table 'oa_department'
#

CREATE TABLE `oa_department` (
  `id` smallint(6) unsigned NOT NULL auto_increment,
  `name` varchar(30) NOT NULL default '0',
  `principal` varchar(15) NOT NULL default '',
  `address` varchar(40) NOT NULL default '',
  `des` varchar(100) NOT NULL default '',
  `fig` tinyint(1) unsigned NOT NULL default '1',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM COMMENT='部門表';



#
# Dumping data for table 'oa_department'
#
INSERT INTO oa_department VALUES("1","市場部","ck","address","","1");
INSERT INTO oa_department VALUES("9","客服部","","","","1");
INSERT INTO oa_department VALUES("6","技術部","ck","address","","1");
INSERT INTO oa_department VALUES("7","財務部","","","","1");
INSERT INTO oa_department VALUES("8","行政部","","","","0");


#
# Table structure for table 'oa_diary'
#

CREATE TABLE `oa_diary` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `title` varchar(60) NOT NULL default '',
  `content` text NOT NULL,
  `mid` mediumint(8) unsigned NOT NULL default '0',
  `date` date NOT NULL default '0000-00-00',
  `time` time NOT NULL default '00:00:00',
  PRIMARY KEY  (`id`),
  FULLTEXT KEY `log` (`content`)
) TYPE=MyISAM COMMENT='客戶數據表';

#
# Table structure for table 'oa_dict'
#

CREATE TABLE `oa_dict` (
  `id` smallint(4) unsigned NOT NULL auto_increment,
  `cid` tinyint(2) unsigned NOT NULL default '0',
  `name` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM COMMENT='辭典表';



#
# Dumping data for table 'oa_dict'
#
INSERT INTO oa_dict VALUES("1","1","總經理");
INSERT INTO oa_dict VALUES("2","1","技術部經理");
INSERT INTO oa_dict VALUES("3","1","市場部經理");
INSERT INTO oa_dict VALUES("4","1","客服部經理");
INSERT INTO oa_dict VALUES("5","1","財務部經理");
INSERT INTO oa_dict VALUES("6","1","生產部總監");
INSERT INTO oa_dict VALUES("7","1","工程師");
INSERT INTO oa_dict VALUES("8","1","普通職員");
INSERT INTO oa_dict VALUES("9","1","其 它");
INSERT INTO oa_dict VALUES("10","2","中共黨員");
INSERT INTO oa_dict VALUES("11","2","共青團員");
INSERT INTO oa_dict VALUES("12","2","民主人士");
INSERT INTO oa_dict VALUES("13","2","群眾");
INSERT INTO oa_dict VALUES("14","3","小學");
INSERT INTO oa_dict VALUES("15","3","初中");
INSERT INTO oa_dict VALUES("16","3","高中");
INSERT INTO oa_dict VALUES("17","3","中專");
INSERT INTO oa_dict VALUES("18","3","技校");
INSERT INTO oa_dict VALUES("19","3","大專");
INSERT INTO oa_dict VALUES("20","3","大本");
INSERT INTO oa_dict VALUES("21","3","碩士");
INSERT INTO oa_dict VALUES("22","3","博士");
INSERT INTO oa_dict VALUES("23","3","博士后");
INSERT INTO oa_dict VALUES("24","3","院士");
INSERT INTO oa_dict VALUES("25","3","其它");
INSERT INTO oa_dict VALUES("26","4","漢族");
INSERT INTO oa_dict VALUES("27","4","回族");
INSERT INTO oa_dict VALUES("28","4","傣族");
INSERT INTO oa_dict VALUES("29","4","苗族");
INSERT INTO oa_dict VALUES("30","4","佤族");
INSERT INTO oa_dict VALUES("31","4","鮮卑族");
INSERT INTO oa_dict VALUES("32","4","朝鮮族");
INSERT INTO oa_dict VALUES("33","4","壯族");
INSERT INTO oa_dict VALUES("34","4","拉祜族");
INSERT INTO oa_dict VALUES("35","4","納西族");
INSERT INTO oa_dict VALUES("36","4","景頗族");
INSERT INTO oa_dict VALUES("37","4","水族");
INSERT INTO oa_dict VALUES("38","4","怒族");
INSERT INTO oa_dict VALUES("39","4","傈僳族");
INSERT INTO oa_dict VALUES("40","4","獨龍族");
INSERT INTO oa_dict VALUES("41","4","布朗族");
INSERT INTO oa_dict VALUES("42","4","基諾族");
INSERT INTO oa_dict VALUES("43","4","羌族");
INSERT INTO oa_dict VALUES("44","4","門巴族");
INSERT INTO oa_dict VALUES("45","4","德昂族");
INSERT INTO oa_dict VALUES("46","4","阿昌族");
INSERT INTO oa_dict VALUES("47","4","普米族");
INSERT INTO oa_dict VALUES("48","4","布依族");
INSERT INTO oa_dict VALUES("49","4","珞巴族");
INSERT INTO oa_dict VALUES("50","4","仡佬族");
INSERT INTO oa_dict VALUES("51","4","白族");
INSERT INTO oa_dict VALUES("52","4","東鄉族");
INSERT INTO oa_dict VALUES("53","4","撒拉族");
INSERT INTO oa_dict VALUES("54","4","保安族");
INSERT INTO oa_dict VALUES("55","4","維吾爾族");
INSERT INTO oa_dict VALUES("56","4","土族");
INSERT INTO oa_dict VALUES("57","4","裕固族");
INSERT INTO oa_dict VALUES("58","4","錫伯族");
INSERT INTO oa_dict VALUES("59","4","俄羅斯族");
INSERT INTO oa_dict VALUES("60","4","塔塔爾族");
INSERT INTO oa_dict VALUES("61","4","哈薩克族");
INSERT INTO oa_dict VALUES("62","4","柯爾克孜族");
INSERT INTO oa_dict VALUES("63","4","塔吉克族");
INSERT INTO oa_dict VALUES("64","4","烏孜別克族");
INSERT INTO oa_dict VALUES("65","4","高山族");
INSERT INTO oa_dict VALUES("66","4","畬族");
INSERT INTO oa_dict VALUES("67","4","黎族");
INSERT INTO oa_dict VALUES("68","4","壯族");
INSERT INTO oa_dict VALUES("69","4","瑤族");
INSERT INTO oa_dict VALUES("70","4","京族");
INSERT INTO oa_dict VALUES("71","4","仫佬族");
INSERT INTO oa_dict VALUES("72","4","毛南族");
INSERT INTO oa_dict VALUES("73","4","土家族");
INSERT INTO oa_dict VALUES("74","4","滿族");
INSERT INTO oa_dict VALUES("75","4","朝鮮族");
INSERT INTO oa_dict VALUES("76","4","赫哲族");
INSERT INTO oa_dict VALUES("77","4","蒙古族");
INSERT INTO oa_dict VALUES("78","4","達斡爾族");
INSERT INTO oa_dict VALUES("79","4","鄂溫克族");
INSERT INTO oa_dict VALUES("80","4","鄂倫春族");
INSERT INTO oa_dict VALUES("81","4","彝族");
INSERT INTO oa_dict VALUES("82","5","正式客戶");
INSERT INTO oa_dict VALUES("83","5","預約客戶");
INSERT INTO oa_dict VALUES("84","5","潛在客戶");
INSERT INTO oa_dict VALUES("85","5","作廢客戶");
INSERT INTO oa_dict VALUES("86","5","其他客戶");
INSERT INTO oa_dict VALUES("87","6","活躍");
INSERT INTO oa_dict VALUES("88","6","停頓");
INSERT INTO oa_dict VALUES("89","6","流失");


#
# Table structure for table 'oa_employees'
#

CREATE TABLE `oa_employees` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `username` varchar(15) NOT NULL default '',
  `sex` char(2) NOT NULL default '',
  `birth` date NOT NULL default '0000-00-00',
  `idcard` varchar(20) NOT NULL default '',
  `native` varchar(20) NOT NULL default '',
  `nation` varchar(15) NOT NULL default '',
  `culture` varchar(10) NOT NULL default '',
  `polity` varchar(16) NOT NULL default '',
  `address` varchar(60) NOT NULL default '',
  `zip` varchar(6) NOT NULL default '',
  `homephone` varchar(20) NOT NULL default '',
  `telphone` varchar(20) NOT NULL default '',
  `mobile` varchar(20) NOT NULL default '',
12 下一頁
?? 文件大小 783 K
?? 上傳用戶 lyyfengyutongzh
?? 所屬分類 OA系統
??? 相關標簽

#開源
?? 快捷鍵說明

復制代碼 Ctrl + C
搜索代碼 Ctrl + F
全屏模式 F11
切換主題 Ctrl + Shift + D
顯示快捷鍵 ?
增大字號 Ctrl + =
減小字號 Ctrl + -
亚洲欧美第一页_禁久久精品乱码_粉嫩av一区二区三区免费野_久草精品视频

?? oa.sql

?? 快捷鍵說明
