mkt_student_market_activity.sql 681 B

1234567891011121314
  1. CREATE TABLE `mkt_student_market_activity` (
  2. `id` int NOT NULL AUTO_INCREMENT,
  3. `sut_id` int DEFAULT NULL,
  4. `ma_id` int DEFAULT NULL,
  5. `create_by` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  6. `create_time` datetime DEFAULT NULL,
  7. `last_update_by` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  8. `last_update_time` datetime DEFAULT NULL,
  9. `del_flag` int DEFAULT NULL,
  10. PRIMARY KEY (`id`),
  11. KEY `IDX_mkt_student_market_activity_ma_id` (`ma_id`),
  12. KEY `IDX_mkt_student_market_activity_sut_id` (`sut_id`),
  13. KEY `idx_sutid_maid` (`sut_id`,`ma_id`)
  14. ) ENGINE=InnoDB AUTO_INCREMENT=30863 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;