RelationalDesign: polnenje.sql

insert into users (user_id, user_name, surname, email, username, user_password)
values (1, 'Dijana', 'Manceva', 'dijanamanceva@gmailcom', 'Dijana23', '123434' ),
(2, 'Evgenija', 'Nikolaevska', 'evgenijanikolaevska@gmailcom', 'Evgenija232', '3454565' ),
(3, 'Trajce', 'Najdovski', 'trajcenajdovski@gmailcom', 'Trajce12', '6565656' ),
(4, 'Marija', 'Maneska', 'marijamaneska@gmailcom', 'MarijaM232', 'asadsddsd' ),
(5, 'Natasa', 'Petreska', 'natasapetreska@gmailcom', 'NatasaP445', 'awewdddfdf' );


insert into roles(id_role, role_name, role_desc)
values(100, 'Manager','Responsible for managing employees and employee schedules, also in charge for budgeting'),
(200, 'Coordinator','Responsible for planning, managing profit and loss, handling cash at the store as well as collating daily sales'),
(300, 'Sales Associate','Responsible for maintaining the store’s clean and organized appearance, restocking items, and checking out customers'),
(400, 'Cashier','Responsible for processing purchases and transactions'),
(500, 'Visual Merchandiser','Their job is to help ensure the best products in your store are highlighted in strategic ways and in specific parts of your store'),
(600, 'Inventory Control Specialist','Responsible for preventing loss, tracking and maintaining inventory');



insert into online_stores(store_id, names, web_address, phone_number, email, social_media)
values(11, 'Zara','www.zara.com','02 444 7894','zaraofficial@gmail.com','https://www.facebook.com/ZARACare'),
(22, 'Bershka','www.bershka.com','02 308 7912','bershkaofficial@yahoo.com','https://www.facebook.com/Bershka'),
(33, 'New Yorker','www.new-yorker.com','02 565 1123','newyorkerofficial@gmail.com','https://www.facebook.com/New-Yorker'),
(44, 'Stradivarius','www.stradivarius.com','02 333 7589','stradivariusofficial@gmail.com','https://www.facebook.com/StradivariusPage'),
(55, 'Pull & Bear','www.pullandbear.com','02 545 1122','pullandbear@yahoo.com','https://www.facebook.com/Pull&Bear' ),
(66, 'LC Waikiki','www.lc-waikiki.com','02 478 9869','lcwaikikipage@yahoo.com','https://www.facebook.com/LC-Waikiki');


insert into category(category_id, category_name)
values(1, 'special occasion clothes'),
(2, 'sport clothes'),
(3, 'ski clothes'),
(4, 'winter clothes'),
(5, 'fall clothes'),
(6, 'summer clothes');

insert into client(client_number_id, user_id)
values(1, 1),
(2, 2),
(3, 3),
(4, 4),
(5, 5);

insert into shipping_employee(shipping_employee_id, user_id)
values(1, 1),
(2, 2),
(3, 3),
(4, 4),
(5, 5);

insert into store_employee(store_employee_id, store_id, user_id)
values(12, 11, 1),
(13, 22, 2),
(14, 33, 3);

insert into works_as(id_role, user_id, works_from, works_to)
values(100, 1, '2013-05-12', now()),
(200, 2, '2014-02-01', now()),
(300, 3, '2012-04-02', now()),
(400, 4, '2018-06-10', now());


insert into catalogue(catalogue_id, catalogue_from, catalogue_to, type_, store_id)
values (1, '2021-10-29', '2022-02-10', 'winter', 11),
(2, '2022-02-11', '2022-04-30', 'spring', 22),
(3, '2022-05-01', '2022-08-15', 'summer', 33), 
(4, '2022-08-16', '2022-10-28', 'autumn', 44);

insert into product(product_id, names, in_store, sizes, color, category_id)
values (1, 'jeans', True, 'S', 'blue', 1),
(21, 'jacket', True, 'S', 'black', 1),
(2, 'tshirt', True, 'S', 'red', 1),
(3, 'coat', False, 'S', 'brown', 1),
(4, 'pants', True, 'S', 'black', 2 ),
(5, 'skirts', True, 'S', 'yellow', 3),
(6, 'shirt', true, 'S', 'green', 3),
(7, 'jeans', True, 'M', 'blue', 4),
(8, 'jacket', True, 'M', 'black', 5),
(9, 'tshirt', False, 'M', 'red', 4),
(10, 'coat', True, 'M', 'black', 4),
(11, 'pants', False, 'M', 'black', 5),
(12, 'skirts', True, 'M', 'yellow', 5),
(13, 'shirt', true, 'M', 'green', 1),
(14, 'jeans', True, 'L', 'black', 6),
(15,'jacket', True, 'L', 'black', 2),
(16, 'tshirt', True, 'L', 'red', 3),
(17, 'coat', False, 'L', 'brown', 4),
(18, 'pants', True, 'L', 'black', 5),
(19, 'skirts', True, 'L', 'yellow', 6),
(20, 'shirt', true, 'L', 'black', 1);

insert into product_in_store(product_in_store_id, store_id, product_id)
values(1, 11, 1),
(2, 22, 2),
(3, 33, 3),
(4, 44, 4);

insert into existss(product_in_store_id, catalogue_id, store_id)
values(1, 1, 11),
(2, 2, 22),
(3, 3, 33),
(4, 4, 44);

insert into price(price_id, price, price_from, price_to, product_in_store_id)
values (1, 500, '2021-10-29', '2022-02-10', 1),
(2, 700, '2022-02-11', '2022-04-30', 2),
(3, 800,'2022-05-01', '2022-08-15', 3), 
(4, 900, '2022-08-16', '2022-10-28', 4),
(5, 300, '2022-12-18', '2022-12-18', 1);

insert into shopping_bag(shopping_id, order_date, shipping_date, modified, user_id)
values (1, now(), now()+interval'3 days', now(), 1),
(2, now(), now()+interval'3 days', now(), 3),
(3, now(), now()+interval'3 days', now(), 2),
(4, now(), now()+interval'3 days', now(), 4);

insert into shipping(shipping_id, locations, date_from, date_to, user_id, shopping_id)
values(1, 'Kavadarci',now(),now()+interval'7 days', 1, 1),
(2, 'Skopje',now(),now()+interval'7 days', 2, 2),
(3, 'Skopje',now(),now()+interval'7 days', 3, 3),
(4, 'Veles',now(),now()+interval'7 days', 4, 4),
(5, 'Bitola',now(),now()+interval'7 days', 5, 4);

insert into orders(amount, shopping_id, product_in_store_id, price_id)
values(3, 1, 1, 1),
(7, 2, 2, 2),
(10, 2, 3, 3),
(4, 1, 4, 4);

select * from orders

insert into project.payment(payment_id, info, shopping_id)
values(5, 'Paypal', 4),
(4, 'Visa', 3),
(3, 'MasterCard', 2),
(2, 'WesternUnion', 1),
(1, 'Zelle', 1);