-- MySQL dump 10.13 Distrib 26.7.0, for macos26.6 (arm64)
--
-- Host: localhost Database: e_conference
-- ------------------------------------------------------
-- Server version 26.7.0
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `Certificate`
--
DROP TABLE IF EXISTS `Certificate`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `Certificate` (
`id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`userId` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`conferenceId` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`certificateId` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`fileUrl` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`issuedAt` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
`source` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'GENERATED',
`submissionId` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `Certificate_certificateId_key` (`certificateId`),
KEY `Certificate_certificateId_idx` (`certificateId`),
KEY `Certificate_userId_conferenceId_idx` (`userId`,`conferenceId`),
KEY `Certificate_conferenceId_fkey` (`conferenceId`),
KEY `Certificate_submissionId_idx` (`submissionId`),
CONSTRAINT `Certificate_conferenceId_fkey` FOREIGN KEY (`conferenceId`) REFERENCES `Conference` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `Certificate_submissionId_fkey` FOREIGN KEY (`submissionId`) REFERENCES `Submission` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `Certificate_userId_fkey` FOREIGN KEY (`userId`) REFERENCES `User` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `Certificate`
--
LOCK TABLES `Certificate` WRITE;
/*!40000 ALTER TABLE `Certificate` DISABLE KEYS */;
INSERT INTO `Certificate` VALUES ('d95d74a1-f769-490f-a311-8e2b2e445b32','1278684c-8ed3-4710-81fc-e32f00658d97','45d20720-3b24-4a7a-8ee8-04b09b065dc7','PRESENTER','CERT-ICBME25-PRES-001',NULL,'2025-11-12 16:00:00.000','GENERATED',NULL);
/*!40000 ALTER TABLE `Certificate` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `CoAuthor`
--
DROP TABLE IF EXISTS `CoAuthor`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `CoAuthor` (
`id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`submissionId` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`affiliation` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`notifiedAt` datetime(3) DEFAULT NULL,
`country` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `CoAuthor_submissionId_fkey` (`submissionId`),
CONSTRAINT `CoAuthor_submissionId_fkey` FOREIGN KEY (`submissionId`) REFERENCES `Submission` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `CoAuthor`
--
LOCK TABLES `CoAuthor` WRITE;
/*!40000 ALTER TABLE `CoAuthor` DISABLE KEYS */;
INSERT INTO `CoAuthor` VALUES ('286b0ff7-489d-4ad3-82df-73c50429d476','783d0dbc-f6ea-421f-855d-a7921793f927','Dr. Bambang Sudarmono, S.T., M.Eng.','bambang.s@ugm.ac.id','Universitas Gadjah Mada',NULL,NULL),('339cfe05-3e59-4100-8273-734e8c8f096e','ea7d2966-09a9-4fed-8acd-d4780d5b5a3f','Prof. Ir. Bambang Riyanto, Ph.D.','bambang.r@ui.ac.id','Universitas Indonesia',NULL,NULL),('470c3e16-a849-4aab-9557-60d4c49bc671','b1a2e7af-40af-455e-8d9e-47ec6dcc0ea0','Eng. Farhan Pratama, M.Sc.','farhan.p@itb.ac.id','Institut Teknologi Bandung',NULL,NULL),('a6be411d-c930-4fc0-a166-d73633d02cdc','5dc952e2-b3e4-48c0-bc97-7a3795762cda','Andi Susanto, S.T., M.T.','andi.susanto@unair.ac.id','Universitas Airlangga',NULL,NULL),('c203ee11-039f-4be6-b1ec-1def495fc53a','ea7d2966-09a9-4fed-8acd-d4780d5b5a3f','dr. Hendra Wijaya, Sp.M.','h.wijaya@rsui.co.id','Rumah Sakit Universitas Indonesia',NULL,NULL);
/*!40000 ALTER TABLE `CoAuthor` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `Conference`
--
DROP TABLE IF EXISTS `Conference`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `Conference` (
`id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`acronym` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`description` text COLLATE utf8mb4_unicode_ci NOT NULL,
`website` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`logoUrl` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`bannerUrl` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`venue` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`venueType` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'ONLINE',
`reviewType` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'DOUBLE_BLIND',
`minReviewers` int NOT NULL DEFAULT '2',
`status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'DRAFT',
`issn` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`language` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'BOTH',
`abstractDeadline` datetime(3) DEFAULT NULL,
`submissionDeadline` datetime(3) DEFAULT NULL,
`reviewDeadline` datetime(3) DEFAULT NULL,
`notificationDate` datetime(3) DEFAULT NULL,
`cameraReadyDeadline` datetime(3) DEFAULT NULL,
`registrationDeadline` datetime(3) DEFAULT NULL,
`startDate` datetime(3) NOT NULL,
`endDate` datetime(3) NOT NULL,
`createdAt` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
`updatedAt` datetime(3) NOT NULL,
`isPublic` tinyint(1) NOT NULL DEFAULT '1',
`maxFileSizeMb` int NOT NULL DEFAULT '10',
`maxPages` int NOT NULL DEFAULT '16',
`minPages` int NOT NULL DEFAULT '4',
`tagline` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`posterUrl` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`meetingUrl` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`whatsappGroupUrl` text COLLATE utf8mb4_unicode_ci,
`signatureUrl` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`allowedPaperFormat` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'WORD',
`requireReviewerFile` tinyint(1) NOT NULL DEFAULT '0',
`reviewRubricConfig` text COLLATE utf8mb4_unicode_ci,
`fullPaperDeadline` datetime(3) DEFAULT NULL,
`isFullPaperUploadOpen` tinyint(1) NOT NULL DEFAULT '0',
`submissionFormatMode` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'FULL_PAPER',
`maxAbstractWords` int DEFAULT '500',
`maxCoAuthors` int DEFAULT '10',
`maxKeywords` int DEFAULT '6',
`maxTitleWords` int DEFAULT '50',
`minAbstractWords` int DEFAULT '10',
`minKeywords` int DEFAULT '3',
`minTitleWords` int DEFAULT '1',
`presentationDeadline` datetime(3) DEFAULT NULL,
`isSchedulePublished` tinyint(1) NOT NULL DEFAULT '1',
`contactPerson` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`contactWhatsapp` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`featuredOrder` int NOT NULL DEFAULT '0',
`isFeatured` tinyint(1) NOT NULL DEFAULT '0',
`bankAccountHolder` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`bankAccountNumber` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`bankName` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`bankPaymentInstructions` text COLLATE utf8mb4_unicode_ci,
`paymentMode` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'BOTH',
`defaultDocumentLanguage` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'EN',
`letterheadLine1` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`letterheadLine2` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`letterheadAddress` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`letterheadWebsite` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`chairName` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`chairTitle` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`conferenceTime` text COLLATE utf8mb4_unicode_ci,
`city` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`letterheadImageUrl` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`loaAcceptanceText` text COLLATE utf8mb4_unicode_ci,
`loaConfirmationText` text COLLATE utf8mb4_unicode_ci,
`loaDate` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`loaOpeningText` text COLLATE utf8mb4_unicode_ci,
`receiptLetterheadImageUrl` text COLLATE utf8mb4_unicode_ci,
`receiptLetterheadLine1` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`receiptLetterheadLine2` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`receiptLetterheadAddress` text COLLATE utf8mb4_unicode_ci,
`receiptLetterheadWebsite` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `Conference_status_idx` (`status`),
KEY `Conference_isFeatured_featuredOrder_idx` (`isFeatured`,`featuredOrder`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `Conference`
--
LOCK TABLES `Conference` WRITE;
/*!40000 ALTER TABLE `Conference` DISABLE KEYS */;
INSERT INTO `Conference` VALUES ('45d20720-3b24-4a7a-8ee8-04b09b065dc7','International Conference on Biomedical Engineering 2025','ICBME 2025','Prosiding resmi hasil publikasi konferensi internasional teknik biomedis dan teknologi kesehatan digital.',NULL,NULL,NULL,'Grand Mercure Hotel, Yogyakarta','OFFLINE','DOUBLE_BLIND',2,'COMPLETED','2987-1234','BOTH',NULL,NULL,NULL,NULL,NULL,NULL,'2025-11-10 08:00:00.000','2025-11-12 17:00:00.000','2026-09-10 17:46:07.969','2026-09-10 17:46:07.969',1,10,16,4,'Engineering Breakthroughs for Next-Generation Healthcare',NULL,NULL,NULL,NULL,'WORD',0,NULL,NULL,0,'FULL_PAPER',500,10,6,50,10,3,1,NULL,1,NULL,NULL,3,1,NULL,NULL,NULL,NULL,'BOTH','EN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('55e4695c-c15d-4774-aae0-0d2bb2f1d2b4','International Conference on Sustainable Energy and Technology 2026','ICSET 2026','Konferensi internasional tahunan yang berfokus pada transisi energi terbarukan, smart grid, teknologi penyimpanan baterai, dan dekarbonisasi industri. Menggunakan seleksi berbasis Abstrak Ilmiah (Abstract Only) dengan opsi upload naskah lengkap setelah penerimaan abstrak.','https://icset2026.example.com',NULL,NULL,'Auditorium Fakultas Teknik UGM, Yogyakarta & Hybrid Zoom','ONLINE','DOUBLE_BLIND',2,'DRAFT',NULL,'BOTH','2026-10-15 23:59:59.000','2026-10-15 23:59:59.000','2026-11-20 23:59:59.000','2026-11-25 23:59:59.000','2026-12-05 23:59:59.000','2026-12-01 23:59:59.000','2026-12-15 08:00:00.000','2026-12-16 17:00:00.000','2026-09-10 17:46:07.927','2026-09-11 13:57:09.757',1,10,16,4,'Accelerating the Clean Energy Transition Through Engineering & Applied Research',NULL,NULL,'https://chat.whatsapp.com/TEST-GROUP-12345','/uploads/signatures/1789063880642-tanda_tangan_danu.png','WORD',0,NULL,'2026-11-15 23:59:59.000',0,'FULL_PAPER',350,10,6,30,100,3,3,NULL,1,'Dr. Ir. Agus Setiawan (Conference Chair)','6281398765432',2,1,'Panitia ICSET UGM 2026','023-8899-771','Bank BNI','Transfer ke rekening BNI di atas dan cantumkan Kode Registrasi. Konfirmasi pembayaran akan diverifikasi dalam 1x24 jam oleh panitia.','BOTH','EN','KEMENTERIAN PENDIDIKAN TINGGI, SAINS, DAN TEKNOLOGI','UNIVERSITAS GADJAH MADA - FAKULTAS TEKNIK','Jl. Grafika No. 2, Kampus UGM, Yogyakarta 55281 | Telp: (0274) 513665','Laman: https://icset2026.ugm.ac.id | Email: icset@ugm.ac.id','Dr. Ir. Agus Setiawan, S.T., M.Eng., IPU.','General Chair of ICSET 2026','09.00 – 16.30 WIB','Yogyakarta',NULL,NULL,NULL,NULL,NULL,NULL,'UNIVERSITAS GADJAH MADA','BENDAHARA & REGISTRASI KEUANGAN ICSET 2026','Kantor Administrasi FT UGM, Jl. Grafika 2 Yogyakarta','Laman: https://icset2026.ugm.ac.id'),('c9692b30-d5bf-4255-9ea6-3769ca4483a8','International Conference on Artificial Intelligence and Data Science 2026','ICAIDS 2026','Konferensi internasional tahunan yang mempertemukan para peneliti, akademisi, dan praktisi industri global untuk mendiskusikan inovasi mutakhir di bidang kecerdasan buatan, machine learning, dan analisis big data dengan format naskah lengkap (Full Paper).','https://icaids2026.example.com',NULL,NULL,'Balairung Universitas Indonesia, Kampus Depok & Hybrid Zoom','HYBRID','DOUBLE_BLIND',2,'OPEN',NULL,'BOTH',NULL,'2026-09-20 23:59:59.000','2026-10-15 23:59:59.000','2026-10-25 23:59:59.000','2026-11-05 23:59:59.000','2026-11-01 23:59:59.000','2026-11-15 08:00:00.000','2026-11-17 17:00:00.000','2026-09-10 17:46:07.885','2026-09-10 17:46:07.885',1,20,12,6,'Bridging Artificial Intelligence Research with Real-World Scientific Impact',NULL,NULL,NULL,NULL,'WORD',0,NULL,NULL,1,'FULL_PAPER',350,10,6,30,50,3,3,NULL,1,'Dr. Ahmad Fauzi (General Chair)','6281234567890',1,1,'Panitia Konferensi ICAIDS UI','157-00-0987654-1','Bank Mandiri','Silakan transfer sesuai nominal ke rekening Mandiri di atas. Cantumkan Kode Registrasi pada berita transfer dan unggah bukti transfer pada menu Registrasi Saya.','BOTH','EN','KEMENTERIAN PENDIDIKAN TINGGI, SAINS, DAN TEKNOLOGI','UNIVERSITAS INDONESIA - FAKULTAS ILMU KOMPUTER','Kampus UI Depok, Jawa Barat 16424 | Telp: (021) 7863419','Laman: https://cs.ui.ac.id/icaids2026 | Email: icaids@ui.ac.id','Prof. Dr. Ir. Ahmad Fauzi, M.Kom.','General Chair of ICAIDS 2026','08.30 – 17.00 WIB','Depok',NULL,NULL,NULL,NULL,NULL,NULL,'UNIVERSITAS INDONESIA','PANITIA PELAKSANA & BENDAHARA ICAIDS 2026','Gedung Dekanat Fasilkom UI, Kampus UI Depok','Laman: https://cs.ui.ac.id/icaids2026');
/*!40000 ALTER TABLE `Conference` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ConferenceMember`
--
DROP TABLE IF EXISTS `ConferenceMember`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ConferenceMember` (
`id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`userId` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`conferenceId` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`role` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`acceptedAt` datetime(3) DEFAULT NULL,
`invitedAt` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
PRIMARY KEY (`id`),
UNIQUE KEY `ConferenceMember_userId_conferenceId_role_key` (`userId`,`conferenceId`,`role`),
KEY `ConferenceMember_conferenceId_role_idx` (`conferenceId`,`role`),
CONSTRAINT `ConferenceMember_conferenceId_fkey` FOREIGN KEY (`conferenceId`) REFERENCES `Conference` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `ConferenceMember_userId_fkey` FOREIGN KEY (`userId`) REFERENCES `User` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `ConferenceMember`
--
LOCK TABLES `ConferenceMember` WRITE;
/*!40000 ALTER TABLE `ConferenceMember` DISABLE KEYS */;
INSERT INTO `ConferenceMember` VALUES ('1152cc45-de7d-4b04-b4d3-01c179b3f8c1','fc11a5b2-6db3-46e0-8fdf-9209059cc678','c9692b30-d5bf-4255-9ea6-3769ca4483a8','CHAIR','2026-09-10 17:46:07.887','2026-09-10 17:46:07.888'),('12325e08-088f-4010-9205-26f9d564895a','84240fe9-8f1d-4a12-a171-7739d30cbce0','c9692b30-d5bf-4255-9ea6-3769ca4483a8','REVIEWER','2026-09-10 17:46:07.887','2026-09-10 17:46:07.888'),('1a777527-fb72-49ff-b4d8-f10f1dab824b','cb635147-39a2-4db7-91e9-14f513500bbd','c9692b30-d5bf-4255-9ea6-3769ca4483a8','REVIEWER','2026-09-10 17:46:07.887','2026-09-10 17:46:07.888'),('6fc5a5de-d5ca-4574-83d0-3cc983a87559','1278684c-8ed3-4710-81fc-e32f00658d97','c9692b30-d5bf-4255-9ea6-3769ca4483a8','AUTHOR','2026-09-10 17:46:07.887','2026-09-10 17:46:07.888'),('75abeedb-7333-4f0f-9746-d4aff8731d33','98e1f8f3-bcf7-415e-a08b-cad8fe098d55','c9692b30-d5bf-4255-9ea6-3769ca4483a8','AUTHOR','2026-09-10 17:46:07.887','2026-09-10 17:46:07.888'),('7e490cab-00f4-4568-90e5-8658832bf63c','1278684c-8ed3-4710-81fc-e32f00658d97','55e4695c-c15d-4774-aae0-0d2bb2f1d2b4','AUTHOR','2026-09-10 17:46:07.929','2026-09-10 17:46:07.930'),('ac58c6ff-a815-4322-a1a3-34c3580e83c9','84240fe9-8f1d-4a12-a171-7739d30cbce0','55e4695c-c15d-4774-aae0-0d2bb2f1d2b4','REVIEWER','2026-09-10 17:46:07.929','2026-09-10 17:46:07.930'),('b61747de-7637-40c8-9808-bed0c77d2dd2','fc11a5b2-6db3-46e0-8fdf-9209059cc678','55e4695c-c15d-4774-aae0-0d2bb2f1d2b4','CHAIR','2026-09-10 17:46:07.929','2026-09-10 17:46:07.930'),('c4353e10-b140-4a50-84b9-a041930888ef','cb635147-39a2-4db7-91e9-14f513500bbd','55e4695c-c15d-4774-aae0-0d2bb2f1d2b4','REVIEWER','2026-09-10 17:46:07.929','2026-09-10 17:46:07.930'),('e24e3c12-2157-4252-9db9-79764dd8487e','98e1f8f3-bcf7-415e-a08b-cad8fe098d55','55e4695c-c15d-4774-aae0-0d2bb2f1d2b4','AUTHOR','2026-09-10 17:46:07.929','2026-09-10 17:46:07.930');
/*!40000 ALTER TABLE `ConferenceMember` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ConflictOfInterest`
--
DROP TABLE IF EXISTS `ConflictOfInterest`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ConflictOfInterest` (
`id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`submissionId` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`reviewerId` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`reason` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `ConflictOfInterest_submissionId_reviewerId_key` (`submissionId`,`reviewerId`),
CONSTRAINT `ConflictOfInterest_submissionId_fkey` FOREIGN KEY (`submissionId`) REFERENCES `Submission` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `ConflictOfInterest`
--
LOCK TABLES `ConflictOfInterest` WRITE;
/*!40000 ALTER TABLE `ConflictOfInterest` DISABLE KEYS */;
/*!40000 ALTER TABLE `ConflictOfInterest` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `DecisionLog`
--
DROP TABLE IF EXISTS `DecisionLog`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `DecisionLog` (
`id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`submissionId` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`chairId` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`decision` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`metaReview` text COLLATE utf8mb4_unicode_ci,
`publicationDecision` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`showReviewsToAuthor` tinyint(1) NOT NULL DEFAULT '1',
`createdAt` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
PRIMARY KEY (`id`),
KEY `DecisionLog_submissionId_idx` (`submissionId`),
KEY `DecisionLog_chairId_idx` (`chairId`),
CONSTRAINT `DecisionLog_chairId_fkey` FOREIGN KEY (`chairId`) REFERENCES `User` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
CONSTRAINT `DecisionLog_submissionId_fkey` FOREIGN KEY (`submissionId`) REFERENCES `Submission` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `DecisionLog`
--
LOCK TABLES `DecisionLog` WRITE;
/*!40000 ALTER TABLE `DecisionLog` DISABLE KEYS */;
INSERT INTO `DecisionLog` VALUES ('d783bbd3-efef-4816-aae3-839ba75dd960','9cd4a360-1eb7-4968-9db8-4d99acf12dbd','cd4f1a56-e1c2-4cdb-8e84-3a2228de9cca','ACCEPT','ACCEPTED','niceeeeeee',NULL,1,'2026-09-10 18:08:24.197');
/*!40000 ALTER TABLE `DecisionLog` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `Discussion`
--
DROP TABLE IF EXISTS `Discussion`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `Discussion` (
`id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`submissionId` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`conferenceId` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`userId` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`message` text COLLATE utf8mb4_unicode_ci NOT NULL,
`isHidden` tinyint(1) NOT NULL DEFAULT '0',
`createdAt` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
PRIMARY KEY (`id`),
KEY `Discussion_submissionId_idx` (`submissionId`),
KEY `Discussion_conferenceId_fkey` (`conferenceId`),
KEY `Discussion_userId_fkey` (`userId`),
CONSTRAINT `Discussion_conferenceId_fkey` FOREIGN KEY (`conferenceId`) REFERENCES `Conference` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE,
CONSTRAINT `Discussion_submissionId_fkey` FOREIGN KEY (`submissionId`) REFERENCES `Submission` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `Discussion_userId_fkey` FOREIGN KEY (`userId`) REFERENCES `User` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `Discussion`
--
LOCK TABLES `Discussion` WRITE;
/*!40000 ALTER TABLE `Discussion` DISABLE KEYS */;
/*!40000 ALTER TABLE `Discussion` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `EmailQueue`
--
DROP TABLE IF EXISTS `EmailQueue`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `EmailQueue` (
`id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`to` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`subject` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`html` text COLLATE utf8mb4_unicode_ci NOT NULL,
`text` text COLLATE utf8mb4_unicode_ci,
`status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'PENDING',
`attempts` int NOT NULL DEFAULT '0',
`lastError` text COLLATE utf8mb4_unicode_ci,
`sentAt` datetime(3) DEFAULT NULL,
`createdAt` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
`updatedAt` datetime(3) NOT NULL,
`attachments` longtext COLLATE utf8mb4_unicode_ci,
PRIMARY KEY (`id`),
KEY `EmailQueue_status_createdAt_idx` (`status`,`createdAt`),
KEY `EmailQueue_sentAt_idx` (`sentAt`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `EmailQueue`
--
LOCK TABLES `EmailQueue` WRITE;
/*!40000 ALTER TABLE `EmailQueue` DISABLE KEYS */;
INSERT INTO `EmailQueue` VALUES ('0569495f-20f3-456c-9b45-93524723d3a2','willdan@gmail.com','Paper submitted — International Conference on Sustainable Energy and Technology 2026','\n \n
E-Conference
\n
Hi willdan albert,
\n
\n Your paper \"Pengaruh Penggunaan Media Sosial terhadap Tingkat Belajar Siswa SMP di Indonesia\" has been successfully\n submitted to International Conference on Sustainable Energy and Technology 2026.\n
\n
You can track its status at the link below:
\n
\n View My Submissions\n \n
\n You will be notified when a decision is made on your paper.\n
\n
\n
E-Conference
\n
Hi King Will,
\n
\n A decision has been made on your paper\n \"testinggggg\" submitted to\n International Conference on Biomedical Engineering 2025.\n
\n
\n
\n Decision: Revision Required\n
\n
\n revisi dikt\n
\n
\n
\n View My Submissions\n \n
\n
\n
\n International Conference on Biomedical Engineering 2025\n
\n
\n Konfirmasi Registrasi & Dokumen Resmi\n
\n
\n\n
\n
\n Yth. DanuSH,\n
\n
\n Terima kasih. Pendaftaran Anda untuk International Conference on Biomedical Engineering 2025 telah berhasil dikonfirmasi (Bebas Biaya / Free).\n
\n\n \n
\n \n \n | Status | \n \n LUNAS / PAID\n | \n
\n \n | Jumlah Pembayaran | \n \n Rp 0 (Bebas Biaya / Free)\n | \n
\n \n | Nomor Kuitansi / Receipt | \n \n A48BC27A\n | \n
\n \n \n | Kategori Pendaftaran | \n \n Test Free Author Category (AUTHOR)\n | \n
\n \n \n
\n\n \n
\n
\n 📎 Dokumen Terlampir (Attached Documents):\n
\n
\n - \n Receipt-A48BC27A.pdf (Kuitansi / Bukti Pembayaran Resmi)\n
\n \n - \n LoA-ICBME2025-47383A7F.pdf (Letter of Acceptance / LoA Resmi)\n
\n \n - \n LoA-ICBME2025-503EB890.pdf (Letter of Acceptance / LoA Resmi)\n
\n \n
\n
\n\n \n
\n
\n 🎉 Official Letter of Acceptance (LoA) Included!\n
\n
\n Selamat! Artikel Anda telah resmi diterima. Surat Penerimaan (LoA) resmi telah kami lampirkan bersama email ini:\n
\n
\n \n - \n LoA-ICBME2025-47383A7F.pdf — \"hahaih aa shas iudkasj dh askhd ks\"\n
\n \n - \n LoA-ICBME2025-503EB890.pdf — \"testinggggg\"\n
\n \n
\n
\n \n\n
\n Anda juga dapat mengunduh kembali dokumen kuitansi maupun LoA kapan saja melalui dashboard akun Anda:\n
\n\n
\n\n
\n\n
\n Email ini dikirim secara otomatis oleh E-Conference System atas nama Panitia Penyelenggara International Conference on Biomedical Engineering 2025.\n
\n
\n
\n
E-Conference
\n
Hi Danu,
\n
\n King Will has listed you as a co-author on the paper\n \"testinggggg\" submitted to\n International Conference on Biomedical Engineering 2025.\n
\n
You can track the paper status, review results, and proceedings on our platform.
\n
\n
\n Don\'t have an account yet? You can create one anytime with this email (zpnever7@gmail.com), and this submission will automatically appear in your dashboard:\n
\n
\n
\n If you believe this is an error or did not contribute to this paper, please contact the submitting author or the conference chair.\n
\n
\n
E-Conference
\n
Hi willdan albert,
\n
\n A decision has been made on your paper\n \"Pengaruh Penggunaan Media Sosial terhadap Tingkat Belajar Siswa SMP di Indonesia\" submitted to\n International Conference on Sustainable Energy and Technology 2026.\n
\n
\n
\n Decision: Accepted\n
\n
\n niceeeeeee\n
\n
\n
\n View My Submissions\n \n
\n
\n
\n International Conference on Biomedical Engineering 2025\n
\n
\n Konfirmasi Pembayaran & Dokumen Resmi\n
\n
\n\n
\n
\n Yth. King Will,\n
\n
\n Terima kasih. Pembayaran pendaftaran Anda untuk International Conference on Biomedical Engineering 2025 telah berhasil diverifikasi dan dikonfirmasi.\n
\n\n \n
\n \n \n | Status | \n \n LUNAS / PAID\n | \n
\n \n | Jumlah Pembayaran | \n \n Rp 2.500.000\n | \n
\n \n | Nomor Kuitansi / Receipt | \n \n 1FE102AC\n | \n
\n \n \n | Kategori Pendaftaran | \n \n Author / Presenter (AUTHOR)\n | \n
\n \n \n
\n\n \n
\n
\n 📎 Dokumen Terlampir (Attached Documents):\n
\n
\n - \n Receipt-1FE102AC.pdf (Kuitansi / Bukti Pembayaran Resmi)\n
\n \n - \n LoA-ICBME2025-503EB890.pdf (Letter of Acceptance / LoA Resmi)\n
\n \n
\n
\n\n \n
\n
\n 🎉 Official Letter of Acceptance (LoA) Included!\n
\n
\n Selamat! Artikel Anda telah resmi diterima. Surat Penerimaan (LoA) resmi telah kami lampirkan bersama email ini:\n
\n
\n \n - \n LoA-ICBME2025-503EB890.pdf — \"testinggggg\"\n
\n \n
\n
\n \n\n
\n Anda juga dapat mengunduh kembali dokumen kuitansi maupun LoA kapan saja melalui dashboard akun Anda:\n
\n\n
\n\n
\n\n
\n Email ini dikirim secara otomatis oleh E-Conference System atas nama Panitia Penyelenggara International Conference on Biomedical Engineering 2025.\n
\n
\n
\n
E-Conference
\n
Hi King Will,
\n
\n Your paper \"testinggggg\" has been successfully\n submitted to International Conference on Biomedical Engineering 2025.\n
\n
You can track its status at the link below:
\n
\n View My Submissions\n \n
\n You will be notified when a decision is made on your paper.\n
\n
\n
E-Conference
\n
Hi Surya,
\n
\n King Will has listed you as a co-author on the paper\n \"testinggggg\" submitted to\n International Conference on Biomedical Engineering 2025.\n
\n
You can track the paper status, review results, and proceedings on our platform.
\n
\n
\n Don\'t have an account yet? You can create one anytime with this email (danusuko2004@gmail.com), and this submission will automatically appear in your dashboard:\n
\n
\n
\n If you believe this is an error or did not contribute to this paper, please contact the submitting author or the conference chair.\n
\n
\n
E-Conference
\n
Hi willdan albert,
\n
\n Your paper \"Pengaruh Penggunaan Media Sosial terhadap Tingkat Belajar Siswa SMP di Indonesia\" has been successfully\n submitted to International Conference on Sustainable Energy and Technology 2026.\n
\n
You can track its status at the link below:
\n
\n View My Submissions\n \n
\n You will be notified when a decision is made on your paper.\n
\n
\n
E-Conference
\n
Hi King Will,
\n
\n A decision has been made on your paper\n \"testinggggg\" submitted to\n International Conference on Biomedical Engineering 2025.\n
\n
\n
\n Decision: Accepted\n
\n
\n Oke acc ya\n
\n
\n
\n View My Submissions\n \n
\n
\n
\n International Conference on Sustainable Energy and Technology 2026\n
\n
\n Konfirmasi Registrasi & Dokumen Resmi\n
\n
\n\n
\n
\n Yth. willdan albert,\n
\n
\n Terima kasih. Pendaftaran Anda untuk International Conference on Sustainable Energy and Technology 2026 telah berhasil dikonfirmasi (Bebas Biaya / Free).\n
\n\n \n
\n \n \n | Status | \n \n LUNAS / PAID\n | \n
\n \n | Jumlah Pembayaran | \n \n Rp 0 (Bebas Biaya / Free)\n | \n
\n \n | Nomor Kuitansi / Receipt | \n \n 1A47C6A1\n | \n
\n \n \n | Kategori Pendaftaran | \n \n Presenter / Author (Student Research Grant - Gratis) (AUTHOR)\n | \n
\n \n \n
\n\n \n
\n
\n 📎 Dokumen Terlampir (Attached Documents):\n
\n
\n - \n Receipt-1A47C6A1.pdf (Kuitansi / Bukti Pembayaran Resmi)\n
\n \n - \n LoA-ICSET2026-9CD4A360.pdf (Letter of Acceptance / LoA Resmi)\n
\n \n
\n
\n\n \n
\n
\n 🎉 Official Letter of Acceptance (LoA) Included!\n
\n
\n Selamat! Artikel Anda telah resmi diterima. Surat Penerimaan (LoA) resmi telah kami lampirkan bersama email ini:\n
\n
\n \n - \n LoA-ICSET2026-9CD4A360.pdf — \"Pengaruh Penggunaan Media Sosial terhadap Tingkat Belajar Siswa SMP di Indonesia\"\n
\n \n
\n
\n \n\n
\n Anda juga dapat mengunduh kembali dokumen kuitansi maupun LoA kapan saja melalui dashboard akun Anda:\n
\n\n
\n\n
\n\n
\n Email ini dikirim secara otomatis oleh E-Conference System atas nama Panitia Penyelenggara International Conference on Sustainable Energy and Technology 2026.\n
\n
\n