structure.sql 100 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834
  1. SET NAMES utf8mb4;
  2. SET FOREIGN_KEY_CHECKS = 0;
  3. -- ----------------------------
  4. -- Table structure for t_achievements
  5. -- ----------------------------
  6. DROP TABLE IF EXISTS `t_achievements`;
  7. CREATE TABLE `t_achievements` (
  8. `achievements_id` int(11) NOT NULL AUTO_INCREMENT,
  9. `total_goal` double(22, 0) NOT NULL,
  10. `no_customer_tag` double(5, 2) NULL DEFAULT 0.00,
  11. `customer_tag` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  12. `ctime` datetime(0) NULL DEFAULT NULL,
  13. `utime` datetime(0) NULL DEFAULT NULL,
  14. `dtime` datetime(0) NULL DEFAULT NULL,
  15. PRIMARY KEY (`achievements_id`) USING BTREE
  16. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  17. -- ----------------------------
  18. -- Table structure for t_achievements_group
  19. -- ----------------------------
  20. DROP TABLE IF EXISTS `t_achievements_group`;
  21. CREATE TABLE `t_achievements_group` (
  22. `achievements_group_id` int(11) NOT NULL AUTO_INCREMENT,
  23. `group_total_goal` double(22, 0) NOT NULL,
  24. `achievements_group_title` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  25. `achievements_group_users` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  26. PRIMARY KEY (`achievements_group_id`) USING BTREE
  27. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  28. -- ----------------------------
  29. -- Table structure for t_affair
  30. -- ----------------------------
  31. DROP TABLE IF EXISTS `t_affair`;
  32. CREATE TABLE `t_affair` (
  33. `affair_id` int(11) NOT NULL AUTO_INCREMENT,
  34. `affair_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  35. `affair_icon` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  36. `affair_tablename` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  37. `affair_is_buildin` tinyint(255) NULL DEFAULT NULL,
  38. `affair_group_id` int(11) NULL DEFAULT NULL,
  39. `version` int(11) NULL DEFAULT NULL,
  40. `lock_time` varchar(25) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  41. `lock_user` int(11) NULL DEFAULT NULL,
  42. PRIMARY KEY (`affair_id`) USING BTREE,
  43. INDEX `affair_group_id`(`affair_group_id`) USING BTREE,
  44. CONSTRAINT `t_affair_ibfk_1` FOREIGN KEY (`affair_group_id`) REFERENCES `t_affair_group` (`affair_group_id`) ON DELETE SET NULL ON UPDATE CASCADE
  45. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;
  46. -- ----------------------------
  47. -- Table structure for t_affair_bar
  48. -- ----------------------------
  49. DROP TABLE IF EXISTS `t_affair_bar`;
  50. CREATE TABLE `t_affair_bar` (
  51. `bar_id` int(11) NOT NULL AUTO_INCREMENT,
  52. `user_id` int(11) NOT NULL,
  53. `affairIds` text CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  54. `utime` datetime(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  55. `affair_category` tinyint(1) NULL DEFAULT 0,
  56. PRIMARY KEY (`bar_id`) USING BTREE,
  57. INDEX `user_id`(`user_id`) USING BTREE,
  58. CONSTRAINT `t_affair_bar_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `t_user` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
  59. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Compact;
  60. -- ----------------------------
  61. -- Table structure for t_affair_calculation
  62. -- ----------------------------
  63. DROP TABLE IF EXISTS `t_affair_calculation`;
  64. CREATE TABLE `t_affair_calculation` (
  65. `calculation_id` int(11) NOT NULL AUTO_INCREMENT,
  66. `affair_id` int(11) NOT NULL,
  67. `calculation_formula` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  68. `calculation_formula_title` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  69. `calculation_result` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',
  70. `calculation_result_title` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',
  71. `calculation_result_accuracy` tinyint(1) NULL DEFAULT 0,
  72. `all_algebras` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  73. `calculation_steps` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL,
  74. PRIMARY KEY (`calculation_id`) USING BTREE,
  75. INDEX `affair_id`(`affair_id`) USING BTREE,
  76. CONSTRAINT `t_affair_calculation_ibfk_1` FOREIGN KEY (`affair_id`) REFERENCES `t_affair` (`affair_id`) ON DELETE CASCADE ON UPDATE CASCADE
  77. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  78. -- ----------------------------
  79. -- Table structure for t_affair_frequently
  80. -- ----------------------------
  81. DROP TABLE IF EXISTS `t_affair_frequently`;
  82. CREATE TABLE `t_affair_frequently` (
  83. `frequently_id` int(11) NOT NULL AUTO_INCREMENT,
  84. `user_id` int(11) NOT NULL,
  85. `affair_id` int(11) NOT NULL,
  86. `ctime` datetime(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  87. PRIMARY KEY (`frequently_id`) USING BTREE,
  88. INDEX `affair_id`(`affair_id`) USING BTREE,
  89. INDEX `user_id`(`user_id`) USING BTREE,
  90. CONSTRAINT `t_affair_frequently_ibfk_1` FOREIGN KEY (`affair_id`) REFERENCES `t_affair` (`affair_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  91. CONSTRAINT `t_affair_frequently_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `t_user` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
  92. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Compact;
  93. -- ----------------------------
  94. -- Table structure for t_affair_group
  95. -- ----------------------------
  96. DROP TABLE IF EXISTS `t_affair_group`;
  97. CREATE TABLE `t_affair_group` (
  98. `affair_group_id` int(11) NOT NULL AUTO_INCREMENT,
  99. `affair_group_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  100. `affair_group_notes` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  101. `status` int(11) NULL DEFAULT 99,
  102. `ctime` datetime(0) NULL DEFAULT NULL,
  103. `utime` datetime(0) NULL DEFAULT NULL,
  104. `dtime` datetime(0) NULL DEFAULT NULL,
  105. PRIMARY KEY (`affair_group_id`) USING BTREE
  106. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  107. -- ----------------------------
  108. -- Table structure for t_affair_modify_record
  109. -- ----------------------------
  110. DROP TABLE IF EXISTS `t_affair_modify_record`;
  111. CREATE TABLE `t_affair_modify_record` (
  112. `record_id` int(11) NOT NULL AUTO_INCREMENT,
  113. `data_id` varchar(25) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  114. `affair_id` int(11) NOT NULL,
  115. `user_id` int(11) NOT NULL,
  116. `record_data` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  117. `ctime` datetime(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  118. `type` tinyint(1) NULL DEFAULT 0,
  119. PRIMARY KEY (`record_id`) USING BTREE,
  120. INDEX `user_id`(`user_id`) USING BTREE,
  121. CONSTRAINT `t_affair_modify_record_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `t_user` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
  122. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Compact;
  123. -- ----------------------------
  124. -- Table structure for t_affair_rule
  125. -- ----------------------------
  126. DROP TABLE IF EXISTS `t_affair_rule`;
  127. CREATE TABLE `t_affair_rule` (
  128. `rule_id` int(11) NOT NULL AUTO_INCREMENT,
  129. `affair_id` int(11) NULL DEFAULT NULL,
  130. `sheet_id` int(11) NULL DEFAULT NULL,
  131. `user_id` int(11) NULL DEFAULT NULL,
  132. `rule_allow_use` tinyint(1) NULL DEFAULT 0,
  133. `rule_allow_view` tinyint(1) NULL DEFAULT 0,
  134. PRIMARY KEY (`rule_id`) USING BTREE,
  135. INDEX `sheet_id`(`sheet_id`) USING BTREE,
  136. CONSTRAINT `t_affair_rule_ibfk_1` FOREIGN KEY (`sheet_id`) REFERENCES `t_affair_sheet` (`sheet_id`) ON DELETE CASCADE ON UPDATE RESTRICT
  137. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;
  138. -- ----------------------------
  139. -- Table structure for t_affair_sheet
  140. -- ----------------------------
  141. DROP TABLE IF EXISTS `t_affair_sheet`;
  142. CREATE TABLE `t_affair_sheet` (
  143. `sheet_id` int(11) NOT NULL AUTO_INCREMENT,
  144. `sheet_prev_id` int(11) NULL DEFAULT NULL,
  145. `sheet_next_id` int(11) NULL DEFAULT NULL,
  146. `affair_id` int(11) NOT NULL,
  147. `sheet_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  148. `sheet_tablename` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  149. `sheet_rule_use_option` tinyint(1) NULL DEFAULT NULL,
  150. `sheet_rule_view_option` tinyint(1) NULL DEFAULT NULL,
  151. `sheet_join_order` tinyint(1) NULL DEFAULT 0,
  152. PRIMARY KEY (`sheet_id`) USING BTREE,
  153. INDEX `affair_id`(`affair_id`) USING BTREE,
  154. CONSTRAINT `t_affair_sheet_ibfk_1` FOREIGN KEY (`affair_id`) REFERENCES `t_affair` (`affair_id`) ON DELETE CASCADE ON UPDATE CASCADE
  155. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;
  156. -- ----------------------------
  157. -- Table structure for t_affair_sheet_column
  158. -- ----------------------------
  159. DROP TABLE IF EXISTS `t_affair_sheet_column`;
  160. CREATE TABLE `t_affair_sheet_column` (
  161. `sheet_column_id` int(11) NOT NULL AUTO_INCREMENT,
  162. `sheet_column_pid` int(11) NULL DEFAULT 0,
  163. `column_id` int(11) NULL DEFAULT NULL,
  164. `sheet_id` int(11) NULL DEFAULT NULL,
  165. `sheet_group_id` int(11) NULL DEFAULT NULL,
  166. `column_is_require` tinyint(1) NULL DEFAULT 0,
  167. `column_is_summary` tinyint(1) NULL DEFAULT 0,
  168. `column_order` int(11) NULL DEFAULT 0,
  169. PRIMARY KEY (`sheet_column_id`) USING BTREE,
  170. INDEX `sheet_id`(`sheet_id`) USING BTREE,
  171. INDEX `system_column_id`(`column_id`) USING BTREE,
  172. CONSTRAINT `t_affair_sheet_column_ibfk_1` FOREIGN KEY (`sheet_id`) REFERENCES `t_affair_sheet` (`sheet_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  173. CONSTRAINT `t_affair_sheet_column_ibfk_2` FOREIGN KEY (`column_id`) REFERENCES `t_affair_system_column` (`column_id`) ON DELETE CASCADE ON UPDATE CASCADE
  174. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;
  175. -- ----------------------------
  176. -- Table structure for t_affair_sheet_column_group
  177. -- ----------------------------
  178. DROP TABLE IF EXISTS `t_affair_sheet_column_group`;
  179. CREATE TABLE `t_affair_sheet_column_group` (
  180. `sheet_group_id` int(11) NOT NULL AUTO_INCREMENT,
  181. `sheet_group_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  182. `sheet_id` int(11) NULL DEFAULT NULL,
  183. PRIMARY KEY (`sheet_group_id`) USING BTREE,
  184. INDEX `sheet_id`(`sheet_id`) USING BTREE,
  185. CONSTRAINT `t_affair_sheet_column_group_ibfk_1` FOREIGN KEY (`sheet_id`) REFERENCES `t_affair_sheet` (`sheet_id`) ON DELETE CASCADE ON UPDATE RESTRICT
  186. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;
  187. -- ----------------------------
  188. -- Table structure for t_affair_system_column
  189. -- ----------------------------
  190. DROP TABLE IF EXISTS `t_affair_system_column`;
  191. CREATE TABLE `t_affair_system_column` (
  192. `column_id` int(11) NOT NULL AUTO_INCREMENT,
  193. `column_pid` int(11) NULL DEFAULT 0,
  194. `group_id` int(11) NULL DEFAULT NULL,
  195. `column_order` int(11) NULL DEFAULT NULL,
  196. `column_title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  197. `column_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  198. `column_unit` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '[]',
  199. `column_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '',
  200. `column_control` tinyint(1) NULL DEFAULT 0,
  201. `column_rule` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  202. `column_is_virtual` tinyint(1) NULL DEFAULT 0,
  203. `column_unit_symbiosis` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  204. `column_detachable` tinyint(1) NULL DEFAULT 0,
  205. `status` tinyint(255) NULL DEFAULT NULL,
  206. PRIMARY KEY (`column_id`) USING BTREE,
  207. INDEX `group_id`(`group_id`) USING BTREE
  208. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;
  209. -- ----------------------------
  210. -- Table structure for t_affair_system_column_group
  211. -- ----------------------------
  212. DROP TABLE IF EXISTS `t_affair_system_column_group`;
  213. CREATE TABLE `t_affair_system_column_group` (
  214. `group_id` int(11) NOT NULL AUTO_INCREMENT,
  215. `group_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  216. PRIMARY KEY (`group_id`) USING BTREE
  217. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;
  218. -- ----------------------------
  219. -- Table structure for t_bill
  220. -- ----------------------------
  221. DROP TABLE IF EXISTS `t_bill`;
  222. CREATE TABLE `t_bill` (
  223. `bill_id` int(11) NOT NULL AUTO_INCREMENT,
  224. `bill_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  225. `bill_number_user_defined` varchar(255) NULL,
  226. `bill_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  227. `bill_desc` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  228. `bill_count` int(11) NULL DEFAULT 0,
  229. `status` int(2) NULL DEFAULT 99,
  230. `ctime` datetime(0) NULL DEFAULT NULL,
  231. `utime` datetime(0) NULL DEFAULT NULL,
  232. `permission` int(1) NULL DEFAULT 1,
  233. `order_data` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  234. `bill_limit` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  235. `bill_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  236. `bill_affair_Ids` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  237. `bill_type` tinyint(1) NULL DEFAULT 0,
  238. `bill_template` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  239. `bill_merge_condition` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',
  240. `bill_set_explain` varchar(255) NULL DEFAULT '0',
  241. PRIMARY KEY (`bill_id`) USING BTREE
  242. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  243. -- ----------------------------
  244. -- Table structure for t_bill_order
  245. -- ----------------------------
  246. DROP TABLE IF EXISTS `t_bill_order`;
  247. CREATE TABLE `t_bill_order` (
  248. `bill_order_id` int(11) NOT NULL AUTO_INCREMENT,
  249. `bill_id` int(11) NULL DEFAULT NULL,
  250. `user_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  251. `bill_order_number` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  252. `bill_order_unit` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  253. `bill_affair_data_Ids` varchar(550) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',
  254. `status` int(2) NULL DEFAULT 99,
  255. `ctime` datetime(0) NULL DEFAULT NULL,
  256. `ptime` datetime(0) NULL DEFAULT NULL,
  257. `bill_data` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  258. `printer_status` int(1) NULL DEFAULT 0,
  259. `bill_order_supplement` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  260. `bill_order_header` varchar(255) NULL,
  261. `bill_explain` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  262. `bill_object` varchar(13) NULL,
  263. `bill_amount` decimal(18, 3) NULL DEFAULT NULL,
  264. `bill_pnames` text NULL,
  265. PRIMARY KEY (`bill_order_id`) USING BTREE,
  266. INDEX `bill_id`(`bill_id`) USING BTREE,
  267. CONSTRAINT `t_bill_order_ibfk_1` FOREIGN KEY (`bill_id`) REFERENCES `t_bill` (`bill_id`) ON DELETE CASCADE ON UPDATE CASCADE
  268. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  269. -- ----------------------------
  270. -- Table structure for t_bill_permission
  271. -- ----------------------------
  272. DROP TABLE IF EXISTS `t_bill_permission`;
  273. CREATE TABLE `t_bill_permission` (
  274. `bill_per_id` int(11) NOT NULL AUTO_INCREMENT,
  275. `bill_id` int(11) NOT NULL,
  276. `user_id` int(11) NOT NULL DEFAULT 0,
  277. PRIMARY KEY (`bill_per_id`) USING BTREE,
  278. INDEX `user_id`(`user_id`) USING BTREE,
  279. INDEX `bill_per_id`(`bill_per_id`) USING BTREE,
  280. INDEX `bill_id`(`bill_id`) USING BTREE,
  281. CONSTRAINT `t_bill_permission_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `t_user` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  282. CONSTRAINT `t_bill_permission_ibfk_3` FOREIGN KEY (`bill_id`) REFERENCES `t_bill` (`bill_id`) ON DELETE CASCADE ON UPDATE CASCADE
  283. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  284. -- ----------------------------
  285. -- Table structure for t_bill_subtitle
  286. -- ----------------------------
  287. DROP TABLE IF EXISTS `t_bill_subtitle`;
  288. CREATE TABLE `t_bill_subtitle` (
  289. `bill_subtitle_id` int(11) NOT NULL AUTO_INCREMENT,
  290. `bill_id` int(11) NOT NULL,
  291. `user_ids` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  292. `bill_subtitle_name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  293. PRIMARY KEY (`bill_subtitle_id`) USING BTREE,
  294. INDEX `bill_id`(`bill_id`) USING BTREE,
  295. CONSTRAINT `t_bill_subtitle_ibfk_2` FOREIGN KEY (`bill_id`) REFERENCES `t_bill` (`bill_id`) ON DELETE CASCADE ON UPDATE CASCADE
  296. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  297. -- ----------------------------
  298. -- Table structure for t_cas_st
  299. -- ----------------------------
  300. DROP TABLE IF EXISTS `t_cas_st`;
  301. CREATE TABLE `t_cas_st` (
  302. `st_id` varchar(23) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  303. `user_id` int(11) NULL DEFAULT NULL,
  304. `tgt_id` varchar(24) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  305. `st_service` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  306. `st_device` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  307. `deviceId` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  308. `deviceToken` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  309. `user_agent` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  310. `st_ip` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  311. `st_last_used` datetime(0) NULL DEFAULT NULL,
  312. `st_use_times` int(11) NULL DEFAULT NULL,
  313. `ctime` datetime(0) NULL DEFAULT NULL,
  314. `utime` datetime(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  315. `dtime` datetime(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  316. `status` int(11) NULL DEFAULT NULL,
  317. PRIMARY KEY (`st_id`) USING BTREE,
  318. INDEX `tgt_id`(`tgt_id`) USING BTREE,
  319. CONSTRAINT `t_cas_st_ibfk_1` FOREIGN KEY (`tgt_id`) REFERENCES `t_cas_tgt` (`tgt_id`) ON DELETE CASCADE ON UPDATE CASCADE
  320. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  321. -- ----------------------------
  322. -- Table structure for t_cas_tgt
  323. -- ----------------------------
  324. DROP TABLE IF EXISTS `t_cas_tgt`;
  325. CREATE TABLE `t_cas_tgt` (
  326. `tgt_id` varchar(24) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  327. `user_id` int(11) NULL DEFAULT NULL,
  328. `tgt_last_used` datetime(0) NULL DEFAULT NULL,
  329. `tgt_use_times` int(11) NULL DEFAULT NULL,
  330. `tgt_platform` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  331. `tgt_kick_step` int(255) NULL DEFAULT NULL,
  332. `ctime` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  333. PRIMARY KEY (`tgt_id`) USING BTREE
  334. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  335. -- ----------------------------
  336. -- Table structure for t_collection
  337. -- ----------------------------
  338. DROP TABLE IF EXISTS `t_collection`;
  339. CREATE TABLE `t_collection` (
  340. `collection_id` int(11) NOT NULL AUTO_INCREMENT,
  341. `user_id` int(11) NULL DEFAULT NULL,
  342. `company_id` int(11) NOT NULL,
  343. `image_id` int(11) NULL DEFAULT NULL,
  344. `product_id` int(11) NULL DEFAULT NULL,
  345. `collection_image_id` int(11) NULL DEFAULT NULL,
  346. `collection_image` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  347. `collection_pname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  348. `collection_cname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  349. `collection_type` tinyint(2) NOT NULL DEFAULT 0,
  350. `collection_state` tinyint(2) NULL DEFAULT 0,
  351. `collection_price` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  352. `collection_price_unit` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  353. `collection_inventory` decimal(13, 3) NULL DEFAULT NULL,
  354. `collection_inventory_unit` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  355. `collection_width` decimal(13, 2) NULL DEFAULT NULL,
  356. `collection_width_unit` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  357. `collection_height` decimal(13, 2) NULL DEFAULT NULL,
  358. `collection_height_unit` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  359. `collection_freeheight` decimal(13, 2) NULL DEFAULT NULL,
  360. `collection_freeheight_unit` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  361. `collection_weight` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  362. `collection_weight_unit` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',
  363. `collection_elasticity` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '',
  364. `collection_mtype` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  365. `collection_material` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  366. `collection_notes` text CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  367. `collection_gram_weight` decimal(13,2) NULL DEFAULT NULL,
  368. `collection_gram_weight_unit` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT 'g/m2',
  369. `collection_tag_ids` text CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  370. `product_cloth_price_unit` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '',
  371. `product_product_price_unit` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '',
  372. `product_cloth_price` decimal(13, 2) NULL DEFAULT NULL,
  373. `product_product_price` decimal(13, 2) NULL DEFAULT NULL,
  374. `push_result` longtext NULL,
  375. `recv_result` longtext NULL,
  376. `ctime` datetime(0) NOT NULL,
  377. `utime` datetime(0) NULL DEFAULT NULL,
  378. `dtime` datetime(0) NULL DEFAULT NULL,
  379. `status` tinyint(2) NOT NULL DEFAULT 99,
  380. PRIMARY KEY (`collection_id`) USING BTREE,
  381. INDEX `image_id`(`image_id`) USING BTREE,
  382. INDEX `user_id`(`user_id`) USING BTREE,
  383. INDEX `company_id`(`company_id`) USING BTREE,
  384. FULLTEXT INDEX `collection_pname`(`collection_pname`),
  385. FULLTEXT INDEX `collection_cname`(`collection_cname`),
  386. CONSTRAINT `t_collection_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `t_user` (`user_id`) ON DELETE SET NULL ON UPDATE CASCADE,
  387. CONSTRAINT `t_collection_ibfk_3` FOREIGN KEY (`company_id`) REFERENCES `t_company` (`company_id`) ON DELETE CASCADE ON UPDATE CASCADE
  388. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  389. -- ----------------------------
  390. -- Table structure for t_company
  391. -- ----------------------------
  392. DROP TABLE IF EXISTS `t_company`;
  393. CREATE TABLE `t_company` (
  394. `company_id` int(11) NOT NULL AUTO_INCREMENT,
  395. `location_id` int(11) NULL DEFAULT NULL,
  396. `company_type` tinyint(1) NULL DEFAULT 0,
  397. `company_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  398. `company_shortname` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  399. `company_major` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  400. `company_urlname` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  401. `company_cert` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  402. `company_tel` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  403. `company_fax` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  404. `company_qq` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '',
  405. `company_email` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  406. `company_ctime` date NULL DEFAULT NULL,
  407. `company_addr` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  408. `company_corporation` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  409. `company_copy` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  410. `company_notes` text CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  411. `viewtimes` int(11) NULL DEFAULT 0,
  412. `company_follows` int(255) NULL DEFAULT 0,
  413. `is_vip` tinyint(1) NULL DEFAULT 0,
  414. `status` int(255) NULL DEFAULT 0,
  415. `ctime` datetime(0) NOT NULL,
  416. `utime` datetime(0) NULL DEFAULT NULL,
  417. `dtime` datetime(0) NULL DEFAULT NULL,
  418. `tagIds` text CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  419. `customerGroupId` int(11) NULL DEFAULT 0,
  420. `company_program` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '',
  421. `version` int(11) NULL DEFAULT NULL,
  422. `company_phone` varchar(255) NULL,
  423. PRIMARY KEY (`company_id`) USING BTREE,
  424. INDEX `FK_Reference_29`(`location_id`) USING BTREE,
  425. INDEX `customerGroupId`(`customerGroupId`) USING BTREE,
  426. INDEX `company_name`(`company_name`) USING BTREE,
  427. INDEX `company_shortname`(`company_shortname`) USING BTREE,
  428. INDEX `company_urlname`(`company_urlname`) USING BTREE,
  429. CONSTRAINT `FK_Reference_29` FOREIGN KEY (`location_id`) REFERENCES `t_location` (`location_id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  430. CONSTRAINT `t_company_ibfk_1` FOREIGN KEY (`customerGroupId`) REFERENCES `t_customer_group` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
  431. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;
  432. -- ----------------------------
  433. -- Table structure for t_customer
  434. -- ----------------------------
  435. DROP TABLE IF EXISTS `t_customer`;
  436. CREATE TABLE `t_customer` (
  437. `id` int(11) NOT NULL AUTO_INCREMENT,
  438. `companyId` int(11) NOT NULL DEFAULT 0,
  439. `addUserId` int(11) NOT NULL,
  440. `customerCompanyId` int(11) NULL DEFAULT NULL,
  441. `avatarImageId` int(11) NULL DEFAULT NULL,
  442. `avatarImage` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  443. `customer_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  444. `customer_phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  445. `customer_qq` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  446. `customer_email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  447. `customer_notes` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  448. `tagIds` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  449. `visitUserIds` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  450. `state` int(11) NULL DEFAULT 0,
  451. `status` int(11) NULL DEFAULT 99,
  452. `createAt` datetime(0) NULL DEFAULT NULL,
  453. `updateAt` datetime(0) NULL DEFAULT NULL,
  454. `deleteAt` datetime(0) NULL DEFAULT NULL,
  455. `groupId` int(11) NULL DEFAULT NULL,
  456. `card1ImageId` int(11) NULL DEFAULT NULL,
  457. `card2ImageId` int(11) NULL DEFAULT NULL,
  458. `card3ImageId` int(11) NULL DEFAULT NULL,
  459. `representative` tinyint(1) NULL DEFAULT 0,
  460. `customer_add` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  461. `customer_phone2` varchar(255) NULL DEFAULT '',
  462. `customer_phone3` varchar(255) NULL DEFAULT '',
  463. PRIMARY KEY (`id`) USING BTREE,
  464. INDEX `companyId`(`companyId`) USING BTREE,
  465. INDEX `t_customer_ibfk_2`(`customerCompanyId`) USING BTREE,
  466. INDEX `id`(`id`, `customerCompanyId`) USING BTREE,
  467. INDEX `groupId`(`groupId`) USING BTREE,
  468. CONSTRAINT `t_customer_ibfk_1` FOREIGN KEY (`companyId`) REFERENCES `t_company` (`company_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  469. CONSTRAINT `t_customer_ibfk_2` FOREIGN KEY (`customerCompanyId`) REFERENCES `t_company` (`company_id`) ON DELETE SET NULL ON UPDATE RESTRICT,
  470. CONSTRAINT `t_customer_ibfk_3` FOREIGN KEY (`groupId`) REFERENCES `t_customer_group` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
  471. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
  472. -- ----------------------------
  473. -- Table structure for t_customer_group
  474. -- ----------------------------
  475. DROP TABLE IF EXISTS `t_customer_group`;
  476. CREATE TABLE `t_customer_group` (
  477. `id` int(11) NOT NULL AUTO_INCREMENT,
  478. `companyId` int(11) NOT NULL,
  479. `userId` int(11) NOT NULL,
  480. `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  481. `notes` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  482. `usedCount` int(11) NULL DEFAULT 0,
  483. `status` int(11) NULL DEFAULT 99,
  484. `createAt` datetime(0) NULL DEFAULT NULL,
  485. `updateAt` datetime(0) NULL DEFAULT NULL,
  486. `deleteAt` datetime(0) NULL DEFAULT NULL,
  487. PRIMARY KEY (`id`) USING BTREE,
  488. INDEX `companyId`(`companyId`) USING BTREE,
  489. INDEX `userId`(`userId`) USING BTREE,
  490. CONSTRAINT `t_customer_group_ibfk_1` FOREIGN KEY (`companyId`) REFERENCES `t_company` (`company_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  491. CONSTRAINT `t_customer_group_ibfk_2` FOREIGN KEY (`userId`) REFERENCES `t_user` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
  492. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  493. -- ----------------------------
  494. -- Table structure for t_department
  495. -- ----------------------------
  496. DROP TABLE IF EXISTS `t_department`;
  497. CREATE TABLE `t_department` (
  498. `department_id` int(255) NOT NULL AUTO_INCREMENT,
  499. `department_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '',
  500. `department_pid` int(255) NULL DEFAULT 0,
  501. PRIMARY KEY (`department_id`) USING BTREE
  502. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;
  503. -- ----------------------------
  504. -- Table structure for t_documentary
  505. -- ----------------------------
  506. DROP TABLE IF EXISTS `t_documentary`;
  507. CREATE TABLE `t_documentary` (
  508. `documentary_id` int(11) NOT NULL AUTO_INCREMENT,
  509. `documentary_number` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  510. `documentary_number_pid` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '',
  511. `documentary_product_id` int(11) NULL DEFAULT NULL,
  512. `documentary_object` varchar(13) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  513. `documentary_summary` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  514. `documentary_state` tinyint(1) NULL DEFAULT 0,
  515. `data_id` varchar(25) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '',
  516. `companyId` int(11) NULL DEFAULT NULL,
  517. `user_id` int(11) NULL DEFAULT NULL,
  518. `ctime` datetime(0) NULL DEFAULT NULL,
  519. `utime` datetime(0) NULL DEFAULT NULL,
  520. `status` tinyint(2) NULL DEFAULT 99,
  521. PRIMARY KEY (`documentary_id`) USING BTREE
  522. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;
  523. -- ----------------------------
  524. -- Table structure for t_documentary_report
  525. -- ----------------------------
  526. DROP TABLE IF EXISTS `t_documentary_report`;
  527. CREATE TABLE `t_documentary_report` (
  528. `report_id` int(11) NOT NULL AUTO_INCREMENT,
  529. `documentary_data_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  530. `reply_user_id` int(11) NULL DEFAULT NULL,
  531. `reply_txt` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  532. `reply_image` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  533. `reply_voice` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  534. `reply_time` datetime(0) NULL DEFAULT NULL,
  535. PRIMARY KEY (`report_id`) USING BTREE
  536. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;
  537. -- ----------------------------
  538. -- Table structure for t_file_list
  539. -- ----------------------------
  540. DROP TABLE IF EXISTS `t_file_list`;
  541. CREATE TABLE `t_file_list` (
  542. `id` int(11) NOT NULL AUTO_INCREMENT,
  543. `pid` int(11) NULL DEFAULT NULL,
  544. `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  545. `md5` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  546. `crop` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  547. `url` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  548. `category` int(255) NULL DEFAULT NULL,
  549. `props` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  550. `mime` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  551. `extension` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  552. `size` int(11) NULL DEFAULT NULL,
  553. `type` int(255) NULL DEFAULT NULL,
  554. `icat` int(255) NULL DEFAULT NULL,
  555. `icatmp` int(255) NULL DEFAULT NULL,
  556. `visitimes` int(11) NULL DEFAULT NULL,
  557. `ctime` datetime(0) NULL DEFAULT NULL,
  558. `utime` datetime(0) NULL DEFAULT NULL,
  559. `dtime` datetime(0) NULL DEFAULT NULL,
  560. `status` int(255) NULL DEFAULT NULL,
  561. `user_id` int(11) NULL DEFAULT NULL,
  562. `template_number` varchar(50) NULL DEFAULT '',
  563. PRIMARY KEY (`id`) USING BTREE,
  564. UNIQUE INDEX `md5`(`md5`, `type`, `category`) USING BTREE
  565. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;
  566. -- ----------------------------
  567. -- Table structure for t_group_position
  568. -- ----------------------------
  569. DROP TABLE IF EXISTS `t_group_position`;
  570. CREATE TABLE `t_group_position` (
  571. `position_id` int(11) NOT NULL AUTO_INCREMENT,
  572. `user_id` int(11) NOT NULL,
  573. `groupIds` text CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  574. `utime` datetime(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  575. `position_type` tinyint(1) NULL DEFAULT 0,
  576. PRIMARY KEY (`position_id`) USING BTREE,
  577. INDEX `user_id`(`user_id`) USING BTREE,
  578. CONSTRAINT `t_group_position_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `t_user` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
  579. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Compact;
  580. -- ----------------------------
  581. -- Table structure for t_inventory
  582. -- ----------------------------
  583. DROP TABLE IF EXISTS `t_inventory`;
  584. CREATE TABLE `t_inventory` (
  585. `inventory_id` int(11) NOT NULL AUTO_INCREMENT,
  586. `warehouse_product_id` int(11) NULL DEFAULT NULL,
  587. `warehouse_product_color` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',
  588. `warehouse_product_color_number` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',
  589. `warehouse_product_height` double(22, 2) NULL DEFAULT NULL,
  590. `warehouse_product_width` double(22, 2) NULL DEFAULT NULL,
  591. `warehouse_material_composition` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',
  592. `warehouse_machine_id` int(11) NULL DEFAULT NULL,
  593. `warehouse_storage_area` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',
  594. `inventory_quantity_unit` int(1) NULL DEFAULT 0,
  595. `warehouse_other_description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',
  596. `status` int(2) NULL DEFAULT 99,
  597. `ctime` datetime(0) NULL DEFAULT NULL,
  598. `utime` datetime(0) NULL DEFAULT NULL,
  599. `warehouse_collection_id` int(11) NULL DEFAULT NULL,
  600. PRIMARY KEY (`inventory_id`) USING BTREE,
  601. INDEX `warehouse_product_id`(`warehouse_product_id`) USING BTREE,
  602. INDEX `warehouse_machine_id`(`warehouse_machine_id`) USING BTREE,
  603. CONSTRAINT `t_inventory_ibfk_1` FOREIGN KEY (`warehouse_product_id`) REFERENCES `t_product` (`product_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  604. CONSTRAINT `t_inventory_ibfk_2` FOREIGN KEY (`warehouse_machine_id`) REFERENCES `t_machine` (`machine_id`) ON DELETE CASCADE ON UPDATE CASCADE
  605. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  606. -- ----------------------------
  607. -- Table structure for t_inventory_calculation
  608. -- ----------------------------
  609. DROP TABLE IF EXISTS `t_inventory_calculation`;
  610. CREATE TABLE `t_inventory_calculation` (
  611. `calculation_id` int(11) NOT NULL AUTO_INCREMENT,
  612. `data_id` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  613. `affair_id` int(11) NOT NULL,
  614. `tagIds` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  615. `calculation_key` int(11) NOT NULL,
  616. `calculation_time` datetime(0) NOT NULL,
  617. `calculation_value` decimal(22, 6) NOT NULL,
  618. `calculation_value2` decimal(22, 6) NOT NULL,
  619. `calculation_condition` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  620. `calculation_note` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  621. `call_time` datetime(0) NOT NULL,
  622. `from_affair_id` int(11) NOT NULL,
  623. `self_built_source` varchar(255) NOT NULL,
  624. `tag_numbers` tinyint(1) NULL DEFAULT 0,
  625. `from_data_id` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',
  626. PRIMARY KEY (`calculation_id`, `data_id`) USING BTREE,
  627. INDEX `call_time`(`call_time`) USING BTREE,
  628. INDEX `calculation_value`(`calculation_key`, `calculation_time`, `calculation_value`, `calculation_value2`, `calculation_condition`, `tagIds`) USING BTREE
  629. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  630. -- ----------------------------
  631. -- Table structure for t_inventory_record
  632. -- ----------------------------
  633. DROP TABLE IF EXISTS `t_inventory_record`;
  634. CREATE TABLE `t_inventory_record` (
  635. `inventory_record_id` int(11) NOT NULL AUTO_INCREMENT,
  636. `inventory_id` int(11) NOT NULL,
  637. `record_time` datetime(0) NOT NULL,
  638. `inventory_quantity` double(22, 2) NOT NULL,
  639. `inventory_quantity_reserve` double(22, 2) NULL DEFAULT 0.00,
  640. `notes` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  641. `status` int(2) NULL DEFAULT 99,
  642. `ctime` datetime(0) NULL DEFAULT NULL,
  643. `utime` datetime(0) NULL DEFAULT NULL,
  644. PRIMARY KEY (`inventory_record_id`) USING BTREE,
  645. INDEX `inventory_id`(`inventory_id`) USING BTREE,
  646. CONSTRAINT `t_inventory_record_ibfk_1` FOREIGN KEY (`inventory_id`) REFERENCES `t_inventory` (`inventory_id`) ON DELETE CASCADE ON UPDATE CASCADE
  647. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  648. -- ----------------------------
  649. -- Table structure for t_keyword_log
  650. -- ----------------------------
  651. DROP TABLE IF EXISTS `t_keyword_log`;
  652. CREATE TABLE `t_keyword_log` (
  653. `keyword_id` int(11) NOT NULL AUTO_INCREMENT,
  654. `user_id` int(11) NULL DEFAULT NULL,
  655. `company_id` int(11) NULL DEFAULT NULL,
  656. `keyword_category` int(11) NULL DEFAULT NULL,
  657. `keyword_text` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  658. `keyword_values` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  659. `status` int(11) NULL DEFAULT 99,
  660. `ctime` datetime(0) NULL DEFAULT NULL,
  661. `dtime` datetime(0) NULL DEFAULT NULL,
  662. PRIMARY KEY (`keyword_id`) USING BTREE,
  663. INDEX `user_id`(`user_id`) USING BTREE,
  664. INDEX `company_id`(`company_id`) USING BTREE,
  665. CONSTRAINT `t_keyword_log_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `t_user` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  666. CONSTRAINT `t_keyword_log_ibfk_2` FOREIGN KEY (`company_id`) REFERENCES `t_company` (`company_id`) ON DELETE CASCADE ON UPDATE CASCADE
  667. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  668. -- ----------------------------
  669. -- Table structure for t_location
  670. -- ----------------------------
  671. DROP TABLE IF EXISTS `t_location`;
  672. CREATE TABLE `t_location` (
  673. `location_id` int(11) NOT NULL AUTO_INCREMENT,
  674. `location_pid` int(11) NULL DEFAULT NULL,
  675. `location_name` varchar(40) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  676. `location_postnum` varchar(6) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  677. `location_level` tinyint(1) NULL DEFAULT NULL,
  678. `location_phonenum` varchar(5) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  679. PRIMARY KEY (`location_id`) USING BTREE,
  680. INDEX `FK_Reference_28`(`location_pid`) USING BTREE,
  681. CONSTRAINT `FK_Reference_28` FOREIGN KEY (`location_pid`) REFERENCES `t_location` (`location_id`) ON DELETE SET NULL ON UPDATE CASCADE
  682. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;
  683. -- ----------------------------
  684. -- Table structure for t_log_edit
  685. -- ----------------------------
  686. DROP TABLE IF EXISTS `t_log_edit`;
  687. CREATE TABLE `t_log_edit` (
  688. `log_edit_id` int(11) NOT NULL AUTO_INCREMENT,
  689. `log_company_id` int(11) NULL DEFAULT NULL,
  690. `log_user_id` int(11) NULL DEFAULT NULL,
  691. `log_edit_clazz` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  692. `log_edit_oldvalue` longtext CHARACTER SET utf8 COLLATE utf8_bin NULL,
  693. `log_edit_newvalue` longtext CHARACTER SET utf8 COLLATE utf8_bin NULL,
  694. `log_action` tinyint(1) NULL DEFAULT NULL,
  695. `ctime` datetime(0) NULL DEFAULT NULL,
  696. PRIMARY KEY (`log_edit_id`) USING BTREE
  697. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;
  698. -- ----------------------------
  699. -- Table structure for t_machine
  700. -- ----------------------------
  701. DROP TABLE IF EXISTS `t_machine`;
  702. CREATE TABLE `t_machine` (
  703. `machine_id` int(11) NOT NULL AUTO_INCREMENT,
  704. `machine_number` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  705. `machine_horse` int(11) NULL DEFAULT 0,
  706. `machine_des` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  707. `machine_state` int(2) NOT NULL DEFAULT 0,
  708. `affair_data_id` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  709. `model_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  710. `status` int(2) NOT NULL DEFAULT 99,
  711. `ctime` datetime(0) NOT NULL,
  712. `utime` datetime(0) NULL DEFAULT NULL,
  713. `dtime` datetime(0) NULL DEFAULT NULL,
  714. PRIMARY KEY (`machine_id`) USING BTREE,
  715. INDEX `machine_id`(`machine_id`) USING BTREE,
  716. INDEX `model_name`(`model_name`) USING BTREE,
  717. CONSTRAINT `t_machine_ibfk_1` FOREIGN KEY (`model_name`) REFERENCES `t_machine_model` (`model_name`) ON DELETE CASCADE ON UPDATE CASCADE
  718. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  719. -- ----------------------------
  720. -- Table structure for t_machine_model
  721. -- ----------------------------
  722. DROP TABLE IF EXISTS `t_machine_model`;
  723. CREATE TABLE `t_machine_model` (
  724. `model_id` int(11) NOT NULL AUTO_INCREMENT,
  725. `model_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  726. `model_des` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  727. `status` int(11) NULL DEFAULT 99,
  728. `ctime` datetime(0) NOT NULL,
  729. `utime` datetime(0) NULL DEFAULT NULL,
  730. PRIMARY KEY (`model_id`) USING BTREE,
  731. INDEX `model_name`(`model_name`) USING BTREE
  732. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  733. -- ----------------------------
  734. -- Table structure for t_machine_record
  735. -- ----------------------------
  736. DROP TABLE IF EXISTS `t_machine_record`;
  737. CREATE TABLE `t_machine_record` (
  738. `record_id` int(11) NOT NULL AUTO_INCREMENT,
  739. `machine_id` int(11) NOT NULL,
  740. `record_des` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  741. `affair_data_id` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  742. `change_time` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  743. `production_time` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  744. `stop_time` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  745. `utime` datetime(0) NOT NULL,
  746. `ctime` datetime(0) NOT NULL,
  747. PRIMARY KEY (`record_id`) USING BTREE
  748. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  749. -- ----------------------------
  750. -- Table structure for t_machine_settings
  751. -- ----------------------------
  752. DROP TABLE IF EXISTS `t_machine_settings`;
  753. CREATE TABLE `t_machine_settings` (
  754. `id` int(11) NOT NULL AUTO_INCREMENT,
  755. `produced_affair_id` int(11) NULL DEFAULT NULL,
  756. `produced_sheet_id` int(11) NULL DEFAULT NULL,
  757. `produced_affair_tag_ids` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  758. `produced_user_ids` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  759. `produced_affair_summary` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  760. `produced_affair_summary_permission` tinyint(1) NULL DEFAULT 1,
  761. `utime` datetime(0) NULL DEFAULT NULL,
  762. PRIMARY KEY (`id`) USING BTREE,
  763. INDEX `produced_sheet`(`produced_sheet_id`) USING BTREE,
  764. INDEX `produced_affair_id`(`produced_affair_id`) USING BTREE,
  765. CONSTRAINT `t_machine_settings_ibfk_3` FOREIGN KEY (`produced_sheet_id`) REFERENCES `t_affair_sheet` (`sheet_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  766. CONSTRAINT `t_machine_settings_ibfk_4` FOREIGN KEY (`produced_affair_id`) REFERENCES `t_affair` (`affair_id`) ON DELETE CASCADE ON UPDATE CASCADE
  767. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  768. -- ----------------------------
  769. -- Table structure for t_pattribute
  770. -- ----------------------------
  771. DROP TABLE IF EXISTS `t_pattribute`;
  772. CREATE TABLE `t_pattribute` (
  773. `pattribute_id` int(11) NOT NULL AUTO_INCREMENT,
  774. `user_id` int(11) NULL DEFAULT NULL,
  775. `company_id` int(11) NULL DEFAULT NULL,
  776. `product_id` int(11) NOT NULL,
  777. `image_id` int(11) NULL DEFAULT NULL,
  778. `pattribute_image_id` int(11) NULL DEFAULT NULL,
  779. `pattribute_image` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  780. `pattribute_pname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  781. `pattribute_cname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  782. `pattribute_type` int(255) NULL DEFAULT NULL,
  783. `pattribute_price` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  784. `pattribute_price_unit` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  785. `pattribute_inventory` decimal(13, 3) NULL DEFAULT NULL,
  786. `pattribute_inventory_unit` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  787. `pattribute_width` decimal(13, 2) NULL DEFAULT NULL,
  788. `pattribute_width_unit` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  789. `pattribute_height` decimal(13, 2) NULL DEFAULT NULL,
  790. `pattribute_height_unit` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  791. `pattribute_freeheight` decimal(13, 2) NULL DEFAULT NULL,
  792. `pattribute_freeheight_unit` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  793. `pattribute_weight` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  794. `pattribute_weight_unit` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  795. `pattribute_elasticity` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  796. `pattribute_mtype` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  797. `pattribute_material` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  798. `pattribute_notes` text CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  799. `pattribute_address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  800. `pattribute_from` tinyint(1) NULL DEFAULT NULL,
  801. `ctime` datetime(0) NULL DEFAULT NULL,
  802. PRIMARY KEY (`pattribute_id`) USING BTREE,
  803. UNIQUE INDEX `pattribute_id`(`pattribute_id`) USING BTREE,
  804. INDEX `product_id`(`product_id`) USING BTREE,
  805. INDEX `image_id`(`image_id`) USING BTREE,
  806. CONSTRAINT `t_pattribute_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `t_product` (`product_id`) ON DELETE CASCADE ON UPDATE CASCADE
  807. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  808. -- ----------------------------
  809. -- Table structure for t_pattribute_linkman
  810. -- ----------------------------
  811. DROP TABLE IF EXISTS `t_pattribute_linkman`;
  812. CREATE TABLE `t_pattribute_linkman` (
  813. `linkman_id` int(11) NOT NULL AUTO_INCREMENT,
  814. `user_id` int(11) NULL DEFAULT NULL,
  815. `pattribute_id` int(11) NULL DEFAULT NULL,
  816. `linkman_realname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  817. `linkman_phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  818. `linkman_qq` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  819. `linkman_email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  820. `linkman_rolename` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  821. `ctime` datetime(0) NULL DEFAULT NULL,
  822. PRIMARY KEY (`linkman_id`) USING BTREE,
  823. UNIQUE INDEX `linkman_id`(`linkman_id`) USING BTREE,
  824. INDEX `pattribute_id`(`pattribute_id`) USING BTREE,
  825. INDEX `user_id`(`user_id`) USING BTREE,
  826. CONSTRAINT `t_pattribute_linkman_ibfk_1` FOREIGN KEY (`pattribute_id`) REFERENCES `t_pattribute` (`pattribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  827. CONSTRAINT `t_pattribute_linkman_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `t_user` (`user_id`) ON DELETE SET NULL ON UPDATE CASCADE
  828. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  829. -- ----------------------------
  830. -- Table structure for t_printer
  831. -- ----------------------------
  832. DROP TABLE IF EXISTS `t_printer`;
  833. CREATE TABLE `t_printer` (
  834. `printer_id` int(11) NOT NULL AUTO_INCREMENT,
  835. `need_user_id` int(11) NULL DEFAULT NULL,
  836. `printer_user_id` int(11) NULL DEFAULT NULL,
  837. `printer_type` int(11) NULL DEFAULT NULL,
  838. `printer_from_id` int(11) NULL DEFAULT NULL,
  839. `printer_data` text CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  840. `printer_state` int(11) NULL DEFAULT 0,
  841. `ctime` varchar(25) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '',
  842. `ptime` varchar(25) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '',
  843. `ttime` varchar(25) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '',
  844. `printer_page` int(11) NULL,
  845. `version` int(11) NULL,
  846. PRIMARY KEY (`printer_id`) USING BTREE,
  847. UNIQUE INDEX `printer_id`(`printer_id`) USING BTREE,
  848. INDEX `need_user_id`(`need_user_id`) USING BTREE,
  849. INDEX `printer_user_id`(`printer_user_id`) USING BTREE,
  850. CONSTRAINT `t_printer_ibfk_1` FOREIGN KEY (`need_user_id`) REFERENCES `t_user` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  851. CONSTRAINT `t_printer_ibfk_2` FOREIGN KEY (`printer_user_id`) REFERENCES `t_user` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
  852. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;
  853. -- ----------------------------
  854. -- Table structure for t_printer_frequently
  855. -- ----------------------------
  856. DROP TABLE IF EXISTS `t_printer_frequently`;
  857. CREATE TABLE `t_printer_frequently` (
  858. `frequently_id` int(11) NOT NULL AUTO_INCREMENT,
  859. `user_id` int(11) NULL DEFAULT NULL,
  860. `printer_user_ids` text CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  861. `utime` varchar(25) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '',
  862. UNIQUE INDEX `frequently_id`(`frequently_id`) USING BTREE,
  863. INDEX `user_id`(`user_id`) USING BTREE,
  864. CONSTRAINT `t_printer_frequently_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `t_user` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
  865. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Compact;
  866. -- ----------------------------
  867. -- Table structure for t_product
  868. -- ----------------------------
  869. DROP TABLE IF EXISTS `t_product`;
  870. CREATE TABLE `t_product` (
  871. `product_id` int(11) NOT NULL AUTO_INCREMENT,
  872. `user_id` int(11) NULL DEFAULT NULL,
  873. `company_id` int(11) NOT NULL,
  874. `company_type` int(11) NULL DEFAULT NULL,
  875. `image_id` int(11) NULL DEFAULT NULL,
  876. `product_image_id` int(11) NULL DEFAULT NULL,
  877. `product_image` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  878. `product_pname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  879. `product_cname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  880. `product_type` tinyint(2) NULL DEFAULT NULL,
  881. `product_state` tinyint(2) NULL DEFAULT 0,
  882. `product_price` varchar(13) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  883. `product_price_unit` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  884. `product_cloth_price` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  885. `product_cloth_price_unit` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  886. `product_product_price` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  887. `product_product_price_unit` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  888. `product_inventory` decimal(13, 3) NULL DEFAULT NULL,
  889. `product_inventory_unit` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  890. `product_width` decimal(13, 2) NULL DEFAULT NULL,
  891. `product_width_unit` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  892. `product_height` decimal(13, 2) NULL DEFAULT NULL,
  893. `product_height_unit` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  894. `product_freeheight` decimal(13, 2) NULL DEFAULT NULL,
  895. `product_freeheight_unit` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  896. `product_weight` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  897. `product_weight_unit` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  898. `product_elasticity` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  899. `product_mtype` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  900. `product_material` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  901. `product_uptime` text CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  902. `product_uptime_density` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  903. `product_uptime_density_unit` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  904. `product_notes` text CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  905. `product_chart` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  906. `chart_image_id` int(11) NULL DEFAULT NULL,
  907. `chart_image` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  908. `product_hits` int(255) NULL DEFAULT 0,
  909. `product_tag_ids` text CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  910. `ctime` datetime(0) NOT NULL,
  911. `utime` datetime(0) NULL DEFAULT NULL,
  912. `dtime` datetime(0) NULL DEFAULT NULL,
  913. `status` tinyint(2) NOT NULL DEFAULT 99,
  914. `product_exhibition_id` int(11) NULL DEFAULT NULL,
  915. `product_partially_id` int(11) NULL DEFAULT NULL,
  916. `product_beginning_id` int(11) NULL DEFAULT NULL,
  917. `product_gram_weight` decimal(13, 2) NULL DEFAULT NULL,
  918. `product_gram_weight_unit` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT 'g/m2',
  919. `push_result` longtext NULL,
  920. `recv_result` longtext NULL,
  921. `product_public_notes` longtext CHARACTER SET utf8 COLLATE utf8_bin NULL,
  922. PRIMARY KEY (`product_id`) USING BTREE,
  923. UNIQUE INDEX `product_id`(`product_id`) USING BTREE,
  924. INDEX `FK_Relationship_12`(`user_id`) USING BTREE,
  925. INDEX `ctime`(`ctime`) USING BTREE,
  926. INDEX `status`(`status`) USING BTREE,
  927. INDEX `company_id`(`company_id`) USING BTREE,
  928. INDEX `image_id`(`image_id`) USING BTREE,
  929. INDEX `product_pname`(`product_pname`, `product_cname`, `product_type`, `status`) USING BTREE,
  930. CONSTRAINT `t_product_ibfk_2` FOREIGN KEY (`company_id`) REFERENCES `t_company` (`company_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  931. CONSTRAINT `t_product_ibfk_3` FOREIGN KEY (`user_id`) REFERENCES `t_user` (`user_id`) ON DELETE SET NULL ON UPDATE CASCADE
  932. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;
  933. -- ----------------------------
  934. -- Table structure for t_product_share
  935. -- ----------------------------
  936. DROP TABLE IF EXISTS `t_product_share`;
  937. CREATE TABLE `t_product_share` (
  938. `share_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  939. `product_ids` longtext CHARACTER SET utf8 COLLATE utf8_bin NULL,
  940. `user_id` int(11) NULL DEFAULT NULL,
  941. `company_id` int(11) NULL DEFAULT NULL,
  942. `title` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '',
  943. `ctime` datetime NULL,
  944. `share_time` varchar(25) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  945. `desc` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  946. `imgUrl` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  947. `share_type` varchar(25) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  948. `share_password` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  949. `hits` int(11) NULL DEFAULT 0,
  950. PRIMARY KEY (`share_id`) USING BTREE
  951. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Compact;
  952. -- ----------------------------
  953. -- Table structure for t_product_template
  954. -- ----------------------------
  955. DROP TABLE IF EXISTS `t_product_template`;
  956. CREATE TABLE `t_product_template` (
  957. `template_md5` varchar(50) COLLATE utf8_bin NOT NULL,
  958. `user_id` int(11) DEFAULT NULL,
  959. `company_id` int(11) DEFAULT NULL,
  960. `ctime` datetime DEFAULT NULL ON UPDATE current_timestamp(),
  961. `template_imgUrl` varchar(255) COLLATE utf8_bin DEFAULT '',
  962. `template_number` varchar(25) COLLATE utf8_bin DEFAULT '',
  963. `template_color` varchar(50) COLLATE utf8_bin DEFAULT '',
  964. PRIMARY KEY (`template_md5`)
  965. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=COMPACT;
  966. -- ----------------------------
  967. -- Table structure for t_r_product_collection
  968. -- ----------------------------
  969. DROP TABLE IF EXISTS `t_r_product_collection`;
  970. CREATE TABLE `t_r_product_collection` (
  971. `collection_id` int(11) NOT NULL,
  972. `product_id` int(11) NOT NULL,
  973. PRIMARY KEY (`collection_id`, `product_id`) USING BTREE,
  974. INDEX `product_id`(`product_id`) USING BTREE,
  975. INDEX `collection_id_2`(`collection_id`) USING BTREE,
  976. CONSTRAINT `t_r_product_collection_ibfk_1` FOREIGN KEY (`collection_id`) REFERENCES `t_collection` (`collection_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  977. CONSTRAINT `t_r_product_collection_ibfk_2` FOREIGN KEY (`product_id`) REFERENCES `t_product` (`product_id`) ON DELETE CASCADE ON UPDATE CASCADE
  978. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  979. -- ----------------------------
  980. -- Table structure for t_report_forms
  981. -- ----------------------------
  982. DROP TABLE IF EXISTS `t_report_forms`;
  983. CREATE TABLE `t_report_forms` (
  984. `report_forms_id` int(11) NOT NULL AUTO_INCREMENT,
  985. `report_forms_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  986. `report_forms_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  987. `report_forms_desc` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  988. `report_forms_count` int(11) NULL DEFAULT 0,
  989. `status` int(2) NULL DEFAULT 99,
  990. `ctime` datetime(0) NULL DEFAULT NULL,
  991. `utime` datetime(0) NULL DEFAULT NULL,
  992. `forms_data` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  993. `report_forms_limit` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  994. `report_forms_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  995. `forms_affair_Ids` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  996. `tag_limit` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  997. `set_begin` tinyint(1) NULL DEFAULT 2,
  998. `set_inventory` tinyint(1) NULL DEFAULT 2,
  999. `report_forms_pid` int(11) NULL DEFAULT NULL,
  1000. `report_forms_prompt` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',
  1001. `print_forms_data` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  1002. `report_forms_group_id` int(11) NULL DEFAULT NULL,
  1003. `set_seal_account` tinyint(1) NULL DEFAULT 2,
  1004. `set_achievements` tinyint(1) NULL DEFAULT 2,
  1005. `set_company_account` tinyint(1) NULL DEFAULT 2,
  1006. PRIMARY KEY (`report_forms_id`) USING BTREE,
  1007. INDEX `report_forms_group_id`(`report_forms_group_id`) USING BTREE,
  1008. CONSTRAINT `t_report_forms_ibfk_1` FOREIGN KEY (`report_forms_group_id`) REFERENCES `t_report_forms_group` (`report_forms_group_id`) ON DELETE SET NULL ON UPDATE NO ACTION
  1009. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  1010. -- ----------------------------
  1011. -- Table structure for t_report_forms_begin
  1012. -- ----------------------------
  1013. DROP TABLE IF EXISTS `t_report_forms_begin`;
  1014. CREATE TABLE `t_report_forms_begin` (
  1015. `begin_id` int(11) NOT NULL AUTO_INCREMENT,
  1016. `user_id` int(11) NULL DEFAULT NULL,
  1017. `report_forms_id` int(11) NULL DEFAULT NULL,
  1018. `begin_customer` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  1019. `status` int(2) NULL DEFAULT 99,
  1020. `ctime` datetime(0) NULL DEFAULT NULL,
  1021. `utime` datetime(0) NULL DEFAULT NULL,
  1022. `begin_cumulative` double(16, 2) NULL DEFAULT NULL,
  1023. `admission` tinyint(1) NULL DEFAULT 0,
  1024. PRIMARY KEY (`begin_id`) USING BTREE,
  1025. INDEX `user_id`(`user_id`) USING BTREE,
  1026. INDEX `report_forms_id`(`report_forms_id`) USING BTREE,
  1027. CONSTRAINT `t_report_forms_begin_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `t_user` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  1028. CONSTRAINT `t_report_forms_begin_ibfk_2` FOREIGN KEY (`report_forms_id`) REFERENCES `t_report_forms` (`report_forms_id`) ON DELETE CASCADE ON UPDATE CASCADE
  1029. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  1030. -- ----------------------------
  1031. -- Table structure for t_report_forms_group
  1032. -- ----------------------------
  1033. DROP TABLE IF EXISTS `t_report_forms_group`;
  1034. CREATE TABLE `t_report_forms_group` (
  1035. `report_forms_group_id` int(11) NOT NULL AUTO_INCREMENT,
  1036. `report_forms_group_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  1037. `report_forms_group_notes` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  1038. `status` int(11) NULL DEFAULT 99,
  1039. `ctime` datetime(0) NULL DEFAULT NULL,
  1040. `utime` datetime(0) NULL DEFAULT NULL,
  1041. `dtime` datetime(0) NULL DEFAULT NULL,
  1042. PRIMARY KEY (`report_forms_group_id`) USING BTREE
  1043. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  1044. -- ----------------------------
  1045. -- Table structure for t_report_forms_permission
  1046. -- ----------------------------
  1047. DROP TABLE IF EXISTS `t_report_forms_permission`;
  1048. CREATE TABLE `t_report_forms_permission` (
  1049. `report_forms_per_id` int(11) NOT NULL AUTO_INCREMENT,
  1050. `report_forms_id` int(11) NOT NULL,
  1051. `user_id` int(11) NOT NULL DEFAULT 0,
  1052. PRIMARY KEY (`report_forms_per_id`) USING BTREE,
  1053. INDEX `user_id`(`user_id`) USING BTREE,
  1054. INDEX `bill_per_id`(`report_forms_per_id`) USING BTREE,
  1055. INDEX `bill_id`(`report_forms_id`) USING BTREE,
  1056. CONSTRAINT `t_report_forms_permission_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `t_user` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  1057. CONSTRAINT `t_report_forms_permission_ibfk_2` FOREIGN KEY (`report_forms_id`) REFERENCES `t_report_forms` (`report_forms_id`) ON DELETE CASCADE ON UPDATE CASCADE
  1058. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  1059. -- ----------------------------
  1060. -- Table structure for t_role
  1061. -- ----------------------------
  1062. DROP TABLE IF EXISTS `t_role`;
  1063. CREATE TABLE `t_role` (
  1064. `role_id` int(11) NOT NULL AUTO_INCREMENT,
  1065. `role_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  1066. `role_desc` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  1067. PRIMARY KEY (`role_id`) USING BTREE
  1068. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;
  1069. -- ----------------------------
  1070. -- Table structure for t_rule_new
  1071. -- ----------------------------
  1072. DROP TABLE IF EXISTS `t_rule_new`;
  1073. CREATE TABLE `t_rule_new` (
  1074. `rule_new_id` int(11) NOT NULL AUTO_INCREMENT,
  1075. `user_id` int(11) NULL DEFAULT NULL,
  1076. `product_modular` tinyint(1) NULL DEFAULT 0,
  1077. `product_modular_delete` tinyint(1) NULL DEFAULT 0,
  1078. `product_modular_add` tinyint(1) NULL DEFAULT 0,
  1079. `product_modular_public` tinyint(1) NULL DEFAULT 0,
  1080. `product_modular_private` tinyint(1) NULL DEFAULT 0,
  1081. `product_modular_supplier` tinyint(1) NULL DEFAULT 0,
  1082. `product_modular_push` tinyint(1) NULL DEFAULT 0,
  1083. `product_modular_template` tinyint(1) NULL DEFAULT 0,
  1084. `product_modular_batch_share` tinyint(1) NULL DEFAULT 0,
  1085. `material_modular` tinyint(1) NULL DEFAULT 0,
  1086. `material_modular_edit` tinyint(1) NULL DEFAULT 0,
  1087. `material_modular_delete` tinyint(1) NULL DEFAULT 0,
  1088. `material_modular_push` tinyint(1) NULL DEFAULT 0,
  1089. `documentary_modular_statistics` tinyint(1) NULL DEFAULT 0,
  1090. `documentary_modular_remove` tinyint(1) NULL DEFAULT 0,
  1091. `customer_modular` tinyint(1) NULL DEFAULT 0,
  1092. `customer_modular_delete` tinyint(1) NULL DEFAULT 0,
  1093. `customer_modular_customer_edit` tinyint(1) NULL DEFAULT 0,
  1094. `customer_modular_company_edit` tinyint(1) NULL DEFAULT 0,
  1095. `customer_modular_add` tinyint(1) NULL DEFAULT 0,
  1096. `customer_modular_transfer` tinyint(1) NULL DEFAULT 0,
  1097. `customer_modular_set_visible` tinyint(1) NULL DEFAULT 0,
  1098. `machine_modular` tinyint(1) NULL DEFAULT 0,
  1099. `machine_modular_add` tinyint(1) NULL DEFAULT 0,
  1100. `machine_modular_edit` tinyint(1) NULL DEFAULT 0,
  1101. `machine_modular_record` tinyint(1) NULL DEFAULT 0,
  1102. `machine_modular_wait` tinyint(1) NULL DEFAULT 0,
  1103. `shop_modular` tinyint(1) NULL DEFAULT 0,
  1104. `shop_modular_update` tinyint(1) NULL DEFAULT 0,
  1105. `bill_modular` tinyint(1) NULL DEFAULT 0,
  1106. `bill_modular_waste` tinyint(1) NULL DEFAULT 0,
  1107. `bill_modular_set` tinyint(1) NULL DEFAULT 0,
  1108. `affair_modular` tinyint(1) NULL DEFAULT 0,
  1109. `employee_modular` tinyint(1) NULL DEFAULT 0,
  1110. `tag_modular` tinyint(1) NULL DEFAULT 0,
  1111. `report_modular` tinyint(1) NULL DEFAULT 0,
  1112. `report_modular_download` tinyint(1) NULL DEFAULT 0,
  1113. `company_modular` tinyint(1) NULL DEFAULT 0,
  1114. `company_modular_authentication` tinyint(1) NULL DEFAULT 0,
  1115. `affair_recycle_bin` tinyint(1) NULL DEFAULT 0,
  1116. `documentary_modular` tinyint(1) NULL DEFAULT 0,
  1117. `documentary_modular_control` tinyint(1) NULL DEFAULT 0,
  1118. `documentary_modular_report` tinyint(1) NULL DEFAULT 0,
  1119. `print_modular` tinyint(1) NULL DEFAULT 0,
  1120. `documentary_modular_adjustment` tinyint(1) NULL DEFAULT 0,
  1121. `product_modular_public_see` tinyint(1) NULL DEFAULT 0,
  1122. `product_modular_private_see` tinyint(1) NULL DEFAULT 0,
  1123. `affair_all_modify_record_see` tinyint(1) NULL DEFAULT 0,
  1124. `inventory_modular_edit` tinyint(1) NULL DEFAULT 0,
  1125. PRIMARY KEY (`rule_new_id`) USING BTREE,
  1126. UNIQUE INDEX `rule_new_id`(`rule_new_id`) USING BTREE,
  1127. INDEX `user_id`(`user_id`) USING BTREE,
  1128. CONSTRAINT `t_rule_new_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `t_user` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
  1129. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  1130. -- ----------------------------
  1131. -- Table structure for t_seal_account
  1132. -- ----------------------------
  1133. DROP TABLE IF EXISTS `t_seal_account`;
  1134. CREATE TABLE `t_seal_account` (
  1135. `seal_id` int(11) NOT NULL AUTO_INCREMENT,
  1136. `user_id` int(11) NULL DEFAULT NULL,
  1137. `content_id` int(11) NULL DEFAULT NULL,
  1138. `content_type` tinyint(1) NULL DEFAULT 0,
  1139. `content_time` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  1140. PRIMARY KEY (`seal_id`) USING BTREE,
  1141. INDEX `user_id`(`user_id`) USING BTREE,
  1142. CONSTRAINT `t_seal_account_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `t_user` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
  1143. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  1144. -- ----------------------------
  1145. -- Table structure for t_shop
  1146. -- ----------------------------
  1147. DROP TABLE IF EXISTS `t_shop`;
  1148. CREATE TABLE `t_shop` (
  1149. `shop_id` int(11) NOT NULL AUTO_INCREMENT,
  1150. `company_id` int(11) NULL DEFAULT NULL,
  1151. `shop_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  1152. `shop_urlname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  1153. `shop_intro` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  1154. `shop_allow_subdomain` smallint(6) NULL DEFAULT 0,
  1155. `shop_open_time` datetime(0) NULL DEFAULT NULL,
  1156. `shop_hits` int(255) NULL DEFAULT 0,
  1157. `shop_wechat_hits` int(255) NULL DEFAULT 0,
  1158. PRIMARY KEY (`shop_id`) USING BTREE
  1159. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
  1160. -- ----------------------------
  1161. -- Table structure for t_shop_product
  1162. -- ----------------------------
  1163. DROP TABLE IF EXISTS `t_shop_product`;
  1164. CREATE TABLE `t_shop_product` (
  1165. `product_id` int(11) NOT NULL,
  1166. `company_id` int(11) NULL DEFAULT NULL,
  1167. `user_id` int(11) NULL DEFAULT NULL,
  1168. `shop_id` int(11) NULL DEFAULT NULL,
  1169. `product_shop_pname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  1170. `product_shop_material` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  1171. `product_shop_height` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  1172. `product_shop_height_unit` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  1173. `product_shop_width` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  1174. `product_shop_width_unit` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  1175. `product_shop_elasticity` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  1176. `product_shop_price_origin` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  1177. `product_shop_price_origin_unit` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  1178. `product_shop_price_on_sale` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  1179. `product_shop_price_on_sale_unit` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  1180. `product_shop_inventory` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  1181. `product_shop_inventory_unit` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  1182. `product_intro` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  1183. `product_is_promotion` int(11) NULL DEFAULT NULL,
  1184. `product_is_order` int(255) NULL DEFAULT NULL,
  1185. `product_on_time` datetime(0) NULL DEFAULT NULL,
  1186. `product_tag_ids` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  1187. `product_order` int(255) NULL DEFAULT 0,
  1188. `product_promotion` tinyint(1) NULL DEFAULT NULL,
  1189. `product_promotion_start` datetime(0) NULL DEFAULT NULL,
  1190. `product_promotion_end` datetime(0) NULL DEFAULT NULL,
  1191. `product_shop_hits` int(255) UNSIGNED NULL DEFAULT 0,
  1192. `product_shop_hits_weight` int(11) NULL DEFAULT 0,
  1193. PRIMARY KEY (`product_id`) USING BTREE,
  1194. UNIQUE INDEX `product_id`(`product_id`) USING BTREE,
  1195. CONSTRAINT `t_shop_product_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `t_product` (`product_id`) ON DELETE CASCADE ON UPDATE RESTRICT
  1196. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
  1197. -- ----------------------------
  1198. -- Table structure for t_statement_calculation
  1199. -- ----------------------------
  1200. DROP TABLE IF EXISTS `t_statement_calculation`;
  1201. CREATE TABLE `t_statement_calculation` (
  1202. `calculation_id` int(11) NOT NULL AUTO_INCREMENT,
  1203. `data_id` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  1204. `affair_id` int(11) NOT NULL,
  1205. `user_id` int(11) NOT NULL,
  1206. `tagIds` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  1207. `bill_order_id` int(11) NOT NULL,
  1208. `calculation_key` varchar(13) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  1209. `calculation_time` datetime(0) NOT NULL,
  1210. `calculation_product_specification` varchar(255) NOT NULL,
  1211. `calculation_product_color` varchar(255) NOT NULL,
  1212. `calculation_account_category_out` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  1213. `calculation_receivables_payment_category` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  1214. `receivables_mode` tinyint(1) NOT NULL,
  1215. `bill_order_number` varchar(255) NULL,
  1216. `tag_numbers` tinyint(1) NULL DEFAULT 0,
  1217. `calculation_value` decimal(22, 6) NOT NULL DEFAULT 0.000000,
  1218. `calculation_condition` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  1219. `calculation_supplement` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  1220. `call_time` datetime(0) NOT NULL,
  1221. `calculation_senior_screen` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  1222. `calculation_account_category` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  1223. `calculation_product_id` int(11) NOT NULL,
  1224. `calculation_collection_id` int(11) NOT NULL,
  1225. `day` INT ( 11 ) NULL,
  1226. `calculation_ctime` datetime(0) NULL DEFAULT NULL,
  1227. `calculation_note` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  1228. PRIMARY KEY (`calculation_id`, `data_id`) USING BTREE,
  1229. INDEX `bill_order_id`(`bill_order_id`) USING BTREE,
  1230. INDEX `call_time`(`call_time`) USING BTREE,
  1231. INDEX ` calculation_value`(`calculation_key`, `affair_id`, `calculation_time`, `calculation_value`, `calculation_condition`, `tagIds`) USING BTREE,
  1232. INDEX `calculation_time`(`calculation_time`, `affair_id`, `calculation_condition`, `tagIds`) USING BTREE
  1233. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  1234. -- ----------------------------
  1235. -- Table structure for t_tag_frequently
  1236. -- ----------------------------
  1237. DROP TABLE IF EXISTS `t_tag_frequently`;
  1238. CREATE TABLE `t_tag_frequently` (
  1239. `frequently_id` int(11) NOT NULL AUTO_INCREMENT,
  1240. `user_id` int(11) NOT NULL,
  1241. `tag_id` int(11) NOT NULL,
  1242. `ctime` datetime(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  1243. PRIMARY KEY (`frequently_id`) USING BTREE,
  1244. INDEX `user_id`(`user_id`) USING BTREE,
  1245. INDEX `tag_id`(`tag_id`) USING BTREE,
  1246. CONSTRAINT `t_tag_frequently_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `t_user` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  1247. CONSTRAINT `t_tag_frequently_ibfk_3` FOREIGN KEY (`tag_id`) REFERENCES `t_tag_list` (`tag_id`) ON DELETE CASCADE ON UPDATE CASCADE
  1248. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Compact;
  1249. -- ----------------------------
  1250. -- Table structure for t_tag_list
  1251. -- ----------------------------
  1252. DROP TABLE IF EXISTS `t_tag_list`;
  1253. CREATE TABLE `t_tag_list` (
  1254. `tag_id` int(11) NOT NULL AUTO_INCREMENT,
  1255. `company_id` int(11) NULL DEFAULT NULL,
  1256. `user_id` int(11) NULL DEFAULT NULL,
  1257. `tag_category` int(11) NULL DEFAULT 0,
  1258. `tag_image_id` int(11) NULL DEFAULT NULL,
  1259. `tag_image` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  1260. `tag_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  1261. `tag_desc` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  1262. `used_count` int(11) NULL DEFAULT 0,
  1263. `status` int(2) NULL DEFAULT 99,
  1264. `ctime` datetime(0) NULL DEFAULT NULL,
  1265. `utime` datetime(0) NULL DEFAULT NULL,
  1266. `permission` int(1) NULL DEFAULT 1,
  1267. `necessary` int(1) NULL DEFAULT 0,
  1268. `data_protection` int(1) NULL DEFAULT 0,
  1269. `position` int(11) NULL DEFAULT 0,
  1270. `permission_view` INT ( 1 ) NULL DEFAULT 1,
  1271. PRIMARY KEY (`tag_id`) USING BTREE,
  1272. INDEX `t_tag_list_ibfk_1`(`tag_image_id`) USING BTREE
  1273. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  1274. -- ----------------------------
  1275. -- Table structure for t_tag_list_rel
  1276. -- ----------------------------
  1277. DROP TABLE IF EXISTS `t_tag_list_rel`;
  1278. CREATE TABLE `t_tag_list_rel` (
  1279. `rel_id` int(11) NOT NULL AUTO_INCREMENT,
  1280. `user_id` int(11) NOT NULL,
  1281. `tag_category` int(11) NULL DEFAULT NULL,
  1282. `content_id` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  1283. `content_type` int(11) NULL DEFAULT 0,
  1284. `tag_id` int(11) NULL DEFAULT NULL,
  1285. `ctime` datetime(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  1286. PRIMARY KEY (`rel_id`) USING BTREE,
  1287. INDEX `tag_id`(`tag_id`) USING BTREE,
  1288. CONSTRAINT `t_tag_list_rel_ibfk_1` FOREIGN KEY (`tag_id`) REFERENCES `t_tag_list` (`tag_id`) ON DELETE CASCADE ON UPDATE CASCADE
  1289. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  1290. -- ----------------------------
  1291. -- Table structure for t_tag_permission
  1292. -- ----------------------------
  1293. DROP TABLE IF EXISTS `t_tag_permission`;
  1294. CREATE TABLE `t_tag_permission` (
  1295. `per_id` int(11) NOT NULL AUTO_INCREMENT,
  1296. `tag_id` int(11) NOT NULL,
  1297. `user_id` int(11) NOT NULL DEFAULT 0,
  1298. PRIMARY KEY (`per_id`) USING BTREE,
  1299. INDEX `per_id`(`per_id`) USING BTREE,
  1300. INDEX `tag_id`(`tag_id`) USING BTREE,
  1301. INDEX `user_id`(`user_id`) USING BTREE,
  1302. `allow` INT ( 1 ) NULL DEFAULT 1,
  1303. CONSTRAINT `t_tag_permission_ibfk_1` FOREIGN KEY (`tag_id`) REFERENCES `t_tag_list` (`tag_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  1304. CONSTRAINT `t_tag_permission_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `t_user` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
  1305. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  1306. -- ----------------------------
  1307. -- Table structure for t_user
  1308. -- ----------------------------
  1309. DROP TABLE IF EXISTS `t_user`;
  1310. CREATE TABLE `t_user` (
  1311. `user_id` int(11) NOT NULL AUTO_INCREMENT,
  1312. `company_id` int(11) NULL DEFAULT NULL,
  1313. `role_id` int(11) NOT NULL,
  1314. `location_id` int(11) NULL DEFAULT NULL,
  1315. `department_id` int(11) NULL DEFAULT NULL,
  1316. `user_addr` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  1317. `user_company_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  1318. `user_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  1319. `user_password` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  1320. `user_pwdhash` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  1321. `user_realname` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  1322. `user_gender` tinyint(1) NULL DEFAULT 1,
  1323. `user_avatar` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  1324. `user_phonenum` varchar(11) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  1325. `user_state` tinyint(1) NULL DEFAULT 0,
  1326. `user_qq` varchar(15) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  1327. `user_email` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  1328. `user_uid` varchar(18) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  1329. `user_region` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  1330. `visible` tinyint(255) NULL DEFAULT NULL,
  1331. `ctime` datetime(0) NOT NULL,
  1332. `utime` datetime(0) NULL DEFAULT NULL,
  1333. `dtime` datetime(0) NULL DEFAULT NULL,
  1334. `status` decimal(2, 0) NOT NULL DEFAULT 99,
  1335. `user_logtimes` int(11) NULL DEFAULT NULL,
  1336. `user_lastip` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  1337. `user_lastlogintime` datetime(0) NULL DEFAULT NULL,
  1338. `user_lastackqstring` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  1339. `user_lastackurl` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  1340. `avos_session_token` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  1341. `user_lastacktime` datetime(0) NULL DEFAULT NULL,
  1342. `user_lastackdevice` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  1343. `user_signup_user_agent` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  1344. `auth_key` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  1345. `access_token` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  1346. `tgt` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  1347. `st` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  1348. `sid` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  1349. `avos_token` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  1350. `referral_code` int(6) NULL DEFAULT NULL,
  1351. `user_lastaddress` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  1352. `necessary` tinyint(1) NULL DEFAULT 0,
  1353. `work_time` varchar(60) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  1354. `attendance_id` int(11) NULL DEFAULT NULL,
  1355. `bill_header` varchar(255) NULL,
  1356. `report_header` varchar(255) NULL,
  1357. `report_password` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NULL,
  1358. `report_password_type` tinyint(1) NULL DEFAULT 0,
  1359. PRIMARY KEY (`user_id`) USING BTREE,
  1360. INDEX `FK_Relationship_2`(`role_id`) USING BTREE,
  1361. INDEX `company_id`(`company_id`) USING BTREE,
  1362. INDEX `department_id`(`department_id`) USING BTREE,
  1363. INDEX `user_name`(`user_name`) USING BTREE,
  1364. INDEX `referral_code`(`referral_code`) USING BTREE,
  1365. INDEX `referral_code_2`(`referral_code`) USING BTREE,
  1366. INDEX `user_phonenum`(`user_phonenum`) USING BTREE,
  1367. CONSTRAINT `FK_Relationship_2` FOREIGN KEY (`role_id`) REFERENCES `t_role` (`role_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  1368. CONSTRAINT `t_user_ibfk_2` FOREIGN KEY (`company_id`) REFERENCES `t_company` (`company_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  1369. CONSTRAINT `t_user_ibfk_3` FOREIGN KEY (`department_id`) REFERENCES `t_department` (`department_id`) ON DELETE SET NULL ON UPDATE CASCADE
  1370. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;
  1371. -- ----------------------------
  1372. -- Table structure for t_user_attendance
  1373. -- ----------------------------
  1374. DROP TABLE IF EXISTS `t_user_attendance`;
  1375. CREATE TABLE `t_user_attendance` (
  1376. `attendance_id` int(11) NOT NULL AUTO_INCREMENT,
  1377. `attendance_name` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  1378. `attendance_time` varchar(60) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  1379. `monday` varchar(60) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '',
  1380. `tuesday` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '',
  1381. `wednesday` varchar(60) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '',
  1382. `thursday` varchar(60) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '',
  1383. `friday` varchar(60) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '',
  1384. `saturday` varchar(60) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '',
  1385. `sunday` varchar(60) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '',
  1386. PRIMARY KEY (`attendance_id`) USING BTREE
  1387. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;
  1388. -- ----------------------------
  1389. -- Table structure for t_work
  1390. -- ----------------------------
  1391. DROP TABLE IF EXISTS `t_work`;
  1392. CREATE TABLE `t_work` (
  1393. `work_id` int(11) NOT NULL AUTO_INCREMENT,
  1394. `work_pid` int(11) NULL DEFAULT NULL,
  1395. `work_children_ids` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  1396. `affair_id` int(11) NULL DEFAULT NULL,
  1397. `user_id` int(11) NULL DEFAULT NULL,
  1398. `work_type` int(11) NULL DEFAULT NULL,
  1399. `reminder_id` int(11) NULL DEFAULT NULL,
  1400. `image_ids` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  1401. `voice_ids` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  1402. `content_text` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  1403. `ctime` datetime(0) NULL DEFAULT NULL,
  1404. `utime` datetime(0) NULL DEFAULT NULL,
  1405. `work_data_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  1406. `work_object_type` tinyint(1) NULL DEFAULT 1,
  1407. `work_object_ids` text CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  1408. `work_theme` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  1409. `affair_data_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  1410. PRIMARY KEY (`work_id`) USING BTREE
  1411. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;
  1412. -- ----------------------------
  1413. -- Table structure for t_work_frequently
  1414. -- ----------------------------
  1415. DROP TABLE IF EXISTS `t_work_frequently`;
  1416. CREATE TABLE `t_work_frequently` (
  1417. `work_frequently_id` int(11) NOT NULL AUTO_INCREMENT,
  1418. `user_id` int(11) NOT NULL,
  1419. `affair_id` int(11) NOT NULL,
  1420. `ctime` datetime(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  1421. `work_type_notice` tinyint(1) NULL DEFAULT 0,
  1422. `work_type_instructions` tinyint(1) NULL DEFAULT 0,
  1423. `work_type_Assign` tinyint(1) NULL DEFAULT 0,
  1424. PRIMARY KEY (`work_frequently_id`) USING BTREE,
  1425. INDEX `affair_id`(`affair_id`) USING BTREE,
  1426. INDEX `user_id`(`user_id`) USING BTREE,
  1427. CONSTRAINT `t_work_frequently_ibfk_1` FOREIGN KEY (`affair_id`) REFERENCES `t_affair` (`affair_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  1428. CONSTRAINT `t_work_frequently_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `t_user` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
  1429. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Compact;
  1430. -- ----------------------------
  1431. -- Table structure for t_work_reminder
  1432. -- ----------------------------
  1433. DROP TABLE IF EXISTS `t_work_reminder`;
  1434. CREATE TABLE `t_work_reminder` (
  1435. `work_id` int(11) NOT NULL,
  1436. `reply_id` int(11) NULL DEFAULT NULL,
  1437. `set_object_type` tinyint(1) NULL DEFAULT NULL,
  1438. `set_object_ids` text CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  1439. `set_frequency` int(11) NULL DEFAULT 0,
  1440. `set_interval` int(11) NULL DEFAULT NULL,
  1441. `set_interval_unit` tinyint(1) NULL DEFAULT NULL,
  1442. `reminder_object_ids` text CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  1443. `reminder_frequency` int(11) NULL DEFAULT 0,
  1444. `reminder_time` datetime(0) NULL DEFAULT NULL,
  1445. `is_reminder` tinyint(1) NULL DEFAULT 0,
  1446. PRIMARY KEY (`work_id`) USING BTREE,
  1447. CONSTRAINT `t_work_reminder_ibfk_1` FOREIGN KEY (`work_id`) REFERENCES `t_work` (`work_id`) ON DELETE CASCADE ON UPDATE CASCADE
  1448. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;
  1449. -- ----------------------------
  1450. -- Table structure for t_work_reply
  1451. -- ----------------------------
  1452. DROP TABLE IF EXISTS `t_work_reply`;
  1453. CREATE TABLE `t_work_reply` (
  1454. `reply_id` int(11) NOT NULL AUTO_INCREMENT,
  1455. `reply_pid` int(11) NULL DEFAULT NULL,
  1456. `work_id` int(11) NULL DEFAULT NULL,
  1457. `reply_user_id` int(11) NULL DEFAULT NULL,
  1458. `reply_txt` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  1459. `reply_affair_old_data` text CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  1460. `reply_affair_new_data` text CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  1461. `reply_time` datetime(0) NULL DEFAULT NULL,
  1462. `reply_object_ids` text CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  1463. `reply_image` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  1464. `reply_voice` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  1465. `reply_content` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  1466. PRIMARY KEY (`reply_id`) USING BTREE,
  1467. INDEX `work_id`(`work_id`) USING BTREE,
  1468. CONSTRAINT `t_work_reply_ibfk_1` FOREIGN KEY (`work_id`) REFERENCES `t_work` (`work_id`) ON DELETE CASCADE ON UPDATE CASCADE
  1469. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;
  1470. -- ----------------------------
  1471. -- Table structure for t_process_in_calculation
  1472. -- ----------------------------
  1473. DROP TABLE IF EXISTS `t_process_in_calculation`;
  1474. CREATE TABLE `t_process_in_calculation` (
  1475. `calculation_id` int(11) NOT NULL AUTO_INCREMENT,
  1476. `data_id` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  1477. `affair_id` int(11) NOT NULL,
  1478. `tagIds` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  1479. `calculation_key` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  1480. `calculation_time` datetime(0) NOT NULL,
  1481. `product_id` int(11) NOT NULL,
  1482. `collection_id` int(11) NOT NULL,
  1483. `product_color` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  1484. `product_color_number` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  1485. `sale_object` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  1486. `product_width` decimal(14, 2) NOT NULL,
  1487. `product_height` decimal(14, 2) NOT NULL,
  1488. `machining_price` decimal(15, 3) NOT NULL,
  1489. `calculation_condition` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  1490. `actual_in_storehouse_quantity` decimal(22, 2) NOT NULL,
  1491. `call_time` datetime(0) NOT NULL,
  1492. `tag_numbers` tinyint(1) NULL DEFAULT 0,
  1493. PRIMARY KEY (`calculation_id`, `data_id`) USING BTREE,
  1494. INDEX `call_time`(`call_time`) USING BTREE,
  1495. INDEX `data_id`(`data_id`) USING BTREE,
  1496. INDEX `affair_id`(`affair_id`, `calculation_time`, `calculation_condition`, `tagIds`, `calculation_key`, `product_id`, `product_color`, `sale_object`) USING BTREE
  1497. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  1498. -- ----------------------------
  1499. -- Table structure for t_process_out_calculation
  1500. -- ----------------------------
  1501. DROP TABLE IF EXISTS `t_process_out_calculation`;
  1502. CREATE TABLE `t_process_out_calculation` (
  1503. `calculation_id` int(11) NOT NULL AUTO_INCREMENT,
  1504. `data_id` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  1505. `affair_id` int(11) NOT NULL,
  1506. `tagIds` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  1507. `calculation_condition` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  1508. `calculation_time` datetime(0) NOT NULL,
  1509. `machining_price` decimal(15, 3) NOT NULL,
  1510. `machining_quantity` decimal(15, 2) NOT NULL,
  1511. `machining_total_amount` decimal(15, 3) NOT NULL,
  1512. `out_storehouse_quantity` decimal(22, 2) NOT NULL,
  1513. `from_data_id` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  1514. `is_complete` int(1) NOT NULL DEFAULT 0,
  1515. `call_time` datetime(0) NOT NULL,
  1516. `clearing_storehouse` int(1) NOT NULL DEFAULT 0,
  1517. `tag_numbers` tinyint(1) NULL DEFAULT 0,
  1518. PRIMARY KEY (`calculation_id`, `data_id`, `from_data_id`) USING BTREE,
  1519. INDEX `call_time`(`call_time`) USING BTREE,
  1520. INDEX `affair_id`(`affair_id`, `calculation_time`, `calculation_condition`, `tagIds`, `from_data_id`) USING BTREE
  1521. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  1522. -- ----------------------------
  1523. -- Table structure for t_machine_calculation
  1524. -- ----------------------------
  1525. DROP TABLE IF EXISTS `t_machine_calculation`;
  1526. CREATE TABLE `t_machine_calculation` (
  1527. `calculation_id` int(11) NOT NULL AUTO_INCREMENT,
  1528. `data_id` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  1529. `affair_id` int(11) NOT NULL,
  1530. `tagIds` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  1531. `calculation_condition` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
  1532. `call_time` datetime(0) NOT NULL,
  1533. `calculation_key` varchar(13) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  1534. `calculation_time` datetime(0) NOT NULL ,
  1535. `calculation_time2` datetime(0) NOT NULL ,
  1536. `product_id` int(11) NOT NULL DEFAULT 0,
  1537. `single_weight` decimal(22, 2) NULL DEFAULT 0.00 ,
  1538. `pipe_weight` decimal(22, 2) NULL DEFAULT 0.00 ,
  1539. `machine_horse` bigint(22) NULL DEFAULT NULL,
  1540. `pan_head_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  1541. `public_note` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  1542. PRIMARY KEY (`calculation_id`, `data_id`) USING BTREE,
  1543. INDEX `call_time`(`call_time`) USING BTREE,
  1544. INDEX ` calculation_value`(`affair_id`, `calculation_key`, `calculation_condition`, `calculation_time`, `product_id`, `tagIds`, `calculation_time2`) USING BTREE
  1545. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  1546. -- ----------------------------
  1547. -- Table structure for t_ticket_calculation
  1548. -- ----------------------------
  1549. DROP TABLE IF EXISTS `t_ticket_calculation`;
  1550. CREATE TABLE `t_ticket_calculation` (
  1551. `calculation_id` int(11) NOT NULL AUTO_INCREMENT,
  1552. `data_id` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  1553. `affair_id` int(11) NOT NULL,
  1554. `tagIds` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  1555. `calculation_condition` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
  1556. `calculation_key` varchar(13) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  1557. `calculation_time` datetime(0) NOT NULL ,
  1558. `calculation_value` decimal(22, 6) NOT NULL DEFAULT 0.000000 ,
  1559. `call_time` datetime(0) NOT NULL,
  1560. `calculation_note` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  1561. `tag_numbers` tinyint(1) NULL DEFAULT 0,
  1562. `ticket_key` varchar(13) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  1563. `ticket_time` datetime(0) NOT NULL ,
  1564. PRIMARY KEY (`calculation_id`, `data_id`) USING BTREE,
  1565. INDEX `call_time`(`call_time`) USING BTREE,
  1566. INDEX ` calculation_value`(`affair_id`, `calculation_key`, `calculation_condition`, `calculation_time`, `tagIds`, `ticket_key`, `ticket_time`) USING BTREE
  1567. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  1568. -- ----------------------------
  1569. -- Table structure for t_customer_given
  1570. -- ----------------------------
  1571. DROP TABLE IF EXISTS `t_customer_given`;
  1572. CREATE TABLE `t_customer_given` (
  1573. `id` int(11) NOT NULL AUTO_INCREMENT,
  1574. `givenKey` varchar(50) NOT NULL,
  1575. `companyId` int(11) DEFAULT NULL,
  1576. PRIMARY KEY (`id`)
  1577. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  1578. -- ----------------------------
  1579. -- Table structure for t_customer_visible
  1580. -- ----------------------------
  1581. DROP TABLE IF EXISTS `t_customer_visible`;
  1582. CREATE TABLE `t_customer_visible` (
  1583. `id` int(20) NOT NULL AUTO_INCREMENT,
  1584. `userId` int(11) NOT NULL,
  1585. `objectKey` varchar(50) NOT NULL,
  1586. `companyId` int(11) DEFAULT NULL,
  1587. PRIMARY KEY (`id`),
  1588. KEY `userId` (`userId`,`objectKey`) USING BTREE,
  1589. CONSTRAINT `t_customer_visible_ibfk_2` FOREIGN KEY (`userId`) REFERENCES `t_user` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
  1590. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  1591. -- ----------------------------
  1592. -- Table structure for t_documentary_statistics
  1593. -- ----------------------------
  1594. DROP TABLE IF EXISTS `t_documentary_statistics`;
  1595. CREATE TABLE `t_documentary_statistics` (
  1596. `statistics_id` int(11) NOT NULL AUTO_INCREMENT,
  1597. `statistics_name` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  1598. `statistics_number` int(11) NOT NULL DEFAULT 0,
  1599. `permission` tinyint(1) NULL DEFAULT 0,
  1600. `user_ids` text CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  1601. `companyId` int(11) NULL DEFAULT NULL,
  1602. PRIMARY KEY (`statistics_id`) USING BTREE
  1603. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;
  1604. -- ----------------------------
  1605. -- Table structure for t_documentary_step
  1606. -- ----------------------------
  1607. DROP TABLE IF EXISTS `t_documentary_step`;
  1608. CREATE TABLE `t_documentary_step` (
  1609. `step_id` int(11) NOT NULL AUTO_INCREMENT,
  1610. `step_name` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '',
  1611. `step_number` int(11) NOT NULL,
  1612. `affairIds` text CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  1613. `companyId` int(11) NULL DEFAULT 0,
  1614. `ctime` datetime(0) NULL DEFAULT NULL,
  1615. `utime` datetime(0) NULL DEFAULT NULL,
  1616. PRIMARY KEY (`step_id`) USING BTREE
  1617. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;
  1618. -- ----------------------------
  1619. -- Table structure for t_report_account
  1620. -- ----------------------------
  1621. DROP TABLE IF EXISTS `t_report_account`;
  1622. CREATE TABLE `t_report_account` (
  1623. `account_id` int(11) NOT NULL AUTO_INCREMENT,
  1624. `account_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  1625. `account_bank_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',
  1626. `account_bank_number` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',
  1627. `account_cumulative` double(13, 2) NULL DEFAULT 0,
  1628. `ctime` datetime(0) NULL DEFAULT NULL,
  1629. `utime` datetime(0) NULL DEFAULT NULL,
  1630. `user_id` int(11) NULL DEFAULT NULL,
  1631. `permission` tinyint(1) NULL DEFAULT 1,
  1632. `see_user_ids` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  1633. PRIMARY KEY (`account_id`) USING BTREE
  1634. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  1635. -- ----------------------------
  1636. -- Table structure for t_inventory_frequently
  1637. -- ----------------------------
  1638. DROP TABLE IF EXISTS `t_inventory_frequently`;
  1639. CREATE TABLE `t_inventory_frequently` (
  1640. `frequently_id` int(11) NOT NULL AUTO_INCREMENT,
  1641. `user_id` int(11) NULL DEFAULT NULL,
  1642. `inventory_user_ids` text CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  1643. `utime` varchar(25) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '',
  1644. UNIQUE INDEX `frequently_id`(`frequently_id`) USING BTREE
  1645. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Compact;
  1646. -- ----------------------------
  1647. -- Table structure for t_inventory_notice
  1648. -- ----------------------------
  1649. DROP TABLE IF EXISTS `t_inventory_notice`;
  1650. CREATE TABLE `t_inventory_notice` (
  1651. `notice_id` int(11) NOT NULL AUTO_INCREMENT,
  1652. `user_id` int(11) NULL DEFAULT NULL,
  1653. `data_ids` text CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  1654. `ctime` varchar(25) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '',
  1655. `content` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  1656. `data_count` int(11) NULL DEFAULT NULL,
  1657. PRIMARY KEY (`notice_id`) USING BTREE,
  1658. UNIQUE INDEX `frequently_id`(`notice_id`) USING BTREE
  1659. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Compact;
  1660. -- ----------------------------
  1661. -- Table structure for t_inventory_notice_user
  1662. -- ----------------------------
  1663. DROP TABLE IF EXISTS `t_inventory_notice_user`;
  1664. CREATE TABLE `t_inventory_notice_user` (
  1665. `id` int(11) NOT NULL AUTO_INCREMENT,
  1666. `notice_id` int(11) NOT NULL,
  1667. `user_id` int(11) NOT NULL,
  1668. `ctime` varchar(25) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '',
  1669. `notice_state` tinyint(1) NULL DEFAULT NULL,
  1670. PRIMARY KEY (`id`) USING BTREE,
  1671. UNIQUE INDEX `id`(`id`) USING BTREE
  1672. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Compact;
  1673. -- ----------------------------
  1674. -- Table structure for t_screen
  1675. -- ----------------------------
  1676. DROP TABLE IF EXISTS `t_screen`;
  1677. CREATE TABLE `t_screen` (
  1678. `screen_id` int(11) NOT NULL AUTO_INCREMENT,
  1679. `user_id` int(11) NULL DEFAULT NULL,
  1680. `column_ids` text CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  1681. `utime` varchar(25) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '',
  1682. `screen_type` tinyint(1) NULL DEFAULT 1,
  1683. UNIQUE INDEX `frequently_id`(`screen_id`) USING BTREE
  1684. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Compact;
  1685. -- ----------------------------
  1686. -- Table structure for t_user_reminder
  1687. -- ----------------------------
  1688. DROP TABLE IF EXISTS `t_user_reminder`;
  1689. CREATE TABLE `t_user_reminder` (
  1690. `user_id` int(11) NOT NULL,
  1691. `sale_price_reminder` tinyint(1) DEFAULT 0,
  1692. `purchase_price_reminder` tinyint(1) DEFAULT 0,
  1693. `documentary_add_reminder` tinyint(1) DEFAULT 0,
  1694. `documentary_add_son_reminder` tinyint(1) DEFAULT 0,
  1695. `documentary_join_reminder` tinyint(1) DEFAULT 0,
  1696. `documentary_new_affair_join_reminder` tinyint(1) NULL DEFAULT 0,
  1697. `product_image_shear` tinyint(1) NULL DEFAULT 0,
  1698. `documentary_copy_order` tinyint(1) NULL DEFAULT 0,
  1699. PRIMARY KEY (`user_id`),
  1700. UNIQUE KEY `user_id` (`user_id`) USING BTREE
  1701. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=COMPACT;
  1702. -- ----------------------------
  1703. -- Table structure for t_notification
  1704. -- ----------------------------
  1705. DROP TABLE IF EXISTS `t_notification`;
  1706. CREATE TABLE `t_notification` (
  1707. `notification_id` int(0) UNSIGNED NOT NULL AUTO_INCREMENT,
  1708. `notification_code` int(11) NULL,
  1709. `is_read` int(2) NULL,
  1710. `ctime` datetime(0) NULL,
  1711. PRIMARY KEY (`notification_id`)
  1712. );
  1713. -- ----------------------------
  1714. -- Function structure for Fun_GetPY
  1715. -- ----------------------------
  1716. SET GLOBAL log_bin_trust_function_creators = 1;
  1717. delimiter ;;
  1718. CREATE FUNCTION IF NOT EXISTS `Fun_GetPY`(in_string VARCHAR(255) CHARSET utf8)
  1719. RETURNS varchar(255) CHARSET utf8
  1720. BEGIN
  1721. #截取字符串,每次做截取后的字符串存放在该变量中,初始为函数参数in_string值
  1722. DECLARE tmp_str VARCHAR(255) CHARSET gbk DEFAULT '' ;
  1723. #tmp_str的长度
  1724. DECLARE tmp_len SMALLINT DEFAULT 0;
  1725. #tmp_str的长度
  1726. DECLARE tmp_loc SMALLINT DEFAULT 0;
  1727. #截取字符,每次 left(tmp_str,1) 返回值存放在该变量中
  1728. DECLARE tmp_char VARCHAR(2) CHARSET gbk DEFAULT '';
  1729. #结果字符串
  1730. DECLARE tmp_rs VARCHAR(255)CHARSET gbk DEFAULT '';
  1731. #拼音字符,存放单个汉字对应的拼音首字符
  1732. DECLARE tmp_cc VARCHAR(2) CHARSET gbk DEFAULT '';
  1733. #初始化,将in_string赋给tmp_str
  1734. SET tmp_str = in_string;
  1735. #初始化长度
  1736. SET tmp_len = LENGTH(tmp_str);
  1737. #如果被计算的tmp_str长度大于0则进入该while
  1738. WHILE tmp_len > 0 DO
  1739. #获取tmp_str最左端的首个字符,注意这里是获取首个字符,该字符可能是汉字,也可能不是。
  1740. SET tmp_char = LEFT(tmp_str,1);
  1741. #左端首个字符赋值给拼音字符
  1742. SET tmp_cc = tmp_char;
  1743. #获取字符的编码范围的位置,为了确认汉字拼音首字母是那一个
  1744. SET tmp_loc=INTERVAL(CONV(HEX(tmp_char),16,10),0xB0A1,0xB0C5,0xB2C1,0xB4EE,0xB6EA,0xB7A2,0xB8C1,0xB9FE,0xBBF7,0xBFA6,0xC0AC
  1745. ,0xC2E8,0xC4C3,0xC5B6,0xC5BE,0xC6DA,0xC8BB,0xC8F6,0xCBFA,0xCDDA ,0xCEF4,0xD1B9,0xD4D1);
  1746. #判断左端首个字符是多字节还是单字节字符,要是多字节则认为是汉字且作以下拼音获取,要是单字节则不处理。如果是多字节字符但是不在对应的编码范围之内,即对应的不是大写字母则也不做处理,这样数字或者特殊字符就保持原样了
  1747. IF (LENGTH(tmp_char)>1 AND tmp_loc>0 AND tmp_loc<24) THEN
  1748. #获得汉字拼音首字符
  1749. SELECT ELT(tmp_loc,'a','b','c','d','e','f','g','h','j','k','l','m','n','o','p','q','r','s','t','w','x','y','z') INTO tmp_cc;
  1750. END IF;
  1751. IF ASCII(tmp_cc)>96 AND ASCII(tmp_cc) <123
  1752. THEN
  1753. #将当前tmp_str左端首个字符拼音首字符与返回字符串拼接
  1754. SET tmp_rs = CONCAT(tmp_rs,tmp_cc);
  1755. ELSE
  1756. SET tmp_rs = CONCAT(tmp_rs,tmp_char);
  1757. END IF;
  1758. #将tmp_str左端首字符去除
  1759. SET tmp_str = SUBSTRING(tmp_str,2);
  1760. #计算当前字符串长度
  1761. SET tmp_len = LENGTH(tmp_str);
  1762. END WHILE;
  1763. #返回结果字符串
  1764. RETURN tmp_rs;
  1765. END
  1766. ;;
  1767. delimiter ;
  1768. SET FOREIGN_KEY_CHECKS = 1;