create table sys_menu (
id int identity,
sys_pid int null,
sys_menuname varchar(50) null,
sys_menuurl varchar(100) null,
sys_state int null,
createtime datetime null,
createuser int null,
updatetime datetime null,
updateuser int null,
constraint PK_SYS_MENU primary key (id)
)

layUI+mvc,动态菜单数据表，sqlserver