-- ============================================================
-- SEED DUMMY DATA FOR ALL STYLE SUB-ENTITIES (20 tables × 9 styles)
-- ============================================================

-- Clear existing sub-entity data
SET FOREIGN_KEY_CHECKS = 0;
TRUNCATE TABLE style_measurement_values;
TRUNCATE TABLE style_measurements;
TRUNCATE TABLE style_colorways;
TRUNCATE TABLE style_bom;
TRUNCATE TABLE style_consumption;
TRUNCATE TABLE style_operations;
TRUNCATE TABLE style_cost_components;
TRUNCATE TABLE style_costing;
TRUNCATE TABLE style_packaging;
TRUNCATE TABLE style_compliance;
TRUNCATE TABLE style_documents;
TRUNCATE TABLE style_ai_analysis;
TRUNCATE TABLE style_approvals;
TRUNCATE TABLE style_versions;
TRUNCATE TABLE style_sizes;
TRUNCATE TABLE style_tech_pack;
TRUNCATE TABLE style_purchase;
TRUNCATE TABLE style_production;
TRUNCATE TABLE style_qa;
TRUNCATE TABLE style_sustainability;
SET FOREIGN_KEY_CHECKS = 1;

-- ============================================================
-- 1. STYLE_MEASUREMENTS — Measurement point definitions
-- ============================================================
INSERT INTO style_measurements (company_id, style_id, point_name, sequence, tolerance, spec_type) VALUES
-- T-Shirt (1)
(1,1,'Chest Width',1,0.50,'buyer'),(1,1,'Body Length',2,0.50,'buyer'),(1,1,'Sleeve Length',3,0.25,'buyer'),(1,1,'Shoulder Width',4,0.25,'buyer'),(1,1,'Neck Opening',5,0.25,'buyer'),(1,1,'Hem Width',6,0.50,'buyer'),
-- Chino Pants (2)
(1,2,'Waist',1,0.50,'buyer'),(1,2,'Hip',2,0.50,'buyer'),(1,2,'Inseam',3,0.50,'buyer'),(1,2,'Outseam',4,0.50,'buyer'),(1,2,'Thigh',5,0.25,'buyer'),(1,2,'Knee',6,0.25,'buyer'),(1,2,'Leg Opening',7,0.25,'buyer'),
-- Blazer (3)
(1,3,'Chest',1,0.50,'buyer'),(1,3,'Shoulder',2,0.25,'buyer'),(1,3,'Sleeve Length',3,0.25,'buyer'),(1,3,'Back Length',4,0.50,'buyer'),(1,3,'Waist',5,0.50,'buyer'),(1,3,'Neck Drop',6,0.25,'buyer'),
-- Sweater (4)
(1,4,'Chest',1,0.50,'buyer'),(1,4,'Length',2,0.50,'buyer'),(1,4,'Sleeve',3,0.25,'buyer'),(1,4,'Shoulder',4,0.25,'buyer'),(1,4,'Hem',5,0.50,'buyer'),
-- Running Shorts (5)
(1,5,'Waist',1,0.50,'buyer'),(1,5,'Hip',2,0.50,'buyer'),(1,5,'Inseam',3,0.25,'buyer'),(1,5,'Outseam',4,0.50,'buyer'),(1,5,'Leg Opening',5,0.25,'buyer'),
-- Hoodie (6)
(1,6,'Chest',1,0.50,'buyer'),(1,6,'Body Length',2,0.50,'buyer'),(1,6,'Sleeve Length',3,0.25,'buyer'),(1,6,'Shoulder',4,0.25,'buyer'),(1,6,'Hood Height',5,0.25,'buyer'),(1,6,'Pocket Width',6,0.50,'buyer'),
-- Running Tights (7)
(1,7,'Waist',1,0.50,'buyer'),(1,7,'Hip',2,0.50,'buyer'),(1,7,'Inseam',3,0.25,'buyer'),(1,7,'Thigh',4,0.25,'buyer'),(1,7,'Knee',5,0.25,'buyer'),(1,7,'Ankle Opening',6,0.25,'buyer'),
-- Base Layer (8)
(1,8,'Chest',1,0.50,'buyer'),(1,8,'Body Length',2,0.50,'buyer'),(1,8,'Sleeve Length',3,0.25,'buyer'),(1,8,'Shoulder',4,0.25,'buyer'),(1,8,'Neck Opening',5,0.25,'buyer'),
-- Denim Jacket (9)
(1,9,'Chest',1,0.50,'buyer'),(1,9,'Shoulder',2,0.25,'buyer'),(1,9,'Sleeve Length',3,0.25,'buyer'),(1,9,'Back Length',4,0.50,'buyer'),(1,9,'Waist',5,0.50,'buyer'),(1,9,'Neck Drop',6,0.25,'buyer');

-- ============================================================
-- 2. STYLE_MEASUREMENT_VALUES — Values per size
-- ============================================================
INSERT INTO style_measurement_values (company_id, style_id, measurement_id, size_label, value, revision) VALUES
-- T-Shirt measurements (id 1-6)
(1,1,1,'S',48.00,1),(1,1,1,'M',52.00,1),(1,1,1,'L',56.00,1),(1,1,1,'XL',60.00,1),(1,1,1,'XXL',64.00,1),
(1,1,2,'S',68.00,1),(1,1,2,'M',70.00,1),(1,1,2,'L',72.00,1),(1,1,2,'XL',74.00,1),(1,1,2,'XXL',76.00,1),
(1,1,3,'S',20.00,1),(1,1,3,'M',21.00,1),(1,1,3,'L',22.00,1),(1,1,3,'XL',23.00,1),(1,1,3,'XXL',24.00,1),
(1,1,4,'S',40.00,1),(1,1,4,'M',42.00,1),(1,1,4,'L',44.00,1),(1,1,4,'XL',46.00,1),(1,1,4,'XXL',48.00,1),
(1,1,5,'S',19.00,1),(1,1,5,'M',20.00,1),(1,1,5,'L',21.00,1),(1,1,5,'XL',22.00,1),(1,1,5,'XXL',23.00,1),
(1,1,6,'S',46.00,1),(1,1,6,'M',50.00,1),(1,1,6,'L',54.00,1),(1,1,6,'XL',58.00,1),(1,1,6,'XXL',62.00,1),
-- Chino Pants measurements (id 7-13)
(1,2,7,'30',76.00,1),(1,2,7,'32',81.00,1),(1,2,7,'34',86.00,1),(1,2,7,'36',91.00,1),
(1,2,8,'30',96.00,1),(1,2,8,'32',101.00,1),(1,2,8,'34',106.00,1),(1,2,8,'36',111.00,1),
(1,2,9,'30',78.00,1),(1,2,9,'32',78.00,1),(1,2,9,'34',78.00,1),(1,2,9,'36',78.00,1),
(1,2,10,'30',104.00,1),(1,2,10,'32',106.00,1),(1,2,10,'34',108.00,1),(1,2,10,'36',110.00,1),
(1,2,11,'30',28.00,1),(1,2,11,'32',29.50,1),(1,2,11,'34',31.00,1),(1,2,11,'36',32.50,1),
(1,2,12,'30',20.00,1),(1,2,12,'32',21.00,1),(1,2,12,'34',22.00,1),(1,2,12,'36',23.00,1),
(1,2,13,'30',16.00,1),(1,2,13,'32',17.00,1),(1,2,13,'34',18.00,1),(1,2,13,'36',19.00,1),
-- Blazer measurements (id 14-19)
(1,3,14,'S',96.00,1),(1,3,14,'M',102.00,1),(1,3,14,'L',108.00,1),(1,3,14,'XL',114.00,1),
(1,3,15,'S',42.00,1),(1,3,15,'M',44.00,1),(1,3,15,'L',46.00,1),(1,3,15,'XL',48.00,1),
(1,3,16,'S',63.00,1),(1,3,16,'M',64.50,1),(1,3,16,'L',66.00,1),(1,3,16,'XL',67.50,1),
(1,3,17,'S',68.00,1),(1,3,17,'M',70.00,1),(1,3,17,'L',72.00,1),(1,3,17,'XL',74.00,1),
(1,3,18,'S',88.00,1),(1,3,18,'M',94.00,1),(1,3,18,'L',100.00,1),(1,3,18,'XL',106.00,1),
(1,3,19,'S',22.00,1),(1,3,19,'M',23.00,1),(1,3,19,'L',24.00,1),(1,3,19,'XL',25.00,1);

-- ============================================================
-- 3. STYLE_COLORWAYS — Color variants
-- ============================================================
INSERT INTO style_colorways (company_id, style_id, color_name, pantone, fabric, trim_color, status) VALUES
(1,1,'White','PMS 11-0601','100% Cotton Jersey','White','approved'),
(1,1,'Black','PMS 19-4007','100% Cotton Jersey','Black','approved'),
(1,1,'Navy','PMS 19-4024','100% Cotton Jersey','Navy','approved'),
(1,1,'Heather Grey','PMS 14-4102','Cotton/Poly Blend','Grey','pending'),
(1,2,'Khaki','PMS 15-1214','98% Cotton 2% Elastane','Khaki','approved'),
(1,2,'Charcoal','PMS 19-3906','98% Cotton 2% Elastane','Charcoal','approved'),
(1,2,'Olive','PMS 18-0527','98% Cotton 2% Elastane','Olive','approved'),
(1,3,'Charcoal','PMS 19-3906','Wool/Poly Blend','Black','approved'),
(1,3,'Navy','PMS 19-4024','Wool/Poly Blend','Navy','approved'),
(1,3,'Slate Grey','PMS 17-4014','Wool/Poly Blend','Grey','pending'),
(1,4,'Camel','PMS 15-1225','100% Cashmere','Camel','approved'),
(1,4,'Black','PMS 19-4007','100% Cashmere','Black','approved'),
(1,4,'Burgundy','PMS 19-1535','100% Cashmere','Burgundy','approved'),
(1,5,'Black','PMS 19-4007','Dri-FIT Polyester','Black','approved'),
(1,5,'Blue','PMS 19-4052','Dri-FIT Polyester','Blue','approved'),
(1,5,'Red','PMS 18-1763','Dri-FIT Polyester','Red','approved'),
(1,6,'Black','PMS 19-4007','Fleece Cotton/Poly','Black','approved'),
(1,6,'Grey','PMS 14-4102','Fleece Cotton/Poly','Grey','approved'),
(1,6,'Red','PMS 18-1763','Fleece Cotton/Poly','Red','pending'),
(1,7,'Black','PMS 19-4007','Spandex/Polyester','Black','approved'),
(1,7,'Navy','PMS 19-4024','Spandex/Polyester','Navy','approved'),
(1,8,'Black','PMS 19-4007','HeatTech Synthetic','Black','approved'),
(1,8,'White','PMS 11-0601','HeatTech Synthetic','White','approved'),
(1,9,'Indigo','PMS 19-3939','12oz Denim','Copper','approved'),
(1,9,'Black Denim','PMS 19-4007','12oz Denim','Gunmetal','approved'),
(1,9,'Washed Blue','PMS 17-4028','10oz Denim','Antique Brass','approved');

