menu

257 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 null
menu.parent menu_parent_menu_id_fk R
name varchar 255 null
icon varchar 255 √ null
outcome varchar 255 √ null
urut int4 10 √ null
parent int4 10 √ null
menu.id menu_parent_menu_id_fk R
keterangan text 2147483647 √ null
jenis varchar 1 √ null
target varchar 50 √ null
url varchar 255 √ null
id_permission int4 10 √ null
permission.id menu_id_permission_permission_id_fk R

Indexes

Constraint Name Type Sort Column(s)
menu_pkey Primary key Asc id
menu_name_parent_unique Must be unique Asc/Asc name + parent

Relationships

Close relationships within degrees of separation