2700	031	12	1207	120728	1207281007	8	1	3	1	2	2	087	Jl. Hasanuddin	20511	\N	2024-02-10 05:54:53	2024-02-10 05:54:53	\N
2701	012	36	3603	367107	3671071004	18	2	4	1	1	1	367	Kavling Agraria	15116	\N	2024-02-10 05:54:53	2024-02-10 05:54:53	\N
2702	012	36	3603	360322	3603221004	18	2	4	1	1	1	167	Catalina Gading Serpong	15334	\N	2024-02-10 05:54:53	2024-02-10 05:54:53	\N
2703	012	36	3603	360328	3603281001	18	2	4	1	1	1	087	Bukit Hijau Karawaci	15810	\N	2024-02-10 05:54:53	2024-02-10 05:54:53	\N
2704	018	18	1871	187117	1871171006	2	2	3	1	2	1	011	Jalan Way Semangka	35213	\N	2024-02-10 05:54:53	2024-02-10 05:54:53	\N
2705	012	36	3603	360328	3603281001	18	2	4	1	1	1	087	Perum Dasana Indah	15810	\N	2024-02-10 05:54:53	2024-02-10 05:54:53	\N
2706	012	36	3603	360328	3603281001	18	2	4	2	2	1	087	Islamic VillageKrwc Prepaid	15810	\N	2024-02-10 05:54:53	2024-02-10 05:54:53	\N
2707	012	36	3603	360328	3603281001	18	2	4	1	1	1	087	Palem Semi Lippo Karawaci	15810	\N	2024-02-10 05:54:53	2024-02-10 05:54:53	\N
2708	012	36	3603	367108	3671081002	18	2	4	1	1	1	397	Vila Tangerang Indah	15133	\N	2024-02-10 05:54:53	2024-02-10 05:54:53	\N
2709	031	12	1207	120723	1207232005	2	2	4	1	2	1	115	Perumahan Baru22	20351	\N	2024-02-10 05:54:53	2024-02-10 05:54:53	\N
2710	011	31	3174	317407	3174071006	18	2	4	2	1	1	000	Pra Mikyal Indah	12190	\N	2024-02-10 05:54:53	2024-02-10 05:54:53	\N
2711	011	31	3174	317407	3174071009	18	2	4	1	1	1	000	Pasca Mikyal Indah	12140	\N	2024-02-10 05:54:53	2024-02-10 05:54:53	\N
2712	031	12	1271	127119	1271191002	2	2	4	2	1	1	002	Pra Mikyal Shah	20113	\N	2024-02-10 05:54:53	2024-02-10 05:54:53	\N
2713	031	12	1271	127119	1271191002	2	2	4	1	1	1	002	Pasca Mikyal Shah	20113	\N	2024-02-10 05:54:53	2024-02-10 05:54:53	\N
2714	012	36	3674	321618	3674071005	18	2	4	1	1	1	001	Perumahan Trial NJRG PINTAR-AI	15315	\N	2024-02-10 05:54:53	2024-02-10 05:54:53	\N
2715	012	36	3674	321618	3674071005	18	2	4	1	2	1	001	Perumahan Trial JRG Pintar-AI	15315	\N	2024-02-10 05:54:53	2024-02-10 05:54:53	\N
2716	012	36	3674	321618	3674071005	18	1	3	1	2	2	001	Perumahan Trial JRG Praktis AI	15315	\N	2024-02-10 05:54:53	2024-02-10 05:54:53	\N
\.


--
-- Data for Name: kebenaran_data; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.kebenaran_data (id, konten, created_at, updated_at, deleted_at) FROM stdin;
4	PHA+PHNwYW4gc3R5bGU9ImZvbnQtc2l6ZTogMTRweDsiPlBhc3Rpa2FuIEFuZGEgdGVsYWggbWVuZ2lzaSBkYXRhIGRlbmdhbiBCRU5BUiBkYW4gTEVOR0tBUCwga2FyZW5hIGRva3VtZW4gcGVyaWthdGFuL3BlcmphbmppYW4gYWthbiBkaXRlcmJpdGthbiBkYW4gZGlzYW1wYWlrYW4gc2VjYXJhIGVsZWt0cm9uaWsuIEFwYWJpbGEgQW5kYSBtZWxha3VrYW4ga2VzYWxhaGFuIGlucHV0IGRhdGEgYWdhciBtZWxha3VrYW4gcmVnaXN0cmFzaSB1bGFuZy4gPC9zcGFuPjwvcD4K	2024-02-04 16:38:49	2024-02-05 05:18:43	\N
\.