-- ============================================================
-- 4. STYLE_BOM — Bill of Materials
-- ============================================================
INSERT INTO style_bom (company_id, style_id, bom_type, item_name, supplier, gsm, width, consumption, consumption_uom, rate, currency_code, wastage_pct, notes, sequence) VALUES
-- T-Shirt (1)
(1,1,'fabric','100% Combed Cotton Jersey 180gsm','FabricMart',180.00,160.00,1.2000,'Kg',4.50,'USD',5.00,'Main body fabric',1),
(1,1,'trim','Rib Neck Collar 1x1','TrimCo',220.00,NULL,0.1500,'Kg',8.00,'USD',3.00,'Match body color',2),
(1,1,'trim','Shoulder Tape 15mm','TrimCo',NULL,NULL,0.0500,'Kg',2.50,'USD',2.00,'Cotton twill tape',3),
(1,1,'accessory','Woven Label 30x50mm','LabelPro',NULL,NULL,1.0000,'Pcs',0.12,'USD',0.00,'Main brand label',4),
(1,1,'accessory','Care Label SAT-001','LabelPro',NULL,NULL,1.0000,'Pcs',0.08,'USD',0.00,'Care instructions',5),
(1,1,'packaging','Polybag 30x40cm','PackAll',NULL,NULL,1.0000,'Pcs',0.03,'USD',0.00,'Individual packing',6),
(1,1,'packaging','Carton Box 60x40x40cm','PackAll',NULL,NULL,0.0625,'Pcs',0.85,'USD',0.00,'16 pcs per carton',7),
-- Chino Pants (2)
(1,2,'fabric','Cotton Twill 98/2 Elastane 230gsm','TextilePro',230.00,150.00,1.3500,'Kg',5.80,'USD',7.00,'Main body fabric',1),
(1,2,'trim','YKK Zipper #5 18cm','YKK',NULL,NULL,1.0000,'Pcs',0.45,'USD',0.00,'Front fly',2),
(1,2,'trim','Belt Loop Webbing 40mm','TrimCo',NULL,NULL,0.0200,'Kg',3.20,'USD',5.00,'7 belt loops per pant',3),
(1,2,'accessory','Metal Shank Button 17mm','ButtonCraft',NULL,NULL,1.0000,'Pcs',0.15,'USD',0.00,'Waistband closure',4),
(1,2,'accessory','Woven Main Label','LabelPro',NULL,NULL,1.0000,'Pcs',0.14,'USD',0.00,'Brand label',5),
(1,2,'accessory','Size Label','LabelPro',NULL,NULL,1.0000,'Pcs',0.05,'USD',0.00,'Size tag',6),
(1,2,'packaging','Tissue Paper','PackAll',NULL,NULL,1.0000,'Pcs',0.06,'USD',0.00,'Individual fold',7),
(1,2,'packaging','Polybag 35x50cm','PackAll',NULL,NULL,1.0000,'Pcs',0.04,'USD',0.00,'Outer bag',8),
-- Blazer (3)
(1,3,'fabric','Wool/Poly Blend 280gsm','LuxTextiles',280.00,150.00,1.8000,'Kg',12.50,'USD',10.00,'Shell fabric',1),
(1,3,'fabric','Polyester Lining 110gsm','LuxTextiles',110.00,140.00,0.9000,'Kg',3.20,'USD',5.00,'Full lining',2),
(1,3,'trim','Shoulder Pad Set','AccessoryHub',NULL,NULL,1.0000,'Set',1.80,'USD',0.00,'Semi-rigid',3),
(1,3,'trim','Fusible Interlining','InterlineCo',NULL,NULL,0.4000,'Kg',6.50,'USD',3.00,'Front panels + collar',4),
(1,3,'accessory','Horn Buttons 20mm','ButtonCraft',NULL,NULL,8.0000,'Pcs',0.35,'USD',0.00,'Front + cuffs',5),
(1,3,'accessory','Inner Pocket Woven Label','LabelPro',NULL,NULL,1.0000,'Pcs',0.18,'USD',0.00,'Brand badge',6),
(1,3,'accessory','Hanging Loop Ribbon','TrimCo',NULL,NULL,0.1000,'Kg',4.00,'USD',0.00,'Neck loop',7),
(1,3,'packaging','Suit Cover Non-Woven','PackAll',NULL,NULL,1.0000,'Pcs',0.65,'USD',0.00,'Individual cover',8),
-- Sweater (4)
(1,4,'fabric','100% Cashmere 12gg Knit','CashMill',NULL,NULL,0.4500,'Kg',38.00,'USD',8.00,'12-gauge knit',1),
(1,4,'trim','Rib Trim 2x2 1x1','KnitTrims',NULL,NULL,0.0800,'Kg',15.00,'USD',3.00,'Cuffs and hem',2),
(1,4,'accessory','Woven Main Label 30x60mm','LabelPro',NULL,NULL,1.0000,'Pcs',0.22,'USD',0.00,'Brand label',3),
(1,4,'accessory','Care Label SAT-002','LabelPro',NULL,NULL,1.0000,'Pcs',0.10,'USD',0.00,'Hand wash only',4),
(1,4,'packaging','Tissue Paper','PackAll',NULL,NULL,2.0000,'Pcs',0.08,'USD',0.00,'Double fold',5),
(1,4,'packaging','Rigid Gift Box','PackAll',NULL,NULL,1.0000,'Pcs',1.20,'USD',0.00,'Premium packaging',6),
-- Running Shorts (5)
(1,5,'fabric','Dri-FIT Polyester 130gsm','NikeFab',130.00,150.00,0.4500,'Kg',3.80,'USD',5.00,'Moisture wicking',1),
(1,5,'fabric','Mesh Lining 80gsm','NikeFab',80.00,150.00,0.2500,'Kg',2.50,'USD',3.00,'Inner brief',2),
(1,5,'trim','Elastic Waistband 35mm','ElasticCo',NULL,NULL,0.8500,'M',0.18,'USD',5.00,'Drawcord channel',3),
(1,5,'trim','Drawcord 5mm','TrimCo',NULL,NULL,1.0000,'M',0.06,'USD',0.00,'Adjustable waist',4),
(1,5,'accessory','Reflective Heat Transfer','PrintTech',NULL,NULL,1.0000,'Pcs',0.25,'USD',0.00,'Logo placement',5),
(1,5,'accessory','Woven Label 25x40mm','LabelPro',NULL,NULL,1.0000,'Pcs',0.10,'USD',0.00,'Brand tag',6),
(1,5,'packaging','Polybag 25x35cm','PackAll',NULL,NULL,1.0000,'Pcs',0.02,'USD',0.00,'Individual packing',7),
-- Hoodie (6)
(1,6,'fabric','Cotton/Poly Fleece 320gsm','FleeceMill',320.00,160.00,1.6000,'Kg',5.50,'USD',7.00,'Brushed fleece',1),
(1,6,'trim','Kangaroo Pocket Rib','KnitTrims',NULL,NULL,0.1200,'Kg',6.00,'USD',3.00,'Pocket opening trim',2),
(1,6,'trim','Hood Drawcord 6mm','TrimCo',NULL,NULL,1.2000,'M',0.08,'USD',0.00,'Flat cord',3),
(1,6,'accessory','Metal Eyelets 5mm', 'AccessoryHub',NULL,NULL,2.0000,'Pcs',0.04,'USD',0.00,'Hood drawcord holes',4),
(1,6,'accessory','Woven Main Label','LabelPro',NULL,NULL,1.0000,'Pcs',0.14,'USD',0.00,'Brand label',5),
(1,6,'accessory','Size Label','LabelPro',NULL,NULL,1.0000,'Pcs',0.05,'USD',0.00,'Size tag',6),
(1,6,'packaging','Polybag 40x55cm','PackAll',NULL,NULL,1.0000,'Pcs',0.05,'USD',0.00,'Individual packing',7),
(1,6,'packaging','Carton Box 60x40x40cm','PackAll',NULL,NULL,0.0625,'Pcs',0.85,'USD',0.00,'12 pcs per carton',8),
-- Running Tights (7)
(1,7,'fabric','Spandex/Polyester 200gsm','PerformanceKnit',200.00,150.00,0.5500,'Kg',6.20,'USD',5.00,'4-way stretch',1),
(1,7,'trim','Elastic Waistband 30mm','ElasticCo',NULL,NULL,0.8000,'M',0.22,'USD',5.00,'Wide comfort band',2),
(1,7,'accessory','Flatlock Stitch Reinforcement','ThreadCo',NULL,NULL,1.0000,'Pcs',0.15,'USD',0.00,'Seam durability',3),
(1,7,'accessory','Reflective Print','PrintTech',NULL,NULL,1.0000,'Pcs',0.30,'USD',0.00,'Low-light visibility',4),
(1,7,'accessory','Woven Label','LabelPro',NULL,NULL,1.0000,'Pcs',0.10,'USD',0.00,'Brand tag',5),
(1,7,'packaging','Polybag 25x40cm','PackAll',NULL,NULL,1.0000,'Pcs',0.03,'USD',0.00,'Individual packing',6),
-- Base Layer (8)
(1,8,'fabric','HeatTech Synthetic 140gsm','UltraWarm',140.00,160.00,0.4000,'Kg',4.80,'USD',4.00,'Heat retention fabric',1),
(1,8,'trim','Flat Lock Seam Thread','ThreadCo',NULL,NULL,0.0200,'Kg',12.00,'USD',2.00,'Seamless comfort',2),
(1,8,'accessory','Heat Seal Label','PrintTech',NULL,NULL,1.0000,'Pcs',0.08,'USD',0.00,'No-tag comfort',3),
(1,8,'accessory','Woven Size Label','LabelPro',NULL,NULL,1.0000,'Pcs',0.05,'USD',0.00,'Size indicator',4),
(1,8,'packaging','Polybag 20x30cm','PackAll',NULL,NULL,1.0000,'Pcs',0.02,'USD',0.00,'Compact packing',5),
-- Denim Jacket (9)
(1,9,'fabric','12oz Raw Denim','DenimWorks',NULL,NULL,1.8000,'Kg',7.50,'USD',8.00,'Ring spun indigo',1),
(1,9,'fabric','Cotton/Poly Lining 90gsm','FabricMart',90.00,140.00,0.6000,'Kg',2.80,'USD',5.00,'Body lining',2),
(1,9,'trim','YKK Brass Zipper #8','YKK',NULL,NULL,1.0000,'Pcs',1.20,'USD',0.00,'Front closure',3),
(1,9,'trim','Copper Rivets','AccessoryHub',NULL,NULL,12.0000,'Pcs',0.06,'USD',0.00,'Stress points',4),
(1,9,'accessory','Woven Main Label','LabelPro',NULL,NULL,1.0000,'Pcs',0.14,'USD',0.00,'Brand label',5),
(1,9,'accessory','Leather Patch 50x70mm','AccessoryHub',NULL,NULL,1.0000,'Pcs',0.45,'USD',0.00,'Back neck patch',6),
(1,9,'accessory','Shank Button 17mm','ButtonCraft',NULL,NULL,4.0000,'Pcs',0.18,'USD',0.00,'Cuff buttons',7),
(1,9,'packaging','Butcher Paper Wrap','PackAll',NULL,NULL,1.0000,'Pcs',0.12,'USD',0.00,'Individual wrap',8),
(1,9,'packaging','Carton Box 60x40x40cm','PackAll',NULL,NULL,0.05,'Pcs',0.85,'USD',0.00,'10 pcs per carton',9);

