/*2.*/
CREATE TABLE user_layout_pref
(
	user_id varchar2(20),
	menu_layout_pref varchar2(10) default 'normal',
	constraint userid_fk_ulp foreign key(user_id) references user_auth_details(user_id) on delete cascade 
);

/*1.*/
CREATE TABLE role_master
(
	roleid varchar2(10),
	roledesc varchar2(30) not null,
	constraint roleid_pk primary key(roleid),
);

/*3.*/
CREATE TABLE menu_master
(
	menuid varchar2(10),
	parent_menuid varchar2(10),
	menudesc varchar2(30) not null,
	constraint menuid_pk primary key(menuid)
);

/*4.*/
CREATE TABLE role_menu_mapping
(
	roleid varchar2(10),
	menuid varchar2(10),
	constraint roleid_fk_rmm foreign key(roleid) references role_master(roleid) on delete cascade,
	constraint menuid_fk_rmm foreign key(menuid) references menu_master(menuid) on delete cascade
);


LOGIN TEAM TABLE :- user_auth_details

		- user_id varchar(20)
		- roleid varchar2(10) default 'R001',
		- login_time date,