HYTOS

CREATE TABLE IF NOT EXISTS Fittings_2K (

    UID                                    TEXT    NOT NULL,

    Components_UID                         TEXT    NOT NULL,

    [90_Elbow_Standard_Screw]              INTEGER,

    [90_Elbow_Standard_Flange_Weld]        INTEGER,

    [90_Elbow_Long_Radius_All]             INTEGER,

    [90_Elbow_1_Weld]                      INTEGER,

    [90_Elbow_2_Weld]                      INTEGER,

    [90_Elbow_3_Weld]                      INTEGER,

    [90_Elbow_4_Weld]                      INTEGER,

    [90_Elbow_5_Weld]                      INTEGER,

    [45_Elbow_Standard_All]                INTEGER,

    [45_Elbow_Long_Radius_All]             INTEGER,

    [45_Elbow_1_Weld]                      INTEGER,

    [45_Elbow_2_Weld]                      INTEGER,

    [180_Elbow_Standard_Screw]             INTEGER,

    [180_Elbow_Standard_Flange_Weld]       INTEGER,

    [180_Elbow_Long_Radius_All]            INTEGER,

    Tee_Elbow_Standard_Screw               INTEGER,

    Tee_Elbow_Long_Radius_Screw            INTEGER,

    Tee_Elbow_Standard_Flange_Weld         INTEGER,

    Tee_Elbow_Stub_In_Branch               INTEGER,

    Tee_Through_Screw                      INTEGER,

    Tee_Through_Flange_Weld                INTEGER,

    Tee_Through_Stub_In_Branch             INTEGER,

    Gate_Ball_Plug_Valve_Full              INTEGER,

    [Gate_Ball_Plug_Valve_Reduce_Trim_0.9] INTEGER,

    [Gate_Ball_Plug_Valve_Reduce_Trim_0.8] INTEGER,

    Globe_Valve_Standard                   INTEGER,

    Globe_Valve_Angle_YType                INTEGER,

    Diaphragm_Dam_Valve                    INTEGER,

    Butterfly_Valve                        INTEGER,

    Check_Valve_Lift                       INTEGER,

    Check_Valve_Swing                      INTEGER,

    Check_Valve_Tilting                    INTEGER,

    Pipe_Entrance_Normal                   INTEGER,

    Pipe_Entrance_Borda                    INTEGER,

    Pipe_Exit                              INTEGER,

    Resistance_Coefficiency                REAL,

    Calculated_Fitting                     REAL,

    CONSTRAINT PK_Fittings_2K PRIMARY KEY (

        UID

    ),

    CONSTRAINT FK_Components_UID FOREIGN KEY (

        Components_UID

    )

    REFERENCES Components (UID) ON DELETE CASCADE

);