--
-- Data for Name: kelengkapan_data; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.kelengkapan_data (id, customer_id, nama_pelanggan, geo_province_id, geo_town_id, is_pk, is_badan_hukum, is_npwp, npwp, ktp, ktp_url, ktp_url_relyon, nama_ktp, alamat_ktp, alamat_lokasi_pemasangan, no_telpon, email, is_send, created_at, updated_at, deleted_at, is_send_email) FROM stdin;
1	03122395	RUSFIL IDWAN, BE	3	19	0	0	1	1234567890321654	1234567890321654	file_upload/ziWb8TWvjoeHDuVnCDZU1kORRD35p5whr94M1cBA.png	/images/idcard/1707299465-5593e8cf-1319-4cb0-a793-2b8fb8ca23ce.png	RUSFIL IDWAN, BE	alamat	alamat	6281361538293	adeaji61@gmail.com	1	2024-02-06 07:59:34	2024-02-09 04:52:01	\N	1
\.


--
-- Data for Name: ketentuan_umum; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.ketentuan_umum (id, konten, created_at, updated_at, deleted_at) FROM stdin;
2	[BLOB]	2024-02-04 16:50:47	2024-02-05 05:18:32	\N
\.


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

COPY public.migrations (id, migration, batch) FROM stdin;
5	2023_12_28_101319_geo_provinces	1
6	2023_12_28_101407_geo_towns	1
7	2023_12_28_101419_geo_villages	1
8	2023_12_28_101428_geo_districts	1
1	2014_10_12_000000_create_users_table	1
2	2014_10_12_100000_create_password_reset_tokens_table	1
3	2019_08_19_000000_create_failed_jobs_table	1
4	2019_12_14_000001_create_personal_access_tokens_table	1
9	2023_12_29_054102_custom_token	2
10	2024_01_01_094139_gas_tools	3
11	2024_01_01_094953_fuel_units	4
12	2024_01_01_095001_fuels	4
15	2024_01_01_124728_housing_areas	5
16	2024_01_01_130458_building_types	6
17	2024_01_01_131722_status_locations	7
18	2024_01_01_132613_electrical_powers	8
21	2024_01_04_030808_registration	9
22	2024_01_08_043957_gas_tool_usages	10
23	2024_01_08_044005_fuel_usages	10
24	2024_02_04_150456_brosur	11
25	2024_02_04_150505_kebenaran_data	11
26	2024_02_04_150709_ketentuan_umum	11
27	2024_02_04_150600_file_pernyataan	11
28	2024_02_06_030330_kelengkapan_data	12
35	2024_02_09_085019_areas	13
36	2024_02_09_085025_area_infos	13
\.


