menu_item


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
menu_item.parent_id FKA4FAA1F3BC856BBF R
version BIGINT 19 null
description VARCHAR 256 null
link VARCHAR 512 null
menu_id BIGINT 19 null
menu.id FKA4FAA1F32FF475B7 R
name VARCHAR 100
parent_id BIGINT 19 null
menu_item.id FKA4FAA1F3BC856BBF R
rank INT 10 null
type VARCHAR 255 null
new_window BIT 1 b'0'
roles VARCHAR 255 null
site_required BIT 1 null
permits TEXT 65535 null
icon VARCHAR 3000 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FKA4FAA1F32FF475B7 Performance Asc menu_id
FKA4FAA1F3BC856BBF Performance Asc parent_id

Relationships