-- Data for Name: employees; Type: TABLE DATA; Schema: public; Owner: admin
--

COPY public.employees (id, site_id, code, name, department_id, title_id, phone, email, photo, created_at, updated_at, approval_id, manager_id, status) FROM stdin;
\.


--
-- Data for Name: menu_mobiles; Type: TABLE DATA; Schema: public; Owner: admin
--

COPY public.menu_mobiles (id, menu_name, menu_link, menu_icon, menu_group, menu_type, created_at, updated_at, menu_alias) FROM stdin;
\.


--
-- Data for Name: menus; Type: TABLE DATA; Schema: public; Owner: admin
--

COPY public.menus (id, site_id, parent_id, menu_name, menu_route, menu_icon, menu_sort, created_at, updated_at, is_divider, menu_description) FROM stdin;
2	1	0	Setting	#	ri-tools-line	0	2023-12-19 05:58:21	2025-01-08 12:31:08	\N	\N
6	1	3	Menu	menu		0	2023-12-19 05:58:21	2025-01-08 12:31:08	\N	\N
3	1	2	User Access	\N	\N	0	2024-04-19 09:54:23	2025-01-08 12:31:08	\N	\N
4	1	2	Approval	\N	\N	0	2024-04-19 09:54:37	2025-01-08 12:31:08	\N	\N
5	1	2	Others	\N	\N	0	2024-04-19 09:54:43	2025-01-08 12:31:08	\N	\N
7	1	3	User	user	\N	0	2023-12-19 05:58:21	2025-01-08 12:31:08	\N	\N
8	1	3	Role	role		206	2023-12-19 05:58:21	2025-01-08 12:31:08	\N	\N
\.


--
-- Data for Name: migrations; Type: TABLE DATA; Schema: public; Owner: admin
--

COPY public.migrations (id, migration, batch) FROM stdin;
1	2014_10_12_000000_create_users_table	1
2	2014_10_12_100000_create_password_resets_table	1
3	2023_10_05_055212_create_auto_numbers	1
4	2023_10_05_055213_create_admins_table	1
5	2023_10_05_151130_create_provinces_table	1
6	2023_10_05_151139_create_regions_table	1
7	2023_10_05_151147_create_districts_table	1
8	2023_10_05_151205_create_configs_table	1
9	2023_10_05_151304_create_sites_table	1
10	2023_10_05_151345_create_site_configs_table	1
11	2023_12_14_064018_alter_table_sites	2
12	2024_04_04_150009_add_long_logo_in_sites	2
13	2024_01_10_135320_add_user_type_to_user_table	3
14	2024_06_26_082642_add_status_in_users	3
15	2024_04_03_110236_create_customer_categories_table	4
16	2024_04_03_110246_create_customers_table	4
17	2023_12_28_060907_create_banks_table	5
18	2024_04_03_110323_create_customer_bank_accounts_table	5
19	2024_04_03_110339_create_customer_contacts_table	5
20	2024_04_03_110350_create_customer_documents_table	5
21	2023_12_28_055229_create_account_categories_table	6
22	2023_12_28_065855_create_accounts_table	6
23	2024_02_02_100909_create_account_mappings_table	6
24	2024_04_25_162633_create_customer_accounts_table	6
25	2024_09_03_115733_create_user_customers_table	6
26	2024_09_26_151713_nullable_site_id_in_users	7
27	2024_09_26_153305_nullable_last_login_in_users	8
28	2024_10_01_083512_add_sync_code_in_users	8
29	2025_01_15_113838_add_fcm_token_in_users_table	8
30	2023_10_05_151732_admin_ntrust_setup_tables	9
31	2023_10_05_151736_user_ntrust_setup_tables	9
32	2023_10_05_153013_create_menus_table	9
33	2023_10_05_153039_create_role_menus_table	9
34	2023_12_15_052427_add_column_is_divider_in_menus_table	9
35	2024_04_18_110401_add_desctiption_in_menus_table	9
36	2024_06_05_123550_add_redirect_to_to_role_menu_table	9
37	2023_10_07_031054_create_titles_table	10
38	2023_10_07_043633_create_departments_table	10
39	2023_10_07_044714_create_employees_table	10
40	2023_10_10_082556_create_user_employees_table	10
41	2024_01_08_044856_delete_unique_to_department_table	10
42	2024_01_08_045028_delete_unique_to_title_table	10
43	2024_01_08_050231_delete_unique_to_employee_table	10
44	2024_01_19_024255_add_column_is_workorder_in_departments_table	10
45	2024_01_25_121208_add_approve_line_employees_table	10
46	2024_02_03_135651_add_whastapp_in_departments_table	10
47	2024_06_22_050023_add_status_in_employees	10
48	2024_08_06_130645_add_order_to_titles_table	10
49	2024_09_26_135645_nullable_title_and_department_in_employees	10
50	2024_09_26_151757_nullable_site_id_in_employees	10
51	2023_10_05_153048_create_user_logs_table	11
52	2024_01_03_044515_create_menu_mobiles_table	12
53	2024_01_03_072417_create_role_menu_mobiles_table	12
54	2024_02_16_113642_add_menu_alias_in_menu_mobiles_table	12
\.


--
-- Data for Name: permission_role; Type: TABLE DATA; Schema: public; Owner: admin
--

COPY public.permission_role (permission_id, role_id) FROM stdin;
\.


--
-- Data for Name: permissions; Type: TABLE DATA; Schema: public; Owner: admin
--

COPY public.permissions (id, name, display_name, description, created_at, updated_at) FROM stdin;
\.


--
-- Data for Name: provinces; Type: TABLE DATA; Schema: public; Owner: admin
--

COPY public.provinces (id, name, created_at, updated_at) FROM stdin;
1	Bali	2025-01-24 08:48:42	2025-01-24 08:48:42
2	Bangka Belitung	2025-01-24 08:48:42	2025-01-24 08:48:42
3	Banten	2025-01-24 08:48:42	2025-01-24 08:48:42
4	Bengkulu	2025-01-24 08:48:42	2025-01-24 08:48:42
5	DI Yogyakarta	2025-01-24 08:48:42	2025-01-24 08:48:42
6	DKI Jakarta	2025-01-24 08:48:42	2025-01-24 08:48:42
7	Gorontalo	2025-01-24 08:48:42	2025-01-24 08:48:42
8	Jambi	2025-01-24 08:48:42	2025-01-24 08:48:42
9	Jawa Barat	2025-01-24 08:48:42	2025-01-24 08:48:42
10	Jawa Tengah	2025-01-24 08:48:42	2025-01-24 08:48:42
11	Jawa Timur	2025-01-24 08:48:42	2025-01-24 08:48:42
12	Kalimantan Barat	2025-01-24 08:48:42	2025-01-24 08:48:42
13	Kalimantan Selatan	2025-01-24 08:48:42	2025-01-24 08:48:42
14	Kalimantan Tengah	2025-01-24 08:48:42	2025-01-24 08:48:42
15	Kalimantan Timur	2025-01-24 08:48:42	2025-01-24 08:48:42
16	Kalimantan Utara	2025-01-24 08:48:42	2025-01-24 08:48:42
17	Kepulauan Riau	2025-01-24 08:48:42	2025-01-24 08:48:42
18	Lampung	2025-01-24 08:48:42	2025-01-24 08:48:42
19	Maluku	2025-01-24 08:48:42	2025-01-24 08:48:42
20	Maluku Utara	2025-01-24 08:48:42	2025-01-24 08:48:42
21	Nanggroe Aceh Darussalam (NAD)	2025-01-24 08:48:42	2025-01-24 08:48:42
22	Nusa Tenggara Barat (NTB)	2025-01-24 08:48:42	2025-01-24 08:48:42
23	Nusa Tenggara Timur (NTT)	2025-01-24 08:48:42	2025-01-24 08:48:42
24	Papua	2025-01-24 08:48:42	2025-01-24 08:48:42
25	Papua Barat	2025-01-24 08:48:42	2025-01-24 08:48:42
26	Riau	2025-01-24 08:48:42	2025-01-24 08:48:42
27	Sulawesi Barat	2025-01-24 08:48:42	2025-01-24 08:48:42
28	Sulawesi Selatan	2025-01-24 08:48:42	2025-01-24 08:48:42
29	Sulawesi Tengah	2025-01-24 08:48:42	2025-01-24 08:48:42
30	Sulawesi Tenggara	2025-01-24 08:48:42	2025-01-24 08:48:42
31	Sulawesi Utara	2025-01-24 08:48:42	2025-01-24 08:48:42
32	Sumatera Barat	2025-01-24 08:48:42	2025-01-24 08:48:42
33	Sumatera Selatan	2025-01-24 08:48:42	2025-01-24 08:48:42
34	Sumatera Utara	2025-01-24 08:48:42	2025-01-24 08:48:42
\.


--
-- Data for Name: regions; Type: TABLE DATA; Schema: public; Owner: admin
--

