/*	create database tile	*/

create database tile

create table item
(
	item_id bigint,
	item_name varchar(250),
	disp_name varchar(250),
	material text,
	item_weight double,
	weight_unit varchar(100),
	color varchar(100),
	length varchar(250),
	height varchar(250),
	width varchar(250),
	price double,
	sample_price double 
)

create table orders
(
	order_id bigint,
	o_date date,
	s_date date,
	status varchar(250),
	track_no varchar(250),
	shipping_charge double,
	shipping_mode varchar(250),
	total double,
	b_f_name varchar(250),
	b_l_name varchar(250),
	b_address_1  varchar(250),
	b_address_2 varchar(250),
	b_city varchar(250), 
	b_state varchar(250),
	b_zip varchar(250),
	b_country varchar(250),
	b_phone varchar(250),
	b_fax varchar(250),
	b_email varchar(250),
	s_f_name varchar(250),
	s_l_name varchar(250),
	s_address_1 varchar(250),
	s_address_2 varchar(250),
	s_city varchar(250),
	s_state varchar(250),
	s_zip varchar(250),
	s_country varchar(250),
	s_phone varchar(250),
	s_fax varchar(250),
	s_email varchar(250)
)

create table items_ordered
(
	io_id bigint,
	order_id bigint,
	item_id bigint,
	qty bigint,
	color varchar(50),
	sample int,
	amount double
)