drop table products;
create table products ( prod_id number(6,0) not null enable, prod_name varchar2(50 byte) not null enable, prod_desc varchar2(4000 byte) not null enable, prod_subcategory varchar2(50 byte) not null enable, prod_subcategory_id number not null enable, prod_subcategory_desc varchar2(2000 byte) not null enable, prod_category varchar2(50 byte) not null enable, prod_category_id number not null enable, prod_category_desc varchar2(2000 byte) not null enable, prod_weight_class number(3,0) not null enable, prod_unit_of_measure varchar2(20 byte), prod_pack_size varchar2(30 byte) not null enable, supplier_id number(6,0) not null enable, prod_status varchar2(20 byte) not null enable, prod_list_price number(8,2) not null enable, prod_min_price number(8,2) not null enable, prod_total varchar2(13 byte) not null enable, prod_total_id number not null enable, prod_src_id number, prod_eff_from date, prod_eff_to date, prod_valid varchar2(1 byte) );
drop table sales;
create table sales ( prod_id number not null enable, cust_id number not null enable, time_id date not null enable, channel_id number not null enable, promo_id number not null enable, quantity_sold number(10,2) not null enable, amount_sold number(10,2) not null enable, prod_name varchar2(50 byte) ) ;
drop table times;
create table times ( time_id date not null enable, day_name varchar2(9 byte) not null enable, day_number_in_week number(1,0) not null enable, day_number_in_month number(2,0) not null enable, calendar_week_number number(2,0) not null enable, fiscal_week_number number(2,0) not null enable, week_ending_day date not null enable, week_ending_day_id number not null enable, calendar_month_number number(2,0) not null enable, fiscal_month_number number(2,0) not null enable, calendar_month_desc varchar2(8 byte) not null enable, calendar_month_id number not null enable, fiscal_month_desc varchar2(8 byte) not null enable, fiscal_month_id number not null enable, days_in_cal_month number not null enable, days_in_fis_month number not null enable, end_of_cal_month date not null enable, end_of_fis_month date not null enable, calendar_month_name varchar2(9 byte) not null enable, fiscal_month_name varchar2(9 byte) not null enable, calendar_quarter_desc char(7 byte) not null enable, calendar_quarter_id number not null enable, fiscal_quarter_desc char(7 byte) not null enable, fiscal_quarter_id number not null enable, days_in_cal_quarter number not null enable, days_in_fis_quarter number not null enable, end_of_cal_quarter date not null enable, end_of_fis_quarter date not null enable, calendar_quarter_number number(1,0) not null enable, fiscal_quarter_number number(1,0) not null enable, calendar_year number(4,0) not null enable, calendar_year_id number not null enable, fiscal_year number(4,0) not null enable, fiscal_year_id number not null enable, days_in_cal_year number not null enable, days_in_fis_year number not null enable, end_of_cal_year date not null enable, end_of_fis_year date not null enable ); |