Connected to PostgreSQL Database

Table: dewan

Structure

Column	Type	Length	Nullable
userid	character	30	NO
pwd	character	60	NO
created_on	date		YES
created_by	character	30	YES
first_name	character	130	YES
middle_name	character	130	YES
last_name	character	130	YES
role	character	100	YES
valid_from	date		YES
valid_to	date		YES
ipaddress	inet		YES

Sample Data (Max 10 Rows)

userid	pwd	created_by	first_name	middle_name	last_name	role	valid_from	valid_to	ipaddress
ifa199	$2y$10$IxLbkt0VlfY5oZcMvK.1IeHtvmOxP0RJSR2JtStjmpsKCySjoDtuW	sahmad010226	ifa	ifa	ifa	admin	2023-12-12	2024-12-12	1.1.1.2
dua	$2y$10$qQq07ZGrUgA6Ug1uD7nwq.tfFgKncLg.Xl2O/e9Pb4UEdiQ73P9gC	sahmad	shalahuddin	-	ahmad	owner	2023-12-12	2024-12-12	1.1.1.1
trident	$2y$10$DBPIYzzREExP0pH0yXlkLe8MQDxC8ZPfb8KZxfe.pA.jw.B1ybE1y	sahmad010226	trident	gamalama	lakasila	admin	2023-12-12	2024-12-12	1.1.1.1
satu	$2y$10$OcIaBZUI4QIkSfzSKO6Av.ZXmTDUEjbO1FmwFfMYq05XnXJUbKhUO	tiga	empat	limat	enam	tujuh	2024-12-12	2025-12-31	1.1.1.1
adm	$2y$10$HTRxwELfADTsi9vJAIlKZu1pQAxYRjbZswLJo.eMglaiTmolfqhGa
sahmad	$2y$10$xS2GrSGddMILnGnu0uamP./d1VDWQn2R.AtLLWrOo0rJRmMvQP1xC	Shalahuddin Ahmad	Shalahuddin	-	Ahmad	Owner	2024-01-01	2024-12-31	1.1.1.1
wasiat	$2y$10$GCkO3oCke1..Nvwts6HJ3uF2/YC/WZ6yGoYSkgR1LOAAz2T7JpUKa	Shalahuddin Ahmad	Shalahuddin	aaa	Ahmad	dewan	2024-01-01	2024-12-12	1.1.1.1
tuan	$2y$10$1ZxCBECyjOzrAwFXc4dp4OBaPAmZqza6dZluFI/U8k6SisFrwlzUW	admin	tuan	tuan	tuan	admin	2020-01-01	2029-01-01	11.11.11.111
tokoh	$2y$10$GdQQ5F.1tevcPuuHO1TKMue0mKZ6xzIYr0zYj4l4dZieiBlu.Lg2i	admin	tokoh	tokkko	toko	admin	2020-01-01	2029-01-01	1.1.1.1
bos	$2y$10$Ug.8XNcMPwjpfQHF.wII.O2wg4GSCcYyRfztU29rOJZnyipFbTBAO	admin	bos	kaya	minyak	admin	2000-01-01	2030-01-01	1.1.1.1

Table: entry_log

Structure

Column	Type	Length	Nullable
id	integer		NO
type	character	20	NO
userid	character	30	NO
wid	character	20	YES
firstname	character	130	YES
email	character	200	YES
date	date		NO
time	time without time zone		NO
ip_address	character varying	45	NO
notes	character	100	YES

Sample Data (Max 10 Rows)

id	type	userid	date	time	ip_address	notes
1	admin_dewan	admin	2024-06-10	14:12:59	140.213.190.58	login.php login
2	admin_dewan	admin	2024-06-10	14:14:25	140.213.190.58	login.php login
3	admin_dewan	admin	2024-07-10	16:26:54	140.213.190.58	login.php login
4	admin_dewan	admin	2024-07-10	16:45:13	140.213.190.58	login.php login
5	admin_dewan	admin	2024-08-10	18:21:07	114.10.29.176	login.php login
6	admin_dewan	admin	2024-08-10	18:22:05	114.10.29.176	login.php login
7	admin_dewan	admin	2024-08-10	18:25:02	114.10.29.176	login.php login
8	admin_dewan	admin	2024-08-10	18:26:53	114.10.29.176	login.php login
9	admin_dewan	admin	2024-10-10	00:53:35	103.167.107.2	login.php login
10	admin_dewan	admin	2024-11-10	01:43:45	114.10.134.134	login.php login