COPY public.regions (id, province_id, name, type, postal_code, created_at, updated_at) FROM stdin;
1	21	Aceh Barat	Kabupaten	23681	2025-01-24 08:48:42	2025-01-24 08:48:42
2	21	Aceh Barat Daya	Kabupaten	23764	2025-01-24 08:48:42	2025-01-24 08:48:42
3	21	Aceh Besar	Kabupaten	23951	2025-01-24 08:48:42	2025-01-24 08:48:42
4	21	Aceh Jaya	Kabupaten	23654	2025-01-24 08:48:42	2025-01-24 08:48:42
5	21	Aceh Selatan	Kabupaten	23719	2025-01-24 08:48:42	2025-01-24 08:48:42
6	21	Aceh Singkil	Kabupaten	24785	2025-01-24 08:48:42	2025-01-24 08:48:42
7	21	Aceh Tamiang	Kabupaten	24476	2025-01-24 08:48:42	2025-01-24 08:48:42
8	21	Aceh Tengah	Kabupaten	24511	2025-01-24 08:48:42	2025-01-24 08:48:42
9	21	Aceh Tenggara	Kabupaten	24611	2025-01-24 08:48:42	2025-01-24 08:48:42
10	21	Aceh Timur	Kabupaten	24454	2025-01-24 08:48:42	2025-01-24 08:48:42
11	21	Aceh Utara	Kabupaten	24382	2025-01-24 08:48:42	2025-01-24 08:48:42
12	32	Agam	Kabupaten	26411	2025-01-24 08:48:42	2025-01-24 08:48:42
13	23	Alor	Kabupaten	85811	2025-01-24 08:48:42	2025-01-24 08:48:42
14	19	Ambon	Kota	97222	2025-01-24 08:48:42	2025-01-24 08:48:42
15	34	Asahan	Kabupaten	21214	2025-01-24 08:48:42	2025-01-24 08:48:42
16	24	Asmat	Kabupaten	99777	2025-01-24 08:48:42	2025-01-24 08:48:42
17	1	Badung	Kabupaten	80351	2025-01-24 08:48:42	2025-01-24 08:48:42
18	13	Balangan	Kabupaten	71611	2025-01-24 08:48:42	2025-01-24 08:48:42
19	15	Balikpapan	Kota	76111	2025-01-24 08:48:42	2025-01-24 08:48:42
20	21	Banda Aceh	Kota	23238	2025-01-24 08:48:42	2025-01-24 08:48:42
21	18	Bandar Lampung	Kota	35139	2025-01-24 08:48:42	2025-01-24 08:48:42
22	9	Bandung	Kabupaten	40311	2025-01-24 08:48:42	2025-01-24 08:48:42
23	9	Bandung	Kota	40111	2025-01-24 08:48:42	2025-01-24 08:48:42
24	9	Bandung Barat	Kabupaten	40721	2025-01-24 08:48:42	2025-01-24 08:48:42
25	29	Banggai	Kabupaten	94711	2025-01-24 08:48:42	2025-01-24 08:48:42
26	29	Banggai Kepulauan	Kabupaten	94881	2025-01-24 08:48:42	2025-01-24 08:48:42
27	2	Bangka	Kabupaten	33212	2025-01-24 08:48:42	2025-01-24 08:48:42
28	2	Bangka Barat	Kabupaten	33315	2025-01-24 08:48:42	2025-01-24 08:48:42
29	2	Bangka Selatan	Kabupaten	33719	2025-01-24 08:48:42	2025-01-24 08:48:42
30	2	Bangka Tengah	Kabupaten	33613	2025-01-24 08:48:42	2025-01-24 08:48:42
31	11	Bangkalan	Kabupaten	69118	2025-01-24 08:48:42	2025-01-24 08:48:42
32	1	Bangli	Kabupaten	80619	2025-01-24 08:48:42	2025-01-24 08:48:42
33	13	Banjar	Kabupaten	70619	2025-01-24 08:48:42	2025-01-24 08:48:42
34	9	Banjar	Kota	46311	2025-01-24 08:48:42	2025-01-24 08:48:42
35	13	Banjarbaru	Kota	70712	2025-01-24 08:48:42	2025-01-24 08:48:42
36	13	Banjarmasin	Kota	70117	2025-01-24 08:48:42	2025-01-24 08:48:42
37	10	Banjarnegara	Kabupaten	53419	2025-01-24 08:48:42	2025-01-24 08:48:42
38	28	Bantaeng	Kabupaten	92411	2025-01-24 08:48:42	2025-01-24 08:48:42
39	5	Bantul	Kabupaten	55715	2025-01-24 08:48:42	2025-01-24 08:48:42
40	33	Banyuasin	Kabupaten	30911	2025-01-24 08:48:42	2025-01-24 08:48:42
41	10	Banyumas	Kabupaten	53114	2025-01-24 08:48:42	2025-01-24 08:48:42
42	11	Banyuwangi	Kabupaten	68416	2025-01-24 08:48:42	2025-01-24 08:48:42
43	13	Barito Kuala	Kabupaten	70511	2025-01-24 08:48:42	2025-01-24 08:48:42
44	14	Barito Selatan	Kabupaten	73711	2025-01-24 08:48:42	2025-01-24 08:48:42
45	14	Barito Timur	Kabupaten	73671	2025-01-24 08:48:42	2025-01-24 08:48:42
46	14	Barito Utara	Kabupaten	73881	2025-01-24 08:48:42	2025-01-24 08:48:42
47	28	Barru	Kabupaten	90719	2025-01-24 08:48:42	2025-01-24 08:48:42
48	17	Batam	Kota	29413	2025-01-24 08:48:42	2025-01-24 08:48:42
49	10	Batang	Kabupaten	51211	2025-01-24 08:48:42	2025-01-24 08:48:42
50	8	Batang Hari	Kabupaten	36613	2025-01-24 08:48:42	2025-01-24 08:48:42
51	11	Batu	Kota	65311	2025-01-24 08:48:42	2025-01-24 08:48:42
52	34	Batu Bara	Kabupaten	21655	2025-01-24 08:48:42	2025-01-24 08:48:42
53	30	Bau-Bau	Kota	93719	2025-01-24 08:48:42	2025-01-24 08:48:42
54	9	Bekasi	Kabupaten	17837	2025-01-24 08:48:42	2025-01-24 08:48:42
55	9	Bekasi	Kota	17121	2025-01-24 08:48:42	2025-01-24 08:48:42
56	2	Belitung	Kabupaten	33419	2025-01-24 08:48:42	2025-01-24 08:48:42
57	2	Belitung Timur	Kabupaten	33519	2025-01-24 08:48:42	2025-01-24 08:48:42
58	23	Belu	Kabupaten	85711	2025-01-24 08:48:42	2025-01-24 08:48:42
59	21	Bener Meriah	Kabupaten	24581	2025-01-24 08:48:42	2025-01-24 08:48:42
60	26	Bengkalis	Kabupaten	28719	2025-01-24 08:48:42	2025-01-24 08:48:42
61	12	Bengkayang	Kabupaten	79213	2025-01-24 08:48:42	2025-01-24 08:48:42
62	4	Bengkulu	Kota	38229	2025-01-24 08:48:42	2025-01-24 08:48:42
63	4	Bengkulu Selatan	Kabupaten	38519	2025-01-24 08:48:42	2025-01-24 08:48:42
64	4	Bengkulu Tengah	Kabupaten	38319	2025-01-24 08:48:42	2025-01-24 08:48:42
65	4	Bengkulu Utara	Kabupaten	38619	2025-01-24 08:48:42	2025-01-24 08:48:42
66	15	Berau	Kabupaten	77311	2025-01-24 08:48:42	2025-01-24 08:48:42
67	24	Biak Numfor	Kabupaten	98119	2025-01-24 08:48:42	2025-01-24 08:48:42
68	22	Bima	Kabupaten	84171	2025-01-24 08:48:42	2025-01-24 08:48:42
69	22	Bima	Kota	84139	2025-01-24 08:48:42	2025-01-24 08:48:42
70	34	Binjai	Kota	20712	2025-01-24 08:48:42	2025-01-24 08:48:42
71	17	Bintan	Kabupaten	29135	2025-01-24 08:48:42	2025-01-24 08:48:42
72	21	Bireuen	Kabupaten	24219	2025-01-24 08:48:42	2025-01-24 08:48:42
73	31	Bitung	Kota	95512	2025-01-24 08:48:42	2025-01-24 08:48:42
74	11	Blitar	Kabupaten	66171	2025-01-24 08:48:42	2025-01-24 08:48:42
75	11	Blitar	Kota	66124	2025-01-24 08:48:42	2025-01-24 08:48:42
76	10	Blora	Kabupaten	58219	2025-01-24 08:48:42	2025-01-24 08:48:42
77	7	Boalemo	Kabupaten	96319	2025-01-24 08:48:42	2025-01-24 08:48:42
78	9	Bogor	Kabupaten	16911	2025-01-24 08:48:42	2025-01-24 08:48:42
79	9	Bogor	Kota	16119	2025-01-24 08:48:42	2025-01-24 08:48:42
80	11	Bojonegoro	Kabupaten	62119	2025-01-24 08:48:42	2025-01-24 08:48:42
81	31	Bolaang Mongondow (Bolmong)	Kabupaten	95755	2025-01-24 08:48:42	2025-01-24 08:48:42
82	31	Bolaang Mongondow Selatan	Kabupaten	95774	2025-01-24 08:48:42	2025-01-24 08:48:42
83	31	Bolaang Mongondow Timur	Kabupaten	95783	2025-01-24 08:48:42	2025-01-24 08:48:42
84	31	Bolaang Mongondow Utara	Kabupaten	95765	2025-01-24 08:48:42	2025-01-24 08:48:42
85	30	Bombana	Kabupaten	93771	2025-01-24 08:48:42	2025-01-24 08:48:42
86	11	Bondowoso	Kabupaten	68219	2025-01-24 08:48:42	2025-01-24 08:48:42
87	28	Bone	Kabupaten	92713	2025-01-24 08:48:42	2025-01-24 08:48:42
88	7	Bone Bolango	Kabupaten	96511	2025-01-24 08:48:42	2025-01-24 08:48:42
89	15	Bontang	Kota	75313	2025-01-24 08:48:42	2025-01-24 08:48:42
90	24	Boven Digoel	Kabupaten	99662	2025-01-24 08:48:42	2025-01-24 08:48:42
91	10	Boyolali	Kabupaten	57312	2025-01-24 08:48:42	2025-01-24 08:48:42
92	10	Brebes	Kabupaten	52212	2025-01-24 08:48:42	2025-01-24 08:48:42
93	32	Bukittinggi	Kota	26115	2025-01-24 08:48:42	2025-01-24 08:48:42
94	1	Buleleng	Kabupaten	81111	2025-01-24 08:48:42	2025-01-24 08:48:42
95	28	Bulukumba	Kabupaten	92511	2025-01-24 08:48:42	2025-01-24 08:48:42
96	16	Bulungan (Bulongan)	Kabupaten	77211	2025-01-24 08:48:42	2025-01-24 08:48:42
97	8	Bungo	Kabupaten	37216	2025-01-24 08:48:42	2025-01-24 08:48:42
98	29	Buol	Kabupaten	94564	2025-01-24 08:48:42	2025-01-24 08:48:42
99	19	Buru	Kabupaten	97371	2025-01-24 08:48:42	2025-01-24 08:48:42
100	19	Buru Selatan	Kabupaten	97351	2025-01-24 08:48:42	2025-01-24 08:48:42
101	30	Buton	Kabupaten	93754	2025-01-24 08:48:42	2025-01-24 08:48:42
102	30	Buton Utara	Kabupaten	93745	2025-01-24 08:48:42	2025-01-24 08:48:42
103	9	Ciamis	Kabupaten	46211	2025-01-24 08:48:42	2025-01-24 08:48:42
104	9	Cianjur	Kabupaten	43217	2025-01-24 08:48:42	2025-01-24 08:48:42
105	10	Cilacap	Kabupaten	53211	2025-01-24 08:48:42	2025-01-24 08:48:42
106	3	Cilegon	Kota	42417	2025-01-24 08:48:42	2025-01-24 08:48:42
107	9	Cimahi	Kota	40512	2025-01-24 08:48:42	2025-01-24 08:48:42
108	9	Cirebon	Kabupaten	45611	2025-01-24 08:48:42	2025-01-24 08:48:42
109	9	Cirebon	Kota	45116	2025-01-24 08:48:42	2025-01-24 08:48:42
110	34	Dairi	Kabupaten	22211	2025-01-24 08:48:42	2025-01-24 08:48:42
111	24	Deiyai (Deliyai)	Kabupaten	98784	2025-01-24 08:48:42	2025-01-24 08:48:42
112	34	Deli Serdang	Kabupaten	20511	2025-01-24 08:48:42	2025-01-24 08:48:42
113	10	Demak	Kabupaten	59519	2025-01-24 08:48:42	2025-01-24 08:48:42
114	1	Denpasar	Kota	80227	2025-01-24 08:48:42	2025-01-24 08:48:42
115	9	Depok	Kota	16416	2025-01-24 08:48:42	2025-01-24 08:48:42
116	32	Dharmasraya	Kabupaten	27612	2025-01-24 08:48:42	2025-01-24 08:48:42
117	24	Dogiyai	Kabupaten	98866	2025-01-24 08:48:42	2025-01-24 08:48:42
118	22	Dompu	Kabupaten	84217	2025-01-24 08:48:42	2025-01-24 08:48:42
119	29	Donggala	Kabupaten	94341	2025-01-24 08:48:42	2025-01-24 08:48:42
120	26	Dumai	Kota	28811	2025-01-24 08:48:42	2025-01-24 08:48:42
121	33	Empat Lawang	Kabupaten	31811	2025-01-24 08:48:42	2025-01-24 08:48:42
122	23	Ende	Kabupaten	86351	2025-01-24 08:48:42	2025-01-24 08:48:42
123	28	Enrekang	Kabupaten	91719	2025-01-24 08:48:42	2025-01-24 08:48:42
124	25	Fakfak	Kabupaten	98651	2025-01-24 08:48:42	2025-01-24 08:48:42
125	23	Flores Timur	Kabupaten	86213	2025-01-24 08:48:42	2025-01-24 08:48:42
126	9	Garut	Kabupaten	44126	2025-01-24 08:48:42	2025-01-24 08:48:42
127	21	Gayo Lues	Kabupaten	24653	2025-01-24 08:48:42	2025-01-24 08:48:42
128	1	Gianyar	Kabupaten	80519	2025-01-24 08:48:42	2025-01-24 08:48:42
129	7	Gorontalo	Kabupaten	96218	2025-01-24 08:48:42	2025-01-24 08:48:42
130	7	Gorontalo	Kota	96115	2025-01-24 08:48:42	2025-01-24 08:48:42
131	7	Gorontalo Utara	Kabupaten	96611	2025-01-24 08:48:42	2025-01-24 08:48:42
132	28	Gowa	Kabupaten	92111	2025-01-24 08:48:42	2025-01-24 08:48:42
133	11	Gresik	Kabupaten	61115	2025-01-24 08:48:42	2025-01-24 08:48:42
134	10	Grobogan	Kabupaten	58111	2025-01-24 08:48:42	2025-01-24 08:48:42
135	5	Gunung Kidul	Kabupaten	55812	2025-01-24 08:48:42	2025-01-24 08:48:42
136	14	Gunung Mas	Kabupaten	74511	2025-01-24 08:48:42	2025-01-24 08:48:42
137	34	Gunungsitoli	Kota	22813	2025-01-24 08:48:42	2025-01-24 08:48:42
138	20	Halmahera Barat	Kabupaten	97757	2025-01-24 08:48:42	2025-01-24 08:48:42
139	20	Halmahera Selatan	Kabupaten	97911	2025-01-24 08:48:42	2025-01-24 08:48:42
140	20	Halmahera Tengah	Kabupaten	97853	2025-01-24 08:48:42	2025-01-24 08:48:42
141	20	Halmahera Timur	Kabupaten	97862	2025-01-24 08:48:42	2025-01-24 08:48:42
142	20	Halmahera Utara	Kabupaten	97762	2025-01-24 08:48:42	2025-01-24 08:48:42
143	13	Hulu Sungai Selatan	Kabupaten	71212	2025-01-24 08:48:42	2025-01-24 08:48:42
144	13	Hulu Sungai Tengah	Kabupaten	71313	2025-01-24 08:48:42	2025-01-24 08:48:42
145	13	Hulu Sungai Utara	Kabupaten	71419	2025-01-24 08:48:42	2025-01-24 08:48:42
146	34	Humbang Hasundutan	Kabupaten	22457	2025-01-24 08:48:42	2025-01-24 08:48:42
147	26	Indragiri Hilir	Kabupaten	29212	2025-01-24 08:48:42	2025-01-24 08:48:42
148	26	Indragiri Hulu	Kabupaten	29319	2025-01-24 08:48:42	2025-01-24 08:48:42
149	9	Indramayu	Kabupaten	45214	2025-01-24 08:48:42	2025-01-24 08:48:42
150	24	Intan Jaya	Kabupaten	98771	2025-01-24 08:48:42	2025-01-24 08:48:42
151	6	Jakarta Barat	Kota	11220	2025-01-24 08:48:42	2025-01-24 08:48:42
152	6	Jakarta Pusat	Kota	10540	2025-01-24 08:48:42	2025-01-24 08:48:42
153	6	Jakarta Selatan	Kota	12230	2025-01-24 08:48:42	2025-01-24 08:48:42
154	6	Jakarta Timur	Kota	13330	2025-01-24 08:48:42	2025-01-24 08:48:42
155	6	Jakarta Utara	Kota	14140	2025-01-24 08:48:42	2025-01-24 08:48:42
156	8	Jambi	Kota	36111	2025-01-24 08:48:42	2025-01-24 08:48:42
157	24	Jayapura	Kabupaten	99352	2025-01-24 08:48:42	2025-01-24 08:48:42
158	24	Jayapura	Kota	99114	2025-01-24 08:48:42	2025-01-24 08:48:42
159	24	Jayawijaya	Kabupaten	99511	2025-01-24 08:48:42	2025-01-24 08:48:42
160	11	Jember	Kabupaten	68113	2025-01-24 08:48:42	2025-01-24 08:48:42
161	1	Jembrana	Kabupaten	82251	2025-01-24 08:48:42	2025-01-24 08:48:42
162	28	Jeneponto	Kabupaten	92319	2025-01-24 08:48:42	2025-01-24 08:48:42
163	10	Jepara	Kabupaten	59419	2025-01-24 08:48:42	2025-01-24 08:48:42
164	11	Jombang	Kabupaten	61415	2025-01-24 08:48:42	2025-01-24 08:48:42
165	25	Kaimana	Kabupaten	98671	2025-01-24 08:48:42	2025-01-24 08:48:42
166	26	Kampar	Kabupaten	28411	2025-01-24 08:48:42	2025-01-24 08:48:42
167	14	Kapuas	Kabupaten	73583	2025-01-24 08:48:42	2025-01-24 08:48:42
168	12	Kapuas Hulu	Kabupaten	78719	2025-01-24 08:48:42	2025-01-24 08:48:42
169	10	Karanganyar	Kabupaten	57718	2025-01-24 08:48:42	2025-01-24 08:48:42
170	1	Karangasem	Kabupaten	80819	2025-01-24 08:48:42	2025-01-24 08:48:42
171	9	Karawang	Kabupaten	41311	2025-01-24 08:48:42	2025-01-24 08:48:42
172	17	Karimun	Kabupaten	29611	2025-01-24 08:48:42	2025-01-24 08:48:42
173	34	Karo	Kabupaten	22119	2025-01-24 08:48:42	2025-01-24 08:48:42
174	14	Katingan	Kabupaten	74411	2025-01-24 08:48:42	2025-01-24 08:48:42
175	4	Kaur	Kabupaten	38911	2025-01-24 08:48:42	2025-01-24 08:48:42
176	12	Kayong Utara	Kabupaten	78852	2025-01-24 08:48:42	2025-01-24 08:48:42
177	10	Kebumen	Kabupaten	54319	2025-01-24 08:48:42	2025-01-24 08:48:42
178	11	Kediri	Kabupaten	64184	2025-01-24 08:48:42	2025-01-24 08:48:42
179	11	Kediri	Kota	64125	2025-01-24 08:48:42	2025-01-24 08:48:42
180	24	Keerom	Kabupaten	99461	2025-01-24 08:48:42	2025-01-24 08:48:42
181	10	Kendal	Kabupaten	51314	2025-01-24 08:48:42	2025-01-24 08:48:42
182	30	Kendari	Kota	93126	2025-01-24 08:48:42	2025-01-24 08:48:42
183	4	Kepahiang	Kabupaten	39319	2025-01-24 08:48:42	2025-01-24 08:48:42
184	17	Kepulauan Anambas	Kabupaten	29991	2025-01-24 08:48:42	2025-01-24 08:48:42
185	19	Kepulauan Aru	Kabupaten	97681	2025-01-24 08:48:42	2025-01-24 08:48:42
186	32	Kepulauan Mentawai	Kabupaten	25771	2025-01-24 08:48:42	2025-01-24 08:48:42
187	26	Kepulauan Meranti	Kabupaten	28791	2025-01-24 08:48:42	2025-01-24 08:48:42
188	31	Kepulauan Sangihe	Kabupaten	95819	2025-01-24 08:48:42	2025-01-24 08:48:42
189	6	Kepulauan Seribu	Kabupaten	14550	2025-01-24 08:48:42	2025-01-24 08:48:42
190	31	Kepulauan Siau Tagulandang Biaro (Sitaro)	Kabupaten	95862	2025-01-24 08:48:42	2025-01-24 08:48:42
191	20	Kepulauan Sula	Kabupaten	97995	2025-01-24 08:48:42	2025-01-24 08:48:42
192	31	Kepulauan Talaud	Kabupaten	95885	2025-01-24 08:48:42	2025-01-24 08:48:42
193	24	Kepulauan Yapen (Yapen Waropen)	Kabupaten	98211	2025-01-24 08:48:42	2025-01-24 08:48:42
194	8	Kerinci	Kabupaten	37167	2025-01-24 08:48:42	2025-01-24 08:48:42
195	12	Ketapang	Kabupaten	78874	2025-01-24 08:48:42	2025-01-24 08:48:42
196	10	Klaten	Kabupaten	57411	2025-01-24 08:48:42	2025-01-24 08:48:42
197	1	Klungkung	Kabupaten	80719	2025-01-24 08:48:42	2025-01-24 08:48:42
198	30	Kolaka	Kabupaten	93511	2025-01-24 08:48:42	2025-01-24 08:48:42
199	30	Kolaka Utara	Kabupaten	93911	2025-01-24 08:48:42	2025-01-24 08:48:42
200	30	Konawe	Kabupaten	93411	2025-01-24 08:48:42	2025-01-24 08:48:42
201	30	Konawe Selatan	Kabupaten	93811	2025-01-24 08:48:42	2025-01-24 08:48:42
202	30	Konawe Utara	Kabupaten	93311	2025-01-24 08:48:42	2025-01-24 08:48:42
203	13	Kotabaru	Kabupaten	72119	2025-01-24 08:48:42	2025-01-24 08:48:42
204	31	Kotamobagu	Kota	95711	2025-01-24 08:48:42	2025-01-24 08:48:42
205	14	Kotawaringin Barat	Kabupaten	74119	2025-01-24 08:48:42	2025-01-24 08:48:42
206	14	Kotawaringin Timur	Kabupaten	74364	2025-01-24 08:48:42	2025-01-24 08:48:42
207	26	Kuantan Singingi	Kabupaten	29519	2025-01-24 08:48:42	2025-01-24 08:48:42
208	12	Kubu Raya	Kabupaten	78311	2025-01-24 08:48:42	2025-01-24 08:48:42
209	10	Kudus	Kabupaten	59311	2025-01-24 08:48:42	2025-01-24 08:48:42
210	5	Kulon Progo	Kabupaten	55611	2025-01-24 08:48:42	2025-01-24 08:48:42
211	9	Kuningan	Kabupaten	45511	2025-01-24 08:48:42	2025-01-24 08:48:42
212	23	Kupang	Kabupaten	85362	2025-01-24 08:48:42	2025-01-24 08:48:42
213	23	Kupang	Kota	85119	2025-01-24 08:48:42	2025-01-24 08:48:42
214	15	Kutai Barat	Kabupaten	75711	2025-01-24 08:48:42	2025-01-24 08:48:42
215	15	Kutai Kartanegara	Kabupaten	75511	2025-01-24 08:48:42	2025-01-24 08:48:42
216	15	Kutai Timur	Kabupaten	75611	2025-01-24 08:48:42	2025-01-24 08:48:42
217	34	Labuhan Batu	Kabupaten	21412	2025-01-24 08:48:42	2025-01-24 08:48:42
218	34	Labuhan Batu Selatan	Kabupaten	21511	2025-01-24 08:48:42	2025-01-24 08:48:42
219	34	Labuhan Batu Utara	Kabupaten	21711	2025-01-24 08:48:42	2025-01-24 08:48:42
220	33	Lahat	Kabupaten	31419	2025-01-24 08:48:42	2025-01-24 08:48:42
221	14	Lamandau	Kabupaten	74611	2025-01-24 08:48:42	2025-01-24 08:48:42
222	11	Lamongan	Kabupaten	64125	2025-01-24 08:48:42	2025-01-24 08:48:42
223	18	Lampung Barat	Kabupaten	34814	2025-01-24 08:48:42	2025-01-24 08:48:42
224	18	Lampung Selatan	Kabupaten	35511	2025-01-24 08:48:42	2025-01-24 08:48:42
225	18	Lampung Tengah	Kabupaten	34212	2025-01-24 08:48:42	2025-01-24 08:48:42
226	18	Lampung Timur	Kabupaten	34319	2025-01-24 08:48:42	2025-01-24 08:48:42
227	18	Lampung Utara	Kabupaten	34516	2025-01-24 08:48:42	2025-01-24 08:48:42
228	12	Landak	Kabupaten	78319	2025-01-24 08:48:42	2025-01-24 08:48:42
229	34	Langkat	Kabupaten	20811	2025-01-24 08:48:42	2025-01-24 08:48:42
230	21	Langsa	Kota	24412	2025-01-24 08:48:42	2025-01-24 08:48:42
231	24	Lanny Jaya	Kabupaten	99531	2025-01-24 08:48:42	2025-01-24 08:48:42
232	3	Lebak	Kabupaten	42319	2025-01-24 08:48:42	2025-01-24 08:48:42
233	4	Lebong	Kabupaten	39264	2025-01-24 08:48:42	2025-01-24 08:48:42
234	23	Lembata	Kabupaten	86611	2025-01-24 08:48:42	2025-01-24 08:48:42
235	21	Lhokseumawe	Kota	24352	2025-01-24 08:48:42	2025-01-24 08:48:42
236	32	Lima Puluh Koto/Kota	Kabupaten	26671	2025-01-24 08:48:42	2025-01-24 08:48:42
237	17	Lingga	Kabupaten	29811	2025-01-24 08:48:42	2025-01-24 08:48:42
238	22	Lombok Barat	Kabupaten	83311	2025-01-24 08:48:42	2025-01-24 08:48:42
239	22	Lombok Tengah	Kabupaten	83511	2025-01-24 08:48:42	2025-01-24 08:48:42
240	22	Lombok Timur	Kabupaten	83612	2025-01-24 08:48:42	2025-01-24 08:48:42
241	22	Lombok Utara	Kabupaten	83711	2025-01-24 08:48:42	2025-01-24 08:48:42
242	33	Lubuk Linggau	Kota	31614	2025-01-24 08:48:42	2025-01-24 08:48:42
243	11	Lumajang	Kabupaten	67319	2025-01-24 08:48:42	2025-01-24 08:48:42
244	28	Luwu	Kabupaten	91994	2025-01-24 08:48:42	2025-01-24 08:48:42
245	28	Luwu Timur	Kabupaten	92981	2025-01-24 08:48:42	2025-01-24 08:48:42
246	28	Luwu Utara	Kabupaten	92911	2025-01-24 08:48:42	2025-01-24 08:48:42
247	11	Madiun	Kabupaten	63153	2025-01-24 08:48:42	2025-01-24 08:48:42
248	11	Madiun	Kota	63122	2025-01-24 08:48:42	2025-01-24 08:48:42
249	10	Magelang	Kabupaten	56519	2025-01-24 08:48:42	2025-01-24 08:48:42
250	10	Magelang	Kota	56133	2025-01-24 08:48:42	2025-01-24 08:48:42
251	11	Magetan	Kabupaten	63314	2025-01-24 08:48:42	2025-01-24 08:48:42
252	9	Majalengka	Kabupaten	45412	2025-01-24 08:48:42	2025-01-24 08:48:42
253	27	Majene	Kabupaten	91411	2025-01-24 08:48:42	2025-01-24 08:48:42
254	28	Makassar	Kota	90111	2025-01-24 08:48:42	2025-01-24 08:48:42
255	11	Malang	Kabupaten	65163	2025-01-24 08:48:42	2025-01-24 08:48:42
256	11	Malang	Kota	65112	2025-01-24 08:48:42	2025-01-24 08:48:42
257	16	Malinau	Kabupaten	77511	2025-01-24 08:48:42	2025-01-24 08:48:42
258	19	Maluku Barat Daya	Kabupaten	97451	2025-01-24 08:48:42	2025-01-24 08:48:42
259	19	Maluku Tengah	Kabupaten	97513	2025-01-24 08:48:42	2025-01-24 08:48:42
260	19	Maluku Tenggara	Kabupaten	97651	2025-01-24 08:48:42	2025-01-24 08:48:42
261	19	Maluku Tenggara Barat	Kabupaten	97465	2025-01-24 08:48:42	2025-01-24 08:48:42
262	27	Mamasa	Kabupaten	91362	2025-01-24 08:48:42	2025-01-24 08:48:42
263	24	Mamberamo Raya	Kabupaten	99381	2025-01-24 08:48:42	2025-01-24 08:48:42
264	24	Mamberamo Tengah	Kabupaten	99553	2025-01-24 08:48:42	2025-01-24 08:48:42
265	27	Mamuju	Kabupaten	91519	2025-01-24 08:48:42	2025-01-24 08:48:42
266	27	Mamuju Utara	Kabupaten	91571	2025-01-24 08:48:42	2025-01-24 08:48:42
267	31	Manado	Kota	95247	2025-01-24 08:48:42	2025-01-24 08:48:42
268	34	Mandailing Natal	Kabupaten	22916	2025-01-24 08:48:42	2025-01-24 08:48:42
269	23	Manggarai	Kabupaten	86551	2025-01-24 08:48:42	2025-01-24 08:48:42
270	23	Manggarai Barat	Kabupaten	86711	2025-01-24 08:48:42	2025-01-24 08:48:42
271	23	Manggarai Timur	Kabupaten	86811	2025-01-24 08:48:42	2025-01-24 08:48:42
272	25	Manokwari	Kabupaten	98311	2025-01-24 08:48:42	2025-01-24 08:48:42
273	25	Manokwari Selatan	Kabupaten	98355	2025-01-24 08:48:42	2025-01-24 08:48:42
274	24	Mappi	Kabupaten	99853	2025-01-24 08:48:42	2025-01-24 08:48:42
275	28	Maros	Kabupaten	90511	2025-01-24 08:48:42	2025-01-24 08:48:42
276	22	Mataram	Kota	83131	2025-01-24 08:48:42	2025-01-24 08:48:42
277	25	Maybrat	Kabupaten	98051	2025-01-24 08:48:42	2025-01-24 08:48:42
278	34	Medan	Kota	20228	2025-01-24 08:48:42	2025-01-24 08:48:42
279	12	Melawi	Kabupaten	78619	2025-01-24 08:48:42	2025-01-24 08:48:42
280	8	Merangin	Kabupaten	37319	2025-01-24 08:48:42	2025-01-24 08:48:42
281	24	Merauke	Kabupaten	99613	2025-01-24 08:48:42	2025-01-24 08:48:42
282	18	Mesuji	Kabupaten	34911	2025-01-24 08:48:42	2025-01-24 08:48:42
283	18	Metro	Kota	34111	2025-01-24 08:48:42	2025-01-24 08:48:42
284	24	Mimika	Kabupaten	99962	2025-01-24 08:48:42	2025-01-24 08:48:42
285	31	Minahasa	Kabupaten	95614	2025-01-24 08:48:42	2025-01-24 08:48:42
286	31	Minahasa Selatan	Kabupaten	95914	2025-01-24 08:48:42	2025-01-24 08:48:42
287	31	Minahasa Tenggara	Kabupaten	95995	2025-01-24 08:48:42	2025-01-24 08:48:42
288	31	Minahasa Utara	Kabupaten	95316	2025-01-24 08:48:42	2025-01-24 08:48:42
289	11	Mojokerto	Kabupaten	61382	2025-01-24 08:48:42	2025-01-24 08:48:42
290	11	Mojokerto	Kota	61316	2025-01-24 08:48:42	2025-01-24 08:48:42
291	29	Morowali	Kabupaten	94911	2025-01-24 08:48:42	2025-01-24 08:48:42
292	33	Muara Enim	Kabupaten	31315	2025-01-24 08:48:42	2025-01-24 08:48:42
293	8	Muaro Jambi	Kabupaten	36311	2025-01-24 08:48:42	2025-01-24 08:48:42
294	4	Muko Muko	Kabupaten	38715	2025-01-24 08:48:42	2025-01-24 08:48:42
295	30	Muna	Kabupaten	93611	2025-01-24 08:48:42	2025-01-24 08:48:42
296	14	Murung Raya	Kabupaten	73911	2025-01-24 08:48:42	2025-01-24 08:48:42
297	33	Musi Banyuasin	Kabupaten	30719	2025-01-24 08:48:42	2025-01-24 08:48:42
298	33	Musi Rawas	Kabupaten	31661	2025-01-24 08:48:42	2025-01-24 08:48:42
299	24	Nabire	Kabupaten	98816	2025-01-24 08:48:42	2025-01-24 08:48:42
300	21	Nagan Raya	Kabupaten	23674	2025-01-24 08:48:42	2025-01-24 08:48:42
301	23	Nagekeo	Kabupaten	86911	2025-01-24 08:48:42	2025-01-24 08:48:42
302	17	Natuna	Kabupaten	29711	2025-01-24 08:48:42	2025-01-24 08:48:42
303	24	Nduga	Kabupaten	99541	2025-01-24 08:48:42	2025-01-24 08:48:42
304	23	Ngada	Kabupaten	86413	2025-01-24 08:48:42	2025-01-24 08:48:42
305	11	Nganjuk	Kabupaten	64414	2025-01-24 08:48:42	2025-01-24 08:48:42
306	11	Ngawi	Kabupaten	63219	2025-01-24 08:48:42	2025-01-24 08:48:42
307	34	Nias	Kabupaten	22876	2025-01-24 08:48:42	2025-01-24 08:48:42
308	34	Nias Barat	Kabupaten	22895	2025-01-24 08:48:42	2025-01-24 08:48:42
309	34	Nias Selatan	Kabupaten	22865	2025-01-24 08:48:42	2025-01-24 08:48:42
310	34	Nias Utara	Kabupaten	22856	2025-01-24 08:48:42	2025-01-24 08:48:42
311	16	Nunukan	Kabupaten	77421	2025-01-24 08:48:42	2025-01-24 08:48:42
312	33	Ogan Ilir	Kabupaten	30811	2025-01-24 08:48:42	2025-01-24 08:48:42
313	33	Ogan Komering Ilir	Kabupaten	30618	2025-01-24 08:48:42	2025-01-24 08:48:42
314	33	Ogan Komering Ulu	Kabupaten	32112	2025-01-24 08:48:42	2025-01-24 08:48:42
315	33	Ogan Komering Ulu Selatan	Kabupaten	32211	2025-01-24 08:48:42	2025-01-24 08:48:42
316	33	Ogan Komering Ulu Timur	Kabupaten	32312	2025-01-24 08:48:42	2025-01-24 08:48:42
317	11	Pacitan	Kabupaten	63512	2025-01-24 08:48:42	2025-01-24 08:48:42
318	32	Padang	Kota	25112	2025-01-24 08:48:42	2025-01-24 08:48:42
319	34	Padang Lawas	Kabupaten	22763	2025-01-24 08:48:42	2025-01-24 08:48:42
320	34	Padang Lawas Utara	Kabupaten	22753	2025-01-24 08:48:42	2025-01-24 08:48:42
321	32	Padang Panjang	Kota	27122	2025-01-24 08:48:42	2025-01-24 08:48:42
322	32	Padang Pariaman	Kabupaten	25583	2025-01-24 08:48:42	2025-01-24 08:48:42
323	34	Padang Sidempuan	Kota	22727	2025-01-24 08:48:42	2025-01-24 08:48:42
324	33	Pagar Alam	Kota	31512	2025-01-24 08:48:42	2025-01-24 08:48:42
325	34	Pakpak Bharat	Kabupaten	22272	2025-01-24 08:48:42	2025-01-24 08:48:42
326	14	Palangka Raya	Kota	73112	2025-01-24 08:48:42	2025-01-24 08:48:42
327	33	Palembang	Kota	30111	2025-01-24 08:48:42	2025-01-24 08:48:42
328	28	Palopo	Kota	91911	2025-01-24 08:48:42	2025-01-24 08:48:42
329	29	Palu	Kota	94111	2025-01-24 08:48:42	2025-01-24 08:48:42
330	11	Pamekasan	Kabupaten	69319	2025-01-24 08:48:42	2025-01-24 08:48:42
331	3	Pandeglang	Kabupaten	42212	2025-01-24 08:48:42	2025-01-24 08:48:42
332	9	Pangandaran	Kabupaten	46511	2025-01-24 08:48:42	2025-01-24 08:48:42
333	28	Pangkajene Kepulauan	Kabupaten	90611	2025-01-24 08:48:42	2025-01-24 08:48:42
334	2	Pangkal Pinang	Kota	33115	2025-01-24 08:48:42	2025-01-24 08:48:42
335	24	Paniai	Kabupaten	98765	2025-01-24 08:48:42	2025-01-24 08:48:42
336	28	Parepare	Kota	91123	2025-01-24 08:48:42	2025-01-24 08:48:42
337	32	Pariaman	Kota	25511	2025-01-24 08:48:42	2025-01-24 08:48:42
338	29	Parigi Moutong	Kabupaten	94411	2025-01-24 08:48:42	2025-01-24 08:48:42
339	32	Pasaman	Kabupaten	26318	2025-01-24 08:48:42	2025-01-24 08:48:42
340	32	Pasaman Barat	Kabupaten	26511	2025-01-24 08:48:42	2025-01-24 08:48:42
341	15	Paser	Kabupaten	76211	2025-01-24 08:48:42	2025-01-24 08:48:42
342	11	Pasuruan	Kabupaten	67153	2025-01-24 08:48:42	2025-01-24 08:48:42
343	11	Pasuruan	Kota	67118	2025-01-24 08:48:42	2025-01-24 08:48:42
344	10	Pati	Kabupaten	59114	2025-01-24 08:48:42	2025-01-24 08:48:42
345	32	Payakumbuh	Kota	26213	2025-01-24 08:48:42	2025-01-24 08:48:42
346	25	Pegunungan Arfak	Kabupaten	98354	2025-01-24 08:48:42	2025-01-24 08:48:42
347	24	Pegunungan Bintang	Kabupaten	99573	2025-01-24 08:48:42	2025-01-24 08:48:42
348	10	Pekalongan	Kabupaten	51161	2025-01-24 08:48:42	2025-01-24 08:48:42
349	10	Pekalongan	Kota	51122	2025-01-24 08:48:42	2025-01-24 08:48:42
350	26	Pekanbaru	Kota	28112	2025-01-24 08:48:42	2025-01-24 08:48:42
351	26	Pelalawan	Kabupaten	28311	2025-01-24 08:48:42	2025-01-24 08:48:42
352	10	Pemalang	Kabupaten	52319	2025-01-24 08:48:42	2025-01-24 08:48:42
353	34	Pematang Siantar	Kota	21126	2025-01-24 08:48:42	2025-01-24 08:48:42
354	15	Penajam Paser Utara	Kabupaten	76311	2025-01-24 08:48:42	2025-01-24 08:48:42
355	18	Pesawaran	Kabupaten	35312	2025-01-24 08:48:42	2025-01-24 08:48:42
356	18	Pesisir Barat	Kabupaten	35974	2025-01-24 08:48:42	2025-01-24 08:48:42
357	32	Pesisir Selatan	Kabupaten	25611	2025-01-24 08:48:42	2025-01-24 08:48:42
358	21	Pidie	Kabupaten	24116	2025-01-24 08:48:42	2025-01-24 08:48:42
359	21	Pidie Jaya	Kabupaten	24186	2025-01-24 08:48:42	2025-01-24 08:48:42
360	28	Pinrang	Kabupaten	91251	2025-01-24 08:48:42	2025-01-24 08:48:42
361	7	Pohuwato	Kabupaten	96419	2025-01-24 08:48:42	2025-01-24 08:48:42
362	27	Polewali Mandar	Kabupaten	91311	2025-01-24 08:48:42	2025-01-24 08:48:42
363	11	Ponorogo	Kabupaten	63411	2025-01-24 08:48:42	2025-01-24 08:48:42
364	12	Pontianak	Kabupaten	78971	2025-01-24 08:48:42	2025-01-24 08:48:42
365	12	Pontianak	Kota	78112	2025-01-24 08:48:42	2025-01-24 08:48:42
366	29	Poso	Kabupaten	94615	2025-01-24 08:48:42	2025-01-24 08:48:42
367	33	Prabumulih	Kota	31121	2025-01-24 08:48:42	2025-01-24 08:48:42
368	18	Pringsewu	Kabupaten	35719	2025-01-24 08:48:42	2025-01-24 08:48:42
369	11	Probolinggo	Kabupaten	67282	2025-01-24 08:48:42	2025-01-24 08:48:42
370	11	Probolinggo	Kota	67215	2025-01-24 08:48:42	2025-01-24 08:48:42
371	14	Pulang Pisau	Kabupaten	74811	2025-01-24 08:48:42	2025-01-24 08:48:42
372	20	Pulau Morotai	Kabupaten	97771	2025-01-24 08:48:42	2025-01-24 08:48:42
373	24	Puncak	Kabupaten	98981	2025-01-24 08:48:42	2025-01-24 08:48:42
374	24	Puncak Jaya	Kabupaten	98979	2025-01-24 08:48:42	2025-01-24 08:48:42
375	10	Purbalingga	Kabupaten	53312	2025-01-24 08:48:42	2025-01-24 08:48:42
376	9	Purwakarta	Kabupaten	41119	2025-01-24 08:48:42	2025-01-24 08:48:42
377	10	Purworejo	Kabupaten	54111	2025-01-24 08:48:42	2025-01-24 08:48:42
378	25	Raja Ampat	Kabupaten	98489	2025-01-24 08:48:42	2025-01-24 08:48:42
379	4	Rejang Lebong	Kabupaten	39112	2025-01-24 08:48:42	2025-01-24 08:48:42
380	10	Rembang	Kabupaten	59219	2025-01-24 08:48:42	2025-01-24 08:48:42
381	26	Rokan Hilir	Kabupaten	28992	2025-01-24 08:48:42	2025-01-24 08:48:42
382	26	Rokan Hulu	Kabupaten	28511	2025-01-24 08:48:42	2025-01-24 08:48:42
383	23	Rote Ndao	Kabupaten	85982	2025-01-24 08:48:42	2025-01-24 08:48:42
384	21	Sabang	Kota	23512	2025-01-24 08:48:42	2025-01-24 08:48:42
385	23	Sabu Raijua	Kabupaten	85391	2025-01-24 08:48:42	2025-01-24 08:48:42
386	10	Salatiga	Kota	50711	2025-01-24 08:48:42	2025-01-24 08:48:42
387	15	Samarinda	Kota	75133	2025-01-24 08:48:42	2025-01-24 08:48:42
388	12	Sambas	Kabupaten	79453	2025-01-24 08:48:42	2025-01-24 08:48:42
389	34	Samosir	Kabupaten	22392	2025-01-24 08:48:42	2025-01-24 08:48:42
390	11	Sampang	Kabupaten	69219	2025-01-24 08:48:42	2025-01-24 08:48:42
391	12	Sanggau	Kabupaten	78557	2025-01-24 08:48:42	2025-01-24 08:48:42
392	24	Sarmi	Kabupaten	99373	2025-01-24 08:48:42	2025-01-24 08:48:42
393	8	Sarolangun	Kabupaten	37419	2025-01-24 08:48:42	2025-01-24 08:48:42
394	32	Sawah Lunto	Kota	27416	2025-01-24 08:48:42	2025-01-24 08:48:42
395	12	Sekadau	Kabupaten	79583	2025-01-24 08:48:42	2025-01-24 08:48:42
396	28	Selayar (Kepulauan Selayar)	Kabupaten	92812	2025-01-24 08:48:42	2025-01-24 08:48:42
397	4	Seluma	Kabupaten	38811	2025-01-24 08:48:42	2025-01-24 08:48:42
398	10	Semarang	Kabupaten	50511	2025-01-24 08:48:42	2025-01-24 08:48:42
399	10	Semarang	Kota	50135	2025-01-24 08:48:42	2025-01-24 08:48:42
400	19	Seram Bagian Barat	Kabupaten	97561	2025-01-24 08:48:42	2025-01-24 08:48:42
401	19	Seram Bagian Timur	Kabupaten	97581	2025-01-24 08:48:42	2025-01-24 08:48:42
402	3	Serang	Kabupaten	42182	2025-01-24 08:48:42	2025-01-24 08:48:42
403	3	Serang	Kota	42111	2025-01-24 08:48:42	2025-01-24 08:48:42
404	34	Serdang Bedagai	Kabupaten	20915	2025-01-24 08:48:42	2025-01-24 08:48:42
405	14	Seruyan	Kabupaten	74211	2025-01-24 08:48:42	2025-01-24 08:48:42
406	26	Siak	Kabupaten	28623	2025-01-24 08:48:42	2025-01-24 08:48:42
407	34	Sibolga	Kota	22522	2025-01-24 08:48:42	2025-01-24 08:48:42
408	28	Sidenreng Rappang/Rapang	Kabupaten	91613	2025-01-24 08:48:42	2025-01-24 08:48:42
409	11	Sidoarjo	Kabupaten	61219	2025-01-24 08:48:42	2025-01-24 08:48:42
410	29	Sigi	Kabupaten	94364	2025-01-24 08:48:42	2025-01-24 08:48:42
411	32	Sijunjung (Sawah Lunto Sijunjung)	Kabupaten	27511	2025-01-24 08:48:42	2025-01-24 08:48:42
412	23	Sikka	Kabupaten	86121	2025-01-24 08:48:42	2025-01-24 08:48:42
413	34	Simalungun	Kabupaten	21162	2025-01-24 08:48:42	2025-01-24 08:48:42
414	21	Simeulue	Kabupaten	23891	2025-01-24 08:48:42	2025-01-24 08:48:42
415	12	Singkawang	Kota	79117	2025-01-24 08:48:42	2025-01-24 08:48:42
416	28	Sinjai	Kabupaten	92615	2025-01-24 08:48:42	2025-01-24 08:48:42
417	12	Sintang	Kabupaten	78619	2025-01-24 08:48:42	2025-01-24 08:48:42
418	11	Situbondo	Kabupaten	68316	2025-01-24 08:48:42	2025-01-24 08:48:42
419	5	Sleman	Kabupaten	55513	2025-01-24 08:48:42	2025-01-24 08:48:42
420	32	Solok	Kabupaten	27365	2025-01-24 08:48:42	2025-01-24 08:48:42
421	32	Solok	Kota	27315	2025-01-24 08:48:42	2025-01-24 08:48:42
422	32	Solok Selatan	Kabupaten	27779	2025-01-24 08:48:42	2025-01-24 08:48:42
423	28	Soppeng	Kabupaten	90812	2025-01-24 08:48:42	2025-01-24 08:48:42
424	25	Sorong	Kabupaten	98431	2025-01-24 08:48:42	2025-01-24 08:48:42
425	25	Sorong	Kota	98411	2025-01-24 08:48:42	2025-01-24 08:48:42
426	25	Sorong Selatan	Kabupaten	98454	2025-01-24 08:48:42	2025-01-24 08:48:42
427	10	Sragen	Kabupaten	57211	2025-01-24 08:48:42	2025-01-24 08:48:42
428	9	Subang	Kabupaten	41215	2025-01-24 08:48:42	2025-01-24 08:48:42
429	21	Subulussalam	Kota	24882	2025-01-24 08:48:42	2025-01-24 08:48:42
430	9	Sukabumi	Kabupaten	43311	2025-01-24 08:48:42	2025-01-24 08:48:42
431	9	Sukabumi	Kota	43114	2025-01-24 08:48:42	2025-01-24 08:48:42
432	14	Sukamara	Kabupaten	74712	2025-01-24 08:48:42	2025-01-24 08:48:42
433	10	Sukoharjo	Kabupaten	57514	2025-01-24 08:48:42	2025-01-24 08:48:42
434	23	Sumba Barat	Kabupaten	87219	2025-01-24 08:48:42	2025-01-24 08:48:42
435	23	Sumba Barat Daya	Kabupaten	87453	2025-01-24 08:48:42	2025-01-24 08:48:42
436	23	Sumba Tengah	Kabupaten	87358	2025-01-24 08:48:42	2025-01-24 08:48:42
437	23	Sumba Timur	Kabupaten	87112	2025-01-24 08:48:42	2025-01-24 08:48:42
438	22	Sumbawa	Kabupaten	84315	2025-01-24 08:48:42	2025-01-24 08:48:42
439	22	Sumbawa Barat	Kabupaten	84419	2025-01-24 08:48:42	2025-01-24 08:48:42
440	9	Sumedang	Kabupaten	45326	2025-01-24 08:48:42	2025-01-24 08:48:42
441	11	Sumenep	Kabupaten	69413	2025-01-24 08:48:42	2025-01-24 08:48:42
442	8	Sungaipenuh	Kota	37113	2025-01-24 08:48:42	2025-01-24 08:48:42
443	24	Supiori	Kabupaten	98164	2025-01-24 08:48:42	2025-01-24 08:48:42
444	11	Surabaya	Kota	60119	2025-01-24 08:48:42	2025-01-24 08:48:42
445	10	Surakarta (Solo)	Kota	57113	2025-01-24 08:48:42	2025-01-24 08:48:42
446	13	Tabalong	Kabupaten	71513	2025-01-24 08:48:42	2025-01-24 08:48:42
447	1	Tabanan	Kabupaten	82119	2025-01-24 08:48:42	2025-01-24 08:48:42
448	28	Takalar	Kabupaten	92212	2025-01-24 08:48:42	2025-01-24 08:48:42
449	25	Tambrauw	Kabupaten	98475	2025-01-24 08:48:42	2025-01-24 08:48:42
450	16	Tana Tidung	Kabupaten	77611	2025-01-24 08:48:42	2025-01-24 08:48:42
451	28	Tana Toraja	Kabupaten	91819	2025-01-24 08:48:42	2025-01-24 08:48:42
452	13	Tanah Bumbu	Kabupaten	72211	2025-01-24 08:48:42	2025-01-24 08:48:42
453	32	Tanah Datar	Kabupaten	27211	2025-01-24 08:48:42	2025-01-24 08:48:42
454	13	Tanah Laut	Kabupaten	70811	2025-01-24 08:48:42	2025-01-24 08:48:42
455	3	Tangerang	Kabupaten	15914	2025-01-24 08:48:42	2025-01-24 08:48:42
456	3	Tangerang	Kota	15111	2025-01-24 08:48:42	2025-01-24 08:48:42
457	3	Tangerang Selatan	Kota	15435	2025-01-24 08:48:42	2025-01-24 08:48:42
458	18	Tanggamus	Kabupaten	35619	2025-01-24 08:48:42	2025-01-24 08:48:42
459	34	Tanjung Balai	Kota	21321	2025-01-24 08:48:42	2025-01-24 08:48:42
460	8	Tanjung Jabung Barat	Kabupaten	36513	2025-01-24 08:48:42	2025-01-24 08:48:42
461	8	Tanjung Jabung Timur	Kabupaten	36719	2025-01-24 08:48:42	2025-01-24 08:48:42
462	17	Tanjung Pinang	Kota	29111	2025-01-24 08:48:42	2025-01-24 08:48:42
463	34	Tapanuli Selatan	Kabupaten	22742	2025-01-24 08:48:42	2025-01-24 08:48:42
464	34	Tapanuli Tengah	Kabupaten	22611	2025-01-24 08:48:42	2025-01-24 08:48:42
465	34	Tapanuli Utara	Kabupaten	22414	2025-01-24 08:48:42	2025-01-24 08:48:42
466	13	Tapin	Kabupaten	71119	2025-01-24 08:48:42	2025-01-24 08:48:42
467	16	Tarakan	Kota	77114	2025-01-24 08:48:42	2025-01-24 08:48:42
468	9	Tasikmalaya	Kabupaten	46411	2025-01-24 08:48:42	2025-01-24 08:48:42
469	9	Tasikmalaya	Kota	46116	2025-01-24 08:48:42	2025-01-24 08:48:42
470	34	Tebing Tinggi	Kota	20632	2025-01-24 08:48:42	2025-01-24 08:48:42
471	8	Tebo	Kabupaten	37519	2025-01-24 08:48:42	2025-01-24 08:48:42
472	10	Tegal	Kabupaten	52419	2025-01-24 08:48:42	2025-01-24 08:48:42
473	10	Tegal	Kota	52114	2025-01-24 08:48:42	2025-01-24 08:48:42
474	25	Teluk Bintuni	Kabupaten	98551	2025-01-24 08:48:42	2025-01-24 08:48:42
475	25	Teluk Wondama	Kabupaten	98591	2025-01-24 08:48:42	2025-01-24 08:48:42
476	10	Temanggung	Kabupaten	56212	2025-01-24 08:48:42	2025-01-24 08:48:42
477	20	Ternate	Kota	97714	2025-01-24 08:48:42	2025-01-24 08:48:42
478	20	Tidore Kepulauan	Kota	97815	2025-01-24 08:48:42	2025-01-24 08:48:42
479	23	Timor Tengah Selatan	Kabupaten	85562	2025-01-24 08:48:42	2025-01-24 08:48:42
480	23	Timor Tengah Utara	Kabupaten	85612	2025-01-24 08:48:42	2025-01-24 08:48:42
481	34	Toba Samosir	Kabupaten	22316	2025-01-24 08:48:42	2025-01-24 08:48:42
482	29	Tojo Una-Una	Kabupaten	94683	2025-01-24 08:48:42	2025-01-24 08:48:42
483	29	Toli-Toli	Kabupaten	94542	2025-01-24 08:48:42	2025-01-24 08:48:42
484	24	Tolikara	Kabupaten	99411	2025-01-24 08:48:42	2025-01-24 08:48:42
485	31	Tomohon	Kota	95416	2025-01-24 08:48:42	2025-01-24 08:48:42
486	28	Toraja Utara	Kabupaten	91831	2025-01-24 08:48:42	2025-01-24 08:48:42
487	11	Trenggalek	Kabupaten	66312	2025-01-24 08:48:42	2025-01-24 08:48:42
488	19	Tual	Kota	97612	2025-01-24 08:48:42	2025-01-24 08:48:42
489	11	Tuban	Kabupaten	62319	2025-01-24 08:48:42	2025-01-24 08:48:42
490	18	Tulang Bawang	Kabupaten	34613	2025-01-24 08:48:42	2025-01-24 08:48:42
491	18	Tulang Bawang Barat	Kabupaten	34419	2025-01-24 08:48:42	2025-01-24 08:48:42
492	11	Tulungagung	Kabupaten	66212	2025-01-24 08:48:42	2025-01-24 08:48:42
493	28	Wajo	Kabupaten	90911	2025-01-24 08:48:42	2025-01-24 08:48:42
494	30	Wakatobi	Kabupaten	93791	2025-01-24 08:48:42	2025-01-24 08:48:42
495	24	Waropen	Kabupaten	98269	2025-01-24 08:48:42	2025-01-24 08:48:42
496	18	Way Kanan	Kabupaten	34711	2025-01-24 08:48:42	2025-01-24 08:48:42
497	10	Wonogiri	Kabupaten	57619	2025-01-24 08:48:42	2025-01-24 08:48:42
498	10	Wonosobo	Kabupaten	56311	2025-01-24 08:48:42	2025-01-24 08:48:42
499	24	Yahukimo	Kabupaten	99041	2025-01-24 08:48:42	2025-01-24 08:48:42
500	24	Yalimo	Kabupaten	99481	2025-01-24 08:48:42	2025-01-24 08:48:42
501	5	Yogyakarta	Kota	55111	2025-01-24 08:48:42	2025-01-24 08:48:42
\.


