1、供应商入驻状态有哪些？

{"header":[{"lableName": "联系人称谓","lablecode":"contact_appellation","type":"string"}, 
{"lableName": "所在部门", "lablecode": "contact_department","type":"string"},
{"lableName": "姓名", "lablecode": "contact_name","type":"string"},
{"lableName": "手机号码", "lablecode": "contact_phone","type":"phone"},
{"lableName": "职位", "lablecode": "contact_position","type":"string"},
{"lableName": "电子邮箱", "lablecode": "contact_email","type":"email"}],"data":[{"contact_appellation": "联系人称谓","contact_department":"所在部门","contact_name":"姓名","contact_phone":"手机号码","contact_position":"职位","contact_email":"电子邮箱"},{"contact_appellation": "联系人称谓","contact_department":"所在部门","contact_name":"姓名","contact_phone":"手机号码","contact_position":"职位","contact_email":"电子邮箱"}]}

/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

# Dump of table asgard_dictionary

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

DROP TABLE IF EXISTS `asgard_dictionary`;

CREATE TABLE `asgard_dictionary` (

`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,

`code` varchar(100) DEFAULT NULL,

`key` varchar(100) NOT NULL DEFAULT '',

`value` varchar(100) NOT NULL DEFAULT '',

`desc` varchar(50) DEFAULT NULL COMMENT '描述，一般为展示到界面',

`created_by` bigint(20) unsigned DEFAULT NULL COMMENT '创建人',

`updated_by` bigint(20) unsigned DEFAULT NULL COMMENT '最后更新人',

`created_at` datetime NOT NULL COMMENT '创建时间',

`updated_at` datetime NOT NULL COMMENT '最后更新时间',

`options` int(11) DEFAULT NULL COMMENT '预留字段',

`extra_json` varchar(2048) DEFAULT NULL COMMENT '预留字段',

`is_deleted` tinyint(4) DEFAULT '0' COMMENT '是否删除',

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='数据字典-尾部带有“_init”的表示初始值；“_logic”表示应用逻辑之后的结果-有程序控制其操作（创建和修改）';

LOCK TABLES `asgard_dictionary` WRITE;

/*!40000 ALTER TABLE `asgard_dictionary` DISABLE KEYS */;

INSERT INTO `asgard_dictionary` (`id`, `code`, `key`, `value`, `desc`, `created_by`, `updated_by`, `created_at`, `updated_at`, `options`, `extra_json`, `is_deleted`)

VALUES

\(1,'pur\_auditor\_show\_init','pur\_saas\_operate','saas\_operate','运营',NULL,NULL,'2018-01-03 09:51:05','2018-01-03 09:51:05',NULL,NULL,0\),

\(2,'pur\_auditor\_show\_init','pur\_upper\_com\_belongto\_tenant','upper\_com\_belongto\_tenant','上级公司所属公司',NULL,NULL,'2018-01-20 00:00:00','2018-01-20 00:00:00',NULL,NULL,0\),

\(3,'sup\_auditor\_show\_init','sup\_saas\_operate','saas\_operate','运营',NULL,NULL,'2018-01-20 00:00:00','2018-01-20 00:00:00',NULL,NULL,0\),

\(4,'pur\_auditor\_value\_logic','pur\_auditor\_value\_logic','saas\_operate,upper\_com\_belongto\_tenant','审核方',NULL,NULL,'2018-01-20 00:00:00','2018-01-20 00:00:00',NULL,NULL,0\),

\(5,'pur\_auditing\_value\_logic','pur\_auditing\_value\_logic','close','准入审核',NULL,NULL,'2018-01-20 00:00:00','2018-01-20 00:00:00',NULL,NULL,0\),

\(6,'saas\_config\_phase','enter','enter','入驻阶段填写',NULL,NULL,'2018-01-31 00:00:00','2018-01-31 00:00:00',NULL,NULL,0\),

\(7,'saas\_config\_phase','update','update','修改阶段填写',NULL,NULL,'2018-01-31 00:00:00','2018-01-31 00:00:00',NULL,NULL,0\),

\(8,'saas\_config\_audit','change\_audit','change\_audit','变更需要审核',NULL,NULL,'2018-02-02 00:00:00','2018-02-02 00:00:00',NULL,NULL,0\),

\(9,'saas\_config\_audit','change\_no\_audit','change\_no\_audit','变更不需要审核',NULL,NULL,'2018-02-02 00:00:00','2018-02-02 00:00:00',NULL,NULL,0\),

\(10,'taxpayerType','normal','normal','一般纳税人',NULL,NULL,'2018-02-02 00:00:00','2018-02-02 00:00:00',NULL,NULL,0\),

\(11,'taxpayerType','samllaccount','samllaccount','小额贷款',NULL,NULL,'2018-02-02 00:00:00','2018-02-02 00:00:00',NULL,NULL,0\);

/*!40000 ALTER TABLE `asgard_dictionary` ENABLE KEYS */;

UNLOCK TABLES;

# Dump of table purchaser_account

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

DROP TABLE IF EXISTS `purchaser_account`;

CREATE TABLE `purchaser_account` (

`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,

`master_purchaser_id` bigint(20) unsigned DEFAULT NULL,

`account_id` bigint(20) unsigned DEFAULT NULL COMMENT '用户 ID，对接用户中心',

`created_by` bigint(20) unsigned DEFAULT NULL COMMENT '创建人',

`updated_by` bigint(20) unsigned DEFAULT NULL COMMENT '最后更新人',

`created_at` datetime NOT NULL COMMENT '创建时间',

`updated_at` datetime NOT NULL COMMENT '最后更新时间',

`extra_json` varchar(2048) DEFAULT NULL COMMENT '预留字段',

`options` int(11) DEFAULT NULL COMMENT '预留字段',

`is_deleted` tinyint(4) DEFAULT '0' COMMENT '是否删除',

PRIMARY KEY (`id`),

UNIQUE KEY `purchaser_account_id_uindex` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

# Dump of table purchaser_basic

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

DROP TABLE IF EXISTS `purchaser_basic`;

CREATE TABLE `purchaser_basic` (

`id` bigint(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '采购商ID',

`outer_id` bigint(20) unsigned DEFAULT NULL COMMENT '统一saas平台中的账户id,数据同步使用',

`tenant_id` bigint(20) unsigned DEFAULT NULL COMMENT '租户id，冗余',

`purchaser_code` varchar(255) DEFAULT NULL COMMENT '采购商代码: 由平台生成',

`source` varchar(255) DEFAULT NULL COMMENT '来源: invited -> 邀请入驻 , saas_registed -> saas 平台直接注册入驻',

`status` varchar(255) DEFAULT NULL COMMENT 'preserved: 已保存 unqualified: 不合格 submit: 已提交 to_be_investigated: 待评估 investigated: 已评估 in_store: 已入库',

`auditor` bigint(20) DEFAULT NULL COMMENT '审核人',

`audit_time` datetime DEFAULT NULL COMMENT '审核时间',

`superior_master_purchaser_id` bigint(20) unsigned DEFAULT NULL COMMENT '上级采购商信息',

`created_by` bigint(20) unsigned DEFAULT NULL COMMENT '创建人',

`updated_by` bigint(20) unsigned DEFAULT NULL COMMENT '最后更新人',

`created_at` datetime NOT NULL COMMENT '创建时间',

`updated_at` datetime NOT NULL COMMENT '最后更新时间',

`extra_json` varchar(2048) DEFAULT NULL COMMENT '预留字段',

`options` int(11) DEFAULT NULL COMMENT '预留字段',

`is_deleted` tinyint(4) DEFAULT '0' COMMENT '是否删除',

PRIMARY KEY (`id`),

KEY `master_purchaser_id` (`outer_id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='采购商基本信息';

LOCK TABLES `purchaser_basic` WRITE;

/*!40000 ALTER TABLE `purchaser_basic` DISABLE KEYS */;

INSERT INTO `purchaser_basic` (`id`, `outer_id`, `tenant_id`, `purchaser_code`, `source`, `status`, `auditor`, `audit_time`, `superior_master_purchaser_id`, `created_by`, `updated_by`, `created_at`, `updated_at`, `extra_json`, `options`, `is_deleted`)

VALUES

\(10,NULL,20,'73331b3b-2192-4313-94ff-e94a1ebfbaf3',NULL,'test-status',NULL,NULL,NULL,NULL,NULL,'2018-01-31 11:30:50','2018-01-31 11:30:50',NULL,NULL,0\),

\(11,NULL,21,'3c4ee87a-91f5-43a0-a484-a016efd33df2',NULL,'test-status',NULL,NULL,NULL,NULL,NULL,'2018-02-01 12:34:40','2018-02-01 12:34:41',NULL,NULL,1\),

\(12,NULL,22,'fc15eaef-afdd-481f-b2c4-53d5805875df',NULL,'test-status',NULL,NULL,NULL,NULL,NULL,'2018-02-01 12:37:22','2018-02-01 12:37:25',NULL,NULL,1\);

/*!40000 ALTER TABLE `purchaser_basic` ENABLE KEYS */;

UNLOCK TABLES;

# Dump of table purchaser_black

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

DROP TABLE IF EXISTS `purchaser_black`;

CREATE TABLE `purchaser_black` (

`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,

`tenant_id` bigint(20) unsigned DEFAULT NULL COMMENT '租户id',

`master_purchaser_id` bigint(20) unsigned DEFAULT NULL,

`master_supplier_id` bigint(20) unsigned DEFAULT NULL,

`status` tinyint(4) DEFAULT NULL COMMENT '是否还在黑名单状态：1、加黑 2、解冻',

`level` tinyint(4) DEFAULT NULL COMMENT '黑名单级别：公司级别还是物料级别；租户级别，即供应商不可和租户任何采购商发生业务',

`blacklist_content` varchar(500) DEFAULT NULL COMMENT '哪些物料',

`start_time` datetime DEFAULT NULL COMMENT '黑名单开始时间-拉黑时间',

`end_time` datetime DEFAULT NULL COMMENT '黑名单结束时间-设置多长时间',

`release_time` datetime DEFAULT NULL COMMENT '解除时间',

`created_by` bigint(20) unsigned DEFAULT NULL COMMENT '创建人',

`updated_by` bigint(20) unsigned DEFAULT NULL COMMENT '最后更新人',

`created_at` datetime NOT NULL COMMENT '创建时间',

`updated_at` datetime NOT NULL COMMENT '最后更新时间',

`extra_json` varchar(2048) DEFAULT NULL COMMENT '预留字段',

`options` int(11) DEFAULT NULL COMMENT '预留字段',

`is_deleted` tinyint(4) DEFAULT '0' COMMENT '是否删除',

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='采购商设置黑名单';

# Dump of table purchaser_company

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

DROP TABLE IF EXISTS `purchaser_company`;

CREATE TABLE `purchaser_company` (

`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,

`tenant_id` bigint(20) unsigned DEFAULT NULL COMMENT '租户id',

`master_purchaser_id` bigint(20) unsigned DEFAULT NULL,

`company_name` varchar(200) DEFAULT NULL,

`legal_representative` varchar(200) DEFAULT NULL COMMENT '法人代表',

`unified_social_credit_code` varchar(18) DEFAULT NULL COMMENT '统一社会信用代码',

`registered_captical` int(11) DEFAULT NULL COMMENT '注册资本',

`registered_time` date DEFAULT NULL COMMENT '注册时间',

`business_term_from` date DEFAULT NULL COMMENT '营业期限-开始',

`business_term_to` date DEFAULT NULL COMMENT '营业时间-结束',

`province` varchar(20) DEFAULT NULL,

`city` varchar(20) DEFAULT NULL,

`area` varchar(20) DEFAULT NULL,

`street` varchar(200) DEFAULT NULL,

`company_type` varchar(20) DEFAULT NULL,

`company_website` varchar(200) DEFAULT NULL,

`company_logo` varchar(200) DEFAULT NULL,

`company_brief_info` varchar(2000) DEFAULT NULL,

`created_by` bigint(20) unsigned DEFAULT NULL COMMENT '创建人',

`updated_by` bigint(20) unsigned DEFAULT NULL COMMENT '最后更新人',

`created_at` datetime NOT NULL COMMENT '创建时间',

`updated_at` datetime NOT NULL COMMENT '最后更新时间',

`extra_json` varchar(2048) DEFAULT NULL COMMENT '预留字段',

`options` int(11) DEFAULT NULL COMMENT '预留字段',

`is_deleted` tinyint(4) DEFAULT '0' COMMENT '是否删除',

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

LOCK TABLES `purchaser_company` WRITE;

/*!40000 ALTER TABLE `purchaser_company` DISABLE KEYS */;

INSERT INTO `purchaser_company` (`id`, `tenant_id`, `master_purchaser_id`, `company_name`, `legal_representative`, `unified_social_credit_code`, `registered_captical`, `registered_time`, `business_term_from`, `business_term_to`, `province`, `city`, `area`, `street`, `company_type`, `company_website`, `company_logo`, `company_brief_info`, `created_by`, `updated_by`, `created_at`, `updated_at`, `extra_json`, `options`, `is_deleted`)

VALUES

\(1,21,11,'bd1c17a1-db44-4f9d-8820-4f8efd74b068',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-02-01 12:34:41','2018-02-01 12:34:41',NULL,NULL,0\),

\(2,22,12,'f2b0b2db-5615-420e-b822-55890c189ad4',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-02-01 12:37:24','2018-02-01 12:37:24',NULL,NULL,0\);

/*!40000 ALTER TABLE `purchaser_company` ENABLE KEYS */;

UNLOCK TABLES;

# Dump of table purchaser_company_tax

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

DROP TABLE IF EXISTS `purchaser_company_tax`;

CREATE TABLE `purchaser_company_tax` (

`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,

`tenant_id` bigint(20) unsigned DEFAULT NULL,

`master_purchaser_id` bigint(20) unsigned DEFAULT NULL,

`taxpayer_name` varchar(20) DEFAULT NULL COMMENT '税务人名称',

`taxpayer_type` varchar(20) DEFAULT NULL COMMENT '税务人类型',

`registration_address` varchar(200) DEFAULT NULL,

`registration_phone` varchar(20) DEFAULT NULL,

`registration_bank_name` varchar(200) DEFAULT NULL,

`registration_bank_account` varchar(20) DEFAULT NULL,

`special_invoice_contact_name` varchar(20) DEFAULT NULL COMMENT '专票联系人名称',

`special_invoice_contact_phone` varchar(20) DEFAULT NULL COMMENT '专票联系人手机号码',

`created_by` bigint(20) unsigned DEFAULT NULL COMMENT '创建人',

`updated_by` bigint(20) unsigned DEFAULT NULL COMMENT '最后更新人',

`created_at` datetime NOT NULL COMMENT '创建时间',

`updated_at` datetime NOT NULL COMMENT '最后更新时间',

`extra_json` varchar(2048) DEFAULT NULL COMMENT '预留字段',

`options` int(11) DEFAULT NULL COMMENT '预留字段',

`is_deleted` tinyint(4) DEFAULT '0' COMMENT '是否删除',

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

# Dump of table purchaser_follow_info_component

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

DROP TABLE IF EXISTS `purchaser_follow_info_component`;

CREATE TABLE `purchaser_follow_info_component` (

`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,

`tenant_id` bigint(20) unsigned DEFAULT NULL,

`master_purchaser_id` bigint(20) unsigned DEFAULT NULL,

`type` int(4) NOT NULL COMMENT '1、PFP:表示采购商关注采购商的信息；2、PFS：表示采购商关注供应商的信息',

`component_key` varchar(200) DEFAULT NULL,

`is_follow` tinyint(4) DEFAULT NULL COMMENT '是否关注',

`follow_party` varchar(200) DEFAULT NULL COMMENT '关注方',

`created_by` bigint(20) unsigned DEFAULT NULL COMMENT '创建人',

`updated_by` bigint(20) unsigned DEFAULT NULL COMMENT '最后更新人',

`created_at` datetime NOT NULL COMMENT '创建时间',

`updated_at` datetime NOT NULL COMMENT '最后更新时间',

`extra_json` varchar(2048) DEFAULT NULL COMMENT '预留字段',

`options` int(11) DEFAULT NULL COMMENT '预留字段',

`is_deleted` tinyint(4) DEFAULT '0' COMMENT '是否删除',

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='采购商关注内容的相关信息表';

# Dump of table purchaser_info_component

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

DROP TABLE IF EXISTS `purchaser_info_component`;

CREATE TABLE `purchaser_info_component` (

`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,

`tenant_id` bigint(20) unsigned DEFAULT NULL,

`master_purchaser_id` bigint(20) unsigned DEFAULT NULL,

`component_key` varchar(200) DEFAULT NULL,

`key_type` varchar(50) DEFAULT NULL COMMENT 'key类型：table,form',

`component_name` varchar(200) DEFAULT NULL,

`data` varchar(2048) DEFAULT NULL,

`created_by` bigint(20) unsigned DEFAULT NULL COMMENT '创建人',

`updated_by` bigint(20) unsigned DEFAULT NULL COMMENT '最后更新人',

`created_at` datetime NOT NULL COMMENT '创建时间',

`updated_at` datetime NOT NULL COMMENT '最后更新时间',

`extra_json` varchar(2048) DEFAULT NULL COMMENT '预留字段',

`options` int(11) DEFAULT NULL COMMENT '预留字段',

`is_deleted` tinyint(4) DEFAULT '0' COMMENT '是否删除',

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='采购商-信息组或者叫出了基本信息之外的其他信息表';

# Dump of table purchaser_invitation_code

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

DROP TABLE IF EXISTS `purchaser_invitation_code`;

CREATE TABLE `purchaser_invitation_code` (

`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,

`tenant_id` bigint(20) unsigned DEFAULT NULL COMMENT '租户id',

`master_purchaser_id` bigint(20) unsigned NOT NULL,

`master_supplier_id` bigint(20) unsigned DEFAULT NULL,

`invitation_code` varchar(100) DEFAULT NULL COMMENT '邀请码',

`status` tinyint(4) NOT NULL COMMENT '1、未使用 2、已使用',

`created_by` bigint(20) unsigned DEFAULT NULL COMMENT '创建人',

`updated_by` bigint(20) unsigned DEFAULT NULL COMMENT '最后更新人',

`created_at` datetime NOT NULL COMMENT '创建时间',

`updated_at` datetime NOT NULL COMMENT '最后更新时间',

`extra_json` varchar(2048) DEFAULT NULL COMMENT '预留字段',

`options` int(11) DEFAULT NULL COMMENT '预留字段',

`is_deleted` tinyint(4) DEFAULT '0' COMMENT '是否删除',

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='采购商生成的邀请码';

# Dump of table purchaser_rate_template

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

DROP TABLE IF EXISTS `purchaser_rate_template`;

CREATE TABLE `purchaser_rate_template` (

`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,

`tenant_id` bigint(20) unsigned DEFAULT NULL,

`master_purchaser_id` bigint(20) unsigned DEFAULT NULL,

`rate_template_name` int(11) DEFAULT NULL,

`created_by` bigint(20) unsigned DEFAULT NULL COMMENT '创建人',

`updated_by` bigint(20) unsigned DEFAULT NULL COMMENT '最后更新人',

`created_at` datetime NOT NULL COMMENT '创建时间',

`updated_at` datetime NOT NULL COMMENT '最后更新时间',

`extra_json` varchar(2048) DEFAULT NULL COMMENT '预留字段',

`options` int(11) DEFAULT NULL COMMENT '预留字段',

`is_deleted` tinyint(4) DEFAULT '0' COMMENT '是否删除',

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='采购商评分模版';

# Dump of table purchaser_rate_template_module

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

DROP TABLE IF EXISTS `purchaser_rate_template_module`;

CREATE TABLE `purchaser_rate_template_module` (

`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,

`rate_template_id` bigint(20) unsigned DEFAULT NULL,

`module_name` int(11) DEFAULT NULL,

`module_columns` varchar(2048) DEFAULT NULL,

`created_by` bigint(20) unsigned DEFAULT NULL COMMENT '创建人',

`updated_by` bigint(20) unsigned DEFAULT NULL COMMENT '最后更新人',

`created_at` datetime NOT NULL COMMENT '创建时间',

`updated_at` datetime NOT NULL COMMENT '最后更新时间',

`extra_json` varchar(2048) DEFAULT NULL COMMENT '预留字段',

`options` int(11) DEFAULT NULL COMMENT '预留字段',

`is_deleted` tinyint(4) DEFAULT '0' COMMENT '是否删除',

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='采购商评分模版模块';

# Dump of table purchaser_supplier_basic_info

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

DROP TABLE IF EXISTS `purchaser_supplier_basic_info`;

CREATE TABLE `purchaser_supplier_basic_info` (

`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,

`tenant_id` bigint(20) unsigned DEFAULT NULL,

`master_purchaser_id` bigint(20) unsigned DEFAULT NULL,

`master_supplier_id` bigint(20) unsigned DEFAULT NULL,

`cooperate_status` tinyint(4) DEFAULT NULL COMMENT '合作状态',

`cooperate_time` datetime DEFAULT NULL COMMENT '建立合作时间',

`investigate_status` tinyint(4) DEFAULT NULL COMMENT '考察状态',

`changed` tinyint(4) DEFAULT '0' COMMENT '供应商是否变动：默认为0，变动为1',

`version` varchar(20) DEFAULT NULL COMMENT '如果有变动，消息处理前，版本号有对应的历史版本',

`created_by` bigint(20) unsigned DEFAULT NULL COMMENT '创建人',

`updated_by` bigint(20) unsigned DEFAULT NULL COMMENT '最后更新人',

`created_at` datetime NOT NULL COMMENT '创建时间',

`updated_at` datetime NOT NULL COMMENT '最后更新时间',

`extra_json` varchar(2048) DEFAULT NULL COMMENT '预留字段',

`options` int(11) DEFAULT NULL COMMENT '预留字段',

`is_deleted` tinyint(4) DEFAULT '0' COMMENT '是否删除',

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='供应商-采购商管理管理';

# Dump of table purchaser_supplier_investigate_result

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

DROP TABLE IF EXISTS `purchaser_supplier_investigate_result`;

CREATE TABLE `purchaser_supplier_investigate_result` (

`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,

`master_purchaser_id` bigint(20) unsigned DEFAULT NULL,

`master_supplier_id` bigint(20) unsigned DEFAULT NULL,

`rate_template_id` bigint(20) unsigned DEFAULT NULL,

`period` varchar(11) DEFAULT NULL,

`attachments` varchar(2048) DEFAULT NULL,

`created_by` bigint(20) unsigned DEFAULT NULL COMMENT '创建人',

`updated_by` bigint(20) unsigned DEFAULT NULL COMMENT '最后更新人',

`created_at` datetime NOT NULL COMMENT '创建时间',

`updated_at` datetime NOT NULL COMMENT '最后更新时间',

`extra_json` varchar(2048) DEFAULT NULL COMMENT '预留字段',

`options` int(11) DEFAULT NULL COMMENT '预留字段',

`is_deleted` tinyint(4) DEFAULT '0' COMMENT '是否删除',

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='采购商考察供应商记录结果表';

# Dump of table purchaser_supplier_rate_template_result

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

DROP TABLE IF EXISTS `purchaser_supplier_rate_template_result`;

CREATE TABLE `purchaser_supplier_rate_template_result` (

`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,

`master_purchaser_id` bigint(20) unsigned DEFAULT NULL,

`master_supplier_id` bigint(20) unsigned DEFAULT NULL,

`rate_template_id` bigint(20) unsigned DEFAULT NULL,

`period` varchar(11) DEFAULT NULL,

`created_by` bigint(20) unsigned DEFAULT NULL COMMENT '创建人',

`updated_by` bigint(20) unsigned DEFAULT NULL COMMENT '最后更新人',

`created_at` datetime NOT NULL COMMENT '创建时间',

`updated_at` datetime NOT NULL COMMENT '最后更新时间',

`extra_json` varchar(2048) DEFAULT NULL COMMENT '预留字段',

`options` int(11) DEFAULT NULL COMMENT '预留字段',

`is_deleted` tinyint(4) DEFAULT '0' COMMENT '是否删除',

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='采购商-供应商模版评分结果';

# Dump of table purchaser_supplier_tag

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

DROP TABLE IF EXISTS `purchaser_supplier_tag`;

CREATE TABLE `purchaser_supplier_tag` (

`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,

`type` tinyint(4) DEFAULT NULL COMMENT '1、系统标签 2、采购商运营标签 3、采购商子公司标签',

`ref_id` bigint(20) unsigned DEFAULT NULL COMMENT '是采购商id，还是saas的id，还是采购商子公司的id',

`master_supplier_id` bigint(20) unsigned DEFAULT NULL COMMENT '供应商id',

`tag_id` bigint(20) unsigned DEFAULT NULL,

`tag_code` varchar(50) DEFAULT NULL,

`tag` varchar(100) DEFAULT NULL,

`created_by` bigint(20) unsigned DEFAULT NULL COMMENT '创建人',

`updated_by` bigint(20) unsigned DEFAULT NULL COMMENT '最后更新人',

`created_at` datetime NOT NULL COMMENT '创建时间',

`updated_at` datetime NOT NULL COMMENT '最后更新时间',

`extra_json` varchar(2048) DEFAULT NULL COMMENT '预留字段',

`options` int(11) DEFAULT NULL COMMENT '预留字段',

`is_deleted` tinyint(4) DEFAULT '0' COMMENT '是否删除',

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

# Dump of table saas_component_config

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

1

results matching ""

No results matching ""