Skip to content

Mongodb扫描结果

mongodb扫描结果

Database: xnn_core_product_2

Collection: async_task

Field_compact_name Field_name Count Percentage Types_count
_id _id 303 100.0 string : 303
create_time create_time 303 100.0 date : 303
details details 303 100.0 OBJECT : 303
. data data 303 100.0 ARRAY(OBJECT : 3284) : 303
. : address_id address_id 3284 1083.83 integer : 3284
. : cart cart 3284 1083.83 ARRAY(OBJECT : 35452) : 3284
. : : amount amount 35452 1079.54 integer : 35229, float : 182, string : 41
. : : sku_id sku_id 35452 1079.54 string : 35452
. : : spu_id spu_id 35452 1079.54 string : 35452
. : : spu_remark spu_remark 35452 1079.54 string : 35450, float : 2
. : : unit_price unit_price 35452 1079.54 string : 35250, float : 121, integer : 81
. : end_time end_time 3284 1083.83 date : 3284
. : flagEnd flagEnd 3284 1083.83 integer : 3284
. : flagStart flagStart 3284 1083.83 integer : 3284
. : receive_begin_time receive_begin_time 3284 1083.83 string : 3284
. : receive_end_time receive_end_time 3284 1083.83 string : 3284
. : result result 3284 1083.83 OBJECT : 3284
. : . code code 3284 100.0 integer : 3284
. : . data data 3284 100.0 OBJECT : 3284
. : . . order_id order_id 3284 100.0 string : 3284
. : . msg msg 3284 100.0 string : 3284
. : start_time start_time 3284 1083.83 date : 3284
. : status status 3284 1083.83 integer : 3284
. : timeEnd timeEnd 3284 1083.83 string : 3284
. : timeStart timeStart 3284 1083.83 string : 3284
. : uid uid 3284 1083.83 integer : 3284
. group_id group_id 303 100.0 integer : 303
. station_id station_id 303 100.0 string : 303
. time_config_id time_config_id 303 100.0 string : 303
. user_id user_id 303 100.0 integer : 303
end_time end_time 303 100.0 date : 303
modify_time modify_time 303 100.0 date : 303
start_time start_time 303 100.0 date : 303
status status 303 100.0 integer : 303
type type 303 100.0 integer : 303

Collection: attritem

Field_compact_name Field_name Count Percentage Types_count
_id _id 7 100.0 string : 7
active active 7 100.0 integer : 7
desc desc 7 100.0 string : 7
kind kind 7 100.0 integer : 7
name name 7 100.0 string : 7

Collection: attritem_rel

Field_compact_name Field_name Count Percentage Types_count
_id _id 21 100.0 oid : 21
attr_id attr_id 21 100.0 string : 21
must must 21 100.0 integer : 21
rel_id rel_id 21 100.0 string : 21

Collection: attrvalue

Field_compact_name Field_name Count Percentage Types_count
_id _id 49 100.0 string : 49
attr_id attr_id 49 100.0 string : 49
value value 49 100.0 string : 49

Collection: attrvalue_sxu

Field_compact_name Field_name Count Percentage Types_count
_id _id 32 100.0 oid : 32
sxu_id sxu_id 32 100.0 string : 32
value_id value_id 32 100.0 string : 32

Collection: batch_stock

Field_compact_name Field_name Count Percentage Types_count
_id _id 10000 100.0 oid : 10000
_lock _lock 10000 100.0 boolean : 10000
avg_price avg_price 10000 100.0 integer : 9748, float : 252
batch_number batch_number 10000 100.0 string : 10000
create_time create_time 10000 100.0 date : 10000
remain remain 10000 100.0 float : 9973, integer : 27
sheet_no sheet_no 10000 100.0 string : 10000
shelf_id shelf_id 10000 100.0 null : 10000
shelf_name shelf_name 10000 100.0 null : 10000
sku_id sku_id 10000 100.0 string : 10000
spu_id spu_id 10000 100.0 string : 10000
station_id station_id 10000 100.0 string : 10000
supplier_id supplier_id 10000 100.0 string : 9974, null : 26
supplier_name supplier_name 10000 100.0 string : 9974, null : 26
update_time update_time 10000 100.0 date : 10000
life_time life_time 9849 98.49 null : 9849
name name 9849 98.49 string : 9849
refund_id refund_id 151 1.51 integer : 151
abandon_goods abandon_goods 26 0.26 integer : 26

Collection: batch_stock_flow

Field_compact_name Field_name Count Percentage Types_count
_id _id 10000 100.0 oid : 10000
batch_number batch_number 10000 100.0 string : 9968, null : 32
create_time create_time 10000 100.0 date : 10000
new_remain new_remain 10000 100.0 float : 9801, integer : 199
old_remain old_remain 10000 100.0 integer : 9923, float : 77
operate_type operate_type 10000 100.0 integer : 10000
operator operator 10000 100.0 string : 10000

Collection: customized_info

Field_compact_name Field_name Count Percentage Types_count
_id _id 575 100.0 oid : 575
key key 575 100.0 string : 575
manager manager 575 100.0 string : 575
can_inherited can_inherited 528 91.83 integer : 525, float : 3
app_secret app_secret 390 67.83 string : 386, null : 4
appid appid 390 67.83 string : 386, null : 4
name name 365 63.480000000000004 string : 365
phone phone 338 58.78 string : 338
title title 338 58.78 string : 338
banners banners 303 52.7 ARRAY(string : 474) : 303
logo logo 232 40.35 string : 232
modify_time modify_time 137 23.830000000000002 date : 137
default_salemenu_id default_salemenu_id 96 16.7 string : 96
is_need_invitation_code is_need_invitation_code 66 11.48 boolean : 66
account account 59 10.26 ARRAY(OBJECT : 56, null : 14) : 59
: name name 56 94.92 string : 56
: account account 54 91.53 string : 54
create_time create_time 47 8.17 date : 47
price_diversification price_diversification 47 8.17 integer : 47
banner banner 46 8.0 string : 46
pay_type pay_type 20 3.4799999999999995 integer : 14, float : 5, string : 1

Collection: driver_location

Field_compact_name Field_name Count Percentage Types_count
_id _id 10000 100.0 oid : 10000
date_time date_time 10000 100.0 date : 10000
driver_id driver_id 10000 100.0 integer : 10000
lat lat 10000 100.0 float : 10000
lng lng 10000 100.0 float : 10000
action action 21 0.21 string : 21
order_id order_id 21 0.21 string : 21

Collection: employee_station_limit

Field_compact_name Field_name Count Percentage Types_count
_id _id 1129 100.0 oid : 1129
employee_id employee_id 1129 100.0 integer : 1129
limit_stations limit_stations 1129 100.0 ARRAY(string : 2407) : 1129

Collection: error_charge_config

Field_compact_name Field_name Count Percentage Types_count
_id _id 22 100.0 oid : 22
email email 22 100.0 string : 22
error_code error_code 22 100.0 integer : 22
error_str error_str 22 100.0 string : 22
method method 22 100.0 string : 22
url url 22 100.0 string : 22

Collection: fqt_report

Field_compact_name Field_name Count Percentage Types_count
_id _id 3570 100.0 string : 3570
assign_id assign_id 3570 100.0 string : 3570
date date 3570 100.0 string : 3570
product_origin product_origin 3570 100.0 string : 3570
result result 3570 100.0 string : 3570
sender sender 3570 100.0 string : 3570
spu_id spu_id 3570 100.0 string : 3570
spu_name spu_name 3570 100.0 string : 3570
standard standard 3570 100.0 string : 3570

Collection: freight

Field_compact_name Field_name Count Percentage Types_count
_id _id 717 100.0 string : 717
default default 717 100.0 boolean : 717
edit_time edit_time 717 100.0 date : 717
edit_user_id edit_user_id 717 100.0 integer : 664, float : 53
edit_user_name edit_user_name 717 100.0 string : 717
min_total_price min_total_price 717 100.0 integer : 662, float : 55
name name 717 100.0 string : 717
section section 717 100.0 ARRAY(OBJECT : 1204) : 717
: freight freight 1204 167.92000000000002 integer : 1150, float : 54
: max max 1204 167.92000000000002 integer : 1150, float : 54
: min min 1204 167.92000000000002 integer : 1150, float : 54
service_station_id service_station_id 717 100.0 string : 717
group_id group_id 711 99.16 integer : 584, null : 127
id id 525 73.22 string : 525
district_code district_code 360 50.21 string : 360

Collection: glus_customer_supply

Field_compact_name Field_name Count Percentage Types_count
_id _id 3889 100.0 string : 3889
address_id address_id 3889 100.0 string : 3889
station_id station_id 3889 100.0 string : 3889
user_id user_id 3889 100.0 string : 3889

Collection: glus_supply_chains

