initialize.sql

DROP DATABASE IF EXISTS project;

CREATE DATABASE project;

\c project

\i create.sql

\copy Administrator(aid, name, email, role) FROM administrator.csv CSV HEADER;

\copy Customer(cid, name, email, phone, registration_date, status) FROM customer.csv CSV HEADER;

\copy Merchant(mid, aid, name, status, registration_date, business_type, pin_code, address, contact_number) FROM merchant.csv CSV HEADER;

\copy Brand(brand_id, brand_name, description) FROM brand.csv CSV HEADER;

\copy Category(category_id, name, description) FROM category.csv CSV HEADER;

\copy Payment_method(method_id, customer_id) FROM payment_method.csv CSV HEADER;

\copy Loyalty_Account(method_id, amount, expiry_date) FROM loyalty_account.csv CSV HEADER;

\copy Card(method_id, card_number, card_network, pin, owner_name) FROM card.csv CSV HEADER;

\copy Offer(offer_id, mid, title, description, discount_value, original_price, status, valid_from, valid_to, max_redemptions, total_redemptions, max_per_customer, daily_cap, terms_and_conditions) FROM offer.csv CSV HEADER;

\copy OfferCategory(offer_id, category_id) FROM offerCategory.csv CSV HEADER;

\copy CategoryBrand(category_id, brand_id) FROM categoryBrand.csv CSV HEADER;

\copy Gift(gift_id, sender_id, receiver_id, offer_id) FROM gift.csv CSV HEADER;

\copy Redemption(rid, merchant_id, customer_id, offer_id, savings_amount, redemption_date, status, pin_entered) FROM redemption.csv CSV HEADER;

\copy Save(offer_id, customer_id) FROM save.csv CSV HEADER;