一线平台CRM数据表

整理文档很辛苦,赏杯茶钱您下走!

免费阅读已结束,点击下载阅读编辑剩下 ...

阅读已结束,您可以下载文档离线阅读编辑

资源描述

数据库字段名称类型空action_idintparent_idintaction_namesvarcharaction_codevarcharisshowintisstatusintaction_orderintaction_notevarcharuser_idint否passwordvarchar是add_timedatetime是user_namevarchar否user_truenamevarchar否fenjivarchar是bianhaovarchar是role_idint否groupidint否is_manageint是purview_typeint是user_plusint是enty_timedatetime否user_statusint否is_hsintone_twois_updateint是logintypepidintdepthsproupidintuser_levelintwebsite_idvarchar是website_id_ckvarchar是menu_idint否parent_idint否nenu_namesvarchar否action_codevarchar否urlvarchar否isshowint是isstatusint是menu_orderint是groupidint否groupnamevarchar否top_idint是p_idint是g_levelint是g_listint是is_manageitn是group_orderbyint是is_statusint是is_showint是group_listvarchar是ckorder一线平台数据库ck_admin_action(权限标识表)ck_admin_user(用户表)ck_admin_menu菜单栏表ck_group_type部门表group_list2varchar是action_listvarchar是customer_site_listvarchar是max_order_zckint是inter_userNamevarchar是sms_idint是mail_uservarchar是mail_pswvarchar是company_idvarchar是work_company_idint是zhekoufloat是max_customervarchar是is_leafint是role_idint否parent_idint是role_namevarchar是action_listvarchar是web_listvarchar是role_describevarchar是role_orderbyint是action_codevarchar是site_idint否site_namevarchar是site_urlvarchar是tel400varchar是售后电话varchar是cat_idvarchar是site_remarktext是单位名称varchar是hide_valueint是is_statusint是cat_id2varchar是site_allint是_MASK_FROM_V2timestamp否rec_idint否order_idint是goods_idint是goos_namevarchar是goods_snvarchar是goods_numberint是market_pricefloat是goods_pricefloat是goods_oldpricefloat是goods_attrvarchar是send_numberint是is_realint是parent_idint是ckorder一线平台数据库ck_group_type部门表ck_role权限表ck_website网站来源表ck_order_goods商品表is_giftint是add_timedatetime是is_activeint是goods_typeint是admin_idint是cat_idint是is_yhjint是g_typeint是jianmavarchar是shop_pricefloat是bramd_idint是bramd_namevarchar是comment_statusint是expand_nameintorder_idint否order_snvarchar是user_idint是order_statusint是shipping_statusint是pay_statusint是consigneevarchar是countryint是provinceint是cityint是districtint是addressvarchar是zipcodvarchar是telvarchar是mobilevarchar是emailvarchar是best_timevarchar是sign_buildingvarchar是postscriptvarchar是shipping_idint是shipping_namevarchar是pay_idint是pay_namevarchar是goods_amountfloat是order_amountfloat是add_timedatetime是confirm_timedatetime是pay_timedatetime是to_buyervarchar是theipvarchar是admin_idint是admin_namevarchar是is_second_ordeint是over_timedatetime是qqvarchar是is_commissionint是is_activeint是is_signint是is_returnint是site_idint是ckorder一线平台数据库ck_order_goods商品表ck_order_info订单表site_namevarchar是last_timedatetime是groupidint是is_dingjinint是dingjin_amountint是is_dingjinokint是customer_idint是is_changeactiveint是other_discountDecimal(18,2)是is_lockint是really_shipping_freefloat是sgroupidint是yuyue_timedatetime是ageint是birth_daydatetime是ed_idint是reason_idint是sexint是oda_pick_plbigint是oda_pick_kidbigint是oda_pick_ct是return_timedatetimeprint_lockintonline_payint是source_typeintkd_onint是kd_on_add_timedatetime是is_24orderint是WarehouseIDint是changeout_timedatetime是invoice_noint是is_sendcard_feequestion_idint否question_typeint是order_idint是order_snvarchar是add_user_idint是add_user_namevarchar是revert_user_idint是revert_user_namevarchar是old_question_idint是countenttext是add_timedatetime是revert_timedatetime是question_statusint是ckorder一线平台数据库ck_order_info订单表ck_admin_question客户问题表bank_idint否bank_namevarchar是is_statusint是bank_descint是brand_idint否brand_namevarchar是brand_orderint是is_statusint是hide_valueint是idint否user_idint是Day_callTimeint是Day_callNum_totalint是Day_callNum_outint是Day_callNum_effectiveint是add_timedatetime是idint否cr_idint是phonevarchar是fenjivarchar是add_timedatetime是start_timedatetime是end_timedatetime是Talk_Secondint是IOFlagint是is_updateint是customer_idint是customer_namevarchar是user_idint是user_namevarchar是user_truenamevarchar是groupidint是groupnamevarchar是sgroupidint是sgroupnamevarchar是is_dealint是deal_user_idint是deal_user_namevarchar是deal_timedatetime是is_shareint是new_admin_idint是phone_zvarchar是site_idint是company_idint是ck_bankname银行表ck_brand品牌表ck_call_record_day每天通话记录表ck_call_records通话表ckorder一线平台数据库idint否cr_idint是phonevarchar是fenjivarchar是add_timedatetime是start_timedatetime是end_timedatetime是Talk_Secondint是IOFlagint是is_updateint是customer_idint是customer_namevarchar是user_idint是user_namevarchar是user_truenamevarchar是groupidint是groupnamevarchar是sgroupidint是sgroupnamevarchar是is_dealint是deal_user_idint是deal_user_namevarchar是deal_timedatetime是is_shareint是new_admin_idint是phone_zvarchar是site_idint是company_idint是goods_idintcat_idintgoods_snvarchargoods_namevarchargoods_name_stylevarcharclick_countintbrand_idintprovider_namevarchargoods_numberintgoods_weightfloatmarket_pricefloatshop_pricefloatpromote_pricefloatpromote_start_datedatetimepromote_end_datedatetimewarn_numberintkeywordsvarchargoods_briefvarchargoods_descvarchargoods_thumbvarchargoods_imgvarcharoriginal_imgvarcharis_realintextension_codevarcharintegralintadd_timedatetimeck_call_records通话表ck_cll_records_bak通话备份表CK_GOODS商品表ckorder一线平台数据库sort_orderintis_deleteintis_bestintis_newintis_hotintis_promoteintbonus_type_idintlast_updatedatetimegoods_typeintseller_notevarchargive_integralintcomment_statusintw

1 / 53
下载文档,编辑使用

©2015-2020 m.777doc.com 三七文档.

备案号:鲁ICP备2024069028号-1 客服联系 QQ:2149211541

×
保存成功