bantuan

Column	Type	Null	Default	Links to	Comments	MIME
bantuan_id (Primary)	int(11)	No
pelanggan_id	int(11)	No		pelanggan -> pelanggan_id
id	int(11)	No
tterima	date	No
catatan	varchar(50)	No
status	text	No
sebantuan	text	No
at1	varchar(250)	No
at2	varchar(250)	No
at3	varchar(250)	No
at4	varchar(250)	No
at5	varchar(250)	No
at6	varchar(250)	No
at7	varchar(250)	No
at8	varchar(250)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	bantuan_id	28	A	No
pelanggan_id	BTREE	No	No	pelanggan_id	28	A	No

bencana

Column	Type	Null	Default	Links to	Comments	MIME
bencana_id (Primary)	int(11)	No
infobencana_id	int(11)	No		infobencana -> infobencana_id
kir_id	int(11)	No		ketuaisirumah -> kir_id
kirspp	text	No
tgg1spp	text	No
tgg2spp	text	No
tgg3spp	text	No
tgg4spp	text	No
tgg5spp	text	No
tgg6spp	text	No
tgg7spp	text	No
tgg8spp	text	No
tgg9spp	text	No
tgg10spp	text	No
tgg11spp	text	No
tgg12spp	text	No
tgg13spp	text	No
tgg14spp	text	No
tgg15spp	text	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	bencana_id	0	A	No
infobencana_id	BTREE	No	No	infobencana_id	0	A	No
kir_id	BTREE	No	No	kir_id	0	A	No

catatanketuaisirumah

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	int(11)	No
kir_id	int(11)	No		ketuaisirumah -> kir_id
tarikh	date	No
catatan	varchar(250)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No
kir_id	BTREE	No	No	kir_id	0	A	No

hartaketuaisirumah

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	int(11)	No
kir_id	int(11)	No		ketuaisirumah -> kir_id
harta	text	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No
kir_id	BTREE	No	No	kir_id	0	A	No

hotspot

Column	Type	Null	Default	Links to	Comments	MIME
hotspot_id (Primary)	int(11)	No
daerah	text	No
lokasi	varchar(50)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	hotspot_id	0	A	No

infobencana

Column	Type	Null	Default	Links to	Comments	MIME
infobencana_id (Primary)	int(11)	No
jbencana	text	No
lbencana	varchar(50)	No
tbencana	date	No
lokasipp	varchar(100)	No
tppbuka	date	Yes	NULL
tpptutup	date	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	infobencana_id	0	A	No

ketuaisirumah

Column	Type	Null	Default	Links to	Comments	MIME
kir_id (Primary)	int(11)	No
hotspot_id	int(11)	No		hotspot -> hotspot_id
nama	varchar(50)	No
noic	varchar(15)	No
jantina	text	No
umur	int(11)	No
notel	varchar(12)	No
wn	text	No
bangsa	text	No
pekerjaan	varchar(25)	No
pendapatan	varchar(10)	No
srumah	text	No
kerosakan	text	No
akerosakan	varchar(10)	No
alamat	varchar(200)	No
kategori	text	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	kir_id	0	A	No
hotspot_id	BTREE	No	No	hotspot_id	0	A	No

pelanggan

Column	Type	Null	Default	Links to	Comments	MIME
pelanggan_id (Primary)	int(11)	No
daerah	text	No
nama	text	No
ic	varchar(12)	No
notel	varchar(12)	No
bantuan	text	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	pelanggan_id	11101	A	No

pendketuaisirumah

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	int(11)	No
kir_id	int(11)	No		ketuaisirumah -> kir_id
pendapatan	varchar(20)	No
jumlah	int(11)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No
kir_id	BTREE	No	No	kir_id	0	A	No

perbelanjaanketuaisirumah

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	int(11)	No
kir_id	int(11)	No		ketuaisirumah -> kir_id
perkara	varchar(20)	No
jumlah	int(11)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No
kir_id	BTREE	No	No	kir_id	0	A	No

pma__bookmark

Table comments: Bookmarks

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	int(10)	No
dbase	varchar(255)	No
user	varchar(255)	No
label	varchar(255)	No
query	text	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

