dbinsert.sql

INSERT INTO levels VALUES
('gold'),
('silver'),
('bronze');

INSERT INTO brandType VALUES
('headwear'),
('footwear'),
('underwear'),
('sportswear'),
('everydaywear');

INSERT INTO users VALUES 
('ABC1234567','abcd1234','John','123-456-7890','123 Dobong-ro, Seoul','male','1990-01-01','gold'),
('DEF8901234','efgh5678','Alice','456-789-1230','456 Gangnam-daero, Seoul','female','1985-03-15','silver'),
('GHI5678901','ijkl9012','Mike','789-123-4560','789 Yeouido-dong, Seoul','male','2000-07-20','bronze'),
('JKL2345678','mnop3456','Emily','321-654-9870','101 Hangangno 3-gil, Seoul','female','1992-12-05','gold'),
('MNO9012345','qrst7890','Chris','654-987-3210','202 Jongno-gu, Seoul','male','1988-06-10','silver'),
('PQR6789012','uvwx1234','Sara','987-321-6540','303 Itaewon-dong, Seoul','female','1995-09-25','bronze'),
('STU3456789','yzab5678','Alex','111-222-3333','404 Sinchon-dong, Seoul','male','1983-02-18','gold'),
('VWX0123456','cdef9012','Linda','222-333-4444','505 Sinchon-ro, Seoul','female','1979-11-30','silver'),
('YZA7890123','ghij3456','Tom','333-444-5555','606 Myeongdong, Seoul','male','1998-04-12','bronze'),
('BCD4567890','klmn7890','Eva','444-555-6666','707 Eulji-ro, Seoul','female','1980-08-08','gold'),
('EFG1234567','opqr1234','Mark','555-666-7777','808 Samseong-dong, Seoul','male','1993-06-23','silver'),
('HIJ8901234','stuv5678','Grace','666-777-8888','909 Jamsil-dong, Seoul','female','1982-10-19','bronze'),
('KLM5678901','wxyz9012','Peter','777-888-9999','111 Gwanghwamun, Seoul','male','2002-03-04','gold'),
('NOP2345678','bcde3456','Sophia','888-999-0000','222 Yongsan-gu, Seoul','female','1991-07-14','silver'),
('QRS9012345','fghi7890','Oliver','999-000-1111','333 Apgujeong-ro, Seoul','male','1986-04-28','bronze'),
('TUV6789012','jklm1234','Emma','000-111-2222','444 Mapo-gu, Seoul','female','2001-01-09','gold'),
('WXY3456789','nopq5678','Daniel','123-234-3456','555 Hongdae, Seoul','male','1997-09-03','silver'),
('ZAB0123456','rstu9012','Mia','234-345-4567','666 Sinchon-dong, Seoul','female','1987-12-11','bronze'),
('CDE7890123','vwxy3456','Ethan','345-456-5678','777 Yeoksam-dong, Seoul','male','1994-05-16','gold'),
('FGH4567890','zabc7890','Ava','456-567-6789','888 Sinsa-dong, Seoul','female','1984-03-08','silver');

INSERT INTO employees VALUES 
('LMN1234567','uvwx1234','John','sales'),
('XYZ8901234','yzab5678','Alice','management'),
('UVW5678901','cdef9012','Mike','hr'),
('RST2345678','ghij3456','Emily','sales'),
('CBA9012345','klmn7890','Chris','management'),
('DEF6789012','opqr1234','Sara','hr'),
('GHI3456789','stuv5678','Alex','sales'),
('JKL0123456','wxyz9012','Linda','management'),
('OPQ7890123','bcde3456','Tom','hr'),
('EFG4567890','fghi7890','Eva','sales');