-- ============================================================
-- 5. STYLE_CONSUMPTION — Fabric consumption details
-- ============================================================
INSERT INTO style_consumption (company_id, style_id, marker_efficiency, fabric_width, gsm, fabric_shrinkage, wastage_pct, relaxation_pct, net_consumption, final_consumption, consumption_uom, notes) VALUES
(1,1, 85.00,160.00,180.00,3.00,5.00,1.00,1.1500,1.2075,'Kg','T-shirt marker'),
(1,2, 82.00,150.00,230.00,2.00,7.00,0.50,1.2800,1.3696,'Kg','Chino trouser marker'),
(1,3, 78.00,150.00,280.00,2.00,10.00,1.00,1.6200,1.7820,'Kg','Blazer marker — complex layout'),
(1,4, NULL, NULL, NULL, 0.00,8.00,2.00,0.4200,0.4536,'Kg','Knit consumption — no marker needed'),
(1,5, 88.00,150.00,130.00,1.50,5.00,0.50,0.4200,0.4410,'Kg','Shorts marker'),
(1,6, 80.00,160.00,320.00,3.00,7.00,1.50,1.4800,1.5984,'Kg','Hoodie marker — includes hood'),
(1,7, 90.00,150.00,200.00,1.00,5.00,0.50,0.5100,0.5355,'Kg','Tights marker — tubular'),
(1,8, NULL, NULL, NULL, 0.00,4.00,1.00,0.3800,0.3952,'Kg','Seamless knit — flat consumption'),
(1,9, 78.00,150.00, NULL, 3.00,8.00,1.50,1.6500,1.7820,'Kg','Denim jacket marker — complex');

-- ============================================================
-- 6. STYLE_OPERATIONS — Manufacturing operations
-- ============================================================
INSERT INTO style_operations (company_id, style_id, operation_name, machine_type, smv, sam, operation_type, difficulty, sequence, notes) VALUES
-- T-Shirt (1)
(1,1,'Front Panel Cut','Straight Knife',0.80,0.80,'cutting','easy',1,'Single jersey fabric'),
(1,1,'Back Panel Cut','Straight Knife',0.70,0.70,'cutting','easy',2,NULL),
(1,1,'Sleeve Cut','Straight Knife',0.50,0.50,'cutting','easy',3,NULL),
(1,1,'Shoulder Seam','Overlock 5-thread',0.45,0.45,'sewing','easy',4,NULL),
(1,1,'Neck Collar Attach','Coverstitch',0.60,0.60,'sewing','medium',5,'Rib collar binding'),
(1,1,'Sleeve Set-in','Overlock 5-thread',0.75,0.75,'sewing','medium',6,NULL),
(1,1,'Side Seam','Overlock 5-thread',0.55,0.55,'sewing','easy',7,NULL),
(1,1,'Hem Bottom','Coverstitch',0.40,0.40,'sewing','easy',8,NULL),
(1,1,'Sleeve Hem','Coverstitch',0.35,0.35,'sewing','easy',9,NULL),
(1,1,'Label Attach','Single Needle',0.20,0.20,'sewing','easy',10,NULL),
(1,1,'Trim & Thread Cut','Manual',0.30,0.30,'finishing','easy',11,NULL),
(1,1,'Quality Check','Manual',0.40,0.40,'quality','medium',12,'100% inline check'),
(1,1,'Fold & Polybag','Manual',0.25,0.25,'packing','easy',13,NULL),
-- Chino Pants (2)
(1,2,'Front Panel Cut','Straight Knife',1.20,1.20,'cutting','medium',1,'Twill fabric — multiple pieces'),
(1,2,'Back Panel Cut','Straight Knife',1.00,1.00,'cutting','medium',2,NULL),
(1,2,'Pocket Bag Cut','Straight Knife',0.40,0.40,'cutting','easy',3,'Pocketing fabric'),
(1,2,'Front Dart & Pleat','Single Needle',0.60,0.60,'sewing','medium',4,NULL),
(1,2,'Back Welt Pocket','Single Needle',1.20,1.20,'sewing','hard',5,'Double welt pocket'),
(1,2,'Front Pocket Attach','Single Needle',0.80,0.80,'sewing','medium',6,NULL),
(1,2,'Fly Zipper Attach','Single Needle',0.90,0.90,'sewing','medium',7,NULL),
(1,2,'Inseam','Overlock 5-thread',0.65,0.65,'sewing','easy',8,NULL),
(1,2,'Outseam','Overlock 5-thread',0.65,0.65,'sewing','easy',9,NULL),
(1,2,'Waistband Attach','Lockstitch',0.85,0.85,'sewing','medium',10,NULL),
(1,2,'Belt Loop Attach','Bartack',0.50,0.50,'sewing','medium',11,'7 loops'),
(1,2,'Hem','Coverstitch',0.35,0.35,'sewing','easy',12,NULL),
(1,2,'Buttonhole & Button','Buttonhole M/C',0.40,0.40,'sewing','medium',13,NULL),
(1,2,'Quality Check','Manual',0.50,0.50,'quality','medium',14,NULL),
(1,2,'Press & Fold','Steam Press',0.45,0.45,'finishing','medium',15,NULL),
(1,2,'Polybag & Tag','Manual',0.30,0.30,'packing','easy',16,NULL),
-- Blazer (3)
(1,3,'Front Panel Cut','Straight Knife',1.50,1.50,'cutting','hard',1,'Complex pattern pieces'),
(1,3,'Back Panel Cut','Straight Knife',1.00,1.00,'cutting','medium',2,NULL),
(1,3,'Lining Cut','Straight Knife',0.80,0.80,'cutting','medium',3,NULL),
(1,3,'Fusing Press','Fusing Machine',1.20,1.20,'finishing','medium',4,'Front + collar interlining'),
(1,3,'Dart & Princess Seam','Single Needle',1.40,1.40,'sewing','hard',5,NULL),
(1,3,'Back Vent','Single Needle',0.80,0.80,'sewing','medium',6,NULL),
(1,3,'Collar Make','Single Needle',1.80,1.80,'sewing','hard',7,'Notch collar construction'),
(1,3,'Lining Attach','Single Needle',2.00,2.00,'sewing','hard',8,'Full lining'),
(1,3,'Sleeve Set-in','Overlock',1.20,1.20,'sewing','hard',9,NULL),
(1,3,'Buttonhole','Buttonhole M/C',0.60,0.60,'sewing','medium',10,'5 buttonholes'),
(1,3,'Button Attach','Manual',0.50,0.50,'sewing','medium',11,'5 buttons'),
(1,3,'Shoulder Pad Attach','Manual',0.40,0.40,'sewing','medium',12,NULL),
(1,3,'Press & Shape','Steam Press',1.00,1.00,'finishing','hard',13,'Critical finishing'),
(1,3,'Quality Check','Manual',0.80,0.80,'quality','hard',14,'Detailed QC'),
(1,3,'Hang & Cover','Manual',0.35,0.35,'packing','easy',15,NULL),
-- Sweater (4)
(1,4,'Front Panel Knit','Flat Knit M/C',8.00,8.00,'cutting','medium',1,'12-gauge flat knit'),
(1,4,'Back Panel Knit','Flat Knit M/C',8.00,8.00,'cutting','medium',2,NULL),
(1,4,'Sleeve Knit','Flat Knit M/C',5.00,5.00,'cutting','easy',3,NULL),
(1,4,'Linking — Shoulder','Linking M/C',1.50,1.50,'sewing','hard',4,'Wholegarment linking'),
(1,4,'Linking — Sleeve','Linking M/C',1.20,1.20,'sewing','medium',5,NULL),
(1,4,'Collar Rib Attach','Linking M/C',0.80,0.80,'sewing','medium',6,NULL),
(1,4,'Hem Rib Attach','Linking M/C',0.70,0.70,'sewing','medium',7,NULL),
(1,4,'Cuff Rib Attach','Linking M/C',0.50,0.50,'sewing','easy',8,NULL),
(1,4,'Label Sew','Single Needle',0.20,0.20,'sewing','easy',9,NULL),
(1,4,'Wash & Block','Wash M/C',0.00,0.00,'finishing','medium',10,'Cashmere wash'),
(1,4,'Quality Check','Manual',0.50,0.50,'quality','medium',11,NULL),
(1,4,'Fold & Box','Manual',0.40,0.40,'packing','easy',12,'Premium box packing'),
-- Running Shorts (5)
(1,5,'Main Panel Cut','Straight Knife',0.60,0.60,'cutting','easy',1,'Light fabric'),
(1,5,'Lining Cut','Straight Knife',0.30,0.30,'cutting','easy',2,NULL),
(1,5,'Side Seam','Overlock',0.40,0.40,'sewing','easy',3,NULL),
(1,5,'Inseam','Overlock',0.35,0.35,'sewing','easy',4,NULL),
(1,5,'Waistband Channel','Lockstitch',0.50,0.50,'sewing','medium',5,'Drawcord channel'),
(1,5,'Drawcord Thread','Manual',0.15,0.15,'sewing','easy',6,NULL),
(1,5,'Lining Attach','Overlock',0.30,0.30,'sewing','easy',7,NULL),
(1,5,'Reflective Transfer','Heat Press',0.20,0.20,'finishing','easy',8,NULL),
(1,5,'Hem','Coverstitch',0.25,0.25,'sewing','easy',9,NULL),
(1,5,'Label Attach','Single Needle',0.15,0.15,'sewing','easy',10,NULL),
(1,5,'Quality Check','Manual',0.30,0.30,'quality','medium',11,NULL),
(1,5,'Fold & Polybag','Manual',0.20,0.20,'packing','easy',12,NULL),
-- Hoodie (6)
(1,6,'Front Panel Cut','Straight Knife',1.10,1.10,'cutting','medium',1,'Fleece fabric'),
(1,6,'Back Panel Cut','Straight Knife',0.90,0.90,'cutting','medium',2,NULL),
(1,6,'Hood Cut','Straight Knife',0.40,0.40,'cutting','easy',3,NULL),
(1,6,'Pocket Cut','Straight Knife',0.35,0.35,'cutting','easy',4,NULL),
(1,6,'Sleeve Cut','Straight Knife',0.50,0.50,'cutting','easy',5,NULL),
(1,6,'Kangaroo Pocket Sew','Single Needle',0.80,0.80,'sewing','medium',6,NULL),
(1,6,'Hood Construct','Overlock',0.70,0.70,'sewing','medium',7,NULL),
(1,6,'Shoulder Seam','Overlock',0.50,0.50,'sewing','easy',8,NULL),
(1,6,'Hood Attach','Overlock',0.65,0.65,'sewing','medium',9,NULL),
(1,6,'Sleeve Set-in','Overlock',0.80,0.80,'sewing','medium',10,NULL),
(1,6,'Side Seam + Pocket','Overlock',0.70,0.70,'sewing','medium',11,NULL),
(1,6,'Waistband Rib','Coverstitch',0.45,0.45,'sewing','medium',12,NULL),
(1,6,'Cuff Rib','Coverstitch',0.35,0.35,'sewing','easy',13,NULL),
(1,6,'Drawcord Thread + Eyelet','Manual',0.30,0.30,'sewing','medium',14,NULL),
(1,6,'Label Attach','Single Needle',0.20,0.20,'sewing','easy',15,NULL),
(1,6,'Quality Check','Manual',0.45,0.45,'quality','medium',16,NULL),
(1,6,'Fold & Polybag','Manual',0.30,0.30,'packing','easy',17,NULL),
-- Running Tights (7)
(1,7,'Main Panel Cut','Straight Knife',0.70,0.70,'cutting','easy',1,'Stretch fabric'),
(1,7,'Gusset Cut','Straight Knife',0.20,0.20,'cutting','easy',2,NULL),
(1,7,'Inseam Flatlock','Flatlock M/C',0.60,0.60,'sewing','medium',3,'Flatlock seam'),
(1,7,'Outseam Flatlock','Flatlock M/C',0.60,0.60,'sewing','medium',4,NULL),
(1,7,'Gusset Attach','Flatlock M/C',0.35,0.35,'sewing','medium',5,NULL),
(1,7,'Waistband Attach','Coverstitch',0.50,0.50,'sewing','medium',6,NULL),
(1,7,'Reflective Print','Heat Press',0.25,0.25,'finishing','easy',7,NULL),
(1,7,'Label Attach','Single Needle',0.15,0.15,'sewing','easy',8,NULL),
(1,7,'Quality Check','Manual',0.35,0.35,'quality','medium',9,NULL),
(1,7,'Fold & Polybag','Manual',0.20,0.20,'packing','easy',10,NULL),
-- Base Layer (8)
(1,8,'Tubular Knit','Circular Knit M/C',3.00,3.00,'cutting','medium',1,'Seamless body'),
(1,8,'Sleeve Cut','Straight Knife',0.30,0.30,'cutting','easy',2,NULL),
(1,8,'Shoulder Seam','Flatlock M/C',0.30,0.30,'sewing','easy',3,'Flatlock — no chafe'),
(1,8,'Sleeve Set-in','Flatlock M/C',0.35,0.35,'sewing','easy',4,NULL),
(1,8,'Neck Bind','Coverstitch',0.25,0.25,'sewing','easy',5,NULL),
(1,8,'Hem','Coverstitch',0.20,0.20,'sewing','easy',6,NULL),
(1,8,'Heat Seal Label','Heat Press',0.10,0.10,'finishing','easy',7,NULL),
(1,8,'Quality Check','Manual',0.25,0.25,'quality','medium',8,NULL),
(1,8,'Fold & Polybag','Manual',0.15,0.15,'packing','easy',9,NULL),
-- Denim Jacket (9)
(1,9,'Front Panel Cut','Straight Knife',1.40,1.40,'cutting','hard',1,'Heavy denim'),
(1,9,'Back Panel Cut','Straight Knife',1.00,1.00,'cutting','medium',2,NULL),
(1,9,'Sleeve Cut','Straight Knife',0.60,0.60,'cutting','medium',3,NULL),
(1,9,'Pocket Bag Cut','Straight Knife',0.30,0.30,'cutting','easy',4,NULL),
(1,9,'Collar & Band Cut','Straight Knife',0.40,0.40,'cutting','medium',5,NULL),
(1,9,'Front Chest Pocket','Single Needle',0.90,0.90,'sewing','medium',6,'Welt pocket'),
(1,9,'Front Bottom Pockets','Single Needle',1.20,1.20,'sewing','medium',7,'Flap pockets'),
(1,9,'Back Yoke','Single Needle',0.70,0.70,'sewing','medium',8,NULL),
(1,9,'Collar Attach','Single Needle',1.00,1.00,'sewing','hard',9,'Band collar'),
(1,9,'Front Zipper','Single Needle',0.80,0.80,'sewing','medium',10,NULL),
(1,9,'Sleeve Set-in','Overlock',0.85,0.85,'sewing','medium',11,NULL),
(1,9,'Side Seam','Overlock',0.60,0.60,'sewing','easy',12,NULL),
(1,9,'Cuff Construct','Single Needle',0.70,0.70,'sewing','medium',13,NULL),
(1,9,'Waistband','Lockstitch',0.65,0.65,'sewing','medium',14,NULL),
(1,9,'Rivet Attach','Rivet M/C',0.30,0.30,'sewing','easy',15,'Copper rivets'),
(1,9,'Buttonhole & Button','Buttonhole M/C',0.50,0.50,'sewing','medium',16,NULL),
(1,9,'Distress/Wash','Wash Plant',0.00,0.00,'finishing','hard',17,'Stone wash finish'),
(1,9,'Press','Steam Press',0.80,0.80,'finishing','medium',18,NULL),
(1,9,'Quality Check','Manual',0.60,0.60,'quality','hard',19,'Detailed inspection'),
(1,9,'Hang & Cover','Manual',0.35,0.35,'packing','easy',20,NULL);