--
-- Data for Name: registrations; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.registrations (id, kebutuhan_pelanggan, geo_province_id, geo_town_id, geo_district_id, geo_village_id, housing_area_id, nama_perumahan_jalan_utama, alamat, rt, rw, kode_pos, building_type_id, nama_pemilik_bangunan, no_telpon_pemilik_bangunan, status_lokasi_pemasangan, latitude, longitude, status_location_id, nama, ktp, no_telpon, electrical_power_id, ktp_url, is_send, created_at, updated_at, deleted_at, email, form_id, rekening_listrik_url, ktp_url_relyon, rekening_listrik_url_relyon) FROM stdin;
25	1	36	3603	367109	3671091003	1686	perumahan	alamat	12	1	12345	2	nama pemilik	628234512345	1			2	nama	12345678901234	6282345678901	3	/images/idcard/1704701748-12a91e51-3571-4d51-89ec-a6956b34b173.png	1	2024-01-08 08:17:26	2024-01-08 08:17:26	\N	tes@gmail.com	24010016160	\N	\N	\N
30	1	36	3603	367109	3671091003	1686	perumahan	alamat	01	02	12345	2	nama	6281234567890	0	-6.2088	106.8456	2	nama	1234567899123456	6281234567890	2	/images/idcard/1704774553-a9856c7e-fbe4-4d89-97af-c63baf8f3401.PNG	1	2024-01-09 04:30:54	2024-01-09 04:30:54	\N	tes@gmail.com	24010016171	/images/ebill/1704774555-c960194f-674b-4a5f-8410-d91a98a7b601.PNG	\N	\N
58	1	36	3603	367109	3671091003	1686		alamat				2			0	-6.204922	106.6018035	1	nama	1234567903758362	6282136548979	3	file_upload/gdE3f8uLavWPqulayIPNhMmCQVn6qqB1BUklfYa0.png	0	2024-01-22 10:48:20	2024-01-22 10:48:20	\N	tes@gmail.com	\N		\N	\N
49	2	36	3603	367101	3671011005	1158	bumi mas	bumi mas	01	02	12345	4	nama pemilik	6286521478900	0	-6.2039008	106.627945	1	edi	8965874123654786	6281236547963	3	file_upload/4qIfeM9wZ14VLiDtbrB7tsM9Jqw1O3374duGqQrn.png	1	2024-01-12 07:42:36	2024-01-12 07:43:34	\N	tes@gmail.com	24010016184	file_upload/dFyrga5M9YBVKdaKf4vGPS5DWcYza1FzWHSTTtgj.png	/images/idcard/1705045313-a9d87414-3fac-4d18-adf5-ab2f16f95424.png	/images/ebill/1705045314-339ae27e-6a57-4c90-adae-23cd7962ba59.png
38	2	36	3603	367107	3671071005	1159	perumahan	alamat	01	02	12346	10			0	-6.192867	106.6129333	1	budi	9871234560987123	6283214569870	3	/images/idcard/1705031307-9f853f90-e7fc-428d-9eee-717b53045fa1.PNG	1	2024-01-12 03:50:10	2024-01-12 03:50:16	\N	tes@gmail.com	24010016177		\N	\N
47	2	36	3603	367107	3671071005	1159	cimone	alamat lengkap	01	02	12345	10			0	-6.192867	106.6129333	1	udin	9632587413654789	6281236547899	3	file_upload/sKpppLGOoIZgDN6jjNlNSyTPY8unMSE32PFLpgKG.png	1	2024-01-12 07:26:20	2024-01-12 09:30:47	\N	tes@gmail.com	24010016185		/images/idcard/1705051746-f3cfb707-1ef9-4bb8-8658-c2bcc27c7996.png	\N
26	1	36	3603	367107	3671071005	1159	alamat	alamat	01	02	12345	2	nama	6281234567890	0	-6.1944491	106.8229198	2	nama	1234567890123456	6281234567890	3	/images/idcard/1704712634-b9c17b3e-f250-4d5f-8f56-6ef02564d056.PNG	1	2024-01-08 11:18:53	2024-01-08 11:18:53	\N	tes@gmail.com	24010016163	\N	\N	\N
56	1	36	3603	367109	3671091003	1686	perumahan	alamat	12	1	12345	2	nama pemilik	628234512346	1	1	1	2	nama	12345677890123	6282345678901	3	file_upload/WnayHVQpPn7sW1Q7NBtRaprZFZBSVMCjf1ukiaOd.png	0	2024-01-22 10:29:08	2024-01-22 10:29:08	\N	tes@gmail.com	\N	file_upload/J70VcU8qVh6xqVdO31BbepeNZK2OFPWNdpsTeTVX.png	\N	\N
74	2	36	3603	367109	3671091003	1686		alamat	01	01	12345	4	pemilik	6281324678932	0	-6.2088	106.8456	2	nama	3604052806580001	6281398665508	2	file_upload/pJRr58B9DWAtEm7cU2QcOfJAUAx3OgBCwyHQ9OS9.png	0	2024-02-05 09:05:01	2024-02-07 10:49:09	\N	tes@gmail.com	\N	file_upload/1BaRYYroUGXmQpaeJVuXXBDecU8OI2eaSt6gbMOE.png	/images/idcard/1707302827-8f10af99-4ca0-4aae-a563-a181e43edd54.png	/images/ebill/1707302829-e1aa9d0e-9658-4e03-8dc0-33a3fe6ef673.png
36	1	36	3603	367109	3671091003	1686	perumahan	alamat	12	1	12345	2	nama pemilik	628234512345	1	1	1	2	nama	12345678901232	6282345678901	3	file_upload/hJIeIde22V60VFdGudNY9x6mE8dGSwHDFswXGQrK.png	1	2024-01-12 03:33:47	2024-01-12 03:33:47	\N	tes@gmail.com	\N		\N	\N
35	1	36	3603	367109	3671091003	1686	perumahan	alamat	12	1	12345	2	nama pemilik	628234512345	1	1	1	2	nama	12345678901231	6282345678901	3	file_upload/7kFiZ27XduhyTyIwIIx9auKMyvXr7T6zBECOcYB3.png	1	2024-01-12 03:33:05	2024-01-12 03:33:05	\N	tes@gmail.com	\N		\N	\N
39	1	36	3603	367109	3671091003	1686	perumahan	alamat	12	1	12345	2	nama pemilik	628234512345	1	1	1	2	nama	12345678901233	6282345678901	3	file_upload/jji2DFcOYb52WaxHOFxtYB5xliYr6fvDOnaeoE3H.png	1	2024-01-12 04:23:53	2024-01-12 04:42:51	\N	tes@gmail.com	24010016178		\N	\N
24	1	36	3603	367109	3671091003	1686	perumahan	alamat	12	1	12345	2	nama pemilik	628234512345	0			2	nama	12345678901234	6282345678901	3	/images/idcard/1704701630-05fcc87a-e7bd-4cb9-a346-4585568f07b2.png	1	2024-01-08 08:15:28	2024-01-08 08:15:29	\N	tes@gmail.com	24010016159	\N	\N	\N
40	1	36	3603	367109	3671091003	1686	perumahan	alamat	12	1	12345	2	nama pemilik	628234512346	1	1	1	2	nama	12345678901236	6282345678901	3	file_upload/DhkHb3IsOikfA05JbhuIDzQsmoDpKpF0nfZuzu5R.png	1	2024-01-12 04:45:19	2024-01-12 04:55:08	\N	tes@gmail.com	24010016180	file_upload/F4HgdtVavkbZkj0XAcS7ErfssDNNOb7b9KisDX08.png	/images/idcard/1705035203-0e5e8d05-864a-4dac-a861-cea3dcfe3b03.png	/images/ebill/1705035205-34fb1fd8-fdec-4f99-944f-8cb0548a8b4d.png
57	1	36	3603	367109	3671091003	1686		alamat				2			0	-6.204922	106.6018035	1	nama	1234567903216965	6282136548979	2	file_upload/LDNYWfmtKzpGjA4fzk92i7WzwWouuEhVHe5leSCy.png	0	2024-01-22 10:35:00	2024-01-22 10:35:00	\N	tes@gmail.com	\N	file_upload/oggjEI4TdjNYxy77HMSA35PNMJBiNculZTe6os8M.png	\N	\N
44	1	36	3603	367109	3671091003	\N		amalat				2			0	-6.2026756	106.6040799	1	nama	3698521470369852	6281234567890	2	file_upload/C7flX4whubxZeqQWFkj4iSneSVV7Q7S058r6Ib7A.png	0	2024-01-12 04:58:29	2024-01-12 09:30:45	\N	tes@gmail.com	\N	file_upload/ayyawoRXWOgoVnLxaIYWZzyvdLS99C1mEp5QA4XZ.png	/images/idcard/1705051744-3706e187-fc3f-4d09-b8e2-b85134589f5c.png	/images/ebill/1705051745-1e701e2d-a61b-4b96-b698-6fd455e76d61.png
65	1	36	3603	367109	3671091003	1686	perumahan	alamat	01	02	12345	2			0	-6.2088	106.8456	1	nama	3604052806580001	6281398665508	2	file_upload/CGqLsPaSNiF8Ql5ukPA8V9887gNXpcGW6QPMHX9s.png	0	2024-01-30 02:19:02	2024-01-30 02:19:02	\N	tes@gmail.com	\N	file_upload/cRLfec4nHPKZCEjAuwHUM64sOLre60uycN3MBD1h.png	\N	\N
45	1	36	3603	367109	3671091003	1686	perumahan	alamat	01	02	12345	2			0	-6.204922	106.6018035	1	ipul	1236547890987456	6281234567896	2	file_upload/k6qfzIQZRVFUIL8BxO8MS9K2ZY4NErnklv0rFMxi.png	1	2024-01-12 06:03:34	2024-01-12 06:03:40	\N	tes@gmail.com	24010016181	file_upload/LmUnD3Cn6p19BJXR2bXGeodbN8GAwH7kVp1pGs1x.png	/images/idcard/1705039317-2e94ed82-57c8-498f-8bce-5ff1a1a022bc.png	/images/ebill/1705039319-5f91552a-c95a-4390-8f4e-b906c3273e20.png
46	1	36	3603	367109	3671091003	1686	jalan karawaci	alamat lengkap	01	02	12345	2	budi	6281234567890	0	-6.204922	106.6018035	2	budi	1234567890123458	6281282365478	2	file_upload/F55I1KC45KgiBckehY7RVsGbxe5qpt6nGHPwbCYA.png	1	2024-01-12 07:20:08	2024-01-12 07:20:11	\N	tes@gmail.com	24010016182	file_upload/N8qC5VDwyVW8kK7vgxTnMeDGwefvPUodhT3FzT7E.png	/images/idcard/1705043909-5b0ed83d-1922-4e53-a904-f90a01b34e23.png	/images/ebill/1705043911-100275b6-bee5-43e9-8560-fbe8c3624e37.png
53	1	36	3603	367109	3671091003	1686	perumahan	alamat	12	1	12345	2	nama pemilik	628234512346	1	1	1	2	nama	12345677890123	6282345678901	3	file_upload/J7OjtUe1sOV9TPebevQGbfLOTPqAnHwzylpGucoA.png	0	2024-01-22 10:20:01	2024-01-22 10:20:01	\N	tes@gmail.com	\N	file_upload/N0d2KxptO9Z2WeHMeaeb4U7b6CZZiMiFpsYEkzEf.png	\N	\N
66	1	36	3603	367109	3671091003	1686	perumahan	alamat	01	02	12345	2			0	-6.2088	106.8456	1	nama	3604052806580001	6281398665508	2	file_upload/NDWakcTgOD2cEPnRCET1Oz8eQ01NWIuP3XV7yDZN.png	0	2024-01-30 03:07:07	2024-01-30 03:07:07	\N	tes@gmail.com	\N	file_upload/1lh3Logjv26xUS2bWvMWnVkWRAatmptC8REmW1UL.png	\N	\N
54	1	36	3603	367109	3671091003	1686	perumahan	alamat	12	1	12345	2	nama pemilik	628234512346	1	1	1	2	nama	12345677890123	6282345678901	3	file_upload/IcSpkSZX9ocmrueqBH2Ovn5PWsU8slrBoxMOhMXR.png	0	2024-01-22 10:21:05	2024-01-22 10:21:05	\N	tes@gmail.com	\N	file_upload/4XYYllHZ1F5mvnfht0ZTYg3lqvDX7ivML8JwVaIJ.png	\N	\N
50	1	36	3603	367109	3671091003	1686		alamat				2			0	-6.2026756	106.6040799	1	nama	1234567890123965	6281234567890	2	file_upload/SYKIlnKAiGxxwKHFFQEdnXfNuHeqZaUjQlAlLbAI.png	1	2024-01-12 09:47:00	2024-01-12 09:47:03	\N	tes@gmail.com	24010016186	file_upload/0bsdHcyJpAb6L8MC1R57rRWhERudtCv5WxXfLLWw.png	/images/idcard/1705052721-692e8554-ca96-4814-80b6-481a60e2ff48.png	/images/ebill/1705052722-f3938a74-a474-47b1-bf3a-e8637d5d22b1.png
48	1	36	3603	367109	3671091003	1166	perum 4	bintaro	07	02	15710	2			0	-6.19429	106.6016976	1	dwi	8746932146987126	6281236578965	2	file_upload/Fx58KqVF1vr2VIeqcgYcFNOWaFExt8NYTieSJ4q2.png	1	2024-01-12 07:31:43	2024-01-12 07:31:46	\N	tes@gmail.com	24010016183	file_upload/dFyrga5M9YBVKdaKf4vGPS5DWcYza1FzWHSTTtgj.png	/images/idcard/1705044604-fff0125f-7b6f-4579-8225-021ec254f2db.png	/images/ebill/1705044606-692dabb7-7948-4944-96ab-d0ab9bc6cb72.png
55	1	36	3603	367109	3671091003	1686	perumahan	alamat	12	1	12345	2	nama pemilik	628234512346	1	1	1	2	nama	12345677890123	6282345678901	3	file_upload/Y3d3ddtzPVEH8iiMQmAaCUNsvHuUzVkxVUxBNWBW.png	0	2024-01-22 10:28:51	2024-01-22 10:28:51	\N	tes@gmail.com	\N	file_upload/DVLhWheqNwBINfvLrvdHc04i8ruOiMne63x3gben.png	\N	\N
51	1	36	3603	367109	3671091003	1686	perumahan	alamat	12	1	12345	2	nama pemilik	628234512346	1	1	1	2	nama	12345677890123	6282345678901	3	file_upload/6J2jxe0Gh3fBTnC90oaNxqsDcUS0QhCxeZHrt51n.png	0	2024-01-18 07:04:22	2024-01-18 07:04:22	\N	tes@gmail.com	\N	file_upload/EkpFBXGDXuJzHU6lQFJyDsLUVkNlqU9UHnVgnZbN.png	\N	\N
23	1	36	3603	367109	3671091003	1686	perumahan	alamat	12	1	12345	2	nama pemilik	628234512345	1			2	nama	12345678901234	6282345678901	3	/images/idcard/1704700722-ba2e8e31-342f-4a77-961b-073b2c770261.png	1	2024-01-08 08:00:20	2024-01-08 08:57:15	\N	tes@gmail.com	24010016162	\N	\N	\N
27	1	36	3603	367109	3671091003	1686	alamat	alamat	1	02	12345	2	nama	6281234567890	0	-6.1944491	106.8229198	2	nama	1234567890123456	6281234567890	3	/images/idcard/1704713555-d3345377-fd82-4e0a-8f1c-54ba6a825339.PNG	1	2024-01-08 11:34:14	2024-01-08 11:34:15	\N	tes@gmail.com	24010016164	\N	\N	\N
67	1	36	3603	367109	3671091003	1686	perumahan	alamat	01	02	12345	2			0	-6.2088	106.8456	1	nama	3604052806580001	6281398665508	2	file_upload/MQtxJrgtoKWLAZDqbRbgFI6DaUEmXVf2jWKThFsL.png	0	2024-01-30 03:08:07	2024-01-30 03:08:07	\N	tes@gmail.com	\N	file_upload/lUnCyxXjMf7dLWwte76yszNdunDHPYglvwjVfhHt.png	\N	\N
28	1	36	3603	367109	3671091003	1686	perumahan	alamat	01	01	12345	2	nama	6281234567890	0	-6.2088	106.8456	2	nama	1324657890132456	6281234567890	3	/images/idcard/1704770670-951739f8-46db-4adb-b514-b9cc3d98332a.PNG	1	2024-01-09 03:26:10	2024-01-09 03:26:15	\N	tes@gmail.com	24010016169	\N	\N	\N
29	1	36	3603	367109	3671091003	1686	perumahan	alamat	01	02	12345	2	nama	6281234567890	0	-6.2088	106.8456	2	nama	1234567890321654	6281234567890	2	/images/idcard/1704774326-2198fef5-2e7e-4d11-940e-dc56646b36f7.PNG	1	2024-01-09 04:27:07	2024-01-09 04:27:07	\N	tes@gmail.com	24010016170	\N	\N	\N
9	1	36	3603	367109	3671091003	1686	perumahan	alamat	12	1	12345	2	nama pemilik	628234512345	1			2	nama	12345678901234	6282345678901	3	https://scdn.pgn.co.id/dev-relyon/images/idcard/1704695809-0d454ba0-8c37-4f86-98f3-c9e26641fbf7.png	1	2024-01-08 06:38:27	2024-01-08 06:38:27	\N	\N	\N	\N	\N	\N
8	1	36	3603	367109	3671091003	1686	perumahan	alamat	12	1	12345	2	nama pemilik	628234512345	1			2	nama	12345678901234	6282345678901	3		1	2024-01-08 06:10:57	2024-01-08 06:10:57	\N	\N	\N	\N	\N	\N
7	1	36	3603	367109	3671091003	1686	perumahan	alamat	12	1	12345	2	nama pemilik	628234512345	1			2	nama	12345678901234	6282345678901	3		1	2024-01-08 04:50:33	2024-01-08 04:50:33	\N	\N	\N	\N	\N	\N
6	1	36	3603	367109	3671091003	1686	perumahan	alamat	12	1	12345	2	nama pemilik	628234512345	1			2	nama	12345678901234	6282345678901	3		1	2024-01-08 04:49:21	2024-01-08 04:49:21	\N	\N	\N	\N	\N	\N
5	1	36	3603	367109	3671091003	1686	perumahan	alamat	12	1	12345	2	nama pemilik	628234512345	1			2	nama	12345678901234	6282345678901	3		1	2024-01-08 04:48:53	2024-01-08 04:48:53	\N	\N	\N	\N	\N	\N
4	1	36	3603	367109	3671091003	1686	perumahan	alamat	1	1	12345	2	nama	6281234567890	1			2	nama	123456789012345	6281234567890	3		1	2024-01-04 09:26:02	2024-01-04 09:26:02	\N	\N	\N	\N	\N	\N
3	1	36	3603	367109	3671091003	1686	perumahan	alamat	1	1	12345	2	nama	6281234567899	1			2	nama	1234567890123456	6281234567890	3		1	2024-01-04 08:59:19	2024-01-04 08:59:19	\N	\N	\N	\N	\N	\N
2	1	36	3603	367109	3671091003	1686	peerumahan	alamat	1	2	12345	2	tes	6282345678990	1			2	tes	123456789012345	6286554333334	3		1	2024-01-04 08:28:35	2024-01-04 08:28:35	\N	\N	\N	\N	\N	\N
73	1	36	3603	367109	3671091003	1686	perumahan	alamat	12	1	12345	2	nama pemilik	628234512346	1	1	1	2	nama	12345677890123	6282345678901	3	file_upload/mu3aD8OU3KIn25ok0pIMG3wsdXERUnNxBAIWoqoU.png	0	2024-01-31 08:43:36	2024-01-31 08:43:36	\N	tes@gmail.com	\N	file_upload/HhphkTZ1hjqtARIBD9ER6yNzGBWcRgYct69K1CJj.png	\N	\N
1	1	36	3603	367109	3671091003	1686	perumahan	alamat	12	1	12345	2	nama pemilik	628234512345	1			2	nama	12345678901234	6282345678901	3		1	2024-01-04 07:51:30	2024-01-04 07:51:30	\N	\N	\N	\N	\N	\N
31	1	36	3603	367109	3671091003	1686	perumahan	alamat	01	02	12345	2	nama pemilik	6281234567910	0	-6.204922	106.6018035	1	Nama	1234567890987654	6281234567890	2		1	2024-01-11 07:35:34	2024-01-11 07:52:37	\N	tes@gmail.com	24010016172		\N	\N
32	1	36	3603	367109	3671091003	1166	nama perumahan	alamat lengkap	01	02	12345	2	nama pemilik	6281234567890	0	-6.19429	106.6016976	1	nama	1234567890123459	6281234567890	2		1	2024-01-11 07:41:56	2024-01-11 07:52:38	\N	tes@gmail.com	24010016173		\N	\N
33	1	36	3603	367109	3671091003	1166	perumahan	alamat	01	02	12345	2	pemilik	6281234567901	0	-6.2088	106.8456	1	nama	3216549870321654	6281234567890	2		1	2024-01-11 07:46:03	2024-01-11 07:52:38	\N	tes@gmail.com	24010016174		\N	\N
34	1	36	3603	367109	3671091003	1686	perumahan	bintaro	01	02	15710	2			0	-6.204922	106.6018035	1	nama	1234567890321498	6281234657890	2	/images/idcard/1704971391-1b316f8d-26c1-4d82-940b-e80329eec1f2.PNG	1	2024-01-11 11:11:35	2024-01-11 11:15:30	\N	tes@gmail.com	24010016175	/images/ebill/1704971393-33181721-9c62-4c8f-85fb-0869ad859369.PNG	\N	\N
37	1	36	3603	367109	3671091003	1686	perumahan	alamat	01	02	12345	2	nama pemilik bangunan	6281234567890	0	-6.204922	106.6018035	2	udin	1236549870321456	6281234567890	2	/images/idcard/1705031023-17087c14-1f47-4919-b303-d19891671f46.PNG	1	2024-01-12 03:45:27	2024-01-12 03:45:28	\N	tes@gmail.com	24010016176	/images/ebill/1705031024-12b6d50e-5cf0-433b-aee2-7ad52dab56ba.png	\N	\N
60	1	36	3603	367109	3671091003	1686		alamat				2			0	-6.204922	106.6018035	1	nama	1234567903216549	6282136548979	3	file_upload/WcEaLlImFx34pD4hhC3r1n0x4TimcY53qIJRa2iZ.png	0	2024-01-22 11:05:42	2024-01-22 11:05:42	\N	tes@gmail.com	\N		\N	\N
52	1	36	3603	367109	3671091003	1686	perumahan	alamat	12	1	12345	2	nama pemilik	628234512346	1	1	1	2	nama	12345677890123	6282345678901	3	file_upload/bOGUpuSKkn43iShcDzwoYJPWzt8L134KGIXSjVK9.png	0	2024-01-22 10:19:16	2024-01-22 10:19:16	\N	tes@gmail.com	\N	file_upload/JKlsOm0bBKmPShgVPKLGGBf4m7dS67pGtqEC69D8.png	\N	\N
62	1	36	3603	367109	3671091003	1686		alamat				2			0	-6.204922	106.6018035	1	nama	1234567903216549	6282136548979	3	file_upload/4AjKS0e8PqDZ5pVoSPGqjMYRjSoVi2NmIYlqpjFr.png	0	2024-01-22 11:11:30	2024-01-22 11:11:30	\N	tes@gmail.com	\N		\N	\N
59	1	36	3603	367109	3671091003	1686		alamat				2			0	-6.204922	106.6018035	1	nama	1234567903216549	6282136548979	3	file_upload/5ke1kTh7O0mXchjmLUWbbIHbGOrZprc3V8Vyz15w.png	0	2024-01-22 10:56:07	2024-01-22 10:56:07	\N	tes@gmail.com	\N		\N	\N
61	1	36	3603	367109	3671091003	1686		alamat				2			0	-6.204922	106.6018035	1	nama	1234567903216549	6282136548979	3	file_upload/1zCuP5bEex5aY8VvE5fRGIKDs9Rl7n478I5gjzb8.png	0	2024-01-22 11:07:29	2024-01-22 11:07:29	\N	tes@gmail.com	\N		\N	\N
63	1	36	3603	367109	3671091003	1686		alamat				2			0	-6.204922	106.6018035	1	nama	1234567903216549	6282136548979	3	file_upload/EnVg4uDLFq3zgtffVMT6DwAjvoyTc7flppUKploV.png	0	2024-01-22 11:15:07	2024-01-22 11:15:07	\N	tes@gmail.com	\N		\N	\N
64	1	36	3603	367109	3671091003	1686		alamat				2			0	-6.204922	106.6018035	1	nama	1234567903216549	6282136548979	3	file_upload/olSNmKkhCFO5ymDvB4HD3FY0nVd7YaPAbLQtamcQ.png	0	2024-01-22 11:15:56	2024-01-22 11:15:56	\N	tes@gmail.com	\N		\N	\N
68	1	36	3603	367109	3671091003	1686	perumahan	alamat	01	02	12345	2			0	-6.2088	106.8456	1	nama	3604052806580001	6281398665508	2	file_upload/rdiYvqnisVrorPlpY1WAdG45xL1r1Xvz3cns3FLd.png	0	2024-01-30 03:50:10	2024-01-30 03:50:10	\N	tes@gmail.com	\N	file_upload/ou4H1oYUSsxP9Vi8oDcKZ3xer6MOloDEYYq90Yq6.png	\N	\N
70	1	36	3603	367109	3671091003	1686	perumahan	alamat	01	02	12345	2			0	-6.2088	106.8456	1	nama	3604052806580001	6281398665508	3	file_upload/dJlQ0sfrT92wjfchkgFlie9rdzVydhy64zdckcKT.png	0	2024-01-30 10:18:48	2024-01-30 10:18:48	\N	tes@gmail.com	\N		\N	\N
71	1	36	3603	367109	3671091003	1686	perumahan	alamat	01	02	12345	2			0	-6.2088	106.8456	1	nama	3604052806580001	6281398665508	3	file_upload/M2Oqzcl8XhDzJW1x4zRmEWbFN4GptFFzvdrvL5JW.png	0	2024-01-30 10:44:51	2024-01-30 10:44:51	\N	tes@gmail.com	\N		\N	\N
72	1	36	3603	367109	3671091003	1686	perumahan	alamat	12	1	12345	2	nama pemilik	628234512346	1	1	1	2	nama	12345677890123	6282345678901	3	file_upload/uqPfqK26Qg0V72NwI6DFvGuVFTc82KsJ4dd6c81e.png	0	2024-01-31 08:07:44	2024-02-07 10:49:41	\N	tes@gmail.com	\N	file_upload/wpzG1CMJ88nPBAwjswYhQ7plpjecvl0QduHN4uMa.png	/images/idcard/1707302859-ee0a7ccf-df74-41fe-bb00-d752f905fd56.png	/images/ebill/1707302861-5d69b9f1-16d2-498a-ad75-561ce57b7ac8.png
69	1	36	3603	367109	3671091003	1686	perumahan	alamat	01	02	12345	2			0	-6.2088	106.8456	1	nama	3604052806580001	6281398665508	2	file_upload/6xM7S7PQlh7FzMPF2cJudXEmnuHkI8Ymw4rElNy3.png	0	2024-01-30 03:51:27	2024-02-07 10:50:09	\N	tes@gmail.com	\N	file_upload/5uCB0ghXS6JPvXXtmHJfSpbIuweIWh3TJ48cr3N7.png	/images/idcard/1707302887-c1eaf57e-92a2-458f-81ab-2ea1eb1cc11d.png	/images/ebill/1707302888-1b273a95-874a-4ce5-9a8e-539f26de1cbc.png
75	1	36	3603	367109	3671091003	1686	tes	alamat	01	02	12345	2			0	-6.2088	106.8456	1	nama	3604052806580001	6281398665508	3	file_upload/36sDTmDUzbMix6Y8iYGG0IsjPwCWgz3HT0KK58pw.png	0	2024-02-05 09:06:36	2024-02-07 10:48:42	\N	tes@gmail.com	\N		/images/idcard/1707302801-3ebcb3ee-87d9-41f2-9151-494cb5e07a35.png	\N
\.