INSERT INTO brands(brandType,brandName,brandIntro) VALUES 
('headwear',"Hat Haven","Perfect Style for Your Head"),
('headwear',"Cap Creations","The Art of Hats"),
('headwear',"Peak Performance Hats","High Performance, Top-notch Hats"),
('headwear',"Crown Couture","Crown-Like Designs"),
('headwear',"Shade Seeker","Coolness in Nature"),
('headwear',"Urban Elegance Headwear","Urban Elegance"),
('headwear',"Headgear Heroes","Heroes for Your Head"),
('headwear',"Brim Bliss","The Ultimate Hat Experience"),
('headwear',"SunChic Hats","Elegance Even Under the Sun"),
('headwear',"Hatopia","The Perfect World of Hats"),
('footwear',"Sole Supreme","The Perfect Choice in Footwear"),
('footwear',"WalkWonders","Walking Becomes Marvelous"),
('footwear',"FootLuxe","Elegance and Comfort in Every Step"),
('footwear',"StrideStyle","Walking in Style"),
('footwear',"KickMaster","Mastering with Every Kick"),
('footwear',"Urban Soles","Urban Footsteps"),
('footwear',"Sneaker Symphony","The Music of Sneakers"),
('footwear',"ComfortCrafted Kicks","Comfort Comes First"),
('footwear',"Posh Peds","Premium Footsteps"),
('footwear',"StepStylist","Fashion with Each Step"),
('underwear',"Silk Secrets","Silk-Covered Secrets"),
('underwear',"Lace Elegance","Elegance in Lace"),
('underwear',"Inner Bliss Intimates","Inner Happiness"),
('underwear',"Cotton Comfort Co","Comfortable Cotton Underwear"),
('underwear',"LingerieLux","The Splendor of Lingerie"),
('underwear',"Bare Essentials","Essential Essentials"),
('underwear',"Velvet Touch Underwear","Velvet-Touched Undergarments"),
('underwear',"Sensual Secrets","Sensuous Secrets"),
('underwear',"Silk & Satin Sensations","The Marvel of Silk and Satin"),
('underwear',"Undercover Elegance","Secret Elegance"),
('sportswear',"ActiveVibe","Feeling Active"),
('sportswear',"FitFlex Gear","Gear for Your Physique"),
('sportswear',"SportStrike","Sports Impact"),
('sportswear',"PowerPulse Activewear","Active Wear with Power Pulse"),
('sportswear',"ZenAthletic","Gentle Sensation of Exercise"),
('sportswear',"SwiftMotion Sportswear","Sportswear for Swift Movements"),
('sportswear',"Peak Performance Athletic","Sports Apparel for Peak Performance"),
('sportswear',"GymChic","Sleek Gym Style"),
('sportswear',"ActivePro Apparel","Professional Activewear"),
('sportswear',"SportFusion","The Fusion of Sports and Style"),
('everydaywear',"Everyday Elegance","Everyday Elegance"),
('everydaywear',"Casual Comfort Co","Comfortable Casual Style"),
('everydaywear',"Wardrobe Wonders","Wardrobe Wonders"),
('everydaywear',"UrbanEase","Comfort in the City"),
('everydaywear',"ChicStreet","Stylish Street Style"),
('everydaywear',"DailyDapper","Style for Every Day"),
('everydaywear',"EasyLiving Attire","Effortless and Comfortable Lifestyle Apparel"),
('everydaywear',"SimpleStyle","Simplicity in Style"),
('everydaywear',"CasualCouture","Casual Couture"),
('everydaywear',"StreetSmart Fashion","Urban Smart Fashion");

