create table category(cat_id int primary key auto_increment, cat_name varchar(30),cat_label varchar(30));

create table product(prod_id int primary key auto_increment, cat_id int(11), prod_name varchar(100),prod_desc varchar(100), foreign key (cat_id) references category(cat_id))

create table sales(sales_id int primary key auto_increment, prod_id int(11), sales_name varchar(100),sales_desc varchar(100),
foreign key(prod_id) references product(prod_id));

rails generate scaffold category cat_id:integer cat_name:string cat_label:string