CREATE TABLE IF NOT EXISTS Fittings_CraneK (

    UID                              TEXT    NOT NULL,

    Components_UID                   TEXT    NOT NULL,

    [90_Elbow_Standard_Screw]        INTEGER,

    [90_Elbow_Long_Radius_1]         INTEGER,

    [90_Elbow_Long_Radius_1.5]       INTEGER,

    [90_Elbow_Long_Radius_2]         INTEGER,

    [90_Elbow_Long_Radius_3]         INTEGER,

    [90_Elbow_Long_Radius_4]         INTEGER,

    [90_Elbow_Long_Radius_6]         INTEGER,

    [90_Elbow_Long_Radius_8]         INTEGER,

    [90_Elbow_Long_Radius_10]        INTEGER,

    [90_Elbow_Long_Radius_12]        INTEGER,

    [90_Elbow_Long_Radius_14]        INTEGER,

    [90_Elbow_Long_Radius_16]        INTEGER,

    [90_Elbow_Long_Radius_20]        INTEGER,

    [90_Elbow_1_Weld]                INTEGER,

    [90_Elbow_2_Weld]                INTEGER,

    [90_Elbow_3_Weld]                INTEGER,

    [90_Elbow_6_Weld]                INTEGER,

    [45_Elbow_Standard_Screw]        INTEGER,

    [45_Elbow_1_Weld]                INTEGER,

    [45_Elbow_3_Weld]                INTEGER,

    [180_Elbow_Standard_Screw]       INTEGER,

    [180_Elbow_Long_Radius_1]        INTEGER,

    [180_Elbow_Long_Radius_1.5]      INTEGER,

    [180_Elbow_Long_Radius_2]        INTEGER,

    [180_Elbow_Long_Radius_3]        INTEGER,

    [180_Elbow_Long_Radius_4]        INTEGER,

    [180_Elbow_Long_Radius_6]        INTEGER,

    [180_Elbow_Long_Radius_8]        INTEGER,

    [180_Elbow_Long_Radius_10]       INTEGER,

    [180_Elbow_Long_Radius_12]       INTEGER,

    [180_Elbow_Long_Radius_14]       INTEGER,

    [180_Elbow_Long_Radius_16]       INTEGER,

    [180_Elbow_Long_Radius_20]       INTEGER,

    [180_Elbow_2_Weld]               INTEGER,

    [180_Elbow_3_Weld]               INTEGER,

    [180_Elbow_4_Weld]               INTEGER,

    [180_Elbow_6_Weld]               INTEGER,

    [180_Elbow_12_Weld]              INTEGER,

    Tee_Through                      INTEGER,

    Tee_Elbow                        INTEGER,

    Expander                         INTEGER,

    Reducer                          INTEGER,

    Globe_Valve_Standard             INTEGER,

    Globe_Valve_45_Angle             INTEGER,

    Globe_Valve_90_Angle             INTEGER,

    Plug_Valve_1_Way                 INTEGER,

    Plug_Valve_3_Way_Through         INTEGER,

    Plug_Valve_3_Way_Elbow           INTEGER,

    Foot_Valve_Poppet_Disc           INTEGER,

    Foot_Valve_Hinged_Disc           INTEGER,

    Gate_Valve                       INTEGER,

    Ball_Valve                       INTEGER,

    Butterfly_Valve                  INTEGER,

    Pipe_Enterance_Projecting        INTEGER,

    [Pipe_Enterance_Flush_0.00]      INTEGER,

    [Pipe_Enterance_Flush_0.02]      INTEGER,

    [Pipe_Enterance_Flush_0.04]      INTEGER,

    [Pipe_Enterance_Flush_0.06]      INTEGER,

    [Pipe_Enterance_Flush_0.10]      INTEGER,

    [Pipe_Enterance_Flush_0.15]      INTEGER,

    Pipe_Exit_Projecting             INTEGER,

    Pipe_Exit_Sharp_Edged            INTEGER,

    Pipe_Exit_Rounded                INTEGER,

    Check_Valve_Swing_Vertical       INTEGER,

    Check_Valve_Swing_Angled         INTEGER,

    Check_Valve_Lift_Straight        INTEGER,

    Check_Valve_Lift_Angled          INTEGER,

    [Check_Valve_Tilting_Alpha_5]    INTEGER,

    [Check_Valve_Tilting_Alpha_15]   INTEGER,

    Check_Valve_Globe_Stop           INTEGER,

    Check_Valve_Globe_Stop_45_Angle  INTEGER,

    Check_Valve_Globe_Stop_Inline    INTEGER,

    Check_Valve_Angled_Stop          INTEGER,

    Check_Valve_Angled_Stop_45_Angle INTEGER,

    Check_Valve_Angled_Stop_Inline   INTEGER,

    User_Input                       INTEGER,

    Resistance_Coefficiency          REAL,

    Calculated_Fitting               REAL,

    CONSTRAINT PK_Fittings_CraneK PRIMARY KEY (

        UID

    ),

    CONSTRAINT FK_Components_UID FOREIGN KEY (

        Components_UID

    )

    REFERENCES Components (UID) ON DELETE CASCADE

);

