--
-- Host: localhost    Database: NoteEZ
-- ------------------------------------------------------


--
-- Table structure for table `conference_subtitle`
--

CREATE TABLE `conference_subtitle` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `member_id` int(11) NOT NULL,
  `conference_name` text DEFAULT NULL,
  `source_language` varchar(20) DEFAULT NULL,
  `target_language` varchar(20) DEFAULT NULL,
  `conference_content` text DEFAULT NULL,
  `subtitle_path` text DEFAULT NULL,
  `process_time` datetime DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `member_id` (`member_id`),
  CONSTRAINT `conference_subtitle_ibfk_1` FOREIGN KEY (`member_id`) REFERENCES `member` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `conference_subtitle`
--

INSERT INTO `conference_subtitle` VALUES (1,1,'2022-04-04 20:54:36 會議','cmn-Hant-TW',NULL,NULL,NULL,'2022-04-04 12:54:36'),(2,1,'2022-04-04 20:57:28 會議','cmn-Hant-TW',NULL,NULL,NULL,'2022-04-04 12:57:28'),(3,1,'2022-04-04 20:59:46 會議','cmn-Hant-TW',NULL,NULL,NULL,'2022-04-04 12:59:46'),(4,1,'2022-04-04 21:01:32 會議','cmn-Hant-TW',NULL,NULL,NULL,'2022-04-04 13:01:32'),(5,1,'meeting room test!','cmn-Hant-TW',NULL,NULL,NULL,'2022-04-04 13:02:38');