--
-- Data for Name: status_locations; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.status_locations (id, name, sort, is_deleted, created_at, updated_at, deleted_at) FROM stdin;
1	Pemilik	1	0	2024-01-01 20:19:13	\N	\N
2	Penyewa	2	0	2024-01-01 20:19:13	\N	\N
\.



--
-- Name: area_infos area_infos_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.area_infos
    ADD CONSTRAINT area_infos_pkey PRIMARY KEY (id);


--
-- Name: areas areas_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.areas
    ADD CONSTRAINT areas_pkey PRIMARY KEY (id);


--
-- Name: brosur brosur_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.brosur
    ADD CONSTRAINT brosur_pkey PRIMARY KEY (id);


--
-- Name: building_types building_types_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.building_types
    ADD CONSTRAINT building_types_pkey PRIMARY KEY (id);


--
-- Name: electrical_powers electrical_powers_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.electrical_powers
    ADD CONSTRAINT electrical_powers_pkey PRIMARY KEY (id);


--
-- Name: failed_jobs failed_jobs_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.failed_jobs
    ADD CONSTRAINT failed_jobs_pkey PRIMARY KEY (id);


--
-- Name: failed_jobs failed_jobs_uuid_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.failed_jobs
    ADD CONSTRAINT failed_jobs_uuid_unique UNIQUE (uuid);