Field_compact_name Field_name Count Percentage Types_count
_id _id 35 100.0 string : 35
partners partners 35 100.0 ARRAY(OBJECT : 356, null : 8) : 35
: partner_salemenu partner_salemenu 356 1017.14 string : 356
: partner_station partner_station 356 1017.14 string : 356
station_id station_id 35 100.0 string : 35

Collection: in_stock_log

Field_compact_name Field_name Count Percentage Types_count
_id _id 10000 100.0 oid : 10000
category_id_1 category_id_1 10000 100.0 string : 10000
category_id_2 category_id_2 10000 100.0 string : 10000
create_time create_time 10000 100.0 date : 10000
name name 10000 100.0 string : 10000
operator operator 10000 100.0 string : 10000
price price 10000 100.0 integer : 9136, float : 864
purchase_sku_id purchase_sku_id 10000 100.0 string : 10000
ratio ratio 10000 100.0 float : 9988, integer : 12
sheet_no sheet_no 10000 100.0 string : 10000
spu_id spu_id 10000 100.0 string : 10000
station_id station_id 10000 100.0 string : 10000
std_unit std_unit 10000 100.0 string : 10000
type type 10000 100.0 integer : 10000
category category 9796 97.96000000000001 string : 9796
money money 9796 97.96000000000001 float : 9517, integer : 279
date_time date_time 9715 97.15 date : 9715
batch_number batch_number 9548 95.48 string : 9548
id id 9548 95.48 string : 9548
life_time life_time 9548 95.48 null : 9548
purchase_unit purchase_unit 9548 95.48 string : 9548
quantity quantity 9548 95.48 float : 9521, integer : 27
shelf_id shelf_id 9548 95.48 null : 9548
unit_price unit_price 9548 95.48 integer : 9353, float : 195
old_batch_stock_num old_batch_stock_num 9409 94.08999999999999 integer : 9409
old_total_stock_num old_total_stock_num 9409 94.08999999999999 float : 9379, integer : 30
modify_time modify_time 9210 92.10000000000001 date : 9210
status status 2512 25.119999999999997 integer : 2512
delete_reason delete_reason 2507 25.069999999999997 integer : 2507
in_stock_amount in_stock_amount 591 5.91 float : 591
desc desc 236 2.36 string : 236
order_id order_id 204 2.04 string : 204
sale_ratio sale_ratio 204 2.04 float : 204
sale_sku_id sale_sku_id 204 2.04 string : 204
supplier_id supplier_id 204 2.04 string : 178, null : 26
supplier_name supplier_name 204 2.04 string : 178, null : 26
remark remark 11 0.11 string : 11

Collection: order_change

Field_compact_name Field_name Count Percentage Types_count
_id _id 10000 100.0 oid : 10000
after after 10000 100.0 float : 9924, integer : 76
attr attr 10000 100.0 string : 10000
before before 10000 100.0 float : 10000
date_time date_time 10000 100.0 date : 10000
order_id order_id 10000 100.0 string : 10000
user_id user_id 10000 100.0 integer : 10000

Collection: order_data

Field_compact_name Field_name Count Percentage Types_count
_id _id 3163 100.0 oid : 3163
data data 3163 100.0 ARRAY(OBJECT : 74144) : 3163
: amount amount 74144 2344.1 float : 74144
: price price 74144 2344.1 float : 74144
: sku_id sku_id 74144 2344.1 string : 74144
date_time date_time 3163 100.0 date : 3163
order_id order_id 3163 100.0 string : 3163
sid sid 3163 100.0 integer : 3163

Collection: order_delta_log

Field_compact_name Field_name Count Percentage Types_count
_id _id 10000 100.0 string : 10000
changes changes 10000 100.0 ARRAY(OBJECT : 242003, null : 3) : 10000
: date_time date_time 242003 2420.0299999999997 date : 242003
: quantity quantity 242003 2420.0299999999997 float : 242003
: sku_id sku_id 242003 2420.0299999999997 string : 242003
: sku_version sku_version 242003 2420.0299999999997 integer : 242003
: type type 242003 2420.0299999999997 integer : 242003

Collection: order_new

Field_compact_name Field_name Count Percentage Types_count
_id _id 10000 100.0 string : 10000
_lock _lock 10000 100.0 string : 10000
close_time close_time 10000 100.0 null : 10000
create_time create_time 10000 100.0 date : 10000
customer customer 10000 100.0 OBJECT : 10000
. address address 10000 100.0 string : 10000
. address_id address_id 10000 100.0 string : 10000
. address_sign_id address_sign_id 10000 100.0 string : 8129, null : 1871
. extender extender 10000 100.0 string : 10000
. receive_begin_time receive_begin_time 10000 100.0 string : 10000
. receive_end_time receive_end_time 10000 100.0 string : 10000
. receiver_name receiver_name 10000 100.0 string : 10000
. receiver_phone receiver_phone 10000 100.0 string : 10000
. supply_station_id supply_station_id 10000 100.0 string : 8129, null : 1871
. uid uid 10000 100.0 string : 10000
date_time date_time 10000 100.0 date : 10000
details details 10000 100.0 ARRAY(OBJECT : 125018, null : 47) : 10000
: accept_quantity accept_quantity 125018 1250.1799999999998 float : 124156, integer : 862
: id id 125018 1250.1799999999998 string : 125018
: material material 125018 1250.1799999999998 ARRAY(OBJECT : 125018) : 125018
: : accept_std_count accept_std_count 125018 100.0 float : 125018
: : real_std_count real_std_count 125018 100.0 float : 125018
: : sale_ratio sale_ratio 125018 100.0 float : 125018
: : spu_id spu_id 125018 100.0 string : 125018
: : std_sale_price std_sale_price 125018 100.0 integer : 125018
: : std_unit_name std_unit_name 125018 100.0 string : 125018
: : cost cost 98336 78.66 integer : 97706, float : 630
: : stock_count stock_count 98336 78.66 float : 98336
: name name 125018 1250.1799999999998 string : 125018
: origins origins 125018 1250.1799999999998 ARRAY(null : 106638, OBJECT : 61499) : 125018
: : order_id order_id 61499 49.19 string : 61499
: : sku_id sku_id 61499 49.19 string : 61499
: : split_flag split_flag 247 0.2 integer : 247
: purchase_quantity purchase_quantity 125018 1250.1799999999998 float : 125018
: quantity quantity 125018 1250.1799999999998 float : 125018
: real_item_price real_item_price 125018 1250.1799999999998 integer : 112471, float : 12547
: real_quantity real_quantity 125018 1250.1799999999998 float : 124154, integer : 864
: sale_price sale_price 125018 1250.1799999999998 integer : 122613, float : 2405
: sale_unit_name sale_unit_name 125018 1250.1799999999998 string : 125018
: salemenu_id salemenu_id 125018 1250.1799999999998 string : 125018
: search_text search_text 125018 1250.1799999999998 ARRAY(string : 493419, null : 6653) : 125018
: sort_station_ids sort_station_ids 125018 1250.1799999999998 ARRAY(OBJECT : 122571, null : 2447) : 125018
: : amount amount 122571 98.04 float : 122571
: : order_id order_id 122571 98.04 string : 122571
: : sku_id sku_id 122571 98.04 string : 122571
: sync_origin sync_origin 125018 1250.1799999999998 string : 125018
: total_item_pay total_item_pay 125018 1250.1799999999998 integer : 113154, float : 11864
: total_item_price total_item_price 125018 1250.1799999999998 integer : 111460, float : 13558
: version version 125018 1250.1799999999998 integer : 125018
: is_price_timing is_price_timing 124434 1244.3400000000001 boolean : 124434
: attrition_rate attrition_rate 108730 1087.3 float : 82045, integer : 26685
: spu_remark spu_remark 106625 1066.25 string : 106625
: is_weight is_weight 73708 737.08 integer : 73708
: origin_item_price origin_item_price 54135 541.35 float : 54135
: origin_sale_price origin_sale_price 54135 541.35 integer : 51098, float : 3037
: real_is_weight real_is_weight 45037 450.37 boolean : 45037
: weighting_quantity weighting_quantity 27391 273.91 integer : 27351, float : 40
: out_of_stock out_of_stock 84 0.84 boolean : 84
: fake_item_price fake_item_price 21 0.21 float : 21
: rule_id rule_id 21 0.21 string : 21
district_code district_code 10000 100.0 string : 10000
expire_time expire_time 10000 100.0 date : 10000
freeze freeze 10000 100.0 integer : 10000
is_aggregation is_aggregation 10000 100.0 integer : 10000
modify_time modify_time 10000 100.0 date : 10000
paid_amount paid_amount 10000 100.0 integer : 10000
pay_status pay_status 10000 100.0 integer : 10000
real_pay real_pay 10000 100.0 integer : 10000
real_price real_price 10000 100.0 integer : 8301, float : 1699
refund_amount refund_amount 10000 100.0 integer : 10000
salemenu_ids salemenu_ids 10000 100.0 ARRAY(string : 25351, null : 47) : 10000
settle_way settle_way 10000 100.0 integer : 10000
source_order_ids source_order_ids 10000 100.0 ARRAY(string : 11227, null : 8179) : 10000
station_id station_id 10000 100.0 string : 10000
status status 10000 100.0 integer : 10000
time_config_id time_config_id 10000 100.0 string : 10000
total_pay total_pay 10000 100.0 float : 8511, integer : 1489
total_price total_price 10000 100.0 integer : 7954, float : 2046
fake_total_price fake_total_price 9997 99.97 integer : 9336, float : 661
origin_total_price origin_total_price 9997 99.97 integer : 6285, float : 3712
_abnormal_lock _abnormal_lock 9301 93.01 string : 9301
is_purchase_task_synced is_purchase_task_synced 8375 83.75 boolean : 8375
distribute_time distribute_time 8344 83.44 date : 8344
batch_remark batch_remark 8195 81.95 string : 8195
freight freight 8129 81.28999999999999 float : 8129
remark remark 8129 81.28999999999999 null : 8129
is_purchase_task_new_synced is_purchase_task_new_synced 2201 22.009999999999998 boolean : 2201
abnormal_money abnormal_money 1774 17.740000000000002 integer : 1774
abnormals abnormals 1774 17.740000000000002 ARRAY(OBJECT : 3456, null : 27) : 1774
: detail_id detail_id 3456 194.81 string : 3456
: final_amount final_amount 3456 194.81 float : 3456
: id id 3456 194.81 integer : 3456
: money_delta money_delta 3456 194.81 integer : 3456
: text text 3456 194.81 string : 3456
: type_id type_id 3456 194.81 integer : 3456
: type_text type_text 3456 194.81 string : 3456
refunds refunds 1774 17.740000000000002 ARRAY(null : 1773, OBJECT : 1) : 1774
: detail_id detail_id 1 0.06 string : 1
: id id 1 0.06 integer : 1
: out_order_id out_order_id 1 0.06 string : 1
: out_sku_id out_sku_id 1 0.06 string : 1
: real_amount real_amount 1 0.06 float : 1
: request_amount request_amount 1 0.06 float : 1
: state state 1 0.06 integer : 1
: station_store_id station_store_id 1 0.06 string : 1
: text text 1 0.06 string : 1
: type_id type_id 1 0.06 integer : 1
: type_text type_text 1 0.06 string : 1
serials serials 920 9.2 ARRAY(string : 2353) : 920
token token 808 8.08 string : 808
purchase_task_sync_time purchase_task_sync_time 7 0.06999999999999999 date : 7