INSERT INTO products(brandID,productName,price,salePrice,target,stock) VALUES 
(1,"Classic Cotton Ball Cap",11700,10530,'unisex',91),
(1,"Vintage Fedora Hat",41300,37170,'unisex',97),
(1,"Beach Bliss Straw Hat",19100,17190,'unisex',66),
(1,"Nice White Ball cap",10500,9450,'unisex',11),
(2,"Snapback Style Snap Cap",32900,29610,'unisex',47),
(2,"Leather Elegance Cap",18700,16830,'unisex',99),
(2,"Retro Vibes Baseball Cap",49900,44910,'unisex',11),
(2,"Mesh Magic Trucker Hat",49700,44730,'unisex',97),
(3,"Sports Enthusiast Cap",31300,28170,'unisex',89),
(3,"Trailblazer Adventure Hat",26600,23940,'unisex',20),
(3,"Classic Elegance Sun Hat",20400,18360,'unisex',71),
(3,"Mohair Comfort Beanie",41700,37530,'unisex',82),
(4,"Tiara Crown Princess Hat",17000,15300,'women',59),
(4,"Royal Crown King's Hat",41600,37440,'men',73),
(4,"Queen's Regal Crown Cap",10800,9720,'women',0),
(4,"King's Jeweled Crown Hat",20700,18630,'men',13),
(5,"SunChaser Wide-Brim Hat",30200,27180,'unisex',37),
(5,"Sporty Sun Visor",10800,9720,'unisex',56),
(5,"Pro Golfer's Sun Hat",17400,15660,'men',66),
(5,"Expedition Safari Hat",33900,30510,'unisex',49),
(6,"Timeless Elegance Top Hat",43700,39330,'women',81),
(6,"Vintage Bowler Hat",21000,18900,'men',60),
(6,"Urban Flat Cap Collection",35200,31680,'unisex',11),
(6,"Classic Newsboy Cap",10800,9720,'men',62),
(7,"Heroic Crown Collection",31100,27990,'men',50),
(7,"Epic Gladiator Cap",12200,10980,'men',17),
(7,"Viking Legends Hat",40900,36810,'men',98),
(7,"Space Odyssey Hat",48600,43740,'unisex',21),
(8,"Elegant Wide Brim Sun Hat",39800,35820,'unisex',92),
(8,"Seaside Straw Hat",41400,37260,'women',7),
(8,"Panama Dreams Hat",42400,38160,'women',25),
(8,"Vintage Cloche Collection",24900,22410,'women',86),
(9,"Beach Ready Sun Visor",45000,40500,'unisex',41),
(9,"Beachcomber Bucket Hat",33400,30060,'unisex',14),
(9,"Bohemian Floppy Hat",36500,32850,'women',33),
(9,"Sun-Kissed Straw Fedora",20800,18720,'unisex',23),
(10,"All-Weather Trucker Cap",28500,25650,'unisex',14),
(10,"Urban Snapback Style Hat",14000,12600,'unisex',56),
(10,"Cozy Knit Beanie",16000,14400,'unisex',77),
(10,"Retro Bucket Hat",35200,31680,'unisex',17),
(11,"Classic Canvas Sneakers",71200,64080,'unisex',27),
(11,"Urban Explorer Boots",50800,45720,'men',31),
(11,"Slip-On Comfort Loafers",97500,87750,'women',23),
(11,"Beach Adventure Sandals",66800,60120,'men',31),
(12,"Comfort Ballet Flats",87400,78660,'women',43),
(12,"Leather Luxury Loafers",99200,89280,'men',54),
(12,"Casual Slip-On Flats",66000,59400,'unisex',34),
(12,"Velvet Elegance Ankle Boots",82700,74430,'women',75),
(13,"SpeedRunner Running Shoes",83500,75150,'unisex',14),
(13,"Glamour Heel Collection",98200,88380,'women',2),
(13,"Adventure Hiker Boots",86600,77940,'men',32),
(13,"Sporty Comfort Sandals",96400,86760,'unisex',8),
(14,"Street Style Sneakers",96100,86490,'unisex',32),
(14,"Chic Wedge Sandals",81100,72990,'unisex',83),
(14,"Cozy Indoor Slippers",53900,48510,'unisex',40),
(14,"Modern Loafer Collection",68700,61830,'men',18),
(15,"Performance Running Sneakers",72200,64980,'unisex',93),
(15,"Active Adventure Sandals",65700,59130,'men',91),
(15,"ProCourt Tennis Shoes",62600,56340,'women',51),
(15,"Slam Dunk Basketball Shoes",86000,77400,'men',61),
(16,"Classic Oxford Elegance",83400,75060,'unisex',25),
(16,"Urban Chelsea Collection",67700,60930,'men',48),
(16,"Comfort Moccasin Loafers",78000,70200,'men',30),
(16,"Beachside Espadrilles",58400,52560,'women',15),
(17,"High-Top Street Style",64200,57780,'unisex',52),
(17,"Urban Skater Collection",86300,77670,'unisex',46),
(17,"SpeedRush Running Trainers",80300,72270,'unisex',92),
(17,"Slip-On Street Sneakers",78900,71010,'unisex',34),
(18,"ProGolfer Golf Shoes",61700,55530,'women',59),
(18,"Summer Breeze Espadrilles",55300,49770,'unisex',51),
(18,"ActiveStride Athletic Sneakers",97800,88020,'unisex',75),
(18,"Elegant Dress Oxford Shoes",53900,48510,'women',27),
(19,"RunActive Running Shoes",76000,68400,'unisex',35),
(19,"Urban Slip-On Street Sneakers",57200,51480,'unisex',94),
(19,"Classic Loafer Collection",61100,54990,'men',50),
(19,"Stylish High Heels",63600,57240,'women',87),
(20,"Stylish Sneakers",63600,57240,'unisex',84),
(20,"Beach Sandals",58100,52290,'women',75),
(20,"Comfortable Indoor Slippers",93900,84510,'unisex',33),
(20,"Modern Loafer",54800,49320,'men',89),
(21,"Elegant Lace Bralette",40000,36000,'women',85),
(21,"Silk Elegance Panties",31800,28620,'women',100),
(21,"Comfort Seamless Briefs",40300,36270,'women',26),
(21,"Active Support Sports Bra",48800,43920,'women',13),
(22,"Luxurious Satin Chemise",46700,42030,'women',48),
(22,"Romantic Lace Teddy",34700,31230,'women',79),
(22,"Silky Elegance Robe",49700,44730,'women',29),
(22,"Sheer Temptation Bodysuit",49500,44550,'women',43),
(23,"Everyday Comfort Briefs",41300,37170,'women',45),
(23,"Classic Boxer Shorts",45200,40680,'women',9),
(23,"Cozy Pajama Set",38200,34380,'unisex',47),
(23,"Lounge Comfort Bralette",48500,43650,'women',5),
(24,"Silk Sensation Camisole",36000,32400,'women',42),
(24,"Delicate Lace Thong",48600,43740,'women',88),
(24,"Satin Dreams Sleepwear Set",43500,39150,'women',4),
(24,"Sensual Silk Robe",35800,32220,'women',64),
(25,"Lift & Shape Push-Up Bra",42600,38340,'women',21),
(25,"Body Sculpting Shapewear",34700,31230,'women',78),
(25,"Classic Corset Collection",45100,40590,'women',30),
(25,"Full Comfort Coverage Panties",46800,42120,'unisex',77),
(26,"Lacy Elegance Lingerie Set",33500,30150,'women',8),
(26,"Lace Allure Bralette",31500,28350,'women',15),
(26,"Sensual Silk Chemise",48800,43920,'women',93),
(26,"Sheer Delight Panties",45200,40680,'women',69),
(27,"Everyday Comfort Camisole",41600,37440,'women',21),
(27,"Classic Comfort Briefs",36800,33120,'women',12),
(27,"Cozy Sleep Shorts",43500,39150,'men',84),
(27,"Wireless Comfort Bralette",48200,43380,'women',94),
(28,"Sheer Temptation Lingerie",32300,29070,'women',49),
(28,"Romantic Lace Teddy",40400,36360,'women',55),
(28,"Satin Elegance Robe",43000,38700,'women',35),
(28,"Sensual Silk Chemise",49700,44730,'women',5),
(29,"Ultra Comfort Seamless Bra",44600,40140,'women',23),
(29,"Seamless Bliss Panties",47700,42930,'women',15),
(29,"Cozy Lounge Set",38600,34740,'women',22),
(29,"Wireless Comfort Bralette",49600,44640,'women',80),
(30,"Luxurious Satin Chemise",41200,37080,'women',95),
(30,"Romantic Lace Teddy",37800,34020,'women',27),
(30,"Silky Elegance Robe",47600,42840,'women',21),
(30,"Sheer Tempt",32600,29340,'women',78),
(31,"Performance Leggings",39100,35190,'women',41),
(31,"High Impact Sports Bra",57700,51930,'women',86),
(31,"FlexFit Workout Shorts",59300,53370,'women',56),
(31,"Breathable Tank Top",87000,78300,'women',89),
(32,"Reflective Running Jacket",88800,79920,'unisex',19),
(32,"Zen Yoga Pants",89000,80100,'women',83),
(32,"Elite Compression Tights",35700,32130,'women',22),
(32,"Performance Workout Hoodie",46700,42030,'unisex',18),
(33,"Pro Cyclist Shorts",60900,54810,'men',86),
(33,"CrossFit Performance Shirt",71900,64710,'men',19),
(33,"SpeedRunner Leggings",49400,44460,'women',84),
(33,"FlexFit Workout Capris",61000,54900,'women',64),
(34,"Performance Athletic Shorts",78400,70560,'unisex',3),
(34,"Maximum Support Sports Bra",91300,82170,'women',73),
(34,"Zen Yoga Tank",39600,35640,'women',73),
(34,"Elite Compression Socks",44400,39960,'unisex',46),
(35,"SpeedRush Running Tights",75400,67860,'women',50),
(35,"CrossFit Performance Shorts",39700,35730,'unisex',29),
(35,"Performance Leggings",46500,41850,'men',77),
(35,"FlexFit Workout Jacket",82300,74070,'unisex',33),
(36,"High-Waist Performance Leggings",61700,55530,'women',96),
(36,"Seamless Sports Bra Top",79600,71640,'women',61),
(36,"FlexFit Workout Shorts",76200,68580,'unisex',83),
(36,"Moisture-Wicking Athletic Tee",67400,60660,'men',63),
(37,"SpeedRunner Running Shorts",92400,83160,'unisex',52),
(37,"Zen Yoga Leggings",57500,51750,'women',51),
(37,"Elite Compression Top",46700,42030,'unisex',60),
(37,"Performance Workout Leggings",70500,63450,'women',0),
(38,"CrossFit Performance Leggings",61900,55710,'women',16),
(38,"High-Impact CrossFit Sports Bra",82900,74610,'women',27),
(38,"Pro CrossFit Shorts",35700,32130,'unisex',15),
(38,"Performance CrossFit Tank Top",62200,55980,'women',71),
(39,"SpeedRunner Running Capris",36300,32670,'women',24),
(39,"Maximum Support Sports Bra",56400,50760,'women',29),
(39,"Zen Yoga Pants",61300,55170,'women',12),
(39,"Elite Compression Shorts",31700,28530,'unisex',37),
(40,"SpeedRunner Running Shorts",54800,49320,'unisex',98),
(40,"Maximum Support Sports Bra",50200,45180,'women',81),
(40,"Zen Yoga Leggings",53100,47790,'women',54),
(40,"Elite Compression Top",35700,32130,'unisex',8),
(41,"Everyday Comfort T-Shirt",39200,35280,'unisex',31),
(41,"Classic Denim Jeans",31200,28080,'men',90),
(41,"Cozy Hooded Sweatshirt",35100,31590,'unisex',47),
(41,"Knit Pullover Sweater",57000,51300,'men',81),
(42,"Casual Midi Dress",46000,41400,'women',66),
(42,"Casual Summer Shorts",39300,35370,'men',2),
(42,"Relaxed Fit Button-Up Shirt",37800,34020,'men',35),
(42,"Trendy Jumpsuit",50900,45810,'men',57),
(43,"Urban Style Mini Skirt",47500,42750,'women',48),
(43,"Elegant Blouse",46600,41940,'women',37),
(43,"Slim Fit Chino Pants",32700,29430,'men',45),
(43,"Lightweight Cardigan Sweater",68400,61560,'unisex',3),
(44,"Stretchy Leggings",66700,60030,'women',1),
(44,"Comfortable Sweatpants",58800,52920,'unisex',69),
(44,"Flowy Tunic Top",57300,51570,'women',34),
(44,"Classic Denim Jacket",42400,38160,'men',54),
(45,"Classic Polo Shirt",39300,35370,'unisex',50),
(45,"Khaki Chinos",55200,49680,'men',42),
(45,"Maxi Summer Dress",69600,62640,'women',42),
(45,"Cozy Cardigan Sweater",68200,61380,'women',95),
(46,"Urban Graphic T-Shirt",48900,44010,'unisex',42),
(46,"Cargo Utility Pants",44300,39870,'men',21),
(46,"Trendy Bomber Jacket",66200,59580,'men',18),
(46,"Skater Style Dress",49000,44100,'women',2),
(47,"Urban Jumpsuit",52400,47160,'unisex',64),
(47,"Street Style Graphic Hoodie",47900,43110,'unisex',8),
(47,"Denim Cutoff Shorts",56600,50940,'men',13),
(47,"Striped Casual Top",37800,34020,'men',0),
(48,"Stylish Midi Skirt",50300,45270,'women',75),
(48,"Trendy Graphic Sweatshirt",43100,38790,'unisex',100),
(48,"Classic Denim Overalls",45100,40590,'unisex',5),
(48,"Trench Coat with Belt",32500,29250,'women',13),
(48,"Urban Crop Top",50900,45810,'women',90),
(49,"Pleated Midi Skirt",69700,62730,'women',10),
(49,"Utility Style Jumpsuit",54600,49140,'men',24),
(49,"Denim Shacket with Pockets",45500,40950,'men',85),
(49,"Plaid Flannel Shirt",47700,42930,'women',48),
(50,"Wide-Leg Palazzo Pants",60100,54090,'men',18),
(50,"Casual Graphic T-Shirt",58700,52830,'unisex',78),
(50,"Cozy Knit Sweater Dress",32700,29430,'women',41);