--
-- Data for Name: role_menu_mobiles; Type: TABLE DATA; Schema: public; Owner: admin
--

COPY public.role_menu_mobiles (id, site_id, role_id, menu_mobile_id, role_access, created_at, updated_at) FROM stdin;
\.


--
-- Data for Name: role_menus; Type: TABLE DATA; Schema: public; Owner: admin
--

COPY public.role_menus (id, site_id, role_id, menu_id, role_access, created_at, updated_at, redirect_to) FROM stdin;
1	1	1	2	1	2025-01-26 20:12:38	2025-01-26 20:12:38	0
2	1	1	3	1	2025-01-26 20:12:54	2025-01-26 20:12:54	0
3	1	1	4	1	2025-01-26 20:12:57	2025-01-26 20:12:57	0
4	1	1	5	1	2025-01-26 20:13:00	2025-01-26 20:13:00	0
5	1	1	6	1	2025-01-26 20:13:03	2025-01-26 20:13:03	0
6	1	1	7	1	2025-01-26 20:30:30	2025-01-26 20:30:30	0
7	1	1	8	1	2025-01-26 20:30:30	2025-01-26 20:30:30	0
\.


--
-- Data for Name: role_user; Type: TABLE DATA; Schema: public; Owner: admin
--

COPY public.role_user (user_id, role_id) FROM stdin;
1	1
\.


