?? crm.sql

?? CRM 不僅僅是一個管理名詞和管理概念
?? SQL
?? 第 1 頁 / 共 2 頁
字號:
12 下一頁
# phpMyAdmin MySQL-Dump
# version 2.2.4
# http://phpwizard.net/phpMyAdmin/
# http://phpmyadmin.sourceforge.net/ (download page)
#
# 主機: localhost
# Generation Time: Sep 18, 2003 at 05:05 PM
# Server version: 3.23.52
# PHP Version: 4.3.0
# 數據庫 : `crm`
# --------------------------------------------------------

#
# 數據表的結構 `crm_account`
#

CREATE TABLE crm_account (
  AccountID int(10) NOT NULL auto_increment,
  AccountOwnerID varchar(40) NOT NULL default '',
  AccountName varchar(100) NOT NULL default '',
  AccountType varchar(40) NOT NULL default '',
  AccountSN varchar(20) NOT NULL default '',
  AccountIndustry varchar(40) NOT NULL default '',
  AccountSource varchar(40) NOT NULL default '',
  Area varchar(20) NOT NULL default '',
  YearRevenue varchar(40) NOT NULL default '',
  Tel varchar(60) NOT NULL default '',
  HumanScale varchar(40) NOT NULL default '',
  Fax varchar(60) NOT NULL default '',
  Relationship varchar(40) NOT NULL default '',
  WebSite varchar(60) NOT NULL default '',
  MainContact varchar(40) NOT NULL default '',
  Credit varchar(40) NOT NULL default '',
  TaxSN varchar(40) NOT NULL default '',
  FixedAssets varchar(40) NOT NULL default '',
  Sale varchar(40) NOT NULL default '',
  SaleManNumber varchar(40) NOT NULL default '',
  ComputerNumber varchar(40) NOT NULL default '',
  CorpProperty varchar(40) NOT NULL default '',
  FoundTime varchar(40) NOT NULL default '',
  Shared tinyint(1) NOT NULL default '0',
  Country varchar(100) NOT NULL default '',
  Province varchar(100) NOT NULL default '',
  City varchar(100) NOT NULL default '',
  Address varchar(200) NOT NULL default '',
  Zip varchar(20) NOT NULL default '',
  Memo varchar(250) NOT NULL default '',
  CreateID varchar(40) NOT NULL default '',
  CreateTime datetime default NULL,
  ModifyID varchar(40) NOT NULL default '',
  ModifyTime datetime default NULL,
  ifshow tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (AccountID),
  KEY AccountOwnerID (AccountOwnerID),
  KEY Shared (Shared)
) TYPE=MyISAM COMMENT='客戶信息表';

#
# 數據表的結構 `crm_account_human_scale`
#

CREATE TABLE crm_account_human_scale (
  ScaleID int(10) NOT NULL auto_increment,
  ScaleName varchar(40) NOT NULL default '',
  PRIMARY KEY  (ScaleID)
) TYPE=MyISAM COMMENT='人員規模表';

#
# 導出下面的數據庫內容 `crm_account_human_scale`
#

INSERT INTO crm_account_human_scale VALUES (1, '小型');
INSERT INTO crm_account_human_scale VALUES (2, '中小型');
INSERT INTO crm_account_human_scale VALUES (3, '中型');
INSERT INTO crm_account_human_scale VALUES (4, '大中型');
INSERT INTO crm_account_human_scale VALUES (5, '大型');
INSERT INTO crm_account_human_scale VALUES (6, '超大型');
# --------------------------------------------------------

#
# 數據表的結構 `crm_account_industry`
#

CREATE TABLE crm_account_industry (
  IndustryID int(10) NOT NULL auto_increment,
  IndustryName varchar(40) NOT NULL default '',
  PRIMARY KEY  (IndustryID)
) TYPE=MyISAM COMMENT='客戶行業表';

#
# 導出下面的數據庫內容 `crm_account_industry`
#