Collection: order_statistics_cycletime

Field_compact_name Field_name Count Percentage Types_count
_id _id 1000 100.0 oid : 1000
abnormal_department abnormal_department 1000 100.0 ARRAY(null : 792, OBJECT : 208) : 1000
: department_id department_id 208 20.8 integer : 208
: order_department_num order_department_num 208 20.8 integer : 208
abnormal_money abnormal_money 1000 100.0 integer : 1000
abnormal_reason abnormal_reason 1000 100.0 ARRAY(null : 792, OBJECT : 328) : 1000
: order_type_num order_type_num 328 32.800000000000004 integer : 328
: type_id type_id 328 32.800000000000004 integer : 328
abnormal_sku_num abnormal_sku_num 1000 100.0 integer : 1000
amount_delivered amount_delivered 1000 100.0 integer : 1000
amount_ordered amount_ordered 1000 100.0 integer : 1000
amount_ordered_fake amount_ordered_fake 1000 100.0 integer : 1000
customer_ordered customer_ordered 1000 100.0 integer : 1000
customer_ordered_fake customer_ordered_fake 1000 100.0 integer : 1000
cycle_begin_time cycle_begin_time 1000 100.0 date : 1000
district_code district_code 1000 100.0 string : 1000
freight freight 1000 100.0 float : 782, integer : 218
money_cost money_cost 1000 100.0 float : 1000
money_delivered money_delivered 1000 100.0 integer : 645, float : 355
money_ordered money_ordered 1000 100.0 integer : 537, float : 463
money_ordered_fake money_ordered_fake 1000 100.0 integer : 1000
nosku_abnormal_department nosku_abnormal_department 1000 100.0 ARRAY(null : 926, OBJECT : 74) : 1000
: department_id department_id 74 7.3999999999999995 integer : 74
: order_department_num order_department_num 74 7.3999999999999995 integer : 74
nosku_abnormal_money nosku_abnormal_money 1000 100.0 integer : 1000
nosku_abnormal_reason nosku_abnormal_reason 1000 100.0 ARRAY(null : 926, OBJECT : 91) : 1000
: order_type_num order_type_num 91 9.1 integer : 91
: type_id type_id 91 9.1 integer : 91
real_refund_money real_refund_money 1000 100.0 integer : 940, float : 60
refund_sku_num refund_sku_num 1000 100.0 integer : 1000
request_refund_money request_refund_money 1000 100.0 integer : 940, float : 60
restaurants restaurants 1000 100.0 ARRAY(OBJECT : 7509) : 1000
: abnormal_money abnormal_money 7509 750.9000000000001 integer : 7509
: abnormal_order_num abnormal_order_num 7509 750.9000000000001 integer : 7509
: money_cost money_cost 7509 750.9000000000001 float : 7509
: money_delivered money_delivered 7509 750.9000000000001 integer : 6572, float : 937
: money_ordered money_ordered 7509 750.9000000000001 integer : 6145, float : 1364
: real_refund_money real_refund_money 7509 750.9000000000001 integer : 7402, float : 107
: refund_num refund_num 7509 750.9000000000001 integer : 7509
: request_refund_money request_refund_money 7509 750.9000000000001 integer : 7402, float : 107
: resname resname 7509 750.9000000000001 string : 7509
: sid sid 7509 750.9000000000001 string : 7509
salemenu_id salemenu_id 1000 100.0 string : 1000
sku_num sku_num 1000 100.0 integer : 1000
skus skus 1000 100.0 ARRAY(OBJECT : 34532) : 1000
: abnormal_money abnormal_money 34532 3453.2 integer : 34532
: category_id_1 category_id_1 34532 3453.2 string : 34532
: category_id_2 category_id_2 34532 3453.2 string : 34532
: money_cost money_cost 34532 3453.2 float : 34532
: money_delivered money_delivered 34532 3453.2 integer : 27424, float : 7108
: money_ordered money_ordered 34532 3453.2 integer : 24617, float : 9915
: outer_id outer_id 34532 3453.2 string : 34532
: quantity_basis_delivered quantity_basis_delivered 34532 3453.2 float : 34532
: quantity_basis_ordered quantity_basis_ordered 34532 3453.2 float : 34532
: quantity_delivered quantity_delivered 34532 3453.2 float : 34276, integer : 256
: quantity_delta quantity_delta 34532 3453.2 integer : 34220, float : 312
: quantity_ordered quantity_ordered 34532 3453.2 float : 34532
: real_refund_amount real_refund_amount 34532 3453.2 integer : 34362, float : 170
: real_refund_money real_refund_money 34532 3453.2 integer : 34362, float : 170
: request_refund_amount request_refund_amount 34532 3453.2 integer : 34362, float : 170
: request_refund_money request_refund_money 34532 3453.2 integer : 34362, float : 170
: sale_ratio sale_ratio 34532 3453.2 float : 34532
: sale_unit_name sale_unit_name 34532 3453.2 string : 34532
: sku_id sku_id 34532 3453.2 string : 34532
: sku_name sku_name 34532 3453.2 string : 34532
: spu_id spu_id 34532 3453.2 string : 34532
: std_money_cost std_money_cost 34532 3453.2 float : 34256, integer : 276
: std_sale_price std_sale_price 34532 3453.2 float : 34532
: std_unit_name std_unit_name 34532 3453.2 string : 34532
: sync_origin sync_origin 34532 3453.2 string : 34532
station_id station_id 1000 100.0 string : 1000
time_config_id time_config_id 1000 100.0 string : 1000

Collection: order_statistics_orderedtime

