eccommon_platform_regions

平台地区表

所属应用: eccommon

表结构

ColumnName	Comment	Type	Not null	Default	Autoincrement
id	id	int(10) unsigned	Y		Y
outregion_id	平台区域id	bigint(20)	N	0	N
outregion_name	平台区域名称	varchar(50)	N		N
outparent_id	平台父区域id	bigint(20)	N	0	N
outparent_name	平台父区域名称	varchar(50)	N	0	N
out_path_name	平台多级路径	varchar(255)	N		N
out_path_id	平台多级路径ID	varchar(255)	N		N
region_grade	区域层级	mediumint(8) unsigned	N	1	N
shop_type	平台类型	varchar(50)	N		N
local_region_id	oms区域id	bigint(20)	N	0	N
local_region_name	oms区域名称	varchar(50)	N		N
local_path_name	oms多级路径	varchar(255)	N		N
mapping	是否关联 0:未关联;1:已关联;	enum('0','1')	N	0	N

索引

Key name	Column names	Unique	Comment
primary	id	Y
ind_local_region_id	local_region_id	N
ind_local_path_name	local_path_name, shop_type	Y
ind_shop_outregion_name	shop_type, outregion_name	N
ind_shop_region_name	shop_type, local_region_name	N
ind_shop_outregion	shop_type, region_grade, outregion_name, outparent_id	N