Table: persons

Structure

Column	Type	Length	Nullable
id	integer		NO
name	character varying	100	NO
age	integer		NO
city	character varying	100	NO

Sample Data (Max 10 Rows)

No data found.

Table: tup

Structure

Column	Type	Length	Nullable
tupid	integer		NO
entry_date	date		YES
tran_date	date		YES
start_date	date		YES
due_date	date		YES
payment_date	date		YES
status	character	20	YES
id	character	20	YES
userid	character	30	YES
up	character	1	YES
amount	numeric		YES
name	character	200	YES
phone	character	40	YES
email	character	200	YES
street_1	character	200	YES
street_2	character	200	YES
region	character	100	YES
province	character	100	YES
city	character	100	YES
doc_transaction	bytea		YES
doc_payment	bytea		YES

Sample Data (Max 10 Rows)

tupid	entry_date	tran_date	start_date	due_date	payment_date	status	id	userid	up	amount	name	phone	email	street_1	street_2	region	province	city
6	2020-04-01	2024-10-13	2020-04-02	2020-04-03	2020-04-04	Paid	14	tepan	U	28747	Shalahuddin aaa Ahmad	085894163552	shalahuddin.ahmad@gmail.com	Jl. Mawar B-1, Mekarsari, Cimanggis	Pondok Mekarari Permai	Jawa Barat	Jabnar	KOTA DEPOK
3	2000-12-13	2024-10-12	2024-12-12	2024-12-15	2024-12-16	Cancelled	13	pante	U	3000000	Shalahuddin aaa Ahmad	085894163552	shalahuddin.ahmad@gmail.com	Jl. Mawar B-1, Mekarsari, Cimanggis	Pondok Mekarari Permai	Jawa Barat	aaa	KOTA DEPOK
1	2024-12-12	2024-10-12	2024-12-12	2024-12-31	2025-01-07	Paid	13	pante	U	1000	Shalahuddin aaa Ahmad	085894163552	shalahuddin.ahmad@gmail.com	Jl. Mawar B-1, Mekarsari, Cimanggis	Pondok Mekarari Permai	Jawa Barat	Jabar	KOTA DEPOK
4	2024-12-21	2024-10-12	2024-12-12	2024-05-05	2025-06-06	Paid	13	pante	P	321000	duran	939393	asdasd@gmail.com	asdasd	daf	assda	asdds	asasd
5	2024-12-11	2024-10-13	2024-12-12	2024-12-21	2024-12-12	Paid	13	pante	U	2569022	Shalahuddin aaa Ahmad	085894163552	shalahuddin.ahmad@gmail.com	Jl. Mawar B-1, Mekarsari, Cimanggis	Pondok Mekarari Permai	Jawa Barat	Jabnar	KOTA DEPOK
9	2001-05-12	2024-10-14	2001-05-13	2001-05-14	2001-05-15	Open	14	tepan	U	9988877	Shalahuddin aaa Ahmad	085894163552	shalahuddin.ahmad@gmail.com	Jl. Mawar B-1, Mekarsari, Cimanggis	Pondok Mekarari Permai	Jawa Barat	Jabnar	KOTA DEPOK
7	2020-04-01	2024-10-13	2020-04-01	2020-04-21	2020-04-23	Cancelled	14	tepan	P	1000	Shalahuddin aaa Ahmad	085894163552	shalahuddin.ahmad@gmail.com	Jl. Mawar B-1, Mekarsari, Cimanggis	Pondok Mekarari Permai	Jawa Barat	Jabnar	KOTA DEPOK
2	2000-12-12	2024-10-12	2024-12-12	2024-12-21	2024-12-23	Paid	13	pante	U	5000000	Johansyah	8288282	johan@duran.com	animo	ms	kudai	kurgan	mero
8	2020-04-01	2024-10-13	2020-04-01	2020-04-01	2020-04-01	Cancelled	13	pante	U	22222	Shalahuddin aaa Ahmad	085894163552	shalahuddin.ahmad@gmail.com	Jl. Mawar B-1, Mekarsari, Cimanggis	Pondok Mekarari Permai	Jawa Barat	SULSEL	KOTA DEPOK
10	2024-10-14	2024-10-14	2024-10-01	2024-10-03		Open	13	pante	U	5000000	Abdi	838383	ad@duran.com	jl. tumee	Jddidi	tora	bika	cendol