Field_compact_name Field_name Count Percentage Types_count
_id _id 1000 100.0 oid : 1000
abnormal_department abnormal_department 1000 100.0 ARRAY(null : 697, OBJECT : 303) : 1000
: department_id department_id 303 30.3 integer : 303
: order_department_num order_department_num 303 30.3 integer : 303
abnormal_money abnormal_money 1000 100.0 integer : 1000
abnormal_reason abnormal_reason 1000 100.0 ARRAY(OBJECT : 751, null : 697) : 1000
: order_type_num order_type_num 751 75.1 integer : 751
: type_id type_id 751 75.1 integer : 751
abnormal_sku_num abnormal_sku_num 1000 100.0 integer : 1000
amount_delivered amount_delivered 1000 100.0 integer : 1000
amount_ordered amount_ordered 1000 100.0 integer : 1000
amount_ordered_fake amount_ordered_fake 1000 100.0 integer : 1000
customer_ordered customer_ordered 1000 100.0 integer : 1000
customer_ordered_fake customer_ordered_fake 1000 100.0 integer : 1000
district_code district_code 1000 100.0 string : 1000
freight freight 1000 100.0 float : 525, integer : 475
money_cost money_cost 1000 100.0 float : 1000
money_delivered money_delivered 1000 100.0 integer : 527, float : 473
money_ordered money_ordered 1000 100.0 float : 631, integer : 369
money_ordered_fake money_ordered_fake 1000 100.0 integer : 1000
nosku_abnormal_department nosku_abnormal_department 1000 100.0 ARRAY(null : 874, OBJECT : 126) : 1000
: department_id department_id 126 12.6 integer : 126
: order_department_num order_department_num 126 12.6 integer : 126
nosku_abnormal_money nosku_abnormal_money 1000 100.0 integer : 1000
nosku_abnormal_reason nosku_abnormal_reason 1000 100.0 ARRAY(null : 874, OBJECT : 192) : 1000
: order_type_num order_type_num 192 19.2 integer : 192
: type_id type_id 192 19.2 integer : 192
orderedtime orderedtime 1000 100.0 date : 1000
real_refund_money real_refund_money 1000 100.0 integer : 861, float : 139
refund_sku_num refund_sku_num 1000 100.0 integer : 1000
request_refund_money request_refund_money 1000 100.0 integer : 861, float : 139
restaurants restaurants 1000 100.0 ARRAY(OBJECT : 16928) : 1000
: abnormal_money abnormal_money 16928 1692.8000000000002 integer : 16928
: abnormal_order_num abnormal_order_num 16928 1692.8000000000002 integer : 16928
: money_cost money_cost 16928 1692.8000000000002 float : 16928
: money_delivered money_delivered 16928 1692.8000000000002 integer : 15121, float : 1807
: money_ordered money_ordered 16928 1692.8000000000002 integer : 14331, float : 2597
: real_refund_money real_refund_money 16928 1692.8000000000002 integer : 16612, float : 316
: refund_num refund_num 16928 1692.8000000000002 integer : 16928
: request_refund_money request_refund_money 16928 1692.8000000000002 integer : 16612, float : 316
: resname resname 16928 1692.8000000000002 string : 16928
: sid sid 16928 1692.8000000000002 string : 16928
salemenu_id salemenu_id 1000 100.0 string : 1000
sku_num sku_num 1000 100.0 integer : 1000
skus skus 1000 100.0 ARRAY(OBJECT : 52764) : 1000
: abnormal_money abnormal_money 52764 5276.400000000001 integer : 52764
: category_id_1 category_id_1 52764 5276.400000000001 string : 52764
: category_id_2 category_id_2 52764 5276.400000000001 string : 52764
: money_cost money_cost 52764 5276.400000000001 float : 52764
: money_delivered money_delivered 52764 5276.400000000001 integer : 43369, float : 9395
: money_ordered money_ordered 52764 5276.400000000001 integer : 39425, float : 13339
: outer_id outer_id 52764 5276.400000000001 string : 52764
: quantity_basis_delivered quantity_basis_delivered 52764 5276.400000000001 float : 52764
: quantity_basis_ordered quantity_basis_ordered 52764 5276.400000000001 float : 52764
: quantity_delivered quantity_delivered 52764 5276.400000000001 float : 52764
: quantity_delta quantity_delta 52764 5276.400000000001 integer : 51571, float : 1193
: quantity_ordered quantity_ordered 52764 5276.400000000001 float : 52764
: real_refund_amount real_refund_amount 52764 5276.400000000001 integer : 52258, float : 506
: real_refund_money real_refund_money 52764 5276.400000000001 integer : 52258, float : 506
: request_refund_amount request_refund_amount 52764 5276.400000000001 integer : 52258, float : 506
: request_refund_money request_refund_money 52764 5276.400000000001 integer : 52258, float : 506
: sale_ratio sale_ratio 52764 5276.400000000001 float : 52764
: sale_unit_name sale_unit_name 52764 5276.400000000001 string : 52764
: sku_id sku_id 52764 5276.400000000001 string : 52764
: sku_name sku_name 52764 5276.400000000001 string : 52764
: spu_id spu_id 52764 5276.400000000001 string : 52764
: std_money_cost std_money_cost 52764 5276.400000000001 float : 52701, integer : 63
: std_sale_price std_sale_price 52764 5276.400000000001 float : 52764
: std_unit_name std_unit_name 52764 5276.400000000001 string : 52764
: sync_origin sync_origin 52764 5276.400000000001 string : 52764
station_id station_id 1000 100.0 string : 1000

Collection: order_statistics_receivedtime

Field_compact_name Field_name Count Percentage Types_count
_id _id 1000 100.0 oid : 1000
abnormal_department abnormal_department 1000 100.0 ARRAY(null : 552, OBJECT : 448) : 1000
: department_id department_id 448 44.800000000000004 integer : 448
: order_department_num order_department_num 448 44.800000000000004 integer : 448
abnormal_money abnormal_money 1000 100.0 integer : 1000
abnormal_reason abnormal_reason 1000 100.0 ARRAY(OBJECT : 1376, null : 552) : 1000
: order_type_num order_type_num 1376 137.6 integer : 1376
: type_id type_id 1376 137.6 integer : 1376
abnormal_sku_num abnormal_sku_num 1000 100.0 integer : 1000
amount_delivered amount_delivered 1000 100.0 integer : 1000
amount_ordered amount_ordered 1000 100.0 integer : 1000
amount_ordered_fake amount_ordered_fake 1000 100.0 integer : 1000
customer_ordered customer_ordered 1000 100.0 integer : 1000
customer_ordered_fake customer_ordered_fake 1000 100.0 integer : 1000
district_code district_code 1000 100.0 string : 1000
freight freight 1000 100.0 float : 758, integer : 242
money_cost money_cost 1000 100.0 float : 1000
money_delivered money_delivered 1000 100.0 integer : 511, float : 489
money_ordered money_ordered 1000 100.0 float : 657, integer : 343
money_ordered_fake money_ordered_fake 1000 100.0 integer : 1000
nosku_abnormal_department nosku_abnormal_department 1000 100.0 ARRAY(null : 735, OBJECT : 265) : 1000
: department_id department_id 265 26.5 integer : 265
: order_department_num order_department_num 265 26.5 integer : 265
nosku_abnormal_money nosku_abnormal_money 1000 100.0 integer : 1000
nosku_abnormal_reason nosku_abnormal_reason 1000 100.0 ARRAY(null : 735, OBJECT : 354) : 1000
: order_type_num order_type_num 354 35.4 integer : 354
: type_id type_id 354 35.4 integer : 354
real_refund_money real_refund_money 1000 100.0 integer : 937, float : 63
receive_begin_time receive_begin_time 1000 100.0 date : 1000
refund_sku_num refund_sku_num 1000 100.0 integer : 1000
request_refund_money request_refund_money 1000 100.0 integer : 937, float : 63
restaurants restaurants 1000 100.0 ARRAY(OBJECT : 32299) : 1000
: abnormal_money abnormal_money 32299 3229.9 integer : 32299
: abnormal_order_num abnormal_order_num 32299 3229.9 integer : 32299
: money_cost money_cost 32299 3229.9 float : 32299
: money_delivered money_delivered 32299 3229.9 integer : 30586, float : 1713
: money_ordered money_ordered 32299 3229.9 integer : 29694, float : 2605
: real_refund_money real_refund_money 32299 3229.9 integer : 32197, float : 102
: refund_num refund_num 32299 3229.9 integer : 32299
: request_refund_money request_refund_money 32299 3229.9 integer : 32197, float : 102
: resname resname 32299 3229.9 string : 32299
: sid sid 32299 3229.9 string : 32299
salemenu_id salemenu_id 1000 100.0 string : 1000
sku_num sku_num 1000 100.0 integer : 1000
skus skus 1000 100.0 ARRAY(OBJECT : 65264) : 1000
: abnormal_money abnormal_money 65264 6526.4 integer : 65264
: category_id_1 category_id_1 65264 6526.4 string : 65264
: category_id_2 category_id_2 65264 6526.4 string : 65264
: money_cost money_cost 65264 6526.4 float : 65264
: money_delivered money_delivered 65264 6526.4 integer : 56926, float : 8338
: money_ordered money_ordered 65264 6526.4 integer : 52836, float : 12428
: outer_id outer_id 65264 6526.4 string : 65264
: quantity_basis_delivered quantity_basis_delivered 65264 6526.4 float : 65264
: quantity_basis_ordered quantity_basis_ordered 65264 6526.4 float : 65264
: quantity_delivered quantity_delivered 65264 6526.4 float : 65231, integer : 33
: quantity_delta quantity_delta 65264 6526.4 integer : 62387, float : 2877
: quantity_ordered quantity_ordered 65264 6526.4 float : 65264
: real_refund_amount real_refund_amount 65264 6526.4 integer : 65102, float : 162
: real_refund_money real_refund_money 65264 6526.4 integer : 65102, float : 162
: request_refund_amount request_refund_amount 65264 6526.4 integer : 65102, float : 162
: request_refund_money request_refund_money 65264 6526.4 integer : 65102, float : 162
: sale_ratio sale_ratio 65264 6526.4 float : 65264
: sale_unit_name sale_unit_name 65264 6526.4 string : 65264
: sku_id sku_id 65264 6526.4 string : 65264
: sku_name sku_name 65264 6526.4 string : 65264
: spu_id spu_id 65264 6526.4 string : 65264
: std_money_cost std_money_cost 65264 6526.4 float : 65212, integer : 52
: std_sale_price std_sale_price 65264 6526.4 float : 65264
: std_unit_name std_unit_name 65264 6526.4 string : 65264
: sync_origin sync_origin 65264 6526.4 string : 65264
station_id station_id 1000 100.0 string : 1000

