123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797179817991800180118021803180418051806180718081809181018111812181318141815181618171818181918201821182218231824182518261827182818291830183118321833183418351836183718381839184018411842184318441845184618471848184918501851185218531854185518561857185818591860186118621863186418651866186718681869187018711872187318741875187618771878187918801881188218831884188518861887188818891890189118921893189418951896189718981899190019011902190319041905190619071908190919101911191219131914191519161917191819191920192119221923192419251926192719281929193019311932193319341935193619371938193919401941194219431944194519461947194819491950195119521953195419551956195719581959196019611962196319641965196619671968196919701971197219731974197519761977197819791980198119821983198419851986198719881989199019911992199319941995199619971998199920002001200220032004200520062007200820092010201120122013201420152016201720182019202020212022202320242025202620272028202920302031203220332034203520362037203820392040204120422043204420452046204720482049205020512052205320542055205620572058205920602061206220632064206520662067206820692070207120722073207420752076207720782079208020812082208320842085208620872088208920902091209220932094209520962097209820992100210121022103210421052106210721082109211021112112211321142115211621172118211921202121212221232124212521262127212821292130213121322133213421352136213721382139214021412142214321442145214621472148214921502151215221532154215521562157215821592160216121622163216421652166216721682169217021712172217321742175217621772178217921802181218221832184218521862187218821892190219121922193219421952196219721982199220022012202220322042205220622072208220922102211221222132214221522162217221822192220222122222223222422252226222722282229223022312232223322342235223622372238223922402241224222432244224522462247224822492250225122522253225422552256225722582259226022612262226322642265226622672268226922702271227222732274227522762277227822792280228122822283228422852286228722882289229022912292229322942295229622972298229923002301230223032304230523062307230823092310231123122313231423152316231723182319232023212322232323242325232623272328232923302331233223332334233523362337233823392340234123422343234423452346234723482349235023512352235323542355235623572358235923602361236223632364236523662367236823692370237123722373237423752376237723782379238023812382238323842385238623872388238923902391239223932394239523962397239823992400240124022403240424052406240724082409241024112412241324142415241624172418241924202421242224232424242524262427242824292430243124322433243424352436243724382439244024412442244324442445244624472448244924502451245224532454245524562457245824592460246124622463246424652466246724682469247024712472247324742475247624772478247924802481248224832484248524862487248824892490249124922493249424952496249724982499250025012502250325042505250625072508250925102511251225132514251525162517251825192520252125222523252425252526252725282529253025312532253325342535253625372538253925402541254225432544254525462547254825492550255125522553255425552556255725582559256025612562256325642565256625672568256925702571257225732574257525762577257825792580258125822583258425852586258725882589259025912592259325942595259625972598259926002601260226032604260526062607260826092610261126122613261426152616261726182619262026212622262326242625262626272628262926302631263226332634263526362637263826392640264126422643264426452646264726482649265026512652265326542655265626572658265926602661266226632664266526662667266826692670267126722673267426752676267726782679268026812682268326842685268626872688268926902691269226932694269526962697269826992700270127022703270427052706270727082709271027112712271327142715271627172718271927202721272227232724272527262727272827292730273127322733273427352736273727382739274027412742274327442745274627472748274927502751275227532754275527562757275827592760276127622763276427652766276727682769277027712772277327742775277627772778277927802781278227832784278527862787278827892790279127922793279427952796279727982799280028012802280328042805280628072808280928102811281228132814281528162817281828192820282128222823282428252826282728282829283028312832283328342835283628372838283928402841284228432844284528462847284828492850285128522853285428552856285728582859286028612862286328642865286628672868286928702871287228732874287528762877287828792880288128822883288428852886288728882889289028912892289328942895289628972898 |
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_account
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_account`
- (
- `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
- `deposit` varchar(255) DEFAULT NULL COMMENT '开户行',
- `name` varchar(255) DEFAULT NULL COMMENT '收款账户名称',
- `account` varchar(64) DEFAULT NULL COMMENT '收款账号',
- `status` tinyint(1) DEFAULT '1' COMMENT '0禁用1正常',
- `type` enum('public','private') DEFAULT 'public' COMMENT '账户类型public 公账 private私户',
- `create_id` int(11) DEFAULT NULL COMMENT '创建人',
- `createtime` bigint(16) DEFAULT NULL COMMENT '创建时间',
- `updatetime` bigint(16) DEFAULT NULL COMMENT '更新时间',
- `deletetime` bigint(16) DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COMMENT='项目开户行表';
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_achievement
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_achievement`
- (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `name` varchar(50) DEFAULT '' COMMENT '名字',
- `obj_id` int(11) DEFAULT '0' COMMENT '对象ID',
- `type` tinyint(2) DEFAULT '0' COMMENT '1公司2部门3员工',
- `year` int(8) DEFAULT NULL COMMENT '年',
- `january` decimal(18, 2) DEFAULT '0.00' COMMENT '一月',
- `february` decimal(18, 2) DEFAULT '0.00' COMMENT '二月',
- `march` decimal(18, 2) DEFAULT '0.00' COMMENT '三月',
- `april` decimal(18, 2) DEFAULT '0.00' COMMENT '四月',
- `may` decimal(18, 2) DEFAULT '0.00' COMMENT '五月',
- `june` decimal(18, 2) DEFAULT '0.00' COMMENT '六月',
- `july` decimal(18, 2) DEFAULT '0.00' COMMENT '七月',
- `august` decimal(18, 2) DEFAULT '0.00' COMMENT '八月',
- `september` decimal(18, 2) DEFAULT '0.00' COMMENT '九月',
- `october` decimal(18, 2) DEFAULT '0.00' COMMENT '十月',
- `november` decimal(18, 2) DEFAULT '0.00' COMMENT '十一月',
- `december` decimal(18, 2) DEFAULT '0.00' COMMENT '十二月',
- `status` tinyint(2) DEFAULT '0' COMMENT '1销售(目标)2回款(目标)3 获客 4 拜访 5服务工单',
- `yeartarget` decimal(18, 2) DEFAULT '0.00' COMMENT '年目标',
- `createtime` bigint(16) DEFAULT NULL COMMENT '创建时间',
- `updatetime` bigint(16) DEFAULT NULL COMMENT '更新时间',
- `deletetime` bigint(16) DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='业绩目标表';
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_achievement_records`
- (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `name` varchar(50) DEFAULT '' COMMENT '名字',
- `obj_id` int(11) DEFAULT '0' COMMENT '对象ID',
- `type` tinyint(2) DEFAULT '0' COMMENT '1公司2部门3员工',
- `year` int(8) DEFAULT NULL COMMENT '年',
- `january` decimal(18, 2) DEFAULT '0.00' COMMENT '一月',
- `february` decimal(18, 2) DEFAULT '0.00' COMMENT '二月',
- `march` decimal(18, 2) DEFAULT '0.00' COMMENT '三月',
- `april` decimal(18, 2) DEFAULT '0.00' COMMENT '四月',
- `may` decimal(18, 2) DEFAULT '0.00' COMMENT '五月',
- `june` decimal(18, 2) DEFAULT '0.00' COMMENT '六月',
- `july` decimal(18, 2) DEFAULT '0.00' COMMENT '七月',
- `august` decimal(18, 2) DEFAULT '0.00' COMMENT '八月',
- `september` decimal(18, 2) DEFAULT '0.00' COMMENT '九月',
- `october` decimal(18, 2) DEFAULT '0.00' COMMENT '十月',
- `november` decimal(18, 2) DEFAULT '0.00' COMMENT '十一月',
- `december` decimal(18, 2) DEFAULT '0.00' COMMENT '十二月',
- `status` tinyint(2) DEFAULT '0' COMMENT '1销售(目标)2回款(目标)',
- `yeartarget` decimal(18, 2) DEFAULT '0.00' COMMENT '年目标',
- `check_status` tinyint(4) DEFAULT '0' COMMENT '0待审核、1审核中、2审核通过、3审核未通过、4撤销、',
- `flow_staff_ids` varchar(255) DEFAULT '' COMMENT '流程审批人ID',
- `flow_id` int(11) NULL DEFAULT NULL COMMENT '审核流程ID',
- `order_id` int(11) NULL DEFAULT NULL COMMENT '审批流程步骤id',
- `check_staff_ids` varchar(255) DEFAULT '' COMMENT '已审批人IDs',
- `owner_staff_id` int(11) NULL DEFAULT NULL COMMENT '负责人id',
- `createtime` int(11) DEFAULT NULL,
- `updatetime` int(11) DEFAULT NULL,
- `deletetime` int(11) DEFAULT NULL,
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='业绩目标修改日志表';
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_admin_config
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_admin_config`
- (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `type` varchar(50) DEFAULT NULL COMMENT '类型',
- `field` varchar(50) DEFAULT NULL COMMENT '字段名',
- `value` varchar(200) DEFAULT NULL COMMENT '字段值',
- `createtime` bigint(16) DEFAULT NULL COMMENT '创建时间',
- `updatetime` bigint(16) DEFAULT NULL COMMENT '更新时间',
- `deletetime` bigint(16) DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_aftermarket
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_aftermarket`
- (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `type_ids` varchar(64) DEFAULT NULL COMMENT '分类id 1,2,3,4',
- `product_ids` varchar(64) DEFAULT NULL COMMENT '产品id',
- `title` varchar(255) DEFAULT NULL COMMENT '标题',
- `img` varchar(255) DEFAULT NULL COMMENT '图片',
- `method` text COMMENT '处理方式',
- `desc` varchar(255) DEFAULT NULL COMMENT '简介',
- `content` text COMMENT '内容',
- `click_number` int(10) DEFAULT '0' COMMENT '点击次数',
- `comment_num` int(10) DEFAULT '0' COMMENT '评论数',
- `create_staff_id` int(10) DEFAULT NULL COMMENT '创建销售',
- `createtime` bigint(16) DEFAULT NULL COMMENT '创建时间',
- `updatetime` bigint(16) DEFAULT NULL COMMENT '更新时间',
- `deletetime` bigint(16) DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='售后问题';
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_aftermarket_type
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_aftermarket_type`
- (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `pid` int(10) DEFAULT NULL COMMENT '问题上级分类id',
- `name` varchar(255) DEFAULT NULL COMMENT '问题分类名称',
- `create_staff_id` int(10) DEFAULT NULL COMMENT '创建人',
- `sort` int(4) DEFAULT '10' COMMENT '排序',
- `createtime` bigint(16) DEFAULT NULL COMMENT '创建时间',
- `updatetime` bigint(16) DEFAULT NULL COMMENT '更新时间',
- `deletetime` bigint(16) DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='售后问题分类';
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_approval`
- (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `formapproval_id` int(11) DEFAULT NULL COMMENT '审批id',
- `number` varchar(255) DEFAULT NULL COMMENT '编号',
- `relation_type` varchar(255) DEFAULT NULL COMMENT '关联类型',
- `relation_id` int(11) DEFAULT NULL COMMENT '关联id',
- `content` text COMMENT '内容',
- `check_status` tinyint(4) DEFAULT '0' COMMENT '0待审核、1审核中、2审核通过、3审核未通过、4撤销、',
- `flow_staff_ids` varchar(255) DEFAULT '' COMMENT '流程审批人ID',
- `check_staff_ids` varchar(255) DEFAULT '' COMMENT '已审批人IDs',
- `next_staff_id` int(4) DEFAULT NULL COMMENT '下个审核人Id',
- `show_staff_id` varchar(128) DEFAULT NULL COMMENT '查看人',
- `create_staff_id` int(10) DEFAULT NULL COMMENT '创建人',
- `file_ids` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '附件',
- `flow_id` int(11) NULL DEFAULT NULL COMMENT '审核流程ID',
- `order_id` int(11) NULL DEFAULT NULL COMMENT '审批流程步骤id',
- `createtime` bigint(16) DEFAULT NULL COMMENT '创建时间',
- `updatetime` bigint(16) DEFAULT NULL COMMENT '更新时间',
- `deletetime` bigint(16) DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=80 DEFAULT CHARSET=utf8mb4 COMMENT='审批详情';
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_area_management
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_area_management`
- (
- `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
- `name` varchar(32) DEFAULT NULL COMMENT '区域名称',
- `province_ids` text COMMENT 'area_province里面id集合',
- `createtime` bigint(16) DEFAULT NULL COMMENT '创建时间',
- `updatetime` bigint(16) DEFAULT NULL COMMENT '更新时间',
- `deletetime` bigint(16) DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`) USING BTREE,
- KEY `name_index` (`name`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COMMENT='区域管理';
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_area_province
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_area_province`
- (
- `id` int(10) NOT NULL AUTO_INCREMENT COMMENT 'ID',
- `status` tinyint(1) DEFAULT '0' COMMENT '选中状态0未选中1已选中',
- `pid` int(10) DEFAULT NULL COMMENT '父id',
- `shortname` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '简称',
- `name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '名称',
- `mergename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '全称',
- `level` tinyint(4) DEFAULT NULL COMMENT '层级 0 1 2 省市区县',
- `pinyin` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '拼音',
- `code` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '长途区号',
- `zip` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '邮编',
- `first` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '首字母',
- `lng` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '经度',
- `lat` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '纬度',
- PRIMARY KEY (`id`) USING BTREE,
- KEY `pid` (`pid`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='地区表';
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_comment
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_comment`
- (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `relation_type` varchar(32) DEFAULT '0' COMMENT 'sign 签到 customer 客户 event 日程 notice 公告 article文章 workorder工单',
- `relation_id` int(11) DEFAULT NULL COMMENT '关联id',
- `staff_id` int(11) DEFAULT NULL COMMENT '用户ID',
- `content` varchar(255) DEFAULT NULL COMMENT '评论内容',
- `praise` int(11) DEFAULT '0' COMMENT '点赞数',
- `file_ids` varchar(128) DEFAULT NULL COMMENT '文件ID',
- `status` tinyint(1) DEFAULT '0' COMMENT '0 待审核 1已审核',
- `ip` varchar(100) DEFAULT NULL COMMENT 'ip地址',
- `operator` int(11) NULL DEFAULT NULL COMMENT '审核人',
- `checktime` datetime NULL DEFAULT NULL COMMENT '审核时间',
- `createtime` bigint(16) DEFAULT NULL COMMENT '创建时间',
- `updatetime` bigint(16) DEFAULT NULL COMMENT '更新时间',
- `deletetime` bigint(16) DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='评论表';
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_companys` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `com` varchar(32) DEFAULT NULL COMMENT '名称',
- `no` varchar(32) DEFAULT NULL COMMENT '编号',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='快递公司';
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_consume`
- (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `number` varchar(32) DEFAULT NULL COMMENT '费用编号',
- `title` varchar(255) DEFAULT NULL COMMENT '标题',
- `relation_type` varchar(32) DEFAULT NULL COMMENT '关联业务',
- `relation_id` int(11) DEFAULT NULL COMMENT '关联id',
- `customer_id` int(11) DEFAULT NULL COMMENT '客户ID',
- `consume_time` date NULL DEFAULT NULL COMMENT '消费日期',
- `consume_type` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '消费方式',
- `submit_date` date DEFAULT NULL COMMENT '申请日期',
- `submit_type` varchar(64) DEFAULT '' COMMENT '报销类型',
- `money` decimal(18, 2) DEFAULT '0.00' COMMENT '报销总金额',
- `is_cashier` tinyint(1) DEFAULT '0' COMMENT '是否出纳 0否 1是',
- `check_status` tinyint(4) DEFAULT '0' COMMENT '0待审核、1审核中、2审核通过、3审核未通过、4撤销、5草稿(未提交)',
- `flow_id` int(11) NULL DEFAULT NULL COMMENT '审核流程ID',
- `order_id` int(11) NULL DEFAULT NULL COMMENT '审批流程步骤id',
- `flow_staff_ids` varchar(255) DEFAULT '' COMMENT '流程审批人ID',
- `check_staff_ids` varchar(255) DEFAULT '' COMMENT '已审核审批人IDs',
- `next_staff_id` int(4) DEFAULT NULL COMMENT '下一个审批人id',
- `show_staff_ids` varchar(128) DEFAULT NULL COMMENT '可查看人',
- `remark` varchar(255) DEFAULT NULL COMMENT '备注',
- `file_ids` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '附件ID',
- `staff_id` int(10) NOT NULL COMMENT '创建人ID',
- `createtime` bigint(16) DEFAULT NULL COMMENT '创建时间',
- `updatetime` bigint(16) DEFAULT NULL COMMENT '更新时间',
- `deletetime` bigint(16) DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`) USING BTREE,
- KEY `staff_id` (`staff_id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='费用表';
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_consume_detail`
- (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `consume_id` int(10) NOT NULL COMMENT '费用id',
- `customer_id` int(11) DEFAULT NULL COMMENT '客户ID',
- `consume_date` date DEFAULT NULL COMMENT '消费日期',
- `consume_type` varchar(64) DEFAULT '' COMMENT '报销类型',
- `consume_money` decimal(18, 2) DEFAULT '0.00' COMMENT '报销总金额',
- `remark` varchar(255) DEFAULT NULL COMMENT '备注',
- `file_ids` varchar(128) DEFAULT NULL COMMENT '附件ID',
- `mileage` varchar(255) DEFAULT NULL COMMENT '公里数',
- `car_number` varchar(128) DEFAULT NULL COMMENT '车牌号',
- `car_type` varchar(128) DEFAULT NULL COMMENT '出行工具',
- `start_mileage` varchar(255) DEFAULT NULL COMMENT '起始公里数',
- `end_mileage` varchar(255) DEFAULT NULL COMMENT '结束公里数',
- `other_files` varchar(64) DEFAULT NULL COMMENT '其他附件',
- PRIMARY KEY (`id`) USING BTREE,
- KEY `staff_id` (`consume_id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='费用表';
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_contacts
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_contacts`
- (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `customer_id` int(10) NOT NULL COMMENT '客户ID',
- `is_major` tinyint(1) DEFAULT '0' COMMENT '是否主要联系人 0 否 1是',
- `region` tinyint(1) DEFAULT NULL COMMENT '1国内 2国外',
- `name` varchar(64) DEFAULT '' COMMENT '姓名',
- `subname` varchar(64) DEFAULT NULL COMMENT '简称或尊称',
- `sex` tinyint(1) DEFAULT NULL COMMENT '性别 1男 2女',
- `role` varchar(32) DEFAULT NULL COMMENT '角色',
- `post` varchar(32) DEFAULT NULL COMMENT '职务',
- `email` varchar(32) DEFAULT NULL COMMENT '邮箱',
- `mobilecode` varchar(32) DEFAULT NULL COMMENT '区号',
- `mobile` varchar(32) DEFAULT NULL COMMENT '手机号',
- `telephone` varchar(32) DEFAULT NULL COMMENT '电话 座机',
- `birthday` varchar(32) DEFAULT NULL COMMENT '生日',
- `fax` varchar(32) DEFAULT NULL COMMENT '传真号',
- `wechat` varchar(32) DEFAULT NULL COMMENT '微信号',
- `qq` varchar(32) DEFAULT NULL COMMENT 'qq号',
- `address` varchar(64) DEFAULT NULL COMMENT '省市区',
- `address_detail` varchar(64) DEFAULT NULL COMMENT '详细地址',
- `remarks` varchar(255) DEFAULT NULL COMMENT '备注信息',
- `create_staff_id` int(10) DEFAULT NULL COMMENT '创建人ID',
- `owner_staff_id` int(10) DEFAULT NULL COMMENT '负责人ID',
- `next_time` datetime DEFAULT NULL COMMENT '下次联系时间',
- `createtime` bigint(16) DEFAULT NULL COMMENT '创建时间',
- `updatetime` bigint(16) DEFAULT NULL COMMENT '更新时间',
- `deletetime` bigint(16) DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`) USING BTREE,
- KEY `customer_id_index` (`customer_id`) USING BTREE,
- KEY `mobile` (`mobile`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='联系人表';
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_contacts_file
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_contacts_file`
- (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `contacts_id` int(11) NOT NULL COMMENT '联系人ID',
- `file_id` int(11) NOT NULL COMMENT '附件ID',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='联系人附件';
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_contacts_other
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_contacts_other`
- (
- `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '客户id',
- `otherdata` text COMMENT '自定义信息 json',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_contract
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_contract`
- (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `customer_id` int(10) NOT NULL COMMENT '客户ID',
- `contacts_id` int(10) DEFAULT NULL COMMENT '客户签约人 联系人',
- `quote_id` int(10) DEFAULT NULL COMMENT '报价单id',
- `name` varchar(50) DEFAULT '' COMMENT '合同名称',
- `num` varchar(64) DEFAULT '' COMMENT '合同编号',
- `order_date` date DEFAULT NULL COMMENT '下单时间',
- `money` decimal(18, 2) DEFAULT '0.00' COMMENT '合同金额',
- `total_price` decimal(18, 2) DEFAULT '0.00' COMMENT '产品总金额',
- `discount_rate` decimal(10, 2) DEFAULT '0.00' COMMENT '整单折扣',
- `is_start` tinyint(1) DEFAULT NULL COMMENT '0 未生效 1 已生效',
- `is_check_success` tinyint(1) DEFAULT '0' COMMENT '是否已审核 0 否 1是',
- `contract_status` tinyint(1) DEFAULT '0' COMMENT '0 进行中 1 已完成 2 已作废',
- `check_status` tinyint(4) DEFAULT '0' COMMENT '0待审核、1审核中、2审核通过、3审核未通过、4撤销、',
- `flow_staff_ids` varchar(255) DEFAULT '' COMMENT '流程审批人ID',
- `check_staff_ids` varchar(255) DEFAULT '' COMMENT '已审批人IDs',
- `start_time` date DEFAULT NULL COMMENT '开始时间',
- `end_time` date DEFAULT NULL COMMENT '结束时间',
- `order_staff_id` varchar(255) DEFAULT '' COMMENT '公司签约人',
- `business_id` int(11) NULL DEFAULT NULL COMMENT '商机ID',
- `remarks` varchar(255) DEFAULT NULL COMMENT '备注',
- `flow_id` int(11) NULL DEFAULT NULL COMMENT '审核流程ID',
- `order_id` int(11) NULL DEFAULT NULL COMMENT '审批流程步骤id',
- `ratio_id` int(11) NULL DEFAULT NULL COMMENT '绩效ID',
- `ratios` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '业绩比例',
- `create_staff_id` int(10) DEFAULT NULL COMMENT '创建人ID',
- `owner_staff_id` int(10) DEFAULT NULL COMMENT '负责人ID',
- `show_staff_id` varchar(255) DEFAULT NULL COMMENT '显示人ID',
- `createtime` bigint(16) DEFAULT NULL COMMENT '创建时间',
- `updatetime` bigint(16) DEFAULT NULL COMMENT '更新时间',
- `deletetime` bigint(16) DEFAULT NULL COMMENT '删除时间',
- `plan` varchar(2000) DEFAULT NULL COMMENT '回款计划',
- `signed_at` varchar(255) DEFAULT NULL COMMENT '签订地点',
- `guarantee` varchar(32) DEFAULT NULL COMMENT '免费保修期限',
- `payment` varchar(255) DEFAULT '' COMMENT '支付方式:全款发货/五五/三六一/三七',
- `payment_text` varchar(255) DEFAULT '' COMMENT '备注',
- `tax_text` varchar(255) DEFAULT NULL COMMENT '含税情况',
- `delivery_time` varchar(64) DEFAULT NULL COMMENT '交货时间',
- `be_overdue` varchar(255) DEFAULT NULL COMMENT '逾期付款',
- `effective` varchar(255) DEFAULT NULL COMMENT '生效方式',
- `legal` varchar(32) DEFAULT NULL COMMENT '法定代表人',
- `deposit` varchar(255) DEFAULT NULL COMMENT '开户行',
- `account` varchar(255) DEFAULT NULL COMMENT '账号',
- `fax` varchar(64) DEFAULT NULL COMMENT '传真',
- `mobile` varchar(255) DEFAULT NULL COMMENT '电话',
- `entrust` varchar(32) DEFAULT NULL COMMENT '委托代理人',
- `handler` varchar(32) DEFAULT NULL COMMENT '经办人',
- `collection_account` varchar(255) DEFAULT NULL COMMENT '收款账号',
- `collection_deposit` varchar(255) DEFAULT NULL COMMENT '收款开户行',
- `collection_name` varchar(255) DEFAULT NULL COMMENT '收款账户名称',
- `collection_img` varchar(255) DEFAULT NULL COMMENT '收款图片',
- `consignee` varchar(255) DEFAULT '' COMMENT '收货人',
- `consignee_mobile` varchar(255) DEFAULT '' COMMENT '收货人联系方式',
- `delivery_address` varchar(255) DEFAULT '' COMMENT '交货地点',
- `delivery_address_detail` varchar(255) DEFAULT '' COMMENT '交货详情',
- `receipt_file_ids` varchar(64) DEFAULT '' COMMENT '回执单附件',
- `receipt_date` date DEFAULT NULL COMMENT '回执时间',
- `invoice_file_ids` varchar(255) DEFAULT '' COMMENT '发票附件',
- `invoice_date` date DEFAULT NULL COMMENT '发票日期',
- `invoice_logistics_number` varchar(64) DEFAULT NULL COMMENT '发票物流单号',
- PRIMARY KEY (`id`) USING BTREE,
- KEY `customer_id_index` (`customer_id`) USING BTREE,
- KEY `contacts_id_index` (`contacts_id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='合同表';
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_contract_file
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_contract_file`
- (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `contract_id` int(11) NOT NULL COMMENT '合同ID',
- `file_id` int(11) NOT NULL COMMENT '附件ID',
- `createtime` bigint(16) DEFAULT NULL COMMENT '创建时间',
- `create_id` int(10) DEFAULT NULL COMMENT '创建人',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=utf8mb4 COMMENT='合同附件';
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_contract_other
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_contract_other`
- (
- `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '客户id',
- `otherdata` text COMMENT '自定义信息 json',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_contract_product
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_contract_product`
- (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `contract_id` int(11) DEFAULT NULL COMMENT '合同',
- `product_id` int(11) DEFAULT NULL COMMENT '产品',
- `number` int(11) DEFAULT NULL COMMENT '数量',
- `price` decimal(10, 2) DEFAULT NULL COMMENT '购买价格',
- `parts` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '产品配置',
- `ship_status` tinyint(1) NULL DEFAULT 0 COMMENT '0 待发货 1发货 2已收货',
- `type` varchar(32) DEFAULT NULL COMMENT '标准 非标',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_customer
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_customer`
- (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `type` enum('A','B','C','D') DEFAULT 'D' COMMENT '客户类型 a-d,A最高',
- `seas_id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '所属公海',
- `sea_time` int(11) NULL DEFAULT NULL COMMENT '放入公海时间',
- `mobile` varchar(15) DEFAULT NULL COMMENT '手机号',
- `parent_id` int(10) DEFAULT '0' COMMENT '上级(客户/公司)ID',
- `name` varchar(128) DEFAULT NULL COMMENT '客户名称',
- `subname` varchar(128) DEFAULT NULL COMMENT '助记名称',
- `level` tinyint(1) DEFAULT NULL COMMENT '1-5 客户星级',
- `industry` varchar(64) DEFAULT NULL COMMENT '客户行业',
- `source` varchar(64) DEFAULT NULL COMMENT '客户来源',
- `follow` varchar(32) DEFAULT NULL COMMENT '跟进状态',
- `country` varchar(255) DEFAULT NULL COMMENT '乡',
- `last_time` datetime DEFAULT NULL COMMENT '最后一次跟进时间',
- `next_time` datetime DEFAULT NULL COMMENT '下次联系时间',
- `contract_status` tinyint(1) DEFAULT '0' COMMENT '成交状态 0未成交 1已成交',
- `trade_date` date DEFAULT NULL COMMENT '成交日期',
- `receivetime` int(11) DEFAULT NULL COMMENT '领取时间',
- `address` varchar(64) DEFAULT NULL COMMENT '省市区',
- `address_detail` varchar(128) DEFAULT NULL COMMENT '详细地址',
- `location` varchar(128) DEFAULT NULL COMMENT '定位信息',
- `file_ids` varchar(255) DEFAULT NULL COMMENT '附件ID',
- `scale` varchar(32) DEFAULT NULL COMMENT '企业规模',
- `remarks` varchar(255) DEFAULT NULL COMMENT '备注信息',
- `enterprise_status` tinyint(1) DEFAULT '0' COMMENT '工商信息0未查询1已查询',
- `enterprise_detail_status` tinyint(1) DEFAULT '0' COMMENT '工商信息精准查询0未查询1已查询',
- `claimdate` date DEFAULT NULL COMMENT '领用时间(领用A/B/CD)',
- `is_seas` tinyint(1) DEFAULT '0' COMMENT '0 1公海',
- `create_staff_id` int(10) DEFAULT NULL COMMENT '创建人ID',
- `owner_staff_id` int(10) DEFAULT NULL COMMENT '负责人ID',
- `ro_staff_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '只读权限',
- `rw_staff_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '读写权限',
- `show_staff_ids` varchar(128) DEFAULT NULL COMMENT '显示人',
- `management_id` int(10) DEFAULT NULL COMMENT '所在区域',
- `lng` double(16,12) DEFAULT NULL COMMENT '地理位置经度',
- `lat` double(16,12) DEFAULT NULL COMMENT '地理位置维度',
- `createtime` bigint(16) DEFAULT NULL COMMENT '创建时间',
- `updatetime` bigint(16) DEFAULT NULL COMMENT '更新时间',
- `deletetime` bigint(16) DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`) USING BTREE,
- KEY `parent_id_index` (`parent_id`) USING BTREE,
- KEY `owner_staff_id` (`owner_staff_id`) USING BTREE,
- KEY `name` (`name`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='客户表';
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_customer_enterprise
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_customer_enterprise`
- (
- `id` int(8) NOT NULL AUTO_INCREMENT,
- `keywords` varchar(100) NOT NULL COMMENT '关键字',
- `total` int(4) DEFAULT NULL COMMENT '共查询到条数',
- `num` int(4) DEFAULT NULL COMMENT '返回条数',
- `content` mediumtext COMMENT '内容',
- `author_id` int(8) DEFAULT NULL COMMENT '查询人id',
- `author` varchar(10) DEFAULT NULL COMMENT '查询人',
- `res_status` tinyint(1) DEFAULT '0' COMMENT '查询结果0正常1异常',
- `createtime` bigint(16) DEFAULT NULL COMMENT '查询时间',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='工商信息查询记录';
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_customer_enterprise_detail
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_customer_enterprise_detail`
- (
- `id` int(8) NOT NULL AUTO_INCREMENT,
- `name` varchar(100) DEFAULT NULL COMMENT '公司名称',
- `content` mediumtext COMMENT '内容',
- `author_id` int(8) DEFAULT NULL COMMENT '查询人id',
- `author` varchar(10) DEFAULT NULL COMMENT '查询人',
- `res_status` tinyint(1) DEFAULT '0' COMMENT '查询结果0正常1异常',
- `createtime` int(10) DEFAULT NULL COMMENT '查询时间',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='工商信息精准查询记录';
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_customer_file
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_customer_file`
- (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `customer_id` int(11) NOT NULL COMMENT '客户ID',
- `file_id` int(11) NOT NULL COMMENT '附件ID',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='客户附件表';
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_customer_other
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_customer_other`
- (
- `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '客户id',
- `otherdata` text COMMENT '自定义信息 json',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_customer_product
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_customer_product`
- (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `customer_id` int(10) DEFAULT NULL COMMENT '客户ID',
- `contract_id` int(10) DEFAULT NULL COMMENT '合同id',
- `order_id` int(10) DEFAULT NULL COMMENT '订单id',
- `product_id` int(10) DEFAULT NULL COMMENT '产品id',
- `status` tinyint(1) DEFAULT '0' COMMENT '0 待发货 1 发货中 2 待安装 3 安装成功 9 撤销',
- `number` varchar(64) DEFAULT NULL COMMENT '设备编号',
- `file_ids` varchar(255) DEFAULT NULL COMMENT '设备图片',
- `pay_date` date DEFAULT NULL COMMENT '购买时间',
- `over_date` date DEFAULT NULL COMMENT '质保到期时间',
- `create_staff_id` int(10) DEFAULT NULL COMMENT '创建人',
- `createtime` bigint(16) DEFAULT NULL COMMENT '创建时间',
- `updatetime` bigint(16) DEFAULT NULL COMMENT '更新时间',
- `deletetime` bigint(16) DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='客户产品表';
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_customer_type
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_customer_type`
- (
- `id` int(4) NOT NULL AUTO_INCREMENT,
- `name` varchar(5) DEFAULT NULL COMMENT '名称',
- `days_cus` int(4) DEFAULT NULL COMMENT '给员工提醒时间节点,天数',
- `days_pid` int(4) DEFAULT NULL COMMENT '给领导提醒时间节点,第二次天数',
- `cus_status` tinyint(1) DEFAULT '0' COMMENT '员工提醒 0关闭1开启',
- `pid_status` tinyint(1) DEFAULT '0' COMMENT '领导提醒 0关闭1开启',
- `createtime` bigint(16) DEFAULT NULL COMMENT '创建时间',
- `updatetime` bigint(16) DEFAULT NULL COMMENT '更新时间',
- `deletetime` bigint(16) DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='客户类型';
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_daily
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_daily`
- (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `type` varchar(50) DEFAULT NULL COMMENT ' 日 周 月 季 年',
- `other` text COMMENT '其他',
- `reminds_id` varchar(255) DEFAULT NULL COMMENT '提醒人员列表',
- `create_staff_id` int(10) DEFAULT NULL COMMENT '创建用户id',
- `createtime` bigint(16) DEFAULT NULL COMMENT '创建时间',
- `updatetime` bigint(16) DEFAULT NULL COMMENT '更新时间',
- `deletetime` bigint(16) DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='工作报告';
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_daily_read
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_daily_read`
- (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `staff_id` int(10) DEFAULT NULL COMMENT '员工ID',
- `daily_id` int(10) DEFAULT NULL COMMENT '工作报告ID',
- `createtime` bigint(16) DEFAULT NULL COMMENT '创建时间',
- `updatetime` bigint(16) DEFAULT NULL COMMENT '更新时间',
- `deletetime` bigint(16) DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`) USING BTREE,
- KEY `staff_id` (`staff_id`) USING BTREE,
- KEY `record_id` (`daily_id`) USING BTREE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='跟进记录已读记录';
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_discuss
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_discuss`
- (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `title` varchar(255) DEFAULT NULL COMMENT '名称',
- `content` text DEFAULT NULL COMMENT '内容',
- `file_ids` varchar(64) DEFAULT NULL COMMENT '附件ID',
- `show_staff_id` varchar(255) DEFAULT NULL COMMENT '显示人',
- `create_staff_id` int(10) DEFAULT NULL COMMENT '创建人',
- `relation_type` varchar(32) DEFAULT NULL COMMENT '关联类型',
- `relation_id` int(10) DEFAULT NULL COMMENT '关联ID',
- `createtime` bigint(16) DEFAULT NULL COMMENT '创建时间',
- `updatetime` bigint(16) DEFAULT NULL COMMENT '更新时间',
- `deletetime` bigint(16) DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='讨论问题';
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_equipment
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_equipment`
- (
- `id` int(8) NOT NULL AUTO_INCREMENT,
- `pro_id` int(8) DEFAULT NULL COMMENT '产品ID',
- `cus_pro_id` int(8) DEFAULT NULL COMMENT '客户产品表id',
- `number` char(18) DEFAULT NULL COMMENT '设备编号',
- `logo` varchar(255) DEFAULT NULL COMMENT '二维码',
- `name` varchar(50) DEFAULT NULL COMMENT '设备名称',
- `model` varchar(50) DEFAULT NULL COMMENT '型号',
- `needle` varchar(50) DEFAULT NULL COMMENT '机针',
- `voltage` varchar(50) DEFAULT NULL COMMENT '电压',
- `weight` double(10, 2) DEFAULT NULL COMMENT '重量',
- `img` varchar(255) DEFAULT NULL COMMENT '设备图',
- `binding_status` tinyint(1) DEFAULT '1' COMMENT '绑定客户产品状态:1未绑定0已绑定',
- `createtime` bigint(16) DEFAULT NULL COMMENT '创建时间',
- `updatetime` bigint(16) DEFAULT NULL COMMENT '更新时间',
- `deletetime` bigint(16) DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='设备管理';
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_event
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_event`
- (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `type` tinyint(1) DEFAULT '1' COMMENT '1 日程 2任务 3 拜访',
- `process` varchar(64) DEFAULT '0' COMMENT '进程 1 开始 2 到访 3 结束',
- `event_type` varchar(128) DEFAULT NULL COMMENT '日程分类',
- `title` varchar(255) DEFAULT NULL COMMENT '日程标题',
- `visits_number` tinyint(3) DEFAULT NULL COMMENT '第几次拜访客户',
- `visit_purpose` varchar(255) DEFAULT NULL COMMENT '拜访目的',
- `start_time` varchar(32) DEFAULT NULL COMMENT '开始时间',
- `end_time` varchar(32) DEFAULT NULL COMMENT '结束时间',
- `status` tinyint(2) DEFAULT '0' COMMENT '日程状态 0未开始 1执行中2 已结束 3 已取消',
- `level` tinyint(2) DEFAULT NULL COMMENT '紧要程度 0普通 1重要 2紧急 4 重要且紧急',
- `remindtype` tinyint(4) DEFAULT '0' COMMENT '提醒时间0准时提醒 1:5分钟前 2:15分钟前 3:30分钟前 4:一个小时前 5:两个小时前 6:一天前 7:两天前 8:一周前',
- `remind_time` datetime DEFAULT NULL COMMENT '提醒时间',
- `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '' COMMENT '备注',
- `relation_type` varchar(32) DEFAULT NULL COMMENT '关联类型 1客户 2工单',
- `relation_id` int(11) DEFAULT NULL COMMENT '关联ID',
- `customer_id` int(11) DEFAULT NULL COMMENT '客户id',
- `staff_id` int(10) DEFAULT NULL COMMENT '归属人ID',
- `create_staff_id` int(11) DEFAULT NULL COMMENT '任务创建人id',
- `show_staff_ids` varchar(32) DEFAULT NULL,
- `actual_start_time` int(10) DEFAULT NULL COMMENT '实际开始时间',
- `actual_arrive_time` int(10) DEFAULT NULL COMMENT '实际到访时间',
- `actual_end_time` int(10) DEFAULT NULL COMMENT '实际结束时间',
- `use_time` int(10) DEFAULT NULL COMMENT '消耗工时',
- `is_successful` tinyint(1) DEFAULT NULL COMMENT '是否达到预期目的 1是/已解决 2否/俄日解决',
- `achieve_purpose` varchar(255) DEFAULT NULL COMMENT '达成目的',
- `last_event` varchar(32) DEFAULT NULL COMMENT '下一行程 返程/拜访下一家',
- `reminds_id` varchar(32) DEFAULT NULL COMMENT '通知人',
- `call_content` text DEFAULT NULL COMMENT '通话内容',
- `start_mileage` varchar(255) DEFAULT NULL COMMENT '起始公里shu',
- `car_type` varchar(255) DEFAULT NULL COMMENT '出行工具',
- `end_mileage` varchar(255) DEFAULT NULL COMMENT '结束公里数',
- `back_mileage` varchar(255) DEFAULT NULL COMMENT '返程公里数',
- `needs` varchar(255) DEFAULT NULL COMMENT '客户需求',
- `car_number` varchar(64) DEFAULT NULL,
- `auto_end` tinyint(1) NOT NULL DEFAULT 1 COMMENT '自动结束 0否 1是',
- `owner_staff_id` int(11) NOT NULL DEFAULT 0 COMMENT '指派人',
- `createtime` bigint(16) DEFAULT NULL COMMENT '创建时间',
- `updatetime` bigint(16) DEFAULT NULL COMMENT '更新时间',
- `deletetime` bigint(16) DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`) USING BTREE,
- KEY `title` (`title`) USING BTREE,
- KEY `staff_id` (`staff_id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='日程提醒';
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_event_needs
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_event_needs`
- (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `event_id` int(10) DEFAULT NULL COMMENT '事件ID',
- `staff_id` int(10) DEFAULT NULL COMMENT '创建人',
- `needs` text COMMENT '记录',
- `createtime` bigint(16) DEFAULT NULL COMMENT '创建时间',
- `updatetime` bigint(16) DEFAULT NULL COMMENT '更新时间',
- `deletetime` bigint(16) DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`) USING BTREE,
- KEY `staff_id` (`staff_id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='跟进记录已读记录';
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_examine_record
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_examine_record`
- (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `relation_id` int(10) DEFAULT '0' COMMENT '关联ID',
- `relation_type` varchar(32) DEFAULT '0' COMMENT 'consume 费用 ',
- `check_staff_id` int(11) DEFAULT '0' COMMENT '审批人ID',
- `check_time` int(11) DEFAULT NULL COMMENT '审批时间',
- `status` tinyint(4) DEFAULT '0' COMMENT '0待审批 1审核通过2审核拒绝 3撤销',
- `content` varchar(255) DEFAULT '' COMMENT '审核意见',
- `remark` varchar(255) DEFAULT '' COMMENT '审核备注',
- `edit_field` text COMMENT '修改的字段',
- `is_end` tinyint(1) DEFAULT '0' COMMENT '审批失效(1标记为无效)',
- `createtime` bigint(16) DEFAULT NULL COMMENT '创建时间',
- `updatetime` bigint(16) DEFAULT NULL COMMENT '更新时间',
- `deletetime` bigint(16) DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='审批记录';
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_feedback
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_feedback`
- (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `staff_id` int(11) DEFAULT NULL COMMENT '创建人',
- `content` text COMMENT '内容',
- `file_ids` varchar(128) DEFAULT NULL COMMENT '附件ID',
- `createtime` bigint(16) DEFAULT NULL COMMENT '创建时间',
- `updatetime` bigint(16) DEFAULT NULL COMMENT '更新时间',
- `deletetime` bigint(16) DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='意见反馈';
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_field
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_field`
- (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `type` varchar(32) DEFAULT NULL COMMENT '类型',
- `field` varchar(128) DEFAULT NULL COMMENT '内容',
- `name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
- `data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='字段管理';
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_file
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_file`
- (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `types` varchar(20) DEFAULT NULL COMMENT '类型(file、image)',
- `name` varchar(100) DEFAULT NULL COMMENT '附件名称',
- `save_name` varchar(255) DEFAULT NULL COMMENT '保存路径名称',
- `size` int(10) DEFAULT NULL COMMENT '附件大小(字节)',
- `file_path` varchar(255) DEFAULT NULL COMMENT '文件路径',
- `file_path_thumb` varchar(255) DEFAULT NULL COMMENT '文件路径(图片缩略图)',
- `create_staff_id` int(10) DEFAULT NULL COMMENT '创建人ID',
- `createtime` bigint(16) DEFAULT NULL COMMENT '创建时间',
- `updatetime` bigint(16) DEFAULT NULL COMMENT '更新时间',
- `deletetime` bigint(16) DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='小程序 附件表';
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_flow
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_flow`
- (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `name` varchar(100) DEFAULT NULL COMMENT '名称',
- `type` varchar(32) DEFAULT NULL COMMENT '类型',
- `examine_ids` varchar(200) DEFAULT NULL COMMENT '默认审核人id',
- `status` tinyint(1) NULL DEFAULT NULL COMMENT '1 固定审批 0 授权审批',
- `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
- `relation_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '关联类型',
- `group_ids` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '关联角色组',
- `weight` tinyint(4) NULL DEFAULT NULL COMMENT '权重',
- `last_modified` int(11) NULL DEFAULT NULL COMMENT '最后修改时间',
- `last_admin_id` int(11) NULL DEFAULT NULL COMMENT '最后修改人',
- `createtime` bigint(16) DEFAULT NULL COMMENT '创建时间',
- `updatetime` bigint(16) DEFAULT NULL COMMENT '更新时间',
- `deletetime` bigint(16) DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='流程审核配置';
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_form
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_form`
- (
- `id` int(10) NOT NULL AUTO_INCREMENT,
- `name` varchar(64) DEFAULT NULL COMMENT '姓名',
- `type` varchar(32) DEFAULT NULL COMMENT 'type类型',
- `data` text COMMENT '数据',
- `createtime` bigint(16) DEFAULT NULL COMMENT '创建时间',
- `updatetime` bigint(16) DEFAULT NULL COMMENT '更新时间',
- `deletetime` bigint(16) DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='表单配置';
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_form_approval`
- (
- `id` int(10) NOT NULL AUTO_INCREMENT,
- `form_id` int(11) DEFAULT NULL COMMENT '表单ID',
- `name` varchar(64) DEFAULT NULL COMMENT '名称',
- `type` varchar(32) DEFAULT NULL COMMENT 'type类型',
- `img` varchar(255) DEFAULT NULL COMMENT '图片',
- `data` text COMMENT '数据',
- `desc` text COMMENT '描述',
- `flow_staff_ids` varchar(255) DEFAULT NULL COMMENT '审批人列表',
- `examine_ids` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '默认审核人id',
- `status` tinyint(1) NULL DEFAULT NULL COMMENT '1 固定审批 0 授权审批',
- `createtime` bigint(16) DEFAULT NULL COMMENT '创建时间',
- `updatetime` bigint(16) DEFAULT NULL COMMENT '更新时间',
- `deletetime` bigint(16) DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='审批表单配置';
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_joint_follow
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_joint_follow`
- (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `relation_type` varchar(255) DEFAULT NULL COMMENT '类型',
- `relation_id` int(10) DEFAULT NULL COMMENT '关联ID',
- `staff_id` int(10) DEFAULT NULL COMMENT '创建人',
- `roles` tinyint(1) DEFAULT NULL COMMENT '1 管理员 2普通角色',
- `is_edit` tinyint(1) DEFAULT NULL COMMENT '0 只读 1 读写',
- `createtime` bigint(16) DEFAULT NULL COMMENT '创建时间',
- `updatetime` bigint(16) DEFAULT NULL COMMENT '更新时间',
- `deletetime` bigint(16) DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='联合跟进人';
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_leads
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_leads`
- (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `customer_id` int(11) DEFAULT '0' COMMENT '线索转化为客户ID',
- `is_transform` tinyint(1) DEFAULT '0' COMMENT '1已转化',
- `name` varchar(64) DEFAULT '' COMMENT '线索名称',
- `source` varchar(64) DEFAULT '' COMMENT '线索来源',
- `sex` tinyint(1) DEFAULT NULL COMMENT '1男 2女',
- `telephone` varchar(64) DEFAULT '' COMMENT '电话',
- `mobile` varchar(64) DEFAULT '' COMMENT '手机',
- `industry` varchar(64) DEFAULT '' COMMENT '客户行业',
- `level` varchar(64) DEFAULT '' COMMENT '客户级别',
- `address` varchar(128) DEFAULT NULL COMMENT '省市区',
- `address_detail` varchar(128) DEFAULT '' COMMENT '地址',
- `remarks` varchar(255) DEFAULT NULL COMMENT '备注',
- `create_staff_id` int(10) DEFAULT NULL COMMENT '创建人ID',
- `owner_staff_id` int(10) DEFAULT NULL COMMENT '负责人ID',
- `last_time` datetime DEFAULT NULL COMMENT '上次跟进时间',
- `next_time` datetime NULL DEFAULT NULL COMMENT '下次联系时间',
- `follow` varchar(20) DEFAULT NULL COMMENT '跟进',
- `tranfer_stff_id` int(10) NULL DEFAULT NULL COMMENT '转派人ID',
- `receive_time` int(11) NULL DEFAULT NULL COMMENT '分配时间',
- `createtime` bigint(16) DEFAULT NULL COMMENT '创建时间',
- `updatetime` bigint(16) DEFAULT NULL COMMENT '更新时间',
- `deletetime` bigint(16) DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`) USING BTREE,
- KEY `name` (`name`) USING BTREE,
- KEY `mobile` (`mobile`) USING BTREE,
- KEY `staff_id` (`owner_staff_id`) USING BTREE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='线索表';
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_leads_file
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_leads_file`
- (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `leads_id` int(11) NOT NULL COMMENT '线索ID',
- `file_id` int(11) NOT NULL COMMENT '附件ID',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='客户附件表';
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_leads_other
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_leads_other`
- (
- `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '客户id',
- `otherdata` text COMMENT '自定义信息 json',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_login_token
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_login_token`
- (
- `token` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Token',
- `login_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0' COMMENT '登录ID',
- `createtime` int(10) DEFAULT NULL COMMENT '创建时间',
- `expiretime` int(10) DEFAULT NULL COMMENT '过期时间',
- PRIMARY KEY (`token`) USING BTREE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='小程序用户登录Token表';
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_message
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_message`
- (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `relation_type` varchar(32) DEFAULT '0' COMMENT '关联类型 consume 费用审批',
- `relation_id` int(10) DEFAULT NULL COMMENT '关联ID',
- `to_staff_id` int(10) DEFAULT NULL COMMENT '接收人ID',
- `from_staff_id` int(10) DEFAULT NULL COMMENT '发送人ID',
- `title` varchar(255) DEFAULT NULL COMMENT '通知标题',
- `content` text DEFAULT NULL COMMENT '发送内容',
- `send_time` int(11) DEFAULT NULL COMMENT '发送时间',
- `read_time` int(11) DEFAULT NULL COMMENT '阅读时间',
- `status` tinyint(1) DEFAULT NULL COMMENT '0 未操作 1已操作 ',
- `action_id` int(11) DEFAULT NULL COMMENT '操作ID',
- `createtime` bigint(16) DEFAULT NULL COMMENT '创建时间',
- `updatetime` bigint(16) DEFAULT NULL COMMENT '更新时间',
- `deletetime` bigint(16) DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='提醒消息';
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_mobilecode
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_mobilecode`
- (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `name` varchar(64) DEFAULT NULL COMMENT '国家',
- `number` varchar(32) DEFAULT NULL COMMENT '区号',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='手机区号';
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_notice
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_notice`
- (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `title` varchar(50) DEFAULT NULL COMMENT '标题',
- `content` text COMMENT '内容',
- `start_time` int(11) DEFAULT NULL COMMENT '开始时间',
- `end_time` int(11) DEFAULT NULL COMMENT '结束时间',
- `owner_staff_ids` varchar(100) DEFAULT '' COMMENT '通知人',
- `read_staff_ids` text COMMENT '阅读人',
- `create_staff_id` int(10) DEFAULT NULL COMMENT '创建人ID',
- `createtime` bigint(16) DEFAULT NULL COMMENT '创建时间',
- `updatetime` bigint(16) DEFAULT NULL COMMENT '更新时间',
- `deletetime` bigint(16) DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='公告表';
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_notice_template
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_notice_template`
- (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `name` varchar(64) DEFAULT NULL COMMENT '名称',
- `type` varchar(32) DEFAULT NULL COMMENT '类型',
- `data` text COMMENT '内容',
- `enterprise_data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '企业微信',
- `createtime` bigint(16) DEFAULT NULL COMMENT '创建时间',
- `updatetime` bigint(16) DEFAULT NULL COMMENT '更新时间',
- `deletetime` bigint(16) DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='通知模板设置';
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_ocr
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_ocr`
- (
- `id` int(8) NOT NULL AUTO_INCREMENT COMMENT 'id',
- `type_id` int(4) DEFAULT NULL COMMENT '类型id',
- `file_id` int(8) DEFAULT NULL COMMENT '文件id',
- `file_url` varchar(255) DEFAULT NULL COMMENT '图片地址',
- `staff_id` int(8) DEFAULT NULL COMMENT '创建者id',
- `createtime` int(10) DEFAULT NULL COMMENT '提交时间',
- `updatetime` int(10) DEFAULT NULL COMMENT '修改时间',
- `ocr_result` text COMMENT '识别结果',
- `money` decimal(10, 2) DEFAULT NULL COMMENT '总金额',
- `log_id` varchar(100) DEFAULT NULL COMMENT '返回唯一码',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='ocr识别';
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_ocr_type
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_ocr_type`
- (
- `id` int(4) NOT NULL AUTO_INCREMENT COMMENT 'id',
- `name` varchar(20) DEFAULT NULL COMMENT '名称',
- `type` tinyint(2) DEFAULT '1' COMMENT '类型1财务票据文字识别',
- `action` varchar(100) DEFAULT NULL COMMENT '请求方法',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='财务票据类型';
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_operation_log
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_operation_log`
- (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `content` varchar(255) DEFAULT NULL COMMENT '操作内容',
- `operation_type` tinyint(1) DEFAULT NULL COMMENT '操作人类型 1 员工 2管理员',
- `operation_id` int(11) DEFAULT NULL COMMENT '操作人id',
- `relation_type` tinyint(1) DEFAULT NULL COMMENT '关联类型 1客户 2联系人 3合同',
- `relation_id` int(11) DEFAULT NULL COMMENT '被操作的客户id',
- `lng` varchar(64) DEFAULT NULL COMMENT '经度',
- `lat` varchar(64) DEFAULT NULL COMMENT '纬度',
- `location` varchar(255) DEFAULT NULL COMMENT '定位位置',
- `createtime` bigint(16) DEFAULT NULL COMMENT '创建时间',
- `updatetime` bigint(16) DEFAULT NULL COMMENT '更新时间',
- `deletetime` bigint(16) DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='操作日志';
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_order
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_order`
- (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `customer_id` int(11) NOT NULL COMMENT '客户ID',
- `contacts_id` int(11) DEFAULT NULL COMMENT '客户签约人 联系人',
- `contract_id` int(11) DEFAULT NULL COMMENT '合同id',
- `create_staff_id` int(10) DEFAULT NULL COMMENT '创建人ID',
- `owner_staff_id` int(10) DEFAULT NULL COMMENT '负责人ID',
- `show_staff_id` varchar(255) DEFAULT NULL COMMENT '显示人ID',
- `is_account` tinyint(1) NULL DEFAULT 0 COMMENT '是否已到账',
- `createtime` bigint(16) DEFAULT NULL COMMENT '创建时间',
- `updatetime` bigint(16) DEFAULT NULL COMMENT '更新时间',
- `deletetime` bigint(16) DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`) USING BTREE,
- KEY `customer_id_index` (`customer_id`) USING BTREE,
- KEY `contacts_id_index` (`contacts_id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=178 DEFAULT CHARSET=utf8mb4 COMMENT='订单表';
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_parts
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_parts`
- (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `product_id` varchar(64) DEFAULT NULL COMMENT '所属产品',
- `stock` int(10) DEFAULT '0' COMMENT '库存',
- `warning_stock` int(10) DEFAULT '0' COMMENT '预警库存',
- `name` varchar(128) DEFAULT '' COMMENT '部件名称',
- `num` varchar(128) DEFAULT '' COMMENT '部件编码',
- `img` varchar(128) DEFAULT NULL COMMENT '部件图片',
- `banners` varchar(64) DEFAULT NULL COMMENT '部件多图',
- `unit` varchar(128) DEFAULT '箱' COMMENT '单位',
- `price` decimal(18, 2) DEFAULT '0.00' COMMENT '标准价格',
- `cost_price` decimal(10, 2) DEFAULT NULL COMMENT '成本价',
- `status` varchar(32) DEFAULT '上架' COMMENT '是否上架',
- `description` text DEFAULT NULL COMMENT '部件描述',
- `create_staff_id` int(11) DEFAULT NULL COMMENT '创建人ID',
- `createtime` int(11) DEFAULT NULL COMMENT '创建时间',
- `updatetime` int(11) DEFAULT NULL COMMENT '更新时间',
- `deletetime` int(10) DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='产品部件管理';
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_parts_stock
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_parts_stock`
- (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `parts_id` int(11) DEFAULT NULL COMMENT '零件id',
- `consume_id` int(11) DEFAULT NULL COMMENT '费用id',
- `type` tinyint(1) DEFAULT NULL COMMENT ' 类型 1入库 2出库',
- `number` int(11) DEFAULT NULL COMMENT '入库数量',
- `odd_numbers` varchar(255) DEFAULT NULL COMMENT '入库单号',
- `storage_time` date DEFAULT NULL COMMENT '入库时间',
- `desc` varchar(255) DEFAULT '' COMMENT '备注信息',
- `create_staff_id` int(11) DEFAULT NULL COMMENT '创建人',
- `createtime` bigint(16) DEFAULT NULL COMMENT '创建时间',
- `updatetime` bigint(16) DEFAULT NULL COMMENT '更新时间',
- `deletetime` bigint(16) DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='产品库存';
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_parts_stock_reload
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_parts_stock_reload`
- (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `type` tinyint(1) DEFAULT NULL COMMENT ' 类型 1入库 2出库',
- `odd_numbers` varchar(255) DEFAULT NULL COMMENT '单号',
- `storage_time` date DEFAULT NULL COMMENT '时间',
- `desc` varchar(255) DEFAULT '' COMMENT '备注信息',
- `parts` text COMMENT '详情',
- `create_staff_id` int(11) DEFAULT NULL COMMENT '创建人',
- `createtime` bigint(16) DEFAULT NULL COMMENT '创建时间',
- `updatetime` bigint(16) DEFAULT NULL COMMENT '更新时间',
- `deletetime` bigint(16) DEFAULT NULL COMMENT '删除时间',
- `check_status` tinyint(1) DEFAULT '0' COMMENT '0待审核、1审核中、2审核通过、3审核未通过、4撤销',
- `flow_staff_ids` varchar(64) DEFAULT NULL COMMENT '流程审批人ID',
- `check_staff_ids` varchar(64) DEFAULT NULL COMMENT '已审批人IDs',
- `flow_id` int(11) NULL DEFAULT NULL COMMENT '审核流程ID',
- `order_id` int(11) NULL DEFAULT NULL COMMENT '审批流程步骤id',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='产品库存申请记录';
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_person
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_person`
- (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
- `customer_id` int(10) NOT NULL COMMENT '客户id',
- `account` varchar(11) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '手机号',
- `nickname` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '昵称',
- `password` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '密码',
- `salt` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '密码盐',
- `email` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '电子邮箱',
- `avatar` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '头像',
- `bio` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '格言',
- `token` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT 'Token',
- `status` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '状态',
- `verification` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '验证',
- `createtime` int(10) DEFAULT NULL COMMENT '创建时间',
- `updatetime` int(10) DEFAULT NULL COMMENT '更新时间',
- `deletetime` int(10) DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`) USING BTREE,
- KEY `email` (`email`) USING BTREE,
- KEY `mobile` (`account`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='用户表(不知名端)';
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_person_cart
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_person_cart`
- (
- `id` int(4) NOT NULL AUTO_INCREMENT,
- `person_id` int(4) DEFAULT NULL COMMENT '联系人id',
- `parts_id` int(4) DEFAULT NULL COMMENT '备件id',
- `num` int(4) DEFAULT NULL COMMENT '数量',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='购物车表';
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_person_order
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_person_order`
- (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `order_sn` varchar(20) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '订单号',
- `customer_id` int(11) DEFAULT NULL COMMENT '商户id',
- `company` varchar(255) DEFAULT NULL COMMENT '客户名称',
- `person_id` int(11) DEFAULT '0' COMMENT '用户',
- `parts` text CHARACTER SET utf8mb4 COMMENT '购买零件',
- `parts_amount` decimal(10, 2) DEFAULT '0.00' COMMENT '商品总价',
- `dispatch_amount` decimal(10, 2) DEFAULT '0.00' COMMENT '运费',
- `amount` decimal(10, 2) DEFAULT NULL COMMENT '总费用',
- `linkmobile` varchar(20) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '联系电话',
- `linkname` varchar(20) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '收货人',
- `addrcity` varchar(20) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '省市区',
- `address` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '详细地址',
- `status` tinyint(2) DEFAULT '0' COMMENT '订单状态:0=未支付,1=已支付,2=支付失败',
- `remark` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '用户备注',
- `pay_type` enum('wechat','alipay','wallet','score') CHARACTER SET utf8mb4 DEFAULT 'wechat' COMMENT '支付方式:wechat=微信支付,alipay=支付宝,wallet=钱包支付,score=积分支付',
- `transaction_id` varchar(60) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '交易单号',
- `payment_json` varchar(2500) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '交易原始数据',
- `paytime` int(11) DEFAULT NULL COMMENT '支付时间',
- `ext` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '附加字段',
- `createtime` int(11) DEFAULT NULL COMMENT '创建时间',
- `updatetime` int(11) DEFAULT NULL COMMENT '更新时间',
- PRIMARY KEY (`id`) USING BTREE,
- KEY `person_id_index` (`person_id`) USING BTREE,
- KEY `order_sn_index` (`order_sn`) USING BTREE,
- KEY `customer_id_index` (`customer_id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='用户支付订单';
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_praise
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_praise`
- (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `staff_id` int(11) DEFAULT NULL COMMENT '用户ID',
- `relation_type` tinyint(1) DEFAULT '0' COMMENT '1 动态 2 跟进记录',
- `relation_id` int(11) DEFAULT NULL COMMENT 'ID',
- `createtime` bigint(16) DEFAULT NULL COMMENT '创建时间',
- `updatetime` bigint(16) DEFAULT NULL COMMENT '更新时间',
- `deletetime` bigint(16) DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='点赞表';
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_product
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_product`
- (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `type_id` int(11) DEFAULT NULL COMMENT '类型',
- `name` varchar(128) DEFAULT '' COMMENT '产品名称',
- `stock` varchar(255) DEFAULT NULL COMMENT '产品库存数量',
- `num` varchar(128) DEFAULT '' COMMENT '产品编码',
- `img` varchar(200) DEFAULT NULL COMMENT '产品图片',
- `banners` varchar(255) DEFAULT NULL COMMENT '产品多图',
- `unit` varchar(128) DEFAULT '箱' COMMENT '单位',
- `product_line` varchar(255) DEFAULT NULL COMMENT '产品线',
- `bar_code` varchar(255) DEFAULT NULL COMMENT '条形码',
- `price` decimal(18, 2) DEFAULT '0.00' COMMENT '标准价格',
- `tax_price` decimal(10, 2) DEFAULT NULL COMMENT '含税价格',
- `status` varchar(32) DEFAULT '上架' COMMENT '是否上架',
- `part` text COMMENT '组成部分,json字符串',
- `description` text COMMENT '产品描述',
- `create_staff_id` int(11) DEFAULT NULL COMMENT '创建人',
- `update_staff_id` int(11) DEFAULT NULL COMMENT '最后一次更新人',
- `createtime` int(11) DEFAULT NULL COMMENT '创建时间',
- `updatetime` int(11) DEFAULT NULL COMMENT '更新时间',
- `deletetime` int(10) DEFAULT NULL COMMENT '删除时间',
- `content` text COMMENT '组成部分',
- `goods_id` int(11) NULL DEFAULT NULL COMMENT '商品ID',
- `type` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '规格',
- `min_price` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '最低销售价',
- `cost_price` decimal(10, 2) NULL DEFAULT NULL COMMENT '成本价',
- `wholesale` decimal(10, 2) NULL DEFAULT NULL COMMENT '批发价',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4;
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_product_other
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_product_other`
- (
- `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '产品id',
- `other` text COMMENT '自定义信息 json',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4;
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_product_type
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_product_type`
- (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `pid` int(11) DEFAULT NULL COMMENT '上级分类id',
- `name` varchar(255) DEFAULT NULL COMMENT '分类名称',
- `sort` int(4) DEFAULT '10' COMMENT '排序',
- `speci` varchar(255) DEFAULT NULL COMMENT '规格',
- `description` text COMMENT '备注说明',
- `config_ids` varchar(255) DEFAULT NULL COMMENT '规格ids',
- `createtime` bigint(16) DEFAULT NULL COMMENT '创建时间',
- `updatetime` bigint(16) DEFAULT NULL COMMENT '更新时间',
- `deletetime` bigint(16) DEFAULT NULL COMMENT '删除时间',
- `create_staff_id` int(11) DEFAULT NULL COMMENT '创建人',
- `image` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '分类图片',
- `content` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '内容',
- `status` tinyint(1) NULL DEFAULT NULL COMMENT '状态',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='售后问题分类';
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_product_type_config
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_product_type_config`
- (
- `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
- `type_id` int(11) DEFAULT '0' COMMENT '类型id,默认0',
- `pid` int(11) DEFAULT '0' COMMENT '上级id,默认0',
- `name` varchar(255) DEFAULT NULL COMMENT '名称',
- `num` int(11) DEFAULT '1' COMMENT '数量',
- `unit` varchar(10) DEFAULT NULL COMMENT '单位',
- `remark` varchar(255) DEFAULT NULL COMMENT '备注',
- `sort` int(11) DEFAULT '5' COMMENT '排序',
- `createtime` bigint(16) DEFAULT NULL COMMENT '创建时间',
- `updatetime` bigint(16) DEFAULT NULL COMMENT '更新时间',
- `deletetime` bigint(16) DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='配置清单';
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_proofing
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_proofing`
- (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `customer_id` int(11) DEFAULT NULL COMMENT '客户id',
- `process_type` tinyint(3) DEFAULT '0' COMMENT '进度状态',
- `process_number` varchar(128) DEFAULT NULL COMMENT '打样编号',
- `application_name` varchar(32) DEFAULT NULL COMMENT '申请人',
- `application_department` varchar(32) DEFAULT NULL COMMENT '申请部门',
- `application_date` varchar(32) DEFAULT NULL COMMENT '申请时间',
- `sample_name` varchar(128) DEFAULT NULL COMMENT '样品名称',
- `sample_number` varchar(32) DEFAULT NULL COMMENT '样品数量',
- `sample_material` varchar(32) DEFAULT NULL COMMENT '样品材质',
- `sample_provision` varchar(32) DEFAULT NULL COMMENT '样品提供',
- `provisio_desc` varchar(255) DEFAULT NULL COMMENT '样品来源',
- `completion_date` date DEFAULT NULL COMMENT '要求完成时间',
- `proofing_reason` varchar(32) DEFAULT NULL COMMENT '打样原因',
- `device_name` text DEFAULT NULL COMMENT '设备名称',
- `device_config` varchar(255) DEFAULT NULL COMMENT '设备配置',
- `sample_preservation` varchar(32) DEFAULT NULL COMMENT '样品保存',
- `accuracy` varchar(255) DEFAULT NULL COMMENT '精度要求\n\n',
- `appearance` varchar(255) DEFAULT NULL COMMENT '外观要求\n\n外观要求\n\n外观要求\n\n外观要求',
- `speed` varchar(255) DEFAULT NULL COMMENT '速度要求\n\n',
- `others` varchar(255) DEFAULT NULL COMMENT '其他要求\n\n',
- `test_result` tinyint(1) DEFAULT '0' COMMENT '测试结果 1成功 9 失败',
- `accuracy_result` varchar(255) DEFAULT NULL COMMENT '精度测试结果\n\n精度要求测试结果',
- `appearance_result` varchar(255) DEFAULT NULL COMMENT '外观测试结果',
- `speed_result` varchar(255) DEFAULT NULL COMMENT '速度测试结果',
- `others_result` varchar(255) DEFAULT NULL COMMENT '其他测试结果',
- `tester` varchar(32) DEFAULT NULL COMMENT '测试人员名称',
- `proposal` varchar(255) DEFAULT NULL COMMENT '改善建议',
- `qualified_number` varchar(32) DEFAULT NULL COMMENT '合格数量',
- `loss_number` varchar(32) DEFAULT NULL COMMENT '损耗数量',
- `recommended` varchar(255) DEFAULT NULL COMMENT '建议配置',
- `machine_name` varchar(128) DEFAULT NULL COMMENT '机器名称',
- `machine_desc` varchar(255) DEFAULT NULL COMMENT '机器备注',
- `machine_application_date` varchar(32) DEFAULT NULL COMMENT '机器申请时间',
- `machine_application_department` varchar(32) DEFAULT NULL COMMENT '机器申请部门',
- `machine_application_name` varchar(32) DEFAULT NULL COMMENT '机器申请人',
- `fail_reason` varchar(255) DEFAULT NULL COMMENT '失败原因',
- `file_ids` varchar(50) DEFAULT NULL COMMENT '附件ID',
- `create_staff_id` int(11) DEFAULT NULL COMMENT '创建人',
- `owner_staff_id` int(11) DEFAULT NULL COMMENT '负责人',
- `show_staff_id` varchar(255) DEFAULT NULL COMMENT '显示人',
- `createtime` bigint(16) DEFAULT NULL COMMENT '创建时间',
- `updatetime` bigint(16) DEFAULT NULL COMMENT '更新时间',
- `deletetime` bigint(16) DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4;
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_proofing_result
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_proofing_result`
- (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `proofing_id` int(11) DEFAULT NULL COMMENT '打样id',
- `test_result` tinyint(1) DEFAULT '0' COMMENT '测试结果 1成功 9 失败',
- `accuracy_result` varchar(255) DEFAULT NULL COMMENT '精度测试结果\n\n精度要求测试结果',
- `appearance_result` varchar(255) DEFAULT NULL COMMENT '外观测试结果',
- `speed_result` varchar(255) DEFAULT NULL COMMENT '速度测试结果',
- `others_result` varchar(255) DEFAULT NULL COMMENT '其他测试结果',
- `tester` varchar(32) DEFAULT NULL COMMENT '测试人员名称',
- `proposal` varchar(255) DEFAULT NULL COMMENT '改善建议',
- `qualified_number` varchar(32) DEFAULT NULL COMMENT '合格数量',
- `loss_number` varchar(32) DEFAULT NULL COMMENT '损耗数量',
- `fail_reason` varchar(255) DEFAULT NULL COMMENT '失败原因',
- `recommended` varchar(255) DEFAULT NULL COMMENT '建议配置',
- `create_staff_id` int(11) DEFAULT NULL COMMENT '创建人',
- `owner_staff_id` int(11) DEFAULT NULL COMMENT '负责人',
- `createtime` bigint(16) DEFAULT NULL COMMENT '创建时间',
- `updatetime` bigint(16) DEFAULT NULL COMMENT '更新时间',
- `deletetime` bigint(16) DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='售后工单';
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_push_reload
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_push_reload`
- (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `openid` varchar(255) DEFAULT NULL COMMENT 'openID',
- `template_id` varchar(255) DEFAULT NULL COMMENT '模板ID',
- `data` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '数据',
- `pagepath` varchar(255) DEFAULT NULL COMMENT '信息',
- `errcode` varchar(50) DEFAULT NULL COMMENT 'code',
- `result` varchar(255) DEFAULT NULL COMMENT '结果',
- `createtime` bigint(16) DEFAULT NULL COMMENT '创建时间',
- `updatetime` bigint(16) DEFAULT NULL COMMENT '更新时间',
- `deletetime` bigint(16) DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='微信推送记录';
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_quote
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_quote`
- (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `number` varchar(255) DEFAULT NULL COMMENT '报价单编号',
- `customer_id` int(11) DEFAULT NULL COMMENT '客户id',
- `contacts_id` int(11) DEFAULT NULL COMMENT '客户联系人id',
- `contract_id` int(11) DEFAULT NULL COMMENT '转化的合同id',
- `quote_date` date DEFAULT NULL COMMENT '报价时间',
- `discount_amount` decimal(18, 2) DEFAULT NULL COMMENT '优惠金额',
- `quote_amount` decimal(18, 2) DEFAULT NULL COMMENT '报价金额',
- `file_ids` varchar(64) DEFAULT NULL COMMENT '附件列表',
- `status` tinyint(1) DEFAULT '0' COMMENT '0 进行中 1 转化成功 9作废',
- `create_staff_id` int(11) DEFAULT NULL COMMENT '创建人ID',
- `owner_staff_id` int(11) DEFAULT NULL COMMENT '负责人ID',
- `order_staff_id` int(11) DEFAULT NULL COMMENT '公司签约人',
- `check_status` tinyint(4) DEFAULT '0' COMMENT '0待审核、1审核中、2审核通过、3审核未通过、4撤销、',
- `flow_staff_ids` varchar(255) DEFAULT '' COMMENT '流程审批人ID',
- `check_staff_ids` varchar(255) DEFAULT '' COMMENT '已审批人IDs',
- `show_staff_id` varchar(255) DEFAULT NULL COMMENT '显示人',
- `next_staff_id` int(4) DEFAULT NULL COMMENT '下一个审批人id',
- `clause` text DEFAULT NULL COMMENT '特约条款',
- `product_type` text DEFAULT NULL COMMENT '产品类型',
- `flow_id` int(11) NULL DEFAULT NULL COMMENT '审核流程ID',
- `order_id` int(11) NULL DEFAULT NULL COMMENT '审批流程步骤id',
- `ro_staff_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '只读权限',
- `rw_staff_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '读写权限',
- `createtime` bigint(16) DEFAULT NULL COMMENT '创建时间',
- `updatetime` bigint(16) DEFAULT NULL COMMENT '更新时间',
- `deletetime` bigint(16) DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='报价单';
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_quote_file
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_quote_file`
- (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `quote_id` int(11) NOT NULL COMMENT '报价ID',
- `file_id` int(11) NOT NULL COMMENT '附件ID',
- `createtime` bigint(16) DEFAULT NULL COMMENT '创建时间',
- `create_id` int(11) DEFAULT NULL COMMENT '创建人',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='合同附件';
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_quote_other
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_quote_other`
- (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `other` text COMMENT '自定义信息 json',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4;
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_quote_product
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_quote_product`
- (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `quote_id` int(11) DEFAULT NULL COMMENT '报价单id',
- `type_id` int(11) DEFAULT NULL COMMENT '类型',
- `product_id` int(11) DEFAULT NULL COMMENT '产品',
- `number` int(11) DEFAULT NULL COMMENT '数量',
- `price` decimal(10, 2) DEFAULT NULL COMMENT '购买价格',
- `config_desc` varchar(255) DEFAULT NULL COMMENT '配置说明',
- `remarks` varchar(255) DEFAULT NULL COMMENT '备注',
- `config` text,
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4;
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_receivables
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_receivables`
- (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `plan_id` int(11) DEFAULT NULL COMMENT '回款计划ID',
- `number` varchar(100) DEFAULT '' COMMENT '回款编号',
- `customer_id` int(11) DEFAULT NULL COMMENT '客户ID',
- `contract_id` int(11) DEFAULT NULL COMMENT '合同ID',
- `return_time` date DEFAULT NULL COMMENT '回款日期',
- `return_type` varchar(64) DEFAULT '' COMMENT '回款方式',
- `money` decimal(18, 2) DEFAULT '0.00' COMMENT '回款金额',
- `check_status` tinyint(4) DEFAULT '0' COMMENT '0待审核、1审核中、2审核通过、3审核未通过、4撤销、5草稿(未提交)',
- `flow_staff_ids` varchar(255) DEFAULT '' COMMENT '流程审批人ID',
- `check_staff_ids` varchar(255) DEFAULT '' COMMENT '已审批人IDs',
- `remarks` text COMMENT '备注',
- `create_staff_id` int(10) DEFAULT NULL COMMENT '创建人ID',
- `owner_staff_id` int(10) DEFAULT NULL COMMENT '负责人ID',
- `flow_id` int(11) NULL DEFAULT NULL COMMENT '审核流程ID',
- `order_id` int(11) NULL DEFAULT NULL COMMENT '审批流程步骤id',
- `createtime` bigint(16) DEFAULT NULL COMMENT '创建时间',
- `updatetime` bigint(16) DEFAULT NULL COMMENT '更新时间',
- `deletetime` bigint(16) DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='回款表';
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_receivables_other
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_receivables_other`
- (
- `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '客户id',
- `otherdata` text COMMENT '自定义信息 json',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4;
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_receivables_plan
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_receivables_plan`
- (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `num` varchar(100) NOT NULL DEFAULT '' COMMENT '期数',
- `receivables_id` int(11) NOT NULL DEFAULT '0' COMMENT '回款ID',
- `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0进行中 1完成 2逾期',
- `contract_id` int(11) NOT NULL COMMENT '合同ID',
- `customer_id` int(11) NOT NULL COMMENT '客户ID',
- `money` decimal(18, 2) NOT NULL DEFAULT '0.00' COMMENT '计划回款金额',
- `return_date` date DEFAULT NULL COMMENT '计划回款日期',
- `return_type` varchar(64) NOT NULL DEFAULT '' COMMENT '计划回款方式',
- `remind` tinyint(4) NOT NULL DEFAULT '0' COMMENT '提前几天提醒',
- `remind_date` date DEFAULT NULL COMMENT '提醒日期',
- `remarks` varchar(255) NOT NULL DEFAULT '' COMMENT '备注',
- `file` varchar(255) NOT NULL DEFAULT '' COMMENT '附件',
- `create_staff_id` int(11) NOT NULL COMMENT '创建人ID',
- `owner_staff_id` int(11) NOT NULL COMMENT '负责人ID',
- `createtime` bigint(16) DEFAULT NULL COMMENT '创建时间',
- `updatetime` bigint(16) DEFAULT NULL COMMENT '更新时间',
- `deletetime` bigint(16) DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='回款计划表';
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_staff
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_staff`
- (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `admin_id` int(11) NOT NULL COMMENT '关联后台账号id',
- `group_ids` varchar(100) DEFAULT NULL COMMENT '角色组列表',
- `role` tinyint(2) DEFAULT NULL COMMENT '角色角色 1最高管理员 2公司管理员 3部门经理 4部门主管 5组长 6员工',
- `rules` text DEFAULT NULL COMMENT '权限列表',
- `name` varchar(64) DEFAULT NULL COMMENT '姓名',
- `mobile` varchar(32) DEFAULT NULL COMMENT '手机号码',
- `salt` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '密码盐',
- `password` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '密码',
- `is_edit_password` tinyint(1) DEFAULT '0' COMMENT '是否修改过密码',
- `nickname` varchar(64) DEFAULT NULL COMMENT '昵称',
- `img` varchar(255) DEFAULT NULL COMMENT '头像',
- `num` varchar(64) DEFAULT NULL COMMENT '员工编号',
- `email` varchar(64) DEFAULT NULL COMMENT '邮箱',
- `email_code` varchar(20) DEFAULT NULL COMMENT '邮箱授权码',
- `sex` tinyint(1) DEFAULT NULL COMMENT '1男 2女',
- `department_id` int(11) DEFAULT NULL COMMENT '部门id、',
- `post` varchar(32) DEFAULT NULL COMMENT '岗位',
- `parent_id` int(11) DEFAULT NULL COMMENT '直属上级ID',
- `openid` varchar(64) DEFAULT NULL COMMENT '小程序openid',
- `unionid` varchar(64) DEFAULT NULL COMMENT '微信unionid',
- `wx_openid` varchar(64) DEFAULT NULL COMMENT '微信公众号openid',
- `status` tinyint(1) DEFAULT '1' COMMENT '用户状态 0待审核 1启用 2禁用',
- `touser` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '企业微信touser',
- `createtime` bigint(16) DEFAULT NULL COMMENT '创建时间',
- `updatetime` bigint(16) DEFAULT NULL COMMENT '更新时间',
- `deletetime` bigint(16) DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='员工列表';
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_staff_collect
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_staff_collect`
- (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `staff_id` int(10) DEFAULT NULL COMMENT '销售ID',
- `relation_type` tinyint(2) DEFAULT NULL COMMENT '关联类型 1 客户 2 联系人 3合同',
- `relation_id` int(10) DEFAULT NULL COMMENT '关联ID',
- `createtime` bigint(16) DEFAULT NULL COMMENT '创建时间',
- `updatetime` bigint(16) DEFAULT NULL COMMENT '更新时间',
- `deletetime` bigint(16) DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='重点关注表';
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_staff_department
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_staff_department`
- (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `name` varchar(128) DEFAULT NULL COMMENT '部门名称',
- `pid` int(10) DEFAULT '0' COMMENT '上级ID',
- `type` int(1) NULL DEFAULT 0 COMMENT '0:钉钉 1:微信',
- `number` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '微信唯一编号',
- `status` int(1) NULL DEFAULT 0 COMMENT '0:未同步 1已同步',
- `role_id` int(11) NULL DEFAULT NULL COMMENT '同步ID',
- `createtime` bigint(16) DEFAULT NULL COMMENT '创建时间',
- `updatetime` bigint(16) DEFAULT NULL COMMENT '更新时间',
- `deletetime` bigint(16) DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='员工部门表';
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_staff_email
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_staff_email`
- (
- `id` int(8) NOT NULL AUTO_INCREMENT,
- `send_id` int(8) DEFAULT NULL COMMENT '发件人id',
- `send_name` varchar(50) DEFAULT NULL COMMENT '发件人名字',
- `receiver` varchar(200) DEFAULT NULL COMMENT '收件人账号(多个,隔开)',
- `receive_id` varchar(100) DEFAULT NULL COMMENT '联系人Id(多个,隔开)',
- `copyor` varchar(255) DEFAULT NULL COMMENT '抄送人',
- `theme` varchar(200) DEFAULT NULL COMMENT '主题',
- `content` text COMMENT '发送内容',
- `imgs` text COMMENT '图片',
- `attach` text COMMENT '附件',
- `file_ids` varchar(255) DEFAULT NULL COMMENT '附件ids',
- `is_send` tinyint(1) DEFAULT '1' COMMENT '0草稿箱1已发送',
- `sendtime` datetime DEFAULT NULL COMMENT '发送时间/接受时间',
- `createtime` bigint(16) DEFAULT NULL COMMENT '创建时间',
- `updatetime` bigint(16) DEFAULT NULL COMMENT '更新时间',
- `deletetime` bigint(16) DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COMMENT='邮件接受';
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_staff_receive_email
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_staff_receive_email`
- (
- `id` int(8) NOT NULL AUTO_INCREMENT,
- `uuid` int(20) NOT NULL COMMENT '唯一值',
- `staff_id` int(8) DEFAULT NULL COMMENT '收件人id',
- `staff_name` varchar(50) DEFAULT NULL COMMENT '收件人 名字',
- `from_account` varchar(20) DEFAULT NULL COMMENT '发件账号',
- `from_name` varchar(20) DEFAULT NULL COMMENT '发件人名字',
- `theme` varchar(200) DEFAULT NULL COMMENT '主题',
- `content` text COMMENT '发送内容',
- `imgs` varchar(255) DEFAULT NULL COMMENT '图片',
- `attach` varchar(255) DEFAULT NULL COMMENT '附件(文件/图片)',
- `is_read` tinyint(1) DEFAULT '0' COMMENT '0未读1已读',
- `is_delete` tinyint(1) DEFAULT '0' COMMENT '0正常1删除',
- `receivetime` datetime DEFAULT NULL COMMENT '发送时间',
- `createtime` bigint(16) DEFAULT NULL COMMENT '创建时间',
- `updatetime` bigint(16) DEFAULT NULL COMMENT '更新时间',
- `deletetime` bigint(16) DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='邮件接受';
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_staff_rule
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_staff_rule`
- (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `type` enum('menus','operation','fields','data') COLLATE utf8mb4_unicode_ci DEFAULT 'menus' COMMENT 'menu为菜单,file为权限节点',
- `pid` int(10) unsigned DEFAULT '0' COMMENT '父ID',
- `name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '规则名称',
- `title` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '规则名称',
- `remark` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '备注',
- `weigh` int(10) DEFAULT '0' COMMENT '权重',
- `status` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '状态',
- PRIMARY KEY (`id`) USING BTREE,
- KEY `pid` (`pid`) USING BTREE,
- KEY `weigh` (`weigh`) USING BTREE,
- KEY `name` (`name`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='节点表';
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_staff_sign_in
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_staff_sign_in`
- (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `customer_id` int(10) DEFAULT NULL COMMENT '客户id',
- `customer_status` tinyint(1) DEFAULT NULL COMMENT ' 1 已成交 0未成交',
- `relation_type` varchar(32) DEFAULT NULL COMMENT '关联类型',
- `relation_id` int(11) DEFAULT NULL COMMENT '关联id',
- `relation_process` varchar(64) DEFAULT NULL COMMENT '关联进度',
- `event_id` int(11) DEFAULT NULL COMMENT '日程id',
- `location` varchar(255) DEFAULT NULL COMMENT '地理位置',
- `lng` varchar(32) DEFAULT NULL COMMENT '经度',
- `lat` varchar(32) DEFAULT NULL COMMENT '维度',
- `file_ids` varchar(128) DEFAULT NULL COMMENT '附件',
- `content` text DEFAULT NULL COMMENT '签到详情',
- `staff_id` int(11) DEFAULT NULL COMMENT '创建人',
- `reminds_id` varchar(64) DEFAULT NULL COMMENT '提醒人列表',
- `distance` varchar(32) DEFAULT NULL COMMENT '与客户距离',
- `working_time` int(10) DEFAULT NULL COMMENT '工作时长',
- `trip_distance` int(10) DEFAULT NULL COMMENT '出行距离',
- `other` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
- `next_time` datetime NULL DEFAULT NULL COMMENT '下次跟进时间',
- `createtime` bigint(16) DEFAULT NULL COMMENT '创建时间',
- `updatetime` bigint(16) DEFAULT NULL COMMENT '更新时间',
- `deletetime` bigint(16) DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`) USING BTREE,
- KEY `staff_id_index` (`staff_id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='员工签到';
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_staff_sign_in_read
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_staff_sign_in_read`
- (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `staff_id` int(10) DEFAULT NULL COMMENT '创建人',
- `sign_in_id` int(10) DEFAULT NULL COMMENT '签到ID',
- `createtime` bigint(16) DEFAULT NULL COMMENT '创建时间',
- `updatetime` bigint(16) DEFAULT NULL COMMENT '更新时间',
- `deletetime` bigint(16) DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`) USING BTREE,
- KEY `staff_id` (`staff_id`) USING BTREE,
- KEY `record_id` (`sign_in_id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='签到已读记录';
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_staff_team
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_staff_team`
- (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `name` varchar(128) DEFAULT NULL COMMENT '团队名称',
- `number` tinyint(3) DEFAULT NULL COMMENT '现有人数',
- `staff_id` int(11) DEFAULT NULL COMMENT '团队 负责人',
- `status` tinyint(1) DEFAULT '1' COMMENT '0 停用 1启用',
- `notice_staff_ids` varchar(128) DEFAULT NULL COMMENT '业务通知人',
- `flow` text DEFAULT NULL COMMENT '团队',
- `createtime` bigint(16) DEFAULT NULL COMMENT '创建时间',
- `updatetime` bigint(16) DEFAULT NULL COMMENT '更新时间',
- `deletetime` bigint(16) DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='员工团队';
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_staff_team_list
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_staff_team_list`
- (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `team_id` int(11) DEFAULT NULL COMMENT '团队id',
- `staff_id` int(11) DEFAULT NULL COMMENT '团队成员',
- `createtime` bigint(16) DEFAULT NULL COMMENT '创建时间',
- `updatetime` bigint(16) DEFAULT NULL COMMENT '更新时间',
- `deletetime` bigint(16) DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='员工团队';
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_text_template`
- (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `type` varchar(64) DEFAULT NULL COMMENT '模板 类型',
- `content` text COMMENT '内容',
- `createtime` bigint(16) DEFAULT NULL COMMENT '创建时间',
- `updatetime` bigint(16) DEFAULT NULL COMMENT '更新时间',
- `deletetime` bigint(16) DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='备注模板表';
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_text_template
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_text_template`
- (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `type` varchar(64) DEFAULT NULL COMMENT '模板 类型',
- `content` text COMMENT '内容',
- `createtime` bigint(16) DEFAULT NULL COMMENT '创建时间',
- `updatetime` bigint(16) DEFAULT NULL COMMENT '更新时间',
- `deletetime` bigint(16) DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='备注模板表';
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_work_report
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_work_report`
- (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `staff_id` int(10) DEFAULT NULL COMMENT '员工ID',
- `report_date` date DEFAULT NULL COMMENT '报告时间',
- `type` varchar(32) DEFAULT NULL COMMENT '日 周 月 季 年',
- `follow_up` text DEFAULT NULL COMMENT '跟进次数',
- `customer` text DEFAULT NULL COMMENT '客户',
- `quote` text DEFAULT NULL COMMENT '报价单',
- `visit` text DEFAULT NULL COMMENT '拜访',
- `contract` text DEFAULT NULL COMMENT '合同',
- `order` varchar(255) DEFAULT NULL COMMENT '订单',
- `workorder` text DEFAULT NULL COMMENT '工单',
- `receivables` text DEFAULT NULL COMMENT '回款',
- `complete_workorder` text DEFAULT NULL COMMENT '完成工单数量',
- `good_workorder` text DEFAULT NULL COMMENT '好评工单数量',
- `not_event` text DEFAULT NULL COMMENT '未完成日程',
- `complete_event` text DEFAULT NULL COMMENT '已完成日程',
- `report_data` text DEFAULT NULL COMMENT '报告详情',
- `createtime` bigint(16) DEFAULT NULL COMMENT '创建时间',
- `updatetime` bigint(16) DEFAULT NULL COMMENT '更新时间',
- `deletetime` bigint(16) DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4;
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_workorder
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_workorder`
- (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `customer_id` int(10) DEFAULT NULL COMMENT '客户id',
- `contacts_id` int(10) DEFAULT NULL COMMENT '联系人id',
- `contract_id` int(10) DEFAULT NULL COMMENT '合同id',
- `person_id` int(10) DEFAULT NULL COMMENT '用户端id',
- `status` tinyint(1) DEFAULT '0' COMMENT '工单状态 0待分配 1待处理 2处理中 3已完成 9已取消',
- `process` tinyint(3) DEFAULT '0' COMMENT '进程 0 1备货中 2备货完成 3 到访/录入物流信息 9已送达',
- `is_pause` tinyint(1) DEFAULT NULL COMMENT '暂停工单 0否 1是',
- `is_timeout` tinyint(1) DEFAULT NULL COMMENT '是否超时 0否 1是',
- `is_mobile` tinyint(1) DEFAULT '0' COMMENT '是否 已电话沟通 0否 1是',
- `is_install` tinyint(1) DEFAULT NULL COMMENT '是否安装 0 否 1是',
- `mobile_result` tinyint(3) DEFAULT NULL COMMENT '电话结果 , 1 已解决 11 上门服务 12 返厂维修',
- `logistics_type` varchar(32) DEFAULT NULL COMMENT '返厂运输方式',
- `title` varchar(255) DEFAULT NULL COMMENT '工单标题',
- `address` varchar(64) DEFAULT NULL COMMENT '地址',
- `aftermarket_type_ids` varchar(255) DEFAULT NULL COMMENT '问题分类id列表',
- `workorder_number` varchar(64) DEFAULT NULL COMMENT '工单编号',
- `workorder_type` varchar(255) DEFAULT NULL COMMENT '工单类型 (产品发货 上门安装 上门维修 定期检修 产品设计 生产设备 配件发货 配件安装)',
- `address_detail` varchar(128) DEFAULT NULL COMMENT '详细地址',
- `linkman` varchar(50) DEFAULT NULL COMMENT '联系人',
- `linkfun` varchar(50) DEFAULT NULL COMMENT '联系方式',
- `lng` double(16, 12) DEFAULT NULL COMMENT '地理位置经度',
- `lat` double(16,12) DEFAULT NULL COMMENT '地理位置维度',
- `customer_product_id` text DEFAULT NULL COMMENT '客户已有产品id',
- `product_part` varchar(255) DEFAULT NULL COMMENT '配件',
- `appointment_time` date DEFAULT NULL COMMENT '预约时间',
- `priority` varchar(32) DEFAULT NULL COMMENT '一般 紧急 非常紧急',
- `desc` text DEFAULT NULL COMMENT '情况说明',
- `matters` text DEFAULT NULL COMMENT '注意事项',
- `accept_time` int(11) DEFAULT NULL COMMENT '接受工单时间',
- `expected_end_time` int(11) DEFAULT NULL COMMENT '预计完成时间',
- `start_time` int(11) DEFAULT NULL COMMENT '开始处理时间',
- `stock_up_time` int(11) DEFAULT NULL COMMENT '备货完成时间',
- `end_time` int(11) DEFAULT NULL COMMENT '结束时间',
- `results` text DEFAULT NULL COMMENT '处理结果',
- `parts` text DEFAULT NULL COMMENT '带出零件',
- `use_parts` text DEFAULT NULL COMMENT '使用的零件',
- `surplus_parts` text DEFAULT NULL COMMENT '剩余零件',
- `pay_service` text DEFAULT NULL COMMENT '收费项目列表',
- `total_money` decimal(10,2) DEFAULT NULL COMMENT '总费用',
- `discount_money` decimal(10,2) DEFAULT NULL COMMENT '优惠金额',
- `discount_desc` varchar(255) DEFAULT NULL COMMENT '优惠备注',
- `money` decimal(10,2) DEFAULT NULL COMMENT '收取费用',
- `resolved_results` tinyint(3) DEFAULT NULL COMMENT '上门结果 , 1 已解决 9未解决 12 返厂维修',
- `is_pay` tinyint(1) DEFAULT NULL COMMENT '是否支付 0未支付 1已支付',
- `pay_type` varchar(32) DEFAULT NULL COMMENT '支付方式',
- `pay_files` varchar(64) DEFAULT NULL COMMENT '支付凭证',
- `pay_order` varchar(64) DEFAULT NULL COMMENT '支付订单号',
- `pay_time` int(10) DEFAULT NULL COMMENT '支付时间',
- `is_financial_audit` tinyint(1) DEFAULT '0' COMMENT '财务是否审核 0 未审核 1 已审核 9未收款',
- `is_resolved` tinyint(1) DEFAULT NULL COMMENT '是否解决问题 1是 2否',
- `is_over` tinyint(2) DEFAULT NULL COMMENT ' 是否过保 1 过保 2未过保',
- `comment_score` tinyint(1) DEFAULT NULL COMMENT '评分 1-5',
- `comment_content` text DEFAULT NULL COMMENT '评价内容',
- `comment_files` varchar(32) DEFAULT NULL COMMENT '评论图片',
- `aftermarket_ids` varchar(32) DEFAULT NULL COMMENT '解决方案id',
- `aftermarket_text` text DEFAULT NULL COMMENT '其他方案',
- `create_type` tinyint(1) DEFAULT '1' COMMENT '提出方1员工看create_staff_id 2 联系人看person_id',
- `check_status` tinyint(2) DEFAULT NULL COMMENT '审核费用 0无、1审核中、2审核通过、3审核未通过、4撤销、',
- `flow_staff_ids` varchar(64) DEFAULT NULL COMMENT '流程审批人ID',
- `check_staff_ids` varchar(64) DEFAULT NULL COMMENT '已审批人IDs',
- `create_staff_id` int(10) DEFAULT NULL COMMENT '创建人',
- `owner_staff_id` int(10) DEFAULT NULL COMMENT '负责人',
- `show_staff_id` varchar(255) DEFAULT NULL COMMENT '可查看员工id',
- `relation_workorder_id` int(11) DEFAULT NULL COMMENT '关联工单id',
- `createtime` bigint(16) DEFAULT NULL COMMENT '创建时间',
- `updatetime` bigint(16) DEFAULT NULL COMMENT '更新时间',
- `deletetime` bigint(16) DEFAULT NULL COMMENT '删除时间',
- `car_type` varchar(255) DEFAULT NULL COMMENT '出行工具',
- `car_number` varchar(255) DEFAULT NULL COMMENT '车牌号',
- `start_mileage` varchar(255) DEFAULT NULL COMMENT '起始公里shu',
- `end_mileage` varchar(255) DEFAULT NULL COMMENT '结束公里数',
- `delivery_time` varchar(32) DEFAULT NULL COMMENT '要求交期时间',
- `actual_delivery_time` varchar(32) DEFAULT NULL COMMENT '实际交期时间',
- `delivery_address` varchar(255) DEFAULT NULL COMMENT '交货地点',
- `delivery_address_detail` varchar(255) DEFAULT NULL,
- `remarks` text DEFAULT NULL COMMENT '备注',
- `consignee` varchar(255) DEFAULT NULL COMMENT '收货人',
- `consignee_mobile` varchar(255) DEFAULT NULL COMMENT '收货人联系方式',
- `total` varchar(32) DEFAULT NULL COMMENT '总数',
- `spot_check` varchar(32) DEFAULT NULL COMMENT '抽检数',
- `bad_number` varchar(32) DEFAULT NULL COMMENT '不良数',
- `checkpoint` varchar(255) DEFAULT NULL COMMENT '发现地点',
- `product_name` varchar(255) DEFAULT NULL COMMENT '产品名称',
- `checker_name` varchar(255) DEFAULT NULL COMMENT '检验员',
- `autograph_url` varchar(255) DEFAULT NULL COMMENT '签名图片',
- `is_autograph` tinyint(1) DEFAULT '0' COMMENT '0否 1是 签名',
- `is_replace` tinyint(1) DEFAULT NULL COMMENT '0否 1 更换 ',
- `is_recovery` tinyint(1) DEFAULT NULL COMMENT '0否 1 回收',
- `receipt_file_ids` varchar(64) DEFAULT '' COMMENT '回执单附件',
- `receipt_date` date DEFAULT NULL COMMENT '回执时间',
- `maintain` text DEFAULT NULL COMMENT '保养注意事项',
- `tax` varchar(255) DEFAULT NULL COMMENT '含税情况',
- `train_content` text DEFAULT NULL COMMENT '培训内容',
- `collection_img` varchar(255) DEFAULT NULL COMMENT '收款图片',
- `collection_deposit` varchar(255) DEFAULT NULL COMMENT '收款开户行',
- `collection_account` varchar(255) DEFAULT NULL COMMENT '收款账号',
- `collection_name` varchar(255) DEFAULT NULL COMMENT '收款账户名称',
- `product` text DEFAULT NULL COMMENT '产品',
- `is_visit` tinyint(1) DEFAULT '0' COMMENT '回访 0否 1是',
- `complete_name` varchar(32) DEFAULT NULL COMMENT '完成联系人电话',
- `complete_contact` varchar(64) DEFAULT NULL COMMENT '完成联系人电话',
- `is_charge` tinyint(1) DEFAULT NULL COMMENT '是否收费 1 收费 2不收费',
- `flow_id` int(11) NULL DEFAULT NULL COMMENT '审核流程ID',
- `order_id` int(11) NULL DEFAULT NULL COMMENT '审批流程步骤id',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='售后工单';
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_workorder_file
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_workorder_file`
- (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `workorder_id` int(11) NOT NULL COMMENT '工单ID',
- `file_id` int(11) NOT NULL COMMENT '文件ID',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='其他信息';
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_workorder_logistics
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_workorder_logistics`
- (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `customer_id` int(10) DEFAULT NULL COMMENT '客户ID',
- `workorder_id` int(10) DEFAULT NULL COMMENT '工单id',
- `number` varchar(64) DEFAULT NULL COMMENT '快递编号',
- `type` varchar(32) DEFAULT NULL COMMENT '类型',
- `money` decimal(10, 2) DEFAULT NULL,
- `company` varchar(64) DEFAULT NULL COMMENT '快递公司',
- `status` tinyint(1) DEFAULT '0' COMMENT '快递状态0运输中 1已完成',
- `file_ids` varchar(63) DEFAULT NULL COMMENT '发货图片',
- `current_status` varchar(255) DEFAULT NULL COMMENT '物流当前状态',
- `content` text COMMENT '物流详情',
- `receiver_phone` varchar(255) DEFAULT NULL COMMENT '收手机号',
- `sender_phone` varchar(255) DEFAULT NULL COMMENT '发手机号',
- `create_staff_id` int(10) DEFAULT NULL COMMENT '创建人',
- `createtime` bigint(16) DEFAULT NULL COMMENT '创建时间',
- `updatetime` bigint(16) DEFAULT NULL COMMENT '更新时间',
- `deletetime` bigint(16) DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='工单物流信息';
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_workorder_other
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_workorder_other`
- (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `other` text COMMENT '自定义信息 json',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='其他信息';
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_workorder_progress
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_workorder_progress`
- (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `workorder_id` int(10) DEFAULT NULL COMMENT '工单id',
- `data1` text DEFAULT NULL COMMENT '原因分析',
- `data2` text DEFAULT NULL COMMENT '改善对策',
- `data3` text DEFAULT NULL COMMENT '完成时间',
- `data4` text DEFAULT NULL COMMENT '评估改善结果',
- `data5` text DEFAULT NULL COMMENT '完善制度工艺流程',
- `duty_staff` varchar(64) DEFAULT NULL COMMENT '责任人',
- `analyst_staff` varchar(64) DEFAULT NULL COMMENT '分析人',
- `implementer_staff` varchar(64) DEFAULT NULL COMMENT '实施人',
- `director_staff` varchar(64) DEFAULT NULL COMMENT '主管',
- `create_staff_id` int(10) DEFAULT NULL COMMENT '创建人',
- `createtime` bigint(16) DEFAULT NULL COMMENT '创建时间',
- `updatetime` bigint(16) DEFAULT NULL COMMENT '更新时间',
- `deletetime` bigint(16) DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='品质异常单进度';
- -- ----------------------------
- -- Table structure for __PREFIX__qingdongams_workorder_visit
- -- ----------------------------
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_workorder_visit`
- (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `workorder_id` int(10) DEFAULT NULL COMMENT '工单id',
- `satisfaction` tinyint(2) DEFAULT NULL COMMENT '满意度',
- `visit_time` varchar(32) DEFAULT NULL COMMENT '回访时间',
- `visit_opinion` text DEFAULT NULL COMMENT '回访意见',
- `opinion_score` tinyint(2) DEFAULT NULL COMMENT '意见评分',
- `visit_service` varchar(255) DEFAULT NULL COMMENT '服务态度',
- `service_score` tinyint(2) DEFAULT NULL COMMENT '态度评分',
- `visit_skill` varchar(255) DEFAULT NULL COMMENT '技术水平',
- `visit_desc` text DEFAULT NULL COMMENT '备注',
- `skill_score` tinyint(2) DEFAULT NULL COMMENT '水平评分',
- `createtime` bigint(16) DEFAULT NULL COMMENT '创建时间',
- `updatetime` bigint(16) DEFAULT NULL COMMENT '更新时间',
- `deletetime` bigint(16) DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='品质异常单进度';
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_send_template`
- (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `type` enum('sms','email') DEFAULT NULL COMMENT 'sms 短信 email邮箱',
- `number` varchar(64) DEFAULT NULL COMMENT '短信模板编号',
- `name` varchar(128) DEFAULT NULL COMMENT '模板名称',
- `content` varchar(255) DEFAULT NULL COMMENT '内容',
- `preview` varchar(255) DEFAULT NULL COMMENT '预览内容',
- `createtime` bigint(16) DEFAULT NULL COMMENT '创建时间',
- `updatetime` bigint(16) DEFAULT NULL COMMENT '更新时间',
- `deletetime` bigint(16) DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='短信、邮件发送';
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_attendance` (
- `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
- `staff_id` int(11) DEFAULT NULL COMMENT '员工ID',
- `statisc_id` int(11) DEFAULT NULL COMMENT '统计id',
- `type` int(1) DEFAULT '0' COMMENT '0:上下班打卡 1:外勤',
- `time` varchar(30) DEFAULT NULL COMMENT '打卡时间',
- `address` varchar(150) DEFAULT NULL COMMENT '打卡位置',
- `type_name` int(1) DEFAULT '0' COMMENT '0上班,1下班 2 外勤',
- `late` int(1) DEFAULT '0' COMMENT '迟到0:否 1:是',
- `late_time` int(11) DEFAULT NULL COMMENT '迟到时间(分)',
- `leaver` int(1) DEFAULT '0' COMMENT '早退 0:否 1:是',
- `leaver_time` int(11) DEFAULT NULL COMMENT '早退时间(分)',
- `lng` varchar(50) DEFAULT NULL COMMENT '经度',
- `lat` varchar(50) DEFAULT NULL COMMENT '纬度',
- `start_time` datetime DEFAULT NULL COMMENT '开始时间',
- `end_time` datetime DEFAULT NULL COMMENT '结束时间',
- `status` int(1) DEFAULT '0' COMMENT '是否打卡 0:否 1是',
- `remarks` varchar(255) DEFAULT NULL COMMENT '备注',
- `file_ids` varchar(128) DEFAULT NULL COMMENT '附件',
- `createtime` int(11) DEFAULT NULL COMMENT '创建时间',
- `updatetime` int(11) DEFAULT NULL COMMENT '修改时间',
- `deletetime` int(11) DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_attendance_address` (
- `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
- `address` varchar(200) DEFAULT NULL COMMENT '地点',
- `address_detail` varchar(255) DEFAULT NULL COMMENT '地址',
- `distance` int(10) DEFAULT '0' COMMENT '范围(米)',
- `lng` varchar(50) DEFAULT NULL COMMENT '经度',
- `lat` varchar(50) DEFAULT NULL COMMENT '纬度',
- `createtime` int(11) DEFAULT NULL COMMENT '创建时间',
- `updatetime` int(11) DEFAULT NULL COMMENT '更新时间',
- `deletetime` int(11) DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_attendance_card` (
- `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
- `statisc_id` int(11) DEFAULT NULL COMMENT '考勤ID',
- `type` int(1) DEFAULT '0' COMMENT '0:补卡 1:早退 2:迟到',
- `time` datetime DEFAULT NULL COMMENT '补卡时间',
- `title` varchar(255) DEFAULT NULL COMMENT '补卡原因',
- `remark` varchar(255) DEFAULT NULL COMMENT '补卡事由',
- `file_ids` varchar(255) DEFAULT NULL COMMENT '附件',
- `check_status` int(1) DEFAULT '0' COMMENT '0待审核、1审核中、2审核通过、3审核未通过、4撤销',
- `flow_id` int(11) DEFAULT NULL COMMENT '审核流程ID',
- `order_id` int(11) DEFAULT NULL COMMENT '审批流程步骤id',
- `flow_staff_ids` varchar(255) DEFAULT NULL COMMENT '流程审批人ID',
- `check_staff_ids` varchar(255) DEFAULT NULL COMMENT '已审批人IDs',
- `create_staff_id` int(11) DEFAULT NULL COMMENT '创建人ID',
- `owner_staff_id` int(11) DEFAULT NULL COMMENT '负责人ID',
- `createtime` int(11) DEFAULT NULL COMMENT '创建时间',
- `updatetime` int(11) DEFAULT NULL COMMENT '更新时间',
- `deletetime` int(11) DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`) USING BTREE,
- KEY `attendance_index` (`statisc_id`) USING BTREE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_attendance_leave` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `type` varchar(255) DEFAULT NULL COMMENT '请假类型',
- `start_time` varchar(64) DEFAULT NULL COMMENT '开始时间',
- `end_time` varchar(64) DEFAULT NULL COMMENT '结束时间',
- `hour` varchar(32) DEFAULT NULL COMMENT '时长',
- `remarks` varchar(255) DEFAULT NULL COMMENT '备注',
- `file_ids` varchar(128) DEFAULT NULL COMMENT '附件',
- `create_staff_id` int(11) DEFAULT NULL,
- `createtime` int(11) DEFAULT NULL,
- `updatetime` int(11) DEFAULT NULL,
- `deletetime` int(11) DEFAULT NULL,
- `flow_id` int(11) DEFAULT NULL COMMENT '审核流程ID',
- `order_id` int(11) DEFAULT NULL COMMENT '审批流程步骤id',
- `flow_staff_ids` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '流程审批人ID',
- `check_staff_ids` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '已审批人IDs',
- `check_status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0待审核、1审核中、2审核通过、3审核未通过、4撤销、',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_attendance_rule` (
- `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
- `name` varchar(50) DEFAULT NULL COMMENT '规则名称',
- `staff_id` text COMMENT '员工ID',
- `type` tinyint(1) DEFAULT '0' COMMENT '0:上班 1:外出',
- `createtime` int(11) DEFAULT NULL COMMENT '创建时间',
- `updatetime` int(11) DEFAULT NULL COMMENT '更新时间',
- `deletetime` int(11) DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_attendance_statisc` (
- `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
- `staff_id` int(11) DEFAULT NULL COMMENT '员工ID',
- `number` varchar(32) DEFAULT NULL COMMENT '打卡编码',
- `time` date DEFAULT NULL COMMENT '统计时间',
- `clock_in` datetime DEFAULT NULL COMMENT '上班打卡',
- `clock_in_status` tinyint(2) DEFAULT '0' COMMENT '0 正常 1 缺卡 2 旷工 3 迟到/早退打卡 5 补卡 6请假',
- `late_time` int(11) DEFAULT '0' COMMENT '迟到时间(分)',
- `clock_out` datetime DEFAULT NULL COMMENT '下班打卡',
- `clock_out_status` tinyint(2) DEFAULT '0' COMMENT '0 正常 1 缺卡 2 旷工 3 迟到/早退打卡 5 补卡 6请假',
- `leaver_time` int(11) DEFAULT '0' COMMENT '早退时间(分)',
- `createtime` int(11) DEFAULT NULL COMMENT '创建时间',
- `updatetime` int(11) DEFAULT NULL COMMENT '修改时间',
- `deletetime` int(11) DEFAULT NULL COMMENT '删除时间',
- `start_time` varchar(20) DEFAULT NULL COMMENT '开始时间',
- `end_time` varchar(20) DEFAULT NULL COMMENT '结束时间',
- `ustart_time` varchar(20) DEFAULT NULL COMMENT '可打卡开始时间',
- `uend_time` varchar(20) DEFAULT NULL COMMENT '可打卡结束时间',
- `dstart_time` varchar(20) DEFAULT NULL COMMENT '下班可打卡开始时间',
- `dend_time` varchar(20) DEFAULT NULL COMMENT '下班可打卡结束时间',
- `start_status` tinyint(1) DEFAULT '0' COMMENT '上班打卡0:开启 1:关闭',
- `end_status` tinyint(1) DEFAULT '0' COMMENT '下班打卡0:开启 1:关闭',
- PRIMARY KEY (`id`) USING BTREE,
- KEY `time_index` (`time`) USING BTREE,
- KEY `staff_index` (`staff_id`) USING BTREE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_attendance_time` (
- `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
- `number` varchar(32) DEFAULT NULL COMMENT '编码',
- `start_time` varchar(20) DEFAULT NULL COMMENT '开始时间',
- `end_time` varchar(20) DEFAULT NULL COMMENT '结束时间',
- `ustart_time` varchar(20) DEFAULT NULL COMMENT '可打卡开始时间',
- `uend_time` varchar(20) DEFAULT NULL COMMENT '可打卡结束时间',
- `dstart_time` varchar(20) DEFAULT NULL COMMENT '下班可打卡开始时间',
- `dend_time` varchar(20) DEFAULT NULL COMMENT '下班可打卡结束时间',
- `start_next` int(11) DEFAULT '0' COMMENT '0:非次日 1:次日',
- `end_next` int(11) DEFAULT NULL COMMENT '0:非次日 1:次日',
- `start_status` int(1) DEFAULT '0' COMMENT '上班打卡0:开启 1:关闭',
- `end_status` int(1) DEFAULT '0' COMMENT '下班打卡0:开启 1:关闭',
- `monday` int(1) DEFAULT '0' COMMENT '周一 0未选择 1:已选择',
- `tuesday` int(1) DEFAULT '0' COMMENT '周二 0未选择 1:已选择',
- `wednesday` int(1) DEFAULT '0' COMMENT '周三 0未选择 1:已选择',
- `thursday` int(1) DEFAULT '0' COMMENT '周四 0未选择 1:已选择',
- `friday` int(1) DEFAULT '0' COMMENT '周五 0未选择 1:已选择',
- `saturday` int(1) DEFAULT '0' COMMENT '周六 0未选择 1:已选择',
- `weekday` int(1) DEFAULT '0' COMMENT '周日 0未选择 1:已选择',
- `createtime` int(11) DEFAULT NULL COMMENT '创建时间',
- `updatetime` int(11) DEFAULT NULL COMMENT '更新时间',
- `deletetime` int(11) DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`) USING BTREE,
- KEY `number_index` (`number`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_business` (
- `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
- `customer_id` int(11) NOT NULL COMMENT '客户ID',
- `contract_status` int(1) DEFAULT '0' COMMENT '成交状态 0:未成交 1:成交',
- `name` varchar(80) DEFAULT NULL COMMENT '商机名称',
- `money` varchar(10) DEFAULT NULL COMMENT '商机金额',
- `expect_time` datetime DEFAULT NULL COMMENT '预计成交时间',
- `next_time` datetime DEFAULT NULL COMMENT '下次联系时间',
- `status` varchar(30) DEFAULT '0' COMMENT '状态 验证客户、需求分析 、方案/报价 、赢单 、输单',
- `remark` varchar(255) DEFAULT NULL COMMENT '备注',
- `create_staff_id` int(11) DEFAULT NULL COMMENT '创建人',
- `owner_staff_id` int(11) DEFAULT NULL COMMENT '负责人',
- `createtime` int(11) DEFAULT NULL COMMENT '创建时间',
- `updatetime` int(11) DEFAULT NULL COMMENT '更新时间',
- `deletetime` int(11) DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`) USING BTREE,
- KEY `customer_index` (`customer_id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_business_other` (
- `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '商机id',
- `otherdata` text CHARACTER SET utf8 COMMENT '自定义信息 json',
- `createtime` int(11) DEFAULT NULL COMMENT '创建时间',
- `updatetime` int(11) DEFAULT NULL COMMENT '更新时间',
- `deletetime` int(11) DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4;
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_business_product` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `business_id` int(11) NOT NULL COMMENT '商机id',
- `product_id` int(11) DEFAULT NULL COMMENT '产品id',
- `number` tinyint(5) DEFAULT NULL COMMENT '数量',
- `price` double(10,2) DEFAULT NULL COMMENT '价格',
- `parts` varchar(1000) DEFAULT NULL COMMENT '产品配置',
- `ship_status` tinyint(1) DEFAULT '0' COMMENT '0 待发货 1发货 2已收货',
- `createtime` int(11) DEFAULT NULL COMMENT '创建时间',
- `updatetime` int(11) DEFAULT NULL COMMENT '更新时间',
- `deletetime` int(11) DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_business_status` (
- `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
- `business_id` int(11) DEFAULT NULL COMMENT '商机ID',
- `type` int(1) DEFAULT '0' COMMENT '类型0:初期沟通 1:立项跟踪 2:方案/报价 3:谈判审核4:赢单5:输单 6:无效',
- `file` varchar(255) DEFAULT NULL COMMENT '图片',
- `remark` varchar(255) DEFAULT NULL COMMENT '备注',
- `createtime` int(11) DEFAULT NULL COMMENT '创建时间',
- `updatetime` int(11) DEFAULT NULL COMMENT '更新时间',
- `deletetime` int(11) DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`) USING BTREE,
- KEY `business_id` (`business_id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_contract_ratio` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `contract_id` int(11) NOT NULL COMMENT '合同id',
- `ratio` decimal(10,2) DEFAULT NULL COMMENT '比例',
- `staff_id` int(11) DEFAULT NULL,
- `ratio_money` double(18,2) DEFAULT NULL COMMENT '分成金额',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4;
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_daily_draft` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `type` varchar(20) DEFAULT NULL COMMENT ' 日 周 月 季 年',
- `other` text COMMENT '其他',
- `reminds_id` varchar(255) NOT NULL COMMENT '提醒人员列表',
- `create_staff_id` int(11) NOT NULL COMMENT '创建用户id',
- `createtime` int(11) DEFAULT NULL,
- `updatetime` int(11) DEFAULT NULL,
- `deletetime` int(11) DEFAULT NULL,
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='日报提醒人';
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_ding_contacts` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `type` int(1) DEFAULT '0' COMMENT '0:钉钉 1:微信',
- `instance_id` varchar(64) DEFAULT NULL COMMENT '数据ID',
- `customer_id` int(11) NOT NULL COMMENT '客户ID',
- `name` varchar(64) DEFAULT '' COMMENT '姓名',
- `post` varchar(32) DEFAULT NULL COMMENT '职务',
- `email` varchar(32) DEFAULT NULL COMMENT '邮箱',
- `mobile` varchar(32) DEFAULT NULL COMMENT '手机号',
- `remarks` varchar(255) DEFAULT NULL COMMENT '备注信息',
- `create_staff_id` varchar(50) DEFAULT NULL COMMENT '创建人ID',
- `owner_staff_id` varchar(50) DEFAULT NULL COMMENT '负责人ID',
- `status` int(1) DEFAULT '0' COMMENT '0:未同步 1:已同步',
- `createtime` int(11) DEFAULT NULL COMMENT '创建时间',
- `updatetime` int(11) DEFAULT NULL COMMENT '修改时间',
- `deletetime` int(11) DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`) USING BTREE,
- KEY `customer_id_index` (`customer_id`) USING BTREE,
- KEY `mobile` (`mobile`) USING BTREE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_ding_customer` (
- `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
- `type` int(1) DEFAULT '0' COMMENT '0:钉钉 1:微信',
- `customer_id` int(11) DEFAULT NULL COMMENT 'CRM客户ID',
- `instance_id` varchar(64) DEFAULT NULL COMMENT '数据ID',
- `user_id` varchar(100) DEFAULT NULL COMMENT '用户ID',
- `name` varchar(100) DEFAULT NULL COMMENT '客户名称',
- `address` varchar(100) DEFAULT NULL COMMENT '地址',
- `address_detail` varchar(100) DEFAULT NULL COMMENT '详细地址',
- `source` varchar(50) DEFAULT NULL COMMENT '来源',
- `remark` varchar(255) DEFAULT NULL COMMENT '备注',
- `owner_staff_id` varchar(100) DEFAULT NULL COMMENT '负责人',
- `create_staff_id` varchar(100) DEFAULT NULL COMMENT '创建人',
- `status` int(1) DEFAULT '0' COMMENT '0:未同步 1:已同步',
- `createtime` int(11) DEFAULT NULL COMMENT '创建时间',
- `updatetime` int(11) DEFAULT NULL COMMENT '更新时间',
- `deletetime` int(11) DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`) USING BTREE,
- KEY `user_id` (`user_id`) USING BTREE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_ding_record` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `type` int(1) DEFAULT '0' COMMENT '0:钉钉 1:微信',
- `instance_id` varchar(64) CHARACTER SET utf8 DEFAULT NULL COMMENT '数据ID',
- `customer_id` int(11) DEFAULT NULL COMMENT '客户ID',
- `content` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '跟进内容',
- `create_staff_id` varchar(64) DEFAULT NULL COMMENT '创建用户id',
- `status` int(1) DEFAULT '0' COMMENT '0:未同步 1:已同步',
- `createtime` int(11) DEFAULT NULL COMMENT '创建时间',
- `updatetime` int(11) DEFAULT NULL COMMENT '更新时间',
- `deletetime` int(11) DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`) USING BTREE,
- KEY `instance_index` (`instance_id`) USING BTREE,
- KEY `customer_index` (`customer_id`) USING BTREE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_ding_staff` (
- `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
- `type` int(1) DEFAULT '0' COMMENT '0:钉钉 1:企业微信 ',
- `staff_id` int(11) DEFAULT NULL COMMENT '员工ID',
- `dept_id` int(11) DEFAULT NULL COMMENT '部门ID',
- `user_id` varchar(100) DEFAULT NULL COMMENT '钉钉用户ID',
- `name` varchar(30) DEFAULT NULL COMMENT '姓名',
- `mobile` varchar(12) DEFAULT NULL,
- `status` tinyint(1) DEFAULT '0' COMMENT '0:未同步 1:已同步',
- `createtime` int(11) DEFAULT NULL COMMENT '创建时间',
- `updatetime` int(11) DEFAULT NULL COMMENT '更新时间',
- `deletetime` int(11) DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`) USING BTREE,
- KEY `dept_index` (`dept_id`) USING BTREE,
- KEY `user_id` (`user_id`) USING BTREE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_fauser` (
- `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
- `user_id` int(11) NOT NULL COMMENT 'fast用户ID',
- `staff_id` int(11) DEFAULT NULL COMMENT '员工ID',
- `relation_id` int(11) DEFAULT NULL COMMENT '关联ID',
- `type` tinyint(1) DEFAULT '0' COMMENT '0:客户 1:线索',
- `status` tinyint(1) DEFAULT '0' COMMENT '0:未同步 1同步',
- `createtime` int(11) DEFAULT NULL COMMENT '创建时间',
- `updatetime` int(11) DEFAULT NULL COMMENT '更新时间',
- `deletetime` int(11) DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`) USING BTREE,
- KEY `user_index` (`user_id`) USING BTREE,
- KEY `status_index` (`status`) USING BTREE,
- KEY `type_index` (`type`) USING BTREE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_form_field` (
- `id` int(10) NOT NULL AUTO_INCREMENT,
- `types` varchar(30) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '分类',
- `types_id` int(11) NOT NULL DEFAULT '0' COMMENT '分类ID(审批等)',
- `field` varchar(50) CHARACTER SET utf8mb4 NOT NULL COMMENT '字段名',
- `name` varchar(50) CHARACTER SET utf8mb4 NOT NULL COMMENT '标识名',
- `form_type` varchar(20) CHARACTER SET utf8mb4 NOT NULL COMMENT '字段类型',
- `info_type` varchar(128) CHARACTER SET utf8mb4 DEFAULT 'main' COMMENT '信息类型',
- `default_value` varchar(255) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '默认值',
- `max_length` int(4) DEFAULT '0' COMMENT '字数上限',
- `is_unique` tinyint(1) DEFAULT '0' COMMENT '是否唯一(1是,0否)',
- `is_null` tinyint(1) DEFAULT '0' COMMENT '是否必填(1是,0否)',
- `list_show` tinyint(1) DEFAULT '1' COMMENT '列表显示(1是,0否)',
- `add_show` tinyint(1) DEFAULT '1' COMMENT '添加显示(1是,0否)',
- `input_tips` varchar(100) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '输入提示',
- `setting` text CHARACTER SET utf8mb4 COMMENT '设置',
- `order_id` int(4) NOT NULL DEFAULT '0' COMMENT '排序ID',
- `operating` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0改删,1改,2删,3无',
- `createtime` int(11) NOT NULL COMMENT '创建时间',
- `updatetime` int(11) DEFAULT NULL COMMENT '更新时间',
- `deletetime` int(11) DEFAULT NULL,
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='自定义字段';
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_goods` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `type_id` int(11) DEFAULT NULL COMMENT '分类ID',
- `name` varchar(128) NOT NULL DEFAULT '' COMMENT '产品名称',
- `unit` varchar(128) DEFAULT '箱' COMMENT '单位',
- `price` decimal(18,2) DEFAULT '0.00' COMMENT '价格',
- `min_price` decimal(10,2) DEFAULT '0.00' COMMENT '最低销售价',
- `cost_price` decimal(10,2) DEFAULT NULL COMMENT '成本价',
- `wholesale` decimal(10,2) DEFAULT NULL COMMENT '批发价',
- `status` varchar(32) NOT NULL DEFAULT '上架' COMMENT '是否上架',
- `description` text COMMENT '产品描述',
- `createtime` int(11) DEFAULT NULL COMMENT '创建时间',
- `updatetime` int(11) DEFAULT NULL COMMENT '更新时间',
- `deletetime` int(10) DEFAULT NULL COMMENT '删除时间',
- `specs_type` int(11) DEFAULT '0' COMMENT '是否启用规格 1:启用',
- `specs_id` int(11) DEFAULT NULL COMMENT '规格',
- `image` varchar(255) DEFAULT NULL COMMENT '图片',
- `content` text COMMENT '商品详情',
- `num` varchar(64) DEFAULT NULL COMMENT '编号',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='商品';
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_goods_unit` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `name` varchar(128) NOT NULL DEFAULT '' COMMENT '名称',
- `sort` int(10) DEFAULT '0' COMMENT '权重',
- `status` tinyint(1) DEFAULT '1' COMMENT '状态 0:隐藏 1:显示',
- `createtime` int(11) DEFAULT NULL COMMENT '创建时间',
- `updatetime` int(11) DEFAULT NULL COMMENT '更新时间',
- `deletetime` int(10) DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='商品单位';
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_product_part` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `product_id` int(11) DEFAULT NULL,
- `name` varchar(128) NOT NULL DEFAULT '' COMMENT '产品名称',
- `img` varchar(200) DEFAULT NULL COMMENT '产品图片',
- `description` text COMMENT '产品描述',
- `createtime` int(11) DEFAULT NULL COMMENT '创建时间',
- `updatetime` int(11) DEFAULT NULL COMMENT '更新时间',
- `deletetime` int(10) DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='产品配件';
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_record` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `follow_type` varchar(32) CHARACTER SET utf8 DEFAULT NULL COMMENT '跟进类型',
- `follow_time` datetime DEFAULT NULL,
- `follow` varchar(32) CHARACTER SET utf8 DEFAULT NULL COMMENT '跟进状态',
- `content` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '跟进内容',
- `reminds_id` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '提醒人员列表',
- `next_time` datetime DEFAULT NULL COMMENT '下次跟进时间',
- `relation_type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '关联类型 1客户 2联系人 3合同 4线索 5商机',
- `relation_id` int(11) NOT NULL DEFAULT '0' COMMENT '关联ID',
- `create_staff_id` int(11) DEFAULT '0' COMMENT '创建用户id',
- `status` int(1) DEFAULT '0' COMMENT '跟进状态 0:未跟进 1:已跟进',
- `createtime` int(11) DEFAULT NULL,
- `updatetime` int(11) DEFAULT NULL,
- `deletetime` int(11) DEFAULT NULL,
- `location` varchar(128) CHARACTER SET utf8 DEFAULT NULL COMMENT '定位信息',
- `lng` double(16,12) DEFAULT NULL COMMENT '地理位置经度',
- `lat` double(16,12) DEFAULT NULL COMMENT '地理位置维度',
- `staff_id` int(11) NULL COMMENT '创建人',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8mb4 COMMENT='操作记录';
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_record_file` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `record_id` int(11) DEFAULT NULL COMMENT '日志ID',
- `file_id` int(11) DEFAULT NULL COMMENT '附件ID',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COMMENT='跟进附件';
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_record_read` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `admin_id` int(11) DEFAULT NULL,
- `staff_id` int(11) DEFAULT NULL,
- `record_id` int(11) DEFAULT NULL,
- `createtime` int(11) DEFAULT NULL,
- `updatetime` int(11) DEFAULT NULL,
- PRIMARY KEY (`id`) USING BTREE,
- KEY `staff_id` (`staff_id`) USING BTREE,
- KEY `record_id` (`record_id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8mb4 COMMENT='跟进已读';
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_remind` (
- `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
- `type` varchar(32) DEFAULT 'customer' COMMENT 'customer:客户 record:跟进记录 approval:工作报告',
- `staff_ids` varchar(255) DEFAULT NULL COMMENT '员工ID',
- `remark` varchar(255) DEFAULT NULL COMMENT '备注',
- `createtime` int(11) DEFAULT NULL COMMENT '创建时间',
- `updatetime` int(11) DEFAULT NULL COMMENT '更新时间',
- `deletetime` int(11) DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='跟进提醒';
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_seas_type` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `name` varchar(128) DEFAULT NULL COMMENT '部门名称',
- `remarks` varchar(255) DEFAULT NULL COMMENT '备注',
- `rules` text COMMENT '权限',
- `createtime` int(11) DEFAULT NULL,
- `updatetime` int(11) DEFAULT NULL,
- `deletetime` int(11) DEFAULT NULL,
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_specs` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `pid` int(11) DEFAULT NULL COMMENT '上级',
- `name` varchar(128) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '规格名称',
- `content` text CHARACTER SET utf8 COMMENT '详情',
- `status` tinyint(1) DEFAULT NULL COMMENT '状态 1启用 0',
- `createtime` int(11) DEFAULT NULL COMMENT '创建时间',
- `updatetime` int(11) DEFAULT NULL COMMENT '更新时间',
- `deletetime` int(10) DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='商品规格';
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_staff_ratio` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `name` varchar(255) DEFAULT NULL COMMENT '名称',
- `ratio` text COMMENT '比例',
- `status` tinyint(1) DEFAULT '0',
- `createtime` int(11) DEFAULT NULL,
- `updatetime` int(11) DEFAULT NULL,
- `deletetime` int(11) DEFAULT NULL,
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='业绩比例';
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_staff_role` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `name` varchar(128) DEFAULT NULL COMMENT '角色名称',
- `role_type` tinyint(1) DEFAULT NULL COMMENT '角色权限',
- `rules` text CHARACTER SET utf8mb4,
- `createtime` int(11) DEFAULT NULL,
- `updatetime` int(11) DEFAULT NULL,
- `deletetime` int(11) DEFAULT NULL,
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='员工角色';
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_word_template` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `type` varchar(32) DEFAULT NULL COMMENT '类型',
- `name` varchar(128) DEFAULT NULL COMMENT '模板名称',
- `url` varchar(255) DEFAULT NULL COMMENT '模板地址',
- `createtime` int(11) DEFAULT NULL,
- `updatetime` int(11) DEFAULT NULL,
- `deletetime` int(10) DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='word模板';
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_sea_operation` (
- `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
- `customer_id` int(11) DEFAULT NULL COMMENT '客户ID',
- `type` tinyint(1) DEFAULT '0' COMMENT '类型:0领取 1回收',
- `owner_staff_id` int(11) DEFAULT NULL COMMENT '负责人',
- `createtime` int(11) DEFAULT NULL COMMENT '创建时间',
- `updatetime` int(11) DEFAULT NULL COMMENT '更新时间',
- `deletetime` int(11) DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`),
- KEY `customer_index` (`customer_id`) USING BTREE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='客户公海记录';
- ALTER TABLE `__PREFIX__qingdongams_achievement_records`
- ADD COLUMN `flow_id` int(11) NULL COMMENT '审核流程ID' AFTER `flow_staff_ids`,
- ADD COLUMN `order_id` int(11) NULL COMMENT '审批流程步骤id' AFTER `flow_id`,
- ADD COLUMN `owner_staff_id` int(11) NULL DEFAULT NULL COMMENT '负责人id' AFTER `check_staff_ids`;
- ALTER TABLE `__PREFIX__qingdongams_comment`
- ADD COLUMN `operator` int(11) NULL DEFAULT NULL COMMENT '审核人' AFTER `ip`,
- ADD COLUMN `checktime` datetime NULL DEFAULT NULL COMMENT '审核时间' AFTER `operator`;
- ALTER TABLE `__PREFIX__qingdongams_consume`
- ADD COLUMN `consume_time` date NULL DEFAULT NULL COMMENT '消费日期' AFTER `customer_id`,
- ADD COLUMN `consume_type` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '消费方式' AFTER `consume_time`,
- ADD COLUMN `flow_staff_ids` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '流程审批人ID' AFTER `check_status`,
- ADD COLUMN `flow_id` int(11) NULL DEFAULT NULL COMMENT '审核流程ID' AFTER `flow_staff_ids`,
- ADD COLUMN `order_id` int(11) NULL DEFAULT NULL COMMENT '审批流程步骤id' AFTER `flow_id`,
- ADD COLUMN `file_ids` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '附件ID' AFTER `remark`;
- ALTER TABLE `__PREFIX__qingdongams_contract`
- ADD COLUMN `business_id` int(11) NULL DEFAULT NULL COMMENT '商机ID' AFTER `order_staff_id`,
- ADD COLUMN `flow_id` int(11) NULL DEFAULT NULL COMMENT '审核流程ID' AFTER `remarks`,
- ADD COLUMN `order_id` int(11) NULL DEFAULT NULL COMMENT '审批流程步骤id' AFTER `flow_id`,
- ADD COLUMN `ratio_id` int(11) NULL DEFAULT NULL COMMENT '绩效ID' AFTER `order_id`,
- ADD COLUMN `ratios` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '业绩比例' AFTER `ratio_id`;
- ALTER TABLE `__PREFIX__qingdongams_contract_product`
- ADD COLUMN `parts` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '产品配置' AFTER `price`,
- ADD COLUMN `ship_status` tinyint(1) NULL DEFAULT 0 COMMENT '0 待发货 1发货 2已收货' AFTER `parts`;
- ALTER TABLE `__PREFIX__qingdongams_customer`
- ADD COLUMN `seas_id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '所属公海' AFTER `type`,
- ADD COLUMN `sea_time` int(11) NULL DEFAULT NULL COMMENT '放入公海时间' AFTER `seas_id`,
- ADD COLUMN `mobile` varchar(15) DEFAULT NULL COMMENT '手机号' AFTER `sea_time`,
- ADD COLUMN `ro_staff_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '只读权限' AFTER `owner_staff_id`,
- ADD COLUMN `rw_staff_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '读写权限' AFTER `ro_staff_id`;
- ALTER TABLE `__PREFIX__qingdongams_event`
- ADD COLUMN `auto_end` tinyint(1) NOT NULL DEFAULT 1 COMMENT '自动结束 0否 1是' AFTER `car_number`,
- ADD COLUMN `owner_staff_id` int(11) NOT NULL DEFAULT 0 COMMENT '指派人' AFTER `auto_end`;
- ALTER TABLE `__PREFIX__qingdongams_field`
- ADD COLUMN `name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL AFTER `type`,
- ADD COLUMN `data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL AFTER `name`;
- ALTER TABLE `__PREFIX__qingdongams_flow`
- ADD COLUMN `status` tinyint(1) NULL DEFAULT NULL COMMENT '1 固定审批 0 授权审批' AFTER `examine_ids`,
- ADD COLUMN `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注' AFTER `status`,
- ADD COLUMN `relation_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '关联类型' AFTER `remark`,
- ADD COLUMN `group_ids` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '关联角色组' AFTER `relation_type`,
- ADD COLUMN `weight` tinyint(4) NULL DEFAULT NULL COMMENT '权重' AFTER `group_ids`,
- ADD COLUMN `last_modified` int(11) NULL DEFAULT NULL COMMENT '最后修改时间' AFTER `weight`,
- ADD COLUMN `last_admin_id` int(11) NULL DEFAULT NULL COMMENT '最后修改人' AFTER `type`;
- ALTER TABLE `__PREFIX__qingdongams_form_approval`
- ADD COLUMN `examine_ids` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '默认审核人id' AFTER `flow_staff_ids`,
- ADD COLUMN `status` tinyint(1) NULL DEFAULT NULL COMMENT '1 固定审批 0 授权审批' AFTER `examine_ids`;
- ALTER TABLE `__PREFIX__qingdongams_leads`
- ADD COLUMN `tranfer_stff_id` int(10) NULL DEFAULT NULL COMMENT '转派人ID' AFTER `follow`,
- ADD COLUMN `receive_time` int(11) NULL DEFAULT NULL COMMENT '分配时间' AFTER `tranfer_stff_id`;
- ALTER TABLE `__PREFIX__qingdongams_notice_template`
- ADD COLUMN `enterprise_data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '企业微信' AFTER `data`;
- ALTER TABLE `__PREFIX__qingdongams_order`
- ADD COLUMN `is_account` tinyint(1) NULL DEFAULT 0 COMMENT '是否已到账' AFTER `show_staff_id`;
- ALTER TABLE `__PREFIX__qingdongams_parts_stock_reload`
- ADD COLUMN `flow_id` int(11) NULL DEFAULT NULL COMMENT '审核流程ID' AFTER `check_staff_ids`,
- ADD COLUMN `order_id` int(11) NULL DEFAULT NULL COMMENT '审批流程步骤id' AFTER `flow_id`;
- ALTER TABLE `__PREFIX__qingdongams_product`
- ADD COLUMN `goods_id` int(11) NULL DEFAULT NULL COMMENT '商品ID' AFTER `content`,
- ADD COLUMN `type` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '规格' AFTER `goods_id`,
- ADD COLUMN `min_price` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '最低销售价' AFTER `type`,
- ADD COLUMN `cost_price` decimal(10, 2) NULL DEFAULT NULL COMMENT '成本价' AFTER `min_price`,
- ADD COLUMN `wholesale` decimal(10, 2) NULL DEFAULT NULL COMMENT '批发价' AFTER `cost_price`;
- ALTER TABLE `__PREFIX__qingdongams_product_type`
- ADD COLUMN `image` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '分类图片' AFTER `create_staff_id`,
- ADD COLUMN `content` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '内容' AFTER `image`,
- ADD COLUMN `status` tinyint(1) NULL DEFAULT NULL COMMENT '状态' AFTER `content`;
- ALTER TABLE `__PREFIX__qingdongams_quote`
- ADD COLUMN `flow_id` int(11) NULL DEFAULT NULL COMMENT '审核流程ID' AFTER `product_type`,
- ADD COLUMN `order_id` int(11) NULL DEFAULT NULL COMMENT '审批流程步骤id' AFTER `flow_id`,
- ADD COLUMN `ro_staff_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '只读权限' AFTER `order_id`,
- ADD COLUMN `rw_staff_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '读写权限' AFTER `ro_staff_id`;
- ALTER TABLE `__PREFIX__qingdongams_receivables`
- ADD COLUMN `flow_id` int(11) NULL DEFAULT NULL COMMENT '审核流程ID' AFTER `owner_staff_id`,
- ADD COLUMN `order_id` int(11) NULL DEFAULT NULL COMMENT '审批流程步骤id' AFTER `flow_id`;
- ALTER TABLE `__PREFIX__qingdongams_staff`
- ADD COLUMN `touser` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '企业微信touser' AFTER `status`;
- ALTER TABLE `__PREFIX__qingdongams_staff_department`
- ADD COLUMN `type` int(1) NULL DEFAULT 0 COMMENT '0:钉钉 1:微信' AFTER `pid`,
- ADD COLUMN `number` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '微信唯一编号' AFTER `type`,
- ADD COLUMN `status` int(1) NULL DEFAULT 0 COMMENT '0:未同步 1已同步' AFTER `number`,
- ADD COLUMN `role_id` int(11) NULL DEFAULT NULL COMMENT '同步ID' AFTER `status`;
- ALTER TABLE `__PREFIX__qingdongams_staff_sign_in`
- ADD COLUMN `other` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL AFTER `trip_distance`,
- ADD COLUMN `next_time` datetime NULL DEFAULT NULL COMMENT '下次跟进时间' AFTER `other`;
- ALTER TABLE `__PREFIX__qingdongams_workorder`
- ADD COLUMN `flow_id` int(11) NULL DEFAULT NULL COMMENT '审核流程ID' AFTER `is_charge`,
- ADD COLUMN `order_id` int(11) NULL DEFAULT NULL COMMENT '审批流程步骤id' AFTER `flow_id`;
- ALTER TABLE `__PREFIX__qingdongams_contract_other`
- CHANGE COLUMN `other` `otherdata` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '自定义信息 json' AFTER `id`;
- ALTER TABLE `__PREFIX__qingdongams_contacts_other`
- CHANGE COLUMN `other` `otherdata` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '自定义信息 json' AFTER `id`;
- ALTER TABLE `__PREFIX__qingdongams_customer_other`
- CHANGE COLUMN `other` `otherdata` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '自定义信息 json' AFTER `id`;
- ALTER TABLE `__PREFIX__qingdongams_leads_other`
- CHANGE COLUMN `other` `otherdata` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '自定义信息 json' AFTER `id`;
- ALTER TABLE `__PREFIX__qingdongams_receivables_other`
- CHANGE COLUMN `other` `otherdata` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '自定义信息 json' AFTER `id`;
- ALTER TABLE `__PREFIX__qingdongams_approval`
- ADD COLUMN `file_ids` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '附件' AFTER `create_staff_id`,
- ADD COLUMN `flow_id` int(11) NULL DEFAULT NULL COMMENT '审核流程ID' AFTER `file_ids`,
- ADD COLUMN `order_id` int(11) NULL DEFAULT NULL COMMENT '审批流程步骤id' AFTER `flow_id`;
- ALTER TABLE `__PREFIX__qingdongams_record`
- ADD COLUMN `staff_id` int(11) NULL COMMENT '创建人' AFTER `lat`;
- ALTER TABLE `__PREFIX__qingdongams_ding_staff`
- MODIFY COLUMN `user_id` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '钉钉用户ID' AFTER `dept_id`;
- ALTER TABLE `__PREFIX__qingdongams_ding_customer`
- MODIFY COLUMN `user_id` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户ID' AFTER `instance_id`,
- MODIFY COLUMN `owner_staff_id` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '负责人' AFTER `remark`,
- MODIFY COLUMN `create_staff_id` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人' AFTER `owner_staff_id`;
- ALTER TABLE `__PREFIX__qingdongams_ding_contacts`
- MODIFY COLUMN `create_staff_id` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人ID' AFTER `remarks`,
- MODIFY COLUMN `owner_staff_id` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '负责人ID' AFTER `create_staff_id`;
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_notice_read` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `staff_id` int(11) DEFAULT NULL COMMENT '员工ID',
- `notice_id` int(11) DEFAULT NULL COMMENT '公告ID',
- `createtime` int(11) DEFAULT NULL COMMENT '创建时间',
- `updatetime` int(11) DEFAULT NULL COMMENT '修改时间',
- `deletetime` int(11) DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`) USING BTREE,
- KEY `staff_id` (`staff_id`) USING BTREE,
- KEY `notice_id` (`notice_id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='公告已读记录';
- CREATE TABLE IF NOT EXISTS `__PREFIX__qingdongams_invoice` (
- `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
- `number` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '发票编号',
- `customer_id` int(11) NULL DEFAULT NULL COMMENT '客户ID',
- `contract_id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '合同ID',
- `money` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '开票金额',
- `time` datetime(0) NULL DEFAULT NULL COMMENT '开票日期',
- `type` int(2) NULL DEFAULT 0 COMMENT '开票类型:0:增值税专用发票 1:增值税普通发票 2:国税通用机打发票 3:地税通用机打发票 4:收据',
- `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
- `head_type` int(1) NULL DEFAULT 0 COMMENT '抬头类型0:单位 1:个人',
- `invoice_header` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '发票抬头',
- `taxpayer_number` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '纳税人识别号',
- `bank_deposit` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '开户行',
- `bank_account` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '开户账户',
- `invoice_address` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '开票地址',
- `invoice_mobile` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '电话',
- `contacts` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联系人',
- `phone` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联系方式',
- `address` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮寄地址',
- `address_detail` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '详细地址',
- `flow_id` int(11) NULL DEFAULT NULL COMMENT '审核流程ID',
- `order_id` int(11) NULL DEFAULT NULL COMMENT '审批流程步骤id',
- `flow_staff_ids` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '流程审批人ID',
- `check_staff_ids` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '已审批人IDs',
- `create_staff_id` int(11) NULL DEFAULT NULL COMMENT '创建人',
- `owner_staff_id` int(11) NULL DEFAULT NULL COMMENT '负责人',
- `check_status` int(2) NULL DEFAULT NULL COMMENT '审核状态:0待审核、1审核中、2审核通过、3审核未通过、4撤销',
- `invoice_number` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '发票号码',
- `invoice_time` date NULL DEFAULT NULL COMMENT '实际开票日期',
- `logistics` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '物流单号',
- `image` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '凭证',
- `createtime` int(11) NULL DEFAULT NULL COMMENT '创建时间',
- `updatetime` int(11) NULL DEFAULT NULL COMMENT '更新时间',
- `deletetime` int(11) NULL DEFAULT NULL COMMENT '删除时间',
- PRIMARY KEY (`id`) USING BTREE,
- INDEX `customer_index`(`customer_id`) USING BTREE,
- INDEX `contract_index`(`contract_id`) USING BTREE,
- INDEX `number_index`(`number`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT= '发票';
- ALTER TABLE `__PREFIX__qingdongams_push_reload`
- MODIFY COLUMN `data` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '数据' AFTER `template_id`;
- INSERT INTO `__PREFIX__qingdongams_staff_rule`(`id`, `type`, `pid`, `name`, `title`, `remark`, `weigh`, `status`) VALUES (1, 'menus', 0, 'menu', '小程序菜单权限', '', 0, '');
- INSERT INTO `__PREFIX__qingdongams_staff_rule`(`id`, `type`, `pid`, `name`, `title`, `remark`, `weigh`, `status`) VALUES (3, 'menus', 1, 'seas', '公海', '', 0, '');
- INSERT INTO `__PREFIX__qingdongams_staff_rule`(`id`, `type`, `pid`, `name`, `title`, `remark`, `weigh`, `status`) VALUES (4, 'menus', 1, 'leads', '线索', '', 0, '');
- INSERT INTO `__PREFIX__qingdongams_staff_rule`(`id`, `type`, `pid`, `name`, `title`, `remark`, `weigh`, `status`) VALUES (5, 'menus', 1, 'business', '商机', '', 0, '');
- INSERT INTO `__PREFIX__qingdongams_staff_rule`(`id`, `type`, `pid`, `name`, `title`, `remark`, `weigh`, `status`) VALUES (6, 'menus', 1, 'leadspool', '线索池', '', 0, '');
- INSERT INTO `__PREFIX__qingdongams_staff_rule`(`id`, `type`, `pid`, `name`, `title`, `remark`, `weigh`, `status`) VALUES (7, 'menus', 1, 'attendance', '打卡', '', 0, '');
- INSERT INTO `__PREFIX__qingdongams_staff_rule`(`id`, `type`, `pid`, `name`, `title`, `remark`, `weigh`, `status`) VALUES (8, 'menus', 1, 'quote', '报价单', '', 0, '');
- INSERT INTO `__PREFIX__qingdongams_staff_rule`(`id`, `type`, `pid`, `name`, `title`, `remark`, `weigh`, `status`) VALUES (9, 'menus', 1, 'order', '订单', '', 0, '');
- INSERT INTO `__PREFIX__qingdongams_staff_rule`(`id`, `type`, `pid`, `name`, `title`, `remark`, `weigh`, `status`) VALUES (10, 'menus', 1, 'visit', '回访', '', 0, '');
- INSERT INTO `__PREFIX__qingdongams_staff_rule`(`id`, `type`, `pid`, `name`, `title`, `remark`, `weigh`, `status`) VALUES (11, 'menus', 1, 'product', '产品', '', 0, '');
- INSERT INTO `__PREFIX__qingdongams_staff_rule`(`id`, `type`, `pid`, `name`, `title`, `remark`, `weigh`, `status`) VALUES (12, 'menus', 1, 'parts', '库存', '', 0, '');
- INSERT INTO `__PREFIX__qingdongams_staff_rule`(`id`, `type`, `pid`, `name`, `title`, `remark`, `weigh`, `status`) VALUES (13, 'menus', 1, 'achievement', '目标', '', 0, '');
- INSERT INTO `__PREFIX__qingdongams_staff_rule`(`id`, `type`, `pid`, `name`, `title`, `remark`, `weigh`, `status`) VALUES (14, 'menus', 1, 'consume', '费用', '', 0, '');
- INSERT INTO `__PREFIX__qingdongams_staff_rule`(`id`, `type`, `pid`, `name`, `title`, `remark`, `weigh`, `status`) VALUES (15, 'menus', 1, 'cashier', '出纳', '', 0, '');
- INSERT INTO `__PREFIX__qingdongams_staff_rule`(`id`, `type`, `pid`, `name`, `title`, `remark`, `weigh`, `status`) VALUES (16, 'menus', 1, 'receivables', '收款', '', 0, '');
- INSERT INTO `__PREFIX__qingdongams_staff_rule`(`id`, `type`, `pid`, `name`, `title`, `remark`, `weigh`, `status`) VALUES (17, 'menus', 1, 'aftermarket', '知识库', '', 0, '');
- INSERT INTO `__PREFIX__qingdongams_staff_rule`(`id`, `type`, `pid`, `name`, `title`, `remark`, `weigh`, `status`) VALUES (18, 'menus', 1, 'work_report', '日志', '', 0, '');
- INSERT INTO `__PREFIX__qingdongams_staff_rule`(`id`, `type`, `pid`, `name`, `title`, `remark`, `weigh`, `status`) VALUES (19, 'menus', 1, 'map', '地图', '', 0, '');
- INSERT INTO `__PREFIX__qingdongams_staff_rule`(`id`, `type`, `pid`, `name`, `title`, `remark`, `weigh`, `status`) VALUES (20, 'menus', 1, 'daily', '工作报告', '', 0, '');
- INSERT INTO `__PREFIX__qingdongams_staff_rule`(`id`, `type`, `pid`, `name`, `title`, `remark`, `weigh`, `status`) VALUES (21, 'menus', 1, 'contract', '合同', '', 0, '');
- INSERT INTO `__PREFIX__qingdongams_staff_rule`(`id`, `type`, `pid`, `name`, `title`, `remark`, `weigh`, `status`) VALUES (22, 'menus', 1, 'workorder', '工单', '', 0, '');
- INSERT INTO `__PREFIX__qingdongams_staff_rule`(`id`, `type`, `pid`, `name`, `title`, `remark`, `weigh`, `status`) VALUES (23, 'menus', 1, 'event', '任务', '', 0, '');
- INSERT INTO `__PREFIX__qingdongams_staff_rule`(`id`, `type`, `pid`, `name`, `title`, `remark`, `weigh`, `status`) VALUES (24, 'menus', 1, 'approval', '办公', '', 0, '');
- INSERT INTO `__PREFIX__qingdongams_staff_rule`(`id`, `type`, `pid`, `name`, `title`, `remark`, `weigh`, `status`) VALUES (26, 'menus', 1, 'staff_list', '员工列表', '', 0, '');
- INSERT INTO `__PREFIX__qingdongams_staff_rule`(`id`, `type`, `pid`, `name`, `title`, `remark`, `weigh`, `status`) VALUES (30, 'menus', 1, 'statistics', '数据统计', '', 0, '');
- INSERT INTO `__PREFIX__qingdongams_staff_rule`(`id`, `type`, `pid`, `name`, `title`, `remark`, `weigh`, `status`) VALUES (31, 'menus', 1, 'sign_in', '出差签到', '', 0, '');
- INSERT INTO `__PREFIX__qingdongams_staff_rule`(`id`, `type`, `pid`, `name`, `title`, `remark`, `weigh`, `status`) VALUES (32, 'menus', 0, 'seas', '公海权限', '', 1, '');
- INSERT INTO `__PREFIX__qingdongams_staff_rule`(`id`, `type`, `pid`, `name`, `title`, `remark`, `weigh`, `status`) VALUES (33, 'data', 32, '1', '默认公海', '', 0, '');
- INSERT INTO `__PREFIX__qingdongams_staff_rule`(`id`, `type`, `pid`, `name`, `title`, `remark`, `weigh`, `status`) VALUES (34, 'menus', 1, 'invoice', '发票', '', 0, '');
- INSERT INTO `__PREFIX__qingdongams_text_template` VALUES (1, '任务内容', '[{\"field\":\"客户服务_上门_认识\"},{\"field\":\"客户服务_上门_报价\"},{\"field\":\"客户服务_上门_签合同\"},{\"field\":\"客户服务_上门_收款\"},{\"field\":\"售后服务_上门_上门安装\"},{\"field\":\"售后服务_上门_上门维修\"},{\"field\":\"售后服务_电话\"},{\"field\":\"售后服务_返厂维修\"},{\"field\":\"设计工单\"}]', 1626236423, 1646985836, NULL);
- INSERT INTO `__PREFIX__qingdongams_text_template` VALUES (2, '任务备注', '[{\"field\":\"任务1\"},{\"field\":\"内容3\"},{\"field\":\"内容34\"},{\"field\":\"内容55\"}]', 1626236423, 1645870896, NULL);
- INSERT INTO `__PREFIX__qingdongams_text_template` VALUES (3, '回款备注', '[{\"field\":\"任务1\"},{\"field\":\"内容3\"},{\"field\":\"内容34\"}]', 1626236423, NULL, NULL);
- INSERT INTO `__PREFIX__qingdongams_text_template` VALUES (4, '服务费用', '[{\"field\":\"安装费\"},{\"field\":\"服务费\"}]', 1627095896, 1640338731, NULL);
- INSERT INTO `__PREFIX__qingdongams_text_template` VALUES (5, '任务目的', '[{\"field\":\"认识下\"},{\"field\":\"打样\"},{\"field\":\"报价\"},{\"field\":\"签合同\"},{\"field\":\"要尾款\"}]', 1634027949, 1634027949, NULL);
- INSERT INTO `__PREFIX__qingdongams_text_template` VALUES (6, '返厂服务费用', '[{\"field\":\"维修费\"}]', 1634028003, 1641196693, NULL);
- INSERT INTO `__PREFIX__qingdongams_text_template` VALUES (7, '费用主题', '[{\"field\":\"费用1\"},{\"field\":\"费用2\"}]', 1634030533, 1634030533, NULL);
- INSERT INTO `__PREFIX__qingdongams_text_template` VALUES (9, '客户需求', '[{\"field\":\"客户需求1\"},{\"field\":\"客户需求2\"},{\"field\":\"客户需求4\"},{\"field\":\"客户需求6\"}]', 1638443105, 1638443105, NULL);
- INSERT INTO `__PREFIX__qingdongams_text_template` VALUES (10, '安装未完成原因', '[{\"field\":\"安装未完成原因1\"},{\"field\":\"安装未完成原因2\"},{\"field\":\"安装未完成原因4\"}]', 1638497576, 1638497576, NULL);
- INSERT INTO `__PREFIX__qingdongams_text_template` VALUES (11, '级别变更原因', '[{\"field\":\"联系不上\"},{\"field\":\"有意向\"},{\"field\":\"签合同\"}]', 1639188604, 1639188604, NULL);
- INSERT INTO `__PREFIX__qingdongams_text_template` VALUES (12, '工单标题', '[{\"field\":\"安装\"},{\"field\":\"喷胶机\"},{\"field\":\"等离子\"},{\"field\":\"热胶机\"},{\"field\":\"刮胶机\"},{\"field\":\"平台\"},{\"field\":\"贴头\"}]', 1641553341, 1641553341, NULL);
- INSERT INTO `__PREFIX__qingdongams_text_template` VALUES (13, '工单类型', '[{\"field\":\"设计工单\"},{\"field\":\"生产工单\"},{\"field\":\"产品发货\"},{\"field\":\"上门安装\"},{\"field\":\"配件配送\"},{\"field\":\"配件安装\"},{\"field\":\"上门维修\"},{\"field\":\"返厂维修\"},{\"field\":\"品质异常单\"},{\"field\":\"电话售后\"}]', 1642123485, 1645166553, NULL);
- INSERT INTO `__PREFIX__qingdongams_form` VALUES (11, '线索管理', 'leads', '{\"data\":[{\"id\":\"name\",\"name\":\"单行输入框\",\"type\":1,\"component\":\"input\",\"config\":{\"type\":\"text\",\"label\":\"线索名称\",\"readonly\":false,\"placeholder\":\"线索名称\",\"required\":true,\"is_delete\":false}},{\"id\":\"source\",\"name\":\"下拉选择框\",\"type\":1,\"component\":\"select\",\"config\":{\"label\":\"线索来源\",\"type\":null,\"content\":[{\"key\":\"\",\"value\":\"电话营销\",\"nodeKey\":1,\"isEdit\":false,\"label\":\"电话营销\",\"children\":[],\"expand\":true,\"__label\":\"电话营销\",\"__value\":[\"电话营销\"]},{\"key\":\"\",\"value\":\"主动来电\",\"__label\":\"拜访\",\"__value\":[\"主动来电\"],\"nodeKey\":2,\"isEdit\":false,\"label\":\"拜访\"}],\"required\":true,\"multiple\":false,\"is_delete\":false,\"placeholder\":\"请选择线索来源\"}},{\"id\":\"industry\",\"name\":\"下拉选择框\",\"type\":1,\"component\":\"select\",\"config\":{\"label\":\"客户行业\",\"type\":null,\"content\":[{\"key\":\"\",\"value\":\"行业1\",\"__label\":\"互联网\",\"__value\":[\"行业1\"],\"nodeKey\":1,\"isEdit\":false,\"label\":\"互联网\"},{\"key\":\"\",\"value\":\"行业2\",\"__value\":[\"行业2\"],\"nodeKey\":2,\"isEdit\":false,\"label\":\"信息化\",\"__label\":\"信息化\"}],\"required\":true,\"multiple\":false,\"is_delete\":true,\"placeholder\":\"请选择客户行业\"}},{\"id\":\"mobile\",\"name\":\"单行输入框\",\"type\":1,\"component\":\"input\",\"config\":{\"type\":\"text\",\"label\":\"手机号\",\"readonly\":false,\"placeholder\":\"手机号\",\"required\":true,\"is_delete\":false}},{\"id\":\"level\",\"name\":\"评分\",\"type\":1,\"component\":\"Rate\",\"config\":{\"label\":\"客户级别\",\"allowHalf\":true,\"disabled\":false,\"type\":\"default\",\"is_delete\":true}},{\"id\":\"telephone\",\"name\":\"单行输入框\",\"type\":1,\"component\":\"input\",\"config\":{\"type\":\"text\",\"label\":\"电话\",\"readonly\":false,\"placeholder\":\"电话\",\"required\":false,\"is_delete\":true}},{\"id\":\"address_detail\",\"name\":\"文本框\",\"type\":1,\"component\":\"textarea\",\"config\":{\"label\":\"地址\",\"readonly\":false,\"row\":2,\"placeholder\":\"请输入地址\",\"required\":false,\"is_delete\":true}},{\"id\":\"next_time\",\"name\":\"时间选择框\",\"type\":1,\"component\":\"TimePicker\",\"config\":{\"label\":\"下次联系时间\",\"placeholder\":\"点击选择\",\"type\":\"time\",\"format\":\"YYYY-MM-DD HH:mm:ss\",\"confirm\":true,\"required\":false,\"readonly\":false,\"is_delete\":true}},{\"id\":\"remarks\",\"name\":\"文本框\",\"type\":1,\"component\":\"textarea\",\"config\":{\"label\":\"备注信息\",\"readonly\":false,\"row\":2,\"placeholder\":\"备注信息\",\"required\":false,\"is_delete\":true}}]}', 1619592288, 1655433791, NULL);
- INSERT INTO `__PREFIX__qingdongams_form`
- VALUES (12, '客户管理', 'customer', '{\"data\":[{\"id\":\"name\",\"name\":\"单行输入框\",\"type\":1,\"component\":\"input\",\"config\":{\"type\":\"text\",\"label\":\"客户名称\",\"readonly\":false,\"placeholder\":\"请输入客户名称\",\"required\":true,\"is_delete\":false}},{\"id\":\"subname\",\"name\":\"单行输入框\",\"type\":1,\"component\":\"input\",\"config\":{\"type\":\"text\",\"label\":\"助记名称\",\"readonly\":false,\"placeholder\":\"请输入助记名称\",\"required\":false,\"is_delete\":true}},{\"id\":\"mobile\",\"name\":\"数字框\",\"type\":1,\"value\":\"\",\"component\":\"input\",\"config\":{\"label\":\"手机号\",\"placeholder\":\"请输入手机号\",\"required\":true,\"is_delete\":false,\"value\":\"\",\"infoType\":\"main\",\"only\":false,\"listShow\":false,\"addShow\":false}},{\"id\":\"industry\",\"name\":\"下拉选择框\",\"type\":1,\"component\":\"select\",\"config\":{\"label\":\"客户所属\",\"type\":null,\"content\":[{\"key\":\"\",\"value\":\"终端客户\",\"__label\":\"重点客户\",\"__value\":[\"终端客户\"],\"nodeKey\":1,\"isEdit\":false,\"label\":\"重点客户\"},{\"key\":\"\",\"value\":\"代理商\",\"__label\":\"普通客户\",\"__value\":[\"代理商\"],\"nodeKey\":2,\"isEdit\":false,\"label\":\"普通客户\"},{\"key\":\"\",\"value\":\"同行\",\"__value\":[\"同行\"],\"nodeKey\":3,\"isEdit\":false,\"label\":\"非优先客户\",\"__label\":\"非优先客户\"}],\"required\":true,\"multiple\":false,\"is_delete\":false,\"placeholder\":\"请输入客户所属\"}},{\"id\":\"follow\",\"name\":\"下拉选择框\",\"type\":1,\"component\":\"select\",\"config\":{\"label\":\"客户状态\",\"type\":null,\"content\":[{\"key\":\"\",\"value\":\"初次接触\",\"__label\":\"初次接触\",\"__value\":[\"初次接触\"],\"nodeKey\":1,\"isEdit\":false,\"label\":\"初次接触\"},{\"key\":\"\",\"value\":\"正在跟进\",\"__label\":\"正在跟进\",\"__value\":[\"正在跟进\"],\"nodeKey\":2,\"isEdit\":false,\"label\":\"正在跟进\"},{\"key\":\"\",\"value\":\"准备购买\",\"__label\":\"准备购买\",\"__value\":[\"准备购买\"],\"nodeKey\":3,\"isEdit\":false,\"label\":\"准备购买\"},{\"key\":\"\",\"value\":\"准备付款\",\"__label\":\"准备付款\",\"__value\":[\"准备付款\"],\"nodeKey\":4,\"isEdit\":false,\"label\":\"准备付款\"},{\"key\":\"\",\"value\":\"已经购买\",\"__label\":\"已经购买\",\"__value\":[\"已经购买\"],\"nodeKey\":5,\"isEdit\":false,\"label\":\"已经购买\"},{\"key\":\"\",\"value\":\"暂时搁置\",\"__label\":\"暂时搁置\",\"__value\":[\"暂时搁置\"],\"nodeKey\":6,\"isEdit\":false,\"label\":\"暂时搁置\"}],\"required\":true,\"multiple\":false,\"is_delete\":false,\"placeholder\":\"请输入客户状态\"}},{\"id\":\"level\",\"name\":\"评分\",\"type\":1,\"component\":\"Rate\",\"config\":{\"label\":\"客户星级\",\"allowHalf\":true,\"disabled\":false,\"type\":\"default\",\"is_delete\":true,\"placeholder\":\"客户星级\"}},{\"id\":\"source\",\"name\":\"下拉选择框\",\"type\":1,\"component\":\"select\",\"config\":{\"label\":\"客户来源\",\"type\":null,\"content\":[{\"key\":\"\",\"value\":\"行业活动\",\"__label\":\"行业活动\",\"__value\":[\"行业活动\"],\"nodeKey\":1,\"isEdit\":false,\"label\":\"行业活动\"},{\"key\":\"\",\"value\":\"搜索引擎\",\"__label\":\"搜索引擎\",\"__value\":[\"搜索引擎\"],\"nodeKey\":2,\"isEdit\":false,\"label\":\"搜索引擎\"},{\"key\":\"\",\"value\":\"客户转介绍\",\"__label\":\"客户转介绍\",\"__value\":[\"客户转介绍\"],\"nodeKey\":3,\"isEdit\":false,\"label\":\"客户转介绍\"},{\"key\":\"\",\"value\":\"展会\",\"__label\":\"展会\",\"__value\":[\"展会\"],\"nodeKey\":4,\"isEdit\":false,\"label\":\"展会\"},{\"key\":\"\",\"value\":\"朋友介绍\",\"__label\":\"朋友介绍\",\"__value\":[\"朋友介绍\"],\"nodeKey\":5,\"isEdit\":false,\"label\":\"朋友介绍\"},{\"key\":\"\",\"value\":\"市场推广\",\"__value\":[\"市场推广\"],\"nodeKey\":6,\"isEdit\":false,\"label\":\"市场推广\",\"__label\":\"市场推广\"}],\"required\":true,\"multiple\":false,\"is_delete\":false,\"placeholder\":\"客户来源\"}},{\"id\":\"other_12771\",\"name\":\"文本框\",\"type\":1,\"component\":\"textarea\",\"config\":{\"label\":\"备注信息\",\"row\":2,\"placeholder\":\"请输入备注信息\",\"required\":false,\"is_delete\":true}}]}', 1619592291, 1665543214, NULL);
- INSERT INTO `__PREFIX__qingdongams_form`
- VALUES (13, '联系人管理', 'contacts',
- '{\"data\":[{\"id\":\"name\",\"name\":\"单行输入框\",\"type\":1,\"component\":\"input\",\"config\":{\"type\":\"text\",\"label\":\"联系人姓名\",\"readonly\":false,\"placeholder\":\"请输入联系人姓名\",\"required\":true,\"is_delete\":false}},{\"id\":\"subname\",\"name\":\"单行输入框\",\"type\":1,\"component\":\"input\",\"config\":{\"type\":\"text\",\"label\":\"尊称\",\"readonly\":false,\"placeholder\":\"请输入尊称\",\"required\":false,\"is_delete\":true}},{\"id\":\"other_21517\",\"name\":\"单行输入框\",\"type\":1,\"component\":\"input\",\"config\":{\"type\":\"text\",\"label\":\"电话\",\"placeholder\":\"请输入联系人电话\",\"required\":false,\"is_delete\":true}},{\"id\":\"mobile\",\"name\":\"单行输入框\",\"type\":1,\"component\":\"input\",\"config\":{\"type\":\"text\",\"label\":\"手机号\",\"placeholder\":\"请输入联系人手机号\",\"required\":true,\"is_delete\":false}},{\"id\":\"role\",\"name\":\"下拉选择框\",\"type\":1,\"component\":\"select\",\"config\":{\"label\":\"角色\",\"type\":null,\"content\":[{\"key\":\"\",\"value\":\"普通员工\",\"__label\":\"普通员工\",\"__value\":[\"普通员工\"],\"nodeKey\":1,\"isEdit\":false,\"label\":\"普通员工\"},{\"key\":\"\",\"value\":\"决策人\",\"__label\":\"决策人\",\"__value\":[\"决策人\"],\"nodeKey\":2,\"isEdit\":false,\"label\":\"决策人\"},{\"key\":\"\",\"value\":\"分项决策人\",\"__label\":\"分项决策人\",\"__value\":[\"分项决策人\"],\"nodeKey\":3,\"isEdit\":false,\"label\":\"分项决策人\"},{\"key\":\"\",\"value\":\"商务决策\",\"__label\":\"商务决策\",\"__value\":[\"商务决策\"],\"nodeKey\":4,\"isEdit\":false,\"label\":\"商务决策\"},{\"key\":\"\",\"value\":\"财务决策\",\"__label\":\"财务决策\",\"__value\":[\"财务决策\"],\"nodeKey\":5,\"isEdit\":false,\"label\":\"财务决策\"},{\"key\":\"\",\"value\":\"使用人\",\"__label\":\"使用人\",\"__value\":[\"使用人\"],\"nodeKey\":6,\"isEdit\":false,\"label\":\"使用人\"},{\"key\":\"\",\"value\":\"意见影响人\",\"__label\":\"意见影响人\",\"__value\":[\"意见影响人\"],\"nodeKey\":7,\"isEdit\":false,\"label\":\"意见影响人\"},{\"key\":\"\",\"value\":\"采购\",\"__label\":\"采购\",\"__value\":[\"采购\"],\"nodeKey\":8,\"isEdit\":false,\"label\":\"采购\"},{\"key\":\"\",\"value\":\"老板\",\"__label\":\"老板\",\"__value\":[\"老板\"],\"nodeKey\":9,\"isEdit\":false,\"label\":\"老板\"},{\"key\":\"\",\"value\":\"股东\",\"__label\":\"股东\",\"__value\":[\"股东\"],\"nodeKey\":10,\"isEdit\":false,\"label\":\"股东\"},{\"key\":\"\",\"value\":\"职业经理人\",\"__value\":[\"职业经理人\"],\"nodeKey\":11,\"isEdit\":false,\"label\":\"职业经理人\",\"__label\":\"职业经理人\"}],\"required\":true,\"multiple\":false,\"is_delete\":true,\"placeholder\":\"请选择角色\"}},{\"id\":\"post\",\"name\":\"单行输入框\",\"type\":1,\"component\":\"input\",\"config\":{\"type\":\"text\",\"label\":\"部门职务\",\"placeholder\":\"请输入部门职务\",\"required\":true,\"is_delete\":true}},{\"id\":\"other_4367\",\"name\":\"日期选择框\",\"type\":1,\"component\":\"DatePicker\",\"config\":{\"label\":\"生日\",\"placeholder\":\"请输入联系人生日\",\"type\":\"date\",\"value\":\"\",\"required\":false,\"is_delete\":true}},{\"id\":\"email\",\"name\":\"单行输入框\",\"type\":1,\"component\":\"input\",\"config\":{\"type\":\"text\",\"label\":\"邮箱\",\"placeholder\":\"请输入邮箱\",\"required\":false,\"is_delete\":true}},{\"id\":\"other_17344\",\"name\":\"单行输入框\",\"type\":1,\"component\":\"input\",\"config\":{\"type\":\"text\",\"label\":\"微信\",\"placeholder\":\"请输入联系人微信\",\"required\":false,\"is_delete\":true}},{\"id\":\"other_23536\",\"name\":\"文本框\",\"type\":1,\"component\":\"textarea\",\"config\":{\"label\":\"备注信息\",\"row\":2,\"placeholder\":\"请输入备注信息\",\"required\":false,\"is_delete\":true}}]}',
- 1619592291, 1643096926, NULL);
- INSERT INTO `__PREFIX__qingdongams_form`
- VALUES (14, '合同管理', 'contract',
- '{\"data\":[{\"id\":\"num\",\"name\":\"单行输入框\",\"type\":1,\"component\":\"input\",\"config\":{\"type\":\"text\",\"label\":\"合同编号\",\"readonly\":false,\"placeholder\":\"输入合同编号\",\"required\":true,\"is_delete\":false}},{\"id\":\"name\",\"name\":\"单行输入框\",\"type\":1,\"component\":\"input\",\"config\":{\"type\":\"text\",\"label\":\"合同名称\",\"readonly\":false,\"placeholder\":\"请输入合同名称\",\"required\":true,\"is_delete\":false}},{\"id\":\"money\",\"name\":\"单行输入框\",\"type\":1,\"component\":\"input\",\"config\":{\"type\":\"text\",\"label\":\"合同金额\",\"readonly\":false,\"placeholder\":\"请输入合同金额\",\"required\":true,\"is_delete\":false}},{\"id\":\"order_date\",\"name\":\"时间选择框\",\"type\":1,\"component\":\"TimePicker\",\"config\":{\"label\":\"签约时间\",\"placeholder\":\"点击选择\",\"type\":\"time\",\"format\":\"HH:mm:ss\",\"confirm\":true,\"required\":true,\"readonly\":false,\"is_delete\":false}},{\"id\":\"start_time\",\"name\":\"日期选择框\",\"type\":1,\"component\":\"DatePicker\",\"config\":{\"label\":\"合同生效时间\",\"placeholder\":\"点击选择\",\"type\":\"date\",\"format\":\"\",\"value\":\"\",\"required\":true,\"readonly\":false,\"is_delete\":false}},{\"id\":\"end_time\",\"name\":\"日期选择框\",\"type\":1,\"component\":\"DatePicker\",\"config\":{\"label\":\"合同线束时间\",\"placeholder\":\"点击选择\",\"type\":\"date\",\"format\":\"\",\"value\":\"\",\"required\":true,\"readonly\":false,\"is_delete\":false}},{\"id\":\"other_47006\",\"name\":\"单选框\",\"type\":1,\"component\":\"radio\",\"config\":{\"label\":\"是否含税\",\"content\":[{\"key\":\"\",\"value\":\"含税\"},{\"key\":\"\",\"value\":\"不含税\"}],\"placeholder\":\"请输入\",\"required\":false,\"is_delete\":true}}]}',
- 1619592291, 1643020154, NULL);
- INSERT INTO `__PREFIX__qingdongams_form`
- VALUES (15, '回款管理', 'examine',
- '{\"data\":[{\"id\":\"number\",\"name\":\"单行输入框\",\"type\":1,\"component\":\"input\",\"config\":{\"type\":\"text\",\"label\":\"回款编号\",\"placeholder\":\"请输入回款编号\",\"required\":true,\"is_delete\":false}},{\"id\":\"return_time\",\"name\":\"日期选择框\",\"type\":1,\"component\":\"DatePicker\",\"config\":{\"label\":\"回款日期\",\"placeholder\":\"点击选择\",\"type\":\"date\",\"value\":\"\",\"required\":true,\"is_delete\":false}},{\"id\":\"money\",\"name\":\"单行输入框\",\"type\":1,\"component\":\"input\",\"config\":{\"type\":\"text\",\"label\":\"回款金额\",\"placeholder\":\"请输入回款金额\",\"required\":true,\"is_delete\":false}},{\"id\":\"return_type\",\"name\":\"下拉选择框\",\"type\":1,\"component\":\"select\",\"config\":{\"label\":\"回款方式\",\"type\":null,\"content\":[{\"key\":\"\",\"value\":\"微信\",\"__label\":\"微信\",\"__value\":[\"微信\"],\"nodeKey\":1,\"isEdit\":false,\"label\":\"微信\"}],\"required\":true,\"is_delete\":true}}]}',
- 1619592291, 1643020163, NULL);
- INSERT INTO `__PREFIX__qingdongams_form` VALUES (16, '日报管理', 'daily', '{\"data\":[{\"id\":\"other_43472\",\"name\":\"文本框\",\"type\":1,\"component\":\"textarea\",\"config\":{\"label\":\"1.1.完成了哪些工作\",\"row\":2,\"placeholder\":\"请输入内容\",\"required\":true,\"is_delete\":true}},{\"id\":\"other_48871\",\"name\":\"文本框\",\"type\":1,\"component\":\"textarea\",\"config\":{\"label\":\"1.2.取得了哪些成绩\",\"row\":2,\"placeholder\":\"请输入内容\",\"required\":true,\"is_delete\":true}},{\"id\":\"other_33048\",\"name\":\"文本框\",\"type\":1,\"component\":\"textarea\",\"config\":{\"label\":\"1.3.当前进展如何\",\"row\":2,\"placeholder\":\"请输入内容\",\"required\":true,\"is_delete\":true}},{\"id\":\"other_82389\",\"name\":\"文本框\",\"type\":1,\"component\":\"textarea\",\"config\":{\"label\":\"1.4.计划实施情况\",\"row\":2,\"placeholder\":\"请输入内容\",\"required\":true,\"is_delete\":true}}]}', 1619491859, 1640141699, NULL);
- INSERT INTO `__PREFIX__qingdongams_form` VALUES (17, '周报管理', 'weekly', '{\"data\":[{\"id\":\"other_72263\",\"name\":\"文本框\",\"type\":1,\"component\":\"textarea\",\"config\":{\"label\":\"1.1.完成了哪些工作\",\"row\":2,\"placeholder\":\"请输入内容\",\"required\":false,\"is_delete\":true}},{\"id\":\"other_22415\",\"name\":\"文本框\",\"type\":1,\"component\":\"textarea\",\"config\":{\"label\":\"1.2.取得了哪些成绩\",\"row\":2,\"placeholder\":\"请输入内容\",\"required\":false,\"is_delete\":true}},{\"id\":\"other_41856\",\"name\":\"文本框\",\"type\":1,\"component\":\"textarea\",\"config\":{\"label\":\"1.3.当前进展如何\",\"row\":2,\"placeholder\":\"请输入内容\",\"required\":false,\"is_delete\":true}}]}', 1643020163, 1643020163, NULL);
- INSERT INTO `__PREFIX__qingdongams_form` VALUES (18, '月报管理', 'monthly', '{\"data\":[{\"id\":\"other_79661\",\"name\":\"文本框\",\"type\":1,\"component\":\"textarea\",\"config\":{\"label\":\"1.1.完成了哪些工作\",\"row\":2,\"placeholder\":\"请输入内容\",\"required\":false,\"is_delete\":true}},{\"id\":\"other_52344\",\"name\":\"文本框\",\"type\":1,\"component\":\"textarea\",\"config\":{\"label\":\"1.2.取得了哪些成绩\",\"row\":2,\"placeholder\":\"请输入内容\",\"required\":false,\"is_delete\":true}},{\"id\":\"other_15457\",\"name\":\"文本框\",\"type\":1,\"component\":\"textarea\",\"config\":{\"label\":\"1.3.当前进展如何\",\"row\":2,\"placeholder\":\"请输入内容\",\"required\":false,\"is_delete\":true}}]}', 1643020163, 1643020163, NULL);
- INSERT INTO `__PREFIX__qingdongams_form` VALUES (19, '季报管理', 'quarterly', '{\"data\":[{\"id\":\"other_43472\",\"name\":\"文本框\",\"type\":1,\"component\":\"textarea\",\"config\":{\"label\":\"1.1.完成了哪些工作\",\"row\":2,\"placeholder\":\"请输入内容\",\"required\":true,\"is_delete\":true}},{\"id\":\"other_48871\",\"name\":\"文本框\",\"type\":1,\"component\":\"textarea\",\"config\":{\"label\":\"1.2.取得了哪些成绩\",\"row\":2,\"placeholder\":\"请输入内容\",\"required\":true,\"is_delete\":true}},{\"id\":\"other_33048\",\"name\":\"文本框\",\"type\":1,\"component\":\"textarea\",\"config\":{\"label\":\"1.3.当前进展如何\",\"row\":2,\"placeholder\":\"请输入内容\",\"required\":true,\"is_delete\":true}},{\"id\":\"other_82389\",\"name\":\"文本框\",\"type\":1,\"component\":\"textarea\",\"config\":{\"label\":\"1.4.计划实施情况\",\"row\":2,\"placeholder\":\"请输入内容\",\"required\":true,\"is_delete\":true}}]}', 1619491859, 1640141727, NULL);
- INSERT INTO `__PREFIX__qingdongams_form` VALUES (20, '年报管理', 'yearly', '{\"data\":[{\"id\":\"other_43472\",\"name\":\"文本框\",\"type\":1,\"component\":\"textarea\",\"config\":{\"label\":\"1.1.完成了哪些工作\",\"row\":2,\"placeholder\":\"请输入内容\",\"required\":true,\"is_delete\":true}},{\"id\":\"other_48871\",\"name\":\"文本框\",\"type\":1,\"component\":\"textarea\",\"config\":{\"label\":\"1.2.取得了哪些成绩\",\"row\":2,\"placeholder\":\"请输入内容\",\"required\":true,\"is_delete\":true}},{\"id\":\"other_33048\",\"name\":\"文本框\",\"type\":1,\"component\":\"textarea\",\"config\":{\"label\":\"1.3.当前进展如何\",\"row\":2,\"placeholder\":\"请输入内容\",\"required\":true,\"is_delete\":true}},{\"id\":\"other_82389\",\"name\":\"文本框\",\"type\":1,\"component\":\"textarea\",\"config\":{\"label\":\"1.4.计划实施情况\",\"row\":2,\"placeholder\":\"请输入内容\",\"required\":true,\"is_delete\":true}},{\"id\":\"other_90392\",\"name\":\"文本框\",\"type\":1,\"component\":\"textarea\",\"config\":{\"label\":\"2.1 面临哪些挑战\",\"row\":2,\"placeholder\":\"请输入内容\",\"required\":false,\"is_delete\":true}},{\"id\":\"other_72126\",\"name\":\"文本框\",\"type\":1,\"component\":\"textarea\",\"config\":{\"label\":\"2.2 什么原因导致的\",\"row\":2,\"placeholder\":\"请输入内容\",\"required\":false,\"is_delete\":true}},{\"id\":\"other_39787\",\"name\":\"文本框\",\"type\":1,\"component\":\"textarea\",\"config\":{\"label\":\"2.3 有何改进措施\",\"row\":2,\"placeholder\":\"请输入内容\",\"required\":true,\"is_delete\":true}},{\"id\":\"other_66752\",\"name\":\"文本框\",\"type\":1,\"component\":\"textarea\",\"config\":{\"label\":\"3.1 节约了哪些成本\",\"row\":2,\"placeholder\":\"请输入内容\",\"required\":false,\"is_delete\":true}},{\"id\":\"other_62312\",\"name\":\"文本框\",\"type\":1,\"component\":\"textarea\",\"config\":{\"label\":\"3.2 提升了哪些效率\",\"row\":2,\"placeholder\":\"请输入内容\",\"required\":false,\"is_delete\":true}},{\"id\":\"other_62889\",\"name\":\"文本框\",\"type\":1,\"component\":\"textarea\",\"config\":{\"label\":\"3.3 优化了哪些步骤\",\"row\":2,\"placeholder\":\"请输入内容\",\"required\":false,\"is_delete\":true}},{\"id\":\"other_98365\",\"name\":\"文本框\",\"type\":1,\"component\":\"textarea\",\"config\":{\"label\":\"3.4 拓宽了哪些渠道\",\"row\":2,\"placeholder\":\"请输入内容\",\"required\":false,\"is_delete\":true}},{\"id\":\"other_80726\",\"name\":\"文本框\",\"type\":1,\"component\":\"textarea\",\"config\":{\"label\":\"4.1 下一步的安排\",\"row\":2,\"placeholder\":\"请输入下一步的安排\",\"required\":false,\"is_delete\":true}},{\"id\":\"other_15038\",\"name\":\"文本框\",\"type\":1,\"component\":\"textarea\",\"config\":{\"label\":\"4.2 需要的资源支持\",\"row\":2,\"placeholder\":\"请输入需要的资源支持\",\"required\":false,\"is_delete\":true}},{\"id\":\"other_970\",\"name\":\"文本框\",\"type\":1,\"component\":\"textarea\",\"config\":{\"label\":\"4.3 预计达到的结果\",\"row\":2,\"placeholder\":\"请输入预计达到的结果\",\"required\":false,\"is_delete\":true}}]}', 1643020163, 1643020163, NULL);
- INSERT INTO `__PREFIX__qingdongams_form` VALUES (21, '外勤签到', 'signin', '{\"data\":[{\"id\":\"other_35260\",\"name\":\"文本框\",\"type\":1,\"component\":\"textarea\",\"config\":{\"label\":\"备注\",\"row\":2,\"placeholder\":\"请输入备注\",\"required\":false,\"is_delete\":true}},{\"id\":\"other_65453\",\"name\":\"图片上传\",\"type\":1,\"component\":\"uploadImage\",\"config\":{\"label\":\"图片上传\",\"value\":[],\"required\":false,\"placeholder\":\"请上传图片\",\"maxnum\":1,\"is_delete\":true,\"format\":[\"jpg\",\"jpeg\",\"png\"],\"maxSize\":5000}}],\"isAddContact\":true}', 1643020163, 1657163099, NULL);
- INSERT INTO `__PREFIX__qingdongams_form` VALUES (22, '商机管理', 'business', '{\"data\":[{\"id\":\"name\",\"name\":\"单行输入框\",\"type\":1,\"component\":\"input\",\"config\":{\"type\":\"text\",\"label\":\"商机名称\",\"readonly\":false,\"placeholder\":\"商机名称\",\"required\":true,\"is_delete\":false}},{\"id\":\"money\",\"name\":\"数字框\",\"type\":1,\"component\":\"input-number\",\"config\":{\"label\":\"商机金额\",\"placeholder\":\"请输入商机金额\",\"required\":true,\"is_delete\":false}},{\"id\":\"expect_time\",\"name\":\"日期选择框\",\"type\":1,\"component\":\"DatePicker\",\"config\":{\"label\":\"预计成交时间\",\"placeholder\":\"请输入预计成交时间\",\"type\":\"date\",\"value\":\"\",\"required\":true,\"is_delete\":true}},{\"id\":\"next_time\",\"name\":\"时间选择框\",\"type\":1,\"component\":\"TimePicker\",\"config\":{\"label\":\"下次跟进时间\",\"placeholder\":\"点击选择\",\"type\":\"time\",\"format\":\"YYYY-MM-DD HH:mm:ss\",\"confirm\":true,\"required\":false,\"readonly\":false,\"is_delete\":true}},{\"id\":\"other_48629\",\"name\":\"图片上传\",\"type\":1,\"component\":\"uploadImage\",\"config\":{\"label\":\"图片上传\",\"value\":[],\"required\":false,\"placeholder\":\"请上传图片\",\"maxnum\":1,\"is_delete\":true,\"format\":[\"jpg\",\"jpeg\",\"png\"],\"maxSize\":5000}},{\"id\":\"remark\",\"name\":\"文本框\",\"type\":1,\"component\":\"textarea\",\"config\":{\"label\":\"备注信息\",\"readonly\":false,\"row\":2,\"placeholder\":\"备注信息\",\"required\":false,\"is_delete\":true}}],\"isAddContact\":true}', 1619592288, 1659082152, NULL);
- INSERT INTO `__PREFIX__qingdongams_flow` (id,name,status,examine_ids,relation_type,last_modified,last_admin_id,createtime,updatetime)
- VALUES (1, '费用', 0, 0,'consume', 1657014906, 1, 1657014906, 1657014906);
- INSERT INTO `__PREFIX__qingdongams_flow` (id,name,status,examine_ids,relation_type,last_modified,last_admin_id,createtime,updatetime)
- VALUES (2, '业绩', 0, 0,'achievement',1657767346, 1, 1657767346, 1657767346);
- INSERT INTO `__PREFIX__qingdongams_flow` (id,name,status,examine_ids,relation_type,last_modified,last_admin_id,createtime,updatetime)
- VALUES (3, '回款', 0, 0,'receivables',1658388920, 1, 1658388920, 1658388920);
- INSERT INTO `__PREFIX__qingdongams_flow` (id,name,status,examine_ids,relation_type,last_modified,last_admin_id,createtime,updatetime)
- VALUES (4, '合同', 0, 0,'contract', 1658388928, 1, 1658388928, 1658388928);
- INSERT INTO `__PREFIX__qingdongams_flow` (id,name,status,examine_ids,relation_type,last_modified,last_admin_id,createtime,updatetime)
- VALUES (5, '补卡', 0, 0,'card',1658388928, 1, 1658388928, 1658388928);
- INSERT INTO `__PREFIX__qingdongams_flow` (id,name,status,examine_ids,relation_type,last_modified,last_admin_id,createtime,updatetime)
- VALUES (6, '请假', 0, 0, 'leave',1658388928, 1, 1658388928, 1658388928);
- INSERT INTO `__PREFIX__qingdongams_flow`(`id`, `name`, `status`, `type`, `examine_ids`, `remark`, `relation_type`, `group_ids`, `weight`, `last_modified`, `last_admin_id`, `createtime`, `updatetime`, `deletetime`)
- VALUES (7, '出入库', 0, NULL, 0, '', 'parts', '', NULL, 1665216023, 1, 1665216023, 1665216023, NULL);
- INSERT INTO `__PREFIX__qingdongams_flow`(`id`, `name`, `status`, `type`, `examine_ids`, `remark`, `relation_type`, `group_ids`, `weight`, `last_modified`, `last_admin_id`, `createtime`, `updatetime`, `deletetime`)
- VALUES (8, '工单', 0, NULL, 0, '', 'workorder', '', NULL, 1665226685, 1, 1665226685, 1665226685, NULL);
- INSERT INTO `__PREFIX__qingdongams_flow`(`id`, `name`, `status`, `type`, `examine_ids`, `remark`, `relation_type`, `group_ids`, `weight`, `last_modified`, `last_admin_id`, `createtime`, `updatetime`, `deletetime`)
- VALUES (9, '报价', 0, NULL, 0, '', 'quote', '', NULL, 1665541798, 1, 1665541798, 1665541798, NULL);
- INSERT INTO `__PREFIX__qingdongams_seas_type` VALUES (1, '默认公海', '客户不满足其他公海规则时,会移入当前公海', NULL, NULL, NULL, NULL);
- INSERT INTO `__PREFIX__qingdongams_field`(`id`, `type`, `name`, `data`, `field`) VALUES (1, 'other', '跟进类型', '[\"到访\",\"电话\",\"微信\",\"签约\",\"邮件\"]', NULL);
- INSERT INTO `__PREFIX__qingdongams_field`(`id`, `type`, `name`, `data`, `field`) VALUES (2, 'other', '消费方式', '[\"吃饭\",\"住酒店\"]', NULL);
- INSERT INTO `__PREFIX__qingdongams_field`(`id`, `type`, `name`, `data`, `field`) VALUES (3, 'examine', '回款方式', '[\"微信\"]', NULL);
- INSERT INTO `__PREFIX__qingdongams_field`(`id`, `type`, `name`, `data`, `field`) VALUES (4, 'contacts', '角色', '[\"普通员工\",\"决策人\",\"分项决策人\",\"商务决策\",\"财务决策\",\"使用人\",\"意见影响人\",\"采购\",\"老板\",\"股东\",\"职业经理人\"]', NULL);
- INSERT INTO `__PREFIX__qingdongams_field`(`id`, `type`, `name`, `data`, `field`) VALUES (5, 'leads', '线索来源', '[\"拜访\",\"上门\"]', NULL);
- INSERT INTO `__PREFIX__qingdongams_field`(`id`, `type`, `name`, `data`, `field`) VALUES (6, 'leads', '客户行业', '[\"互联网\",\"信息化\",\"测试\"]', NULL);
- INSERT INTO `__PREFIX__qingdongams_field`(`id`, `type`, `name`, `data`, `field`) VALUES (7, 'customer', '客户所属', '[\"重点客户\",\"普通客户\",\"非优先客户\"]', NULL);
- INSERT INTO `__PREFIX__qingdongams_field`(`id`, `type`, `name`, `data`, `field`) VALUES (8, 'customer', '客户状态', '[\"初次接触\",\"正在跟进\",\"准备购买\",\"准备付款\",\"已经购买\",\"暂时搁置\"]', NULL);
- INSERT INTO `__PREFIX__qingdongams_field`(`id`, `type`, `name`, `data`, `field`) VALUES (9, 'customer', '客户来源', '[\"行业活动\",\"搜索引擎\",\"客户转介绍\",\"展会\",\"朋友介绍\",\"市场推广\"]', NULL);
- INSERT INTO `__PREFIX__qingdongams_field`(`id`, `type`, `name`, `data`, `field`) VALUES (10, 'business', '商机阶段', '[\"验证客户\",\"需求分析\",\"方案\\/报价\",\"赢单\",\"输单\"]', NULL);
- INSERT INTO `__PREFIX__qingdongams_notice_template`(`id`, `name`, `type`, `data`, `enterprise_data`, `createtime`, `updatetime`, `deletetime`) VALUES (1, '审批通知', 'examine', '{\"template_id\":\"\",\"first\":\"{{staff_name}}发起一个《审批》指定由您处理\",\"keyword1\":\"{{customer_name}}\",\"keyword1_color\":\"#666\",\"keyword2\":\"{{date}}\",\"keyword2_color\":\"#666\",\"keyword3\":\"\",\"keyword3_color\":\"#666\",\"keyword4\":\"\",\"keyword4_color\":\"#666\",\"keyword5\":\"\",\"keyword5_color\":\"#666\",\"remark\":\"请及时处理!\",\"remark_color\":\"#666\"}', NULL, NULL, NULL, NULL);
- INSERT INTO `__PREFIX__qingdongams_notice_template`(`id`, `name`, `type`, `data`, `enterprise_data`, `createtime`, `updatetime`, `deletetime`) VALUES (3, '新建跟进记录通知', 'record', '{\"template_id\":\"\",\"first\":\"{{staff_name}}刚刚新建了一条《跟进记录》指定由您审阅\",\"keyword1\":\"{{customer_name}}\",\"keyword1_color\":\"#666\",\"keyword2\":\"{{customer_follow}}\",\"keyword2_color\":\"#666\",\"keyword3\":\"{{date}}\",\"keyword3_color\":\"#666\",\"keyword4\":\"\",\"keyword4_color\":\"#666\",\"keyword5\":\"\",\"keyword5_color\":\"#666\",\"remark\":\"请及时处理!\",\"remark_color\":\"#666\"}', NULL, NULL, NULL, NULL);
- INSERT INTO `__PREFIX__qingdongams_notice_template`(`id`, `name`, `type`, `data`, `enterprise_data`, `createtime`, `updatetime`, `deletetime`) VALUES (4, '新建工作报告通知', 'daily', '{\"template_id\":\"\",\"first\":\"{{staff_name}}刚刚新建了一条《工作报告》指定由您审阅\",\"keyword1\":\"{{date}}\",\"keyword1_color\":\"#666\",\"keyword2\":\"{{daily_type}}\",\"keyword2_color\":\"#666\",\"keyword3\":\"\",\"keyword3_color\":\"#666\",\"keyword4\":\"\",\"keyword4_color\":\"#666\",\"keyword5\":\"\",\"keyword5_color\":\"#666\",\"remark\":\"\",\"remark_color\":\"#666\"}', NULL, NULL, NULL, NULL);
- INSERT INTO `__PREFIX__qingdongams_notice_template`(`id`, `name`, `type`, `data`, `enterprise_data`, `createtime`, `updatetime`, `deletetime`) VALUES (5, '回收客户到公海通知', 'seas', '{\"template_id\":\"\",\"first\":\"您的客户长时间未跟进,已被系统自动回收到公海池内。\",\"keyword1\":\"{{customer_name}}\",\"keyword1_color\":\"#666\",\"keyword2\":\"{{day}}\",\"keyword2_color\":\"#666\",\"keyword3\":\"{{date}}\",\"keyword3_color\":\"#666\",\"keyword4\":\"\",\"keyword4_color\":\"#666\",\"keyword5\":\"\",\"keyword5_color\":\"#666\",\"remark\":\"建议客户及时跟进!\",\"remark_color\":\"#666\"}', NULL, NULL, NULL, NULL);
- INSERT INTO `__PREFIX__qingdongams_notice_template`(`id`, `name`, `type`, `data`, `enterprise_data`, `createtime`, `updatetime`, `deletetime`) VALUES (7, '审批通过通知', 'examine_adopt', '{\"template_id\":\"\",\"first\":\"您提交的审批已审核通过!\",\"keyword1\":\"{{check_name}}\",\"keyword1_color\":\"#666\",\"keyword2\":\"{{examine_type}}\",\"keyword2_color\":\"#666\",\"keyword3\":\"{{submit_time}}\",\"keyword3_color\":\"#666\",\"keyword4\":\"\",\"keyword4_color\":\"#666\",\"keyword5\":\"\",\"keyword5_color\":\"#666\",\"remark\":\"审核通过!\",\"remark_color\":\"#666\"}', NULL, NULL, NULL, NULL);
- INSERT INTO `__PREFIX__qingdongams_notice_template`(`id`, `name`, `type`, `data`, `enterprise_data`, `createtime`, `updatetime`, `deletetime`) VALUES (8, '审批拒绝通知', 'examine_refuse', '{\"template_id\":\"\",\"first\":\"您提交的审批被拒绝!\",\"keyword1\":\"{{staff_name}}\",\"keyword1_color\":\"#666\",\"keyword2\":\"{{check_name}}\",\"keyword2_color\":\"#666\",\"keyword3\":\"{{check_name}}\",\"keyword3_color\":\"#666\",\"keyword4\":\"{{examine_desc}}\",\"keyword4_color\":\"#666\",\"keyword5\":\"\",\"keyword5_color\":\"#666\",\"remark\":\"审核拒绝!\",\"remark_color\":\"#666\"}', NULL, NULL, NULL, NULL);
- INSERT INTO `__PREFIX__qingdongams_notice_template`(`id`, `name`, `type`, `data`, `enterprise_data`, `createtime`, `updatetime`, `deletetime`) VALUES (9, '合同到期通知', 'contract_expire', '{\"template_id\":\"\",\"first\":\"合同即将到期,请尽快跟进回款\",\"keyword1\":\"{{customer_name}}\",\"keyword1_color\":\"#666\",\"keyword2\":\"{{money}}\",\"keyword2_color\":\"#666\",\"keyword3\":\"{{submit_time}}\",\"keyword3_color\":\"#666\",\"keyword4\":\"\",\"keyword4_color\":\"#666\",\"keyword5\":\"\",\"keyword5_color\":\"#666\",\"remark\":\"请及时跟进!\",\"remark_color\":\"#666\"}', NULL, NULL, NULL, NULL);
- INSERT INTO `__PREFIX__qingdongams_notice_template`(`id`, `name`, `type`, `data`, `enterprise_data`, `createtime`, `updatetime`, `deletetime`) VALUES (10, '回款计划到期通知', 'plan_expire', '{\"template_id\":\"\",\"first\":\"已到计划回款约定时间,请尽快跟进回款\",\"keyword1\":\"{{customer_name}}\",\"keyword1_color\":\"#666\",\"keyword2\":\"{{plan_money}}\",\"keyword2_color\":\"#666\",\"keyword3\":\"{{plan_time}}\",\"keyword3_color\":\"#666\",\"keyword4\":\"\",\"keyword4_color\":\"#666\",\"keyword5\":\"\",\"keyword5_color\":\"#666\",\"remark\":\"请及时跟进!\",\"remark_color\":\"#666\"}', NULL, NULL, NULL, NULL);
- INSERT INTO `__PREFIX__qingdongams_notice_template`(`id`, `name`, `type`, `data`, `enterprise_data`, `createtime`, `updatetime`, `deletetime`) VALUES (11, '评论通知', 'comment', '{\"template_id\":\"\",\"first\":\"评论了您提交的跟进记录!\",\"keyword1\":\"{{staff_name}}\",\"keyword1_color\":\"#666\",\"keyword2\":\"{{content}}\",\"keyword2_color\":\"#666\",\"keyword3\":\"{{date}}\",\"keyword3_color\":\"#666\",\"keyword4\":\"\",\"keyword4_color\":\"#666\",\"keyword5\":\"\",\"keyword5_color\":\"#666\",\"remark\":\"请及时处理!\",\"remark_color\":\"#666\"}', NULL, NULL, NULL, NULL);
- INSERT INTO `__PREFIX__qingdongams_ocr_type`(`id`, `name`, `type`, `action`) VALUES (1, '增值税发票识别', 1, 'vat_invoice');
- INSERT INTO `__PREFIX__qingdongams_ocr_type`(`id`, `name`, `type`, `action`) VALUES (2, '增值税发票验真', 1, 'vat_invoice_verification');
- INSERT INTO `__PREFIX__qingdongams_ocr_type`(`id`, `name`, `type`, `action`) VALUES (3, '定额发票识别', 1, 'quota_invoice');
- INSERT INTO `__PREFIX__qingdongams_ocr_type`(`id`, `name`, `type`, `action`) VALUES (4, '通用机打发票识别', 1, 'invoice');
- INSERT INTO `__PREFIX__qingdongams_ocr_type`(`id`, `name`, `type`, `action`) VALUES (5, '火车票识别', 1, 'train_ticket');
- INSERT INTO `__PREFIX__qingdongams_ocr_type`(`id`, `name`, `type`, `action`) VALUES (6, '出租车票识别', 1, 'taxi_receipt');
- INSERT INTO `__PREFIX__qingdongams_ocr_type`(`id`, `name`, `type`, `action`) VALUES (7, '飞机行程单识别', 1, 'air_ticket');
- INSERT INTO `__PREFIX__qingdongams_ocr_type`(`id`, `name`, `type`, `action`) VALUES (8, '汽车票识别', 1, 'bus_ticket');
- INSERT INTO `__PREFIX__qingdongams_ocr_type`(`id`, `name`, `type`, `action`) VALUES (9, '过路过桥费发票识别', 1, 'toll_invoice');
- INSERT INTO `__PREFIX__qingdongams_ocr_type`(`id`, `name`, `type`, `action`) VALUES (10, '船票识别', 1, 'ferry_ticket');
- INSERT INTO `__PREFIX__qingdongams_ocr_type`(`id`, `name`, `type`, `action`) VALUES (11, '网约车行程单识别', 1, 'online_taxi_itinerary');
- INSERT INTO `__PREFIX__qingdongams_ocr_type`(`id`, `name`, `type`, `action`) VALUES (12, '通用票据识别', 1, 'receipt');
- INSERT INTO `__PREFIX__qingdongams_ocr_type`(`id`, `name`, `type`, `action`) VALUES (13, '车牌识别', 1, 'license_plate');
- INSERT INTO `__PREFIX__qingdongams_ocr_type`(`id`, `name`, `type`, `action`) VALUES (14, '名片识别', 1, 'business_card');
|