Table: user_appr

Structure

Column	Type	Length	Nullable
userid	character	30	YES
id	character	20	YES
pwd	character varying	60	YES
status	character	50	YES
request_on	date		YES
created_on	date		YES
created_by	character	130	YES
first_name	character	130	YES
middle_name	character	130	YES
last_name	character	100	YES
role	character	120	YES
valid_from	date		YES
valid_to	date		YES
phone	character	40	YES
email	character	200	YES
street_1	character	200	YES
street_2	character	200	YES
region	character	100	YES
province	character	100	YES
city	character	100	YES
country_code	character	3	YES
country	character	100	YES
birthdate	date		YES
birthplace	character	100	YES

Sample Data (Max 10 Rows)

userid	id	pwd	status	request_on	created_on	created_by	first_name	middle_name	last_name	role	valid_from	valid_to	phone	email	street_1	street_2	region	city	country_code	country	birthdate	birthplace
ifa	1		approved				Shalahuddin		Ahmad					shalahuddin.ahmad@gmail.com
tora	2		approved				Shalahuddin		Ahmad					shalahuddin.ahmad@gmail.com
tere	3		approved				Shalahuddin		Ahmad					shalahuddin.ahmad@gmail.com
jokeng	4	kengjo	approved	2024-10-12	2024-10-12	Admin	jojon	kekeng	99393	User	2024-10-12	9999-12-31							IDR	Indonesia	1967-09-12	manado
apaaja	5	paaja	approved	2024-10-12	2024-10-12	Admin	duran	duren	durin	User	2024-10-12	9999-12-31	9939393	kskds@gmail.com	jjdjd	jsdjds			IDN	Indonesia	1967-09-12	manado
jumi	6	juma	approved	2024-10-12	2024-10-12	wasiat	jumilah	anak	cantik	User	2024-10-12	9999-12-31	232323	shalahuddin.ahmad@gmail.com	Jl. Mawar B-1, Mekarsari, Cimanggis	Pondok Mekarari Permai	Jawa Barat	KOTA DEPOK	Ind	Indonesia	1967-09-12	Depok
sebelas	7	duabelas	approved	2024-10-12	2024-10-12	satu	tiga belas	empat	belas	User	2024-10-12	9999-12-31							IDN	Indonesia	1967-09-12	manado
temon	8	demon	approved	2024-10-12	2024-10-12	satu	temon	temon	temon	User	2024-10-12	9999-12-31							IDN	Indonesia	2000-01-12	jAKARTA
98	9	$2y$10$cmxvisRoXewjitRjC7ayIOxokOEnwEwZ5rTFzXgrrjH/Wd.IuO3Sy	approved	2024-10-12	2024-10-12	satu	98	98	98	User	2024-10-12	9999-12-31							IDN	I	2000-01-01	MANADO
sahmad010226	11	$2y$10$M8SANcClbHAmmTH6wX70luvOWI/0WHiWkQIBSzTZvSnGZ4AykEkQC	approved	2024-10-12	2024-10-12	satu	shalahuddin	bin	ahmad	User	2024-10-12	9999-12-31						Makassar	IDN	Indonesia	2000-01-12	manado

Table: user_master

Structure