-- ============================================================
-- 7. STYLE_COSTING — Costing versions
-- ============================================================
INSERT INTO style_costing (company_id, style_id, version, material_cost, manufacturing_cost, overhead_cost, compliance_cost, packaging_cost, total_cost, margin_pct, fob_price, currency_code, status, notes) VALUES
(1,1,1, 5.40, 1.80, 0.90, 0.30, 0.45, 8.85, 35.00, 12.10,'USD','final','Standard T-shirt costing'),
(1,2,1, 7.65, 2.80, 1.20, 0.40, 0.55, 12.60, 38.00, 17.40,'USD','final','Chino pants v1'),
(1,3,1, 18.50, 6.50, 2.80, 1.20, 1.80, 30.80, 42.00, 42.70,'USD','final','Wool blazer premium'),
(1,4,1, 22.00, 4.50, 1.80, 0.60, 1.50, 30.40, 45.00, 44.08,'USD','final','Cashmere premium'),
(1,5,1, 2.85, 1.20, 0.60, 0.20, 0.30, 5.15, 40.00, 7.21,'USD','final','Running shorts'),
(1,6,1, 8.90, 2.50, 1.10, 0.35, 0.60, 13.45, 38.00, 18.56,'USD','final','Hoodie standard'),
(1,7,1, 5.20, 1.80, 0.80, 0.25, 0.35, 8.40, 42.00, 11.73,'USD','final','Performance tights'),
(1,8,1, 3.60, 1.00, 0.50, 0.15, 0.25, 5.50, 38.00, 7.59,'USD','final','HeatTech base layer'),
(1,9,1, 11.50, 4.20, 2.00, 0.80, 1.20, 19.70, 40.00, 27.36,'USD','final','Denim jacket v1'),
(1,1,2, 5.10, 1.75, 0.85, 0.30, 0.42, 8.42, 36.00, 11.38,'USD','draft','Optimized material sourcing'),
(1,9,2, 10.80, 4.00, 1.90, 0.80, 1.15, 18.65, 42.00, 25.16,'USD','draft','Alternative wash process');

-- ============================================================
-- 8. STYLE_COST_COMPONENTS — Cost breakdown line items
-- ============================================================
INSERT INTO style_cost_components (company_id, style_id, costing_id, category, item_name, cost, notes) VALUES
-- T-Shirt (costing_id=1)
(1,1,1,'material','Cotton Jersey Fabric',3.20,'1.2kg × $4.50/kg'),
(1,1,1,'material','Rib Collar',0.50,'0.15kg × $8.00/kg'),
(1,1,1,'material','Shoulder Tape',0.10,'0.05kg × $2.50/kg'),
(1,1,1,'material','Labels & Tags',0.20,'Main + care labels'),
(1,1,1,'manufacturing','Cutting',0.45,'2.0 SMV'),
(1,1,1,'manufacturing','Sewing',1.05,'4.65 SMV'),
(1,1,1,'manufacturing','Finishing',0.30,'Trim + press'),
(1,1,1,'overhead','Factory Overhead',0.90,'15% of manufacturing'),
(1,1,1,'compliance','Quality Testing',0.30,'AQL inspection'),
(1,1,1,'packaging','Polybag + Carton',0.45,'Per piece packing'),
-- Chino (costing_id=2)
(1,2,2,'material','Cotton Twill Fabric',5.80,'1.35kg × $5.80/kg'),
(1,2,2,'material','Zipper + Button',0.60,'YKK + metal button'),
(1,2,2,'material','Belt Loop + Labels',0.45,'Webbing + labels'),
(1,2,2,'material','Pocketing Fabric',0.80,'Poly-cotton pocketing'),
(1,2,2,'manufacturing','Cutting',0.60,'4.5 SMV'),
(1,2,2,'manufacturing','Sewing',1.80,'10.5 SMV'),
(1,2,2,'manufacturing','Press & Finish',0.40,'Steam press'),
(1,2,2,'overhead','Factory Overhead',1.20,'15% overhead'),
(1,2,2,'compliance','Quality Testing',0.40,'AQL inspection'),
(1,2,2,'packaging','Tissue + Polybag',0.55,'Premium fold'),
-- Blazer (costing_id=3)
(1,3,3,'material','Wool Blend Shell',12.50,'1.8kg × $12.50/kg'),
(1,3,3,'material','Polyester Lining',2.88,'0.9kg × $3.20/kg'),
(1,3,3,'material','Interlining + Pads',2.60,'Fusible + shoulder pads'),
(1,3,3,'material','Buttons + Labels',0.52,'Horn buttons + labels'),
(1,3,3,'manufacturing','Cutting',0.80,'Complex layout'),
(1,3,3,'manufacturing','Sewing',4.50,'20 SMV'),
(1,3,3,'manufacturing','Press & Shape',1.20,'Critical pressing'),
(1,3,3,'overhead','Factory Overhead',2.80,'15% overhead'),
(1,3,3,'compliance','Quality Testing',1.20,'Premium QC'),
(1,3,3,'packaging','Suit Cover + Hanger',1.80,'Non-woven cover'),
-- Sweater (costing_id=4)
(1,4,4,'material','Cashmere Yarn',20.00,'0.45kg × $38/kg'),
(1,4,4,'material','Rib Trim',1.20,'Cuffs + hem'),
(1,4,4,'material','Labels',0.32,'Brand + care labels'),
(1,4,4,'manufacturing','Knitting',2.50,'Flat knit M/C'),
(1,4,4,'manufacturing','Linking',1.50,'Hand linking'),
(1,4,4,'manufacturing','Wash & Block',0.50,'Cashmere wash'),
(1,4,4,'overhead','Factory Overhead',1.80,'15% overhead'),
(1,4,4,'compliance','Quality Testing',0.60,'Quality check'),
(1,4,4,'packaging','Gift Box + Tissue',1.50,'Premium retail box'),
-- Running Shorts (costing_id=5)
(1,5,5,'material','Dri-FIT Fabric',1.71,'0.45kg × $3.80/kg'),
(1,5,5,'material','Mesh Lining',0.63,'0.25kg × $2.50/kg'),
(1,5,5,'material','Elastic + Drawcord',0.20,'Waistband materials'),
(1,5,5,'material','Labels + Transfer',0.35,'Reflective + labels'),
(1,5,5,'manufacturing','Cutting',0.25,'1.8 SMV'),
(1,5,5,'manufacturing','Sewing',0.75,'4.5 SMV'),
(1,5,5,'manufacturing','Heat Press',0.20,'Reflective transfer'),
(1,5,5,'overhead','Factory Overhead',0.60,'15% overhead'),
(1,5,5,'compliance','Quality Testing',0.20,'Standard QC'),
(1,5,5,'packaging','Polybag',0.30,'Individual bag'),
-- Hoodie (costing_id=6)
(1,6,6,'material','Fleece Fabric',8.80,'1.6kg × $5.50/kg'),
(1,6,6,'material','Rib Trim + Drawcord',0.72,'Pocket + drawcord'),
(1,6,6,'material','Eyelets + Labels',0.23,'Metal eyelets + labels'),
(1,6,6,'manufacturing','Cutting',0.55,'4.25 SMV'),
(1,6,6,'manufacturing','Sewing',1.55,'10.15 SMV'),
(1,6,6,'manufacturing','Thread + Eyelet',0.40,'Drawcord assembly'),
(1,6,6,'overhead','Factory Overhead',1.10,'15% overhead'),
(1,6,6,'compliance','Quality Testing',0.35,'Standard QC'),
(1,6,6,'packaging','Polybag + Carton',0.60,'Per piece packing'),
-- Running Tights (costing_id=7)
(1,7,7,'material','Spandex/Poly Fabric',3.41,'0.55kg × $6.20/kg'),
(1,7,7,'material','Elastic Waistband',0.18,'0.8m × $0.22/m'),
(1,7,7,'material','Reflective Print + Label',0.40,'Print + brand label'),
(1,7,7,'manufacturing','Cutting',0.30,'2.4 SMV'),
(1,7,7,'manufacturing','Sewing (Flatlock)',1.15,'7.5 SMV'),
(1,7,7,'manufacturing','Heat Press',0.25,'Reflective'),
(1,7,7,'overhead','Factory Overhead',0.80,'15% overhead'),
(1,7,7,'compliance','Quality Testing',0.25,'Standard QC'),
(1,7,7,'packaging','Polybag',0.35,'Individual bag'),
-- Base Layer (costing_id=8)
(1,8,8,'material','HeatTech Fabric',1.92,'0.4kg × $4.80/kg'),
(1,8,8,'material','Thread + Label',0.13,'Flatlock thread + label'),
(1,8,8,'manufacturing','Knitting',0.50,'Circular knit M/C'),
(1,8,8,'manufacturing','Sewing',0.35,'3.2 SMV'),
(1,8,8,'manufacturing','Heat Seal Label',0.15,'No-tag application'),
(1,8,8,'overhead','Factory Overhead',0.50,'15% overhead'),
(1,8,8,'compliance','Quality Testing',0.15,'Standard QC'),
(1,8,8,'packaging','Polybag',0.25,'Compact bag'),
-- Denim Jacket (costing_id=9)
(1,9,9,'material','Raw Denim',13.50,'1.8kg × $7.50/kg'),
(1,9,9,'material','Lining Fabric',1.68,'0.6kg × $2.80/kg'),
(1,9,9,'material','Zipper + Rivets + Buttons',1.50,'YKK zip + copper rivets'),
(1,9,9,'material','Labels + Leather Patch',0.59,'Brand label + patch'),
(1,9,9,'manufacturing','Cutting',0.70,'5.2 SMV'),
(1,9,9,'manufacturing','Sewing',2.80,'16 SMV'),
(1,9,9,'manufacturing','Wash & Finish',0.70,'Stone wash'),
(1,9,9,'overhead','Factory Overhead',2.00,'15% overhead'),
(1,9,9,'compliance','Quality Testing',0.80,'Detailed QC'),
(1,9,9,'packaging','Butcher Wrap + Carton',1.20,'Premium wrap');