--
-- Data for Name: roles; Type: TABLE DATA; Schema: public; Owner: admin
--

COPY public.roles (id, site_id, name, display_name, description, created_at, updated_at) FROM stdin;
1	1	adminsite	Administrator Site	\N	2023-12-03 08:56:46	2023-12-03 08:56:46
\.


--
-- Data for Name: site_configs; Type: TABLE DATA; Schema: public; Owner: admin
--

COPY public.site_configs (id, site_id, option, value, created_at, updated_at) FROM stdin;
\.


--
-- Data for Name: sites; Type: TABLE DATA; Schema: public; Owner: admin
--

COPY public.sites (id, slug, name, created_at, updated_at, code, email, phone, address, logo, status, long_logo) FROM stdin;
1	balisuperhost	Bali Superhost	2023-12-19 05:58:20	2024-07-15 12:29:26	headoffice	bsh.ho@bshoffice.com	08111111111	Jalan Raya Mas	media/sites/logobalisuperhost.png	1	media/sites/longbalisuperhost.png
\.


--
-- Data for Name: titles; Type: TABLE DATA; Schema: public; Owner: admin
--

COPY public.titles (id, site_id, code, name, created_at, updated_at, "order") FROM stdin;
\.


--
-- Data for Name: user_customers; Type: TABLE DATA; Schema: public; Owner: admin
--

