Company Management Dashboard - Copy this Html, Bootstrap Component to your project
làm lại phần candiate cho phù hợp hơn được không kiểu như là phải xem thông tin của candidate, xem ai phù hợp nhát với job nữaa và them chức năng gửi gmail mời CREATE TABLE IF NOT EXISTS `candidate` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `dob` date NOT NULL, `email` varchar(255) NOT NULL, `full_name` varchar(255) NOT NULL, `phone` varchar(15) NOT NULL, `address` bigint(20) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `UK_qfut8ruekode092nlkipgl09g` (`email`), UNIQUE KEY `UK_9i5yt1gvm0chg5e10qkns7tll` (`phone`), UNIQUE KEY `UK_m8qhlm4wu215gr34dhxp0dour` (`address`), CONSTRAINT `FKa8gnyyhbb2qnhp94grci1n0o9` FOREIGN KEY (`address`) REFERENCES `address` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1010 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Data exporting was unselected. -- Dumping structure for table works.candidate_skill CREATE TABLE IF NOT EXISTS `candidate_skill` ( `more_infos` varchar(1000) DEFAULT NULL, `skill_level` tinyint(4) NOT NULL CHECK (`skill_level` between 0 and 2), `skill_id` bigint(20) NOT NULL, `can_id` bigint(20) NOT NULL, PRIMARY KEY (`can_id`,`skill_id`), KEY `FKb7cxhiqhcah7c20a2cdlvr1f8` (`skill_id`), CONSTRAINT `FKb0m5tm3fi0upa3b3kjx3vrlxs` FOREIGN KEY (`can_id`) REFERENCES `candidate` (`id`), CONSTRAINT `FKb7cxhiqhcah7c20a2cdlvr1f8` FOREIGN KEY (`skill_id`) REFERENCES `skill` (`skill_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Data exporting was unselected.-- Dumping structure for table works.experience CREATE TABLE IF NOT EXISTS `experience` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `company_name` varchar(255) DEFAULT NULL, `from_date` date DEFAULT NULL, `role` varchar(255) DEFAULT NULL, `to_date` date DEFAULT NULL, `work_description` varchar(2000) DEFAULT NULL, `candidate_id` bigint(20) DEFAULT NULL, PRIMARY KEY (`id`), KEY `FKsmv65lqovssalk12ti3cqkpjf` (`candidate_id`), CONSTRAINT `FKsmv65lqovssalk12ti3cqkpjf` FOREIGN KEY (`candidate_id`) REFERENCES `candidate` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Data exporting was unselected.