Collection: out_batch_stock_flow

Field_compact_name Field_name Count Percentage Types_count
_id _id 10000 100.0 oid : 10000
batch_number batch_number 10000 100.0 string : 10000
create_time create_time 10000 100.0 date : 10000
date_time date_time 10000 100.0 date : 10000
modify_time modify_time 10000 100.0 date : 10000
old_batch_total_stock_num old_batch_total_stock_num 10000 100.0 float : 10000
operator operator 10000 100.0 string : 10000
order_id order_id 10000 100.0 string : 9999, null : 1
out_stock_base out_stock_base 10000 100.0 float : 9973, integer : 27
out_stock_sale out_stock_sale 10000 100.0 float : 10000
price price 10000 100.0 integer : 9155, float : 845
purchase_sku_id purchase_sku_id 10000 100.0 string : 10000
sale_ratio sale_ratio 10000 100.0 float : 10000
sale_sku_id sale_sku_id 10000 100.0 string : 10000
sale_unit sale_unit 10000 100.0 string : 10000
shelf_id shelf_id 10000 100.0 null : 9959, integer : 41
spu_id spu_id 10000 100.0 string : 10000
station_id station_id 10000 100.0 string : 10000
std_unit std_unit 10000 100.0 string : 10000
type type 10000 100.0 integer : 10000
status status 6 0.06 integer : 6

Collection: out_stock_log

Field_compact_name Field_name Count Percentage Types_count
_id _id 10000 100.0 oid : 10000
create_time create_time 10000 100.0 date : 10000
date_time date_time 10000 100.0 date : 10000
operator operator 10000 100.0 string : 10000
order_id order_id 10000 100.0 string : 10000
out_stock_base out_stock_base 10000 100.0 float : 10000
out_stock_sale out_stock_sale 10000 100.0 float : 10000
price price 10000 100.0 float : 6632, integer : 3368
sale_ratio sale_ratio 10000 100.0 float : 10000
sale_sku_id sale_sku_id 10000 100.0 string : 10000
sale_unit sale_unit 10000 100.0 string : 10000
spu_id spu_id 10000 100.0 string : 10000
station_id station_id 10000 100.0 string : 10000
std_unit std_unit 10000 100.0 string : 10000
type type 10000 100.0 integer : 10000
modify_time modify_time 3 0.03 date : 3
old_total_stock_num old_total_stock_num 3 0.03 float : 3

Collection: out_stock_sheet

Field_compact_name Field_name Count Percentage Types_count
_id _id 10000 100.0 string : 10000
create_time create_time 10000 100.0 date : 10000
creator creator 10000 100.0 string : 10000
details details 10000 100.0 ARRAY(OBJECT : 137499, null : 6) : 10000
: creator creator 137499 1374.99 string : 137499
: id id 137499 1374.99 string : 137499
: name name 137499 1374.99 string : 137499
: quantity quantity 137499 1374.99 float : 137205, integer : 288, string : 6
: sale_ratio sale_ratio 137499 1374.99 float : 137499
: sale_unit sale_unit 137499 1374.99 string : 137499
: spu_id spu_id 137499 1374.99 string : 137499
: std_unit std_unit 137499 1374.99 string : 137499
: unit_price unit_price 135544 1355.4399999999998 integer : 68077, float : 67467
: category category 4748 47.48 string : 4748
out_stock_target out_stock_target 10000 100.0 string : 10000
station_id station_id 10000 100.0 string : 10000
status status 10000 100.0 integer : 10000
update_time update_time 10000 100.0 date : 10000
money money 9798 97.98 float : 9643, integer : 155
out_stock_time out_stock_time 9792 97.92 date : 9792

Collection: price_rule

Field_compact_name Field_name Count Percentage Types_count
_id _id 7129 100.0 string : 7129
address_num address_num 7129 100.0 integer : 7129
addresses addresses 7129 100.0 ARRAY(string : 115016) : 7129
begin begin 7129 100.0 date : 7129
create_time create_time 7129 100.0 date : 7129
creator creator 7129 100.0 string : 7129
end end 7129 100.0 date : 7129
salemenu_id salemenu_id 7129 100.0 string : 7129
sku_num sku_num 7129 100.0 integer : 7129
skus skus 7129 100.0 ARRAY(OBJECT : 719517) : 7129
: id id 719517 10092.82 string : 719517
: name name 719517 10092.82 string : 719517
: yx_price yx_price 719517 10092.82 integer : 719517
: search_text search_text 700071 9820.04 ARRAY(string : 2601297, null : 198957, integer : 30) : 700071
: rule_type rule_type 367348 5152.87 integer : 367348
station_id station_id 7129 100.0 string : 7129
status status 7129 100.0 integer : 7129
type type 7129 100.0 string : 7129
group_id group_id 7105 99.66000000000001 integer : 7105
name name 5194 72.86 string : 5194
modifier modifier 4793 67.23 string : 4793
modify_time modify_time 4793 67.23 date : 4793
district_code district_code 3940 55.269999999999996 string : 3940

Collection: purchase_apply

Field_compact_name Field_name Count Percentage Types_count
_id _id 47 100.0 string : 47
create_time create_time 47 100.0 date : 47
price price 47 100.0 integer : 33, float : 14
request_id request_id 47 100.0 string : 47
seller_id seller_id 47 100.0 string : 47
sku_id sku_id 47 100.0 string : 47
status status 47 100.0 integer : 47
pindan_round pindan_round 33 70.21 string : 33
sale_ratio sale_ratio 33 70.21 float : 33
sale_unit_name sale_unit_name 33 70.21 string : 33
spu_id spu_id 33 70.21 string : 33
std_apply_price std_apply_price 33 70.21 float : 33
std_sale_price std_sale_price 33 70.21 integer : 33
std_unit_name std_unit_name 33 70.21 string : 33
buyer_id buyer_id 14 29.79 string : 14

Collection: purchase_sheet

Field_compact_name Field_name Count Percentage Types_count
_id _id 140 100.0 string : 140
create_time create_time 140 100.0 date : 140
operator operator 140 100.0 string : 140
settle_supplier_id settle_supplier_id 140 100.0 string : 140
station_id station_id 140 100.0 string : 140
status status 140 100.0 integer : 140
in_stock_time in_stock_time 136 97.14 date : 136
operator_id operator_id 112 80.0 integer : 112
purchaser_id purchaser_id 112 80.0 integer : 112
cycle_start_time cycle_start_time 85 60.709999999999994 date : 85
time_config_id time_config_id 85 60.709999999999994 string : 85
ref_price_type ref_price_type 63 45.0 integer : 63
modify_time modify_time 57 40.71 date : 57
submit_time submit_time 33 23.57 date : 26, null : 7
remark remark 16 11.43 string : 12, null : 4

Collection: purchase_sku_log