CREATE TABLE IF NOT EXISTS Fittings_EquivalentLength (

    UID                  TEXT    NOT NULL,

    Components_UID       TEXT    NOT NULL,

    Gate_Ball_Plug_Valve INTEGER,

    Globe_Valve          INTEGER,

    Butterfly_Valve      INTEGER,

    Check_Valve          INTEGER,

    [90_Elbow]           INTEGER,

    [45_Elbow]            INTEGER,

    Tee_Branch           INTEGER,

    Tee_Through          INTEGER,

    Milter               INTEGER,

    Milter_Degree        INTEGER,

    Nozzle_In_YN         BOOLEAN,

    Nozzle_Out_YN        BOOLEAN,

    Calculated_Fitting   REAL,

    CONSTRAINT PK_Fittings_EquivalentLength PRIMARY KEY (

        UID

    ),

    CONSTRAINT FK_Components_UID FOREIGN KEY (

        Components_UID

    )

    REFERENCES Components (UID) ON DELETE CASCADE

);

CREATE TABLE IF NOT EXISTS ResistanceCoefficient (

    CONSTRAINT PK_ResistanceCoefficient PRIMARY KEY (

    CONSTRAINT UQ_ResistanceCoefficient UNIQUE (

-- ResistanceCoefficient

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('4c91f058-3591-4420-8688-fa5ecd7ce191', '2-K', '90 Elbow', 'Bend', 'Standard (r/d=1), screwed', 0.401, 'standard_elbow_90.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('7e99bad1-d7f2-475f-a508-764c4d61f6b3', '2-K', '90 Elbow', 'Bend', 'Standard (r/d=1), flanged/welded', 0.251, 'bend_90.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('c51ec980-a46d-4376-8e5b-9268f815b271', '2-K', '90 Elbow', 'Bend', 'Long-radius (r/d=1.5), all', 0.201, 'bend_90.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('f557a485-d5c1-47d8-8ab4-8ec7548d88c7', '2-K', '90 Elbow', 'Miter', '1 weld (90 angle)', 1.151, 'miter.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('900c39d7-9b02-46c3-9b66-39a6be7d5c11', '2-K', '90 Elbow', 'Miter', '2 welds (45 angle)', 0.351, 'miter.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('49bb4634-40b0-4359-bb4d-551e498fd94a', '2-K', '90 Elbow', 'Miter', '3 welds (30 angle)', 0.301, 'miter.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('b542215f-4ff1-4f04-9deb-e09682216ac7', '2-K', '90 Elbow', 'Miter', '4 welds (22.5 angle)', 0.271, 'miter.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('9dd150c1-1299-44f6-8ea7-80fbe67d4086', '2-K', '90 Elbow', 'Miter', '5 welds (18 angle)', 0.251, 'miter.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('0697cb49-6740-488e-913b-62de626c6b44', '2-K', '45 Elbow', 'Bend', 'Standard (r/d=1), all types', 0.201, 'standard_elbow_45.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('abf004aa-c14f-4ef6-ae0c-d57d630da22e', '2-K', '45 Elbow', 'Bend', 'Long-radius (r/d=1.5), all types', 0.151, 'bend_45.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('74e99396-f7be-481f-a819-fd16909b21bb', '2-K', '45 Elbow', 'Miter', '1 weld (45 angle)', 0.251, 'miter.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('4f9838ff-1fcb-4708-8557-eef6ea503f96', '2-K', '45 Elbow', 'Miter', '2 welds (22.5 angle)', 0.151, 'miter.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('b3093b15-4786-41b7-a3f4-18492519d40e', '2-K', '180 Elbow', 'Bend', 'Standard (r/d=1), screwed', 0.601, 'return_bend.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('2db12d7f-623c-4536-a147-2f860cf8220e', '2-K', '180 Elbow', 'Bend', 'Standard (r/d=1), flanged/welded', 0.351, 'bend_180.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('e0d32fa1-054d-412e-8892-1e8bf7eedf4c', '2-K', '180 Elbow', 'Bend', 'Long-radius (r/d=1.5), all types', 0.301, 'bend_180.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('d4ad2ded-737b-4dac-8578-40f145bf5ba0', '2-K', 'Tees', 'Tee as Elbow', 'Standard, screwed', 0.701, '2K_tee_screwed_branch.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('0fa86444-fc56-4af3-b18b-9aacbcce0a51', '2-K', 'Tees', 'Tee as Elbow', 'Long-radius, screwed', 0.401, '2K_tee_screwed_branch.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('cd4e496a-e3fb-4a37-8b9b-47d97a23d7f6', '2-K', 'Tees', 'Tee as Elbow', 'Standard, flanged or welded', 0.801, '2K_tee_flanged_branch.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('a703cfb8-f8ae-40a8-99c3-7f8c9fc076d1', '2-K', 'Tees', 'Tee as Elbow', 'Stub-in-type branch', 1.001, '2K_tee_stub_branch.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('238aa72a-e2ca-4bed-b0d7-899707532156', '2-K', 'Tees', 'Run through', 'Screwed', 0.101, '2K_tee_screwed_run.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('e0a96893-08a5-444d-8d1a-aeda3759740c', '2-K', 'Tees', 'Run through', 'Flanged or welded', 0.501, '2K_tee_flanged_run.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('240e75aa-2eee-4250-84a6-6bd83a1512d7', '2-K', 'Tees', 'Run through', 'Stub-in-type branch', 0.001, '2K_tee_stub_run.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('30454963-584e-458e-8088-23b6752b84d0', '2-K', 'Valves', 'Gate_Ball_Plug', 'Full line size, β = 1.0', 0.101, 'gate_vv.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('2c14e45c-b690-46ab-b956-8f53a64a56a7', '2-K', 'Valves', 'Gate_Ball_Plug', 'Reduced Trim, β = 0.9', 0.151, 'gate_vv_reduced.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('9cf3fef3-7e90-4efd-871c-dba533ba6371', '2-K', 'Valves', 'Gate_Ball_Plug', 'Reduced Trim, β = 0.8', 0.251, 'gate_vv_reduced.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('82323809-74a0-4f6e-b5cf-3701621a2f8c', '2-K', 'Valves', 'Globe', 'Standard', 4.002, 'globe_vv_standard.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('3bdfc787-b9b1-40a4-904b-a1cef0c950e5', '2-K', 'Valves', 'Globe', 'Angle or Y-type', 2.001, 'globe_vv_45.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('ce5e4953-7c6a-41c0-8121-080ea81b643d', '2-K', 'Valves', 'Others', 'Diaphragm, dam type', 2.001, 'diaphragm.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('2f9140ea-f7c2-45ec-9c96-dd3b72a3a813', '2-K', 'Valves', 'Others', 'Butterfly', 0.251, 'butterfly_vv.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('6982c55e-98e4-49ac-81e1-aaf20bf475bb', '2-K', 'Check Valves', 'Lift', 'Lift Check Valve', 10.002, 'lift_check_vv.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('abb9a4b9-02dd-4f3c-bb54-c1f95f2b3979', '2-K', 'Check Valves', 'Swing', 'Swing Check Valve', 1.502, 'swing_check_vv_ver.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('593d94b9-465f-4468-9b5f-0c2b3673eefc', '2-K', 'Check Valves', 'Tilting', 'Tilting-disk Check Valve', 0.501, 'tilting_disc_check_vv.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('a81fd72b-0177-47ed-a48d-308e2cdf4c08', '2-K', 'Pipe', 'Standard', 'Pipe entrance (Normal)', 0.501, 'entrance_flush.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('9c417855-1f2b-42d5-8c0c-b97a373678a9', '2-K', 'Pipe', 'Standard', 'Pipe entrance (Borda)', 1.001, 'entrance_projecting.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('ef4d98cb-8bc6-49ae-8302-b3f1bf855ea9', '2-K', 'Pipe', 'Standard', 'Pipe exit', 1.001, 'exit_rounded.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('e5c2e1b2-4991-45a1-bd0d-99b844feaf80', 'CraneK', '90 Elbow', 'Standard', 'Standard (Screw)', 30.0, 'standard_elbow_90.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('7536b61a-93bf-4e4c-b0a0-fd644a56062e', 'CraneK', '90 Elbow', 'Bend', 'Standard (r/d=1)', 20.0, 'bend_90.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('76ed1ee3-46c0-4d94-a9cc-f1bff2078d3d', 'CraneK', '90 Elbow', 'Bend', 'Long-radius (r/d=1.5)', 14.0, 'bend_90.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('f8e4e8ce-3b1a-4787-b9a0-08087947a7ed', 'CraneK', '90 Elbow', 'Bend', 'Long-radius (r/d=2)', 12.0, 'bend_90.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('aa323a46-c204-4c5e-8c90-de3aea2f4473', 'CraneK', '90 Elbow', 'Bend', 'Long-radius (r/d=3)', 12.0, 'bend_90.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('ca227d40-88eb-477c-970e-ddec2668121c', 'CraneK', '90 Elbow', 'Bend', 'Long-radius (r/d=4)', 14.0, 'bend_90.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('d79a71d3-54fd-4e0f-b3a8-2f9fd154cebf', 'CraneK', '90 Elbow', 'Bend', 'Long-radius (r/d=6)', 17.0, 'bend_90.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('9b27113f-9f68-4cd0-81da-96f796bca266', 'CraneK', '90 Elbow', 'Bend', 'Long-radius (r/d=8)', 24.0, 'bend_90.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('399716ad-5cc0-4d47-8530-cd4662a298d5', 'CraneK', '90 Elbow', 'Bend', 'Long-radius (r/d=10)', 30.0, 'bend_90.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('7b37b368-f33f-42fa-b3a7-d8432abde6b6', 'CraneK', '90 Elbow', 'Bend', 'Long-radius (r/d=12)', 34.0, 'bend_90.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('4e4f2bac-0f9e-4219-aba2-4a63e7d461eb', 'CraneK', '90 Elbow', 'Bend', 'Long-radius (r/d=14)', 38.0, 'bend_90.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('793b2ac9-aa91-4eb8-a406-a822b271d604', 'CraneK', '90 Elbow', 'Bend', 'Long-radius (r/d=16)', 42.0, 'bend_90.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('22962e0a-4ca3-4e6f-ab79-c9ccefe37929', 'CraneK', '90 Elbow', 'Bend', 'Long-radius (r/d=20)', 50.0, 'bend_90.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('07e530db-20ad-4345-b78a-27c1b7d4b639', 'CraneK', '90 Elbow', 'Miter', '1 weld (90 angle)', 60.0, 'miter.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('622ba25e-e07b-4cde-9933-6b02a75877fd', 'CraneK', '90 Elbow', 'Miter', '2 welds (45 angle)', 30.0, 'miter.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('85451819-04c9-40aa-a257-67cdcda24b23', 'CraneK', '90 Elbow', 'Miter', '3 welds (30 angle)', 24.0, 'miter.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('74425955-7581-4026-99b4-47ac3cc65123', 'CraneK', '90 Elbow', 'Miter', '6 welds (15 angle)', 24.0, 'miter.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('304010f3-6eff-4fee-ae8d-72ffd270e02f', 'CraneK', '45 Elbow', 'Standard', 'Standard (Screw)', 16.0, 'standard_elbow_45.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('f1da291f-b281-4dba-997f-3226f17366d2', 'CraneK', '45 Elbow', 'Miter', '1 weld (45 angle)', 15.0, 'miter.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('b337e57e-f991-4f77-8b9e-33997e59db7f', 'CraneK', '45 Elbow', 'Miter', '3 welds (15 angle)', 12.0, 'miter.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('708882f7-bba4-43ba-be1c-c19bb05462de', 'CraneK', '180 Elbow', 'Standard', 'Standard (Screw)', 50.0, 'return_bend.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('43d331ea-f66f-4ced-8a22-e94d43f2c74a', 'CraneK', '180 Elbow', 'Bend', 'Standard (r/d=1)', 2.0, 'bend_180.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('8b3224e1-784f-4203-9df5-14970f93d5d7', 'CraneK', '180 Elbow', 'Bend', 'Long-radius (r/d=1.5)', 2.0, 'bend_180.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('76d7a533-8bb2-42aa-a58a-b5a57fc1f73d', 'CraneK', '180 Elbow', 'Bend', 'Long-radius (r/d=2)', 2.0, 'bend_180.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('b2da93f1-c0d0-4592-897e-f55eeef8c472', 'CraneK', '180 Elbow', 'Bend', 'Long-radius (r/d=3)', 2.0, 'bend_180.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('6dada552-aed7-466b-b465-fa0de44a2160', 'CraneK', '180 Elbow', 'Bend', 'Long-radius (r/d=4)', 2.0, 'bend_180.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('ec1a9e7c-e2d9-4ebd-ac60-88fcec5a8eb3', 'CraneK', '180 Elbow', 'Bend', 'Long-radius (r/d=6)', 2.0, 'bend_180.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('8cbe9c68-5b05-470f-a39c-d271d7f63996', 'CraneK', '180 Elbow', 'Bend', 'Long-radius (r/d=8)', 2.0, 'bend_180.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('94d8bdc9-a044-4531-b6eb-f481396f1b9c', 'CraneK', '180 Elbow', 'Bend', 'Long-radius (r/d=10)', 2.0, 'bend_180.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('c8e9448f-e3e3-4b8a-b29c-2a75eeec3a33', 'CraneK', '180 Elbow', 'Bend', 'Long-radius (r/d=12)', 2.0, 'bend_180.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('92b6fe36-8af8-49cc-a760-4506592bcc0e', 'CraneK', '180 Elbow', 'Bend', 'Long-radius (r/d=14)', 2.0, 'bend_180.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('f83ce443-431e-44c0-9aab-2640b15c828c', 'CraneK', '180 Elbow', 'Bend', 'Long-radius (r/d=16)', 2.0, 'bend_180.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('65a9d9b2-adde-48d4-87bb-4288ade1c195', 'CraneK', '180 Elbow', 'Bend', 'Long-radius (r/d=20)', 2.0, 'bend_180.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('5c7c71df-0228-4caf-9362-b5fb0c62a7b3', 'CraneK', '180 Elbow', 'Miter', '2 welds (90 angle)', 120.0, 'miter.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('bccfdef8-e554-4980-a973-2ca7c333aad2', 'CraneK', '180 Elbow', 'Miter', '3 welds (60 angle)', 75.0, 'miter.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('3080568d-cd7a-445a-9ccf-70e41fe0928c', 'CraneK', '180 Elbow', 'Miter', '4 welds (45 angle)', 60.0, 'miter.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('7a11c767-9e66-4b73-8bd4-92bb870da36c', 'CraneK', '180 Elbow', 'Miter', '6 welds (30 angle)', 48.0, 'miter.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('d7faa2ad-cbd3-4c90-8548-4dad83b0366d', 'CraneK', '180 Elbow', 'Miter', '12 welds (15 angle)', 48.0, 'miter.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('9dc1be90-af68-48ab-9106-67c00046556b', 'CraneK', 'Tees', 'Standard', 'Flow through run', 20.0, 'tee_screwed_run.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('4dc8a38d-d953-4169-a31e-8f6f9d2a0f6c', 'CraneK', 'Tees', 'Standard', 'Flow through branch', 60.0, 'tee_screwed_branch.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('b6a5cc04-49f0-468a-a880-8d296fe85543', 'CraneK', 'Globe Valves', 'Globe', 'Standard', 340.0, 'globe_vv_standard.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('b9499eca-938b-4dfa-a481-34eec069dda5', 'CraneK', 'Globe Valves', 'Globe', 'Angled - 45 ˚', 55.0, 'globe_vv_45.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('77e409d4-e30e-430c-886a-555252d40de3', 'CraneK', 'Globe Valves', 'Globe', 'Angled - 90 ˚', 150.0, 'globe_vv_90.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('8b68da68-5486-4bf7-8814-d01383935c95', 'CraneK', 'Plug Valves', 'Plug', 'Straight-way', 18.0, 'plug_straight.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('b57d3b98-b978-4ff1-b28f-b258b331d61e', 'CraneK', 'Plug Valves', 'Plug', '3-way, Flow through run', 30.0, 'plug_3way_1.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('7a25f110-c93c-484b-82e0-eaa64f92271f', 'CraneK', 'Plug Valves', 'Plug', '3-way, Flow through branch', 90.0, 'plug_3way_2.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('e1fafe39-7f4e-4e69-80aa-cb601294fcb8', 'CraneK', 'Foot Valves', 'Foot', 'Foot Valve (Poppet Disc)', 420.0, 'foot_vv_poppet.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('e78fb6d2-aa6c-4c02-954c-e3d29e3c1685', 'CraneK', 'Foot Valves', 'Foot', 'Foot Valve (Hinged Disc)', 75.0, 'foot_vv_hinged.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('8daee505-4241-468d-a355-fb40e67000a5', 'CraneK', 'Etc Valves', 'Etc', 'Gate Valve', 8.0, 'gate_vv.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('6ef3f074-8271-420a-b5fc-53e96cfc94e3', 'CraneK', 'Etc Valves', 'Etc', 'Ball Valve', 3.0, 'ball_vv.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('37b266fe-73be-4b60-a95c-0208a776bb2d', 'CraneK', 'Etc Valves', 'Etc', 'Butterfly Valve', 0.0, 'butterfly_vv.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('74226f5a-3334-4329-aee5-90a3f0182bf6', 'CraneK', 'Pipe', 'Entrance', 'Pipe entrance (projecting)', 0.78, 'entrance_projecting.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('c79f339a-849b-4990-a4c5-c3f4119fa226', 'CraneK', 'Pipe', 'Entrance', 'Pipe entrance (flush) r/d=0.00', 0.5, 'entrance_flush.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('dddc660d-6c01-4102-b774-8c848d5fd30c', 'CraneK', 'Pipe', 'Entrance', 'Pipe entrance (flush) r/d=0.02', 0.28, 'entrance_flush.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('19089fa4-33e6-4d8b-a4cc-cb5a4d43000f', 'CraneK', 'Pipe', 'Entrance', 'Pipe entrance (flush) r/d=0.04', 0.24, 'entrance_flush.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('aa9d01db-ad5d-4069-940e-2b50010bc8e3', 'CraneK', 'Pipe', 'Entrance', 'Pipe entrance (flush) r/d=0.06', 0.15, 'entrance_flush.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('12a4528a-721d-48da-8db7-2e926e23e8eb', 'CraneK', 'Pipe', 'Entrance', 'Pipe entrance (flush) r/d=0.10', 0.09, 'entrance_flush.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('513198eb-a36c-4fde-98fe-e28a318b1a97', 'CraneK', 'Pipe', 'Entrance', 'Pipe entrance (flush) r/d=0.15', 0.04, 'entrance_flush.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('55e57bf2-a0e1-4c83-a885-cdd3d4e29156', 'CraneK', 'Pipe', 'Exit', 'Pipe exit (projecting)', 1.0, 'exit_projecting.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('8e802ae0-22ba-4da9-8c3c-9c993a874f30', 'CraneK', 'Pipe', 'Exit', 'Pipe exit (sharp-edged)', 1.0, 'exit_sharp_edged.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('5389b79a-609c-4e51-92d3-b95f5f18b1de', 'CraneK', 'Pipe', 'Exit', 'Pipe exit (rounded)', 1.0, 'exit_rounded.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('fe1c1ad7-9405-4ae6-95d0-b7db2c78e079', 'CraneK', 'Check Valves', 'Swing', 'Swing Check Valve (Vertical)', 50.0, 'swing_check_vv_ver.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('5c410f05-a1f3-4d18-806a-98d00ff22dd6', 'CraneK', 'Check Valves', 'Swing', 'Swing Check Valve (Angled)', 100.0, 'swing_check_vv_angled.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('2bdc252f-22f1-4f67-b909-b85a6e30fe5b', 'CraneK', 'Check Valves', 'Lift', 'Lift Check Valve', 600.0, 'lift_check_vv.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('0c00f201-b122-48f0-87f3-ed1abd925693', 'CraneK', 'Check Valves', 'Lift', 'Lift Check Valve (Angled)', 55.0, 'lift_check_vv_angled.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('c118da0f-8c34-40ae-8782-a9e0d368e5e3', 'CraneK', 'Check Valves', 'Tilting', 'Tilting-disk Check Valve (α=5 ˚)', 0.0, 'tilting_disc_check_vv.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('5c01640d-4211-4343-a07a-9eadd6d85f81', 'CraneK', 'Check Valves', 'Tilting', 'Tilting-disk Check Valve (α=15 ˚)', 0.0, 'tilting_disc_check_vv.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('8e2cdc5b-86ae-4f33-8127-9e3bf8c758c8', 'CraneK', 'Check Valves', 'Globe Stop', 'Globe Stop Check Valve', 400.0, 'globe_stop_check_vv_90.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('1398c102-c489-4de2-9e35-7235489d61ce', 'CraneK', 'Check Valves', 'Globe Stop', 'Globe Stop Check Valve (45 ˚)', 300.0, 'globe_stop_check_vv_45.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('653adcbc-1968-4766-98c8-f4cdf4d7bce4', 'CraneK', 'Check Valves', 'Globe Stop', 'Globe Stop Check Valve (inline)', 55.0, 'globe_stop_check_vv_inline.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('5dd16b9e-efcb-429c-9f1e-a544add08870', 'CraneK', 'Check Valves', 'Angled Stop', 'Angled Stop Check Valve', 200.0, 'angle_stop_check_vv_90.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('603dc870-198d-4e93-a115-d820e0497273', 'CraneK', 'Check Valves', 'Angled Stop', 'Angled Stop Check Valve (45 ˚)', 350.0, 'angle_stop_check_vv_45.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('372c9f2f-3f98-4fe6-a746-cd6d183260f0', 'CraneK', 'Check Valves', 'Angled Stop', 'Angled Stop Check Valve (inline)', 55.0, 'angle_stop_check_vv_inline.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('890006d1-e9c6-4709-81c3-4c8afe949000', 'CraneK', 'Reducer/Expander', 'Reducer', 'Reducer', 0.0, 'reducer.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('5911fa93-ed1c-4481-b936-f0eb9530741d', 'CraneK', 'Reducer/Expander', 'Expander', 'Expander', 0.0, 'expander.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('cfeb679e-f272-464e-8cea-4cc7177f42fd', 'CraneK', 'Manual', 'Manual', 'User Input', 0.5, 'user_input.png');

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('c7b61759-873d-488d-a7e0-677ee4c870e9', 'Equivalent_Length', 'Valves', 'Gate_Ball_Plug', 'Gate / Ball / Plug', NULL, NULL);

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('64ded43d-0c69-4c24-980a-75fd8b633b16', 'Equivalent_Length', 'Valves', 'Globe', 'Globe', NULL, NULL);

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('99911b7d-b9ab-43ea-884f-78b05bd12eaa', 'Equivalent_Length', 'Valves', 'Butterfly', 'Butterfly', NULL, NULL);

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('43d46dda-388a-4d5b-b892-3663a33694f8', 'Equivalent_Length', 'Valves', 'Check', 'Check', NULL, NULL);

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('38b70f6d-e9c4-48b9-be35-fab8396e17df', 'Equivalent_Length', 'Elbow', '90 Elbow', '90 Elbow', NULL, NULL);

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('83a65af2-4086-4836-8c81-1da66087fec2', 'Equivalent_Length', 'Elbow', '45 Elbow', '45 Elbow', NULL, NULL);

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('303bd313-70a5-4465-85ea-c4bffb695b6c', 'Equivalent_Length', 'Elbow', 'Miter', 'Miter', NULL, NULL);

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('b3f1de1b-41e7-4bfd-bb43-818fac7b1afb', 'Equivalent_Length', 'Tees', 'Tee branch', 'Tee branch', NULL, NULL);

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('5e3645cc-bbae-43c5-9a00-1dee08cba187', 'Equivalent_Length', 'Tees', 'Tee through', 'Tee through', NULL, NULL);

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('c06bb8ff-f5d4-4506-92a5-478dd181e1ad', 'Equivalent_Length', 'Nozzles', 'Nozzle In', 'Nozzle in', NULL, NULL);

INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('cc296474-9c65-472f-9a73-5cf666727a4d', 'Equivalent_Length', 'Nozzles', 'Nozzle Out', 'Nozzle out', NULL, NULL);