COPY public.user_customers (user_id, customer_id) FROM stdin;
\.


--
-- Data for Name: user_employees; Type: TABLE DATA; Schema: public; Owner: admin
--

COPY public.user_employees (user_id, employee_id) FROM stdin;
\.


--
-- Data for Name: user_logs; Type: TABLE DATA; Schema: public; Owner: admin
--

COPY public.user_logs (id, site_id, user_id, ip_address, device, last_login, created_at, updated_at) FROM stdin;
\.



--
-- Name: account_categories account_categories_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.account_categories
    ADD CONSTRAINT account_categories_pkey PRIMARY KEY (id);


--
-- Name: account_mappings account_mappings_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.account_mappings
    ADD CONSTRAINT account_mappings_pkey PRIMARY KEY (id);


--
-- Name: accounts accounts_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.accounts
    ADD CONSTRAINT accounts_pkey PRIMARY KEY (id);


--
-- Name: admin_permission_role admin_permission_role_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.admin_permission_role
    ADD CONSTRAINT admin_permission_role_pkey PRIMARY KEY (permission_id, role_id);


--
-- Name: admin_permissions admin_permissions_name_unique; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.admin_permissions
    ADD CONSTRAINT admin_permissions_name_unique UNIQUE (name);


--
-- Name: admin_permissions admin_permissions_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.admin_permissions
    ADD CONSTRAINT admin_permissions_pkey PRIMARY KEY (id);


