-- MySQL dump 10.13  Distrib 8.0.44, for Linux (x86_64)
--
-- Host: localhost    Database: repayment
-- ------------------------------------------------------
-- Server version	8.0.44-0ubuntu0.22.04.1

/*!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 `nationality`
--

DROP TABLE IF EXISTS `nationality`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `nationality` (
  `nationality_id` int NOT NULL AUTO_INCREMENT,
  `nationality_code` varchar(255) DEFAULT NULL,
  `nationality_name` varchar(255) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`nationality_id`)
) ENGINE=InnoDB AUTO_INCREMENT=193 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `nationality`
--

LOCK TABLES `nationality` WRITE;
/*!40000 ALTER TABLE `nationality` DISABLE KEYS */;
INSERT INTO `nationality` VALUES (1,'0','Other','2021-07-01 03:09:08','2022-02-01 13:32:38'),(2,'1','Thai','2021-07-03 10:36:00','2022-02-01 13:32:38'),(3,'3','American','2021-07-03 10:36:00','2022-02-01 13:32:38'),(4,'4','Australian','2021-07-03 10:36:00','2022-02-01 13:32:38'),(5,'5','Bangladeshi','2021-07-03 10:36:00','2022-02-01 13:32:38'),(6,'6','Belgian','2021-07-03 10:36:00','2022-02-01 13:32:38'),(7,'7','Bhutanese','2021-07-03 10:36:00','2022-02-01 13:32:38'),(8,'8','British','2021-07-03 10:36:00','2022-02-01 13:32:38'),(9,'10','Cambodian','2021-07-03 10:36:00','2022-02-01 13:32:38'),(10,'11','Canadian','2021-07-03 10:36:00','2022-02-01 13:32:38'),(11,'12','Chinese','2021-07-03 10:36:00','2022-02-01 13:32:38'),(12,'14','Finnish','2021-07-03 10:36:00','2022-02-01 13:32:38'),(13,'15','German','2021-07-03 10:36:00','2022-02-01 13:32:38'),(14,'16','Indian','2021-07-03 10:36:00','2022-02-01 13:32:38'),(15,'17','Iranian','2021-07-03 10:36:00','2022-02-01 13:32:38'),(16,'18','Japanese','2021-07-03 10:36:00','2022-02-01 13:32:38'),(17,'19','Korean','2021-07-03 10:36:00','2022-02-01 13:32:38'),(18,'20','Malaysian','2021-07-03 10:36:00','2022-02-01 13:32:38'),(19,'21','Maldivian','2021-07-03 10:36:00','2022-02-01 13:32:38'),(20,'22','Myanmar','2021-07-03 10:36:00','2022-02-01 13:32:38'),(21,'23','Nepalese','2021-07-03 10:36:00','2022-02-01 13:32:38'),(22,'24','Pakistani','2021-07-03 10:36:00','2022-02-01 13:32:38'),(23,'25','Filipino','2021-07-03 10:36:00','2022-02-01 13:32:38'),(24,'28','Swiss','2021-07-03 10:36:00','2022-02-01 13:32:38'),(25,'29','Taiwanese','2021-07-03 10:36:00','2022-02-01 13:32:38'),(27,'31','Vietnamese','2021-07-03 10:36:00','2022-02-01 13:32:38'),(28,'32','Indonesian','2021-07-03 10:36:00','2022-02-01 13:32:38'),(29,'33','Turkish','2021-07-03 10:36:00','2022-02-01 13:32:38'),(30,'34','Bruneian','2021-07-03 10:36:00','2022-02-01 13:32:38'),(31,'37','Danish','2021-07-03 10:36:00','2022-02-01 13:32:38'),(32,'38','French','2021-07-03 10:36:00','2022-02-01 13:32:38'),(33,'39','Lao','2021-07-03 10:36:00','2022-02-01 13:32:38'),(34,'40','Nigerian','2021-07-03 10:36:00','2022-02-01 13:32:38'),(35,'41','Norwegian','2021-07-03 10:36:00','2022-02-01 13:32:38'),(36,'42','Austrian','2021-07-03 10:36:00','2022-02-01 13:32:38'),(37,'43','Estonian','2021-07-03 10:36:00','2022-02-01 13:32:38'),(38,'101','Ethiopian','2021-07-03 10:36:00','2022-02-01 13:32:38'),(39,'104','Uzbek','2021-07-03 10:36:00','2022-02-01 13:32:38'),(40,'105','Egyptian','2021-07-03 10:36:00','2022-02-01 13:32:38'),(41,'106','Sri Lankan','2021-07-03 10:36:00','2022-02-01 13:32:38'),(42,'107','Italian','2021-07-03 10:36:00','2022-02-01 13:32:38'),(43,'109','Botswana','2021-07-03 10:36:00','2022-02-01 13:32:38'),(44,'110','Tanzanian','2021-07-03 10:36:00','2022-02-01 13:32:38'),(45,'111','Omani','2021-07-03 10:36:00','2022-02-01 13:32:38'),(46,'112','Syrian','2021-07-03 10:36:00','2022-02-01 13:32:38'),(47,'113','Moldovan','2021-07-03 10:36:00','2022-02-01 13:32:38'),(48,'114','Moroccan','2021-07-03 10:36:00','2022-02-01 13:32:38'),(49,'115','Pakistani','2021-07-03 10:36:00','2022-02-01 13:32:38'),(50,'116','Dutch','2021-07-03 10:36:00','2022-02-01 13:32:38'),(51,'117','Polish','2021-07-03 10:36:00','2022-02-01 13:32:38'),(52,'118','Guinean','2021-07-03 10:36:00','2022-02-01 13:32:38'),(53,'119','Afghan','2021-07-03 10:36:00','2022-02-01 13:32:38'),(54,'120','Albanian','2021-07-03 10:36:00','2022-02-01 13:32:38'),(55,'121','Algerian','2021-07-03 10:36:00','2022-02-01 13:32:38'),(56,'122','Andorran','2021-07-03 10:36:00','2022-02-01 13:32:38'),(57,'123','Angolan','2021-07-03 10:36:00','2022-02-01 13:32:38'),(58,'124','Anguillan','2021-07-03 10:36:00','2022-02-01 13:32:38'),(59,'125','Argentine','2021-07-03 10:36:00','2022-02-01 13:32:38'),(60,'126','Armenian','2021-07-03 10:36:00','2022-02-01 13:32:38'),(61,'127','Aruban','2021-07-03 10:36:00','2022-02-01 13:32:38'),(62,'128','Azerbaijani','2021-07-03 10:36:00','2022-02-01 13:32:38'),(63,'129','Bahamian','2021-07-03 10:36:00','2022-02-01 13:32:38'),(64,'130','Bahraini','2021-07-03 10:36:00','2022-02-01 13:32:38'),(65,'131','Barbadian','2021-07-03 10:36:00','2022-02-01 13:32:38'),(66,'132','Belarusian','2021-07-03 10:36:00','2022-02-01 13:32:38'),(67,'133','Belizean','2021-07-03 10:36:00','2022-02-01 13:32:38'),(68,'134','Beninese     ','2021-07-03 10:36:00','2022-02-01 13:32:38'),(69,'135','Bermudian','2021-07-03 10:36:00','2022-02-01 13:32:38'),(70,'136','Bolivian','2021-07-03 10:36:00','2022-02-01 13:32:38'),(71,'137','Bosnian','2021-07-03 10:36:00','2022-02-01 13:32:38'),(72,'138','Brazilian','2021-07-03 10:36:00','2022-02-01 13:32:38'),(73,'139','Bulgarian','2021-07-03 10:36:00','2022-02-01 13:32:38'),(74,'140','Burkinese','2021-07-03 10:36:00','2022-02-01 13:32:38'),(75,'141','Burundian','2021-07-03 10:36:00','2022-02-01 13:32:38'),(76,'142','Cameroonian','2021-07-03 10:36:00','2022-02-01 13:32:38'),(77,'143','Cape Verdean','2021-07-03 10:36:00','2022-02-01 13:32:38'),(78,'144','Chadian','2021-07-03 10:36:00','2022-02-01 13:32:38'),(79,'145','Chilean','2021-07-03 10:36:00','2022-02-01 13:32:38'),(80,'146','Colombian','2021-07-03 10:36:00','2022-02-01 13:32:38'),(81,'147','Congolese','2021-07-03 10:36:00','2022-02-01 13:32:38'),(82,'148','Costa Rican','2021-07-03 10:36:00','2022-02-01 13:32:38'),(83,'149','Croat','2021-07-03 10:36:00','2022-02-01 13:32:38'),(84,'150','Cuban','2021-07-03 10:36:00','2022-02-01 13:32:38'),(85,'151','Cypriot','2021-07-03 10:36:00','2022-02-01 13:32:38'),(86,'152','Czech','2021-07-03 10:36:00','2022-02-01 13:32:38'),(87,'153','Dane','2021-07-03 10:36:00','2022-02-01 13:32:38'),(88,'154','Djiboutian','2021-07-03 10:36:00','2022-02-01 13:32:38'),(89,'155','Dominican','2021-07-03 10:36:00','2022-02-01 13:32:38'),(90,'157','East Timorese','2021-07-03 10:36:00','2022-02-01 13:32:38'),(91,'158','Ecudorian','2021-07-03 10:36:00','2022-02-01 13:32:38'),(92,'159','Emirian','2021-07-03 10:36:00','2022-02-01 13:32:38'),(93,'160','Eritrean','2021-07-03 10:36:00','2022-02-01 13:32:38'),(94,'161','Fijian','2021-07-03 10:36:00','2022-02-01 13:32:38'),(95,'162','Gabonese','2021-07-03 10:36:00','2022-02-01 13:32:38'),(96,'163','Gambian','2021-07-03 10:36:00','2022-02-01 13:32:38'),(97,'164','Georgian','2021-07-03 10:36:00','2022-02-01 13:32:38'),(98,'165','Ghanaian','2021-07-03 10:36:00','2022-02-01 13:32:38'),(99,'166','Greek','2021-07-03 10:36:00','2022-02-01 13:32:38'),(100,'167','Greenlander','2021-07-03 10:36:00','2022-02-01 13:32:38'),(101,'168','Grenadian','2021-07-03 10:36:00','2022-02-01 13:32:38'),(102,'169','Guatemalan','2021-07-03 10:36:00','2022-02-01 13:32:38'),(103,'170','Haitian','2021-07-03 10:36:00','2022-02-01 13:32:38'),(104,'171','Honduran','2021-07-03 10:36:00','2022-02-01 13:32:38'),(105,'172','Hungarian','2021-07-03 10:36:00','2022-02-01 13:32:38'),(106,'173','Icelander','2021-07-03 10:36:00','2022-02-01 13:32:38'),(107,'174','Kiribati','2021-07-03 10:36:00','2022-02-01 13:32:38'),(108,'175','Iraqi','2021-07-03 10:36:00','2022-02-01 13:32:38'),(109,'176','Irish','2021-07-03 10:36:00','2022-02-01 13:32:38'),(110,'177','Israeli','2021-07-03 10:36:00','2022-02-01 13:32:38'),(111,'178','Jamaican','2021-07-03 10:36:00','2022-02-01 13:32:38'),(112,'179','Jordanian','2021-07-03 10:36:00','2022-02-01 13:32:38'),(113,'180','Kazakhstan','2021-07-03 10:36:00','2022-02-01 13:32:38'),(114,'181','Kenyan','2021-07-03 10:36:00','2022-02-01 13:32:38'),(115,'182','Kuwaiti','2021-07-03 10:36:00','2022-02-01 13:32:38'),(116,'183','Kyrgyz','2021-07-03 10:36:00','2022-02-01 13:32:38'),(117,'184','Latvian','2021-07-03 10:36:00','2022-02-01 13:32:38'),(118,'185','Lebanese','2021-07-03 10:36:00','2022-02-01 13:32:38'),(119,'186','Liberian','2021-07-03 10:36:00','2022-02-01 13:32:38'),(120,'187','Libyan','2021-07-03 10:36:00','2022-02-01 13:32:38'),(121,'188','Liechtenstein','2021-07-03 10:36:00','2022-02-01 13:32:38'),(122,'189','Lithuanian','2021-07-03 10:36:00','2022-02-01 13:32:38'),(123,'190','Luxmbourg','2021-07-03 10:36:00','2022-02-01 13:32:38'),(124,'191','Macedonian','2021-07-03 10:36:00','2022-02-01 13:32:38'),(125,'192','Malagasy','2021-07-03 10:36:00','2022-02-01 13:32:38'),(126,'193','Malawian','2021-07-03 10:36:00','2022-02-01 13:32:38'),(127,'194','Malian','2021-07-03 10:36:00','2022-02-01 13:32:38'),(128,'195','Maltese','2021-07-03 10:36:00','2022-02-01 13:32:38'),(129,'196','Marshallese','2021-07-03 10:36:00','2022-02-01 13:32:38'),(130,'197','Mauritian','2021-07-03 10:36:00','2022-02-01 13:32:38'),(131,'199','Mexican','2021-07-03 10:36:00','2022-02-01 13:32:38'),(132,'200','Micronesia','2021-07-03 10:36:00','2022-02-01 13:32:38'),(133,'201','Monacan','2021-07-03 10:36:00','2022-02-01 13:32:38'),(134,'202','Mongolian','2021-07-03 10:36:00','2022-02-01 13:32:38'),(135,'203','Montenegrin','2021-07-03 10:36:00','2022-02-01 13:32:38'),(136,'204','Mozambican','2021-07-03 10:36:00','2022-02-01 13:32:38'),(137,'205','Namibian','2021-07-03 10:36:00','2022-02-01 13:32:38'),(138,'206','Nauruan','2021-07-03 10:36:00','2022-02-01 13:32:38'),(139,'207','New Zealander','2021-07-03 10:36:00','2022-02-01 13:32:38'),(140,'208','Nicaraguan','2021-07-03 10:36:00','2022-02-01 13:32:38'),(141,'209','North Korean','2021-07-03 10:36:00','2022-02-01 13:32:38'),(142,'210','Palauan','2021-07-03 10:36:00','2022-02-01 13:32:38'),(143,'211','Panamanian','2021-07-03 10:36:00','2022-02-01 13:32:38'),(144,'212','Papua New Guinean','2021-07-03 10:36:00','2022-02-01 13:32:38'),(145,'213','Paraguayan','2021-07-03 10:36:00','2022-02-01 13:32:38'),(146,'214','Peruvian','2021-07-03 10:36:00','2022-02-01 13:32:38'),(147,'215','Portuguese','2021-07-03 10:36:00','2022-02-01 13:32:38'),(148,'216','Puerto Rican','2021-07-03 10:36:00','2022-02-01 13:32:38'),(149,'217','Qatari','2021-07-03 10:36:00','2022-02-01 13:32:38'),(150,'218','Romanian','2021-07-03 10:36:00','2022-02-01 13:32:38'),(151,'219','Russian','2021-07-03 10:36:00','2022-02-01 13:32:38'),(152,'220','Rwandan','2021-07-03 10:36:00','2022-02-01 13:32:38'),(153,'221','Salvadoran','2021-07-03 10:36:00','2022-02-01 13:32:38'),(154,'222','Samoan','2021-07-03 10:36:00','2022-02-01 13:32:38'),(155,'223','San Marinese','2021-07-03 10:36:00','2022-02-01 13:32:38'),(156,'224','Saudi Arabian','2021-07-03 10:36:00','2022-02-01 13:32:38'),(157,'225','Senegalese','2021-07-03 10:36:00','2022-02-01 13:32:38'),(158,'226','Serbian','2021-07-03 10:36:00','2022-02-01 13:32:38'),(159,'227','Seychelle','2021-07-03 10:36:00','2022-02-01 13:32:38'),(160,'228','Sierra Leonean','2021-07-03 10:36:00','2022-02-01 13:32:38'),(161,'229','Singaporean','2021-07-03 10:36:00','2022-02-01 13:32:38'),(162,'230','Slovak','2021-07-03 10:36:00','2022-02-01 13:32:38'),(163,'231','Slovenian','2021-07-03 10:36:00','2022-02-01 13:32:38'),(164,'232','Somali','2021-07-03 10:36:00','2022-02-01 13:32:38'),(165,'233','South African','2021-07-03 10:36:00','2022-02-01 13:32:38'),(166,'234','South Korean','2021-07-03 10:36:00','2022-02-01 13:32:38'),(167,'235','Spanish','2021-07-03 10:36:00','2022-02-01 13:32:38'),(168,'236','Sudanese','2021-07-03 10:36:00','2022-02-01 13:32:38'),(169,'237','Swazi','2021-07-03 10:36:00','2022-02-01 13:32:38'),(170,'238','Swedish','2021-07-03 10:36:00','2022-02-01 13:32:38'),(171,'239','Togolese','2021-07-03 10:36:00','2022-02-01 13:32:38'),(172,'240','Tongan','2021-07-03 10:36:00','2022-02-01 13:32:38'),(173,'241','Trinidadian','2021-07-03 10:36:00','2022-02-01 13:32:38'),(174,'242','Tswana','2021-07-03 10:36:00','2022-02-01 13:32:38'),(175,'243','Tunisian','2021-07-03 10:36:00','2022-02-01 13:32:38'),(176,'244','Tuvaluan','2021-07-03 10:36:00','2022-02-01 13:32:38'),(177,'245','Ugandan','2021-07-03 10:36:00','2022-02-01 13:32:38'),(178,'246','Ukrainian','2021-07-03 10:36:00','2022-02-01 13:32:38'),(179,'247','Uruguayan','2021-07-03 10:36:00','2022-02-01 13:32:38'),(180,'248','Ni-Vanuatu','2021-07-03 10:36:00','2022-02-01 13:32:38'),(181,'249','Venezuelan','2021-07-03 10:36:00','2022-02-01 13:32:38'),(182,'250','Yemeni','2021-07-03 10:36:00','2022-02-01 13:32:38'),(183,'251','Zambian','2021-07-03 10:36:00','2022-02-01 13:32:38'),(184,'252','Zimbabwean','2021-07-03 10:36:00','2022-02-01 13:32:38'),(186,'13','British','2022-02-01 13:32:38','2022-02-01 13:32:38'),(187,'100','Maldivian','2022-02-01 13:32:38','2022-02-01 13:32:38'),(188,'103','Filipino','2022-02-01 13:32:38','2022-02-01 13:32:38'),(189,'108','Myanmar','2022-02-01 13:32:38','2022-02-01 13:32:38'),(190,'253','German','2022-02-01 13:32:38','2022-02-01 13:32:38'),(191,'254','Swedish','2022-02-01 13:32:38','2022-02-01 13:32:38');
/*!40000 ALTER TABLE `nationality` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2025-12-06 10:00:08