-- ============================================================
-- 9. STYLE_PACKAGING — Packaging materials
-- ============================================================
INSERT INTO style_packaging (company_id, style_id, item_name, quantity, rate, uom, notes) VALUES
(1,1,'Individual Polybag 30×40cm',1.0000,0.03,'Pcs','LDPE polybag'),
(1,1,'Carton Box 60×40×40cm',0.0625,0.85,'Pcs','16 pcs/carton'),
(1,1,'Carton Tape 48mm',0.5000,0.05,'M','Sealing tape'),
(1,1,'Size Sticker',1.0000,0.01,'Pcs','Barcode + size'),
(1,2,'Tissue Paper',1.0000,0.06,'Pcs','Individual fold wrap'),
(1,2,'Polybag 35×50cm',1.0000,0.04,'Pcs','LDPE polybag'),
(1,2,'Carton Box 60×40×40cm',0.0625,0.85,'Pcs','16 pcs/carton'),
(1,2,'Hang Tag',1.0000,0.08,'Pcs','Brand hang tag'),
(1,2,'Price Sticker',1.0000,0.02,'Pcs','UPC barcode'),
(1,3,'Suit Cover Non-Woven',1.0000,0.65,'Pcs','Breathable cover'),
(1,3,'Hanger — Heavy Duty',1.0000,0.35,'Pcs','40mm shoulder'),
(1,3,'Carton Box 70×50×30cm',0.1000,1.20,'Pcs','10 pcs/carton'),
(1,3,'Tissue Paper',2.0000,0.08,'Pcs','Double fold'),
(1,4,'Rigid Gift Box 35×25×8cm',1.0000,1.20,'Pcs','Premium box'),
(1,4,'Tissue Paper',2.0000,0.08,'Pcs','Double layer'),
(1,4,'Satin Ribbon',0.3000,0.15,'M','Box tie'),
(1,4,'Care Card',1.0000,0.05,'Pcs','Cashmere care guide'),
(1,5,'Polybag 25×35cm',1.0000,0.02,'Pcs','LDPE polybag'),
(1,5,'Carton Box 60×40×40cm',0.0833,0.85,'Pcs','12 pcs/carton'),
(1,5,'Size Sticker',1.0000,0.01,'Pcs','Barcode + size'),
(1,6,'Polybag 40×55cm',1.0000,0.05,'Pcs','LDPE polybag'),
(1,6,'Carton Box 60×40×40cm',0.0833,0.85,'Pcs','12 pcs/carton'),
(1,6,'Hang Tag',1.0000,0.08,'Pcs','Brand hang tag'),
(1,6,'Size Sticker',1.0000,0.01,'Pcs','Barcode + size'),
(1,7,'Polybag 25×40cm',1.0000,0.03,'Pcs','LDPE polybag'),
(1,7,'Carton Box 60×40×40cm',0.0625,0.85,'Pcs','16 pcs/carton'),
(1,8,'Polybag 20×30cm',1.0000,0.02,'Pcs','Compact bag'),
(1,8,'Carton Box 50×40×30cm',0.1000,0.70,'Pcs','10 pcs/carton'),
(1,9,'Butcher Paper Wrap',1.0000,0.12,'Pcs','Individual wrap'),
(1,9,'Carton Box 60×40×40cm',0.1000,0.85,'Pcs','10 pcs/carton'),
(1,9,'Hang Tag + Price Tag',1.0000,0.10,'Pcs','Leather-look tag'),
(1,9,'Carton Tape 48mm',0.5000,0.05,'M','Sealing tape');

-- ============================================================
-- 10. STYLE_COMPLIANCE — Testing & compliance
-- ============================================================
INSERT INTO style_compliance (company_id, style_id, category, item_name, cost, required, status, notes) VALUES
(1,1,'testing','Shrinkage Test',25.00,1,'completed','AATCC 135'),
(1,1,'testing','Color Fastness Wash',30.00,1,'completed','ISO 105-C06'),
(1,1,'testing','Pilling Resistance',20.00,1,'in_progress','ISO 12945-2'),
(1,1,'audit','Factory Social Audit',500.00,1,'completed','SEDEX member'),
(1,2,'testing','Shrinkage Test',25.00,1,'completed','AATCC 135'),
(1,2,'testing','Color Fastness Wash',30.00,1,'completed','ISO 105-C06'),
(1,2,'testing','Seam Strength',15.00,1,'completed','ASTM D1683'),
(1,2,'audit','Factory Social Audit',500.00,1,'completed','SEDEX'),
(1,2,'sustainability','OEKO-TEX Standard 100',200.00,1,'in_progress','Class II'),
(1,3,'testing','Color Fastness Dry Cleaning',35.00,1,'completed','ISO 105-D01'),
(1,3,'testing','Pilling Resistance',20.00,1,'completed','ISO 12945-2'),
(1,3,'testing','Shrinkage Test',25.00,1,'completed','AATCC 135'),
(1,3,'audit','Factory Social Audit',500.00,1,'completed','BSCI'),
(1,3,'certification','Woolmark Blend',350.00,1,'in_progress','Woolmark license'),
(1,4,'testing','Cashmere Content Test',45.00,1,'completed','ISO 1833'),
(1,4,'testing','Pilling Resistance',20.00,1,'completed','ISO 12945-2'),
(1,4,'testing','Color Fastness',30.00,1,'in_progress','ISO 105'),
(1,4,'audit','Factory Social Audit',500.00,1,'completed','SEDEX'),
(1,4,'sustainability','Cashmere Traceability',150.00,1,'in_progress','Origin tracking'),
(1,5,'testing','Moisture Wicking Test',25.00,1,'completed','AATCC 195'),
(1,5,'testing','Color Fastness Wash',30.00,1,'completed','ISO 105-C06'),
(1,5,'audit','Factory Social Audit',500.00,1,'completed','SEDEX'),
(1,5,'sustainability','bluesign System',250.00,1,'in_progress','Chemical safety'),
(1,6,'testing','Shrinkage Test',25.00,1,'completed','AATCC 135'),
(1,6,'testing','Color Fastness Wash',30.00,1,'completed','ISO 105-C06'),
(1,6,'testing','Pilling Resistance',20.00,1,'pending','ISO 12945-2'),
(1,6,'audit','Factory Social Audit',500.00,1,'completed','SEDEX'),
(1,7,'testing','Elasticity Recovery',20.00,1,'completed','ASTM D3107'),
(1,7,'testing','Color Fastness Wash',30.00,1,'completed','ISO 105-C06'),
(1,7,'testing','UV Protection Factor',35.00,1,'in_progress','AS/NZS 4399'),
(1,7,'audit','Factory Social Audit',500.00,1,'completed','SEDEX'),
(1,8,'testing','Thermal Resistance',40.00,1,'completed','ISO 11092'),
(1,8,'testing','Color Fastness Wash',30.00,1,'completed','ISO 105-C06'),
(1,8,'audit','Factory Social Audit',500.00,1,'completed','BSCI'),
(1,9,'testing','Shrinkage Test',25.00,1,'completed','AATCC 135'),
(1,9,'testing','Color Fastness Wash',30.00,1,'completed','ISO 105-C06'),
(1,9,'testing','Abrasion Resistance',25.00,1,'completed','ISO 12947'),
(1,9,'testing','Seam Strength',15.00,1,'completed','ASTM D1683'),
(1,9,'audit','Factory Social Audit',500.00,1,'completed','SEDEX'),
(1,9,'sustainability','Organic Cotton Content',120.00,1,'in_progress','GOTS certification');

-- ============================================================
-- 11. STYLE_DOCUMENTS — Attached documents
-- ============================================================
INSERT INTO style_documents (company_id, style_id, doc_type, doc_name, file_path) VALUES
(1,1,'tech_pack','T-Shirt Tech Pack v1.0','/docs/styles/1/tech_pack_v1.pdf'),
(1,1,'spec_sheet','T-Shirt Spec Sheet','/docs/styles/1/spec_sheet.pdf'),
(1,1,'image','Front Flat Sketch','/docs/styles/1/flat_front.png'),
(1,1,'image','Back Flat Sketch','/docs/styles/1/flat_back.png'),
(1,2,'tech_pack','Chino Tech Pack v1.0','/docs/styles/2/tech_pack_v1.pdf'),
(1,2,'spec_sheet','Chino Spec Sheet','/docs/styles/2/spec_sheet.pdf'),
(1,2,'image','Front Flat Sketch','/docs/styles/2/flat_front.png'),
(1,2,'3d_model','3D Rendering','/docs/styles/2/3d_model.obj'),
(1,3,'tech_pack','Blazer Tech Pack v1.0','/docs/styles/3/tech_pack_v1.pdf'),
(1,3,'spec_sheet','Blazer Spec Sheet','/docs/styles/3/spec_sheet.pdf'),
(1,3,'image','Front Flat Sketch','/docs/styles/3/flat_front.png'),
(1,3,'image','Back Flat Sketch','/docs/styles/3/flat_back.png'),
(1,3,'image','Detail Close-up','/docs/styles/3/detail_collar.png'),
(1,4,'tech_pack','Sweater Tech Pack v1.0','/docs/styles/4/tech_pack_v1.pdf'),
(1,4,'spec_sheet','Sweater Spec Sheet','/docs/styles/4/spec_sheet.pdf'),
(1,5,'tech_pack','Shorts Tech Pack v1.0','/docs/styles/5/tech_pack_v1.pdf'),
(1,5,'spec_sheet','Shorts Spec Sheet','/docs/styles/5/spec_sheet.pdf'),
(1,5,'image','Front Flat Sketch','/docs/styles/5/flat_front.png'),
(1,6,'tech_pack','Hoodie Tech Pack v1.0','/docs/styles/6/tech_pack_v1.pdf'),
(1,6,'spec_sheet','Hoodie Spec Sheet','/docs/styles/6/spec_sheet.pdf'),
(1,6,'image','Front Flat Sketch','/docs/styles/6/flat_front.png'),
(1,6,'image','Back Flat Sketch','/docs/styles/6/flat_back.png'),
(1,7,'tech_pack','Tights Tech Pack v1.0','/docs/styles/7/tech_pack_v1.pdf'),
(1,7,'spec_sheet','Tights Spec Sheet','/docs/styles/7/spec_sheet.pdf'),
(1,8,'tech_pack','Base Layer Tech Pack v1.0','/docs/styles/8/tech_pack_v1.pdf'),
(1,8,'spec_sheet','Base Layer Spec Sheet','/docs/styles/8/spec_sheet.pdf'),
(1,9,'tech_pack','Denim Jacket Tech Pack v1.0','/docs/styles/9/tech_pack_v1.pdf'),
(1,9,'spec_sheet','Denim Jacket Spec Sheet','/docs/styles/9/spec_sheet.pdf'),
(1,9,'image','Front Flat Sketch','/docs/styles/9/flat_front.png'),
(1,9,'image','Back Flat Sketch','/docs/styles/9/flat_back.png'),
(1,9,'image','Wash Detail','/docs/styles/9/wash_detail.png');