Column	Type	Length	Nullable
userid	character	30	YES
id	character	20	YES
pwd	character varying	60	YES
status	character	50	YES
request_on	date		YES
created_on	date		YES
created_by	character	130	YES
first_name	character	130	YES
middle_name	character	130	YES
last_name	character	100	YES
role	character	120	YES
valid_from	date		YES
valid_to	date		YES
phone	character	40	YES
email	character	200	YES
street_1	character	200	YES
street_2	character	200	YES
region	character	100	YES
province	character	100	YES
city	character	100	YES
country_code	character	3	YES
country	character	100	YES
birthdate	date		YES
birthplace	character	100	YES

Sample Data (Max 10 Rows)

userid	id	pwd	status	request_on	created_on	created_by	first_name	middle_name	last_name	role	valid_from	valid_to	phone	email	street_1	street_2	region	province	city	country_code	country	birthdate	birthplace
tora	2	bika	approved	2024-10-10	2024-10-10	Admin	Shalahuddin	aaa	Ahmad	User	2024-10-10	2025-10-10	085894163552	shalahuddin.ahmad@gmail.com	Jl. Mawar B-1, Mekarsari, Cimanggis	Pondok Mekarari Permai	Jawa Barat		KOTA DEPOK	Ind	Indonesia	1967-12-12	manado
ifa	1	jjj	approved	2024-10-08	2024-10-08	Admin	Shalahuddin	aaa	Ahmad	User	2024-10-08	2025-10-08	085894163552	shalahuddin.ahmad@gmail.com	Jl. Mawar B-1, Mekarsari, Cimanggis	Pondok Mekarari Permai	Jawa Barat		KOTA DEPOK	Ind	Indonesia	2024-10-01	manado
tere	3	liye	approved	2024-10-11	2024-10-11	Admin	Shalahuddin	aaa	Ahmad	User	2024-10-11	2025-10-11	085894163552	shalahuddin.ahmad@gmail.com	Jl. Mawar B-1, Mekarsari, Cimanggis	Pondok Mekarari Permai	Jawa Barat		KOTA DEPOK	Ind	Indonesia	2024-10-12	manado
jokeng	4	kengjo	approved	2024-10-12	2024-10-12	Admin	jojon	kekeng	99393	User	2024-10-12	9999-12-31								IDR	Indonesia	1967-09-12	manado
apaaja	5	paaja	approved	2024-10-12	2024-10-12	Admin	duran	duren	durin	User	2024-10-12	9999-12-31	9939393	kskds@gmail.com	jjdjd	jsdjds				IDN	Indonesia	1967-09-12	manado
jumi	6	juma	approved	2024-10-12	2024-10-12	Admin	jumilah	anak	cantik	User	2024-10-12	9999-12-31	232323	shalahuddin.ahmad@gmail.com	Jl. Mawar B-1, Mekarsari, Cimanggis	Pondok Mekarari Permai	Jawa Barat		KOTA DEPOK	Ind	Indonesia	1967-09-12	Depok
sebelas	7	duabelas	approved	2024-10-12	2024-10-12	Admin	tiga belas	empat	belas	User	2024-10-12	9999-12-31								IDN	Indonesia	1967-09-12	manado
temon	8	demon	approved	2024-10-12	2024-10-12	Admin	temon	temon	temon	User	2024-10-12	9999-12-31								IDN	Indonesia	2000-01-12	jAKARTA
98	9	$2y$10$cmxvisRoXewjitRjC7ayIOxokOEnwEwZ5rTFzXgrrjH/Wd.IuO3Sy	approved	2024-10-12	2024-10-12	Admin	98	98	98	User	2024-10-12	9999-12-31								IDN	I	2000-01-01	MANADO
ahmad	10	$2y$10$Mcx0JdTftu8BN4RDu8WLw.fFLOMS91V3yxt0dr0tlILPcqijx7PVS	approved	2024-10-12	2024-10-12	Admin	Shalahuddin	Bin	Ahmad	User	2024-10-12	9999-12-31	0858	shal@gmail.com	sengkang	wajo	sulses	timur	makassar	IDN	Indonesia	2067-09-12	Bone