Field_compact_name Field_name Count Percentage Types_count
_id _id 1544 100.0 oid : 1544
create_time create_time 1544 100.0 date : 1544
purchase_amount purchase_amount 1544 100.0 float : 1544
purchase_operator purchase_operator 1544 100.0 string : 1544
purchase_price purchase_price 1544 100.0 integer : 1493, float : 51
release_id release_id 1544 100.0 null : 1488, integer : 56
sheet_no sheet_no 1544 100.0 string : 1544
sku_id sku_id 1544 100.0 string : 1544
station_id station_id 1544 100.0 string : 1544
status status 1544 100.0 integer : 1544
purchaser_id purchaser_id 1232 79.79 integer : 1232
sale_ratio sale_ratio 1232 79.79 float : 1232
sale_unit_name sale_unit_name 1232 79.79 string : 1232
settle_supplier_id settle_supplier_id 1232 79.79 string : 1232
sku_name sku_name 1232 79.79 string : 1232
spu_id spu_id 1232 79.79 string : 1232
spu_name spu_name 1232 79.79 string : 1232
std_unit_name std_unit_name 1232 79.79 string : 1232
tasks tasks 1176 76.17 ARRAY(OBJECT : 1701, null : 9) : 1176
: address_id address_id 1701 144.64 string : 1696, null : 5
: id id 1701 144.64 integer : 1701
: order_id order_id 1701 144.64 string : 1696, null : 5
: plan_amount plan_amount 1701 144.64 float : 1701
: remark remark 1701 144.64 string : 1684, null : 17
: res_name res_name 1701 144.64 string : 1696, null : 5
modify_time modify_time 632 40.93 date : 632
ref_price ref_price 337 21.83 null : 324, float : 11, integer : 2
arrived_amount arrived_amount 294 19.040000000000003 float : 285, integer : 9
arrived_price arrived_price 294 19.040000000000003 integer : 294
remark remark 281 18.2 string : 281
new_release_id new_release_id 56 3.63 integer : 56
switch switch 56 3.63 boolean : 56

Collection: purchase_specification

Field_compact_name Field_name Count Percentage Types_count
_id _id 10000 100.0 oid : 10000
category_1 category_1 10000 100.0 string : 10000
category_2 category_2 10000 100.0 string : 10000
create_time create_time 10000 100.0 date : 10000
id id 10000 100.0 string : 10000
latest latest 10000 100.0 integer : 10000
name name 10000 100.0 string : 10000
pinlei pinlei 10000 100.0 string : 10000
price price 10000 100.0 float : 5711, integer : 4289
ratio ratio 10000 100.0 float : 10000
spu_id spu_id 10000 100.0 string : 10000
station_id station_id 10000 100.0 string : 10000
status status 10000 100.0 integer : 9553, float : 447
unit_name unit_name 10000 100.0 string : 10000
update_time update_time 10000 100.0 date : 10000
version version 10000 100.0 integer : 10000
last_in_stock_price last_in_stock_price 508 5.08 OBJECT : 508
. T4852 T4852 508 100.0 integer : 508

Collection: requests_log_summary

Field_compact_name Field_name Count Percentage Types_count
_id _id 2365 100.0 oid : 2365
create_time create_time 2365 100.0 date : 2365
details details 2365 100.0 ARRAY(OBJECT : 67844) : 2365
: avg_time avg_time 67844 2868.6699999999996 float : 67844
: exception exception 67844 2868.6699999999996 string : 67844
: http_status http_status 67844 2868.6699999999996 integer : 67844
: msg msg 67844 2868.6699999999996 string : 67844
: processing_time processing_time 67844 2868.6699999999996 integer : 67844
: request_count request_count 67844 2868.6699999999996 integer : 67844
: request_method request_method 67844 2868.6699999999996 string : 67844
: request_params request_params 67844 2868.6699999999996 string : 67844
: request_time request_time 67844 2868.6699999999996 date : 67844
: request_uid request_uid 67844 2868.6699999999996 string : 67844
: request_url request_url 67844 2868.6699999999996 string : 67844
: code code 67281 2844.8599999999997 integer : 67281
: version version 60092 2540.89 string : 60092
: extra_value extra_value 57779 2443.09 string : 57779
: tmp_code tmp_code 2017 85.28999999999999 string : 2017
log_type log_type 2365 100.0 string : 2365
service_name service_name 2365 100.0 string : 2365

Collection: return_to_supply_log

Field_compact_name Field_name Count Percentage Types_count
_id _id 10000 100.0 oid : 10000
sheet_no sheet_no 10000 100.0 string : 10000
create_time create_time 9978 99.78 date : 9978
operator operator 9978 99.78 string : 9978
price price 9978 99.78 float : 9978
purchase_sku_id purchase_sku_id 9978 99.78 string : 9978
return_amount return_amount 9978 99.78 float : 9974, string : 4
spu_id spu_id 9978 99.78 string : 9978
station_id station_id 9978 99.78 string : 9978
status status 502 5.0200000000000005 integer : 502
name name 480 4.8 string : 480
std_unit std_unit 480 4.8 string : 480
category category 343 3.4299999999999997 string : 343
money money 343 3.4299999999999997 string : 343
category_id_1 category_id_1 326 3.26 string : 326
category_id_2 category_id_2 326 3.26 string : 326
remark remark 136 1.3599999999999999 string : 136
desc desc 115 1.15 string : 106, null : 9
type type 1 0.01 integer : 1

Collection: station(站点)