-- ============================================================
-- 12. STYLE_AI_ANALYSIS — AI-generated insights
-- ============================================================
INSERT INTO style_ai_analysis (company_id, style_id, analysis_type, summary, recommendation, potential_saving, risk_level, confidence) VALUES
(1,1,'cost_optimization','Fabric cost is 36% of total. Bulk sourcing from Vietnam could reduce by 8%.','Negotiate volume discount with FabricMart or consider alternative supplier in Bangladesh.',0.43,'low',85.00),
(1,1,'supplier_alternative','Current trim supplier charges premium. Similar quality available from local sources.','Trial local trim supplier for shoulder tape — potential 20% savings.',0.08,'low',78.00),
(1,2,'cost_optimization','Elastane component adds 15% to fabric cost. Consider 98/2 blend vs current.','Review if 2% elastane is required — could use 100% cotton for relaxed fit.',1.15,'medium',72.00),
(1,3,'risk_assessment','Wool blend supply chain has seasonal volatility. Q4 prices may spike 12-18%.','Lock in wool pricing for next 6 months via forward contract.',NULL,'high',90.00),
(1,3,'cost_optimization','Shoulder pad + interlining cost is 11% of material cost. Alternative construction possible.','Consider fused shoulder construction to eliminate separate pad cost.',0.65,'medium',68.00),
(1,4,'cost_optimization','Cashmere cost is dominant at 73% of material cost. Fiber grade selection opportunity.','Grade down from A to A/B cashmere — 15% savings with minimal visual impact.',3.30,'medium',75.00),
(1,4,'profitability','Current margin at 45% is strong. Market supports premium positioning.','Maintain premium pricing. Consider limited edition marketing.',NULL,'low',88.00),
(1,5,'consumption','Shorts consumption is efficient at 0.45kg. Marker efficiency could improve 3% with nesting.','Use automated marker nesting software for better fabric utilization.',0.12,'low',82.00),
(1,6,'cost_optimization','Fleece fabric accounts for 66% of material cost. Blend ratio adjustment possible.','Consider 80/20 cotton/poly instead of current 60/40 — same handfeel, lower cost.',0.89,'low',76.00),
(1,7,'risk_assessment','Spandex supply from China faces tariff uncertainty. 10-15% cost risk.','Diversify spandex sourcing to India or Taiwan suppliers.',NULL,'medium',80.00),
(1,8,'cost_optimization','HeatTech synthetic fabric is proprietary. Generic equivalent available at 12% less.','Evaluate Korean synthetic alternative — similar thermal performance.',0.43,'medium',70.00),
(1,9,'cost_optimization','Stone wash process adds $0.70/unit. Enzyme wash alternative is cheaper and eco-friendlier.','Switch to enzyme wash — 40% process cost reduction, better sustainability profile.',0.28,'low',85.00),
(1,9,'supplier_alternative','Denim sourcing limited to 2 domestic mills. Consider Turkey or Pakistan origins.','Qualify Turkish denim mill for 10% cost advantage on 12oz raw.',1.15,'medium',74.00);

-- ============================================================
-- 13. STYLE_APPROVALS — Approval workflow
-- ============================================================
INSERT INTO style_approvals (company_id, style_id, approval_level, role_name, status, remarks, acted_at) VALUES
(1,1,1,'Merchandiser','approved','Costing confirmed. Ready for sampling.','2025-01-15 10:30:00'),
(1,1,2,'Design Manager','approved','Design and colorways approved.','2025-01-16 14:00:00'),
(1,1,3,'Production Manager','approved','SMV confirmed. Line allocation ready.','2025-01-17 09:15:00'),
(1,1,4,'Quality Manager','approved','AQL standards confirmed.','2025-01-17 11:00:00'),
(1,1,5,'Commercial Manager','approved','FOB price approved at $12.10.','2025-01-18 10:00:00'),
(1,2,1,'Merchandiser','approved','Costing finalized.','2025-02-01 09:00:00'),
(1,2,2,'Design Manager','approved','Colorways confirmed.','2025-02-02 11:30:00'),
(1,2,3,'Production Manager','approved','Line ready.','2025-02-03 08:45:00'),
(1,2,4,'Quality Manager','pending','Awaiting AQL spec confirmation.',NULL),
(1,2,5,'Commercial Manager','pending','FOB under review.',NULL),
(1,3,1,'Merchandiser','approved','Premium costing approved.','2025-01-20 10:00:00'),
(1,3,2,'Design Manager','approved','Design finalized.','2025-01-21 15:00:00'),
(1,3,3,'Production Manager','approved','Complex construction confirmed.','2025-01-22 09:00:00'),
(1,3,4,'Quality Manager','pending','Awaiting testing results.',NULL),
(1,3,5,'Commercial Manager','pending','FOB under negotiation.',NULL),
(1,4,1,'Merchandiser','approved','Cashmere costing approved.','2025-02-10 10:00:00'),
(1,4,2,'Design Manager','approved','Colorways approved.','2025-02-11 14:30:00'),
(1,4,3,'Production Manager','approved','Knit schedule confirmed.','2025-02-12 09:00:00'),
(1,4,4,'Quality Manager','pending','Pilling test pending.',NULL),
(1,4,5,'Commercial Manager','approved','Premium pricing confirmed at $44.08.','2025-02-13 11:00:00'),
(1,5,1,'Merchandiser','approved','Cost approved.','2025-03-01 09:00:00'),
(1,5,2,'Design Manager','approved','All colorways confirmed.','2025-03-02 10:00:00'),
(1,5,3,'Production Manager','approved','Standard line allocation.','2025-03-02 14:00:00'),
(1,5,4,'Quality Manager','approved','AQL confirmed.','2025-03-03 09:00:00'),
(1,5,5,'Commercial Manager','approved','FOB approved.','2025-03-03 11:00:00'),
(1,6,1,'Merchandiser','approved','Standard hoodie costing.','2025-03-10 09:00:00'),
(1,6,2,'Design Manager','approved','Designs confirmed.','2025-03-11 10:00:00'),
(1,6,3,'Production Manager','pending','Line allocation pending.',NULL),
(1,6,4,'Quality Manager','pending','Awaiting spec.',NULL),
(1,6,5,'Commercial Manager','pending','FOB review.',NULL),
(1,7,1,'Merchandiser','approved','Performance costing approved.','2025-03-15 09:00:00'),
(1,7,2,'Design Manager','approved','Colorways finalized.','2025-03-16 11:00:00'),
(1,7,3,'Production Manager','approved','Specialized line confirmed.','2025-03-17 08:00:00'),
(1,7,4,'Quality Manager','pending','UV test pending.',NULL),
(1,7,5,'Commercial Manager','approved','FOB approved.','2025-03-18 10:00:00'),
(1,8,1,'Merchandiser','approved','HeatTech costing confirmed.','2025-04-01 09:00:00'),
(1,8,2,'Design Manager','approved','Minimal design approved.','2025-04-02 10:00:00'),
(1,8,3,'Production Manager','approved','Circular knit line allocated.','2025-04-03 08:00:00'),
(1,8,4,'Quality Manager','pending','Thermal test pending.',NULL),
(1,8,5,'Commercial Manager','approved','FOB at $7.59.','2025-04-03 14:00:00'),
(1,9,1,'Merchandiser','approved','Denim jacket costing approved.','2025-04-10 09:00:00'),
(1,9,2,'Design Manager','approved','Wash samples approved.','2025-04-11 15:00:00'),
(1,9,3,'Production Manager','approved','Wash plant scheduled.','2025-04-12 08:00:00'),
(1,9,4,'Quality Manager','pending','Abrasion test pending.',NULL),
(1,9,5,'Commercial Manager','pending','FOB under review.',NULL);

-- ============================================================
-- 14. STYLE_VERSIONS — Version history
-- ============================================================
INSERT INTO style_versions (company_id, style_id, version_label, change_description, changed_by) VALUES
(1,1,'V1.0','Initial development — basic cotton t-shirt',1),
(1,1,'V1.1','Adjusted sleeve length +1cm per buyer feedback',1),
(1,1,'V2.0','Updated fabric from 160gsm to 180gsm for better handfeel',1),
(1,2,'V1.0','Initial development — slim fit chino',1),
(1,2,'V1.1','Added 2% elastane for comfort stretch',1),
(1,3,'V1.0','Initial development — wool blend blazer',1),
(1,3,'V1.1','Changed from 2-button to 3-button front',1),
(1,3,'V1.2','Updated shoulder pad from thin to semi-rigid',1),
(1,4,'V1.0','Initial development — cashmere sweater',1),
(1,4,'V1.1','Changed from 7-gauge to 12-gauge knit for finer handfeel',1),
(1,5,'V1.0','Initial development — running shorts',1),
(1,5,'V1.1','Added reflective transfer for low-light running',1),
(1,6,'V1.0','Initial development — lifestyle hoodie',1),
(1,6,'V1.1','Added kangaroo pocket construction',1),
(1,7,'V1.0','Initial development — running tights',1),
(1,8,'V1.0','Initial development — heat tech base layer',1),
(1,9,'V1.0','Initial development — denim jacket',1),
(1,9,'V1.1','Changed zipper from plastic to YKK brass #8',1),
(1,9,'V1.2','Updated wash from acid wash to stone wash',1);

