<?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>