개정판 c6866fd3
issue #1043 : 시스템분석/설계 : Template.db 수정
Change-Id: I191583c5e4ca20913e82b151946297f0468a44d6
| HYTOS/HYTOS/Scripts/CreateTables.sql | ||
|---|---|---|
| 404 | 404 |
Category TEXT NOT NULL, |
| 405 | 405 |
Type TEXT NOT NULL, |
| 406 | 406 |
Name TEXT NOT NULL, |
| 407 |
K REAL NOT NULL,
|
|
| 408 |
Image TEXT NOT NULL,
|
|
| 407 |
K REAL, |
|
| 408 |
Image TEXT, |
|
| 409 | 409 |
CONSTRAINT PK_ResistanceCoefficient PRIMARY KEY ( |
| 410 | 410 |
UID |
| 411 | 411 |
), |
| HYTOS/HYTOS/Scripts/InitialData.sql | ||
|---|---|---|
| 800 | 800 |
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');
|
| 801 | 801 |
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');
|
| 802 | 802 |
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');
|
| 803 |
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);
|
|
| 804 |
INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('64ded43d-0c69-4c24-980a-75fd8b633b16', 'Equivalent_Length', 'Valves', 'Globe', 'Globe', NULL, NULL);
|
|
| 805 |
INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('99911b7d-b9ab-43ea-884f-78b05bd12eaa', 'Equivalent_Length', 'Valves', 'Butterfly', 'Butterfly', NULL, NULL);
|
|
| 806 |
INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('43d46dda-388a-4d5b-b892-3663a33694f8', 'Equivalent_Length', 'Valves', 'Check', 'Check', NULL, NULL);
|
|
| 807 |
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);
|
|
| 808 |
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);
|
|
| 809 |
INSERT INTO ResistanceCoefficient (UID, Method, Category, Type, Name, K, Image) VALUES ('303bd313-70a5-4465-85ea-c4bffb695b6c', 'Equivalent_Length', 'Elbow', 'Miter', 'Miter', NULL, NULL);
|
|
| 810 |
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);
|
|
| 811 |
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);
|
|
| 812 |
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);
|
|
| 813 |
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);
|
|
| 803 | 814 |
|
| 804 | 815 |
--Configuration |
| 805 | 816 |
INSERT INTO Configuration (Section, "Key", Value) VALUES ('Units', 'Flowrate_Mass', 'kg/h');
|
내보내기 Unified diff
