{
        "id": 22,
        "commune_name_ascii": "Timekten",
        "commune_name": "تيمقتن",
        "daira_name_ascii": "Aoulef",
        "daira_name": "أولف",
        "wilaya_code": "01",
        "wilaya_name_ascii": "Adrar",
        "wilaya_name": "أدرار"
    }
	

baladiyas.sql

dairas.sql

state.sql

        TABLE    state 
 
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `arabic` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `french` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `wilaya_code` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,


         TABLE   dairas
	   
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `arabic` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `french` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `id_state` int(11) NOT NULL,


          TABLE baladiyas

  `id` int(11) NOT NULL AUTO_INCREMENT,
  `arabic` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `french` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `id_daira` int(11) NOT NULL,
  `id_state` int(11) NOT NULL,
  `daira_arabic` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `daira_french` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,