-- ============================================================
-- 15. STYLE_SIZES — Size definitions with body measurements
-- ============================================================
INSERT INTO style_sizes (company_id, style_id, size_label, size_code, chest, waist, hip, length, sleeve, shoulder, sku_suffix, sequence, status) VALUES
-- T-Shirt (1)
(1,1,'S','S',96.00,76.00,96.00,68.00,20.00,40.00,'-S',1,'active'),
(1,1,'M','M',104.00,84.00,104.00,70.00,21.00,42.00,'-M',2,'active'),
(1,1,'L','L',112.00,92.00,112.00,72.00,22.00,44.00,'-L',3,'active'),
(1,1,'XL','XL',120.00,100.00,120.00,74.00,23.00,46.00,'-XL',4,'active'),
(1,1,'XXL','XXL',128.00,108.00,128.00,76.00,24.00,48.00,'-XXL',5,'active'),
-- Chino (2)
(1,2,'30','30',NULL,76.00,96.00,104.00,NULL,NULL,'-30',1,'active'),
(1,2,'32','32',NULL,81.00,101.00,106.00,NULL,NULL,'-32',2,'active'),
(1,2,'34','34',NULL,86.00,106.00,108.00,NULL,NULL,'-34',3,'active'),
(1,2,'36','36',NULL,91.00,111.00,110.00,NULL,NULL,'-36',4,'active'),
-- Blazer (3)
(1,3,'S','S',96.00,88.00,NULL,68.00,63.00,42.00,'-S',1,'active'),
(1,3,'M','M',102.00,94.00,NULL,70.00,64.50,44.00,'-M',2,'active'),
(1,3,'L','L',108.00,100.00,NULL,72.00,66.00,46.00,'-L',3,'active'),
(1,3,'XL','XL',114.00,106.00,NULL,74.00,67.50,48.00,'-XL',4,'active'),
-- Sweater (4)
(1,4,'S','S',96.00,76.00,NULL,66.00,58.00,40.00,'-S',1,'active'),
(1,4,'M','M',102.00,82.00,NULL,68.00,60.00,42.00,'-M',2,'active'),
(1,4,'L','L',108.00,88.00,NULL,70.00,62.00,44.00,'-L',3,'active'),
(1,4,'XL','XL',114.00,94.00,NULL,72.00,64.00,46.00,'-XL',4,'active'),
-- Running Shorts (5)
(1,5,'S','S',NULL,72.00,92.00,42.00,NULL,NULL,'-S',1,'active'),
(1,5,'M','M',NULL,78.00,98.00,44.00,NULL,NULL,'-M',2,'active'),
(1,5,'L','L',NULL,84.00,104.00,46.00,NULL,NULL,'-L',3,'active'),
(1,5,'XL','XL',NULL,90.00,110.00,48.00,NULL,NULL,'-XL',4,'active'),
-- Hoodie (6)
(1,6,'S','S',96.00,76.00,NULL,66.00,60.00,40.00,'-S',1,'active'),
(1,6,'M','M',104.00,84.00,NULL,68.00,62.00,42.00,'-M',2,'active'),
(1,6,'L','L',112.00,92.00,NULL,70.00,64.00,44.00,'-L',3,'active'),
(1,6,'XL','XL',120.00,100.00,NULL,72.00,66.00,46.00,'-XL',4,'active'),
(1,6,'XXL','XXL',128.00,108.00,NULL,74.00,68.00,48.00,'-XXL',5,'active'),
-- Running Tights (7)
(1,7,'S','S',NULL,72.00,92.00,72.00,NULL,NULL,'-S',1,'active'),
(1,7,'M','M',NULL,78.00,98.00,74.00,NULL,NULL,'-M',2,'active'),
(1,7,'L','L',NULL,84.00,104.00,76.00,NULL,NULL,'-L',3,'active'),
(1,7,'XL','XL',NULL,90.00,110.00,78.00,NULL,NULL,'-XL',4,'active'),
-- Base Layer (8)
(1,8,'S','S',96.00,76.00,NULL,64.00,58.00,40.00,'-S',1,'active'),
(1,8,'M','M',102.00,82.00,NULL,66.00,60.00,42.00,'-M',2,'active'),
(1,8,'L','L',108.00,88.00,NULL,68.00,62.00,44.00,'-L',3,'active'),
(1,8,'XL','XL',114.00,94.00,NULL,70.00,64.00,46.00,'-XL',4,'active'),
-- Denim Jacket (9)
(1,9,'S','S',96.00,88.00,NULL,64.00,60.00,42.00,'-S',1,'active'),
(1,9,'M','M',102.00,94.00,NULL,66.00,62.00,44.00,'-M',2,'active'),
(1,9,'L','L',108.00,100.00,NULL,68.00,64.00,46.00,'-L',3,'active'),
(1,9,'XL','XL',114.00,106.00,NULL,70.00,66.00,48.00,'-XL',4,'active');

-- ============================================================
-- 16. STYLE_TECH_PACK — Tech pack construction details
-- ============================================================
INSERT INTO style_tech_pack (company_id, style_id, construction_details, stitch_type, stitch_density, sewing_instructions, print_placement, embroidery_details, wash_instructions, care_instructions, trim_details, packing_instructions) VALUES
(1,1,
'Classic crew neck t-shirt. Set-in sleeve. 1x1 rib collar. Coverstitch hem and sleeve hem.',
'Safety stitch 5-thread overlock + Coverstitch', '12-14 SPI',
'Stitch shoulder seam first. Attach rib collar using 4-needle coverstitch. Set sleeves. Close side seams. Hem bottom and sleeve openings.',
'Front left chest — 10cm from HPS, centered. Back — full sublimation available.',
NULL,
'No special wash required. Standard tumble dry low.',
'100% cotton — machine wash cold with like colors. Do not bleach. Tumble dry low. Iron on medium heat.',
'Rib collar: 1x1 rib, 220gsm, color-match to body. Shoulder tape: cotton twill 15mm.',
'Individual polybag. Size sticker on bag. 16 pcs per carton. Carton label with PO number.'),
(1,2,
'Slim fit chino pants. Front fly zipper. 2 front slant pockets, 2 back welt pockets. Belt loops. Single pleat option.',
'Safety stitch 5-thread + Lockstitch', '11-13 SPI',
'Sew front darts/pleats. Construct back welt pockets. Attach pocket bags. Install YKK fly zipper. Join inseam and outseam. Attach waistband. Sew belt loops. Hem.',
NULL, NULL,
'Cold wash, hang dry recommended.',
'98% cotton, 2% elastane — machine wash cold. Do not bleach. Hang to dry. Iron on medium.',
'YKK #5 zipper 18cm. Metal shank button 17mm. Belt loop webbing 40mm.',
'Fold with tissue paper. Hang tag attached. Individual polybag.'),
(1,3,
'Two-button notch collar blazer. Full polyester lining. Single back vent. 2 front flap pockets, 1 inner pocket. Shoulder pads.',
'Lockstitch + Overlock', '10-12 SPI',
'Fuse front panels and collar. Sew darts and princess seams. Construct back vent. Make notch collar. Attach lining. Set sleeves. Make buttonholes. Attach buttons. Add shoulder pads.',
NULL, NULL,
'Professional dry clean only.',
'Dry clean only. Store on hanger. Do not press directly on fabric.',
'Horn buttons 20mm × 5. Semi-rigid shoulder pads. Fusible interlining on front + collar.',
'Suit cover on hanger. Tissue paper fold. Individual cover per piece.'),
(1,4,
'12-gauge fully fashioned cashmere crew neck sweater. Rib trim at collar, cuffs, and hem. Linked construction.',
'Linking stitch', '12 GG knit',
'Knit front, back, and sleeves on flat knit machine. Link shoulder seams. Link sleeves to body. Attach rib collar, cuffs, and hem rib.',
NULL, NULL,
'Hand wash cold. Do not wring. Lay flat to dry.',
'100% cashmere — hand wash in cold water with cashmere shampoo. Do not bleach. Lay flat to dry. Store folded with cedar.',
'Cashmere yarn 12gg. Rib trim 2×2.',
'Tissue paper double fold. Ribbon tie. Rigid gift box with care card.'),
(1,5,
'Split-leg running shorts. Elastic waistband with drawcord. Inner mesh brief lining. Reflective heat transfer logo.',
'Overlock + Coverstitch', '12-14 SPI',
'Cut and attach mesh lining to main body. Sew side seams and inseam. Create waistband channel. Thread drawcord. Apply reflective transfer. Hem.',
'Left leg — reflective logo, 5cm above hem.',
NULL,
'Cold wash, tumble dry low.',
'100% polyester Dri-FIT — machine wash cold. Do not iron directly on reflective transfer.',
'Elastic waistband 35mm. Drawcord 5mm flat. Reflective heat transfer.',
'Individual polybag. Size sticker.'),
(1,6,
'Pullover hoodie with kangaroo pocket. Brushed fleece interior. 2-piece hood with drawcord. Rib cuffs and waistband.',
'Safety stitch 5-thread + Coverstitch', '10-12 SPI',
'Sew kangaroo pocket. Construct 2-piece hood. Join shoulder seams. Attach hood. Set sleeves. Close side seams through pocket. Attach rib waistband and cuffs. Thread drawcord through hood. Set eyelets.',
NULL, NULL,
'Cold wash, tumble dry medium.',
'60% cotton, 40% polyester — machine wash cold with like colors. Do not bleach. Tumble dry medium. Iron on low.',
'6mm flat drawcord. Metal eyelets 5mm × 2. Rib trim 2×2 for cuffs and waistband.',
'Individual polybag. Hang tag attached.'),
(1,7,
'4-way stretch running tights. High-rise waistband. Flatlock seams for comfort. Reflective details for visibility.',
'Flatlock + Coverstitch', '12-14 SPI',
'Sew gusset. Join inseam with flatlock. Join outseam with flatlock. Attach wide waistband. Apply reflective print. Heat seal label.',
'Left calf — reflective stripe. Right hip — reflective logo.',
NULL,
'Cold wash. Do not use fabric softener.',
'88% polyester, 12% spandex — machine wash cold. Do not bleach. Do not use fabric softener. Hang to dry.',
'Elastic waistband 30mm wide comfort. Flatlock thread.',
'Individual polybag.'),
(1,8,
'Long-sleeve base layer. Tubular body construction (no side seams). Flatlock shoulder and sleeve seams. Heat seal label.',
'Flatlock + Coverstitch', '14-16 SPI',
'Knit tubular body on circular machine. Cut and attach sleeves with flatlock. Bind neck. Hem bottom. Apply heat seal label.',
NULL, NULL,
'Cold wash. Do not iron on label.',
'Synthetic HeatTech blend — machine wash cold. Do not bleach. Do not iron on heat seal label.',
'Flatlock seam thread for seamless comfort. Heat seal label (no physical tag).',
'Compact fold. Individual polybag.'),
(1,9,
'Classic denim jacket. Button front with YKK brass zipper. 2 chest welt pockets, 2 front flap pockets. Back yoke. Band collar. Copper rivets at stress points.',
'Lockstitch + Overlock + Bartack', '8-10 SPI',
'Sew front chest welt pockets. Construct front flap pockets. Join back yoke. Attach band collar. Install YKK #8 zipper. Set sleeves. Close side seams. Construct cuffs. Attach waistband. Set copper rivets. Make buttonholes.',
'Back yoke — embroidered logo available. Left chest pocket — leather patch.',
'Leather patch 50×70mm on back neck.',
'Stone wash. Enzyme wash alternative available.',
'100% cotton denim — machine wash cold inside out. Do not bleach. Hang to dry. Iron on high.',
'YKK #8 brass zipper. Copper rivets × 12. Shank button 17mm × 4. Leather patch.',
'Butcher paper individual wrap. Hang tag + price tag. 10 pcs per carton.');