--
-- Name: file_pernyataan file_pernyataan_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.file_pernyataan
    ADD CONSTRAINT file_pernyataan_pkey PRIMARY KEY (id);


--
-- Name: fuel_units fuel_units_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.fuel_units
    ADD CONSTRAINT fuel_units_pkey PRIMARY KEY (id);


--
-- Name: fuel_usages fuel_usages_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.fuel_usages
    ADD CONSTRAINT fuel_usages_pkey PRIMARY KEY (id);


--
-- Name: fuels fuels_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.fuels
    ADD CONSTRAINT fuels_pkey PRIMARY KEY (id);


--
-- Name: gas_tool_usages gas_tool_usages_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.gas_tool_usages
    ADD CONSTRAINT gas_tool_usages_pkey PRIMARY KEY (id);


--
-- Name: gas_tools gas_tools_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.gas_tools
    ADD CONSTRAINT gas_tools_pkey PRIMARY KEY (id);


--
-- Name: geo_districts geo_districts_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.geo_districts
    ADD CONSTRAINT geo_districts_pkey PRIMARY KEY (id);


--
-- Name: geo_provinces geo_provinces_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.geo_provinces
    ADD CONSTRAINT geo_provinces_pkey PRIMARY KEY (id);


--
-- Name: geo_towns geo_towns_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.geo_towns
    ADD CONSTRAINT geo_towns_pkey PRIMARY KEY (id);


--
-- Name: geo_villages geo_villages_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.geo_villages
    ADD CONSTRAINT geo_villages_pkey PRIMARY KEY (id);


--
-- Name: housing_areas housing_areas_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.housing_areas
    ADD CONSTRAINT housing_areas_pkey PRIMARY KEY (id);


--
-- Name: kebenaran_data kebenaran_data_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.kebenaran_data
    ADD CONSTRAINT kebenaran_data_pkey PRIMARY KEY (id);


--
-- Name: kelengkapan_data kelengkapan_data_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.kelengkapan_data
    ADD CONSTRAINT kelengkapan_data_pkey PRIMARY KEY (id);


--
-- Name: ketentuan_umum ketentuan_umum_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.ketentuan_umum
    ADD CONSTRAINT ketentuan_umum_pkey PRIMARY KEY (id);


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

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


--
-- Name: registrations registrations_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.registrations
    ADD CONSTRAINT registrations_pkey PRIMARY KEY (id);


--
-- Name: status_locations status_locations_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.status_locations
    ADD CONSTRAINT status_locations_pkey PRIMARY KEY (id);


--
--