--
-- Name: admin_role_user admin_role_user_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.admin_role_user
    ADD CONSTRAINT admin_role_user_pkey PRIMARY KEY (user_id, role_id);


--
-- Name: admin_roles admin_roles_name_unique; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.admin_roles
    ADD CONSTRAINT admin_roles_name_unique UNIQUE (name);


--
-- Name: admin_roles admin_roles_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.admin_roles
    ADD CONSTRAINT admin_roles_pkey PRIMARY KEY (id);


--
-- Name: auto_numbers auto_numbers_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.auto_numbers
    ADD CONSTRAINT auto_numbers_pkey PRIMARY KEY (id);


--
-- Name: banks banks_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.banks
    ADD CONSTRAINT banks_pkey PRIMARY KEY (id);


--
-- Name: configs configs_option_unique; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.configs
    ADD CONSTRAINT configs_option_unique UNIQUE (option);


--
-- Name: configs configs_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.configs
    ADD CONSTRAINT configs_pkey PRIMARY KEY (id);


--
-- Name: customer_accounts customer_accounts_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.customer_accounts
    ADD CONSTRAINT customer_accounts_pkey PRIMARY KEY (id);


--
-- Name: customer_bank_accounts customer_bank_accounts_account_no_unique; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.customer_bank_accounts
    ADD CONSTRAINT customer_bank_accounts_account_no_unique UNIQUE (account_no);