Field_compact_name Field_name Count Percentage Types_count
_id _id 1161 100.0 string : 1161
address address 1161 100.0 string : 1161
default_settle_way default_settle_way 1161 100.0 integer : 1161
distribute_cities distribute_cities 1161 100.0 ARRAY(string : 1314) : 1161
name name 1161 100.0 string : 1161
receive_begin_time receive_begin_time 1161 100.0 string : 1161
receive_end_time receive_end_time 1161 100.0 string : 1161
receiver_name receiver_name 1161 100.0 string : 1161
receiver_phone receiver_phone 1161 100.0 string : 1161
role role 1161 100.0 integer : 1161
show_tax_rate show_tax_rate 1161 100.0 integer : 1161
enable_customized enable_customized 1160 99.91 integer : 1004, float : 156
key_url key_url 1160 99.91 string : 1160
station_status station_status 1160 99.91 integer : 1159, float : 1
partner_id partner_id 1137 97.92999999999999 integer : 1137
merchandise_ref_price_type merchandise_ref_price_type 954 82.17 integer : 954
purchase_ref_price_type purchase_ref_price_type 954 82.17 integer : 954
use_mq use_mq 954 82.17 boolean : 954
use_mq2 use_mq2 929 80.02 boolean : 929
enable_pay_info enable_pay_info 909 78.29 integer : 889, ARRAY(integer : 20) : 20
settle_suppliers settle_suppliers 781 67.27 ARRAY(string : 7207, null : 101) : 781
service_time service_time 757 65.2 ARRAY(string : 1189, null : 190) : 757
pay_info_id pay_info_id 712 61.33 string : 654, null : 58
suppliers suppliers 700 60.29 ARRAY(string : 3989) : 700
code code 588 50.64999999999999 string : 588
district_code district_code 483 41.6 string : 483
JHD_key JHD_key 450 38.76 integer : 450
JHD_key_time JHD_key_time 450 38.76 date : 450
CGD_key CGD_key 393 33.85 integer : 393
CGD_key_time CGD_key_time 393 33.85 date : 393
district_name district_name 353 30.4 ARRAY(string : 381) : 286, string : 67
show_sku_outer_id show_sku_outer_id 326 28.08 integer : 326
stock_method stock_method 323 27.82 integer : 323
FKD_key FKD_key 314 27.05 integer : 314
FKD_key_time FKD_key_time 313 26.96 date : 313
modify_time modify_time 286 24.63 date : 286
JHTHD_key JHTHD_key 255 21.959999999999997 integer : 255
JHTHD_key_time JHTHD_key_time 255 21.959999999999997 date : 255
distribute_config distribute_config 220 18.95 ARRAY(OBJECT : 219, null : 2) : 220
: bottomInfoBlockLines bottomInfoBlockLines 219 99.55000000000001 ARRAY(OBJECT : 1205) : 219
: : content content 1205 550.23 ARRAY(OBJECT : 2060, null : 685) : 1205
: : : text text 2060 170.95 string : 2060
: : : field field 1070 88.8 string : 1070
: : : alignment alignment 212 17.59 string : 212
: : : bold bold 212 17.59 boolean : 212
: : : capital capital 212 17.59 boolean : 212
: : : fontSize fontSize 212 17.59 string : 122, integer : 90
: : : height height 212 17.59 string : 212
: : : sortNo sortNo 212 17.59 string : 212
: : : width width 212 17.59 string : 212
: : type type 1205 550.23 string : 1205
: footerBlockLines footerBlockLines 219 99.55000000000001 ARRAY(OBJECT : 342) : 219
: : content content 342 156.16 ARRAY(OBJECT : 247, null : 136) : 342
: : : text text 247 72.22 string : 247
: : : alignment alignment 198 57.89 string : 198
: : : bold bold 198 57.89 boolean : 198
: : : capital capital 198 57.89 boolean : 198
: : : fontSize fontSize 198 57.89 integer : 166, string : 32
: : : field field 189 55.26 string : 189
: : : height height 59 17.25 string : 59
: : : sortNo sortNo 59 17.25 string : 59
: : : width width 59 17.25 string : 59
: : type type 342 156.16 string : 342
: headerBlockLines headerBlockLines 219 99.55000000000001 ARRAY(OBJECT : 1031) : 219
: : content content 1031 470.78 ARRAY(OBJECT : 1433, null : 296) : 1031
: : : text text 1433 138.98999999999998 string : 1433
: : : field field 1117 108.33999999999999 string : 1117
: : : alignment alignment 404 39.190000000000005 string : 404
: : : bold bold 404 39.190000000000005 boolean : 404
: : : capital capital 404 39.190000000000005 boolean : 404
: : : fontSize fontSize 404 39.190000000000005 string : 339, integer : 65
: : : height height 306 29.68 string : 306
: : : sortNo sortNo 306 29.68 string : 306
: : : width width 306 29.68 string : 306
: : type type 1031 470.78 string : 1031
: is_system_default_template is_system_default_template 219 99.55000000000001 boolean : 219
: name name 219 99.55000000000001 string : 219
: print_size print_size 219 99.55000000000001 string : 219
: productBlockHeader productBlockHeader 219 99.55000000000001 OBJECT : 219
: . abnormals_detail abnormals_detail 219 100.0 boolean : 219
: . category_number category_number 219 100.0 boolean : 219
: . category_total category_total 219 100.0 boolean : 219
: . tr tr 219 100.0 ARRAY(OBJECT : 1742) : 219
: . : field field 1742 795.43 string : 1742
: . : text text 1742 795.43 string : 1742
: . : width width 1742 795.43 string : 1724, integer : 18
: . : alignment alignment 396 180.82 string : 396
: . : bold bold 396 180.82 boolean : 396
: . : capital capital 396 180.82 boolean : 396
: . : fontSize fontSize 396 180.82 string : 267, integer : 129
: . : height height 396 180.82 string : 396
: . : sortNo sortNo 396 180.82 string : 396
: topInfoBlockLines topInfoBlockLines 219 99.55000000000001 ARRAY(OBJECT : 570) : 219
: : content content 570 260.27 ARRAY(OBJECT : 772, null : 177) : 570
: : : text text 772 135.44 string : 772
: : : field field 753 132.10999999999999 string : 753
: : : alignment alignment 78 13.68 string : 78
: : : bold bold 78 13.68 boolean : 78
: : : capital capital 78 13.68 boolean : 78
: : : fontSize fontSize 78 13.68 string : 65, integer : 13
: : : height height 78 13.68 string : 78
: : : sortNo sortNo 78 13.68 string : 78
: : : width width 78 13.68 string : 78
: : type type 570 260.27 string : 570
users users 190 16.37 ARRAY(integer : 341, float : 21, null : 6) : 190
create_time create_time 155 13.350000000000001 date : 155
description description 155 13.350000000000001 null : 124, string : 31
id id 147 12.659999999999998 string : 147
old_saas old_saas 78 6.72 float : 42, integer : 36
distribute_center distribute_center 59 5.08 string : 59
state state 48 4.130000000000001 integer : 47, float : 1
lat lat 25 2.15 string : 25
lng lng 25 2.15 string : 25
map_address map_address 25 2.15 string : 25
buyer buyer 1 0.09 OBJECT : 1
. address address 1 100.0 string : 1
. company_name company_name 1 100.0 string : 1
. contact_person contact_person 1 100.0 string : 1
. contact_phone contact_phone 1 100.0 string : 1
. delivery_addr delivery_addr 1 100.0 string : 1
. delivery_begin_time delivery_begin_time 1 100.0 string : 1
. delivery_end_time delivery_end_time 1 100.0 string : 1
. is_company is_company 1 100.0 boolean : 1

Collection: station(供应商)

Field_compact_name Field_name Count Percentage Types_count
_id _id 7621 100.0 string : 7621
address address 7621 100.0 string : 3843, null : 3778
bank bank 7621 100.0 string : 4148, null : 3473
business_licence business_licence 7621 100.0 string : 3821, null : 3800
card_no card_no 7621 100.0 string : 4053, null : 3568
company_name company_name 7621 100.0 string : 4542, null : 3079
contacter contacter 7621 100.0 string : 4432, null : 3189
contacter_phone contacter_phone 7621 100.0 string : 4389, null : 3232
distribute_cities distribute_cities 7621 100.0 ARRAY(string : 4082, null : 3712) : 7621
name name 7621 100.0 string : 7621
pay_method pay_method 7621 100.0 integer : 7621
phone phone 7621 100.0 string : 5403, null : 2218
role role 7621 100.0 integer : 7621
show_tax_rate show_tax_rate 7621 100.0 integer : 7621
state state 7621 100.0 integer : 7621
customer_id customer_id 7241 95.00999999999999 string : 7241
merchandise merchandise 7241 95.00999999999999 ARRAY(string : 114402, null : 621) : 7241
search_text search_text 7241 95.00999999999999 ARRAY(string : 33770, null : 2003) : 7241
station_id station_id 7240 95.0 string : 7240
partner_id partner_id 7231 94.88 integer : 7231
merchandise_ref_price_type merchandise_ref_price_type 7172 94.11 integer : 7172
purchase_ref_price_type purchase_ref_price_type 7172 94.11 integer : 7172
default_settle_way default_settle_way 6599 86.59 integer : 6599
district_code district_code 4916 64.51 null : 3713, string : 1203
district_name district_name 4916 64.51 null : 3250, string : 1062, ARRAY(string : 1234) : 604
suppliers suppliers 3715 48.75 ARRAY(string : 6050, null : 313) : 3715
account account 3714 48.730000000000004 string : 3714
code code 3714 48.730000000000004 string : 3714
main_cate main_cate 3714 48.730000000000004 ARRAY(string : 6071, null : 583) : 3714
receive_begin_time receive_begin_time 3714 48.730000000000004 string : 3714
receive_end_time receive_end_time 3714 48.730000000000004 string : 3714
receiver_name receiver_name 3714 48.730000000000004 string : 3714
receiver_phone receiver_phone 3714 48.730000000000004 string : 3714
location_lat location_lat 2088 27.400000000000002 null : 1966, float : 122
location_lon location_lon 2088 27.400000000000002 null : 1966, float : 122
qualification_images qualification_images 2088 27.400000000000002 ARRAY(null : 2048, string : 58) : 2084, null : 4
enable_customized enable_customized 274 3.5999999999999996 float : 274
enable_pay_info enable_pay_info 274 3.5999999999999996 integer : 274
key_url key_url 274 3.5999999999999996 string : 274
pay_info_id pay_info_id 274 3.5999999999999996 string : 274
service_time service_time 256 3.36 ARRAY(null : 256) : 256
station_status station_status 178 2.34 integer : 178
distribute_center distribute_center 1 0.01 string : 1
id id 1 0.01 string : 1

Collection: stock_new

Field_compact_name Field_name Count Percentage Types_count
_id _id 8424 100.0 oid : 8424
avg_price avg_price 8424 100.0 integer : 5135, float : 3289
remain remain 8424 100.0 float : 8150, integer : 274
spu_id spu_id 8424 100.0 string : 8424
station_id station_id 8424 100.0 string : 8424
_lock _lock 8218 97.55 boolean : 8218
threshold threshold 211 2.5 float : 211
threshold_remain_difference threshold_remain_difference 211 2.5 float : 211

Collection: stock_sheet