pma__central_columns

Table comments: Central list of columns

Column	Type	Null	Default	Links to	Comments	MIME
db_name (Primary)	varchar(64)	No
col_name (Primary)	varchar(64)	No
col_type	varchar(64)	No
col_length	text	Yes	NULL
col_collation	varchar(64)	No
col_isNull	tinyint(1)	No
col_extra	varchar(255)	Yes
col_default	text	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	db_name	0	A	No
				col_name	0	A	No

pma__column_info

Table comments: Column information for phpMyAdmin

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	int(5)	No
db_name	varchar(64)	No
table_name	varchar(64)	No
column_name	varchar(64)	No
comment	varchar(255)	No
mimetype	varchar(255)	No
transformation	varchar(255)	No
transformation_options	varchar(255)	No
input_transformation	varchar(255)	No
input_transformation_options	varchar(255)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No
db_name	BTREE	Yes	No	db_name	0	A	No
				table_name	0	A	No
				column_name	0	A	No

pma__designer_settings

Table comments: Settings related to Designer

Column	Type	Null	Default	Links to	Comments	MIME
username (Primary)	varchar(64)	No
settings_data	text	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	username	0	A	No

pma__export_templates

Table comments: Saved export templates

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	int(5)	No
username	varchar(64)	No
export_type	varchar(10)	No
template_name	varchar(64)	No
template_data	text	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No
u_user_type_template	BTREE	Yes	No	username	0	A	No
				export_type	0	A	No
				template_name	0	A	No

pma__favorite

Table comments: Favorite tables

Column	Type	Null	Default	Links to	Comments	MIME
username (Primary)	varchar(64)	No
tables	text	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	username	0	A	No

pma__history

Table comments: SQL history for phpMyAdmin

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	bigint(20)	No
username	varchar(64)	No
db	varchar(64)	No
table	varchar(64)	No
timevalue	timestamp	No	CURRENT_TIMESTAMP
sqlquery	text	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No
username	BTREE	No	No	username	0	A	No
				db	0	A	No
				table	0	A	No
				timevalue	0	A	No

pma__navigationhiding

Table comments: Hidden items of navigation tree

Column	Type	Null	Default	Links to	Comments	MIME
username (Primary)	varchar(64)	No
item_name (Primary)	varchar(64)	No
item_type (Primary)	varchar(64)	No
db_name (Primary)	varchar(64)	No
table_name (Primary)	varchar(64)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	username	0	A	No
				item_name	0	A	No
				item_type	0	A	No
				db_name	0	A	No
				table_name	0	A	No

pma__pdf_pages

Table comments: PDF relation pages for phpMyAdmin

Column	Type	Null	Default	Links to	Comments	MIME
db_name	varchar(64)	No
page_nr (Primary)	int(10)	No
page_descr	varchar(50)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	page_nr	0	A	No
db_name	BTREE	No	No	db_name	0	A	No

pma__recent

Table comments: Recently accessed tables

Column	Type	Null	Default	Links to	Comments	MIME
username (Primary)	varchar(64)	No
tables	text	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	username	0	A	No

pma__relation

Table comments: Relation table

Column	Type	Null	Default	Links to	Comments	MIME
master_db (Primary)	varchar(64)	No
master_table (Primary)	varchar(64)	No
master_field (Primary)	varchar(64)	No
foreign_db	varchar(64)	No
foreign_table	varchar(64)	No
foreign_field	varchar(64)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	master_db	0	A	No
				master_table	0	A	No
				master_field	0	A	No
foreign_field	BTREE	No	No	foreign_db	0	A	No
				foreign_table	0	A	No

pma__savedsearches

Table comments: Saved searches

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	int(5)	No
username	varchar(64)	No
db_name	varchar(64)	No
search_name	varchar(64)	No
search_data	text	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No
u_savedsearches_username_dbname	BTREE	Yes	No	username	0	A	No
				db_name	0	A	No
				search_name	0	A	No

pma__table_coords

Table comments: Table coordinates for phpMyAdmin PDF output