INSERT INTO wishes VALUES 
('ABC1234567',33),
('ABC1234567',34),
('ABC1234567',35),
('DEF8901234',36),
('DEF8901234',37),
('GHI5678901',38),
('GHI5678901',39),
('GHI5678901',40),
('JKL2345678',41),
('JKL2345678',42),
('JKL2345678',43),
('MNO9012345',44),
('MNO9012345',45),
('MNO9012345',46),
('PQR6789012',47),
('PQR6789012',48),
('STU3456789',49),
('STU3456789',50),
('STU3456789',51),
('VWX0123456',52),
('VWX0123456',53),
('VWX0123456',54),
('YZA7890123',55),
('YZA7890123',56),
('YZA7890123',57),
('BCD4567890',58),
('BCD4567890',59),
('BCD4567890',60),
('EFG1234567',29),
('EFG1234567',30),
('EFG1234567',31),
('HIJ8901234',32),
('HIJ8901234',33),
('HIJ8901234',34),
('KLM5678901',35),
('KLM5678901',36),
('KLM5678901',37),
('NOP2345678',38),
('NOP2345678',39),
('NOP2345678',40),
('QRS9012345',41),
('QRS9012345',42),
('TUV6789012',43),
('TUV6789012',44),
('TUV6789012',45),
('WXY3456789',46),
('WXY3456789',47),
('ZAB0123456',48),
('CDE7890123',49),
('FGH4567890',50);

