Логички и физички дизајн - Креирање база податоци (со SQL DDL): polnenje.sql

INSERT INTO AuditlyUser (Id, FirstName, LastName, EmailAddress, ProductDomainName)
VALUES
(1, 'Leon', 'Spremo', leonspremo@gmail.com', 'heyreach.io'),
(2, 'Jane', 'Petel', 'jane.petel@outlook.com', 'nativeteams.com),
(3, 'Alex', 'Johnson', 'alex.johnson@email.com', '');

INSERT INTO UserProducts (UserId, ProductDomainName)
VALUES
(1, 'expandi.io'),
(3, 'prospeo.io'),
(1,'heyreach.io'),
(3, 'netnut.io'); 

INSERT INTO Product (ProductDomainName)
VALUES
('expandi.io'),
('prospeo.io'),
(nativeteams.com),
('smartrecruiters.com');


INSERT INTO ProductIndustry (ProductDomainName, Industry)
VALUES
('expandi.io', 'Lead Generation'),
('heyreach.io', ' Lead Intelligence'),
('heyreach.io', ' Lead Generation'),
('nativeteams.com', 'Freelancer Management Systems'),
('smartrecruiters.com', 'Recruitment Automation');

INSERT INTO Reviewer (Id, FirstName, LastName, Position, CompanyName, EmailAddress, LinkedInUserProfileUrl, DateOfReview)
VALUES
(1, 'Sarah', 'Miller', 'Analyst', 'TechAnalysis', 'sarah.miller@email.com', 'http://linkedin.com/sarahmiller','2023-12-12'),
(2, 'Mike', 'Brown', 'Senior Reviewer', 'MarketExperts', NULL, 'http://linkedin.com/mikebrown','2023-12-12'),
(3, 'Emily', 'White', 'Lead Researcher', 'BizInsights', 'emily.white@email.com', NULL,'2023-12-12');


INSERT INTO Message (Id, UserId, MessageType, EmailSubject, EmailText, LinkedInText)
VALUES
(1, 1, 'email', 'Question About Your Lead Generation Tool', 'Hello, I saw that you left a negative review about expandi, want to book a demo and show you our product?.', NULL),
(2, 2, 'linkedin', NULL, NULL, 'Heyo, I saw your lovely review on about our product and i would like to give you a 10% discount as a thank you :).'),
(3, 3, 'email', 'Meeting Request', 'Can we schedule a meeting for next week?', NULL);


INSERT INTO Review (Id, ReviewerId, ProductDomainName, ReviewSite, Sentiment, ReviewerScore, ReviewText)
VALUES
(1, 1, 'heyreach.io', 'g2', 'positive', 8.0, 'Great product with innovative features.'),
(2, 2, 'nativeteams.com', 'capterra', 'neutral', 3.5, NULL),
(3, 3, 'prospero.io', 'trustPilot', negative', NULL, 'Disappointing experience with customer service.');


INSERT INTO ReviewerSocialMediaLinks (SocialMediaLink, ReviewerId, SocialMediaType)
VALUES
('http://facebook.com/sarahmiller', 1, 'facebook'),
('http://twitter.com/mikebrown', 2, 'twitter'),
('http://instagram.com/emilywhite', 3, 'instagram');