Create Table

create_table.sql

############################ SELLERS TABLE ###################################
########################################################################
create table sellers (
 seller_id number primary key,
 seller_name varchar2(45),
 seller_description varchar2(250)
);
insert into sellers values (1, 'Saigon Tourist', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.')
insert into sellers values (2, 'Pizza Hut', 'Temporibus autem quibusdam et aut officiis debitis aut rerum necessitatibus saepe eveniet ut et voluptates repudiandae sint et')
insert into sellers values (3, 'KFC', 'Et harum quidem rerum facilis est et expedita distinctio. Nam libero tempore, cum soluta')
insert into sellers values (4, 'Viettien', 'Nemo enim ipsam voluptatem quia voluptas sit aspernatur aut odit aut fugit, sed quia consequuntur magni dolores')
insert into sellers values (5, 'Addidas', 'Quis autem vel eum iure reprehenderit qui in ea voluptate velit esse quam nihil')


############################ USERS TABLE ###################################
######################################################################
create table users (
 user_id number primary key,
 first_name varchar2(45),
 last_name varchar2(45),
 email varchar2(45),
 password varchar2(45),
 address varchar2(45),
 phone varchar2(45)
);
insert into users values (1, 'Tin', 'Nguyen', 'tin@abc.com', '123456', '', '')
insert into users values (2, 'Phuc', 'Nguyen', 'phuc@sgt.com', '123456', '', '')
insert into users values (3, 'David', 'Choi', 'david@shopworld.com', '123456', '', '')
insert into users values (4, 'Paul', 'Walker', 'paul@vip.com', '123456', '', '')
insert into users values (5, 'Vin', 'Diesel', 'vin@gasonline.com', '123456', '', '')


############################ DEALERS TABLE ##############################
########################################################################
create table dealers (
 dealer_id number primary key,
 dealer_name varchar2(45),
 dealer_description varchar2(250)
);
insert into dealers values (1, 'Dealer A', 'Sed ut perspiciatis unde omnis iste natus error')
insert into dealers values (2, 'Dealer B', 'Eius modi tempora incidunt ut labore et dolore')
insert into dealers values (3, 'Dealer C', 'Nemo enim ipsam voluptatem quia voluptas sit aspernatur')
insert into dealers values (4, 'Dealer D', 'Duis aute irure dolor in reprehenderit in voluptate')
insert into dealers values (5, 'Dealer E', 'Sarchitecto beatae vitae dicta sunt explicabo.')


############################ PRODUCTS TABLE ###################################
########################################################################
create table products (
 product_id number primary key,
 product_name varchar2(45),
 product_price number(8,2),
 product_description varchar2(250),
 seller_id number constraint pro_sel_fk references sellers (seller_id)
);
insert into products values (1, 'Dinner at Japanese Restaurant', 20.15, '', 4)
insert into products values (2, 'Phan Thiet Resort Tour', 400.50, '', 1)
insert into products values (3, 'Half Price for dinner at Pizza Hut', 7.05, '', 2)
insert into products values (4, 'KFC mua 1 tang 1', 3.5, '', 3)
insert into products values (5, 'Addidas sale of', 10.15, '', 5)


############################ DEALS TABLE ################################
########################################################################
create table deals (
 deal_id number primary key,
 dealed_price number(8,2),
 old_price number(8,2),
 expiration_time date,
 dealer_id number constraint deal_dealer_fk references dealers (dealer_id),
 product_id number constraint deal_pro_fk references products (product_id)
);
insert into deals values (1, 18.15, 20.15, TO_DATE('05.06.2011', 'DD.MM.YYYY'), 1, 1)
insert into deals values (2, 300.05, 400.50, TO_DATE('07.07.2011', 'DD.MM.YYYY'), 1, 2)
insert into deals values (3, 5.05, 7.05, TO_DATE('12.07.2011', 'DD.MM.YYYY'), 2, 3)
insert into deals values (4, 2.5, 3.5, TO_DATE('20.05.2011', 'DD.MM.YYYY'), 3, 4)
insert into deals values (5, 8.15, 10.15, TO_DATE('27.09.2011', 'DD.MM.YYYY'), 5, 5)


############################ TICKETS TABLE ################################
########################################################################
create table tickets(
 ticket_id number primary key,
 code varchar2(45),
 deal_id number constraint tic_deals_fk references deals (deal_id),
 user_id number constraint tic_users_fk references users (user_id)
);
insert into tickets values (1, 'SAHV68', 1, 1)
insert into tickets values (2, 'HKO98', 1, 2)
insert into tickets values (3, 'SJU6TY', 3, 4)
insert into tickets values (4, '45TY89', 4, 4)
insert into tickets values (5, 'P545D', 5, 2)
insert into tickets values (6, 'CVB394', 3, 5)