INSERT INTO crm_account_industry VALUES (1, '動力能源');
INSERT INTO crm_account_industry VALUES (2, '辦公文教');
INSERT INTO crm_account_industry VALUES (3, '食品飲料');
INSERT INTO crm_account_industry VALUES (4, '服飾皮革');
INSERT INTO crm_account_industry VALUES (5, '交通運輸');
INSERT INTO crm_account_industry VALUES (6, '商業服務');
INSERT INTO crm_account_industry VALUES (7, '纖維紡織');
INSERT INTO crm_account_industry VALUES (8, '房產建筑');
INSERT INTO crm_account_industry VALUES (9, '工業用品');
INSERT INTO crm_account_industry VALUES (10, '科研文化');
INSERT INTO crm_account_industry VALUES (11, '家用電器');
INSERT INTO crm_account_industry VALUES (12, '家居用品');
INSERT INTO crm_account_industry VALUES (13, '機械機電');
INSERT INTO crm_account_industry VALUES (14, '電腦軟件');
INSERT INTO crm_account_industry VALUES (15, '醫藥保健');
INSERT INTO crm_account_industry VALUES (16, '金融貿易');
INSERT INTO crm_account_industry VALUES (17, '化學化工');
INSERT INTO crm_account_industry VALUES (18, '玩具行業');
INSERT INTO crm_account_industry VALUES (19, '冶金礦產');
INSERT INTO crm_account_industry VALUES (20, '運動休閑');
INSERT INTO crm_account_industry VALUES (21, '通訊郵電');
INSERT INTO crm_account_industry VALUES (22, '旅游餐飲');
INSERT INTO crm_account_industry VALUES (23, '信息媒體');
INSERT INTO crm_account_industry VALUES (24, '其他行業');
# --------------------------------------------------------

#
# 數據表的結構 `crm_account_relationship`
#

CREATE TABLE crm_account_relationship (
  RelationshipID int(10) NOT NULL auto_increment,
  RelationshipName varchar(40) NOT NULL default '',
  PRIMARY KEY  (RelationshipID)
) TYPE=MyISAM COMMENT='客戶關系等級表';

#
# 導出下面的數據庫內容 `crm_account_relationship`
#

INSERT INTO crm_account_relationship VALUES (1, '密切');
INSERT INTO crm_account_relationship VALUES (2, '良好');
INSERT INTO crm_account_relationship VALUES (3, '普通');
INSERT INTO crm_account_relationship VALUES (4, '緊張');
INSERT INTO crm_account_relationship VALUES (5, '其他');
# --------------------------------------------------------

#
# 數據表的結構 `crm_account_type`
#

CREATE TABLE crm_account_type (
  TypeID int(10) NOT NULL auto_increment,
  TypeName varchar(40) NOT NULL default '',
  PRIMARY KEY  (TypeID)
) TYPE=MyISAM COMMENT='帳戶類別表';

#
# 導出下面的數據庫內容 `crm_account_type`
#

INSERT INTO crm_account_type VALUES (1, '企業大客戶');
INSERT INTO crm_account_type VALUES (2, '家庭用戶');
INSERT INTO crm_account_type VALUES (3, '政府用戶');
INSERT INTO crm_account_type VALUES (4, '個人用戶');
INSERT INTO crm_account_type VALUES (5, '中小企業');
INSERT INTO crm_account_type VALUES (6, '批發商');
# --------------------------------------------------------

#
# 數據表的結構 `crm_account_year_revenue`
#

CREATE TABLE crm_account_year_revenue (
  RevenueID int(10) NOT NULL auto_increment,
  RevenueName varchar(40) NOT NULL default '',
  PRIMARY KEY  (RevenueID)
) TYPE=MyISAM COMMENT='年收入表';

#
# 導出下面的數據庫內容 `crm_account_year_revenue`
#

INSERT INTO crm_account_year_revenue VALUES (1, '0-10萬元');
INSERT INTO crm_account_year_revenue VALUES (2, '10-50萬元');
INSERT INTO crm_account_year_revenue VALUES (3, '50-100萬元');
INSERT INTO crm_account_year_revenue VALUES (4, '100-500萬元');
INSERT INTO crm_account_year_revenue VALUES (5, '500-1000萬元');
INSERT INTO crm_account_year_revenue VALUES (6, '1000-5000萬元');
INSERT INTO crm_account_year_revenue VALUES (7, '5000萬元-1億元');
INSERT INTO crm_account_year_revenue VALUES (8, '一億元以上');
# --------------------------------------------------------

#
# 數據表的結構 `crm_activity`
#