Field_compact_name Field_name Count Percentage Types_count
_id _id 10000 100.0 string : 10000
creator creator 10000 100.0 string : 10000
date_time date_time 10000 100.0 date : 10000
delta_money delta_money 10000 100.0 integer : 9735, float : 265
details details 10000 100.0 ARRAY(OBJECT : 59873, null : 602) : 10000
: category category 59873 598.73 string : 59873
: id id 59873 598.73 string : 59873
: money money 59873 598.73 float : 52910, integer : 6963
: name name 59873 598.73 string : 59873
: operator operator 59873 598.73 string : 59873
: quantity quantity 59873 598.73 float : 59649, integer : 224
: std_unit std_unit 59873 598.73 string : 59873
: unit_price unit_price 59873 598.73 integer : 52888, float : 6985
: spu_id spu_id 59642 596.42 string : 59642
: batch_number batch_number 35914 359.14 string : 35914
: life_time life_time 35914 359.14 null : 35914
: purchase_unit purchase_unit 35914 359.14 string : 35914
: ratio ratio 35914 359.14 float : 35864, integer : 50
: shelf_id shelf_id 35914 359.14 null : 35914
: shelf_name shelf_name 28477 284.77000000000004 null : 28477
: desc desc 4031 40.31 string : 4030, null : 1
: remain remain 40 0.4 null : 22, integer : 18
: remark remark 11 0.11 string : 11
settle_supplier_id settle_supplier_id 10000 100.0 string : 9974, null : 26
sku_money sku_money 10000 100.0 float : 9587, integer : 413
station_id station_id 10000 100.0 string : 10000
status status 10000 100.0 integer : 10000
supplier_name supplier_name 10000 100.0 string : 9974, null : 26
type type 10000 100.0 integer : 10000
update_time update_time 10000 100.0 date : 10000
zhezhangs zhezhangs 10000 100.0 ARRAY(null : 9947, OBJECT : 53) : 10000
: action action 53 0.53 string : 53
: create_time create_time 53 0.53 date : 53
: money money 53 0.53 float : 53
: operator operator 53 0.53 string : 53
: reason reason 53 0.53 string : 53
: remark remark 53 0.53 string : 53
: creator creator 1 0.01 string : 1
: operate_time operate_time 1 0.01 string : 1
fentans fentans 9746 97.46000000000001 ARRAY(null : 9743, OBJECT : 3) : 9746
: action action 3 0.03 string : 3
: create_time create_time 3 0.03 date : 3
: in_sku_logs in_sku_logs 3 0.03 ARRAY(string : 19) : 3
: method method 3 0.03 string : 3
: money money 3 0.03 float : 3
: operator operator 3 0.03 string : 3
: reason reason 3 0.03 string : 3
: remark remark 3 0.03 string : 3
_lock _lock 9589 95.89 boolean : 9589
init_details init_details 9552 95.52000000000001 ARRAY(OBJECT : 59171, null : 403) : 9552
: category category 59171 619.46 string : 59171
: id id 59171 619.46 string : 59171
: money money 59171 619.46 float : 52279, string : 6133, integer : 759
: name name 59171 619.46 string : 59171
: operator operator 59171 619.46 string : 59171
: quantity quantity 59171 619.46 float : 58947, integer : 224
: std_unit std_unit 59171 619.46 string : 59171
: unit_price unit_price 59171 619.46 integer : 52264, float : 6907
: spu_id spu_id 58940 617.04 string : 58940
: batch_number batch_number 35914 375.97999999999996 string : 35914
: life_time life_time 35914 375.97999999999996 null : 35914
: purchase_unit purchase_unit 35914 375.97999999999996 string : 35914
: ratio ratio 35914 375.97999999999996 float : 35864, integer : 50
: shelf_id shelf_id 35914 375.97999999999996 null : 35914
: shelf_name shelf_name 28477 298.13 null : 28477
: desc desc 3965 41.510000000000005 string : 3964, null : 1
: remark remark 11 0.12 string : 11
submit_time submit_time 9397 93.97 date : 9397
purchase_sheet_id purchase_sheet_id 10 0.1 string : 10
create_type create_type 8 0.08 integer : 8

Collection: stock_value_new

Field_compact_name Field_name Count Percentage Types_count
_id _id 10000 100.0 oid : 10000
accum_stock_value accum_stock_value 10000 100.0 float : 8694, integer : 1306
date_time date_time 10000 100.0 date : 10000
spu_id spu_id 10000 100.0 string : 10000
station_id station_id 10000 100.0 string : 10000
out_stock_amount out_stock_amount 6973 69.73 float : 6973
out_stock_value out_stock_value 6973 69.73 float : 6973
in_stock_amount in_stock_amount 4916 49.16 float : 4916
in_stock_value in_stock_value 4916 49.16 float : 4916
loss_stock_amount loss_stock_amount 1127 11.27 float : 1127
loss_stock_value loss_stock_value 1127 11.27 float : 1127
increase_stock_amount increase_stock_amount 554 5.54 float : 554
increase_stock_value increase_stock_value 554 5.54 float : 554
return_stock_amount return_stock_amount 13 0.13 float : 13
return_stock_value return_stock_value 13 0.13 float : 13

Collection: user_config

Field_compact_name Field_name Count Percentage Types_count
_id _id 292 100.0 oid : 292
create_time create_time 292 100.0 date : 292
load_config load_config 292 100.0 ARRAY(string : 1082, null : 136) : 292
uid uid 292 100.0 integer : 292
update_time update_time 292 100.0 date : 292

Collection: weighting_latest

Field_compact_name Field_name Count Percentage Types_count
_id _id 10000 100.0 string : 10000
modify_time modify_time 10000 100.0 date : 10000
order_id order_id 10000 100.0 string : 10000
quantity quantity 10000 100.0 float : 10000
real_quantity real_quantity 10000 100.0 float : 9967, integer : 33
sku_id sku_id 10000 100.0 string : 10000
weighting_quantity weighting_quantity 10000 100.0 integer : 9868, float : 132

Collection: weighting_op_log

Field_compact_name Field_name Count Percentage Types_count
_id _id 10000 100.0 oid : 10000
create_time create_time 10000 100.0 date : 10000
data data 10000 100.0 ARRAY(OBJECT : 13732) : 10000
: order_id order_id 13732 137.32 string : 13732
: sku_id sku_id 13732 137.32 string : 13732
: set_weight set_weight 4758 47.58 float : 2471, integer : 2287
: weight weight 4758 47.58 integer : 4692, float : 66
: source_order_id source_order_id 160 1.6 string : 160
employee_number employee_number 10000 100.0 string : 9769, null : 231
op op 10000 100.0 string : 10000
station_id station_id 10000 100.0 string : 10000
user_id user_id 10000 100.0 integer : 10000
user_name user_name 10000 100.0 string : 10000

Collection: weighting_spu_group

Field_compact_name Field_name Count Percentage Types_count
_id _id 5 100.0 string : 5
name name 5 100.0 string : 5
spus spus 5 100.0 ARRAY(string : 77, null : 1) : 5
station_id station_id 5 100.0 string : 5

Collection: wx_pay_info

Field_compact_name Field_name Count Percentage Types_count
_id _id 433 100.0 string : 433
appid appid 433 100.0 string : 432, null : 1
appsecret appsecret 433 100.0 string : 431, null : 2
create_station_id create_station_id 433 100.0 string : 432, null : 1
merchant_id merchant_id 433 100.0 string : 428, null : 5
name name 433 100.0 string : 433
pay_key pay_key 433 100.0 string : 428, null : 5
modify_time modify_time 107 24.709999999999997 date : 107
create_time create_time 46 10.620000000000001 date : 46
default default 1 0.22999999999999998 boolean : 1

Collection: spu_product

Field_compact_name Field_name Count Percentage Types_count
_id _id 87 100.0 string : 87
category_id_1 category_id_1 87 100.0 string : 87
category_id_2 category_id_2 87 100.0 string : 87
create_time create_time 87 100.0 date : 87
desc desc 87 100.0 string : 87
dispatch_method dispatch_method 87 100.0 integer : 87
group_id group_id 87 100.0 integer : 87
modify_time modify_time 87 100.0 date : 87
name name 87 100.0 string : 87
need_pesticide_detect need_pesticide_detect 87 100.0 boolean : 87
p_type p_type 87 100.0 integer : 87
pinlei_id pinlei_id 87 100.0 string : 87
search_text search_text 87 100.0 ARRAY(string : 263) : 87
station_id station_id 87 100.0 string : 87
status status 87 100.0 integer : 87
std_unit_name std_unit_name 87 100.0 string : 87
image image 3 3.45 string : 3
alias alias 2 2.3 ARRAY(string : 2) : 2

Collection: pinlei

Field_compact_name Field_name Count Percentage Types_count
_id _id 14 100.0 string : 14
create_time create_time 14 100.0 date : 14
group_id group_id 14 100.0 integer : 14
modify_time modify_time 14 100.0 date : 14
name name 14 100.0 string : 14
status status 14 100.0 integer : 14
upstream_id upstream_id 14 100.0 string : 14

Collection: category_level2

Field_compact_name Field_name Count Percentage Types_count
_id _id 7 100.0 string : 7
create_time create_time 7 100.0 date : 7
group_id group_id 7 100.0 integer : 7
modify_time modify_time 7 100.0 date : 7
name name 7 100.0 string : 7
status status 7 100.0 integer : 7
upstream_id upstream_id 7 100.0 string : 7
rank rank 1 14.29 integer : 1

Collection: category_level1

Field_compact_name Field_name Count Percentage Types_count
_id _id 4 100.0 string : 4
create_time create_time 4 100.0 date : 4
group_id group_id 4 100.0 integer : 4
icon icon 4 100.0 integer : 4
modify_time modify_time 4 100.0 date : 4
name name 4 100.0 string : 4
rank rank 4 100.0 integer : 4
status status 4 100.0 integer : 4