Schema for database 'frey

frey_catalog

adm_message
adm_role
adm_user
adm_user_link_msg
adm_user_link_role
adm_user_log
adm_user_loginerr
adm_user_safeip
adm_work
adm_work_link_role
cd_make
cd_product
cd_product_company_link
change_log
ckv
company
competitor
competitor_price
cop_numidx
country
crm_area_country_link
crm_country
crm_country_link
etk_partitem
factory
factory_cate
factory_contact
files
grid_cfg
link_pair
m_cn_model
m_make
m_model
m_series
news
object
oe_item
oe_item_developno
oe_link
oe_model_cn_link
oe_model_link
oe_num_link
oe_numidx
oe_param_val
oe_pic
oe_tag_brand
part_param
part_param_sche
power
power_role_link
power_role_param_link
pro
pro_attaqty
pro_bom_assemble
pro_bom_pack
pro_brand
pro_brand_ext
pro_cate
pro_developno
pro_exchange
pro_exchange_model_numidx
pro_ext
pro_factory
pro_fatherson
pro_link_company
pro_masattaqty
pro_model_cn_link
pro_model_link
pro_numidx
pro_pack
pro_pack_ext
pro_pair
pro_param_strenval
pro_param_val
pro_pic
pro_rule_link
pro_source_link
pro_stock
pro_supplier
pro_synlog
pro_tag_brand
province_city
sms
supplier
supplier_cate
supplier_contact
supplier_pro
tag_brand
tag_brand_cnbrand
tag_brand_make
tags
tags_link
user
user_access
user_error
user_history
user_link_role
user_role
user_role_link_ids
user_role_link_mod
user_score
work_ask
work_ask_item
work_ask_item_log
work_ask_item_num
work_data_item
work_data_item_format
work_data_list
ztemp_init

adm_message

Fields

Field Type Collation Null Key Default Extra Privileges Comment

amsg_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

amsg_type

tinyint(4)

(NULL)

NO

0

select,insert,update,references

类型,(0:普通，1:事件, 3:预警)

amsg_from

varchar(20)

utf8mb4_unicode_ci

NO

select,insert,update,references

谁发的

amsg_title

varchar(255)

utf8mb4_unicode_ci

NO

select,insert,update,references

amsg_body

varchar(1024)

utf8mb4_unicode_ci

NO

select,insert,update,references

信息体

amsg_url

varchar(255)

utf8mb4_unicode_ci

NO

select,insert,update,references

操作网址

amsg_urltitle

varchar(255)

utf8mb4_unicode_ci

NO

select,insert,update,references

网址标题

amsg_file

varchar(255)

utf8mb4_unicode_ci

NO

select,insert,update,references

amsg_send_mail

tinyint(4)

(NULL)

NO

0

select,insert,update,references

是否需要发送邮件

amsg_send_sms

tinyint(4)

(NULL)

NO

0

select,insert,update,references

是否需要发送短信

amsg_event

tinyint(4)

(NULL)

NO

0

select,insert,update,references

处理事件标记

amsg_event_user

varchar(20)

utf8mb4_unicode_ci

NO

select,insert,update,references

处理事件的人

amsg_delete

tinyint(4)

(NULL)

NO

0

select,insert,update,references

虚删除

create_time

timestamp

(NULL)

NO

CURRENT_TIMESTAMP

select,insert,update,references

创建时间

update_time

timestamp

(NULL)

NO

CURRENT_TIMESTAMP

on update CURRENT_TIMESTAMP

select,insert,update,references

完成时间

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

adm_message

0

PRIMARY

1

amsg_id

A

8

(NULL)

(NULL)

BTREE

Back

adm_role

Fields

Field Type Collation Null Key Default Extra Privileges Comment

ar_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

角色ID

ar_name

varchar(100)

utf8mb4_unicode_ci

NO

(NULL)

select,insert,update,references

角色名称

ar_remark

varchar(255)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

角色描述

ar_model

enum('pdc','oppo','smart')

utf8mb4_unicode_ci

NO

pdc

select,insert,update,references

所属模块

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

adm_role

0

PRIMARY

1

ar_id

A

6

(NULL)

(NULL)

BTREE

Back

adm_user

Fields

Field Type Collation Null Key Default Extra Privileges Comment

au_id

varchar(20)

utf8_general_ci

NO

PRI

(NULL)

select,insert,update,references

用户名

au_pass

char(32)

utf8_general_ci

NO

(NULL)

select,insert,update,references

密码

au_name

varchar(20)

utf8_general_ci

NO

UNI

(NULL)

select,insert,update,references

姓名

au_depa

int(11)

(NULL)

YES

(NULL)

select,insert,update,references

部门

au_area

int(11)

(NULL)

YES

(NULL)

select,insert,update,references

区域(3)

au_jobno

varchar(50)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

工号

au_status

tinyint(4)

(NULL)

NO

1

select,insert,update,references

状态

au_email

varchar(50)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

邮箱

au_mobile

varchar(20)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

手机号

au_remark

varchar(255)

utf8_general_ci

YES

(NULL)

select,insert,update,references

备注

au_dlang

enum('cn_name','en_name')

utf8mb4_unicode_ci

NO

cn_name

select,insert,update,references

部分数据语言

au_menumini

tinyint(4)

(NULL)

NO

1

select,insert,update,references

左侧菜单是否默认展开

au_menumax

tinyint(4)

(NULL)

NO

1

select,insert,update,references

左侧菜单展开

au_menuopenone

tinyint(4)

(NULL)

NO

1

select,insert,update,references

左侧菜单只显示一栏

au_photobigtype

tinyint(4)

(NULL)

NO

0

select,insert,update,references

图片库大图展开简单模式

au_passupdatetime

timestamp

(NULL)

NO

CURRENT_TIMESTAMP

select,insert,update,references

密码修改时间

au_dingtalk_uid

varchar(64)

utf8mb4_unicode_ci

YES

MUL

select,insert,update,references

钉钉登陆用户ID标识

au_outid

varchar(32)

utf8_general_ci

YES

(NULL)

select,insert,update,references

外部登录键

au_model

enum('pdc','oppo')

utf8mb4_unicode_ci

NO

PRI

pdc

select,insert,update,references

所属于模块

create_time

timestamp

(NULL)

NO

CURRENT_TIMESTAMP

select,insert,update,references

update_time

timestamp

(NULL)

NO

CURRENT_TIMESTAMP

on update CURRENT_TIMESTAMP

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

adm_user

0

PRIMARY

1

au_id

A

29

(NULL)

(NULL)

BTREE

adm_user

0

PRIMARY

2

au_model

A

29

(NULL)

(NULL)

BTREE

adm_user

0

au_name

1

au_name

A

29

(NULL)

(NULL)

BTREE

adm_user

1

au_ding_unikey

1

au_dingtalk_uid

A

3

(NULL)

(NULL)

YES

BTREE

Back

adm_user_link_msg

Fields

Field Type Collation Null Key Default Extra Privileges Comment

aul_au_id

varchar(20)

utf8mb4_unicode_ci

NO

PRI

(NULL)

select,insert,update,references

用户ID

aul_amsg_id

int(11)

(NULL)

NO

PRI

(NULL)

select,insert,update,references

消息ID

aul_type

tinyint(4)

(NULL)

NO

0

select,insert,update,references

类型

aul_isread

tinyint(4)

(NULL)

NO

0

select,insert,update,references

是否已读

aul_read_time

timestamp

(NULL)

YES

(NULL)

select,insert,update,references

已读时间

aul_delete

tinyint(4)

(NULL)

NO

0

select,insert,update,references

虚删除

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

adm_user_link_msg

0

PRIMARY

1

aul_au_id

A

3

(NULL)

(NULL)

BTREE

adm_user_link_msg

0

PRIMARY

2

aul_amsg_id

A

10

(NULL)

(NULL)

BTREE

adm_user_link_msg

1

aul_au_id_read

1

aul_au_id

A

3

(NULL)

(NULL)

BTREE

adm_user_link_msg

1

aul_au_id_read

2

aul_isread

A

4

(NULL)

(NULL)

BTREE

Back

adm_user_link_role

Fields

Field Type Collation Null Key Default Extra Privileges Comment

aulr_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

ault_au_id

varchar(20)

utf8_general_ci

NO

MUL

(NULL)

select,insert,update,references

用户ID

ault_ar_id

int(11)

(NULL)

NO

MUL

(NULL)

select,insert,update,references

角色ID

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

adm_user_link_role

0

PRIMARY

1

aulr_id

A

37

(NULL)

(NULL)

BTREE

adm_user_link_role

0

ault_au_id

1

ault_au_id

A

27

(NULL)

(NULL)

BTREE

adm_user_link_role

0

ault_au_id

2

ault_ar_id

A

37

(NULL)

(NULL)

BTREE

adm_user_link_role

1

ault_ar_id

1

ault_ar_id

A

7

(NULL)

(NULL)

BTREE

Back

adm_user_log

Fields

Field Type Collation Null Key Default Extra Privileges Comment

aulog_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

aulog_uid

varchar(20)

utf8mb4_unicode_ci

NO

MUL

(NULL)

select,insert,update,references

aulog_ip

varchar(50)

utf8mb4_unicode_ci

NO

(NULL)

select,insert,update,references

aulog_address

varchar(255)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

aulog_op_type

varchar(50)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

aulog_op_content

varchar(1024)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

aulog_op_records

int(11)

(NULL)

NO

MUL

0

select,insert,update,references

aulog_create_time

timestamp

(NULL)

NO

CURRENT_TIMESTAMP

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

adm_user_log

0

PRIMARY

1

aulog_id

A

911

(NULL)

(NULL)

BTREE

adm_user_log

1

aulog_uid

1

aulog_uid

A

23

(NULL)

(NULL)

BTREE

adm_user_log

1

aulog_op_records

1

aulog_op_records

A

24

(NULL)

(NULL)

BTREE

Back

adm_user_loginerr

Fields

Field Type Collation Null Key Default Extra Privileges Comment

aul_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

aul_au_id

varchar(20)

utf8mb4_unicode_ci

NO

MUL

(NULL)

select,insert,update,references

用户名

aul_ip

varchar(50)

utf8mb4_unicode_ci

NO

select,insert,update,references

IP

aul_qty

int(11)

(NULL)

NO

(NULL)

select,insert,update,references

登录错误次数

create_time

timestamp

(NULL)

NO

CURRENT_TIMESTAMP

select,insert,update,references

update_time

timestamp

(NULL)

NO

CURRENT_TIMESTAMP

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

adm_user_loginerr

0

PRIMARY

1

aul_id

A

8

(NULL)

(NULL)

BTREE

adm_user_loginerr

1

aul_au_id

1

aul_au_id

A

3

(NULL)

(NULL)

BTREE

adm_user_loginerr

1

aul_au_id

2

aul_ip

A

8

(NULL)

(NULL)

BTREE

Back

adm_user_safeip

Fields

Field Type Collation Null Key Default Extra Privileges Comment

aus_ip

varchar(50)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

aus_address

varchar(1024)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

Indexes

Back

adm_work

Fields

Field Type Collation Null Key Default Extra Privileges Comment

aw_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

aw_name

varchar(50)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

工作节点

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

adm_work

0

PRIMARY

1

aw_id

A

0

(NULL)

(NULL)

BTREE

Back

adm_work_link_role

Fields

Field Type Collation Null Key Default Extra Privileges Comment

awr_aw_id

int(11)

(NULL)

NO

(NULL)

select,insert,update,references

工作节点ID

awr_ar_id

int(11)

(NULL)

NO

(NULL)

select,insert,update,references

角色ID

awr_cid

int(11)

(NULL)

NO

0

select,insert,update,references

品名ID

Indexes

Back

cd_make

Fields

Field Type Collation Null Key Default Extra Privileges Comment

cm_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

原平台的汽车厂商

cm_cn_name

varchar(250)

utf8_general_ci

YES

UNI

(NULL)

select,insert,update,references

品牌名称

cm_en_name

varchar(250)

utf8_general_ci

YES

(NULL)

select,insert,update,references

英文名称

cm_py_name

varchar(250)

utf8_general_ci

YES

(NULL)

select,insert,update,references

俄语名称

cm_sp_name

varchar(250)

utf8_general_ci

YES

(NULL)

select,insert,update,references

西语

cm_al_name

varchar(250)

utf8_general_ci

YES

select,insert,update,references

阿拉伯

cm_seq

int(11)

(NULL)

YES

10

select,insert,update,references

顺序

cm_from_id

int(11)

(NULL)

YES

0

select,insert,update,references

源ID

cm_opuser

varchar(20)

utf8_general_ci

YES

(NULL)

select,insert,update,references

cm_create_time

timestamp

(NULL)

YES

(NULL)

select,insert,update,references

cm_update_time

timestamp

(NULL)

YES

(NULL)

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

cd_make

0

PRIMARY

1

cm_id

A

117

(NULL)

(NULL)

BTREE

cd_make

0

l_name_zh

1

cm_cn_name

A

117

(NULL)

(NULL)

YES

BTREE

Back

cd_product

Fields

Field Type Collation Null Key Default Extra Privileges Comment

product_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

编号

company_type

tinyint(1)

(NULL)

YES

MUL

(NULL)

select,insert,update,references

物料所属中台 1:科技 2:菲尔 3:耐博德 4:科纳博

material_type

smallint(6)

(NULL)

YES

1

select,insert,update,references

物料类型

brand_id

smallint(6)

(NULL)

YES

MUL

4

select,insert,update,references

品牌选择

pid

int(11)

(NULL)

YES

0

select,insert,update,references

父级ID(以中性为主,SO品牌比较特殊)

pdc_tb_id

int(11)

(NULL)

YES

(NULL)

select,insert,update,references

PDM-汽车品牌ID(大类)

material_id

int(11)

(NULL)

YES

0

select,insert,update,references

材质表 0:无 cd_pdc_product_material

scm_no

varchar(250)

utf8_general_ci

YES

MUL

(NULL)

select,insert,update,references

集团编码

frey_no

varchar(64)

utf8_general_ci

YES

MUL

(NULL)

select,insert,update,references

物料编码

number

varchar(250)

utf8_general_ci

YES

MUL

(NULL)

select,insert,update,references

OE

l_name_zh

varchar(250)

utf8_general_ci

YES

(NULL)

select,insert,update,references

产品名称

l_name_en

varchar(250)

utf8_general_ci

YES

(NULL)

select,insert,update,references

英文名称

l_name_ru

varchar(250)

utf8_general_ci

YES

(NULL)

select,insert,update,references

俄文名称

l_name_es

varchar(255)

utf8_general_ci

YES

(NULL)

select,insert,update,references

西语名称

product_type_id

smallint(6)

(NULL)

YES

(NULL)

select,insert,update,references

产品所属类别

l_model_zh

text

utf8_general_ci

YES

(NULL)

select,insert,update,references