CREATE TABLE crm_activity (
  ActivityID int(10) NOT NULL auto_increment,
  AccountID int(10) NOT NULL default '0',
  ContactID int(10) NOT NULL default '0',
  ProjectID int(10) NOT NULL default '0',
  ActivityName varchar(100) NOT NULL default '',
  ActivityLocation varchar(60) NOT NULL default '',
  ActivityMode varchar(40) NOT NULL default '',
  ActivityExecuteID int(10) NOT NULL default '0',
  BeginTime date NOT NULL default '0000-00-00',
  EndTime date NOT NULL default '0000-00-00',
  YuJianSale decimal(10,2) NOT NULL default '0.00',
  PeiTongRen varchar(100) NOT NULL default '',
  Result varchar(250) NOT NULL default '',
  Memo varchar(250) NOT NULL default '',
  PRIMARY KEY  (ActivityID),
  KEY AccountID (AccountID),
  KEY ActivityExecuteID (ActivityExecuteID),
  KEY ProjectID (ProjectID),
  KEY ContactID (ContactID)
) TYPE=MyISAM COMMENT='行動表';

# --------------------------------------------------------

#
# 數據表的結構 `crm_area`
#

CREATE TABLE crm_area (
  AreaID int(8) NOT NULL auto_increment,
  AreaName varchar(50) NOT NULL default '',
  PRIMARY KEY  (AreaID)
) TYPE=MyISAM COMMENT='客戶地區表';

#
# 導出下面的數據庫內容 `crm_area`
#

INSERT INTO crm_area VALUES (1, '華東地區');
INSERT INTO crm_area VALUES (2, '華南地區');
INSERT INTO crm_area VALUES (3, '華中地區');
INSERT INTO crm_area VALUES (4, '華北地區');
INSERT INTO crm_area VALUES (5, '西北地區');
INSERT INTO crm_area VALUES (6, '西南地區');
INSERT INTO crm_area VALUES (7, '其他地區');
# --------------------------------------------------------

#
# 數據表的結構 `crm_attach`
#

CREATE TABLE crm_attach (
  AttachID int(10) NOT NULL auto_increment,
  AttachColumn varchar(60) NOT NULL default '',
  AttachColumnID int(10) NOT NULL default '0',
  FileName varchar(200) NOT NULL default '',
  AttachName varchar(100) NOT NULL default '',
  FileSize varchar(100) NOT NULL default '',
  UploaderID int(10) NOT NULL default '0',
  UploadTime date NOT NULL default '0000-00-00',
  PRIMARY KEY  (AttachID),
  KEY AttachColumnID (AttachColumnID)
) TYPE=MyISAM COMMENT='web上傳附件表';

# --------------------------------------------------------

#
# 數據表的結構 `crm_contact`
#

CREATE TABLE crm_contact (
  ContactID int(10) NOT NULL auto_increment,
  AccountID int(10) NOT NULL default '0',
  ContactName varchar(40) NOT NULL default '',
  ChenWei varchar(40) NOT NULL default '',
  ZhiWu varchar(40) NOT NULL default '',
  Dept varchar(40) NOT NULL default '',
  Birthday date NOT NULL default '0000-00-00',
  Email varchar(40) NOT NULL default '',
  OfficeTel varchar(40) NOT NULL default '',
  OfficeFax varchar(40) NOT NULL default '',
  Mobile varchar(40) NOT NULL default '',
  HomeTel varchar(40) NOT NULL default '',
  HomeAddr varchar(60) NOT NULL default '',
  Hobby varchar(100) NOT NULL default '',
  Source varchar(40) NOT NULL default '',
  Relation varchar(40) NOT NULL default '',
  AddID int(10) NOT NULL default '0',
  CreateTime date NOT NULL default '0000-00-00',
  PRIMARY KEY  (ContactID),
  KEY AccountID (AccountID),
  KEY AddID (AddID)
) TYPE=MyISAM COMMENT='聯系人信息表';

# --------------------------------------------------------

#
# 數據表的結構 `crm_contact_folk`
#
12 下一頁
?? 文件大小 117 K
?? 上傳用戶 ABC258369000
?? 所屬分類 *行業應用
??? 相關標簽

#CRM
?? 快捷鍵說明

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

?? crm.sql

?? 快捷鍵說明
