Print view - phpMyAdmin 4.9.0.1

tbl_bidang

Column	Type	Null	Default	Links to	Comments	MIME
id_bidang (Primary)	int	No
nama_bidang	varchar(128)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id_bidang	14	A	No

tbl_fa

Column	Type	Null	Default	Links to	Comments	MIME
id_font (Primary)	int	No
font	varchar(32)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id_font	862	A	No

tbl_nav

Column	Type	Null	Default	Links to	Comments	MIME
id_nav (Primary)	int	No
desc_nav	varchar(32)	Yes	NULL
fa	varchar(32)	Yes	NULL

Indexes

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

tbl_online

Column	Type	Null	Default	Links to	Comments	MIME
id_user (Primary)	char(36)	No		tbl_user -> id_user
session	char(36)	No
date_time	datetime	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id_user	3	A	No

tbl_permissions

Column	Type	Null	Default	Links to	Comments	MIME
id_permissions (Primary)	int	No
priv_permissions	int	Yes	NULL
nav_permissions	int	Yes	NULL
create_permissions	char(1)	Yes	NULL
read_permissions	char(1)	Yes	NULL
update_permissions	char(1)	Yes	NULL
delete_permissions	char(1)	Yes	NULL

Indexes

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

tbl_privilages

Column	Type	Null	Default	Links to	Comments	MIME
id_priv (Primary)	int	No
desc_priv	varchar(32)	Yes	NULL
desc_priv_more	varchar(64)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id_priv	2	A	No

tbl_scan_sulur

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	bigint	No
id_sulur	int	No
path	varchar(256)	No
tgl	timestamp	No	CURRENT_TIMESTAMP
deskripsi	varchar(128)	No

Indexes

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

tbl_scan_suma

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	bigint	No
id_suma	int	No
path	varchar(256)	No
tgl	timestamp	No	CURRENT_TIMESTAMP
deskripsi	varchar(128)	No

Indexes

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

tbl_suma

Column	Type	Null	Default	Links to	Comments	MIME
id_suma (Primary)	bigint	No
no_suma	char(128)	No
pengirim_suma	varchar(256)	No
perihal_suma	varchar(256)	No
diterima_suma	date	No
tgl_entri_suma	timestamp	No	CURRENT_TIMESTAMP
disposisi	text	No
bidang	int	No
tgl_suma	date	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id_suma	29065	A	No

tbl_surat_keluar

Column	Type	Null	Default	Links to	Comments	MIME
id_sulur (Primary)	bigint	No
nomer_sulur	int	No
kode_sulur	char(32)	No
kepada_sulur	varchar(256)	No
perihal_sulur	varchar(256)	No
tanggal_sulur	date	No
pengolah_sulur	int	No
tgl_entri_sulur	timestamp	No	CURRENT_TIMESTAMP

Indexes

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

tbl_user

Column	Type	Null	Default	Links to	Comments	MIME
id_user (Primary)	char(36)	No
username	varchar(32)	Yes	NULL
password	varchar(255)	Yes	NULL
privilages_user	int	No
create_at	datetime	Yes	NULL
flag	char(2)	No	0

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id_user	4	A	No

tbl_user_desc

Column	Type	Null	Default	Links to	Comments	MIME
id_user (Primary)	char(36)	No
user_fullname	varchar(64)	Yes	NULL
user_email	varchar(64)	Yes	NULL
user_address	text	Yes	NULL
photo	varchar(255)	Yes	NULL

Indexes

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

tbl_user_log

Column	Type	Null	Default	Links to	Comments	MIME
number (Primary)	int	No
id_user	char(36)	No
date_and_time	datetime	No
user_agents	varchar(255)	No
ip_address	int	No
log	varchar(64)	No

Indexes

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

Open new phpMyAdmin window