--
-- Name: customer_bank_accounts customer_bank_accounts_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.customer_bank_accounts
    ADD CONSTRAINT customer_bank_accounts_pkey PRIMARY KEY (id);


--
-- Name: customer_categories customer_categories_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.customer_categories
    ADD CONSTRAINT customer_categories_pkey PRIMARY KEY (id);


--
-- Name: customer_contacts customer_contacts_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.customer_contacts
    ADD CONSTRAINT customer_contacts_pkey PRIMARY KEY (id);


--
-- Name: customer_documents customer_documents_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.customer_documents
    ADD CONSTRAINT customer_documents_pkey PRIMARY KEY (id);


--
-- Name: customers customers_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.customers
    ADD CONSTRAINT customers_pkey PRIMARY KEY (id);


--
-- Name: departments departments_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.departments
    ADD CONSTRAINT departments_pkey PRIMARY KEY (id);


--
-- Name: districts districts_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.districts
    ADD CONSTRAINT districts_pkey PRIMARY KEY (id);


--
-- Name: employees employees_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.employees
    ADD CONSTRAINT employees_pkey PRIMARY KEY (id);


--
-- Name: menu_mobiles menu_mobiles_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.menu_mobiles
    ADD CONSTRAINT menu_mobiles_pkey PRIMARY KEY (id);


--
-- Name: menus menus_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.menus
    ADD CONSTRAINT menus_pkey PRIMARY KEY (id);


--
-- Name: migrations migrations_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.migrations
    ADD CONSTRAINT migrations_pkey PRIMARY KEY (id);


--
-- Name: permission_role permission_role_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.permission_role
    ADD CONSTRAINT permission_role_pkey PRIMARY KEY (permission_id, role_id);


--
-- Name: permissions permissions_name_unique; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.permissions
    ADD CONSTRAINT permissions_name_unique UNIQUE (name);


--
-- Name: permissions permissions_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.permissions
    ADD CONSTRAINT permissions_pkey PRIMARY KEY (id);


--
-- Name: provinces provinces_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.provinces
    ADD CONSTRAINT provinces_pkey PRIMARY KEY (id);


--
-- Name: regions regions_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.regions
    ADD CONSTRAINT regions_pkey PRIMARY KEY (id);


--
-- Name: role_menu_mobiles role_menu_mobiles_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.role_menu_mobiles
    ADD CONSTRAINT role_menu_mobiles_pkey PRIMARY KEY (id);


--
-- Name: role_menus role_menus_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.role_menus
    ADD CONSTRAINT role_menus_pkey PRIMARY KEY (id);


--
-- Name: role_user role_user_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.role_user
    ADD CONSTRAINT role_user_pkey PRIMARY KEY (user_id, role_id);


--
-- Name: roles roles_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.roles
    ADD CONSTRAINT roles_pkey PRIMARY KEY (id);


--
-- Name: roles roles_site_id_name_unique; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.roles
    ADD CONSTRAINT roles_site_id_name_unique UNIQUE (site_id, name);


--
-- Name: site_configs site_configs_option_unique; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.site_configs
    ADD CONSTRAINT site_configs_option_unique UNIQUE (option);


--
-- Name: site_configs site_configs_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.site_configs
    ADD CONSTRAINT site_configs_pkey PRIMARY KEY (id);


--
-- Name: sites sites_name_unique; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.sites
    ADD CONSTRAINT sites_name_unique UNIQUE (name);


--
-- Name: sites sites_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.sites
    ADD CONSTRAINT sites_pkey PRIMARY KEY (id);