INSERT INTO orders(userID, productID, brandID, date, comment,purchasePrice) VALUES 
('ABC1234567',1,1,'2023-09-01',"Please wrap the clothes for a gift.",10530),
('ABC1234567',17,5,'2023-09-02',"",27180),
('ABC1234567',3,1,'2023-09-03',"",17190),
('DEF8901234',1,1,'2023-09-04',"Deliver the clothes on a specific date.
",10530),
('DEF8901234',3,1,'2023-09-05',"",17190),
('GHI5678901',20,5,'2023-09-06',"",30510),
('GHI5678901',5,2,'2023-09-07',"Send a confirmation email for the order.",29610),
('GHI5678901',15,4,'2023-09-08',"",9720),
('JKL2345678',32,8,'2023-09-09',"Provide care and maintenance instructions for these clothes.
",22410),
('JKL2345678',10,3,'2023-09-10',"Send order confirmation emails with status updates.",23940),
('JKL2345678',43,11,'2023-09-11',"",87750),
('MNO9012345',51,13,'2023-09-12',"",77940),
('MNO9012345',65,17,'2023-09-13',"Expedite the delivery of these clothes.",57780),
('MNO9012345',46,12,'2023-09-14',"",89280),
('PQR6789012',76,19,'2023-09-15',"Can you gift wrap these clothes?",57240),
('PQR6789012',51,13,'2023-09-16',"",77940),
('STU3456789',65,17,'2023-09-17',"",57780),
('STU3456789',77,20,'2023-09-18',"",57240),
('STU3456789',51,13,'2023-09-19',"",77940),
('VWX0123456',52,13,'2023-09-20',"I need the clothes to be delivered discreetly.",86760),
('VWX0123456',83,21,'2023-09-21',"",36270),
('VWX0123456',92,23,'2023-09-22',"",43650),
('YZA7890123',110,28,'2023-09-23',"",36360),
('YZA7890123',97,25,'2023-09-24',"Please include a gift message with the package.",38340),
('YZA7890123',84,21,'2023-09-25',"",43920),
('BCD4567890',88,22,'2023-09-26',"Notify me when the clothes are out for delivery.",44550),
('BCD4567890',92,23,'2023-09-27',"Include a personalized thank-you note with the order.",43650),
('BCD4567890',117,30,'2023-09-28',"",37080),
('EFG1234567',92,23,'2023-09-29',"Include a receipt with the order.",43650),
('EFG1234567',84,21,'2023-09-30',"",43920),
('EFG1234567',127,32,'2023-10-01',"",32130),
('HIJ8901234',134,34,'2023-10-02',"",82170),
('HIJ8901234',154,39,'2023-10-03',"Can I schedule the delivery time for these clothes?",50760),
('HIJ8901234',122,31,'2023-10-04',"",51930),
('KLM5678901',131,33,'2023-10-05',"",44460),
('KLM5678901',134,34,'2023-10-06',"Confirm the estimated arrival date for my order.",82170),
('KLM5678901',147,37,'2023-10-07',"",42030),
('NOP2345678',134,34,'2023-10-08',"",82170),
('NOP2345678',124,31,'2023-10-09',"Let me know when the clothes are dispatched.",78300),
('NOP2345678',138,35,'2023-10-10',"",35730),
('QRS9012345',161,41,'2023-10-11',"",35280),
('QRS9012345',192,48,'2023-10-12',"",29250),
('TUV6789012',199,50,'2023-10-13',"Send me care instructions specific to these clothes.",52830),
('TUV6789012',184,46,'2023-10-14',"",44100),
('TUV6789012',165,42,'2023-10-15',"",41400),
('WXY3456789',186,47,'2023-10-16',"Include a gift receipt in case of returns.",43110),
('WXY3456789',177,45,'2023-10-17',"",35370),
('ZAB0123456',165,42,'2023-10-18',"",41400),
('CDE7890123',171,43,'2023-10-19',"",29430),
('FGH4567890',170,43,'2023-10-20',"",41940),
('FGH4567890',32,8,'2023-11-02',"",22410),
('FGH4567890',33,9,'2023-11-03',"",40500),
('FGH4567890',34,9,'2023-11-04',"",30060),
('FGH4567890',35,9,'2023-11-05',"",32850);

INSERT INTO deliveries VALUES 
(1,'done'),
(2,'done'),
(3,'done'),
(4,'done'),
(5,'done'),
(6,'done'),
(7,'done'),
(8,'done'),
(9,'done'),
(10,'done'),
(11,'done'),
(12,'done'),
(13,'done'),
(14,'done'),
(15,'done'),
(16,'done'),
(17,'done'),
(18,'done'),
(19,'done'),
(20,'done'),
(21,'done'),
(22,'done'),
(23,'done'),
(24,'done'),
(25,'done'),
(26,'done'),
(27,'done'),
(28,'done'),
(29,'done'),
(30,'done'),
(31,'done'),
(32,'done'),
(33,'done'),
(34,'done'),
(35,'done'),
(36,'done'),
(37,'done'),
(38,'done'),
(39,'done'),
(40,'done'),
(41,'done'),
(42,'done'),
(43,'done'),
(44,'done'),
(45,'done'),
(46,'done'),
(47,'done'),
(48,'done'),
(49,'done'),
(50,'done'),
(51,'shipping'),
(52,'shipping'),
(53,'ready'),
(54,'paid');

INSERT INTO reviews(userID,productID,date,grade,comment) VALUES
('ABC1234567',1,'2023-09-06',4,"This hat brand always delivers on style and comfort. A go-to choice for completing any outfit."),
('ABC1234567',17,'2023-09-07',3,"The quality of their hats is exceptional. I love their wide range of designs, from classic to trendy."),
('ABC1234567',3,'2023-09-08',3,"These hats are the perfect blend of fashion and function. I'm a fan of their versatility."),
('DEF8901234',1,'2023-09-09',5,"If you're looking for a reliable hat brand, look no further. They've got something for everyone."),
('DEF8901234',3,'2023-09-10',4,"Their hats are a statement piece. You'll turn heads with one of these on."),
('GHI5678901',20,'2023-09-11',5,"I appreciate the attention to detail in their hat designs. It's all about the little things."),
('GHI5678901',5,'2023-09-12',3,"This brand consistently offers the latest hat trends, making it easy to stay fashionable."),
('GHI5678901',15,'2023-09-13',3,"Their hats are durable and can withstand daily wear. A great investment for your headwear collection."),
('JKL2345678',32,'2023-09-14',4,"I love how this brand combines classic and modern styles in their hats. Always a hit."),
('JKL2345678',10,'2023-09-15',3,"You can't go wrong with their hats. They are a must-have accessory for any season."),
('JKL2345678',43,'2023-09-16',4,"This footwear brand combines style and comfort effortlessly. Every step is a pleasure."),
('MNO9012345',51,'2023-09-17',4,"The attention to detail in their shoe designs is truly impressive. It's all about craftsmanship."),
('MNO9012345',65,'2023-09-18',5,"I love the versatility of their shoes. From casual to formal, they've got you covered."),
('MNO9012345',46,'2023-09-19',4,"If you're in search of durable and long-lasting footwear, this brand should be your go-to."),
('PQR6789012',76,'2023-09-20',5,"Their shoes are like a second skin for your feet. You'll forget you're even wearing them."),
('PQR6789012',51,'2023-09-21',3,"This brand offers a wide range of sizes and widths, making it easy to find your perfect fit."),
('STU3456789',65,'2023-09-22',4,"The quality of materials used in their shoes is top-notch. You can feel the difference."),
('STU3456789',77,'2023-09-23',3,"Their shoes are built to withstand any weather conditions. Rain or shine, they've got you covered."),
('STU3456789',51,'2023-09-24',4,"These shoes are worth every penny. The investment is worth it for the comfort and style."),
('VWX0123456',52,'2023-09-25',4,"I've never been disappointed with this shoe brand. They consistently exceed my expectations."),
('VWX0123456',83,'2023-09-26',5,"This underwear brand is all about comfort. Their fabrics are incredibly soft and breathable."),
('VWX0123456',92,'2023-09-27',4,"I appreciate the variety of styles and colors this brand offers. There's something for everyone."),
('YZA7890123',110,'2023-09-28',4,"The fit of their underwear is perfect, and it stays that way even after multiple washes."),
('YZA7890123',97,'2023-09-29',4,"If you're in search of affordable and high-quality underwear, this brand is a top choice."),
('YZA7890123',84,'2023-09-30',3,"Their underwear is so comfy that you'll forget you're wearing it. A definite confidence booster."),
('BCD4567890',88,'2023-10-01',5,"I love the seamless designs this brand has to offer. No more visible panty lines!"),
('BCD4567890',92,'2023-10-02',3,"This brand's underwear is perfect for everyday wear. You'll feel great all day long."),
('BCD4567890',117,'2023-10-03',5,"The durability of their underwear is impressive. It lasts longer than most brands I've tried."),
('EFG1234567',92,'2023-10-04',4,"These undergarments are a great value for the price. I can't recommend them enough."),
('EFG1234567',84,'2023-10-05',4,"Their underwear is like a second skin. You'll never want to wear anything else."),
('EFG1234567',127,'2023-10-06',3,"This sports brand has everything you need for an active lifestyle. Quality and performance combined."),
('HIJ8901234',134,'2023-10-07',4,"I've been a fan of their sportswear for years. It's designed for athletes, and it shows."),
('HIJ8901234',154,'2023-10-08',3,"The range of sports gear they offer is impressive. You'll find the perfect fit for your sport of choice."),
('HIJ8901234',122,'2023-10-09',3,"This brand is synonymous with innovation. Their products always keep up with the latest technology."),
('KLM5678901',131,'2023-10-10',3,"I trust this brand for my workouts. The durability and functionality are unbeatable."),
('KLM5678901',134,'2023-10-11',3,"Their sports apparel looks great both in and out of the gym. It's all about style and performance."),
('KLM5678901',147,'2023-10-12',3,"You'll feel confident and comfortable in this brand's sportswear. It's a game-changer."),
('NOP2345678',134,'2023-10-13',3,"The support and flexibility in their sports bras are unmatched. Perfect for intense workouts."),
('NOP2345678',124,'2023-10-14',5,"Whether you're a beginner or a pro athlete, this brand has something for everyone."),
('NOP2345678',138,'2023-10-15',5,"I've never been disappointed with this sports brand. Their products elevate my fitness journey."),
('QRS9012345',161,'2023-10-16',3,"This clothing brand is my daily go-to. It's all about comfort and style for everyday wear."),
('QRS9012345',192,'2023-10-17',5,"The variety of clothing styles they offer is fantastic. From casual to formal, they've got it all."),
('TUV6789012',199,'2023-10-18',4,"I appreciate the quality of their fabrics. Their clothes stand up to daily wear and tear."),
('TUV6789012',184,'2023-10-19',5,"If you want a brand that offers both classic and trendy pieces, look no further."),
('TUV6789012',165,'2023-10-20',4,"Their clothing is versatile and easy to mix and match. You can create countless outfits."),
('WXY3456789',186,'2023-10-21',3,"I love the attention to detail in their designs. It's the little things that make a big difference."),
('WXY3456789',177,'2023-10-22',4,"This brand consistently keeps up with fashion trends. You'll always be in style."),
('ZAB0123456',165,'2023-10-23',4,"Their clothes are durable and can handle the demands of daily life. A must-have for your wardrobe."),
('CDE7890123',171,'2023-10-24',5,"These pieces are a great value for the price. I can't get enough of their everyday style."),
('FGH4567890',170,'2023-10-25',4,"You can trust this brand for your daily fashion needs. It's all about looking and feeling great.");

INSERT INTO notifications (writerID, date, content) VALUES 
('LMN1234567','2023-10-31',"New product 'Super Widget' is now available for purchase."),
('XYZ8901234','2023-10-30',"We have a special offer for our valued customers. Get 20% off on all products this week."),
('UVW5678901','2023-10-29',"Important update: Changes in our return policy. Please read."),
('RST2345678','2023-10-28',"Customer support will be available 24/7 starting next month."),
('CBA9012345','2023-10-27',"Hurry! Limited stock available for the 'Mega Gadget.'"),
('DEF6789012','2023-10-26',"Check out our new collection of summer apparel."),
('GHI3456789','2023-10-25',"Get free shipping on orders over $50. Shop now!"),
('JKL0123456','2023-10-24',"We are hosting a customer appreciation event at our store this Saturday."),
('OPQ7890123','2023-10-23',"Product safety is our top priority. Learn more about our quality control."),
('EFG4567890','2023-10-22',"Introducing our loyalty program. Earn rewards with every purchase.");

INSERT INTO qna (userID, type, date, comment) VALUES 
('ABC1234567','General','2023-10-31',"How do I use this product?"),
('DEF8901234','Product','2023-10-30',"Is this product available in other colors?"),
('GHI5678901','Shipping','2023-10-29',"When will my order be shipped?"),
('JKL2345678','General','2023-10-28',"Can I return the product if I'm not satisfied?"),
('MNO9012345','Product','2023-10-27',"What are the features of this product?"),
('PQR6789012','General','2023-10-26',"How can I track my order?"),
('STU3456789','Shipping','2023-10-25',"How long does shipping take?"),
('VWX0123456','Product','2023-10-24',"Do you have this product in a larger size?"),
('YZA7890123','General','2023-10-23',"Is there a warranty for this product?"),
('BCD4567890','Shipping','2023-10-22',"Can I change the delivery address?"),
('EFG1234567','General','2023-10-21',"How can I contact customer support?"),
('HIJ8901234','Product','2023-10-20',"What materials is the product made of?"),
('KLM5678901','Shipping','2023-10-19',"Is international shipping available?"),
('NOP2345678','General','2023-10-18',"How do I cancel my order?"),
('QRS9012345','Product','2023-10-17',"Can I get a discount on bulk orders?"),
('TUV6789012','Shipping','2023-10-16',"What courier service do you use for shipping?"),
('WXY3456789','General','2023-10-15',"Do you have a loyalty program?"),
('ZAB0123456','Product','2023-10-14',"Are there any upcoming product releases?"),
('CDE7890123','General','2023-10-13',"How can I check the status of my order?"),
('FGH4567890','Shipping','2023-10-12',"Can I change my delivery time?");

INSERT INTO replyqna (qnaID, employeeID, date, comment) VALUES 
(1,'LMN1234567','2023-10-31',"You can use the product by following the user manual."),
(2,'XYZ8901234','2023-10-30',"Yes, the product is available in multiple colors."),
(3,'UVW5678901','2023-10-29',"Your order will be shipped within 2-3 business days."),
(4,'RST2345678','2023-10-28',"Yes, you can return the product within 30 days if not satisfied."),
(5,'CBA9012345','2023-10-27',"The product features include..."),
(6,'DEF6789012','2023-10-26',"You can track your order by logging into your account."),
(7,'GHI3456789','2023-10-25',"Shipping typically takes 5-7 business days."),
(8,'JKL0123456','2023-10-24',"We offer larger sizes for this product."),
(9,'OPQ7890123','2023-10-23',"Yes, there is a 1-year warranty for this product."),
(10,'EFG4567890','2023-10-22',"You can change the delivery address by contacting customer support.");

INSERT INTO coupons (rank, expirationDate, discountRate, minFee) VALUES 
('gold','2023-12-31',20,50000),
('silver','2023-12-31',15,40000),
('bronze','2023-12-31',10,30000),
('gold','2023-12-31',25,60000),
('silver','2023-12-31',20,50000),
('bronze','2023-12-31',15,40000),
('gold','2023-12-31',30,7000),
('silver','2023-12-31',25,6000),
('bronze','2023-12-31',20,5000),
('gold','2023-12-31',35,8000);