-- ============================================================
-- 17. STYLE_PURCHASE — Purchase/procurement tracking
-- ============================================================
INSERT INTO style_purchase (company_id, style_id, item_name, item_type, supplier, required_qty, required_uom, warehouse_qty, reserved_qty, purchase_qty, lead_time_days, unit_cost, currency_code, po_status, notes) VALUES
(1,1,'Cotton Jersey 180gsm','fabric','FabricMart',5000.00,'Kg',2000.00,1500.00,5000.00,14,4.50,'USD','partial_received','PO #FM-2025-001'),
(1,1,'Rib Collar 220gsm','trim','TrimCo',600.00,'Kg',300.00,200.00,600.00,10,8.00,'USD','ordered','PO #TC-2025-012'),
(1,1,'Shoulder Tape 15mm','trim','TrimCo',200.00,'Kg',150.00,50.00,200.00,10,2.50,'USD','received','PO #TC-2025-013'),
(1,1,'Woven Labels','accessory','LabelPro',25000.00,'Pcs',12000.00,8000.00,25000.00,7,0.12,'USD','received','PO #LP-2025-045'),
(1,2,'Cotton Twill 230gsm','fabric','TextilePro',4500.00,'Kg',1200.00,800.00,4500.00,21,5.80,'USD','partial_received','PO #TP-2025-008'),
(1,2,'YKK Zipper #5 18cm','trim','YKK',20000.00,'Pcs',10000.00,5000.00,20000.00,14,0.45,'USD','ordered','PO #YKK-2025-033'),
(1,2,'Metal Button 17mm','accessory','ButtonCraft',20000.00,'Pcs',8000.00,4000.00,20000.00,10,0.15,'USD','partial_received','PO #BC-2025-022'),
(1,3,'Wool Blend 280gsm','fabric','LuxTextiles',3000.00,'Kg',500.00,300.00,3000.00,30,12.50,'USD','ordered','PO #LT-2025-005'),
(1,3,'Polyester Lining 110gsm','fabric','LuxTextiles',1500.00,'Kg',200.00,100.00,1500.00,28,3.20,'USD','ordered','PO #LT-2025-006'),
(1,3,'Horn Buttons 20mm','accessory','ButtonCraft',5000.00,'Pcs',1000.00,500.00,5000.00,14,0.35,'USD','partial_received','PO #BC-2025-028'),
(1,4,'Cashmere Yarn 12gg','fabric','CashMill',200.00,'Kg',0.00,0.00,200.00,45,38.00,'USD','ordered','PO #CM-2025-002 — 45-day lead time'),
(1,5,'Dri-FIT Polyester 130gsm','fabric','NikeFab',2500.00,'Kg',1500.00,1000.00,2500.00,10,3.80,'USD','received','PO #NF-2025-015'),
(1,5,'Mesh Lining 80gsm','fabric','NikeFab',1500.00,'Kg',800.00,400.00,1500.00,10,2.50,'USD','received','PO #NF-2025-016'),
(1,6,'Fleece Cotton/Poly 320gsm','fabric','FleeceMill',6000.00,'Kg',1000.00,500.00,6000.00,18,5.50,'USD','partial_received','PO #FM-2025-020'),
(1,6,'Metal Eyelets 5mm','accessory','AccessoryHub',15000.00,'Pcs',8000.00,3000.00,15000.00,7,0.04,'USD','received','PO #AH-2025-044'),
(1,7,'Spandex/Polyester 200gsm','fabric','PerformanceKnit',3000.00,'Kg',1800.00,1200.00,3000.00,14,6.20,'USD','partial_received','PO #PN-2025-010'),
(1,8,'HeatTech Synthetic 140gsm','fabric','UltraWarm',2000.00,'Kg',0.00,0.00,2000.00,21,4.80,'USD','ordered','PO #UW-2025-003'),
(1,9,'Raw Denim 12oz','fabric','DenimWorks',4000.00,'Kg',800.00,400.00,4000.00,21,7.50,'USD','partial_received','PO #DW-2025-007'),
(1,9,'YKK Brass Zipper #8','trim','YKK',8000.00,'Pcs',3000.00,2000.00,8000.00,14,1.20,'USD','ordered','PO #YKK-2025-038'),
(1,9,'Copper Rivets','accessory','AccessoryHub',100000.00,'Pcs',50000.00,20000.00,100000.00,10,0.06,'USD','received','PO #AH-2025-050'),
(1,9,'Leather Patch 50×70mm','accessory','AccessoryHub',8000.00,'Pcs',0.00,0.00,8000.00,14,0.45,'USD','ordered','PO #AH-2025-051');

-- ============================================================
-- 18. STYLE_PRODUCTION — Production planning
-- ============================================================
INSERT INTO style_production (company_id, style_id, total_smv, total_sam, operators, machines, line_efficiency, daily_capacity, estimated_days, planned_qty, actual_output, start_date, end_date, status, notes) VALUES
(1,1, 6.30,6.30, 20,15, 68.00, 1800, 14, 25000, 12500,'2025-02-01','2025-02-14','in_progress','Line A — running 50% complete'),
(1,2, 10.50,10.50, 25,20, 65.00, 1200, 21, 15000, 6000,'2025-02-15','2025-03-07','in_progress','Line B — 40% complete'),
(1,3, 16.00,16.00, 15,12, 62.00, 400, 30, 8000, 2400,'2025-03-01','2025-03-30','in_progress','Line C — premium line, slow pace'),
(1,4, 20.00,20.00, 10,8, 60.00, 200, 25, 3000, 600,'2025-03-15','2025-04-08','in_progress','Knit line — slow but steady'),
(1,5, 4.50,4.50, 18,12, 70.00, 2200, 10, 20000, 18000,'2025-03-10','2025-03-19','in_progress','Line A overflow — 90% complete'),
(1,6, 10.15,10.15, 22,18, 66.00, 1100, 18, 12000, 0,'2025-04-01','2025-04-18','planned','Pending line allocation'),
(1,7, 7.50,7.50, 12,10, 64.00, 800, 12, 5000, 0,'2025-04-10','2025-04-21','planned','Specialized stretch line'),
(1,8, 3.20,3.20, 15,8, 72.00, 2500, 8, 15000, 0,'2025-04-15','2025-04-22','planned','Circular knit — fast output'),
(1,9, 16.00,16.00, 20,15, 63.00, 600, 25, 10000, 2000,'2025-04-01','2025-04-25','in_progress','Including wash process time');

-- ============================================================
-- 19. STYLE_QA — Quality assurance inspections
-- ============================================================
INSERT INTO style_qa (company_id, style_id, stage, aql_level, sample_size, accepted_qty, rejected_qty, major_defects, minor_defects, critical_defects, result, inspector, inspection_date, remarks) VALUES
(1,1,'fabric_inspection',2.5,20,19,1,1,0,0,'pass','Ahmed Khan','2025-01-28','Fabric quality good — 1 roll with shade variation'),
(1,1,'inline',2.5,80,78,2,2,1,0,'pass','Ahmed Khan','2025-02-10','2 garments with open seam — repaired'),
(1,1,'endline',2.5,50,49,1,1,0,0,'pass','Ahmed Khan','2025-02-14','1 garment with stain — rejected'),
(1,2,'fabric_inspection',2.5,20,18,2,1,2,0,'pass','Sarah Lee','2025-02-10','2 rolls with needle damage'),
(1,2,'inline',2.5,80,76,4,3,2,0,'fail','Sarah Lee','2025-02-25','Back welt pocket stitching inconsistent — rework required'),
(1,2,'inline',2.5,80,79,1,1,0,0,'pass','Sarah Lee','2025-02-27','After rework — acceptable'),
(1,3,'fabric_inspection',1.5,32,31,1,1,0,0,'pass','James Wilson','2025-02-20','Wool fabric inspection — 1 moth damage spot'),
(1,3,'inline',1.5,80,77,3,2,2,0,'fail','James Wilson','2025-03-10','Collar notch alignment issue — rework'),
(1,3,'inline',1.5,80,79,1,1,0,0,'pass','James Wilson','2025-03-12','After collar rework — acceptable'),
(1,4,'fabric_inspection',1.0,20,19,1,1,0,0,'pass','James Wilson','2025-03-08','Cashmere quality inspection — 1 knot defect'),
(1,4,'endline',1.0,30,28,2,1,1,0,'pass','James Wilson','2025-04-01','2 garments with slight pilling — within tolerance'),
(1,5,'inline',2.5,80,79,1,1,0,0,'pass','Maria Garcia','2025-03-15','Running shorts — clean production'),
(1,5,'endline',2.5,50,50,0,0,0,0,'pass','Maria Garcia','2025-03-19','Zero defect — excellent'),
(1,6,'fabric_inspection',2.5,20,20,0,0,0,0,'pass','Maria Garcia','2025-03-25','Fleece quality good'),
(1,7,'inline',2.5,50,48,2,2,0,0,'pass','David Brown','2025-04-15','2 flatlock seam issues — repaired'),
(1,8,'inline',2.5,50,49,1,1,0,0,'pass','David Brown','2025-04-18','1 tubular knit defect — acceptable after QC review'),
(1,9,'fabric_inspection',2.0,32,30,2,2,0,0,'pass','Sarah Lee','2025-04-05','Denim — 2 rolls with irregular weave'),
(1,9,'inline',2.0,80,75,5,3,3,0,'fail','Sarah Lee','2025-04-12','Rivet alignment and zipper issues — rework'),
(1,9,'inline',2.0,80,79,1,1,0,0,'pass','Sarah Lee','2025-04-15','After rework — acceptable');

-- ============================================================
-- 20. STYLE_SUSTAINABILITY — Sustainability certifications
-- ============================================================
INSERT INTO style_sustainability (company_id, style_id, certification_name, cert_type, status, certificate_no, issued_by, issued_date, expiry_date, notes) VALUES
(1,1,'OEKO-TEX Standard 100','chemical','certified','SH025 123456','OEKO-TEX Association','2024-06-15','2025-06-14','Class II — safe for direct skin contact'),
(1,1,'GOTS Organic','organic','applied',NULL,NULL,NULL,NULL,'Application pending — cotton sourcing verification'),
(1,2,'OEKO-TEX Standard 100','chemical','certified','SH025 234567','OEKO-TEX Association','2024-08-01','2025-07-31','Class II — safe for direct skin contact'),
(1,2,'bluesign System','chemical','required',NULL,NULL,NULL,NULL,'Required for elastane component verification'),
(1,3,'Woolmark Blend','social','applied',NULL,'The Woolmark Company',NULL,NULL,'License application submitted — audit pending'),
(1,3,'OEKO-TEX Standard 100','chemical','certified','SH025 345678','OEKO-TEX Association','2024-09-15','2025-09-14','Class II'),
(1,4,'Sustainable Cashmere','social','applied',NULL,'Sustainable Fibre Alliance',NULL,NULL,'Origin tracing from Inner Mongolia'),
(1,4,'OEKO-TEX Standard 100','chemical','required',NULL,NULL,NULL,NULL,'Required — cashmere dyestuff verification'),
(1,5,'bluesign System','chemical','certified','BL025 567890','bluesign technologies','2024-07-01','2025-06-30','Full chemical safety system'),
(1,5,'GRS Recycled','recycled','required',NULL,NULL,NULL,NULL,'Evaluate recycled polyester option for V2'),
(1,6,'OEKO-TEX Standard 100','chemical','applied',NULL,NULL,NULL,NULL,'Pending — cotton/poly blend verification'),
(1,7,'OEKO-TEX Standard 100','chemical','certified','SH025 678901','OEKO-TEX Association','2024-10-01','2025-09-30','Class II — performance fabric'),
(1,7,'GRS Recycled','recycled','applied',NULL,NULL,NULL,NULL,'Recycled polyester certification pending'),
(1,8,'OEKO-TEX Standard 100','chemical','certified','SH025 789012','OEKO-TEX Association','2024-11-01','2025-10-31','Synthetic base layer — chemical safety'),
(1,9,'OEKO-TEX Standard 100','chemical','applied',NULL,NULL,NULL,NULL,'Pending — indigo dye verification'),
(1,9,'GOTS Organic','organic','applied',NULL,NULL,NULL,NULL,'Organic cotton denim — GOTS application submitted'),
(1,9,'Clean Denim Program','environmental','certified','CDP-2025-041','Clean Fashion Initiative','2025-01-15','2026-01-14','Reduced water wash process');