--
-- Name: sites sites_slug_unique; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.sites
    ADD CONSTRAINT sites_slug_unique UNIQUE (slug);


--
-- Name: titles titles_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.titles
    ADD CONSTRAINT titles_pkey PRIMARY KEY (id);


--
-- Name: user_logs user_logs_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.user_logs
    ADD CONSTRAINT user_logs_pkey PRIMARY KEY (id);


--
-- Name: account_mappings account_mappings_account_from_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.account_mappings
    ADD CONSTRAINT account_mappings_account_from_id_foreign FOREIGN KEY (account_from_id) REFERENCES public.accounts(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: account_mappings account_mappings_account_to_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.account_mappings
    ADD CONSTRAINT account_mappings_account_to_id_foreign FOREIGN KEY (account_to_id) REFERENCES public.accounts(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: account_mappings account_mappings_site_from_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.account_mappings
    ADD CONSTRAINT account_mappings_site_from_id_foreign FOREIGN KEY (site_from_id) REFERENCES public.sites(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: account_mappings account_mappings_site_to_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.account_mappings
    ADD CONSTRAINT account_mappings_site_to_id_foreign FOREIGN KEY (site_to_id) REFERENCES public.sites(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: accounts accounts_account_category_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.accounts
    ADD CONSTRAINT accounts_account_category_id_foreign FOREIGN KEY (account_category_id) REFERENCES public.account_categories(id) ON DELETE SET NULL;


--
-- Name: accounts accounts_bank_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.accounts
    ADD CONSTRAINT accounts_bank_id_foreign FOREIGN KEY (bank_id) REFERENCES public.banks(id) ON DELETE SET NULL;


--
-- Name: accounts accounts_site_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.accounts
    ADD CONSTRAINT accounts_site_id_foreign FOREIGN KEY (site_id) REFERENCES public.sites(id) ON DELETE CASCADE;


--
-- Name: admin_permission_role admin_permission_role_permission_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.admin_permission_role
    ADD CONSTRAINT admin_permission_role_permission_id_foreign FOREIGN KEY (permission_id) REFERENCES public.admin_permissions(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: admin_permission_role admin_permission_role_role_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.admin_permission_role
    ADD CONSTRAINT admin_permission_role_role_id_foreign FOREIGN KEY (role_id) REFERENCES public.admin_roles(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: admin_role_user admin_role_user_role_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.admin_role_user
    ADD CONSTRAINT admin_role_user_role_id_foreign FOREIGN KEY (role_id) REFERENCES public.admin_roles(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: admin_role_user admin_role_user_user_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.admin_role_user
    ADD CONSTRAINT admin_role_user_user_id_foreign FOREIGN KEY (user_id) REFERENCES public.admins(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: customer_accounts customer_accounts_account_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.customer_accounts
    ADD CONSTRAINT customer_accounts_account_id_foreign FOREIGN KEY (account_id) REFERENCES public.accounts(id) ON DELETE CASCADE;


--
-- Name: customer_accounts customer_accounts_customer_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.customer_accounts
    ADD CONSTRAINT customer_accounts_customer_id_foreign FOREIGN KEY (customer_id) REFERENCES public.customers(id) ON DELETE CASCADE;


--
-- Name: customer_accounts customer_accounts_site_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.customer_accounts
    ADD CONSTRAINT customer_accounts_site_id_foreign FOREIGN KEY (site_id) REFERENCES public.sites(id) ON DELETE CASCADE;


--
-- Name: customer_bank_accounts customer_bank_accounts_bank_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.customer_bank_accounts
    ADD CONSTRAINT customer_bank_accounts_bank_id_foreign FOREIGN KEY (bank_id) REFERENCES public.banks(id) ON DELETE CASCADE;


--
-- Name: customer_bank_accounts customer_bank_accounts_customer_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.customer_bank_accounts
    ADD CONSTRAINT customer_bank_accounts_customer_id_foreign FOREIGN KEY (customer_id) REFERENCES public.customers(id) ON DELETE CASCADE;


--
-- Name: customer_contacts customer_contacts_customer_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.customer_contacts
    ADD CONSTRAINT customer_contacts_customer_id_foreign FOREIGN KEY (customer_id) REFERENCES public.customers(id) ON DELETE CASCADE;


--
-- Name: customer_documents customer_documents_customer_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.customer_documents
    ADD CONSTRAINT customer_documents_customer_id_foreign FOREIGN KEY (customer_id) REFERENCES public.customers(id) ON DELETE CASCADE;


--
-- Name: customers customers_customer_category_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.customers
    ADD CONSTRAINT customers_customer_category_id_foreign FOREIGN KEY (customer_category_id) REFERENCES public.customer_categories(id) ON DELETE CASCADE;


--
-- Name: customers customers_district_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.customers
    ADD CONSTRAINT customers_district_id_foreign FOREIGN KEY (district_id) REFERENCES public.districts(id) ON DELETE CASCADE;


--
-- Name: customers customers_province_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.customers
    ADD CONSTRAINT customers_province_id_foreign FOREIGN KEY (province_id) REFERENCES public.provinces(id) ON DELETE CASCADE;


--
-- Name: customers customers_region_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.customers
    ADD CONSTRAINT customers_region_id_foreign FOREIGN KEY (region_id) REFERENCES public.regions(id) ON DELETE CASCADE;


--
-- Name: departments departments_site_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.departments
    ADD CONSTRAINT departments_site_id_foreign FOREIGN KEY (site_id) REFERENCES public.sites(id) ON DELETE CASCADE;


--
-- Name: districts districts_region_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.districts
    ADD CONSTRAINT districts_region_id_foreign FOREIGN KEY (region_id) REFERENCES public.regions(id) ON DELETE RESTRICT;


--
-- Name: employees employees_approval_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.employees
    ADD CONSTRAINT employees_approval_id_foreign FOREIGN KEY (approval_id) REFERENCES public.employees(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: employees employees_department_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.employees
    ADD CONSTRAINT employees_department_id_foreign FOREIGN KEY (department_id) REFERENCES public.departments(id) ON DELETE CASCADE;


--
-- Name: employees employees_manager_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.employees
    ADD CONSTRAINT employees_manager_id_foreign FOREIGN KEY (manager_id) REFERENCES public.employees(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: employees employees_site_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.employees
    ADD CONSTRAINT employees_site_id_foreign FOREIGN KEY (site_id) REFERENCES public.sites(id) ON DELETE CASCADE;


--
-- Name: employees employees_title_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.employees
    ADD CONSTRAINT employees_title_id_foreign FOREIGN KEY (title_id) REFERENCES public.titles(id) ON DELETE CASCADE;


--
-- Name: menus menus_site_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.menus
    ADD CONSTRAINT menus_site_id_foreign FOREIGN KEY (site_id) REFERENCES public.sites(id) ON DELETE CASCADE;


--
-- Name: permission_role permission_role_permission_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.permission_role
    ADD CONSTRAINT permission_role_permission_id_foreign FOREIGN KEY (permission_id) REFERENCES public.permissions(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: permission_role permission_role_role_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.permission_role
    ADD CONSTRAINT permission_role_role_id_foreign FOREIGN KEY (role_id) REFERENCES public.roles(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: regions regions_province_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.regions
    ADD CONSTRAINT regions_province_id_foreign FOREIGN KEY (province_id) REFERENCES public.provinces(id) ON DELETE RESTRICT;


--
-- Name: role_menu_mobiles role_menu_mobiles_menu_mobile_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.role_menu_mobiles
    ADD CONSTRAINT role_menu_mobiles_menu_mobile_id_foreign FOREIGN KEY (menu_mobile_id) REFERENCES public.menu_mobiles(id) ON DELETE CASCADE;


--
-- Name: role_menu_mobiles role_menu_mobiles_role_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.role_menu_mobiles
    ADD CONSTRAINT role_menu_mobiles_role_id_foreign FOREIGN KEY (role_id) REFERENCES public.roles(id) ON DELETE CASCADE;


--
-- Name: role_menu_mobiles role_menu_mobiles_site_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.role_menu_mobiles
    ADD CONSTRAINT role_menu_mobiles_site_id_foreign FOREIGN KEY (site_id) REFERENCES public.sites(id) ON DELETE CASCADE;


--
-- Name: role_menus role_menus_menu_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.role_menus
    ADD CONSTRAINT role_menus_menu_id_foreign FOREIGN KEY (menu_id) REFERENCES public.menus(id) ON DELETE CASCADE;


--
-- Name: role_menus role_menus_role_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.role_menus
    ADD CONSTRAINT role_menus_role_id_foreign FOREIGN KEY (role_id) REFERENCES public.roles(id) ON DELETE CASCADE;


--
-- Name: role_menus role_menus_site_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.role_menus
    ADD CONSTRAINT role_menus_site_id_foreign FOREIGN KEY (site_id) REFERENCES public.sites(id) ON DELETE CASCADE;


--
-- Name: role_user role_user_role_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.role_user
    ADD CONSTRAINT role_user_role_id_foreign FOREIGN KEY (role_id) REFERENCES public.roles(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: role_user role_user_user_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.role_user
    ADD CONSTRAINT role_user_user_id_foreign FOREIGN KEY (user_id) REFERENCES public.users(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: roles roles_site_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.roles
    ADD CONSTRAINT roles_site_id_foreign FOREIGN KEY (site_id) REFERENCES public.sites(id) ON DELETE CASCADE;


--
-- Name: site_configs site_configs_site_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.site_configs
    ADD CONSTRAINT site_configs_site_id_foreign FOREIGN KEY (site_id) REFERENCES public.sites(id) ON DELETE CASCADE;


--
-- Name: titles titles_site_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.titles
    ADD CONSTRAINT titles_site_id_foreign FOREIGN KEY (site_id) REFERENCES public.sites(id) ON DELETE CASCADE;


--
-- Name: user_customers user_customers_customer_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.user_customers
    ADD CONSTRAINT user_customers_customer_id_foreign FOREIGN KEY (customer_id) REFERENCES public.customers(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: user_customers user_customers_user_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.user_customers
    ADD CONSTRAINT user_customers_user_id_foreign FOREIGN KEY (user_id) REFERENCES public.users(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: user_employees user_employees_employee_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.user_employees
    ADD CONSTRAINT user_employees_employee_id_foreign FOREIGN KEY (employee_id) REFERENCES public.employees(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: user_employees user_employees_user_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.user_employees
    ADD CONSTRAINT user_employees_user_id_foreign FOREIGN KEY (user_id) REFERENCES public.users(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: user_logs user_logs_site_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.user_logs
    ADD CONSTRAINT user_logs_site_id_foreign FOREIGN KEY (site_id) REFERENCES public.sites(id) ON DELETE CASCADE;


--
-- Name: user_logs user_logs_user_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.user_logs
    ADD CONSTRAINT user_logs_user_id_foreign FOREIGN KEY (user_id) REFERENCES public.users(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
--