车型(中文

l_model_en

text

utf8_general_ci

YES

(NULL)

select,insert,update,references

车型(英文)

l_model_ru

text

utf8_general_ci

YES

(NULL)

select,insert,update,references

车型(俄文)

l_model_es

text

utf8_general_ci

YES

(NULL)

select,insert,update,references

车型（西语）

engines

text

utf8_general_ci

YES

(NULL)

select,insert,update,references

发动机

displacement

text

utf8_general_ci

YES

(NULL)

select,insert,update,references

排量

years

varchar(250)

utf8_general_ci

YES

(NULL)

select,insert,update,references

年限

hs_number

varchar(250)

utf8_general_ci

YES

(NULL)

select,insert,update,references

HS编码

customs_agent

varchar(255)

utf8_general_ci

YES

(NULL)

select,insert,update,references

报关单位

tax_name_1

varchar(250)

utf8_general_ci

YES

(NULL)

select,insert,update,references

开票名称1

tax_name_2

varchar(250)

utf8_general_ci

YES

(NULL)

select,insert,update,references

开票名称2

refund_rate

int(11)

(NULL)

YES

13

select,insert,update,references

可退税率

sap_unit

smallint(6)

(NULL)

YES

1

select,insert,update,references

基本单位

model_brand

smallint(6)

(NULL)

YES

(NULL)

select,insert,update,references

所属车型品牌

chassis

varchar(250)

utf8_general_ci

YES

(NULL)

select,insert,update,references

底盘

kingdee_id

varchar(250)

utf8_general_ci

YES

(NULL)

select,insert,update,references

金碟ID

cat_type

smallint(6)

(NULL)

YES

(NULL)

select,insert,update,references

燃油类型

l_remark_zh

text

utf8_general_ci

YES

(NULL)

select,insert,update,references

采购提醒(中文

l_remark_ru

text

utf8_general_ci

YES

(NULL)

select,insert,update,references

采购提醒(俄文

l_remark_en

text

utf8_general_ci

YES

(NULL)

select,insert,update,references

采购提醒(英文

l_remark_es

text

utf8_general_ci

YES

(NULL)

select,insert,update,references

采购提醒(西语

create_date

int(10) unsigned

(NULL)

YES

(NULL)

select,insert,update,references

创建日期

edit_date

int(10) unsigned

(NULL)

YES

(NULL)

select,insert,update,references

修改日期

delete_time

int(11)

(NULL)

YES

0

select,insert,update,references

删除时间

is_delete

tinyint(1)

(NULL)

YES

(NULL)

select,insert,update,references

是否删除 1:是 0:否

user_id

int(11)

(NULL)

YES

(NULL)

select,insert,update,references

创建用户id

upload_sap

smallint(6)

(NULL)

YES

0

select,insert,update,references

同步广州金蝶

sap_product_division

smallint(6)

(NULL)

YES

(NULL)

select,insert,update,references

产品组

frey_product_id

int(11)

(NULL)

YES

0

select,insert,update,references

菲尔产品ID

nibd_product_id

int(11)

(NULL)

YES

0

select,insert,update,references

耐博德产品ID

cnab_product_id

int(11)

(NULL)

YES

0

select,insert,update,references

科纳博产品ID

bc_product_id

int(11)

(NULL)

YES

0

select,insert,update,references

炳诚产品ID

l_spec_en

varchar(255)

utf8_general_ci

YES

(NULL)

select,insert,update,references

规格英文

l_spec_ru

varchar(255)

utf8_general_ci

YES

(NULL)

select,insert,update,references

俄文规格

l_spec_es

varchar(255)

utf8_general_ci

YES

(NULL)

select,insert,update,references

西语规格

gd_kingdee_id

varchar(250)

utf8_general_ci

YES

(NULL)

select,insert,update,references

广州金蝶集团id

status

varchar(255)

utf8_general_ci

YES

03

select,insert,update,references

状态

handel

tinyint(1)

(NULL)

YES

0

select,insert,update,references

处理状态

sap_stock

int(11)

(NULL)

YES

0

select,insert,update,references

月结sap库存

fixed_source

varchar(255)

utf8_general_ci

YES

(NULL)

select,insert,update,references

固定货源地

is_urgent

tinyint(4)

(NULL)

YES

0

select,insert,update,references

是否紧急 1：紧急 0：不紧急

is_research

tinyint(1)

(NULL)

YES

(NULL)

select,insert,update,references

是否内部研发 1:否 2:是

open_number

varchar(255)

utf8_general_ci

YES

(NULL)

select,insert,update,references

开发号

common_name

varchar(255)

utf8_general_ci

YES

select,insert,update,references

common_name

source

tinyint(1)

(NULL)

YES

1

select,insert,update,references

创建数据来源 1:科技中台 2:宜配

pdc_id

int(11)

(NULL)

YES

(NULL)

select,insert,update,references

PDM 主键

is_kit

tinyint(1)

(NULL)

YES

(NULL)

select,insert,update,references

PDM-是否套件 0:否 1:是

pdc_serial_number

varchar(255)

utf8_general_ci

YES

(NULL)

select,insert,update,references

PDM-物料流水号 PDC下推

pdc_car_brand

text

utf8_general_ci

YES

(NULL)

select,insert,update,references

PDM-汽车品牌(可分配汽车品牌)

main_status

varchar(255)

utf8_general_ci

YES

(NULL)

select,insert,update,references

PDM-主状态

status_remarks

varchar(255)

utf8_general_ci

YES

(NULL)

select,insert,update,references

PDM-状态备注

dev_status

varchar(255)

utf8_general_ci

YES

(NULL)

select,insert,update,references

PDM-开发状态

des_cn_name

text

utf8_general_ci

YES

(NULL)

select,insert,update,references

中文描述

des_en_name

text

utf8_general_ci

YES

(NULL)

select,insert,update,references

英文描述

des_ru_name

text

utf8_general_ci

YES

(NULL)

select,insert,update,references

俄文描述

des_es_name

text

utf8_general_ci

YES

(NULL)

select,insert,update,references

西语描述

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

cd_product

0

PRIMARY

1

product_id

A

136734

(NULL)

(NULL)

BTREE

cd_product

1

frey_no

1

frey_no

A

136746

(NULL)

(NULL)

YES

BTREE

cd_product

1

number

1

number

A

42430

(NULL)

(NULL)

YES

BTREE

cd_product

1

scm_no

1

scm_no

A

51765

(NULL)

(NULL)

YES

BTREE

cd_product

1

brand_id

1

brand_id

A

23

(NULL)

(NULL)

YES

BTREE

cd_product

1

company_type

1

company_type

A

4

(NULL)

(NULL)

YES

BTREE

Back

cd_product_company_link

Fields

Field Type Collation Null Key Default Extra Privileges Comment

link_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

编号

product_id

int(11)

(NULL)

YES

MUL

(NULL)

select,insert,update,references

所属产品

company_id

smallint(6)

(NULL)

YES

MUL

1

select,insert,update,references

公司ID

internation_code

varchar(255)

utf8_general_ci

YES

(NULL)

select,insert,update,references

国标码

l_spec_zh

varchar(255)

utf8_general_ci

YES

(NULL)

select,insert,update,references

产品规格

pur_group_id

smallint(6)

(NULL)

YES

(NULL)

select,insert,update,references

采购组

shelf_date

varchar(255)

utf8_general_ci

YES

(NULL)

select,insert,update,references

工厂质保期

shelf_id

int(11)

(NULL)

YES

(NULL)

select,insert,update,references

产品销售质保

print_text

varchar(255)

utf8_general_ci

YES

(NULL)

select,insert,update,references

是否工厂刻字

buyer_id

smallint(6)

(NULL)

YES

MUL

(NULL)

select,insert,update,references

采购跟单员

out_ward

varchar(255)

utf8_general_ci

YES

(NULL)

select,insert,update,references

外观处理

precautions

varchar(255)

utf8_general_ci

YES

(NULL)

select,insert,update,references

安装注意事项

outbox_id

varchar(255)

utf8_general_ci

YES

(NULL)

select,insert,update,references

外盒

box_id

varchar(255)

utf8_general_ci

YES

(NULL)

select,insert,update,references

内盒

bag_id

varchar(255)

utf8_general_ci

YES

(NULL)

select,insert,update,references

内袋

accessories_id

varchar(255)

utf8_general_ci

YES

(NULL)

select,insert,update,references

包装辅料

box_fcl_quantity

int(11)

(NULL)

YES

(NULL)

select,insert,update,references

内盒装盒数量

outbox_fcl_quantity

int(11)

(NULL)

YES

(NULL)

select,insert,update,references

外盒装盒数量

weight

decimal(10,3)

(NULL)

YES

(NULL)

select,insert,update,references

单个净重

fcl_gross_weight

decimal(10,2)

(NULL)

YES

(NULL)

select,insert,update,references

整箱毛重

one_gross_weight

decimal(10,2)

(NULL)

YES

(NULL)

select,insert,update,references

单个产品毛重

weight_unit

varchar(2)

utf8_general_ci

YES

02

select,insert,update,references

重量单位

pack_remark

varchar(255)

utf8_general_ci

YES

(NULL)

select,insert,update,references

装箱标准

pack_method

varchar(255)

utf8_general_ci

YES

(NULL)

select,insert,update,references

包装方式

bag_fcl_quantity

varchar(255)

utf8_general_ci

YES

(NULL)

select,insert,update,references

内袋装袋数

sale_status

int(11)

(NULL)

YES

(NULL)

select,insert,update,references

分配组员

label_id

varchar(255)

utf8_general_ci

YES

(NULL)

select,insert,update,references

标签

packaging_status

tinyint(1)

(NULL)

YES

(NULL)

select,insert,update,references

包装状态

print_car

varchar(250)

utf8_general_ci

YES

(NULL)

select,insert,update,references

打印车型

pack_remarks

tinytext

utf8_general_ci

YES

(NULL)

select,insert,update,references

外包方式备注

waiting_days

varchar(250)

utf8_general_ci

YES

(NULL)

select,insert,update,references

入仓日期

mnemonic_code

varchar(250)

utf8_general_ci

YES

(NULL)

select,insert,update,references

助记码（首选）

mnemonic_code_bak

varchar(250)

utf8_general_ci

YES

(NULL)

select,insert,update,references

助记码（备选）

project_manager_id

smallint(6)

(NULL)

YES

(NULL)

select,insert,update,references

备选采购跟单员

sqe_id

smallint(6)

(NULL)

YES

(NULL)

select,insert,update,references

SQE名称

classification

varchar(6)

utf8_general_ci

YES

(NULL)

select,insert,update,references

产品分类

status

smallint(6)

(NULL)

YES

MUL

1

select,insert,update,references

状态

safe_stock

int(11)

(NULL)

YES

(NULL)

select,insert,update,references

安全库存

top_stock

int(11)

(NULL)

YES

(NULL)

select,insert,update,references

库存上限

superintendent_id

smallint(6)

(NULL)

YES

(NULL)

select,insert,update,references

采购负责人

leader_id

smallint(6)

(NULL)

YES

(NULL)

select,insert,update,references

采购组长

create_time

int(11)

(NULL)

YES

(NULL)

select,insert,update,references

创建时间

post_time

int(11)

(NULL)

YES

(NULL)

select,insert,update,references

更新时间

delete_time

int(11)

(NULL)

YES

0

select,insert,update,references

删除时间

pd_status

varchar(6)

utf8_general_ci

YES

03

select,insert,update,references

产品状态

market_positioning

varchar(250)

utf8_general_ci

YES

(NULL)

select,insert,update,references

市场定位

gd_kingdee_id

varchar(250)

utf8_general_ci

YES

(NULL)

select,insert,update,references

广州金蝶ID

min_quantity

int(11)

(NULL)

YES

0

select,insert,update,references

最小起订量

planned_delivery_date

varchar(255)

utf8_general_ci

YES

(NULL)

select,insert,update,references

计划交期(天)

hhhh

tinyint(1)

(NULL)

YES

0

select,insert,update,references

finish_storage_time

int(11)

(NULL)

YES

(NULL)

select,insert,update,references

成品入库时间

beijing_safe_stock

int(11)

(NULL)

YES

0

select,insert,update,references

北京安全库存

beijing_top_stock

int(11)

(NULL)

YES

0

select,insert,update,references

北京库存上限

down_stock

int(11)

(NULL)

YES

0

select,insert,update,references

库存下限

hs_number

varchar(255)

utf8_general_ci

YES

(NULL)

select,insert,update,references

hs编码

tax_name_1

varchar(255)

utf8_general_ci

YES

(NULL)

select,insert,update,references

开票名称1

tax_name_2

varchar(255)

utf8_general_ci

YES

(NULL)

select,insert,update,references

开票名称2

customs_agent

varchar(255)

utf8_general_ci

YES

(NULL)

select,insert,update,references

报关单位

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

cd_product_company_link

0

PRIMARY

1

link_id

A

320228

(NULL)

(NULL)

BTREE

cd_product_company_link

0

company_id

1

company_id

A

9

(NULL)

(NULL)

YES

BTREE

cd_product_company_link

0

company_id

2

product_id

A

314288

(NULL)

(NULL)

YES

BTREE

cd_product_company_link

1

product_id

1

product_id

A

147688

(NULL)

(NULL)

YES

BTREE

cd_product_company_link

1

buyer_id

1

buyer_id

A

18

(NULL)

(NULL)

YES

BTREE

cd_product_company_link

1

status

1

status

A

2

(NULL)

(NULL)

YES

BTREE

Back

change_log

Fields

Field Type Collation Null Key Default Extra Privileges Comment

cl_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

数据变更历史

cl_type

varchar(16)

utf8mb4_unicode_ci

NO

MUL

(NULL)

select,insert,update,references

pro:产品相关 model:车型

cl_act

enum('add','edit','del','oth')

utf8mb4_unicode_ci

YES

MUL

edit

select,insert,update,references

变更类型

cl_dataid

int(11)

(NULL)

NO

MUL

(NULL)

select,insert,update,references

变更数据ID

cl_change

json

(NULL)

YES

(NULL)

select,insert,update,references

变更内容

cl_opuser

varchar(20)

utf8mb4_unicode_ci

YES

MUL

(NULL)

select,insert,update,references

cl_create_time

timestamp

(NULL)

YES

MUL

(NULL)

select,insert,update,references

变更时间

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

change_log

0

PRIMARY

1

cl_id

A

5

(NULL)

(NULL)

BTREE

change_log

1

cl_type

1

cl_type

A

3

(NULL)

(NULL)

BTREE

change_log

1

cl_dataid

1

cl_dataid

A

4

(NULL)

(NULL)

BTREE

change_log

1

cl_create_time

1

cl_create_time

A

5

(NULL)

(NULL)

YES

BTREE

change_log

1

cl_opuser

1

cl_opuser

A

2

(NULL)

(NULL)

YES

BTREE

change_log

1

cl_act

1

cl_act

A

2

(NULL)

(NULL)

YES

BTREE

Back

ckv

Fields

Field Type Collation Null Key Default Extra Privileges Comment

k

varchar(255)

utf8mb4_unicode_ci

NO

PRI

select,insert,update,references

键

u

varchar(20)

utf8mb4_unicode_ci

NO

PRI

select,insert,update,references

用户

v

json

(NULL)

YES

(NULL)

select,insert,update,references

值

remark

varchar(255)

utf8mb4_unicode_ci

NO

PRI

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

ckv

0

PRIMARY

1

k

A

2

(NULL)

(NULL)

BTREE

ckv

0

PRIMARY

2

u

A

2

(NULL)

(NULL)

BTREE

ckv

0

PRIMARY

3

remark

A

2

(NULL)

(NULL)

BTREE

Back

company

Fields

Field Type Collation Null Key Default Extra Privileges Comment

com_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

com_cn_name

varchar(200)

utf8mb4_unicode_ci

NO

select,insert,update,references

中文名称

com_en_name

varchar(200)

utf8mb4_unicode_ci

NO

select,insert,update,references

英文名称

com_py_name

varchar(200)

utf8mb4_unicode_ci

NO

select,insert,update,references

俄文名称

com_sp_name

varchar(200)

utf8mb4_unicode_ci

NO

select,insert,update,references

西班牙文名称

com_al_name

varchar(200)

utf8mb4_unicode_ci

NO

select,insert,update,references

西班牙文名称

com_seq

int(11)

(NULL)

NO

MUL

0

select,insert,update,references

排序

com_create_time

timestamp

(NULL)

YES

CURRENT_TIMESTAMP

on update CURRENT_TIMESTAMP

select,insert,update,references

com_update_time

timestamp

(NULL)

YES

(NULL)

select,insert,update,references

com_opuser

varchar(20)

utf8mb4_unicode_ci

NO

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

company

0

PRIMARY

1

com_id

A

8

(NULL)

(NULL)

BTREE

company

1

com_seq

1

com_seq

A

1

(NULL)

(NULL)

BTREE

Back

competitor

Fields

Field Type Collation Null Key Default Extra Privileges Comment

cor_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

竞争对手

cor_name

varchar(255)

utf8mb4_unicode_ci

NO

UNI

(NULL)

select,insert,update,references

名称

cor_level

int(11)

(NULL)

YES

MUL

0

select,insert,update,references

级别obj(19)

cor_remark

varchar(512)

utf8mb4_unicode_ci

NO

(NULL)

select,insert,update,references

备注

cor_info

longtext

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

简介

cor_opuser

varchar(20)

utf8mb4_unicode_ci

YES

MUL

(NULL)

select,insert,update,references

cor_create_time

timestamp

(NULL)

YES

(NULL)

select,insert,update,references

cor_update_time

timestamp

(NULL)

YES

(NULL)

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

competitor

0

PRIMARY

1

cor_id

A

2

(NULL)

(NULL)

BTREE

competitor

0

cor_name

1

cor_name

A

2

(NULL)

(NULL)

BTREE

competitor

1

cor_level

1

cor_level

A

1

(NULL)

(NULL)

YES

BTREE

competitor

1

cor_opuser

1

cor_opuser

A

1

(NULL)

(NULL)

YES

BTREE

Back

competitor_price

Fields

Field Type Collation Null Key Default Extra Privileges Comment

cop_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

竞品价格

cop_cor_id

int(11)

(NULL)

NO

MUL

0

select,insert,update,references

竞争对手ID

cop_oe_id

int(11)

(NULL)

YES

MUL

0

select,insert,update,references

零件库ID

cop_cat_id

int(11)

(NULL)

YES

MUL

0

select,insert,update,references

零件分类

cop_cop_num

varchar(128)

utf8mb4_unicode_ci

YES

MUL

select,insert,update,references

工厂号码

cop_pf_id

int(11)

(NULL)

NO

MUL

1

select,insert,update,references

号码厂商默认OE

cop_number

varchar(128)

utf8mb4_unicode_ci

NO

(NULL)

select,insert,update,references

cop_format

varchar(128)

utf8mb4_unicode_ci

NO

MUL

(NULL)

select,insert,update,references

cop_price

decimal(10,2)

(NULL)

YES

0.00

select,insert,update,references

批发价

cop_price_time

date

(NULL)

YES

(NULL)

select,insert,update,references

获取时间

cop_remark

varchar(255)

utf8mb4_unicode_ci

YES

select,insert,update,references

备注

cop_opuser

varchar(20)

utf8mb4_unicode_ci

YES

MUL

(NULL)

select,insert,update,references

cop_create_time

timestamp

(NULL)

YES

(NULL)

select,insert,update,references

cop_update_time

timestamp

(NULL)

YES

(NULL)

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

competitor_price

0

PRIMARY

1

cop_id

A

1394

(NULL)

(NULL)

BTREE

competitor_price

1

spr_num

1

cop_cor_id

A

2

(NULL)

(NULL)

BTREE

competitor_price

1

spr_num

2

cop_cat_id

A

17

(NULL)

(NULL)

YES

BTREE

competitor_price

1

spr_num

3

cop_pf_id

A

17

(NULL)

(NULL)

BTREE

competitor_price

1

spr_num

4

cop_format

A

17

(NULL)

(NULL)

BTREE

competitor_price

1

cop_oe_id

1

cop_oe_id

A

447

(NULL)

(NULL)

YES

BTREE

competitor_price

1

cop_cat_id

1

cop_cat_id

A

17

(NULL)

(NULL)

YES

BTREE

competitor_price

1

cop_cop_num

1

cop_cop_num

A

1

(NULL)

(NULL)

YES

BTREE

competitor_price

1

cop_pf_id

1

cop_pf_id

A

1

(NULL)

(NULL)

BTREE

competitor_price

1

cop_format

1

cop_format

A

2

(NULL)

(NULL)

BTREE

competitor_price

1

cop_opuser

1

cop_opuser

A

2

(NULL)

(NULL)

YES

BTREE

Back

cop_numidx

Fields

Field Type Collation Null Key Default Extra Privileges Comment

con_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

con_cop_id

int(11)

(NULL)

NO

MUL

(NULL)

select,insert,update,references

competitor_price 竞品价格ID

con_ismain

enum('Y','N')

utf8mb4_unicode_ci

YES

MUL

N

select,insert,update,references

主号码

con_pf_id

int(11)

(NULL)

YES

MUL

0

select,insert,update,references

号码品牌

con_number

varchar(60)

utf8mb4_unicode_ci

NO

(NULL)

select,insert,update,references

号码

con_formart

varchar(60)

utf8mb4_unicode_ci

NO

MUL

(NULL)

select,insert,update,references

格式化号码

con_opuser

varchar(20)

utf8mb4_unicode_ci

NO

select,insert,update,references

操作人

con_create_time

timestamp

(NULL)

NO

CURRENT_TIMESTAMP

select,insert,update,references

con_update_time

timestamp

(NULL)

NO

CURRENT_TIMESTAMP

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

cop_numidx

0

PRIMARY

1

con_id

A

1403

(NULL)

(NULL)

BTREE

cop_numidx

1

con_ismain

1

con_ismain

A

2

(NULL)

(NULL)

YES

BTREE

cop_numidx

1

con_formart

1

con_formart

A

1400

(NULL)

(NULL)

BTREE

cop_numidx

1

con_formart

2

con_pf_id

A

1400

(NULL)

(NULL)

YES

BTREE

cop_numidx

1

con_pf_id

1

con_pf_id

A

1

(NULL)

(NULL)

YES

BTREE

cop_numidx

1

con_cop_id

1

con_cop_id

A

1397

(NULL)

(NULL)

BTREE

cop_numidx

1

con_cop_id

2

con_ismain

A

1400

(NULL)

(NULL)

YES

BTREE

Back

country

Fields

Field Type Collation Null Key Default Extra Privileges Comment

cou_code

char(2)

utf8mb4_unicode_ci

NO

PRI

(NULL)

select,insert,update,references

cou_en_name

varchar(64)

utf8mb4_unicode_ci

NO

(NULL)

select,insert,update,references

cou_cn_name

varchar(128)

utf8mb4_unicode_ci

YES

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

country

0

PRIMARY

1

cou_code

A

244

(NULL)

(NULL)

BTREE

Back

crm_area_country_link

Fields

Field Type Collation Null Key Default Extra Privileges Comment

cacl_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

cacl_ca_id

int(11)

(NULL)

YES

(NULL)

select,insert,update,references

区域

cacl_cc_id

int(11)

(NULL)

NO

MUL

(NULL)

select,insert,update,references

国家

cacl_ischk

smallint(6)

(NULL)

YES

0

select,insert,update,references

默认勾选？

create_time

timestamp

(NULL)

NO

CURRENT_TIMESTAMP

select,insert,update,references

update_time

timestamp

(NULL)

NO

CURRENT_TIMESTAMP

on update CURRENT_TIMESTAMP

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

crm_area_country_link

0

PRIMARY

1

cacl_id

A

621

(NULL)

(NULL)

BTREE

crm_area_country_link

1

cacl_cc_id

1

cacl_cc_id

A

218

(NULL)

(NULL)

BTREE

crm_area_country_link

1

cacl_cc_id

2

cacl_ca_id

A

621

(NULL)

(NULL)

YES

BTREE

Back

crm_country

Fields

Field Type Collation Null Key Default Extra Privileges Comment

cc_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

cc_isend

smallint(6)

(NULL)

YES

MUL

1

select,insert,update,references

cc_code

char(3)

utf8mb4_unicode_ci

NO

(NULL)

select,insert,update,references

国家两位码区域3位码

cn_name

varchar(100)

utf8mb4_unicode_ci

NO

(NULL)

select,insert,update,references

en_name

varchar(100)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

cc_status

smallint(6)

(NULL)

YES

MUL

1

select,insert,update,references

1启用 0停用

cc_chkccids

json

(NULL)

YES

(NULL)

select,insert,update,references

默认选中的国家

cc_seq

int(11)

(NULL)

YES

MUL

999

select,insert,update,references

排序小到大

cc_type

smallint(6)

(NULL)

YES

MUL

1

select,insert,update,references

1实际区域(pdc) 2虚拟市场(smart)

opuser

varchar(20)

utf8mb4_unicode_ci

NO

(NULL)

select,insert,update,references

create_time

timestamp

(NULL)

NO

CURRENT_TIMESTAMP

select,insert,update,references

update_time

timestamp

(NULL)

NO

CURRENT_TIMESTAMP

on update CURRENT_TIMESTAMP

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

crm_country

0

PRIMARY

1

cc_id

A

284

(NULL)

(NULL)

BTREE

crm_country

1

cc_isend

1

cc_isend

A

2

(NULL)

(NULL)

YES

BTREE

crm_country

1

cc_type

1

cc_type

A

1

(NULL)

(NULL)

YES

BTREE

crm_country

1

cc_ischk

1

cc_status

A

1

(NULL)

(NULL)

YES

BTREE

crm_country

1

cc_seq

1

cc_seq

A

1

(NULL)

(NULL)

YES

BTREE

Back

crm_country_link

Fields

Field Type Collation Null Key Default Extra Privileges Comment

cl_type

enum('model','number','pro','poe')

utf8mb4_unicode_ci

NO

PRI

(NULL)

select,insert,update,references

模块

cl_value_id

int(11)

(NULL)

NO

PRI

(NULL)

select,insert,update,references

模块值ID

cl_cc_id

int(11)

(NULL)

NO

PRI

(NULL)

select,insert,update,references

国家ID crm_country

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

crm_country_link

0

PRIMARY

1

cl_type

A

530

(NULL)

(NULL)

BTREE

crm_country_link

0

PRIMARY

2

cl_value_id

A

590775

(NULL)

(NULL)

BTREE

crm_country_link

0

PRIMARY

3

cl_cc_id

A

13763262

(NULL)

(NULL)

BTREE

crm_country_link

1

cl_value_id

1

cl_value_id

A

105445

(NULL)

(NULL)

BTREE

crm_country_link

1

cl_cc_id

1

cl_cc_id

A

16533

(NULL)

(NULL)

BTREE

Back

etk_partitem

Fields

Field Type Collation Null Key Default Extra Privileges Comment

epa_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

EPC子组数据

epa_param

json

(NULL)

YES

(NULL)

select,insert,update,references

epa_param_unikey

varchar(32)

utf8mb4_unicode_ci

NO

UNI

(NULL)

select,insert,update,references

epa_partitem

json

(NULL)

YES

(NULL)

select,insert,update,references

epa_create_time

timestamp

(NULL)

NO

CURRENT_TIMESTAMP

on update CURRENT_TIMESTAMP

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

etk_partitem

0

PRIMARY

1

epa_id

A

23877

(NULL)

(NULL)

BTREE

etk_partitem

0

epa_param_unikey

1

epa_param_unikey

A

23877

(NULL)

(NULL)

BTREE

Back

factory

Fields

Field Type Collation Null Key Default Extra Privileges Comment

fac_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

工厂

fac_name

varchar(255)

utf8mb4_unicode_ci

NO

MUL

(NULL)

select,insert,update,references

全名

fac_alias

varchar(64)

utf8mb4_unicode_ci

NO

MUL

(NULL)

select,insert,update,references

简称

fac_code

varchar(16)

utf8mb4_unicode_ci

NO

UNI

(NULL)

select,insert,update,references

编码

fac_country

char(2)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

国家-country

fac_province_id

int(11)

(NULL)

YES

(NULL)

select,insert,update,references

省

fac_city_id

int(11)

(NULL)

YES

(NULL)

select,insert,update,references

市

fac_town_id

int(11)

(NULL)

YES

(NULL)

select,insert,update,references

区/镇

fac_follow_user

json

(NULL)

YES

(NULL)

select,insert,update,references

跟进人多选

fac_com_hy

varchar(255)

utf8mb4_unicode_ci

YES

select,insert,update,references

行业

fac_com_clsj

date

(NULL)

YES

(NULL)

select,insert,update,references

创立时间

fac_com_frdb

varchar(64)

utf8mb4_unicode_ci

YES

select,insert,update,references

法人代表

fac_com_zczj

int(11)

(NULL)

YES

0

select,insert,update,references

注册资金（万元）

fac_com_gsdj

varchar(255)

utf8mb4_unicode_ci

YES

select,insert,update,references

工商登记号

fac_com_uninum

varchar(255)

utf8mb4_unicode_ci

YES

select,insert,update,references

统一社会信用代码

fac_com_addr

varchar(255)

utf8mb4_unicode_ci

YES

select,insert,update,references

注册地址

fac_com_nsrsbh

varchar(255)

utf8mb4_unicode_ci

YES

select,insert,update,references

纳税人识别号

fac_com_nsrzz

varchar(255)

utf8mb4_unicode_ci

YES

select,insert,update,references

纳税人资质

fac_com_oldname

varchar(255)

utf8mb4_unicode_ci

YES

select,insert,update,references

曾用名

fac_com_enname

varchar(255)

utf8mb4_unicode_ci

YES

select,insert,update,references

英文名称

fac_com_worker

int(11)

(NULL)

YES

0

select,insert,update,references

人员规模

fac_com_status

varchar(32)

utf8mb4_unicode_ci

YES

select,insert,update,references

登记状态

fac_opuser

varchar(20)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

fac_create_time

timestamp

(NULL)

YES

(NULL)

select,insert,update,references

fac_update_time

timestamp

(NULL)

YES

(NULL)

select,insert,update,references

fac_resource_facid

varchar(36)

utf8mb4_unicode_ci

YES

MUL

select,insert,update,references

文档资源工厂ID

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

factory

0

PRIMARY

1

fac_id

A

0

(NULL)

(NULL)

BTREE

factory

0

fac_code

1

fac_code

A

0

(NULL)

(NULL)

BTREE

factory

1

fac_name

1

fac_name

A

0

(NULL)

(NULL)

BTREE

factory

1

fac_alias

1

fac_alias

A

0

(NULL)

(NULL)

BTREE

factory

1

fac_resource_facid

1

fac_resource_facid

A

0

(NULL)

(NULL)

YES

BTREE

Back

factory_cate

Fields

Field Type Collation Null Key Default Extra Privileges Comment

fc_fac_id

int(11)

(NULL)

NO

PRI

0

select,insert,update,references

工厂ID

fc_cat_id

int(11)

(NULL)

NO

PRI

0

select,insert,update,references

零件分类

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

factory_cate

0

PRIMARY

1

fc_fac_id

A

0

(NULL)

(NULL)

BTREE

factory_cate

0

PRIMARY

2

fc_cat_id

A

0

(NULL)

(NULL)

BTREE

Back

factory_contact

Fields

Field Type Collation Null Key Default Extra Privileges Comment

fco_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

工厂联系人

fco_fac_id

int(11)

(NULL)

NO

(NULL)

select,insert,update,references

工厂

fco_ismain

int(11)

(NULL)

NO

(NULL)

select,insert,update,references

主联系人

fco_name

varchar(255)

utf8mb4_unicode_ci

NO

(NULL)

select,insert,update,references

联系人

fco_phone

varchar(255)

utf8mb4_unicode_ci

YES

select,insert,update,references

手机

fco_tel

varchar(255)

utf8mb4_unicode_ci

YES

select,insert,update,references

电话

fco_job

varchar(255)

utf8mb4_unicode_ci

YES

select,insert,update,references

职位

fco_remark

varchar(512)

utf8mb4_unicode_ci

YES

select,insert,update,references

备注

fco_opuser

varchar(20)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

fco_create_time

timestamp

(NULL)

YES

(NULL)

select,insert,update,references

fco_update_time

timestamp

(NULL)

YES

(NULL)

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

factory_contact

0

PRIMARY

1

fco_id

A

0

(NULL)

(NULL)

BTREE

Back

files

Fields

Field Type Collation Null Key Default Extra Privileges Comment

fileid

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

filepath

varchar(255)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

路径

filebasename

varchar(64)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

文件名

filename

varchar(255)

utf8mb4_unicode_ci

NO

(NULL)

select,insert,update,references

完整文件名

fileextname

varchar(10)

utf8mb4_unicode_ci

NO

select,insert,update,references

扩展名

fileremark

varchar(255)

utf8mb4_unicode_ci

NO

MUL

select,insert,update,references

原始文件名

filetype

varchar(50)

utf8mb4_unicode_ci

NO

select,insert,update,references

类型 image|file

file_category

varchar(100)

utf8mb4_unicode_ci

NO

MUL

select,insert,update,references

配置

file_item

varchar(100)

utf8mb4_unicode_ci

NO

select,insert,update,references

配置

file_time

timestamp

(NULL)

NO

CURRENT_TIMESTAMP

on update CURRENT_TIMESTAMP

select,insert,update,references

上传时间

file_crc32

char(8)

utf8mb4_unicode_ci

YES

select,insert,update,references

CRC32

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

files

0

PRIMARY

1

fileid

A

154676

(NULL)

(NULL)

BTREE

files

1

file_category

1

file_category

A

1

(NULL)

(NULL)

BTREE

files

1

file_category

2

file_item

A

1

(NULL)

(NULL)

BTREE

files

1

fileremark

1

fileremark

A

104640

(NULL)

(NULL)

BTREE

Back

grid_cfg

Fields

Field Type Collation Null Key Default Extra Privileges Comment

gc_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

gc_uuid

varchar(255)

utf8mb4_unicode_ci

NO

MUL

(NULL)

select,insert,update,references

Grid 识别码

gc_user

varchar(20)

utf8mb4_unicode_ci

NO

(NULL)

select,insert,update,references

用户

gc_config

json

(NULL)

YES

(NULL)

select,insert,update,references

配置

create_time

timestamp

(NULL)

NO

CURRENT_TIMESTAMP

select,insert,update,references

update_time

timestamp

(NULL)

NO

CURRENT_TIMESTAMP

on update CURRENT_TIMESTAMP

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

grid_cfg

0

PRIMARY

1

gc_id

A

0

(NULL)

(NULL)

BTREE

grid_cfg

0

gc_uuid

1

gc_uuid

A

0

(NULL)

(NULL)

BTREE

grid_cfg

0

gc_uuid

2

gc_user

A

0

(NULL)

(NULL)

BTREE

Back

link_pair

Fields

Field Type Collation Null Key Default Extra Privileges Comment

lp_factory1

varchar(64)

utf8mb4_unicode_ci

NO

(NULL)

select,insert,update,references

lp_number1

varchar(64)

utf8mb4_unicode_ci

NO

(NULL)

select,insert,update,references

lp_format1

varchar(64)

utf8mb4_unicode_ci

NO

MUL

(NULL)

select,insert,update,references

lp_factory2

varchar(64)

utf8mb4_unicode_ci

NO

(NULL)

select,insert,update,references

lp_number2

varchar(64)

utf8mb4_unicode_ci

NO

(NULL)

select,insert,update,references

lp_format2

varbinary(64)

(NULL)

NO

MUL

(NULL)

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

link_pair

1

lp_format1

1

lp_format1

A

447874

(NULL)

(NULL)

BTREE

link_pair

1

lp_format1

2

lp_factory1

A

507239

(NULL)

(NULL)

BTREE

link_pair

1

lp_format2

1

lp_format2

A

575544

(NULL)

(NULL)

BTREE

link_pair

1

lp_format2

2

lp_factory2

A

558780

(NULL)

(NULL)

BTREE

Back

m_cn_model

Fields

Field Type Collation Null Key Default Extra Privileges Comment

mod3_id

int(11)

(NULL)

NO

PRI

(NULL)

select,insert,update,references

三级车型ID

brand_id

int(11)

(NULL)

NO

MUL

0

select,insert,update,references

品牌ID

brand_name

varchar(128)

utf8mb4_unicode_ci

NO

(NULL)

select,insert,update,references

品牌名称

brand_initial

varchar(16)

utf8mb4_unicode_ci

YES

select,insert,update,references

首字母

make_id

int(11)

(NULL)

NO

MUL

0

select,insert,update,references

生产商ID

make_name

varchar(128)

utf8mb4_unicode_ci

NO

(NULL)

select,insert,update,references

生产商名称

mod1_id

int(11)

(NULL)

NO

MUL

0

select,insert,update,references

一级车型ID

mod1_name

varchar(128)

utf8mb4_unicode_ci

NO

(NULL)

select,insert,update,references

一级车型名称

mod2_id

int(11)

(NULL)

NO

MUL

0

select,insert,update,references

上级车型ID

mod2_name

varchar(128)

utf8mb4_unicode_ci

NO

(NULL)

select,insert,update,references

上级车型名称

mod2_start_year

int(11)

(NULL)

YES

0

select,insert,update,references

开始年

mod2_end_year

int(11)

(NULL)

YES

0

select,insert,update,references

结束年份

mod2_pc

smallint(6)

(NULL)

YES

0

select,insert,update,references

乘用车

mod2_cv

smallint(6)

(NULL)

YES

0

select,insert,update,references

商用车

mod3_name

varchar(128)

utf8mb4_unicode_ci

NO

(NULL)

select,insert,update,references

车型名称

mod3_start_year

int(11)

(NULL)

YES

MUL

0

select,insert,update,references

开始年份

mod3_start_month

varchar(2)

utf8mb4_unicode_ci

YES

select,insert,update,references

开始月

mod3_end_year

int(11)

(NULL)

YES

MUL

0

select,insert,update,references

结束年份

mod3_end_month

varchar(2)

utf8mb4_unicode_ci

YES

select,insert,update,references

结束月

mod3_kw

varchar(32)

utf8mb4_unicode_ci

YES

MUL

select,insert,update,references

功率

mod3_cc

int(11)

(NULL)

YES

MUL

0

select,insert,update,references

排量

mod3_engine

varchar(255)

utf8mb4_unicode_ci

YES

MUL

select,insert,update,references

发动机

mod3_transmission

varchar(64)

utf8mb4_unicode_ci

YES

MUL

select,insert,update,references

变速器

mod3_fuel

varchar(64)

utf8mb4_unicode_ci

YES

MUL

select,insert,update,references

燃料

mod3_body

varchar(64)

utf8mb4_unicode_ci

YES

select,insert,update,references

车身形式

mod3_front_brake

varchar(64)

utf8mb4_unicode_ci

YES

select,insert,update,references

前制动器

mod3_rear_brake

varchar(64)

utf8mb4_unicode_ci

YES

select,insert,update,references

后制动器

mod3_parking_brake

varchar(64)

utf8mb4_unicode_ci

YES

select,insert,update,references

驻车制动

mod3_drive

varchar(64)

utf8mb4_unicode_ci

YES

MUL

select,insert,update,references

驱动方式

mod3_chassis

varchar(64)

utf8mb4_unicode_ci

YES

select,insert,update,references

底盘

mod3_atime

date

(NULL)

YES

MUL

(NULL)

select,insert,update,references

添加时间

mod3_etime

date

(NULL)

YES

MUL

(NULL)

select,insert,update,references

最后编辑时间

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

m_cn_model

0

PRIMARY

1

mod3_id

A

75996

(NULL)

(NULL)

BTREE

m_cn_model

1

idx_mod3_brand_id

1

brand_id

A

276

(NULL)

(NULL)

BTREE

m_cn_model

1

idx_mod3_make_id

1

make_id

A

299

(NULL)

(NULL)

BTREE

m_cn_model

1

idx_mod3_mod1_id

1

mod1_id

A

3212

(NULL)

(NULL)

BTREE

m_cn_model

1

idx_mod3_mod2_id

1

mod2_id

A

3299

(NULL)

(NULL)

BTREE

m_cn_model

1

mod3_atime

1

mod3_atime

A

1543

(NULL)

(NULL)

YES

BTREE

m_cn_model

1

mod3_cc

1

mod3_cc

A

549

(NULL)

(NULL)

YES

BTREE

m_cn_model

1

mod3_engine

1

mod3_engine

A

5848

(NULL)

(NULL)

YES

BTREE

m_cn_model

1

mod3_etime

1

mod3_etime

A

1534

(NULL)

(NULL)

YES

BTREE

m_cn_model

1

mod3_kw

1

mod3_kw

A

636

(NULL)

(NULL)

YES

BTREE

m_cn_model

1

mod3_start_year

1

mod3_start_year

A

29

(NULL)

(NULL)

YES

BTREE

m_cn_model

1

mod3_end_year

1

mod3_end_year

A

27

(NULL)

(NULL)

YES

BTREE

m_cn_model

1

mod3_fuel

1

mod3_fuel

A

43

(NULL)

(NULL)

YES

BTREE

m_cn_model

1

mod3_drive

1

mod3_drive

A

1

(NULL)

(NULL)

YES

BTREE

m_cn_model

1

mod3_transmission

1

mod3_transmission

A

73

(NULL)

(NULL)

YES

BTREE

Back

m_make

Fields

Field Type Collation Null Key Default Extra Privileges Comment

mk_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

mk_cn_name

varchar(100)

utf8mb4_unicode_ci

NO

MUL

(NULL)

select,insert,update,references

mk_en_name

varchar(100)

utf8mb4_unicode_ci

YES

MUL

(NULL)

select,insert,update,references

mk_py_name

varchar(100)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

mk_ypmfa_id

int(11)

(NULL)

YES

MUL

0

select,insert,update,references

宜配TCD车型库ID

opuser

varchar(20)

utf8mb4_unicode_ci

NO

MUL

(NULL)

select,insert,update,references

create_time

timestamp

(NULL)

NO

MUL

CURRENT_TIMESTAMP

on update CURRENT_TIMESTAMP

select,insert,update,references

update_time

timestamp

(NULL)

NO

MUL

CURRENT_TIMESTAMP

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

m_make

0

PRIMARY

1

mk_id

A

1148

(NULL)

(NULL)

BTREE

m_make

1

name

1

mk_cn_name

A

1146

(NULL)

(NULL)

BTREE

m_make

1

opuser

1

opuser

A

1

(NULL)

(NULL)

BTREE

m_make

1

create_time

1

create_time

A

1

(NULL)

(NULL)

BTREE

m_make

1

update_time

1

update_time

A

1

(NULL)

(NULL)

BTREE

m_make

1

mk_en_name

1

mk_en_name

A

1148

(NULL)

(NULL)

YES

BTREE

m_make

1

mk_ypmfa_id

1

mk_ypmfa_id

A

1148

(NULL)

(NULL)

YES

BTREE

Back

m_model

Fields

Field Type Collation Null Key Default Extra Privileges Comment

mm_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

mm_mk_id

int(11)

(NULL)

NO

MUL

(NULL)

select,insert,update,references

品牌ID

mm_ms_id

int(11)

(NULL)

NO

MUL

(NULL)

select,insert,update,references

车系ID

mm_from

enum('manual','ktype','ntype')

utf8mb4_unicode_ci

YES

manual

select,insert,update,references

来源

mm_from_id

int(11)

(NULL)

YES

0

select,insert,update,references

来源ID

mm_name

varchar(255)

utf8mb4_unicode_ci

NO

MUL

(NULL)

select,insert,update,references

车型名称

mm_year_from

int(11)

(NULL)

YES

0

select,insert,update,references

年开始

mm_month_from

int(11)

(NULL)

YES

0

select,insert,update,references

月开始

mm_year_to

int(11)

(NULL)

YES

0

select,insert,update,references

年结束

mm_month_to

int(11)

(NULL)

YES

0

select,insert,update,references

月结束

mm_engine

varchar(255)

utf8mb4_unicode_ci

YES

MUL

select,insert,update,references

Enginecode发动机号

mm_kw

varchar(50)

utf8mb4_unicode_ci

YES

MUL

select,insert,update,references

功率

mm_hp

varchar(50)

utf8mb4_unicode_ci

YES

MUL

select,insert,update,references

马力

mm_fuel

varchar(50)

utf8mb4_unicode_ci

YES

MUL

select,insert,update,references

燃料

mm_cc

varchar(50)

utf8mb4_unicode_ci

YES

MUL

select,insert,update,references

排量

mm_cylinders

varchar(50)

utf8mb4_unicode_ci

YES

MUL

select,insert,update,references

缸数

mm_drive

varchar(50)

utf8mb4_unicode_ci

YES

MUL

select,insert,update,references

驱动

mm_body

varchar(50)

utf8mb4_unicode_ci

YES

MUL

select,insert,update,references

车身

mm_doors

varchar(255)

utf8mb4_unicode_ci

YES

MUL

select,insert,update,references

门数

mm_yptyp_id

int(11)

(NULL)

YES

MUL

0

select,insert,update,references

宜配TCD车型库ID

opuser

varchar(20)

utf8mb4_unicode_ci

YES

select,insert,update,references

操作人

create_time

timestamp

(NULL)

NO

MUL

CURRENT_TIMESTAMP

select,insert,update,references

update_time

timestamp

(NULL)

NO

MUL

CURRENT_TIMESTAMP

on update CURRENT_TIMESTAMP

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

m_model

0

PRIMARY

1

mm_id

A

163752

(NULL)

(NULL)

BTREE

m_model

1

mm_mk_id

1

mm_mk_id

A

1056

(NULL)

(NULL)

BTREE

m_model

1

mm_ms_id

1

mm_ms_id

A

24331

(NULL)

(NULL)

BTREE

m_model

1

mm_fuel

1

mm_fuel

A

17

(NULL)

(NULL)

YES

BTREE

m_model

1

mm_disp

1

mm_cc

A

2881

(NULL)

(NULL)

YES

BTREE

m_model

1

mm_engine

1

mm_engine

A

22108

(NULL)

(NULL)

YES

BTREE

m_model

1

mm_kw

1

mm_kw

A

566

(NULL)

(NULL)

YES

BTREE

m_model

1

mm_hp

1

mm_hp

A

621

(NULL)

(NULL)

YES

BTREE

m_model

1

mm_cylinders

1

mm_cylinders

A

10

(NULL)

(NULL)

YES

BTREE

m_model

1

mm_drive_type

1

mm_drive

A

9

(NULL)

(NULL)

YES

BTREE

m_model

1

mm_body

1

mm_body

A

24

(NULL)

(NULL)

YES

BTREE

m_model

1

mm_doors

1

mm_doors

A

4

(NULL)

(NULL)

YES

BTREE

m_model

1

create_time

1

create_time

A

1

(NULL)

(NULL)

BTREE

m_model

1

update_time

1

update_time

A

1

(NULL)

(NULL)

BTREE

m_model

1

link_id

1

mm_id

A

163752

(NULL)

(NULL)

BTREE

m_model

1

link_id

2

mm_ms_id

A

163752

(NULL)

(NULL)

BTREE

m_model

1

link_id

3

mm_mk_id

A

163752

(NULL)

(NULL)

BTREE

m_model

1

name

1

mm_name

A

46491

(NULL)

(NULL)

BTREE

m_model

1

mm_yptyp_id

1

mm_yptyp_id

A

163752

(NULL)

(NULL)

YES

BTREE

Back

m_series

Fields

Field Type Collation Null Key Default Extra Privileges Comment

ms_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

ms_mk_id

int(11)

(NULL)

NO

MUL

(NULL)

select,insert,update,references

汽车品牌ID

ms_name

varchar(255)

utf8mb4_unicode_ci

NO

MUL

(NULL)

select,insert,update,references

车系

ms_minname

varchar(255)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

短名

ms_yptcd_id

int(11)

(NULL)

YES

MUL

0

select,insert,update,references

宜配TCD车型库ID

ms_chassis

varchar(64)

utf8mb4_unicode_ci

YES

select,insert,update,references

底盘

ms_pc

smallint(6)

(NULL)

YES

MUL

0

select,insert,update,references

乘用车

ms_cv

smallint(6)

(NULL)

YES

MUL

0

select,insert,update,references

商用车

opuser

varchar(20)

utf8mb4_unicode_ci

NO

MUL

(NULL)

select,insert,update,references

create_time

timestamp

(NULL)

NO

MUL

CURRENT_TIMESTAMP

on update CURRENT_TIMESTAMP

select,insert,update,references

update_time

timestamp

(NULL)

NO

MUL

CURRENT_TIMESTAMP

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

m_series

0

PRIMARY

1

ms_id

A

21362

(NULL)

(NULL)

BTREE

m_series

1

ms_mk_id

1

ms_mk_id

A

1148

(NULL)

(NULL)

BTREE

m_series

1

opuser

1

opuser

A

1

(NULL)

(NULL)

BTREE

m_series

1

create_time

1

create_time

A

1

(NULL)

(NULL)

BTREE

m_series

1

update_time

1

update_time

A

1

(NULL)

(NULL)

BTREE

m_series

1

ms_name

1

ms_name

A

16146

(NULL)

(NULL)

BTREE

m_series

1

ms_yptcd_id

1

ms_yptcd_id

A

20763

(NULL)

(NULL)

YES

BTREE

m_series

1

ms_pc

1

ms_pc

A

2

(NULL)

(NULL)

YES

BTREE

m_series

1

ms_cv

1

ms_cv

A

2

(NULL)

(NULL)

YES

BTREE

Back

news

Fields

Field Type Collation Null Key Default Extra Privileges Comment

news_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

news_cate_id

int(11)

(NULL)

NO

0

select,insert,update,references

分类ID

news_title

varchar(255)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

news_remark

mediumtext

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

内容

news_archive

tinyint(1)

(NULL)

NO

0

select,insert,update,references

是否是文档

news_is_allow

tinyint(4)

(NULL)

NO

0

select,insert,update,references

0:禁用,1:允许

opuser

varchar(20)

utf8mb4_unicode_ci

YES

select,insert,update,references

news_create_time

timestamp

(NULL)

YES

(NULL)

select,insert,update,references

news_update_time

timestamp

(NULL)

YES

(NULL)

select,insert,update,references

news_file

varchar(512)

utf8mb4_unicode_ci

YES

[]

select,insert,update,references

附件

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

news

0

PRIMARY

1

news_id

A

0

(NULL)

(NULL)

BTREE

Back

object

Fields

Field Type Collation Null Key Default Extra Privileges Comment

o_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

o_parent_id

int(11)

(NULL)

NO

MUL

0

select,insert,update,references

code

varchar(50)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

cn_name

varchar(255)

utf8mb4_unicode_ci

NO

MUL

(NULL)

select,insert,update,references

名称

en_name

varchar(255)

utf8mb4_unicode_ci

YES

select,insert,update,references

py_name

varchar(255)

utf8mb4_unicode_ci

YES

select,insert,update,references

sp_name

varchar(255)

utf8mb4_unicode_ci

YES

select,insert,update,references

西语

al_name

varchar(255)

utf8mb4_unicode_ci

YES

select,insert,update,references

阿拉伯

o_keyword

varchar(255)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

用于查询

o_level

int(11)

(NULL)

NO

MUL

0

select,insert,update,references

o_lft

int(11)

(NULL)

NO

MUL

0

select,insert,update,references

o_rgt

int(11)

(NULL)

NO

MUL

0

select,insert,update,references

o_ismove

tinyint(1)

(NULL)

NO

0

select,insert,update,references

o_sort

int(11)

(NULL)

NO

MUL

0

select,insert,update,references

o_root

tinyint(4)

(NULL)

NO

0

select,insert,update,references

是否是根

o_list_pagesize

int(11)

(NULL)

NO

0

select,insert,update,references

列表一页默认显示多少条

o_children_level

tinyint(4)

(NULL)

NO

0

select,insert,update,references

子节点的层级约束,-1为无限级,0为只有一级

o_is_init

tinyint(4)

(NULL)

NO

0

select,insert,update,references

是否为初始化值

o_has_code

tinyint(4)

(NULL)

NO

0

select,insert,update,references

是否需要编码

o_from_id

int(11)

(NULL)

YES

0

select,insert,update,references

源 ID

create_time

timestamp

(NULL)

NO

CURRENT_TIMESTAMP

on update CURRENT_TIMESTAMP

select,insert,update,references

update_time

timestamp

(NULL)

NO

CURRENT_TIMESTAMP

on update CURRENT_TIMESTAMP

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

object

0

PRIMARY

1

o_id

A

119

(NULL)

(NULL)

BTREE

object

1

o_parent_id

1

o_parent_id

A

26

(NULL)

(NULL)

BTREE

object

1

o_lft

1

o_lft

A

119

(NULL)

(NULL)

BTREE

object

1

o_rgt

1

o_rgt

A

119

(NULL)

(NULL)

BTREE

object

1

o_level

1

o_level

A

3

(NULL)

(NULL)

BTREE

object

1

o_sort

1

o_sort

A

4

(NULL)

(NULL)

BTREE

object

1

o_name

1

cn_name

A

117

215

(NULL)

BTREE

Back

oe_item

Fields

Field Type Collation Null Key Default Extra Privileges Comment

oe_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

oe_pf_id

int(11)

(NULL)

YES

1

select,insert,update,references

主号厂商

oe_oe

varchar(60)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

主号

oe_oe_format

varchar(60)

utf8mb4_unicode_ci

YES

MUL

(NULL)

select,insert,update,references

主号格式化

oe_pic

int(11)

(NULL)

YES

MUL

0

select,insert,update,references

主图

oe_linepic

int(11)

(NULL)

YES

0

select,insert,update,references

主图纸

oe_cate_id

int(11)

(NULL)

YES

MUL

(NULL)

select,insert,update,references

品类 pro_cate

oe_cn_name

varchar(100)

utf8mb4_unicode_ci

YES

select,insert,update,references

产品中文名

oe_en_name

varchar(100)

utf8mb4_unicode_ci

YES

select,insert,update,references

产品英文名

oe_py_name

varchar(100)

utf8mb4_unicode_ci

YES

select,insert,update,references

产品俄文名

oe_sp_name

varchar(100)

utf8mb4_unicode_ci

YES

select,insert,update,references

产品西语名

oe_al_name

varchar(100)

utf8mb4_unicode_ci

YES

select,insert,update,references

产品阿拉伯名

oe_unit

int(11)

(NULL)

YES

0

select,insert,update,references

基本单位 obj(2)

oe_amount

int(11)

(NULL)

YES

0

select,insert,update,references

用量

oe_model_cn_name

varchar(200)

utf8mb4_unicode_ci

YES

select,insert,update,references

车型中文

oe_model_en_name

varchar(200)

utf8mb4_unicode_ci

YES

select,insert,update,references

车型英文

oe_model_py_name

varchar(200)

utf8mb4_unicode_ci

YES

select,insert,update,references

车型俄文

oe_model_sp_name

varchar(200)

utf8mb4_unicode_ci

YES

select,insert,update,references

车型西语名

oe_model_al_name

varchar(200)

utf8mb4_unicode_ci

YES

select,insert,update,references

车型阿拉伯名

oe_des_cn_name

varchar(200)

utf8mb4_unicode_ci

YES

select,insert,update,references

描述中文

oe_des_en_name

varchar(200)

utf8mb4_unicode_ci

YES

select,insert,update,references

描述英文

oe_des_py_name

varchar(200)

utf8mb4_unicode_ci

YES

select,insert,update,references

描述俄文

oe_des_sp_name

varchar(200)

utf8mb4_unicode_ci

YES

select,insert,update,references

描述西语名

oe_des_al_name

varchar(200)

utf8mb4_unicode_ci

YES

select,insert,update,references

描述阿拉伯名

oe_chassis

varchar(100)

utf8mb4_unicode_ci

YES

select,insert,update,references

底盘

oe_engine

varchar(255)

utf8mb4_unicode_ci

YES

select,insert,update,references

发动机

oe_fuel_type

int(11)

(NULL)

YES

(NULL)

select,insert,update,references

[原]燃油类型 obj(5)

oe_cc

varchar(255)

utf8mb4_unicode_ci

YES

select,insert,update,references

[原]排量

oe_model_year

varchar(255)

utf8mb4_unicode_ci

YES

select,insert,update,references

车型年限

oe_isdevelop

smallint(6)

(NULL)

YES

(NULL)

select,insert,update,references

是否内部研发

oe_develop_status

int(11)

(NULL)

YES

0

select,insert,update,references

开发状态obj(17)

oe_para

json

(NULL)

YES

(NULL)

select,insert,update,references

参数

oe_pos1

varchar(64)

utf8mb4_unicode_ci

NO

select,insert,update,references

前/后轴

oe_pos2

varchar(64)

utf8mb4_unicode_ci

NO

select,insert,update,references

前/后

oe_pos3

varchar(64)

utf8mb4_unicode_ci

NO

select,insert,update,references

左/右

oe_pos4

varchar(64)

utf8mb4_unicode_ci

NO

select,insert,update,references

外/中/内

oe_pos5

varchar(64)

utf8mb4_unicode_ci

NO

select,insert,update,references

上/中/下

oe_opuser

varchar(20)

utf8mb4_unicode_ci

YES

MUL

(NULL)

select,insert,update,references

oe_create_time

timestamp

(NULL)

YES

(NULL)

select,insert,update,references

oe_update_time

timestamp

(NULL)

YES

(NULL)

select,insert,update,references

ck1

smallint(6)

(NULL)

YES

(NULL)

select,insert,update,references

初审状态 -1不通过 0待审 1审核通过

ckuser1

varchar(20)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

初审核人

cktime1

timestamp

(NULL)

YES

(NULL)

select,insert,update,references

初审核时间

ckremark1

varchar(255)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

初审核备注

oe_wdi_id

int(11)

(NULL)

YES

MUL

(NULL)

select,insert,update,references

数据工单明细ID work_data_item

oe_chkpro_from

varchar(16)

utf8mb4_unicode_ci

YES

select,insert,update,references

参考产品来源

oe_chkpro_id

int(11)

(NULL)

YES

0

select,insert,update,references

参考产品ID

oe_chkpro_info

json

(NULL)

YES

(NULL)

select,insert,update,references

参考产品的基本信息wdi_chkpro_from!=self

oe_etk_info

json

(NULL)

YES

(NULL)

select,insert,update,references

EPC信息

oe_etk_epa_id

int(11)

(NULL)

YES

MUL

0

select,insert,update,references

EPC子组信息 oe_etk_epa_id

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

oe_item

0

PRIMARY

1

oe_id

A

39004

(NULL)

(NULL)

BTREE

oe_item

1

oe_oe_format

1

oe_oe_format

A

39005

(NULL)

(NULL)

YES

BTREE

oe_item

1

oe_oe_format

2

oe_pf_id

A

39005

(NULL)

(NULL)

YES

BTREE

oe_item

1

oe_opuser

1

oe_opuser

A

4

(NULL)

(NULL)

YES

BTREE

oe_item

1

oe_pic

1

oe_pic

A

37813

(NULL)

(NULL)

YES

BTREE

oe_item

1

oe_cate_id

1

oe_cate_id

A

379

(NULL)

(NULL)

YES

BTREE

oe_item

1

ck1

1

oe_id

A

39005

(NULL)

(NULL)

BTREE

oe_item

1

ck1

2

ck1

A

39005

(NULL)

(NULL)

YES

BTREE

oe_item

1

oe_wdi_id

1

oe_wdi_id

A

39005

(NULL)

(NULL)

YES

BTREE

oe_item

1

oe_etk_epa_id

1

oe_etk_epa_id

A

25265

(NULL)

(NULL)

YES

BTREE

Back

oe_item_developno

Fields

Field Type Collation Null Key Default Extra Privileges Comment

oid_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

零件开发号

oid_oe_id

int(11)

(NULL)

NO

MUL

(NULL)

select,insert,update,references

零件ID

oid_number

varchar(64)

utf8mb4_unicode_ci

NO

(NULL)

select,insert,update,references

oid_format

varchar(64)

utf8mb4_unicode_ci

NO

MUL

(NULL)

select,insert,update,references

号码

oid_sup_id

int(11)

(NULL)

NO

0

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

oe_item_developno

0

PRIMARY

1

oid_id

A

152

(NULL)

(NULL)

BTREE

oe_item_developno

1

oid_oe_id

1

oid_oe_id

A

152

(NULL)

(NULL)

BTREE

oe_item_developno

1

oid_format

1

oid_format

A

152

(NULL)

(NULL)

BTREE

Back

oe_link

Fields

Field Type Collation Null Key Default Extra Privileges Comment

ol_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

零年关联号码

ol_type

enum('link','pair')

utf8mb4_unicode_ci

NO

MUL

(NULL)

select,insert,update,references

link:关联 pair:配对

ol_oe_id1

int(11)

(NULL)

YES

MUL

0

select,insert,update,references

零件ID

ol_oe_id2

int(11)

(NULL)

YES

MUL

0

select,insert,update,references

关联零件ID 可先导入定时刷ID

ol_pf_id1

int(11)

(NULL)

YES

0

select,insert,update,references

ol_number1

varchar(64)

utf8mb4_unicode_ci

YES

select,insert,update,references

源号码

ol_format1

varchar(64)

utf8mb4_unicode_ci

YES

select,insert,update,references

ol_pf_id2

int(11)

(NULL)

YES

0

select,insert,update,references

ol_number2

varchar(64)

utf8mb4_unicode_ci

YES

select,insert,update,references

关联号码

ol_format2

varchar(64)

utf8mb4_unicode_ci

YES

MUL

select,insert,update,references

号码

ol_from

int(11)

(NULL)

YES

0

select,insert,update,references

数据来源(13)

ol_opuser

varchar(20)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

ol_create_time

timestamp

(NULL)

YES

(NULL)

select,insert,update,references

ol_update_time

timestamp

(NULL)

YES

(NULL)

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

oe_link

0

PRIMARY

1

ol_id

A

548376

(NULL)

(NULL)

BTREE

oe_link

1

ol_type

1

ol_type

A

1

(NULL)

(NULL)

BTREE

oe_link

1

ol_oe_id1

1

ol_oe_id1

A

24528

(NULL)

(NULL)

YES

BTREE

oe_link

1

ol_oe_id2

1

ol_oe_id2

A

10604

(NULL)

(NULL)

YES

BTREE

oe_link

1

ol_format2

1

ol_format2

A

147429

(NULL)

(NULL)

YES

BTREE

Back

oe_model_cn_link

Fields

Field Type Collation Null Key Default Extra Privileges Comment

oml_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

中国适用车型

oml_oe_id

int(11)

(NULL)

NO

MUL

(NULL)

select,insert,update,references

OE ID

oml_mod3_id

int(11)

(NULL)

NO

MUL

(NULL)

select,insert,update,references

中国车型ID

oml_remark

varchar(255)

utf8mb4_unicode_ci

YES

select,insert,update,references

车型备注

oml_from

int(11)

(NULL)

YES

99

select,insert,update,references

数据来源(13)

oml_opuser

varchar(20)

utf8mb4_unicode_ci

NO

(NULL)

select,insert,update,references

oml_create_time

timestamp

(NULL)

YES

(NULL)

select,insert,update,references

oml_update_time

timestamp

(NULL)

YES

(NULL)

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

oe_model_cn_link

0

PRIMARY

1

oml_id

A

1554072

(NULL)

(NULL)

BTREE

oe_model_cn_link

0

uni_mod

1

oml_oe_id

A

22133

(NULL)

(NULL)

BTREE

oe_model_cn_link

0

uni_mod

2

oml_mod3_id

A

1495564

(NULL)

(NULL)

BTREE

oe_model_cn_link

1

oml_mm_id_2

1

oml_mod3_id

A

15376

(NULL)

(NULL)

BTREE

Back

oe_model_link

Fields

Field Type Collation Null Key Default Extra Privileges Comment

oml_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

国际适用车型

oml_oe_id

int(11)

(NULL)

NO

MUL

(NULL)

select,insert,update,references

OE ID

oml_mm_id

int(11)

(NULL)

NO

MUL

(NULL)

select,insert,update,references

车型ID

oml_remark

varchar(255)

utf8mb4_unicode_ci

YES

select,insert,update,references

车型备注

oml_para

json

(NULL)

YES

(NULL)

select,insert,update,references

车型参数

oml_from

int(11)

(NULL)

YES

99

select,insert,update,references

数据来源(13)

oml_opuser

varchar(20)

utf8mb4_unicode_ci

NO

(NULL)

select,insert,update,references

oml_create_time

timestamp

(NULL)

YES

(NULL)

select,insert,update,references

oml_update_time

timestamp

(NULL)

YES

(NULL)

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

oe_model_link

0

PRIMARY

1

oml_id

A

2448674

(NULL)

(NULL)

BTREE

oe_model_link

0

uni_mod

1

oml_oe_id

A

21644

(NULL)

(NULL)

BTREE

oe_model_link

0

uni_mod

2

oml_mm_id

A

2179454

(NULL)

(NULL)

BTREE

oe_model_link

1

oml_mm_id_2

1

oml_mm_id

A

129762

(NULL)

(NULL)

BTREE

Back

oe_num_link

Fields

Field Type Collation Null Key Default Extra Privileges Comment

onl_id

int(11)

(NULL)

NO

PRI

(NULL)

select,insert,update,references

零年关联号码

onl_oe_id

int(11)

(NULL)

YES

MUL

(NULL)

select,insert,update,references

零件ID

onl_number

varchar(64)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

onl_format

varchar(64)

utf8mb4_unicode_ci

YES

MUL

(NULL)

select,insert,update,references

号码

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

oe_num_link

0

PRIMARY

1

onl_id

A

0

(NULL)

(NULL)

BTREE

oe_num_link

1

onl_format

1

onl_format

A

0

(NULL)

(NULL)

YES

BTREE

oe_num_link

1

onl_oe_id

1

onl_oe_id

A

0

(NULL)

(NULL)

YES

BTREE

Back

oe_numidx

Fields

Field Type Collation Null Key Default Extra Privileges Comment

on_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

on_oe_id

int(11)

(NULL)

NO

MUL

(NULL)

select,insert,update,references

产品ID

on_ismain

enum('Y','N')

utf8mb4_unicode_ci

YES

MUL

N

select,insert,update,references

主号码

on_pf_id

int(11)

(NULL)

NO

MUL

(NULL)

select,insert,update,references

号码品牌

on_number

varchar(60)

utf8mb4_unicode_ci

NO

(NULL)

select,insert,update,references

号码

on_formart

varchar(60)

utf8mb4_unicode_ci

NO

MUL

(NULL)

select,insert,update,references

格式化号码

on_mk_id

varchar(64)

utf8mb4_unicode_ci

NO

select,insert,update,references

OE品牌多个逗号分隔

on_from

int(11)

(NULL)

YES

99

select,insert,update,references

数据来源(13)

on_opuser

varchar(20)

utf8mb4_unicode_ci

NO

select,insert,update,references

操作人

on_create_time

timestamp

(NULL)

NO

CURRENT_TIMESTAMP

select,insert,update,references

on_update_time

timestamp

(NULL)

NO

CURRENT_TIMESTAMP

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

oe_numidx

0

PRIMARY

1

on_id

A

551145

(NULL)

(NULL)

BTREE

oe_numidx

1

on_ismain

1

on_ismain

A

1

(NULL)

(NULL)

YES

BTREE

oe_numidx

1

on_oe_id

1

on_oe_id

A

46404

(NULL)

(NULL)

BTREE

oe_numidx

1

on_oe_id

2

on_ismain

A

76851

(NULL)

(NULL)

YES

BTREE

oe_numidx

1

on_formart

1

on_formart

A

534639

(NULL)

(NULL)

BTREE

oe_numidx

1

on_formart

2

on_pf_id

A

515763

(NULL)

(NULL)

BTREE

oe_numidx

1

on_pf_id

1

on_pf_id

A

935

(NULL)

(NULL)

BTREE

Back

oe_param_val

Fields

Field Type Collation Null Key Default Extra Privileges Comment

ppv_oe_id

int(11)

(NULL)

NO

PRI

(NULL)

select,insert,update,references

产品ID

ppv_pc_id

int(11)

(NULL)

YES

MUL

(NULL)

select,insert,update,references

零件分类ID

ppv_ptpa_id

int(11)

(NULL)

NO

PRI

(NULL)

select,insert,update,references

参数ID

ppv_val_int

int(11)

(NULL)

YES

MUL

0

select,insert,update,references

ppv_val_double

decimal(20,6)

(NULL)

YES

MUL

(NULL)

select,insert,update,references

ppv_val_string

varchar(255)

utf8mb4_unicode_ci

YES

MUL

(NULL)

select,insert,update,references

ppv_val_smalltxt

varchar(1024)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

oe_param_val

0

PRIMARY

1

ppv_oe_id

A

0

(NULL)

(NULL)

BTREE

oe_param_val

0

PRIMARY

2

ppv_ptpa_id

A

0

(NULL)

(NULL)

BTREE

oe_param_val

1

ppv_pt_id

1

ppv_pc_id

A

0

(NULL)

(NULL)

YES

BTREE

oe_param_val

1

ppv_ptpa_id

1

ppv_ptpa_id

A

0

(NULL)

(NULL)

BTREE

oe_param_val

1

ppv_val_int

1

ppv_val_int

A

0

(NULL)

(NULL)

YES

BTREE

oe_param_val

1

ppv_val_double

1

ppv_val_double

A

0

(NULL)

(NULL)

YES

BTREE

oe_param_val

1

ppv_val_string

1

ppv_val_string

A

0

(NULL)

(NULL)

YES

BTREE

Back

oe_pic

Fields

Field Type Collation Null Key Default Extra Privileges Comment

pic_oe_id

int(11)

(NULL)

NO

PRI

(NULL)

select,insert,update,references

零件库ID

pic_fileid

int(11)

(NULL)

NO

PRI

(NULL)

select,insert,update,references

文件ID

pic_sup_id

int(11)

(NULL)

NO

(NULL)

select,insert,update,references

供应商ID

pic_ismain

int(11)

(NULL)

YES

0

select,insert,update,references

pic_type

enum('img','line','other')

utf8mb4_unicode_ci

NO

(NULL)

select,insert,update,references

pic_filebase

varchar(100)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

原始文件名

pic_remark

varchar(100)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

备注

pic_sort

int(11)

(NULL)

NO

0

select,insert,update,references

排序

pic_from

int(11)

(NULL)

YES

0

select,insert,update,references

数据来源(13)

pic_unisn

varchar(32)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

原中台唯一标识

pic_opuser

varchar(20)

utf8mb4_unicode_ci

NO

(NULL)

select,insert,update,references

pic_create_time

timestamp

(NULL)

NO

CURRENT_TIMESTAMP

on update CURRENT_TIMESTAMP

select,insert,update,references

pic_update_time

timestamp

(NULL)

NO

CURRENT_TIMESTAMP

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

oe_pic

0

PRIMARY

1

pic_oe_id

A

34209

(NULL)

(NULL)

BTREE

oe_pic

0

PRIMARY

2

pic_fileid

A

141855

(NULL)

(NULL)

BTREE

oe_pic

1

ppic_fileid

1

pic_fileid

A

132621

(NULL)

(NULL)

BTREE

Back

oe_tag_brand

Fields

Field Type Collation Null Key Default Extra Privileges Comment

otb_oe_id

int(11)

(NULL)

NO

PRI

(NULL)

select,insert,update,references

零件库品牌标签

otb_tb_id

int(11)

(NULL)

NO

PRI

(NULL)

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

oe_tag_brand

0

PRIMARY

1

otb_oe_id

A

22249

(NULL)

(NULL)

BTREE

oe_tag_brand

0

PRIMARY

2

otb_tb_id

A

70290

(NULL)

(NULL)

BTREE

Back

part_param

Fields

Field Type Collation Null Key Default Extra Privileges Comment

ptpa_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

参数ID

ptpa_pid

int(11)

(NULL)

YES

0

select,insert,update,references

引用的公共参数ID

ptpa_cate_id

int(11)

(NULL)

YES

MUL

(NULL)

select,insert,update,references

零件分类ID =0为公共参数

cn_name

varchar(50)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

中文名

en_name

varchar(50)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

英文名

py_name

varchar(50)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

sp_name

varchar(50)

utf8mb4_unicode_ci

YES

select,insert,update,references

西语名

al_name

varchar(50)

utf8mb4_unicode_ci

YES

select,insert,update,references

阿拉伯名

tcd_name

varchar(255)

utf8mb4_unicode_ci

YES

select,insert,update,references

TECDOC参数名多个分号分隔

ptpa_type

enum('int','double','string','smalltxt','bigtxt','list','radio','checkbox')

utf8mb4_unicode_ci

NO

MUL

(NULL)

select,insert,update,references

参数类型

ptpa_length

smallint(6)

(NULL)

YES

(NULL)

select,insert,update,references

长度

ptpa_decimal

smallint(6)

(NULL)

NO

0

select,insert,update,references

小数位数

ptpa_unit

varchar(20)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

单位中文

ptpa_is_search

tinyint(4)

(NULL)

NO

0

select,insert,update,references

是否参入查询

ptpa_search_area

tinyint(1)

(NULL)

NO

0

select,insert,update,references

查询区间

ptpa_search_diff

decimal(6,2)

(NULL)

YES

(NULL)

select,insert,update,references

ptpa_search_or

tinyint(1)

(NULL)

NO

0

select,insert,update,references

多值查询

ptpa_is_fuzzy

tinyint(4)

(NULL)

NO

0

select,insert,update,references

是否支持模糊查询

ptpa_is_fuzzy_select

tinyint(4)

(NULL)

NO

0

select,insert,update,references

是否显示模糊与精确选项

ptpa_in_showlist

tinyint(4)

(NULL)

NO

1

select,insert,update,references

是否在列表显示

ptpa_in_showpage

tinyint(4)

(NULL)

NO

1

select,insert,update,references

是否在详情页显示

ptpa_is_show

tinyint(4)

(NULL)

NO

1

select,insert,update,references

是否全部显示(最高)

ptpa_is_edit

tinyint(4)

(NULL)

NO

1

select,insert,update,references

是否允许编辑

ptpa_is_website

tinyint(4)

(NULL)

NO

0

select,insert,update,references

是否在对外网站中显示

ptpa_col_order

smallint(6)

(NULL)

NO

999

select,insert,update,references

显示顺序

ptpa_syn_field

varchar(255)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

同步字段

ptpa_image

varchar(255)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

参数示意图

create_time

timestamp

(NULL)

NO

CURRENT_TIMESTAMP

on update CURRENT_TIMESTAMP

select,insert,update,references

创建时间

update_time

timestamp

(NULL)

YES

(NULL)

on update CURRENT_TIMESTAMP

select,insert,update,references

更新时间

ptta_is_query_must

tinyint(4)

(NULL)

YES

(NULL)

select,insert,update,references

opuser

varchar(255)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

pdfcol

varchar(1024)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

PDF中对应的模块中的列

ptpa_width

smallint(6)

(NULL)

YES

0

select,insert,update,references

展示宽度

ptpa_tecdoc

tinyint(1)

(NULL)

NO

0

select,insert,update,references

是否为Tecdoc参数

ptpa_enweb_name

varchar(255)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

part_param

0

PRIMARY

1

ptpa_id

A

4

(NULL)

(NULL)

BTREE

part_param

1

ptpa_pt_id

1

ptpa_cate_id

A

1

(NULL)

(NULL)

YES

BTREE

part_param

1

ptpa_type

1

ptpa_type

A

1

(NULL)

(NULL)

BTREE

Back

part_param_sche

Fields

Field Type Collation Null Key Default Extra Privileges Comment

pps_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

参数预选&文本值翻译&参数单位

pps_ptpa_id

int(11)

(NULL)

YES

MUL

(NULL)

select,insert,update,references

参数ID ID=0为参数

cn_name

varchar(50)

utf8mb4_unicode_ci

YES

MUL

(NULL)

select,insert,update,references

en_name

varchar(50)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

py_name

varchar(50)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

sp_name

varchar(50)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

西语

al_name

varchar(50)

utf8mb4_unicode_ci

YES

select,insert,update,references

阿拉伯

pps_order

int(11)

(NULL)

NO

999

select,insert,update,references

序号

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

part_param_sche

0

PRIMARY

1

pps_id

A

23

(NULL)

(NULL)

BTREE

part_param_sche

1

pps_ptpa_id

1

pps_ptpa_id

A

6

(NULL)

(NULL)

YES

BTREE

part_param_sche

1

cn_name

1

cn_name

A

23

(NULL)

(NULL)

YES

BTREE

Back

power

Fields

Field Type Collation Null Key Default Extra Privileges Comment

power_code

char(4)

utf8mb4_unicode_ci

NO

PRI

(NULL)

select,insert,update,references

编码(大,中，子,预留)

power_tree

char(4)

utf8mb4_unicode_ci

YES

select,insert,update,references

显示用

power_name

varchar(50)

utf8mb4_unicode_ci

YES

select,insert,update,references

权限模块名称

power_shortname

varchar(50)

utf8mb4_unicode_ci

YES

select,insert,update,references

power_enable

tinyint(4)

(NULL)

NO

1

select,insert,update,references

是否有效

power_show

tinyint(4)

(NULL)

NO

1

select,insert,update,references

是否显示在管理界面

power_view

varchar(1024)

utf8mb4_unicode_ci

YES

select,insert,update,references

控制器,用逗号分隔

power_add

varchar(1024)

utf8mb4_unicode_ci

YES

select,insert,update,references

power_edit

varchar(1024)

utf8mb4_unicode_ci

YES

select,insert,update,references

power_delete

varchar(1024)

utf8mb4_unicode_ci

YES

select,insert,update,references

power_import

varchar(1024)

utf8mb4_unicode_ci

YES

select,insert,update,references

power_export

varchar(1024)

utf8mb4_unicode_ci

YES

select,insert,update,references

power_done

varchar(1024)

utf8mb4_unicode_ci

YES

select,insert,update,references

power_check1

varchar(1024)

utf8mb4_unicode_ci

YES

select,insert,update,references

power_check2

varchar(1024)

utf8mb4_unicode_ci

YES

select,insert,update,references

power_check3

varchar(1024)

utf8mb4_unicode_ci

YES

select,insert,update,references

power_power_type

varchar(100)

utf8mb4_unicode_ci

YES

select,insert,update,references

适用的权限类型view:查看,add:添加,edit:编辑,delete:删除,import:导入,export:导出,done:执行,check1:初审

power_type_as

varchar(255)

utf8mb4_unicode_ci

YES

select,insert,update,references

类型as name

power_fields

varchar(2048)

utf8mb4_unicode_ci

YES

select,insert,update,references

字段

power_has_cate

tinyint(4)

(NULL)

NO

0

select,insert,update,references

是否有品名约束

power_has_proparams

tinyint(4)

(NULL)

NO

0

select,insert,update,references

是否有产品参数约束

power_has_make

tinyint(4)

(NULL)

NO

0

select,insert,update,references

是否有国际大车型约束

power_has_cnmake

tinyint(4)

(NULL)

NO

0

select,insert,update,references

是否有中国大车型约束

power_has_factory

tinyint(4)

(NULL)

NO

0

select,insert,update,references

是否有零件品牌约束

power_has_ver

tinyint(4)

(NULL)

NO

0

select,insert,update,references

是否有版本约束

power_has_area

tinyint(4)

(NULL)

NO

0

select,insert,update,references

是否有区域约束

power_has_time

tinyint(4)

(NULL)

NO

0

select,insert,update,references

是否有时间约束

power_has_user

tinyint(4)

(NULL)

NO

0

select,insert,update,references

用户数据约束

power_has_country

tinyint(4)

(NULL)

NO

0

select,insert,update,references

是否有国家约束

power_action

json

(NULL)

YES

(NULL)

select,insert,update,references

power_model

enum('pdc','oppo','smart')

utf8mb4_unicode_ci

NO

pdc

select,insert,update,references

所属模块

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

power

0

PRIMARY

1

power_code

A

38

(NULL)

(NULL)

BTREE

Back

power_role_link

Fields

Field Type Collation Null Key Default Extra Privileges Comment

prl_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

prl_ar_id

int(11)

(NULL)

NO

MUL

(NULL)

select,insert,update,references

角色ID

prl_power_code

char(4)

utf8mb4_unicode_ci

NO

(NULL)

select,insert,update,references

权限编码

prl_value

int(11)

(NULL)

NO

0

select,insert,update,references

1:view,2:add,4:edit,8:delete,16:import,32:explot,64:done

prl_bigcates

text

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

绑定的产品线

prl_cates

text

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

绑定的品名

prl_makes

text

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

国际大车型

prl_cnmakes

text

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

中国大车型

prl_factorys

text

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

号码品牌

prl_vers

text

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

数据版本

prl_areas

text

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

车型区域

prl_users

text

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

查看额外的用户

prl_countrys

text

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

oppo-价格反馈-国家

prl_masters

text

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

master_tpl ID

prl_view_self

tinyint(4)

(NULL)

NO

0

select,insert,update,references

只能查看自己的数据

prl_view_depa

tinyint(4)

(NULL)

NO

0

select,insert,update,references

只能查看所属部门的用户数据

prl_view_all

tinyint(4)

(NULL)

NO

0

select,insert,update,references

可查看所有人的数据

prl_fields

text

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

属性字段

prl_opuser

varchar(20)

utf8mb4_unicode_ci

NO

select,insert,update,references

prl_update_time

timestamp

(NULL)

NO

CURRENT_TIMESTAMP

on update CURRENT_TIMESTAMP

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

power_role_link

0

PRIMARY

1

prl_id

A

117

(NULL)

(NULL)

BTREE

power_role_link

1

prl_au_id

1

prl_ar_id

A

7

(NULL)

(NULL)

BTREE

power_role_link

1

prl_au_id

2

prl_power_code

A

117

(NULL)

(NULL)

BTREE

Back

power_role_param_link

Fields

Field Type Collation Null Key Default Extra Privileges Comment

prpl_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

prpl_ar_id

int(11)

(NULL)

NO

(NULL)

select,insert,update,references

角色ID

prpl_power_code

char(4)

utf8mb4_unicode_ci

NO

(NULL)

select,insert,update,references

权限编码

prpl_cate

int(11)

(NULL)

NO

(NULL)

select,insert,update,references

品名

prpl_params

varchar(4096)

utf8mb4_unicode_ci

NO

select,insert,update,references

品名参数ID集

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

power_role_param_link

0

PRIMARY

1

prpl_id

A

0

(NULL)

(NULL)

BTREE

Back

pro

Fields

Field Type Collation Null Key Default Extra Privileges Comment

p_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

商品的唯一性规则：小类+主OE+商品品牌+汽车品牌+材质（由小类决定）+物料类型

p_lnk_p_id

int(11)

(NULL)

YES

MUL

0

select,insert,update,references

p_cate

int(11)

(NULL)

NO

MUL

(NULL)

select,insert,update,references

p_pic

int(11)

(NULL)

YES

0

select,insert,update,references

主图ID

p_pf_id

int(11)

(NULL)

YES

1

select,insert,update,references

p_oe

varchar(64)

utf8mb4_unicode_ci

NO

(NULL)

select,insert,update,references

p_oe_format

varchar(64)

utf8mb4_unicode_ci

YES

MUL

(NULL)

select,insert,update,references

p_pb_id

int(11)

(NULL)

NO

MUL

(NULL)

select,insert,update,references

产品品牌ID

p_tb_id

int(11)

(NULL)

NO

MUL

(NULL)

select,insert,update,references

参与编码的汽车品牌 tag_brand

p_cm_id

int(11)

(NULL)

NO

(NULL)

select,insert,update,references

原中台的汽车生产商 cd_make

p_item_type

int(11)

(NULL)

YES

MUL

(NULL)

select,insert,update,references

物料类型 obj(1)

p_comnum

varchar(64)

utf8mb4_unicode_ci

NO

(NULL)

select,insert,update,references

集团中性号

p_comnum_format

varchar(64)

utf8mb4_unicode_ci

NO

MUL

(NULL)

select,insert,update,references

集团中性号去格式

p_innum

varchar(50)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

物料编码

p_innum_format

varchar(50)

utf8mb4_unicode_ci

YES

UNI

(NULL)

select,insert,update,references

p_state_main

enum('01','02','03','04','99','05','06','07','00')

utf8mb4_unicode_ci

NO

MUL

00

select,insert,update,references

主状态 '01'=>'开发中','02'=>'国内不做外贸订做','03'=>'上市','04'=>'退市','99'=>'删除','05'=>'升级中','06'=>'可研发生产','07'=>'新品在途可预定'

p_state_remark

varchar(512)

utf8mb4_unicode_ci

YES

select,insert,update,references

p_cn_name

varchar(100)

utf8mb4_unicode_ci

YES

select,insert,update,references

产品中文名

p_en_name

varchar(100)

utf8mb4_unicode_ci

YES

select,insert,update,references

产品英文名

p_py_name

varchar(100)

utf8mb4_unicode_ci

YES

select,insert,update,references

产品俄文名

p_sp_name

varchar(100)

utf8mb4_unicode_ci

YES

select,insert,update,references

产品西语名

p_al_name

varchar(100)

utf8mb4_unicode_ci

YES

select,insert,update,references

产品阿拉伯名

p_unit

int(11)

(NULL)

YES

0

select,insert,update,references

基本单位 obj(2)

p_material

int(11)

(NULL)

YES

MUL

0

select,insert,update,references

材质obj(16)

p_iskit

smallint(6)

(NULL)

YES

0

select,insert,update,references

是否套件

p_model_cn_name

varchar(200)

utf8mb4_unicode_ci

YES

select,insert,update,references

车型中文

p_model_en_name

varchar(200)

utf8mb4_unicode_ci

YES

select,insert,update,references

车型英文

p_model_py_name

varchar(200)

utf8mb4_unicode_ci

YES

select,insert,update,references

车型俄文

p_model_sp_name

varchar(200)

utf8mb4_unicode_ci

YES

select,insert,update,references

车型西语名

p_model_al_name

varchar(200)

utf8mb4_unicode_ci

YES

select,insert,update,references

车型阿拉伯名

p_chassis

varchar(100)

utf8mb4_unicode_ci

YES

select,insert,update,references

底盘

p_model_year

varchar(255)

utf8mb4_unicode_ci

YES

select,insert,update,references

车型年限

p_engine

varchar(255)

utf8mb4_unicode_ci

YES

select,insert,update,references

发动机

p_fuel_type

int(11)

(NULL)

YES

0

select,insert,update,references

[原]燃油类型 obj(5)

p_cc

varchar(255)

utf8mb4_unicode_ci

YES

select,insert,update,references

[原]排量

p_des_cn_name

varchar(200)

utf8mb4_unicode_ci

YES

select,insert,update,references

描述中文

p_des_en_name

varchar(200)

utf8mb4_unicode_ci

YES

select,insert,update,references

描述英文

p_des_py_name

varchar(200)

utf8mb4_unicode_ci

YES

select,insert,update,references

描述俄文

p_des_sp_name

varchar(200)

utf8mb4_unicode_ci

YES

select,insert,update,references

描述西语名

p_des_al_name

varchar(200)

utf8mb4_unicode_ci

YES

select,insert,update,references

描述阿拉伯名

p_para

json

(NULL)

YES

(NULL)

select,insert,update,references

引用宜配数据参数

p_pos1

varchar(64)

utf8mb4_unicode_ci

YES

select,insert,update,references

前/后轴

p_pos2

varchar(64)

utf8mb4_unicode_ci

YES

select,insert,update,references

前/后

p_pos3

varchar(64)

utf8mb4_unicode_ci

YES

select,insert,update,references

左/右

p_pos4

varchar(64)

utf8mb4_unicode_ci

YES

select,insert,update,references

外/中/内

p_pos5

varchar(64)

utf8mb4_unicode_ci

YES

select,insert,update,references

上/中/下

p_features

varchar(255)

utf8mb4_unicode_ci

YES

select,insert,update,references

产品特性

p_isdevelop

smallint(6)

(NULL)

YES

0

select,insert,update,references

是否内部研发

p_develop_status

smallint(6)

(NULL)

YES

0

select,insert,update,references

开发状态obj(17)

p_source_province_id

int(11)

(NULL)

YES

0

select,insert,update,references

固定货源地-省

p_source_city_id

int(11)

(NULL)

YES

0

select,insert,update,references

固定货源地-市

p_remark

varchar(512)

utf8mb4_unicode_ci

YES

select,insert,update,references

备注(内部)

p_eac_code

varchar(32)

utf8mb4_unicode_ci

YES

select,insert,update,references

EAC编码

p_oe_id

int(11)

(NULL)

YES

MUL

0

select,insert,update,references

零件库ID

p_from_id

int(11)

(NULL)

YES

0

select,insert,update,references

源ID

p_seqno

varchar(8)

utf8mb4_unicode_ci

YES

select,insert,update,references

流水号

p_opuser

varchar(20)

utf8mb4_unicode_ci

NO

select,insert,update,references

操作人

p_create_time

timestamp

(NULL)

NO

CURRENT_TIMESTAMP

on update CURRENT_TIMESTAMP

select,insert,update,references

p_update_time

timestamp

(NULL)

YES

(NULL)

select,insert,update,references

p_pic_syntime

timestamp

(NULL)

YES

MUL

(NULL)

select,insert,update,references

最后一次同步中台的图片时间

temp_pic_init

smallint(6)

(NULL)

YES

MUL

0

select,insert,update,references

是否已初始化图片

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

pro

0

PRIMARY

1

p_id

A

155736

(NULL)

(NULL)

BTREE

pro

0

p_innum

1

p_innum_format

A

155738

(NULL)

(NULL)

YES

BTREE

pro

0

p_comnum

1

p_comnum_format

A

67398

(NULL)

(NULL)

BTREE

pro

0

p_comnum

2

p_innum_format

A

135418

(NULL)

(NULL)

YES

BTREE

pro

1

p_cate

1

p_cate

A

322

(NULL)

(NULL)

BTREE

pro

1

p_state_main

1

p_state_main

A

1

(NULL)

(NULL)

BTREE

pro

1

p_lnk_p_id

1

p_lnk_p_id

A

1

(NULL)

(NULL)

YES

BTREE

pro

1

p_oe_format

1

p_oe_format

A

53356

(NULL)

(NULL)

YES

BTREE

pro

1

p_pb_id

1

p_pb_id

A

25

(NULL)

(NULL)

BTREE

pro

1

p_tb_id

1

p_tb_id

A

46

(NULL)

(NULL)

BTREE

pro

1

p_comnum_format

1

p_comnum_format

A

58443

(NULL)

(NULL)

BTREE

pro

1

p_oe_id

1

p_oe_id

A

40623

(NULL)

(NULL)

YES

BTREE

pro

1

p_material

1

p_material

A

1

(NULL)

(NULL)

YES

BTREE

pro

1

p_item_type

1

p_item_type

A

3

(NULL)

(NULL)

YES

BTREE

pro

1

p_pic_syntime

1

p_pic_syntime

A

18931

(NULL)

(NULL)

YES

BTREE

pro

1

temp_pic_init

1

temp_pic_init

A

1

(NULL)

(NULL)

YES

BTREE

Back

pro_attaqty

Fields

Field Type Collation Null Key Default Extra Privileges Comment

pa_p_id

int(11)

(NULL)

NO

PRI

(NULL)

select,insert,update,references

产品ID

pa_1

varchar(10)

utf8mb4_unicode_ci

NO

select,insert,update,references

附件1数量

pa_2

varchar(10)

utf8mb4_unicode_ci

NO

select,insert,update,references

pa_3

varchar(10)

utf8mb4_unicode_ci

NO

select,insert,update,references

pa_4

varchar(10)

utf8mb4_unicode_ci

NO

select,insert,update,references

pa_5

varchar(10)

utf8mb4_unicode_ci

NO

select,insert,update,references

pa_6

varchar(10)

utf8mb4_unicode_ci

NO

select,insert,update,references

pa_7

varchar(10)

utf8mb4_unicode_ci

NO

select,insert,update,references

pa_8

varchar(10)

utf8mb4_unicode_ci

NO

select,insert,update,references

pa_9

varchar(10)

utf8mb4_unicode_ci

NO

select,insert,update,references

pa_10

varchar(10)

utf8mb4_unicode_ci

NO

select,insert,update,references

pa_11

varchar(10)

utf8mb4_unicode_ci

NO

select,insert,update,references

pa_12

varchar(10)

utf8mb4_unicode_ci

NO

select,insert,update,references

pa_13

varchar(10)

utf8mb4_unicode_ci

NO

select,insert,update,references

pa_14

varchar(10)

utf8mb4_unicode_ci

NO

select,insert,update,references

pa_15

varchar(10)

utf8mb4_unicode_ci

NO

select,insert,update,references

pa_16

varchar(10)

utf8mb4_unicode_ci

NO

select,insert,update,references

pa_17

varchar(10)

utf8mb4_unicode_ci

NO

select,insert,update,references

pa_18

varchar(10)

utf8mb4_unicode_ci

NO

select,insert,update,references

pa_19

varchar(10)

utf8mb4_unicode_ci

NO

select,insert,update,references

pa_20

varchar(10)

utf8mb4_unicode_ci

NO

select,insert,update,references

附件20数量

opuser

varchar(20)

utf8mb4_unicode_ci

NO

(NULL)

select,insert,update,references

create_time

timestamp

(NULL)

NO

CURRENT_TIMESTAMP

select,insert,update,references

update_time

timestamp

(NULL)

NO

CURRENT_TIMESTAMP

on update CURRENT_TIMESTAMP

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

pro_attaqty

0

PRIMARY

1

pa_p_id

A

0

(NULL)

(NULL)

BTREE

Back

pro_bom_assemble

Fields

Field Type Collation Null Key Default Extra Privileges Comment

pba_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

产品组装BOM

pba_p_id

int(11)

(NULL)

YES

MUL

0

select,insert,update,references

产品ID

pba_name

varchar(255)

utf8mb4_unicode_ci

YES

select,insert,update,references

名称

pba_count

int(11)

(NULL)

YES

1

select,insert,update,references

数量

pba_opuser

varchar(20)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

pba_create_time

timestamp

(NULL)

YES

(NULL)

select,insert,update,references

pba_update_time

timestamp

(NULL)

YES

(NULL)

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

pro_bom_assemble

0

PRIMARY

1

pba_id

A

0

(NULL)

(NULL)

BTREE

pro_bom_assemble

0

pba_p_id

1

pba_p_id

A

0

(NULL)

(NULL)

YES

BTREE

pro_bom_assemble

0

pba_p_id

2

pba_name

A

0

(NULL)

(NULL)

YES

BTREE

Back

pro_bom_pack

Fields

Field Type Collation Null Key Default Extra Privileges Comment

pbp_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

产品包装BOM

pbp_p_id

int(11)

(NULL)

YES

MUL

0

select,insert,update,references

产品ID

pbp_name

varchar(255)

utf8mb4_unicode_ci

YES

select,insert,update,references

名称

pbp_count

int(11)

(NULL)

YES

1

select,insert,update,references

数量

pbp_opuser

varchar(20)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

pbp_create_time

timestamp

(NULL)

YES

(NULL)

select,insert,update,references

pbp_update_time

timestamp

(NULL)

YES

(NULL)

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

pro_bom_pack

0

PRIMARY

1

pbp_id

A

0

(NULL)

(NULL)

BTREE

pro_bom_pack

0

pbp_p_id

1

pbp_p_id

A

0

(NULL)

(NULL)

YES

BTREE

pro_bom_pack

0

pbp_p_id

2

pbp_name

A

0

(NULL)

(NULL)

YES

BTREE

Back

pro_brand

Fields

Field Type Collation Null Key Default Extra Privileges Comment

pb_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

pb_cn_name

varchar(100)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

SKU品牌名

pb_en_name

varchar(100)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

SKU品牌名

pb_py_name

varchar(100)

utf8mb4_unicode_ci

YES

MUL

(NULL)

select,insert,update,references

SKU品牌名

pb_sp_name

varchar(100)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

SKU品牌西语名

pb_al_name

varchar(100)

utf8mb4_unicode_ci

YES

select,insert,update,references

SKU品牌阿拉伯名

pb_company

int(11)

(NULL)

YES

0

select,insert,update,references

所属公司 obj(3)

pb_code_rule

varchar(8)

utf8mb4_unicode_ci

YES

MUL

select,insert,update,references

编码规则-品牌标识

pb_rules

varchar(64)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

B:商品品牌 M:汽车品牌 C:品类 S:流水号如：M@C@S@B

pb_from_id

int(11)

(NULL)

YES

0

select,insert,update,references

源ID

pb_opuser

varchar(20)

utf8mb4_unicode_ci

YES

MUL

(NULL)

select,insert,update,references

pb_create_time

timestamp

(NULL)

NO

MUL

(NULL)

on update CURRENT_TIMESTAMP

select,insert,update,references

pb_update_time

timestamp

(NULL)

NO

MUL

(NULL)

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

pro_brand

0

PRIMARY

1

pb_id

A

29

(NULL)

(NULL)

BTREE

pro_brand

1

pb_name

1

pb_py_name

A

29

(NULL)

(NULL)

YES

BTREE

pro_brand

1

opuser

1

pb_opuser

A

1

(NULL)

(NULL)

YES

BTREE

pro_brand

1

create_time

1

pb_create_time

A

3

(NULL)

(NULL)

BTREE

pro_brand

1

update_time

1

pb_update_time

A

1

(NULL)

(NULL)

BTREE

pro_brand

1

pb_ismain

1

pb_py_name

A

29

(NULL)

(NULL)

YES

BTREE

pro_brand

1

pb_code_rule

1

pb_code_rule

A

29

(NULL)

(NULL)

YES

BTREE

Back

pro_brand_ext

Fields

Field Type Collation Null Key Default Extra Privileges Comment

pbe_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

品牌商扩展信息

pbe_pb_id

int(11)

(NULL)

YES

MUL

(NULL)

select,insert,update,references

pro_brand

pbe_type

enum('outbox','inbox','inpocket','tag','material')

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

outbox:外盒 inbox:内盒 inpocket:内袋 tag:标签 material:包装辅料

pbe_val

varchar(100)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

扩展信息值

pbe_code

varchar(64)

utf8mb4_unicode_ci

YES

select,insert,update,references

型号

pbe_code_format

varchar(64)

utf8mb4_unicode_ci

YES

select,insert,update,references

格式型号

pbe_length

float

(NULL)

YES

0

select,insert,update,references

长

pbe_width

float

(NULL)

YES

0

select,insert,update,references

宽

pbe_height

float

(NULL)

YES

0

select,insert,update,references

高

pbe_size_unit

int(11)

(NULL)

YES

1100

select,insert,update,references

尺寸单位 obj(18)

pbe_sort

int(11)

(NULL)

YES

0

select,insert,update,references

顺序从小到大

pbe_opuser

varchar(20)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

pbe_create_time

timestamp

(NULL)

NO

0000-00-00 00:00:00

on update CURRENT_TIMESTAMP

select,insert,update,references

pbe_update_time

timestamp

(NULL)

NO

0000-00-00 00:00:00

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

pro_brand_ext

0

PRIMARY

1

pbe_id

A

522

(NULL)

(NULL)

BTREE

pro_brand_ext

0

unikey

1

pbe_pb_id

A

3

(NULL)

(NULL)

YES

BTREE

pro_brand_ext

0

unikey

2

pbe_type

A

11

(NULL)

(NULL)

YES

BTREE

pro_brand_ext

0

unikey

3

pbe_val

A

522

(NULL)

(NULL)

YES

BTREE

Back

pro_cate

Fields

Field Type Collation Null Key Default Extra Privileges Comment

id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

parent_id

int(11)

(NULL)

NO

MUL

(NULL)

select,insert,update,references

left

int(11)

(NULL)

NO

MUL

(NULL)

select,insert,update,references

right

int(11)

(NULL)

NO

(NULL)

select,insert,update,references

level

smallint(6)

(NULL)

NO

MUL

(NULL)

select,insert,update,references

ismove

tinyint(1)

(NULL)

NO

0

select,insert,update,references

移动标记

cn_name

varchar(100)

utf8mb4_unicode_ci

NO

select,insert,update,references

en_name

varchar(100)

utf8mb4_unicode_ci

NO

select,insert,update,references

py_name

varchar(100)

utf8mb4_unicode_ci

YES

select,insert,update,references

sp_name

varchar(100)

utf8mb4_unicode_ci

YES

select,insert,update,references

西语小类

al_name

varchar(100)

utf8mb4_unicode_ci

YES

select,insert,update,references

阿拉伯小类

is_engine

smallint(6)

(NULL)

YES

0

select,insert,update,references

发动机相关属性

tcd_name

varchar(255)

utf8mb4_unicode_ci

YES

select,insert,update,references

TECDOC名称

cat_as

varchar(100)

utf8mb4_unicode_ci

YES

select,insert,update,references

别名

keyword

varchar(255)

utf8mb4_unicode_ci

YES

select,insert,update,references

关键字

remark

varchar(255)

utf8mb4_unicode_ci

NO

select,insert,update,references

备注

photo_param

int(11)

(NULL)

YES

(NULL)

select,insert,update,references

参数示意图片

cat_pic

int(11)

(NULL)

YES

(NULL)

select,insert,update,references

类别图

cat_pos1

varchar(64)

utf8mb4_unicode_ci

YES

select,insert,update,references

前/后轴

cat_pos2

varchar(64)

utf8mb4_unicode_ci

YES

select,insert,update,references

前/后

cat_pos3

varchar(64)

utf8mb4_unicode_ci

YES

select,insert,update,references

左/右

cat_pos4

varchar(64)

utf8mb4_unicode_ci

YES

select,insert,update,references

外/中/内

cat_pos5

varchar(64)

utf8mb4_unicode_ci

YES

select,insert,update,references

上/中/下

cat_cnpos

varchar(2048)

utf8mb4_unicode_ci

YES

{}

select,insert,update,references

中国车型位置配置

cat_cnpos_fileds

varchar(255)

utf8mb4_unicode_ci

YES

select,insert,update,references

中国车型排序字段

cat_cnpos_vals

varchar(2048)

utf8mb4_unicode_ci

YES

select,insert,update,references

中国车型排序值

cat_zhuyi

varchar(255)

utf8mb4_unicode_ci

YES

[]

select,insert,update,references

注意事项

cat_pzbz

varchar(255)

utf8mb4_unicode_ci

YES

[]

select,insert,update,references

拍照标准

cat_zpsl

varchar(255)

utf8mb4_unicode_ci

YES

[]

select,insert,update,references

照片示例

attaqty

varchar(50)

utf8mb4_unicode_ci

NO

select,insert,update,references

附件(ckv)

create_time

timestamp

(NULL)

NO

CURRENT_TIMESTAMP

on update CURRENT_TIMESTAMP

select,insert,update,references

update_time

timestamp

(NULL)

NO

CURRENT_TIMESTAMP

select,insert,update,references

cat_opuser

varchar(32)

utf8mb4_unicode_ci

YES

select,insert,update,references

cat_tcdfac

varchar(4096)

utf8mb4_unicode_ci

YES

select,insert,update,references

清洗数据的竞品排序

cat_tcdfacmain

varchar(1024)

utf8mb4_unicode_ci

YES

select,insert,update,references

重点关注的最多10个

cat_rate_number

int(11)

(NULL)

YES

70

select,insert,update,references

号码确认相同率

cat_rate_model

int(11)

(NULL)

YES

50

select,insert,update,references

车型确认相同率

cat_pos

json

(NULL)

YES

(NULL)

select,insert,update,references

位置参数配置

cat_unit

int(11)

(NULL)

YES

0

select,insert,update,references

默认基本单位 obj(2)

cat_item_type

int(11)

(NULL)

YES

0

select,insert,update,references

默认物料类型 obj(1)

cat_unit_customs

int(11)

(NULL)

YES

0

select,insert,update,references

报关单位 obj(2)

cat_hsbm

varchar(255)

utf8mb4_unicode_ci

YES

select,insert,update,references

HS编码

cat_ktsl

int(11)

(NULL)

YES

0

select,insert,update,references

退税率

cat_invoice

varchar(255)

utf8mb4_unicode_ci

YES

select,insert,update,references

开票名称

cat_seqrule

smallint(6)

(NULL)

YES

4

select,insert,update,references

编码规则-流水号位数

cat_from_id

int(11)

(NULL)

YES

0

select,insert,update,references

来源ID

cat_prouni_material

int(11)

(NULL)

YES

1

select,insert,update,references

材质是否参与商品唯一性

cat_detfacade

text

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

外观检测

cat_detpara

text

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

参数测量

cat_detpower

text

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

性能检测

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

pro_cate

0

PRIMARY

1

id

A

482

(NULL)

(NULL)

BTREE

pro_cate

1

left

1

left

A

482

(NULL)

(NULL)

BTREE

pro_cate

1

left

2

right

A

482

(NULL)

(NULL)

BTREE

pro_cate

1

level

1

level

A

4

(NULL)

(NULL)

BTREE

pro_cate

1

parent_id

1

parent_id

A

34

(NULL)

(NULL)

BTREE

pro_cate

1

parent_id

2

id

A

482

(NULL)

(NULL)

BTREE

Back

pro_developno

Fields

Field Type Collation Null Key Default Extra Privileges Comment

pde_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

商品开发号

pde_p_id

int(11)

(NULL)

NO

MUL

(NULL)

select,insert,update,references

商品ID

pde_number

varchar(64)

utf8mb4_unicode_ci

NO

(NULL)

select,insert,update,references

pde_format

varchar(64)

utf8mb4_unicode_ci

NO

MUL

(NULL)

select,insert,update,references

号码

pde_sup_id

int(11)

(NULL)

NO

0

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

pro_developno

0

PRIMARY

1

pde_id

A

153

(NULL)

(NULL)

BTREE

pro_developno

1

pde_p_id

1

pde_p_id

A

153

(NULL)

(NULL)

BTREE

pro_developno

1

pde_format

1

pde_format

A

153

(NULL)

(NULL)

BTREE

Back

pro_exchange

Fields

Field Type Collation Null Key Default Extra Privileges Comment

pe_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

pe_type

enum('通用','通用1','通用2','通用3','通用4','通用5')

utf8mb4_unicode_ci

NO

通用

select,insert,update,references

类型

pe_p_id1

int(11)

(NULL)

NO

MUL

(NULL)

select,insert,update,references

型号1

pe_p_id2

int(11)

(NULL)

NO

(NULL)

select,insert,update,references

型号2

pe_param1

varchar(100)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

属性1

pe_param2

varchar(100)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

属性2

pe_remark

varchar(255)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

备注

pe_frometo

enum('','1>2','2>1')

utf8mb4_unicode_ci

NO

select,insert,update,references

通用方向

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

pro_exchange

0

PRIMARY

1

pe_id

A

0

(NULL)

(NULL)

BTREE

pro_exchange

0

pe_p_id1

1

pe_p_id1

A

0

(NULL)

(NULL)

BTREE

pro_exchange

0

pe_p_id1

2

pe_p_id2

A

0

(NULL)

(NULL)

BTREE

pro_exchange

0

pe_p_id1

3

pe_type

A

0

(NULL)

(NULL)

BTREE

Back

pro_exchange_model_numidx

Fields

Field Type Collation Null Key Default Extra Privileges Comment

pemn_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

pemn_p_id1

int(11)

(NULL)

NO

MUL

(NULL)

select,insert,update,references

型号1

pemn_p_id2

int(11)

(NULL)

NO

(NULL)

select,insert,update,references

型号2

pemn_remark

varchar(255)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

备注

pemn_frometo

enum('','1>2','2>1')

utf8mb4_unicode_ci

NO

select,insert,update,references

通用方向

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

pro_exchange_model_numidx

0

PRIMARY

1

pemn_id

A

0

(NULL)

(NULL)

BTREE

pro_exchange_model_numidx

0

pemn_p_id1

1

pemn_p_id1

A

0

(NULL)

(NULL)

BTREE

pro_exchange_model_numidx

0

pemn_p_id1

2

pemn_p_id2

A

0

(NULL)

(NULL)

BTREE

Back

pro_ext

Fields

Field Type Collation Null Key Default Extra Privileges Comment

pe_p_id

int(11)

(NULL)

NO

PRI

(NULL)

select,insert,update,references

pe_pwgcl

varchar(255)

utf8mb4_unicode_ci

YES

select,insert,update,references

参数-外观处理

pe_pcpgg

varchar(255)

utf8mb4_unicode_ci

YES

select,insert,update,references

参数-产品规格

pe_pos1

varchar(32)

utf8mb4_unicode_ci

YES

select,insert,update,references

参数-位置1

pe_pos2

varchar(32)

utf8mb4_unicode_ci

YES

select,insert,update,references

参数-位置2

pe_pos3

varchar(32)

utf8mb4_unicode_ci

YES

select,insert,update,references

参数-位置3

pe_pgjcc

varchar(255)

utf8mb4_unicode_ci

YES

select,insert,update,references

参数-关键尺寸

pe_pbzcc

varchar(255)

utf8mb4_unicode_ci

YES

select,insert,update,references

参数-包装尺寸

pe_safety_stock

int(11)

(NULL)

YES

0

select,insert,update,references

库存-安全库存

pe_max_stock

int(11)

(NULL)

YES

0

select,insert,update,references

库存-库存上限

pe_min_stock

int(11)

(NULL)

YES

0

select,insert,update,references

库存-采购库存下限

pe_assign_user

varchar(20)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

项目组-分配组员

pe_sqe

int(11)

(NULL)

YES

0

select,insert,update,references

项目组-SQE名称obj(11)

pe_purchase

int(11)

(NULL)

YES

0

select,insert,update,references

项目组-采购组obj(10)

pe_purchase_leader

varchar(20)

utf8mb4_unicode_ci

YES

select,insert,update,references

项目组-采购组长

pe_purchase_manager

varchar(20)

utf8mb4_unicode_ci

YES

select,insert,update,references

项目组-采购负责人

pe_purchase_follower

varchar(20)

utf8mb4_unicode_ci

YES

select,insert,update,references

项目组-采购跟单员

pe_purchase_follower2

varchar(20)

utf8mb4_unicode_ci

YES

select,insert,update,references

项目组-备选采购跟单员

pe_sales_warranty

int(11)

(NULL)

YES

0

select,insert,update,references

产品销售质保期obj(9)

pe_install_remark

varchar(255)

utf8mb4_unicode_ci

YES

select,insert,update,references

安装注意事项

pe_category

varchar(64)

utf8mb4_unicode_ci

YES

select,insert,update,references

产品分类obj(12) 多选

pe_warehouse_date

date

(NULL)

YES

(NULL)

select,insert,update,references

入仓日期

pe_kingdee_status

smallint(6)

(NULL)

YES

1

select,insert,update,references

1启用 0禁用

pe_opuser

varchar(20)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

pe_create_time

timestamp

(NULL)

NO

CURRENT_TIMESTAMP

on update CURRENT_TIMESTAMP

select,insert,update,references

pe_update_time

timestamp

(NULL)

NO

CURRENT_TIMESTAMP

on update CURRENT_TIMESTAMP

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

pro_ext

0

PRIMARY

1

pe_p_id

A

151074

(NULL)

(NULL)

BTREE

Back

pro_factory

Fields

Field Type Collation Null Key Default Extra Privileges Comment

pf_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

pf_type

enum('OE','SYS','FAC')

utf8mb4_unicode_ci

YES

FAC

select,insert,update,references

OE,FAC:普通

pf_name

varchar(100)

utf8mb4_unicode_ci

YES

MUL

(NULL)

select,insert,update,references

品牌名

opuser

varchar(20)

utf8mb4_unicode_ci

YES

MUL

(NULL)

select,insert,update,references

create_time

timestamp

(NULL)

NO

MUL

0000-00-00 00:00:00

on update CURRENT_TIMESTAMP

select,insert,update,references

update_time

timestamp

(NULL)

NO

MUL

0000-00-00 00:00:00

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

pro_factory

0

PRIMARY

1

pf_id

A

1427

(NULL)

(NULL)

BTREE

pro_factory

1

en_name

1

pf_name

A

1427

(NULL)

(NULL)

YES

BTREE

pro_factory

1

opuser

1

opuser

A

2

(NULL)

(NULL)

YES

BTREE

pro_factory

1

create_time

1

create_time

A

5

(NULL)

(NULL)

BTREE

pro_factory

1

update_time

1

update_time

A

5

(NULL)

(NULL)

BTREE

Back

pro_fatherson

Fields

Field Type Collation Null Key Default Extra Privileges Comment

pf_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

pf_father_pid

int(11)

(NULL)

NO

MUL

(NULL)

select,insert,update,references

pf_son_pid

int(11)

(NULL)

NO

(NULL)

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

pro_fatherson

0

PRIMARY

1

pf_id

A

0

(NULL)

(NULL)

BTREE

pro_fatherson

0

pf_father_pid

1

pf_father_pid

A

0

(NULL)

(NULL)

BTREE

pro_fatherson

0

pf_father_pid

2

pf_son_pid

A

0

(NULL)

(NULL)

BTREE

Back

pro_link_company

Fields

Field Type Collation Null Key Default Extra Privileges Comment

plc_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

产品关联事业部

plc_p_id

int(11)

(NULL)

NO

0

select,insert,update,references

plc_com_id

int(11)

(NULL)

NO

0

select,insert,update,references

事业部id

plc_com_name

varchar(255)

utf8mb4_unicode_ci

NO

select,insert,update,references

公司名称

plc_pd_unit

smallint(6)

(NULL)

YES

0

select,insert,update,references

产品基本单位（预留

plc_pd_status

varchar(10)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

产品状态

plc_internation_code

varchar(255)

utf8mb4_unicode_ci

NO

(NULL)

select,insert,update,references

国标码

plc_safe_stock

int(11)

(NULL)

NO

0

select,insert,update,references

安全库存

plc_top_stock

int(11)

(NULL)

NO

0

select,insert,update,references

库存上限

plc_waiting_days

varchar(20)

utf8mb4_unicode_ci

NO

select,insert,update,references

入仓日期

plc_mnemonic_code

varchar(255)

utf8mb4_unicode_ci

YES

select,insert,update,references

助记码

plc_mnemonic_code_bak

varchar(255)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

备选助记码

plc_down_stock

int(11)

(NULL)

YES

0

select,insert,update,references

库存下限

plc_out_ward

varchar(255)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

外观处理

plc_precautions

varchar(255)

utf8mb4_unicode_ci

YES

select,insert,update,references

安装注意事项

plc_min_quantity

int(11)

(NULL)

YES

0

select,insert,update,references

最小起订量

plc_planned_delivery_date

varchar(20)

utf8mb4_unicode_ci

YES

select,insert,update,references

计划交期(天)

plc_shelf_date

varchar(20)

utf8mb4_unicode_ci

YES

select,insert,update,references

工厂质保

plc_print_text

varchar(20)

utf8mb4_unicode_ci

YES

select,insert,update,references

是否工厂刻字

plc_outbox_id

int(11)

(NULL)

YES

0

select,insert,update,references

外盒id

plc_outbox_name

varchar(255)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

外盒

plc_box_id

int(11)

(NULL)

YES

0

select,insert,update,references

内盒id

plc_box_name

varchar(255)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

内盒

plc_bag_id

int(11)

(NULL)

YES

0

select,insert,update,references

内袋

plc_bag_name

varchar(255)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

内袋

plc_accessories_id

int(11)

(NULL)

YES

0

select,insert,update,references

包装辅料

plc_accessories_name

varchar(255)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

plc_box_fcl_quantity

int(11)

(NULL)

YES

0

select,insert,update,references

内盒装盒数量

plc_outbox_fcl_quantity

int(11)

(NULL)

YES

0

select,insert,update,references

外盒装盒数量

plc_bag_fcl_quantity

int(11)

(NULL)

YES

(NULL)

select,insert,update,references

内袋装袋数

plc_weight

varchar(20)

utf8mb4_unicode_ci

YES

select,insert,update,references

单个净重

plc_fcl_gross_weight

varchar(20)

utf8mb4_unicode_ci

YES

select,insert,update,references

整箱毛重

plc_one_gross_weight

varchar(20)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

plc_weight_unit

varchar(20)

utf8mb4_unicode_ci

YES

select,insert,update,references

重量单位 01 克 02 千克

plc_pack_remark

varchar(20)

utf8mb4_unicode_ci

YES

select,insert,update,references

装箱标准

plc_pack_method

varchar(20)

utf8mb4_unicode_ci

YES

select,insert,update,references

包装方式

plc_label_id

varchar(20)

utf8mb4_unicode_ci

YES

0

select,insert,update,references

标签ID

plc_label_name

varchar(255)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

plc_packaging_status

int(11)

(NULL)

YES

0

select,insert,update,references

包装状态 1内包 2外包

plc_print_car

varchar(255)

utf8mb4_unicode_ci

YES

select,insert,update,references

打印车型

plc_pack_remarks

varchar(255)

utf8mb4_unicode_ci

YES

select,insert,update,references

打包方式备注

plc_project_manager_id

int(11)

(NULL)

YES

0

select,insert,update,references

项目经理

plc_sqe_id

int(11)

(NULL)

YES

0

select,insert,update,references

sqe

plc_leader_id

int(11)

(NULL)

YES

0

select,insert,update,references

采购组长

plc_superintendent_id

int(11)

(NULL)

YES

0

select,insert,update,references

采购负责人

plc_pur_group_id

int(11)

(NULL)

YES

0

select,insert,update,references

采购组id

plc_buyer_id

int(11)

(NULL)

YES

(NULL)

select,insert,update,references

plc_create_time

timestamp

(NULL)

YES

CURRENT_TIMESTAMP

select,insert,update,references

plc_update_time

timestamp

(NULL)

NO

CURRENT_TIMESTAMP

on update CURRENT_TIMESTAMP

select,insert,update,references

plc_opuser

varchar(20)

utf8mb4_unicode_ci

NO

select,insert,update,references

plc_ori_link_id

int(11)

(NULL)

NO

0

select,insert,update,references

源关联id

plc_hs_number

varchar(255)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

hs编码

plc_tax_name_1

varchar(255)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

开票名称1

plc_tax_name_2

varchar(255)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

开票名称2

plc_customs_agent

varchar(255)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

报关单位

plc_classification

varchar(255)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

产品分类

plc_gd_kingdee_id

int(11)

(NULL)

NO

0

select,insert,update,references

金蝶id

plc_new_box_name

varchar(255)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

新内盒(预留

plc_gd_kingdee_status

smallint(6)

(NULL)

YES

(NULL)

select,insert,update,references

金蝶状态

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

pro_link_company

0

PRIMARY

1

plc_id

A

264443

(NULL)

(NULL)

BTREE

Back

pro_masattaqty

Fields

Field Type Collation Null Key Default Extra Privileges Comment

pa_p_id

int(11)

(NULL)

NO

PRI

(NULL)

select,insert,update,references

产品ID

pa_1

varchar(100)

utf8mb4_unicode_ci

NO

select,insert,update,references

附件1数量

pa_2

varchar(100)

utf8mb4_unicode_ci

NO

select,insert,update,references

pa_3

varchar(100)

utf8mb4_unicode_ci

NO

select,insert,update,references

pa_4

varchar(100)

utf8mb4_unicode_ci

NO

select,insert,update,references

pa_5

varchar(100)

utf8mb4_unicode_ci

NO

select,insert,update,references

pa_6

varchar(100)

utf8mb4_unicode_ci

NO

select,insert,update,references

pa_7

varchar(100)

utf8mb4_unicode_ci

NO

select,insert,update,references

pa_8

varchar(100)

utf8mb4_unicode_ci

NO

select,insert,update,references

pa_9

varchar(100)

utf8mb4_unicode_ci

NO

select,insert,update,references

pa_10

varchar(100)

utf8mb4_unicode_ci

NO

select,insert,update,references

pa_11

varchar(100)

utf8mb4_unicode_ci

NO

select,insert,update,references

pa_12

varchar(100)

utf8mb4_unicode_ci

NO

select,insert,update,references

pa_13

varchar(100)

utf8mb4_unicode_ci

NO

select,insert,update,references

pa_14

varchar(100)

utf8mb4_unicode_ci

NO

select,insert,update,references

pa_15

varchar(100)

utf8mb4_unicode_ci

NO

select,insert,update,references

pa_16

varchar(100)

utf8mb4_unicode_ci

NO

select,insert,update,references

pa_17

varchar(100)

utf8mb4_unicode_ci

NO

select,insert,update,references

pa_18

varchar(100)

utf8mb4_unicode_ci

NO

select,insert,update,references

pa_19

varchar(100)

utf8mb4_unicode_ci

NO

select,insert,update,references

pa_20

varchar(100)

utf8mb4_unicode_ci

NO

select,insert,update,references

附件20数量

pa_21

varchar(100)

utf8mb4_unicode_ci

NO

select,insert,update,references

附件21数量

pa_22

varchar(255)

utf8mb4_unicode_ci

NO

select,insert,update,references

pa_23

varchar(255)

utf8mb4_unicode_ci

NO

select,insert,update,references

备注

opuser

varchar(20)

utf8mb4_unicode_ci

NO

(NULL)

select,insert,update,references

create_time

timestamp

(NULL)

NO

CURRENT_TIMESTAMP

select,insert,update,references

update_time

timestamp

(NULL)

NO

CURRENT_TIMESTAMP

on update CURRENT_TIMESTAMP

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

pro_masattaqty

0

PRIMARY

1

pa_p_id

A

0

(NULL)

(NULL)

BTREE

Back

pro_model_cn_link

Fields

Field Type Collation Null Key Default Extra Privileges Comment

pml_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

pml_p_id

int(11)

(NULL)

NO

MUL

(NULL)

select,insert,update,references

产品ID

pml_mod3_id

int(11)

(NULL)

NO

MUL

(NULL)

select,insert,update,references

车型ID

pml_remark

varchar(255)

utf8mb4_unicode_ci

YES

select,insert,update,references

pml_from

int(11)

(NULL)

YES

99

select,insert,update,references

数据来源(13)

opuser

varchar(20)

utf8mb4_unicode_ci

NO

(NULL)

select,insert,update,references

create_time

timestamp

(NULL)

YES

(NULL)

select,insert,update,references

update_time

timestamp

(NULL)

YES

(NULL)

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

pro_model_cn_link

0

PRIMARY

1

pml_id

A

1782144

(NULL)

(NULL)

BTREE

pro_model_cn_link

0

uni_pro_mod3

1

pml_p_id

A

21300

(NULL)

(NULL)

BTREE

pro_model_cn_link

0

uni_pro_mod3

2

pml_mod3_id

A

1573862

(NULL)

(NULL)

BTREE

pro_model_cn_link

1

pml_mod3_id

1

pml_mod3_id

A

11791

(NULL)

(NULL)

BTREE

Back

pro_model_link

Fields

Field Type Collation Null Key Default Extra Privileges Comment

pml_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

pml_p_id

int(11)

(NULL)

NO

MUL

(NULL)

select,insert,update,references

产品ID

pml_mm_id

int(11)

(NULL)

NO

MUL

(NULL)

select,insert,update,references

车型ID

pml_remark

varchar(255)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

备注

pml_para

json

(NULL)

YES

(NULL)

select,insert,update,references

参数

pml_from

int(11)

(NULL)

YES

99

select,insert,update,references

数据来源(13)

opuser

varchar(20)

utf8mb4_unicode_ci

NO

(NULL)

select,insert,update,references

create_time

timestamp

(NULL)

YES

(NULL)

select,insert,update,references

update_time

timestamp

(NULL)

YES

(NULL)

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

pro_model_link

0

PRIMARY

1

pml_id

A

3152699

(NULL)

(NULL)

BTREE

pro_model_link

1

pml_p_id

1

pml_p_id

A

18309

(NULL)

(NULL)

BTREE

pro_model_link

1

pml_p_id

2

pml_mm_id

A

3129628

(NULL)

(NULL)

BTREE

pro_model_link

1

pml_mm_id

1

pml_mm_id

A

53088

(NULL)

(NULL)

BTREE

pro_model_link

1

pml_mm_id

2

pml_p_id

A

2973081

(NULL)

(NULL)

BTREE

Back

pro_numidx

Fields

Field Type Collation Null Key Default Extra Privileges Comment

pn_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

pn_p_id

int(11)

(NULL)

NO

MUL

(NULL)

select,insert,update,references

产品ID

pn_is_sys

int(11)

(NULL)

YES

MUL

0

select,insert,update,references

是否属于平台

pn_pf_id

int(11)

(NULL)

NO

MUL

(NULL)

select,insert,update,references

号码品牌

pn_number

varchar(60)

utf8mb4_unicode_ci

NO

(NULL)

select,insert,update,references

号码

pn_formart

varchar(60)

utf8mb4_unicode_ci

NO

MUL

(NULL)

select,insert,update,references

格式化号码

pn_mk_id

varchar(64)

utf8mb4_unicode_ci

YES

select,insert,update,references

OE品牌多个逗号分隔

pn_ismain

smallint(6)

(NULL)

YES

0

select,insert,update,references

主号码

pn_type

enum('none','father','son','exchange','pair')

utf8mb4_unicode_ci

NO

MUL

none

select,insert,update,references

类型, none,父,子,通用,配对

pn_type_id

int(11)

(NULL)

NO

MUL

0

select,insert,update,references

类型表ID

pn_from

int(11)

(NULL)

YES

99

select,insert,update,references

数据来源(13)

opuser

varchar(20)

utf8mb4_unicode_ci

NO

select,insert,update,references

操作人

create_time

timestamp

(NULL)

NO

CURRENT_TIMESTAMP

select,insert,update,references

update_time

timestamp

(NULL)

NO

CURRENT_TIMESTAMP

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

pro_numidx

0

PRIMARY

1

pn_id

A

738046

(NULL)

(NULL)

BTREE

pro_numidx

1

pn_p_id

1

pn_p_id

A

51094

(NULL)

(NULL)

BTREE

pro_numidx

1

pn_pf_id

1

pn_pf_id

A

1171

(NULL)

(NULL)

BTREE

pro_numidx

1

pn_formart

1

pn_formart

A

518789

(NULL)

(NULL)

BTREE

pro_numidx

1

pn_type

1

pn_type

A

1

(NULL)

(NULL)

BTREE

pro_numidx

1

pn_type_id

1

pn_type_id

A

1

(NULL)

(NULL)

BTREE

pro_numidx

1

pn_is_sys

1

pn_is_sys

A

1

(NULL)

(NULL)

YES

BTREE

pro_numidx

1

pn_ismain

1

pn_p_id

A

41407

(NULL)

(NULL)

BTREE

pro_numidx

1

pn_ismain

2

pn_ismain

A

63174

(NULL)

(NULL)

YES

BTREE

Back

pro_pack

Fields

Field Type Collation Null Key Default Extra Privileges Comment

pp_p_id

int(11)

(NULL)

NO

PRI

(NULL)

select,insert,update,references

产品ID

pp_outbox

int(11)

(NULL)

YES

0

select,insert,update,references

外盒 pro_brand_ext

pp_inbox

int(11)

(NULL)

YES

0

select,insert,update,references

内盒 pro_brand_ext

pp_inpocket_count

int(11)

(NULL)

YES

0

select,insert,update,references

内袋装袋数

pp_inbox_count

int(11)

(NULL)

YES

0

select,insert,update,references

内盒装盒数

pp_outbox_count

int(11)

(NULL)

YES

0

select,insert,update,references

外盒装箱数

pp_weight_per

float

(NULL)

YES

0

select,insert,update,references

单个净重

pp_weight_box

float

(NULL)

YES

0

select,insert,update,references

整箱毛重

pp_modeltxt

varchar(255)

utf8mb4_unicode_ci

YES

select,insert,update,references

打印车型

pp_weight_pro

float

(NULL)

YES

0

select,insert,update,references

单个产品毛重

pp_weight_unit

int(11)

(NULL)

YES

0

select,insert,update,references

重量单位obj(7)

pp_pack_standard

varchar(64)

utf8mb4_unicode_ci

YES

select,insert,update,references

装箱标准

pp_pack_status

int(11)

(NULL)

YES

0

select,insert,update,references

包装状态obj(8)

pp_pack_style

varchar(255)

utf8mb4_unicode_ci

YES

select,insert,update,references

包装方式

pp_outstyle_remark

varchar(255)

utf8mb4_unicode_ci

YES

select,insert,update,references

外包方式备注

pp_opuser

varchar(20)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

pp_create_time

timestamp

(NULL)

YES

(NULL)

select,insert,update,references

pp_update_time

timestamp

(NULL)

YES

(NULL)

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

pro_pack

0

PRIMARY

1

pp_p_id

A

0

(NULL)

(NULL)

BTREE

Back

pro_pack_ext

Fields

Field Type Collation Null Key Default Extra Privileges Comment

ppe_p_id

int(11)

(NULL)

NO

PRI

(NULL)

select,insert,update,references

产品ID

ppe_type

enum('inpocket','tag','material')

utf8mb4_unicode_ci

NO

PRI

(NULL)

select,insert,update,references

outbox:外盒 inbox:内盒 inpocket:内袋 tag:标签 material:包装辅料

ppe_pbe_id

int(11)

(NULL)

NO

PRI

0

select,insert,update,references

值ID

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

pro_pack_ext

0

PRIMARY

1

ppe_p_id

A

0

(NULL)

(NULL)

BTREE

pro_pack_ext

0

PRIMARY

2

ppe_type

A

0

(NULL)

(NULL)

BTREE

pro_pack_ext

0

PRIMARY

3

ppe_pbe_id

A

0

(NULL)

(NULL)

BTREE

pro_pack_ext

0

unippe

1

ppe_p_id

A

0

(NULL)

(NULL)

BTREE

pro_pack_ext

0

unippe

2

ppe_type

A

0

(NULL)

(NULL)

BTREE

pro_pack_ext

0

unippe

3

ppe_pbe_id

A

0

(NULL)

(NULL)

BTREE

Back

pro_pair

Fields

Field Type Collation Null Key Default Extra Privileges Comment

pp_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

pp_p_id1

int(11)

(NULL)

NO

(NULL)

select,insert,update,references

型号1

pp_p_id2

int(11)

(NULL)

NO

(NULL)

select,insert,update,references

型号2

pp_group

varchar(50)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

组号

pp_pos

varchar(100)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

安装位置

pp_pos2

varchar(100)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

安装位置2

pp_remark

varchar(255)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

备注

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

pro_pair

0

PRIMARY

1

pp_id

A

0

(NULL)

(NULL)

BTREE

Back

pro_param_strenval

Fields

Field Type Collation Null Key Default Extra Privileges Comment

ppsl_ptpa_id

int(11)

(NULL)

NO

PRI

(NULL)

select,insert,update,references

参数值翻译

ppsl_cn_name

varchar(255)

utf8mb4_unicode_ci

NO

PRI

(NULL)

select,insert,update,references

ppsl_en_name

varchar(512)

utf8mb4_unicode_ci

NO

select,insert,update,references

ppsl_py_name

varchar(100)

utf8mb4_unicode_ci

YES

select,insert,update,references

翻译俄文

ppsl_sp_name

varchar(100)

utf8mb4_unicode_ci

YES

select,insert,update,references

翻译西语

ppsl_al_name

varchar(100)

utf8mb4_unicode_ci

YES

select,insert,update,references

翻译阿拉伯

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

pro_param_strenval

0

PRIMARY

1

ppsl_ptpa_id

A

0

(NULL)

(NULL)

BTREE

pro_param_strenval

0

PRIMARY

2

ppsl_cn_name

A

0

(NULL)

(NULL)

BTREE

Back

pro_param_val

Fields

Field Type Collation Null Key Default Extra Privileges Comment

ppv_p_id

int(11)

(NULL)

NO

PRI

(NULL)

select,insert,update,references

产品ID

ppv_pc_id

int(11)

(NULL)

YES

MUL

(NULL)

select,insert,update,references

零件分类ID

ppv_ptpa_id

int(11)

(NULL)

NO

PRI

(NULL)

select,insert,update,references

参数ID

ppv_val_int

int(11)

(NULL)

YES

MUL

0

select,insert,update,references

ppv_val_double

decimal(20,6)

(NULL)

YES

MUL

(NULL)

select,insert,update,references

ppv_val_string

varchar(255)

utf8mb4_unicode_ci

YES

MUL

(NULL)

select,insert,update,references

ppv_val_smalltxt

varchar(1024)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

pro_param_val

0

PRIMARY

1

ppv_p_id

A

0

(NULL)

(NULL)

BTREE

pro_param_val

0

PRIMARY

2

ppv_ptpa_id

A

0

(NULL)

(NULL)

BTREE

pro_param_val

1

ppv_pt_id

1

ppv_pc_id

A

0

(NULL)

(NULL)

YES

BTREE

pro_param_val

1

ppv_ptpa_id

1

ppv_ptpa_id

A

0

(NULL)

(NULL)

BTREE

pro_param_val

1

ppv_val_int

1

ppv_val_int

A

0

(NULL)

(NULL)

YES

BTREE

pro_param_val

1

ppv_val_double

1

ppv_val_double

A

0

(NULL)

(NULL)

YES

BTREE

pro_param_val

1

ppv_val_string

1

ppv_val_string

A

0

(NULL)

(NULL)

YES

BTREE

Back

pro_pic

Fields

Field Type Collation Null Key Default Extra Privileges Comment

pic_p_id

int(11)

(NULL)

NO

PRI

(NULL)

select,insert,update,references

商品库ID

pic_fileid

int(11)

(NULL)

NO

PRI

(NULL)

select,insert,update,references

文件ID

pic_sup_id

int(11)

(NULL)

NO

(NULL)

select,insert,update,references

供应商ID

pic_ismain

int(11)

(NULL)

YES

0

select,insert,update,references

pic_type

enum('img','line','other')

utf8mb4_unicode_ci

NO

(NULL)

select,insert,update,references

pic_filebase

varchar(100)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

原始文件名

pic_remark

varchar(100)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

备注

pic_sort

int(11)

(NULL)

NO

0

select,insert,update,references

排序

pic_from

int(11)

(NULL)

YES

0

select,insert,update,references

数据来源(13)

pic_unisn

varchar(32)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

原中台唯一标识

pic_opuser

varchar(20)

utf8mb4_unicode_ci

NO

(NULL)

select,insert,update,references

pic_create_time

timestamp

(NULL)

NO

CURRENT_TIMESTAMP

on update CURRENT_TIMESTAMP

select,insert,update,references

pic_update_time

timestamp

(NULL)

NO

CURRENT_TIMESTAMP

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

pro_pic

0

PRIMARY

1

pic_p_id

A

34596

(NULL)

(NULL)

BTREE

pro_pic

0

PRIMARY

2

pic_fileid

A

131368

(NULL)

(NULL)

BTREE

pro_pic

1

ppic_fileid

1

pic_fileid

A

131369

(NULL)

(NULL)

BTREE

Back

pro_rule_link

Fields

Field Type Collation Null Key Default Extra Privileges Comment

prl_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

编码规则

prl_type

enum('brand','cate')

utf8mb4_unicode_ci

NO

MUL

(NULL)

select,insert,update,references

brand:汽车品牌tag_brand cate:零件分类pro_cate

prl_pb_id

int(11)

(NULL)

NO

MUL

(NULL)

select,insert,update,references

产品品牌 pro_brand

prl_val_id

int(11)

(NULL)

NO

MUL

(NULL)

select,insert,update,references

prl_type表的对应值

prl_code_a

varchar(8)

utf8mb4_unicode_ci

NO

MUL

select,insert,update,references

编码a

prl_code_b

varchar(8)

utf8mb4_unicode_ci

YES

select,insert,update,references

编码b

prl_opuser

varchar(20)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

prl_create_time

timestamp

(NULL)

NO

0000-00-00 00:00:00

on update CURRENT_TIMESTAMP

select,insert,update,references

prl_update_time

timestamp

(NULL)

NO

0000-00-00 00:00:00

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

pro_rule_link

0

PRIMARY

1

prl_id

A

511

(NULL)

(NULL)

BTREE

pro_rule_link

0

prl_type

1

prl_type

A

2

(NULL)

(NULL)

BTREE

pro_rule_link

0

prl_type

2

prl_pb_id

A

2

(NULL)

(NULL)

BTREE

pro_rule_link

0

prl_type

3

prl_val_id

A

511

(NULL)

(NULL)

BTREE

pro_rule_link

1

prl_pb_id

1

prl_pb_id

A

1

(NULL)

(NULL)

BTREE

pro_rule_link

1

prl_val_id

1

prl_val_id

A

463

(NULL)

(NULL)

BTREE

pro_rule_link

1

prl_code_a

1

prl_code_a

A

476

(NULL)

(NULL)

BTREE

Back

pro_source_link

Fields

Field Type Collation Null Key Default Extra Privileges Comment

psl_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

来源标识

psl_p_id

int(11)

(NULL)

NO

(NULL)

select,insert,update,references

产品ID

psl_code

varchar(255)

utf8mb4_unicode_ci

NO

(NULL)

select,insert,update,references

国标码

psl_from

varchar(64)

utf8mb4_unicode_ci

NO

select,insert,update,references

来源

psl_from_id

int(11)

(NULL)

NO

(NULL)

select,insert,update,references

来源ID

psl_opuser

varchar(20)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

psl_create_time

timestamp

(NULL)

YES

(NULL)

select,insert,update,references

psl_update_time

timestamp

(NULL)

YES

(NULL)

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

pro_source_link

0

PRIMARY

1

psl_id

A

0

(NULL)

(NULL)

BTREE

Back

pro_stock

Fields

Field Type Collation Null Key Default Extra Privileges Comment

ps_outnum

varchar(100)

utf8mb4_unicode_ci

NO

PRI

(NULL)

select,insert,update,references

gsp no

ps_qty

int(11)

(NULL)

NO

0

select,insert,update,references

库存数量

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

pro_stock

0

PRIMARY

1

ps_outnum

A

0

(NULL)

(NULL)

BTREE

Back

pro_supplier

Fields

Field Type Collation Null Key Default Extra Privileges Comment

psu_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

商品品牌供应商

psu_p_id

int(11)

(NULL)

NO

MUL

(NULL)

select,insert,update,references

集团产品ID pb_id=1

psu_sup_id

int(11)

(NULL)

NO

(NULL)

select,insert,update,references

供应商ID

psu_pb_id

int(11)

(NULL)

NO

MUL

0

select,insert,update,references

商品品牌ID

psu_pb_p_innum

varchar(50)

utf8mb4_unicode_ci

NO

(NULL)

select,insert,update,references

商品物料编码

psu_orgcode

varchar(32)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

关联组织

psu_gczbq

varchar(255)

utf8mb4_unicode_ci

YES

select,insert,update,references

工厂质保期

psu_pack_style

varchar(255)

utf8mb4_unicode_ci

YES

select,insert,update,references

包装方式

psu_gckz

smallint(6)

(NULL)

YES

0

select,insert,update,references

是否工厂刻字

psu_zhibao

smallint(6)

(NULL)

YES

0

select,insert,update,references

工厂质保期(月)

psu_inbox_count

smallint(6)

(NULL)

YES

0

select,insert,update,references

内盒数量

psu_inbox_size

varchar(255)

utf8mb4_unicode_ci

NO

select,insert,update,references

内盒尺寸(cm)

psu_weight_net

decimal(10,3)

(NULL)

YES

0.000

select,insert,update,references

产品净重(kg)

psu_weight_gross

decimal(10,3)

(NULL)

YES

0.000

select,insert,update,references

产品毛重(kg)

psu_outbox_count

int(11)

(NULL)

YES

0

select,insert,update,references

外箱数量

psu_outbox_size

varchar(255)

utf8mb4_unicode_ci

YES

select,insert,update,references

外箱尺寸(cm)

psu_zjm

varchar(255)

utf8mb4_unicode_ci

YES

select,insert,update,references

助记码

psu_jhjq

int(11)

(NULL)

YES

0

select,insert,update,references

计划交期(天)

psu_minbuy

int(11)

(NULL)

YES

0

select,insert,update,references

起订量

psu_opuser

varchar(20)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

psu_create_time

timestamp

(NULL)

YES

(NULL)

select,insert,update,references

psu_update_time

timestamp

(NULL)

YES

(NULL)

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

pro_supplier

0

PRIMARY

1

psu_id

A

0

(NULL)

(NULL)

BTREE

pro_supplier

0

psu_uni

1

psu_pb_id

A

0

(NULL)

(NULL)

BTREE

pro_supplier

0

psu_uni

2

psu_p_id

A

0

(NULL)

(NULL)

BTREE

pro_supplier

0

psu_uni

3

psu_sup_id

A

0

(NULL)

(NULL)

BTREE

pro_supplier

1

psu_p_id

1

psu_p_id

A

0

(NULL)

(NULL)

BTREE

pro_supplier

1

psu_p_id

2

psu_pb_id

A

0

(NULL)

(NULL)

BTREE

Back

pro_synlog

Fields

Field Type Collation Null Key Default Extra Privileges Comment

psy_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

商品同步日志

psy_p_id

int(11)

(NULL)

NO

MUL

(NULL)

select,insert,update,references

商品ID

psy_act

enum('add','set','del')

utf8mb4_unicode_ci

NO

(NULL)

select,insert,update,references

操作

psy_type

enum('text','file')

utf8mb4_unicode_ci

NO

(NULL)

select,insert,update,references

操作类型文本|文件

psy_opuser

varchar(20)

utf8mb4_unicode_ci

NO

(NULL)

select,insert,update,references

操作人

psy_create_time

timestamp

(NULL)

NO

MUL

CURRENT_TIMESTAMP

on update CURRENT_TIMESTAMP

select,insert,update,references

操作时间

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

pro_synlog

0

PRIMARY

1

psy_id

A

3718

(NULL)

(NULL)

BTREE

pro_synlog

1

psy_create_time

1

psy_create_time

A

2664

(NULL)

(NULL)

BTREE

pro_synlog

1

psy_p_id

1

psy_p_id

A

3244

(NULL)

(NULL)

BTREE

Back

pro_tag_brand

Fields

Field Type Collation Null Key Default Extra Privileges Comment

ptb_p_id

int(11)

(NULL)

NO

PRI

(NULL)

select,insert,update,references

商品品牌标签

ptb_tb_id

int(11)

(NULL)

NO

PRI

(NULL)

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

pro_tag_brand

0

PRIMARY

1

ptb_p_id

A

34414

(NULL)

(NULL)

BTREE

pro_tag_brand

0

PRIMARY

2

ptb_tb_id

A

56982

(NULL)

(NULL)

BTREE

Back

province_city

Fields

Field Type Collation Null Key Default Extra Privileges Comment

pc_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

pc_pid

int(11)

(NULL)

YES

MUL

0

select,insert,update,references

上级ID

pc_name

varchar(64)

utf8mb4_unicode_ci

NO

MUL

(NULL)

select,insert,update,references

名称

pc_seq

int(11)

(NULL)

YES

MUL

999

select,insert,update,references

排序

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

province_city

0

PRIMARY

1

pc_id

A

51703

(NULL)

(NULL)

BTREE

province_city

1

idx_pc_seq

1

pc_seq

A

38567

(NULL)

(NULL)

YES

BTREE

province_city

1

pc_pid

1

pc_pid

A

3990

(NULL)

(NULL)

YES

BTREE

province_city

1

pc_name

1

pc_name

A

36972

(NULL)

(NULL)

BTREE

Back

sms

Fields

Field Type Collation Null Key Default Extra Privileges Comment

sms_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

sms_mb

char(11)

utf8mb4_unicode_ci

NO

MUL

(NULL)

select,insert,update,references

手机号

sms_code

char(6)

utf8mb4_unicode_ci

NO

(NULL)

select,insert,update,references

验证码

sms_remark

varchar(255)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

描述

sms_status

tinyint(4)

(NULL)

NO

0

select,insert,update,references

0:未使用, 1:已使用

sms_create_time

timestamp

(NULL)

NO

(NULL)

select,insert,update,references

创建时间

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

sms

0

PRIMARY

1

sms_id

A

0

(NULL)

(NULL)

BTREE

sms

1

sms_mb

1

sms_mb

A

0

(NULL)

(NULL)

BTREE

Back

supplier

Fields

Field Type Collation Null Key Default Extra Privileges Comment

sup_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

供应商

sup_name

varchar(255)

utf8mb4_unicode_ci

NO

MUL

(NULL)

select,insert,update,references

名称

sup_code

varchar(16)

utf8mb4_unicode_ci

NO

UNI

(NULL)

select,insert,update,references

编码

sup_qualification

json

(NULL)

YES

(NULL)

select,insert,update,references

供应商资质obj(20)

sup_level

int(11)

(NULL)

YES

0

select,insert,update,references

级别obj(15)

sup_haspro

smallint(6)

(NULL)

YES

0

select,insert,update,references

产品目录 1有 -1无

sup_status

smallint(6)

(NULL)

YES

1

select,insert,update,references

0潜在 1正式

sup_country

char(2)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

国家-country

sup_province_id

int(11)

(NULL)

YES

(NULL)

select,insert,update,references

省

sup_city_id

int(11)

(NULL)

YES

(NULL)

select,insert,update,references

市

sup_town_id

int(11)

(NULL)

YES

(NULL)

select,insert,update,references

区/镇

sup_follow_user

json

(NULL)

YES

(NULL)

select,insert,update,references

跟进人多选

sup_com_hy

varchar(255)

utf8mb4_unicode_ci

YES

select,insert,update,references

行业

sup_com_clsj

date

(NULL)

YES

(NULL)

select,insert,update,references

创立时间

sup_com_frdb

varchar(64)

utf8mb4_unicode_ci

YES

select,insert,update,references

法人代表

sup_com_zczj

int(11)

(NULL)

YES

0

select,insert,update,references

注册资金（万元）

sup_com_gsdj

varchar(255)

utf8mb4_unicode_ci

YES

select,insert,update,references

工商登记号

sup_com_uninum

varchar(255)

utf8mb4_unicode_ci

YES

select,insert,update,references

统一社会信用代码

sup_com_addr

varchar(255)

utf8mb4_unicode_ci

YES

select,insert,update,references

注册地址

sup_com_nsrsbh

varchar(255)

utf8mb4_unicode_ci

YES

select,insert,update,references

纳税人识别号

sup_com_nsrzz

varchar(255)

utf8mb4_unicode_ci

YES

select,insert,update,references

纳税人资质

sup_com_oldname

varchar(255)

utf8mb4_unicode_ci

YES

select,insert,update,references

曾用名

sup_com_enname

varchar(255)

utf8mb4_unicode_ci

YES

select,insert,update,references

英文名称

sup_com_worker

int(11)

(NULL)

YES

0

select,insert,update,references

人员规模

sup_com_status

varchar(32)

utf8mb4_unicode_ci

YES

select,insert,update,references

登记状态

sup_opuser

varchar(20)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

sup_create_time

timestamp

(NULL)

YES

(NULL)

select,insert,update,references

sup_update_time

timestamp

(NULL)

YES

(NULL)

select,insert,update,references

sup_from_id

int(11)

(NULL)

YES

0

select,insert,update,references

源ID

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

supplier

0

PRIMARY

1

sup_id

A

43

(NULL)

(NULL)

BTREE

supplier

0

sup_code

1

sup_code

A

43

(NULL)

(NULL)

BTREE

supplier

1

sup_name

1

sup_name

A

43

(NULL)

(NULL)

BTREE

Back

supplier_cate

Fields

Field Type Collation Null Key Default Extra Privileges Comment

sc_sup_id

int(11)

(NULL)

NO

PRI

0

select,insert,update,references

供应商ID

sc_cat_id

int(11)

(NULL)

NO

PRI

0

select,insert,update,references

零件分类

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

supplier_cate

0

PRIMARY

1

sc_sup_id

A

41

(NULL)

(NULL)

BTREE

supplier_cate

0

PRIMARY

2

sc_cat_id

A

190

(NULL)

(NULL)

BTREE

Back

supplier_contact

Fields

Field Type Collation Null Key Default Extra Privileges Comment

sco_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

供应商联系人

sco_sup_id

int(11)

(NULL)

NO

(NULL)

select,insert,update,references

供应商

sco_ismain

int(11)

(NULL)

NO

(NULL)

select,insert,update,references

主联系人

sco_name

varchar(255)

utf8mb4_unicode_ci

NO

(NULL)

select,insert,update,references

联系人

sco_phone

varchar(255)

utf8mb4_unicode_ci

YES

select,insert,update,references

手机

sco_tel

varchar(255)

utf8mb4_unicode_ci

YES

select,insert,update,references

电话

sco_job

varchar(255)

utf8mb4_unicode_ci

YES

select,insert,update,references

职位

sco_remark

varchar(512)

utf8mb4_unicode_ci

YES

select,insert,update,references

备注

sco_opuser

varchar(20)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

sco_create_time

timestamp

(NULL)

YES

(NULL)

select,insert,update,references

sco_update_time

timestamp

(NULL)

YES

(NULL)

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

supplier_contact

0

PRIMARY

1

sco_id

A

42

(NULL)

(NULL)

BTREE

Back

supplier_pro

Fields

Field Type Collation Null Key Default Extra Privileges Comment

spr_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

供应商产品目录

spr_oe_id

int(11)

(NULL)

YES

MUL

0

select,insert,update,references

关联的零件ID

spr_sup_id

int(11)

(NULL)

YES

MUL

0

select,insert,update,references

供应商ID

spr_area

int(11)

(NULL)

YES

0

select,insert,update,references

区域obj(21)

spr_cat_id

int(11)

(NULL)

NO

MUL

0

select,insert,update,references

零件分类

spr_pf_id

int(11)

(NULL)

NO

MUL

1

select,insert,update,references

号码厂商默认OE

spr_number

varchar(128)

utf8mb4_unicode_ci

NO

MUL

(NULL)

select,insert,update,references

spr_format

varchar(128)

utf8mb4_unicode_ci

NO

(NULL)

select,insert,update,references

spr_sup_num

varchar(128)

utf8mb4_unicode_ci

NO

select,insert,update,references

工厂号码

spr_material

int(11)

(NULL)

YES

MUL

0

select,insert,update,references

材质obj(16)

spr_price

decimal(10,2)

(NULL)

YES

0.00

select,insert,update,references

含税单价

spr_price2

decimal(10,2)

(NULL)

YES

0.00

select,insert,update,references

不含税价

spr_price3

decimal(10,2)

(NULL)

YES

0.00

select,insert,update,references

原厂价格

spr_price4

decimal(10,2)

(NULL)

YES

0.00

select,insert,update,references

指导价格

spr_minbuy

int(11)

(NULL)

YES

0

select,insert,update,references

起订量

spr_delivery

int(11)

(NULL)

YES

0

select,insert,update,references

交期(天)

spr_price_btime

date

(NULL)

YES

(NULL)

select,insert,update,references

工厂报价时间

spr_price_etime

date

(NULL)

YES

(NULL)

select,insert,update,references

价格失效时间

spr_price_status

enum('Y','N')

utf8mb4_unicode_ci

YES

Y

select,insert,update,references

价格状态有效无效

spr_has

enum('Y','N')

utf8mb4_unicode_ci

YES

Y

select,insert,update,references

是否现货

spr_hasample

enum('Y','N')

utf8mb4_unicode_ci

YES

Y

select,insert,update,references

是否提供样品

spr_from

int(11)

(NULL)

YES

MUL

0

select,insert,update,references

数据来源(13)

spr_remark

varchar(255)

utf8mb4_unicode_ci

YES

select,insert,update,references

备注

spr_opuser

varchar(20)

utf8mb4_unicode_ci

YES

MUL

(NULL)

select,insert,update,references

spr_create_time

timestamp

(NULL)

YES

(NULL)

select,insert,update,references

spr_update_time

timestamp

(NULL)

YES

(NULL)

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

supplier_pro

0

PRIMARY

1

spr_id

A

354

(NULL)

(NULL)

BTREE

supplier_pro

0

uni_spr

1

spr_cat_id

A

36

(NULL)

(NULL)

BTREE

supplier_pro

0

uni_spr

2

spr_sup_id

A

39

(NULL)

(NULL)

YES

BTREE

supplier_pro

0

uni_spr

3

spr_pf_id

A

39

(NULL)

(NULL)

BTREE

supplier_pro

0

uni_spr

4

spr_format

A

354

(NULL)

(NULL)

BTREE

supplier_pro

0

uni_spr

5

spr_material

A

354

(NULL)

(NULL)

YES

BTREE

supplier_pro

0

uni_spr

6

spr_area

A

354

(NULL)

(NULL)

YES

BTREE

supplier_pro

1

spr_oe_id

1

spr_oe_id

A

318

(NULL)

(NULL)

YES

BTREE

supplier_pro

1

spr_sup_id

1

spr_sup_id

A

14

(NULL)

(NULL)

YES

BTREE

supplier_pro

1

spr_cat_id

1

spr_cat_id

A

36

(NULL)

(NULL)

BTREE

supplier_pro

1

spr_pf_id

1

spr_pf_id

A

1

(NULL)

(NULL)

BTREE

supplier_pro

1

spr_format

1

spr_number

A

354

(NULL)

(NULL)

BTREE

supplier_pro

1

spr_material

1

spr_material

A

1

(NULL)

(NULL)

YES

BTREE

supplier_pro

1

spr_opuser

1

spr_opuser

A

1

(NULL)

(NULL)

YES

BTREE

supplier_pro

1

spr_from

1

spr_from

A

1

(NULL)

(NULL)

YES

BTREE

Back

tag_brand

Fields

Field Type Collation Null Key Default Extra Privileges Comment

tb_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

汽车品牌

tb_cn_name

varchar(200)

utf8mb4_unicode_ci

NO

(NULL)

select,insert,update,references

tb_en_name

varchar(200)

utf8mb4_unicode_ci

NO

(NULL)

select,insert,update,references

tb_py_name

varchar(200)

utf8mb4_unicode_ci

NO

(NULL)

select,insert,update,references

tb_sp_name

varchar(100)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

汽车品牌西语

tb_al_name

varchar(100)

utf8mb4_unicode_ci

YES

select,insert,update,references

汽车品牌阿拉伯

tb_seq

smallint(6)

(NULL)

YES

999

select,insert,update,references

排序小到大

tb_words

varchar(255)

utf8mb4_unicode_ci

YES

select,insert,update,references

关键字程序处理关联表使用

tb_opuser

varchar(20)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

tb_create_time

timestamp

(NULL)

YES

(NULL)

select,insert,update,references

tb_update_time

timestamp

(NULL)

YES

(NULL)

on update CURRENT_TIMESTAMP

select,insert,update,references

tb_from_ids

varchar(128)

utf8mb4_unicode_ci

YES

select,insert,update,references

源ID，多个逗号分隔

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

tag_brand

0

PRIMARY

1

tb_id

A

115

(NULL)

(NULL)

BTREE

Back

tag_brand_cnbrand

Fields

Field Type Collation Null Key Default Extra Privileges Comment

tbm_tb_id

int(11)

(NULL)

NO

PRI

(NULL)

select,insert,update,references

tbm_brand_id

int(11)

(NULL)

NO

PRI

(NULL)

select,insert,update,references

中国车型品牌

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

tag_brand_cnbrand

0

PRIMARY

1

tbm_tb_id

A

103

(NULL)

(NULL)

BTREE

tag_brand_cnbrand

0

PRIMARY

2

tbm_brand_id

A

144

(NULL)

(NULL)

BTREE

Back

tag_brand_make

Fields

Field Type Collation Null Key Default Extra Privileges Comment

tbm_tb_id

int(11)

(NULL)

NO

PRI

(NULL)

select,insert,update,references

tbm_mk_id

int(11)

(NULL)

NO

PRI

(NULL)

select,insert,update,references

国际车型汽车商

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

tag_brand_make

0

PRIMARY

1

tbm_tb_id

A

106

(NULL)

(NULL)

BTREE

tag_brand_make

0

PRIMARY

2

tbm_mk_id

A

257

(NULL)

(NULL)

BTREE

tag_brand_make

1

uni_key

1

tbm_mk_id

A

215

(NULL)

(NULL)

BTREE

tag_brand_make

1

uni_key

2

tbm_tb_id

A

257

(NULL)

(NULL)

BTREE

Back

tags

Fields

Field Type Collation Null Key Default Extra Privileges Comment

t_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

标签

cn_name

varchar(100)

utf8mb4_unicode_ci

NO

(NULL)

select,insert,update,references

en_name

varchar(100)

utf8mb4_unicode_ci

NO

(NULL)

select,insert,update,references

py_name

varchar(100)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

sp_name

varchar(100)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

标签西语

al_name

varchar(100)

utf8mb4_unicode_ci

YES

select,insert,update,references

标签阿拉伯

t_seq

smallint(6)

(NULL)

YES

0

select,insert,update,references

排序小到大

opuser

varchar(20)

utf8mb4_unicode_ci

NO

(NULL)

select,insert,update,references

create_time

timestamp

(NULL)

NO

CURRENT_TIMESTAMP

select,insert,update,references

update_time

timestamp

(NULL)

NO

CURRENT_TIMESTAMP

on update CURRENT_TIMESTAMP

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

tags

0

PRIMARY

1

t_id

A

4

(NULL)

(NULL)

BTREE

Back

tags_link

Fields

Field Type Collation Null Key Default Extra Privileges Comment

tl_type

enum('poe','poesup','pro','prosup')

utf8mb4_unicode_ci

NO

PRI

(NULL)

select,insert,update,references

模块 poe:零件库 pro:商品库 poesup零件供应商 prosup商品供应商

tl_t_id

int(11)

(NULL)

NO

PRI

(NULL)

select,insert,update,references

标签ID

tl_value_id

int(11)

(NULL)

NO

PRI

(NULL)

select,insert,update,references

模块值ID

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

tags_link

0

PRIMARY

1

tl_type

A

2

(NULL)

(NULL)

BTREE

tags_link

0

PRIMARY

2

tl_value_id

A

449

(NULL)

(NULL)

BTREE

tags_link

0

PRIMARY

3

tl_t_id

A

449

(NULL)

(NULL)

BTREE

tags_link

1

tl_value_id

1

tl_value_id

A

449

(NULL)

(NULL)

BTREE

tags_link

1

tl_t_id

1

tl_t_id

A

3

(NULL)

(NULL)

BTREE

Back

user

Fields

Field Type Collation Null Key Default Extra Privileges Comment

u_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

u_mb

char(11)

ascii_general_ci

NO

UNI

(NULL)

select,insert,update,references

手机号

u_code

varchar(32)

utf8mb4_unicode_ci

YES

select,insert,update,references

客户代号

u_level

int(11)

(NULL)

YES

0

select,insert,update,references

客户等级obj(25)

u_password

char(32)

utf8mb4_unicode_ci

NO

(NULL)

select,insert,update,references

密码

u_status

tinyint(1)

(NULL)

YES

0

select,insert,update,references

0:未审核, 1:已审核启用,-1:禁用

u_name

varchar(20)

utf8mb4_unicode_ci

NO

(NULL)

select,insert,update,references

真实姓名

u_sex

tinyint(1)

(NULL)

NO

1

select,insert,update,references

1:男，0:女

u_email

varchar(200)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

邮箱

u_wx

varchar(200)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

微信

u_wx_unionid

varchar(64)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

微信号唯一标识码

u_wx_info

text

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

微信基本信息

u_company

varchar(200)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

公司名称

u_address

varchar(200)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

地址

u_last_login_time

timestamp

(NULL)

YES

(NULL)

select,insert,update,references

最后登录时间

u_adm_au_id

varchar(20)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

审核者

u_remark

varchar(255)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

审核备注

u_score

int(11)

(NULL)

NO

0

select,insert,update,references

用户积分

u_mycate_ids

varchar(255)

utf8mb4_unicode_ci

YES

select,insert,update,references

收藏的分类ID

u_from

enum('cn','en')

utf8mb4_unicode_ci

NO

cn

select,insert,update,references

来源china world

u_create_time

timestamp

(NULL)

NO

(NULL)

select,insert,update,references

创建时间

u_update_time

timestamp

(NULL)

NO

(NULL)

on update CURRENT_TIMESTAMP

select,insert,update,references

更新时间

u_password_time

timestamp

(NULL)

YES

(NULL)

select,insert,update,references

密码更新时间

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

user

0

PRIMARY

1

u_id

A

6

(NULL)

(NULL)

BTREE

user

0

u_mb

1

u_mb

A

6

(NULL)

(NULL)

BTREE

Back

user_access

Fields

Field Type Collation Null Key Default Extra Privileges Comment

ua_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

ua_u_id

int(11)

(NULL)

NO

MUL

(NULL)

select,insert,update,references

用户ID

ua_date

int(11)

(NULL)

NO

(NULL)

select,insert,update,references

日期(到天)

ua_vin

int(11)

(NULL)

NO

0

select,insert,update,references

vin查询次数

ua_number

int(11)

(NULL)

NO

0

select,insert,update,references

num查询次数

ua_model

int(11)

(NULL)

NO

0

select,insert,update,references

model查询次数

ua_param

int(11)

(NULL)

NO

0

select,insert,update,references

param查询次数

ua_enoenum

int(11)

(NULL)

YES

0

select,insert,update,references

国际OE查询

ua_engspnum

int(11)

(NULL)

YES

0

select,insert,update,references

国际gsp查询

ua_enmodel

int(11)

(NULL)

YES

0

select,insert,update,references

国际车型查询

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

user_access

0

PRIMARY

1

ua_id

A

0

(NULL)

(NULL)

BTREE

user_access

0

ua_u_id

1

ua_u_id

A

0

(NULL)

(NULL)

BTREE

user_access

0

ua_u_id

2

ua_date

A

0

(NULL)

(NULL)

BTREE

Back

user_error

Fields

Field Type Collation Null Key Default Extra Privileges Comment

ue_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

ue_p_id

int(11)

(NULL)

NO

(NULL)

select,insert,update,references

产品ID

ue_type

enum('车型问题','配件问题','其他问题')

utf8mb4_unicode_ci

NO

(NULL)

select,insert,update,references

错误类型

ue_cause

varchar(200)

utf8mb4_unicode_ci

NO

(NULL)

select,insert,update,references

错误原因

ue_image

varchar(255)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

ue_u_id

int(11)

(NULL)

YES

(NULL)

select,insert,update,references

用户ID

ue_mb

varchar(20)

utf8mb4_unicode_ci

NO

(NULL)

select,insert,update,references

手机号

ue_user_info

varchar(1024)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

联系方式json

ue_status

enum('未读','已读','未处理','已处理','无法处理问题','已处理-加积分')

utf8mb4_unicode_ci

NO

未读

select,insert,update,references

状态

ue_status_remark

varchar(1024)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

状态描述

ue_adm_id

varchar(20)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

处理人

ue_create_time

timestamp

(NULL)

NO

CURRENT_TIMESTAMP

on update CURRENT_TIMESTAMP

select,insert,update,references

ue_update_time

timestamp

(NULL)

NO

0000-00-00 00:00:00

select,insert,update,references

ue_done_time

timestamp

(NULL)

YES

(NULL)

select,insert,update,references

处理时间

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

user_error

0

PRIMARY

1

ue_id

A

0

(NULL)

(NULL)

BTREE

Back

user_history

Fields

Field Type Collation Null Key Default Extra Privileges Comment

guh_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

guh_u_id

int(11)

(NULL)

NO

(NULL)

select,insert,update,references

guh_p_id

int(11)

(NULL)

YES

0

select,insert,update,references

guh_atime

timestamp

(NULL)

YES

(NULL)

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

user_history

0

PRIMARY

1

guh_id

A

0

(NULL)

(NULL)

BTREE

Back

user_link_role

Fields

Field Type Collation Null Key Default Extra Privileges Comment

ulr_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

ult_u_id

varchar(20)

utf8mb4_unicode_ci

NO

MUL

(NULL)

select,insert,update,references

用户ID

ult_ur_id

int(11)

(NULL)

NO

MUL

(NULL)

select,insert,update,references

角色ID

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

user_link_role

0

PRIMARY

1

ulr_id

A

0

(NULL)

(NULL)

BTREE

user_link_role

1

ult_ur_id

1

ult_ur_id

A

0

(NULL)

(NULL)

BTREE

user_link_role

1

ult_u_id

1

ult_u_id

A

0

(NULL)

(NULL)

BTREE

user_link_role

1

ult_u_id

2

ult_ur_id

A

0

(NULL)

(NULL)

BTREE

Back

user_role

Fields

Field Type Collation Null Key Default Extra Privileges Comment

ur_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

角色ID

ur_name

varchar(100)

utf8mb4_unicode_ci

NO

(NULL)

select,insert,update,references

角色名称

ur_remark

varchar(255)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

角色描述

ur_allow_vin

int(11)

(NULL)

YES

(NULL)

select,insert,update,references

VIN每日查询限制

ur_allow_num

int(11)

(NULL)

YES

(NULL)

select,insert,update,references

号码每日查询限制

ur_allow_model

int(11)

(NULL)

YES

(NULL)

select,insert,update,references

车型索引每日查询限制

ur_allow_param

int(11)

(NULL)

YES

(NULL)

select,insert,update,references

参数每日查询限制

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

user_role

0

PRIMARY

1

ur_id

A

0

(NULL)

(NULL)

BTREE

Back

user_role_link_ids

Fields

Field Type Collation Null Key Default Extra Privileges Comment

urr_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

urr_ur_id

int(11)

(NULL)

NO

MUL

(NULL)

select,insert,update,references

urr_table

enum('part','part_param','nums','model_china')

utf8mb4_unicode_ci

NO

MUL

(NULL)

select,insert,update,references

urr_table_id

int(11)

(NULL)

YES

(NULL)

select,insert,update,references

urr_power

int(11)

(NULL)

NO

(NULL)

select,insert,update,references

1:查看,4:编辑

urr_string

varchar(50)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

user_role_link_ids

0

PRIMARY

1

urr_id

A

0

(NULL)

(NULL)

BTREE

user_role_link_ids

1

urr_ur_id

1

urr_ur_id

A

0

(NULL)

(NULL)

BTREE

user_role_link_ids

1

urr_table

1

urr_table

A

0

(NULL)

(NULL)

BTREE

Back

user_role_link_mod

Fields

Field Type Collation Null Key Default Extra Privileges Comment

urlm_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

urlm_ur_id

int(11)

(NULL)

NO

MUL

(NULL)

select,insert,update,references

角色ID

urlm_am_id

int(11)

(NULL)

NO

MUL

(NULL)

select,insert,update,references

模块ID

urlm_power

int(11)

(NULL)

NO

(NULL)

select,insert,update,references

1:查看,2:添加,4:编辑,8:删除,16:导入,32:导出,64:执行

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

user_role_link_mod

0

PRIMARY

1

urlm_id

A

0

(NULL)

(NULL)

BTREE

user_role_link_mod

1

urlm_am_id

1

urlm_am_id

A

0

(NULL)

(NULL)

BTREE

user_role_link_mod

1

urlm_ur_id

1

urlm_ur_id

A

0

(NULL)

(NULL)

BTREE

Back

user_score

Fields

Field Type Collation Null Key Default Extra Privileges Comment

us_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

us_type

varchar(50)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

类型

us_u_id

varchar(20)

utf8mb4_unicode_ci

NO

(NULL)

select,insert,update,references

us_au_id

varchar(11)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

us_ue_id

int(11)

(NULL)

YES

(NULL)

select,insert,update,references

纠错表ID

us_score

int(11)

(NULL)

NO

(NULL)

select,insert,update,references

积分

us_remark

varchar(200)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

说明

us_create_time

timestamp

(NULL)

NO

MUL

CURRENT_TIMESTAMP

on update CURRENT_TIMESTAMP

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

user_score

0

PRIMARY

1

us_id

A

74

(NULL)

(NULL)

BTREE

user_score

1

us_create_time

1

us_create_time

A

73

(NULL)

(NULL)

BTREE

Back

work_ask

Fields

Field Type Collation Null Key Default Extra Privileges Comment

was_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

询单ID

was_title

varchar(255)

utf8mb4_unicode_ci

YES

MUL

select,insert,update,references

标题

was_u_code

varchar(32)

utf8mb4_unicode_ci

YES

select,insert,update,references

客户代号

was_uname

varchar(128)

utf8mb4_unicode_ci

YES

select,insert,update,references

联系人

was_utel

varchar(64)

utf8mb4_unicode_ci

YES

MUL

select,insert,update,references

电话

was_remark

varchar(512)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

询单描述

was_status

int(11)

(NULL)

YES

MUL

0

select,insert,update,references

0待处理 1已完成

was_u_id

int(11)

(NULL)

YES

MUL

0

select,insert,update,references

客户ID

was_remark_sys

varchar(512)

utf8mb4_unicode_ci

YES

select,insert,update,references

平台备注

was_money_type

varchar(32)

utf8mb4_unicode_ci

YES

CNY

select,insert,update,references

币种

was_money_rate

float

(NULL)

YES

1

select,insert,update,references

币种对人民币汇率 1USD=7.6CNY

was_count_total

int(11)

(NULL)

YES

0

select,insert,update,references

总数量

was_item_total

int(11)

(NULL)

YES

0

select,insert,update,references

明细总数

was_money_total

decimal(10,2)

(NULL)

YES

0.00

select,insert,update,references

总价

was_sale_opuser

varchar(20)

utf8mb4_unicode_ci

YES

select,insert,update,references

业务员

was_opuser

varchar(20)

utf8mb4_unicode_ci

NO

(NULL)

select,insert,update,references

修改人

was_create_time

timestamp

(NULL)

NO

MUL

(NULL)

on update CURRENT_TIMESTAMP

select,insert,update,references

创建时间

was_update_time

timestamp

(NULL)

YES

(NULL)

select,insert,update,references

修改时间

was_ok_time

timestamp

(NULL)

YES

(NULL)

select,insert,update,references

完成时间

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

work_ask

0

PRIMARY

1

was_id

A

3

(NULL)

(NULL)

BTREE

work_ask

1

was_title

1

was_title

A

3

(NULL)

(NULL)

YES

BTREE

work_ask

1

was_utel

1

was_utel

A

1

(NULL)

(NULL)

YES

BTREE

work_ask

1

was_u_id

1

was_u_id

A

1

(NULL)

(NULL)

YES

BTREE

work_ask

1

was_status

1

was_status

A

2

(NULL)

(NULL)

YES

BTREE

work_ask

1

was_create_time

1

was_create_time

A

3

(NULL)

(NULL)

BTREE

Back

work_ask_item

Fields

Field Type Collation Null Key Default Extra Privileges Comment

wai_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

询单明细

wai_was_id

int(11)

(NULL)

NO

(NULL)

select,insert,update,references

询单ID

wai_status

int(11)

(NULL)

YES

MUL

0

select,insert,update,references

-1忽略 0待处理 1已处理

wai_cat_id

int(11)

(NULL)

YES

0

select,insert,update,references

小类ID

wai_name

varchar(128)

utf8mb4_unicode_ci

YES

select,insert,update,references

名称

wai_count

int(11)

(NULL)

YES

1

select,insert,update,references

数量

wai_des

varchar(255)

utf8mb4_unicode_ci

YES

select,insert,update,references

描述

wai_sup_id

int(11)

(NULL)

YES

0

select,insert,update,references

供应商ID

wai_cost_status

smallint(6)

(NULL)

YES

0

select,insert,update,references

成本状态 -1忽略 0待处理 1已处理

wai_cost_from

json

(NULL)

YES

(NULL)

select,insert,update,references

成本价参考源信息

wai_cost_price

decimal(10,2)

(NULL)

YES

0.00

select,insert,update,references

成本价CNY

wai_cost_opuser

varchar(20)

utf8mb4_unicode_ci

YES

select,insert,update,references

成本价填写人

wai_cost_time

timestamp

(NULL)

YES

(NULL)

select,insert,update,references

成本价填写时间

wai_material

int(11)

(NULL)

YES

0

select,insert,update,references

材质obj(16)

wai_hasshui

smallint(6)

(NULL)

YES

1

select,insert,update,references

是否含税

wai_tuishui

smallint(6)

(NULL)

YES

-1

select,insert,update,references

是否退税

wai_haspack

smallint(6)

(NULL)

YES

1

select,insert,update,references

是否含包装

wai_delivery

int(11)

(NULL)

NO

0

select,insert,update,references

交期(天)

wai_pb_id

int(11)

(NULL)

YES

0

select,insert,update,references

商品品牌

wai_price

decimal(10,2)

(NULL)

YES

0.00

select,insert,update,references

销售价对应币种的单价

wai_price_opuser

varchar(20)

utf8mb4_unicode_ci

YES

select,insert,update,references

销售价填写人

wai_price_time

timestamp

(NULL)

YES

(NULL)

select,insert,update,references

销售价填写时间

wai_money_total

decimal(10,2)

(NULL)

YES

0.00

select,insert,update,references

总价

wai_remark

varchar(255)

utf8mb4_unicode_ci

YES

select,insert,update,references

内部备注[仅后台看]

wai_remark_user

varchar(255)

utf8mb4_unicode_ci

YES

select,insert,update,references

客户备注

wai_spr_id

int(11)

(NULL)

YES

0

select,insert,update,references

参考的供应商目录supplier_pro

wai_oe_id

int(11)

(NULL)

YES

0

select,insert,update,references

零件ID

wai_from_wai_id

int(11)

(NULL)

YES

0

select,insert,update,references

参考的历史报价

wai_opuser

varchar(20)

utf8mb4_unicode_ci

YES

MUL

(NULL)

select,insert,update,references

wai_create_time

timestamp

(NULL)

YES

(NULL)

select,insert,update,references

wai_update_time

timestamp

(NULL)

YES

(NULL)

select,insert,update,references

wai_data

json

(NULL)

YES

(NULL)

select,insert,update,references

原始数据

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

work_ask_item

0

PRIMARY

1

wai_id

A

1162

(NULL)

(NULL)

BTREE

work_ask_item

1

wai_status

1

wai_status

A

2

(NULL)

(NULL)

YES

BTREE

work_ask_item

1

unikey

1

wai_opuser

A

3

(NULL)

(NULL)

YES

BTREE

Back

work_ask_item_log

Fields

Field Type Collation Null Key Default Extra Privileges Comment

wail_id

int(11)

(NULL)

NO

PRI

(NULL)

select,insert,update,references

wail_wai_id

int(11)

(NULL)

NO

MUL

(NULL)

select,insert,update,references

wail_type

enum('cost_price','price')

utf8mb4_unicode_ci

NO

(NULL)

select,insert,update,references

成本价销售价

wail_price

decimal(10,2)

(NULL)

NO

(NULL)

select,insert,update,references

wail_data

json

(NULL)

YES

(NULL)

select,insert,update,references

变更前数据

wail_opuser

varchar(20)

utf8mb4_unicode_ci

NO

(NULL)

select,insert,update,references

wail_create_time

timestamp

(NULL)

NO

(NULL)

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

work_ask_item_log

0

PRIMARY

1

wail_id

A

0

(NULL)

(NULL)

BTREE

work_ask_item_log

1

wail_wai_id

1

wail_wai_id

A

0

(NULL)

(NULL)

BTREE

Back

work_ask_item_num

Fields

Field Type Collation Null Key Default Extra Privileges Comment

wain_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

询单项目的号码

wain_was_id

int(11)

(NULL)

YES

MUL

(NULL)

select,insert,update,references

wain_wai_id

int(11)

(NULL)

NO

MUL

(NULL)

select,insert,update,references

work_ask_item

wain_pf_name

varchar(64)

utf8mb4_unicode_ci

YES

select,insert,update,references

wain_number

varchar(128)

utf8mb4_unicode_ci

NO

MUL

(NULL)

select,insert,update,references

号码

wain_format

varchar(128)

utf8mb4_unicode_ci

NO

(NULL)

select,insert,update,references

格式化号码

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

work_ask_item_num

0

PRIMARY

1

wain_id

A

1181

(NULL)

(NULL)

BTREE

work_ask_item_num

1

wain_number

1

wain_number

A

1157

(NULL)

(NULL)

BTREE

work_ask_item_num

1

wain_id

1

wain_wai_id

A

1162

(NULL)

(NULL)

BTREE

work_ask_item_num

1

wain_was_id

1

wain_was_id

A

2

(NULL)

(NULL)

YES

BTREE

Back

work_data_item

Fields

Field Type Collation Null Key Default Extra Privileges Comment

wdi_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

数据工单明细

wdi_wdlist_id

int(11)

(NULL)

NO

MUL

(NULL)

select,insert,update,references

工单

wdi_cat_id

int(11)

(NULL)

YES

MUL

0

select,insert,update,references

品类ID

wdi_data

json

(NULL)

YES

(NULL)

select,insert,update,references

原始数据

wdi_clean

smallint(6)

(NULL)

YES

MUL

-1

select,insert,update,references

-1待清洗 1已清洗

wdi_clean_has

smallint(6)

(NULL)

YES

MUL

-1

select,insert,update,references

-1无结果 1有结果

wdi_clean_result

json

(NULL)

YES

(NULL)

select,insert,update,references

清洗结果

wdi_clean_time

timestamp

(NULL)

YES

(NULL)

select,insert,update,references

wdi_chkres

json

(NULL)

YES

(NULL)

select,insert,update,references

检测结果

wdi_chkpro_from

varchar(16)

utf8mb4_unicode_ci

YES

select,insert,update,references

确认的产品来源

wdi_chkpro_id

int(11)

(NULL)

YES

0

select,insert,update,references

确认的产品ID

wdi_chkpro_info

json

(NULL)

YES

(NULL)

select,insert,update,references

确认的产品的基本信息wdi_chkpro_from!=self

wdi_chkpro_clean

smallint(6)

(NULL)

YES

MUL

-1

select,insert,update,references

-1待清洗 1已清洗

wdi_chkpro_clean_has

smallint(6)

(NULL)

YES

-1

select,insert,update,references

-1无结果 1有结果

wdi_chkpro_clean_result

json

(NULL)

YES

(NULL)

select,insert,update,references

确认产品的清洗数据

wdi_chkpro_clean_chk

json

(NULL)

YES

(NULL)

select,insert,update,references

确认产品的清洗数据的操作

wdi_chkpro_clean_time

timestamp

(NULL)

YES

(NULL)

select,insert,update,references

wdi_chkpro_clean_by

json

(NULL)

YES

(NULL)

select,insert,update,references

清洗参数

wdi_modmake

varchar(255)

utf8mb4_unicode_ci

YES

select,insert,update,references

确认数据的汽车生产商

wdi_oeitem

json

(NULL)

YES

(NULL)

select,insert,update,references

临时记录oe_item

wdi_opuser

varchar(20)

utf8mb4_unicode_ci

YES

MUL

(NULL)

select,insert,update,references

wdi_create_time

timestamp

(NULL)

YES

(NULL)

select,insert,update,references

wdi_update_time

timestamp

(NULL)

YES

(NULL)

select,insert,update,references

wdi_ar_id

int(11)

(NULL)

YES

MUL

(NULL)

select,insert,update,references

任务角色

wdi_from_opuser

varchar(20)

utf8mb4_unicode_ci

YES

MUL

(NULL)

select,insert,update,references

分配人

wdi_from_time

timestamp

(NULL)

YES

(NULL)

select,insert,update,references

分配时间

wdi_dstatus

smallint(6)

(NULL)

YES

0

select,insert,update,references

数据处理状态 0待处理 1已完成

wdi_dstatus_user

varchar(20)

utf8mb4_unicode_ci

YES

select,insert,update,references

数据处理人

wdi_dstatus_time

timestamp

(NULL)

YES

(NULL)

select,insert,update,references

数据处理时间

wdi_sstatus

smallint(6)

(NULL)

YES

0

select,insert,update,references

供应商处理状态 0待处理 1已完成

wdi_sstatus_user

varchar(20)

utf8mb4_unicode_ci

YES

select,insert,update,references

供应商处理人

wdi_sstatus_time

timestamp

(NULL)

YES

(NULL)

select,insert,update,references

供应商处理时间

wdi_from

int(11)

(NULL)

YES

0

select,insert,update,references

数据单来源 obj(13)

wdi_from_id

int(11)

(NULL)

YES

MUL

0

select,insert,update,references

来源ID

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

work_data_item

0

PRIMARY

1

wdi_id

A

29488

(NULL)

(NULL)

BTREE

work_data_item

1

wdi_wdlist_id

1

wdi_wdlist_id

A

380

(NULL)

(NULL)

BTREE

work_data_item

1

wdi_cat_id

1

wdi_cat_id

A

392

(NULL)

(NULL)

YES

BTREE

work_data_item

1

wdi_clean

1

wdi_clean

A

1

(NULL)

(NULL)

YES

BTREE

work_data_item

1

wdi_clean_has

1

wdi_clean_has

A

2

(NULL)

(NULL)

YES

BTREE

work_data_item

1

wdi_chkpro_clean

1

wdi_chkpro_clean

A

2

(NULL)

(NULL)

YES

BTREE

work_data_item

1

wdi_ar_id

1

wdi_ar_id

A

1

(NULL)

(NULL)

YES

BTREE

work_data_item

1

wdi_opuser

1

wdi_opuser

A

2

(NULL)

(NULL)

YES

BTREE

work_data_item

1

wdi_from_opuser

1

wdi_from_opuser

A

1

(NULL)

(NULL)

YES

BTREE

work_data_item

1

wdi_from

1

wdi_id

A

29488

(NULL)

(NULL)

BTREE

work_data_item

1

wdi_from

2

wdi_from

A

29488

(NULL)

(NULL)

YES

BTREE

work_data_item

1

wdi_from_id

1

wdi_from_id

A

29488

(NULL)

(NULL)

YES

BTREE

Back

work_data_item_format

Fields

Field Type Collation Null Key Default Extra Privileges Comment

wdif_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

格式化数据工单明细

wdif_wdi_id

int(11)

(NULL)

YES

MUL

(NULL)

select,insert,update,references

work_data_item 数据工单明细

wdif_type

enum('Number','Make','Engine','Model','P','Para','Image','Image2','Other')

utf8mb4_unicode_ci

YES

MUL

(NULL)

select,insert,update,references

数据类型

wdif_val

varchar(1024)

utf8mb4_unicode_ci

NO

(NULL)

select,insert,update,references

显示值

wdif_search

varchar(512)

utf8mb4_unicode_ci

YES

MUL

(NULL)

select,insert,update,references

搜索使用如号码

wdif_pf_id

int(11)

(NULL)

YES

MUL

0

select,insert,update,references

号码的厂商

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

work_data_item_format

0

PRIMARY

1

wdif_id

A

46094

(NULL)

(NULL)

BTREE

work_data_item_format

1

wdif_pf_id

1

wdif_pf_id

A

1

(NULL)

(NULL)

YES

BTREE

work_data_item_format

1

wdif_search

1

wdif_search

A

42194

(NULL)

(NULL)

YES

BTREE

work_data_item_format

1

wdif_wdi_id

1

wdif_wdi_id

A

45126

(NULL)

(NULL)

YES

BTREE

work_data_item_format

1

wdif_type

1

wdif_type

A

1

(NULL)

(NULL)

YES

BTREE

Back

work_data_list

Fields

Field Type Collation Null Key Default Extra Privileges Comment

wdlist_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

数据工单ID

wdlist_sup_id

int(11)

(NULL)

YES

0

select,insert,update,references

供应商ID

wdlist_seq

varchar(60)

utf8mb4_unicode_ci

NO

(NULL)

select,insert,update,references

单号

wdlist_cols

json

(NULL)

YES

(NULL)

select,insert,update,references

导入的表头属性

wdlist_from_opuser

varchar(20)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

数据添加人

wdlist_title

varchar(255)

utf8mb4_unicode_ci

YES

select,insert,update,references

标题

wdlist_type

int(11)

(NULL)

YES

0

select,insert,update,references

数据单类型 obj(14)

wdlist_remark

varchar(512)

utf8mb4_unicode_ci

YES

(NULL)

select,insert,update,references

备注描述

wdlist_status

int(11)

(NULL)

YES

0

select,insert,update,references

0待处理 1已处理

wdlist_opuser

varchar(20)

utf8mb4_unicode_ci

NO

(NULL)

select,insert,update,references

创建人

wdlist_create_time

timestamp

(NULL)

NO

CURRENT_TIMESTAMP

on update CURRENT_TIMESTAMP

select,insert,update,references

创建时间

wdlist_update_time

timestamp

(NULL)

YES

(NULL)

select,insert,update,references

wdlist_from

int(11)

(NULL)

YES

0

select,insert,update,references

数据单来源 obj(13)

wdlist_from_id

int(11)

(NULL)

YES

0

select,insert,update,references

来源ID

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

work_data_list

0

PRIMARY

1

wdlist_id

A

379

(NULL)

(NULL)

BTREE

Back

ztemp_init

Fields

Field Type Collation Null Key Default Extra Privileges Comment

z_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

z_status

smallint(6)

(NULL)

YES

MUL

0

select,insert,update,references

z_data

json

(NULL)

YES

(NULL)

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment Index
comment

ztemp_init

0

PRIMARY

1

z_id

A

40004

(NULL)

(NULL)

BTREE

ztemp_init

1

status

1

z_status

A

1

(NULL)

(NULL)

YES

BTREE

Back

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
amsg_id	int(11)	(NULL)	NO	PRI	(NULL)	auto_increment	select,insert,update,references
amsg_type	tinyint(4)	(NULL)	NO		0		select,insert,update,references	类型,(0:普通，1:事件, 3:预警)
amsg_from	varchar(20)	utf8mb4_unicode_ci	NO				select,insert,update,references	谁发的
amsg_title	varchar(255)	utf8mb4_unicode_ci	NO				select,insert,update,references
amsg_body	varchar(1024)	utf8mb4_unicode_ci	NO				select,insert,update,references	信息体
amsg_url	varchar(255)	utf8mb4_unicode_ci	NO				select,insert,update,references	操作网址
amsg_urltitle	varchar(255)	utf8mb4_unicode_ci	NO				select,insert,update,references	网址标题
amsg_file	varchar(255)	utf8mb4_unicode_ci	NO				select,insert,update,references
amsg_send_mail	tinyint(4)	(NULL)	NO		0		select,insert,update,references	是否需要发送邮件
amsg_send_sms	tinyint(4)	(NULL)	NO		0		select,insert,update,references	是否需要发送短信
amsg_event	tinyint(4)	(NULL)	NO		0		select,insert,update,references	处理事件标记
amsg_event_user	varchar(20)	utf8mb4_unicode_ci	NO				select,insert,update,references	处理事件的人
amsg_delete	tinyint(4)	(NULL)	NO		0		select,insert,update,references	虚删除
create_time	timestamp	(NULL)	NO		CURRENT_TIMESTAMP		select,insert,update,references	创建时间
update_time	timestamp	(NULL)	NO		CURRENT_TIMESTAMP	on update CURRENT_TIMESTAMP	select,insert,update,references	完成时间