<?xml version="1.0" encoding="UTF-8"?> <schemadesigner version="6.5"> <source> <database charset="utf8" collation="utf8_bin">lottery_db</database> </source> <canvas zoom="100"> <tables> <table name="lottery" view="colnames"> <left>60</left> <top>439</top> <width>179</width> <height>197</height> <sql_create_table>CREATE TABLE `lottery` ( `id` bigint(20) NOT NULL COMMENT 'product_turn', `lottery_detail` blob COMMENT '[transection_id: 1, display_name: Ali, avatar: http://tronsis.com/images/abc.jpg, location: shenzhen guangdong, ip_address: 10.2.3.4, units: 5, time_stamp: 26, 2, 2016 3:45:45 GMT, lottery_numbers {1,2,3,4,5} ', `winner_lottery_number` varchar(20) COLLATE utf8_bin DEFAULT NULL, `winner` bigint(20) DEFAULT NULL, `winner_info` text COLLATE utf8_bin COMMENT 'wining user', `status_` varchar(20) COLLATE utf8_bin DEFAULT NULL, `timestamp_` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), CONSTRAINT `FK_lottery` FOREIGN KEY (`id`) REFERENCES `product_turn` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin</sql_create_table> </table> <table name="product" view="colnames"> <left>625</left> <top>678</top> <width>137</width> <height>214</height> <sql_create_table>CREATE TABLE `product` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `name` varchar(100) COLLATE utf8_bin DEFAULT NULL, `icon` text COLLATE utf8_bin, `introduction` text COLLATE utf8_bin, `images` text COLLATE utf8_bin, `category` bigint(20) DEFAULT NULL, `status_` varchar(20) COLLATE utf8_bin DEFAULT 'active', `timestamp_` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin</sql_create_table> </table> <table name="product_category" view="colnames"> <left>358</left> <top>423</top> <width>143</width> <height>146</height> <sql_create_table>CREATE TABLE `product_category` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `name` varchar(100) COLLATE utf8_bin DEFAULT NULL, `icon` blob, `status_` varchar(20) COLLATE utf8_bin DEFAULT 'active', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin</sql_create_table> </table> <table name="product_turn" view="colnames"> <left>353</left> <top>581</top> <width>182</width> <height>333</height> <sql_create_table>CREATE TABLE `product_turn` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `product_id` bigint(20) DEFAULT NULL, `product_name` varchar(100) COLLATE utf8_bin DEFAULT NULL, `product_icon` text COLLATE utf8_bin, `product_introduction` text COLLATE utf8_bin, `product_images` text COLLATE utf8_bin, `product_category` bigint(20) DEFAULT NULL, `turn_count` int(11) DEFAULT '1', `total_units` int(11) DEFAULT '0', `paid_units` int(11) DEFAULT '0', `turn_expiry` date DEFAULT NULL, `status_` varchar(20) COLLATE utf8_bin DEFAULT 'active' COMMENT 'active/computing/closed/expired', `count_down_delay` int(11) DEFAULT NULL COMMENT 'Seconds', `result_time` datetime DEFAULT NULL, `start_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `recommended_order` int(11) DEFAULT NULL, `modified_by` varchar(50) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_bin</sql_create_table> </table> <table name="review_post" view="colnames"> <left>677</left> <top>402</top> <width>117</width> <height>214</height> <sql_create_table>CREATE TABLE `review_post` ( `id` bigint(20) NOT NULL COMMENT 'product_turn', `product_info` text COLLATE utf8_bin NOT NULL COMMENT 'json', `images` text COLLATE utf8_bin NOT NULL COMMENT 'json{images list}', `description` varchar(255) COLLATE utf8_bin NOT NULL, `user` bigint(20) NOT NULL, `liked_by` text COLLATE utf8_bin COMMENT 'json{user_ids}', `status_` varchar(20) COLLATE utf8_bin DEFAULT 'active', `timestamp_` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `FK_review_post_user` (`user`), CONSTRAINT `FK_review_post` FOREIGN KEY (`id`) REFERENCES `product_turn` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `FK_review_post_user` FOREIGN KEY (`user`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin</sql_create_table> </table> <table name="sys_activity_and_news" view="colnames"> <left>27</left> <top>26</top> <width>191</width> <height>180</height> <sql_create_table>CREATE TABLE `sys_activity_and_news` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `preview_image` text COLLATE utf8_bin, `preview_summery` varchar(200) COLLATE utf8_bin DEFAULT NULL, `detail_info` text COLLATE utf8_bin, `type_` varchar(20) COLLATE utf8_bin DEFAULT 'news' COMMENT 'news/activity', `timestamp_` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_bin</sql_create_table> </table> <table name="sys_coin_transection" view="colnames"> <left>35</left> <top>219</top> <width>166</width> <height>146</height> <sql_create_table>CREATE TABLE `sys_coin_transection` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `coin_holder` bigint(20) DEFAULT NULL, `coin` int(11) DEFAULT NULL, `timestamp_` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin</sql_create_table> </table> <table name="sys_faq" view="colnames"> <left>248</left> <top>24</top> <width>113</width> <height>146</height> <sql_create_table>CREATE TABLE `sys_faq` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `title` text COLLATE utf8_bin, `detail` text COLLATE utf8_bin, `timestamp_` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_bin</sql_create_table> </table> <table name="sys_feedback" view="colnames"> <left>248</left> <top>189</top> <width>140</width> <height>163</height> <sql_create_table>CREATE TABLE `sys_feedback` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `feedback_text` varchar(200) COLLATE utf8_bin DEFAULT NULL, `feedback_image` text COLLATE utf8_bin, `feedback_by` varchar(100) COLLATE utf8_bin DEFAULT NULL, `timestamp_` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COLLATE=utf8_bin</sql_create_table> </table> <table name="sys_message" view="colnames"> <left>420</left> <top>13</top> <width>129</width> <height>180</height> <sql_create_table>CREATE TABLE `sys_message` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `title` varchar(100) COLLATE utf8_bin DEFAULT NULL, `detail` text COLLATE utf8_bin, `icon` text COLLATE utf8_bin COMMENT 'BASE64', `message_type` varchar(20) COLLATE utf8_bin DEFAULT 'system' COMMENT 'system/delivery-message', `timestamp_` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_bin</sql_create_table> </table> <table name="sys_payment_transection" view="colnames"> <left>416</left> <top>203</top> <width>189</width> <height>197</height> <sql_create_table>CREATE TABLE `sys_payment_transection` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `paid_by` bigint(20) DEFAULT NULL, `thirdparty_name` varchar(50) COLLATE utf8_bin DEFAULT 'n/a' COMMENT 'wechat/alipay', `thirdparty_transection_id` varchar(100) COLLATE utf8_bin DEFAULT NULL, `amount` int(11) DEFAULT NULL COMMENT 'RMB , real money', `coins` int(11) DEFAULT NULL, `timestamp_` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin</sql_create_table> </table> <table name="user" view="colnames"> <left>1067</left> <top>254</top> <width>133</width> <height>311</height> <sql_create_table>CREATE TABLE `user` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `username` varchar(20) COLLATE utf8_bin NOT NULL, `password` varchar(50) COLLATE utf8_bin NOT NULL, `real_name` varchar(50) COLLATE utf8_bin DEFAULT NULL, `display_picture` text COLLATE utf8_bin, `dob` date DEFAULT NULL, `gender` int(11) DEFAULT '0', `points` int(11) DEFAULT NULL, `coins` int(11) DEFAULT NULL COMMENT 'real money', `qq_address` varchar(20) COLLATE utf8_bin DEFAULT NULL, `phone_address` varchar(20) COLLATE utf8_bin DEFAULT NULL, `postal_address` text COLLATE utf8_bin COMMENT 'json:{name, phone, province, city, district, address, isDefault}', `status_` varchar(20) COLLATE utf8_bin DEFAULT 'active', `timestamp_` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `username_index` (`username`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_bin</sql_create_table> </table> <table name="user_cart" view="colnames"> <left>1057</left> <top>593</top> <width>119</width> <height>163</height> <sql_create_table>CREATE TABLE `user_cart` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `user` bigint(20) DEFAULT NULL, `product_turn` bigint(20) DEFAULT NULL, `units` int(11) DEFAULT NULL, `timestamp_` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `FK_cart` (`product_turn`), CONSTRAINT `FK_cart` FOREIGN KEY (`product_turn`) REFERENCES `product_turn` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_bin</sql_create_table> </table> <table name="user_share_log" view="colnames"> <left>1224</left> <top>367</top> <width>137</width> <height>129</height> <sql_create_table>CREATE TABLE `user_share_log` ( `user_id` bigint(20) NOT NULL, `last_share_date` date DEFAULT NULL, `timestamp_` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin</sql_create_table> </table> <table name="user_token" view="colnames"> <left>1228</left> <top>208</top> <width>113</width> <height>146</height> <sql_create_table>CREATE TABLE `user_token` ( `token` varchar(100) COLLATE utf8_bin NOT NULL, `user` bigint(20) DEFAULT NULL, `user_agent` varchar(100) COLLATE utf8_bin DEFAULT 'ios-UIODKJIERUI' COMMENT 'UDID/IMEI', `timestamp_` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`token`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin</sql_create_table> </table> <table name="user_wish_list" view="colnames"> <left>1232</left> <top>520</top> <width>140</width> <height>180</height> <sql_create_table>CREATE TABLE `user_wish_list` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `title` varchar(100) COLLATE utf8_bin DEFAULT NULL, `description` varchar(200) COLLATE utf8_bin DEFAULT NULL, `status_` varchar(20) COLLATE utf8_bin DEFAULT 'active', `created_by` bigint(20) DEFAULT NULL, `timestamp_` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COLLATE=utf8_bin</sql_create_table> </table> <table name="winner_order" view="colnames"> <left>60</left> <top>648</top> <width>190</width> <height>248</height> <sql_create_table>CREATE TABLE `winner_order` ( `id` bigint(20) NOT NULL COMMENT 'product_turn', `sn` varchar(20) COLLATE utf8_bin NOT NULL, `address` text COLLATE utf8_bin COMMENT 'json{Realname, address, district, city, province}', `units_by_winner` int(11) DEFAULT NULL, `status_` varchar(20) COLLATE utf8_bin DEFAULT 'win' COMMENT 'win/confirmed/shipped/received', `user` bigint(20) DEFAULT NULL COMMENT 'winning user id', `lottery` bigint(20) NOT NULL, `delivery_company_name` varchar(200) COLLATE utf8_bin DEFAULT NULL, `delivery_company_sn` varchar(100) COLLATE utf8_bin DEFAULT NULL, `timestamp_` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), CONSTRAINT `FK_winner_order` FOREIGN KEY (`id`) REFERENCES `product_turn` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin</sql_create_table> </table> <table name="sys_search_keyword_frequency" view="colnames"> <left>575</left> <top>18</top> <width>225</width> <height>129</height> <sql_create_table>CREATE TABLE `sys_search_keyword_frequency` ( `keyword` varchar(200) COLLATE utf8_bin NOT NULL, `frequency` int(11) DEFAULT NULL, `last_time_used` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`keyword`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin</sql_create_table> </table> </tables> </canvas> </schemadesigner>