Column	Type	Null	Default	Links to	Comments	MIME
db_name (Primary)	varchar(64)	No
table_name (Primary)	varchar(64)	No
pdf_page_number (Primary)	int(11)	No	0
x	float	No	0
y	float	No	0

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	db_name	0	A	No
				table_name	0	A	No
				pdf_page_number	0	A	No

pma__table_info

Table comments: Table information for phpMyAdmin

Column	Type	Null	Default	Links to	Comments	MIME
db_name (Primary)	varchar(64)	No
table_name (Primary)	varchar(64)	No
display_field	varchar(64)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	db_name	0	A	No
				table_name	0	A	No

pma__table_uiprefs

Table comments: Tables' UI preferences

Column	Type	Null	Default	Links to	Comments	MIME
username (Primary)	varchar(64)	No
db_name (Primary)	varchar(64)	No
table_name (Primary)	varchar(64)	No
prefs	text	No
last_update	timestamp	No	CURRENT_TIMESTAMP

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	username	0	A	No
				db_name	0	A	No
				table_name	0	A	No

pma__tracking

Table comments: Database changes tracking for phpMyAdmin

Column	Type	Null	Default	Links to	Comments	MIME
db_name (Primary)	varchar(64)	No
table_name (Primary)	varchar(64)	No
version (Primary)	int(10)	No
date_created	datetime	No
date_updated	datetime	No
schema_snapshot	text	No
schema_sql	text	Yes	NULL
data_sql	longtext	Yes	NULL
tracking	set('UPDATE', 'REPLACE', 'INSERT', 'DELETE', 'TRUNCATE', 'CREATE DATABASE', 'ALTER DATABASE', 'DROP DATABASE', 'CREATE TABLE', 'ALTER TABLE', 'RENAME TABLE', 'DROP TABLE', 'CREATE INDEX', 'DROP INDEX', 'CREATE VIEW', 'ALTER VIEW', 'DROP VIEW')	Yes	NULL
tracking_active	int(1)	No	1

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	db_name	0	A	No
				table_name	0	A	No
				version	0	A	No

pma__userconfig

Table comments: User preferences storage for phpMyAdmin

Column	Type	Null	Default	Links to	Comments	MIME
username (Primary)	varchar(64)	No
timevalue	timestamp	No	CURRENT_TIMESTAMP
config_data	text	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	username	0	A	No

pma__usergroups

Table comments: User groups with configured menu items

Column	Type	Null	Default	Links to	Comments	MIME
usergroup (Primary)	varchar(64)	No
tab (Primary)	varchar(64)	No
allowed (Primary)	enum('Y', 'N')	No	N

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	usergroup	0	A	No
				tab	0	A	No
				allowed	0	A	No

pma__users

Table comments: Users and their assignments to user groups

Column	Type	Null	Default	Links to	Comments	MIME
username (Primary)	varchar(64)	No
usergroup (Primary)	varchar(64)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	username	0	A	No
				usergroup	0	A	No

tambahanketuaisirumah

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	int(11)	No
kir_id	int(11)	No
kediaman	varchar(250)	No
taksiran	varchar(250)	No
sejarahkes	varchar(250)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No
kir_id	BTREE	No	No	kir_id	0	A	No

tanggungan

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	int(11)	No
kir_id	int(11)	No
notgg	int(11)	No
nama	varchar(50)	No
noic	varchar(15)	No
jantina	text	No
umur	int(11)	No
wn	text	No
hubungan	text	No
pekerjaan	text	No
kategori	text	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No
kir_id	BTREE	No	No	kir_id	0	A	No

urusan

Column	Type	Null	Default	Links to	Comments	MIME
urusan_id (Primary)	int(11)	No
pelanggan_id	int(11)	No		pelanggan -> pelanggan_id
urusan	text	No
tarikh	date	No
catatan	varchar(50)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	urusan_id	25406	A	No
pelanggan_id	BTREE	No	No	pelanggan_id	25406	A	No

user

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	int(11)	No
name	varchar(50)	No
role	text	No
user_id	varchar(25)	No
pwd	text	No
jawatan	varchar(50)	No
daerah	text	No
status	text	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	6	A	No