CREATE TABLE `table_1` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'column_1', `prod_name` varchar(20) NOT NULL COMMENT 'column_2', `prod_type` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT 'column_3 0:活期 1:定期', `start_time` time NOT NULL COMMENT '停止交易开始时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='This is table 1;'; CREATE TABLE `table_2` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `user_id` bigint(20) unsigned NOT NULL COMMENT '用户id', `user_name` varchar(50) NOT NULL COMMENT '用户名称', `prod_id` bigint(20) unsigned NOT NULL COMMENT '产品id', `interest_date` date DEFAULT NULL COMMENT '计息日期', PRIMARY KEY (`id`) USING BTREE, UNIQUE KEY `uk_user_id_prod_id` (`user_id`,`prod_id`) USING BTREE ) COMMENT='This is table 2';
Convert