프로젝트

일반

사용자정보

개정판 7345d960

ID7345d960ec3e47598f07951ca5fcfbe5356a290e
상위 857d5558
하위 d9aa8d67

김연진이(가) 약 5년 전에 추가함

issue #1043 : 시스템분석/설계 : Template.db 수정

Change-Id: I7f4ab6c5daf3a8e88537ebaa5268747b59ab4682

차이점 보기:

HYTOS/HYTOS/Scripts/CreateTables.sql
223 223 
    Inside_Pipe_Size         REAL,
224 224 
    Schedule_No              TEXT,
225 225 
    Straight_Length          REAL,
226 
    Equivalent_Length        REAL,
226 227 
    Equivalent_Length_Input  REAL,
227 228 
    Fitting_Length           REAL,
228 229 
    Fitting_K                REAL,
HYTOS/HYTOS/Scripts/InitialData.sql
1 1 
-- DisplayNames
2 
INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME, "Order") VALUES ('99baa4fc-bc4d-46bb-be9a-6e4f8802b991', 'HMB', 'UID', 'UID', 0);
3 
INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME, "Order") VALUES ('2007be94-56a4-48ac-b7df-df380f162e91', 'HMB', 'Components_UID', 'Components_UID', 1);
4 
INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME, "Order") VALUES ('2c73d94e-1fb1-49e7-9eb3-7e05f5d925dc', 'HMB', 'Stream_No', 'Stream No.', 2);
5 
INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME, "Order") VALUES ('7682cd15-b3c2-4b7d-8f43-858e2c153f30', 'HMB', 'Phase_Type', 'Phase (L/V/Mixed)', 3);
6 
INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME, "Order") VALUES ('fd749994-95d3-40ae-98d3-6cf050646868', 'HMB', 'Flowrate_Mass', 'Flowrate (Mass)', 4);
7 
INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME, "Order") VALUES ('4e3837b5-0d93-466e-a00f-5be0a5a17a2b', 'HMB', 'Flowrate_Volume', 'Flowrate (Volume)', 5);
8 
INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME, "Order") VALUES ('f17d7a86-bb29-41d7-8c6b-401f0d1bce7a', 'HMB', 'Density', 'Density', 6);
9 
INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME, "Order") VALUES ('9e60de3e-95eb-46d5-b66a-fa9955e2c0f5', 'HMB', 'Viscosity', 'Viscosity', 7);
10 
INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME, "Order") VALUES ('5ba88856-1c83-4fe2-b7fa-371256cab217', 'HMB', 'Temperature', 'Temperature', 8);
11 
INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME, "Order") VALUES ('70a04a4c-d393-438f-8a5f-a156192debb7', 'HMB', 'Molecular_Weight', 'Molecular Weight', 9);
12 
INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME, "Order") VALUES ('5376f061-5588-4348-abd8-cbe757007534', 'HMB', 'Specific_Heat_Ratio', 'Specific heat ratio (Cp/Cv)', 10);
13 
INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME, "Order") VALUES ('3fbde097-cdd0-490b-8e91-1ffe5a508a19', 'HMB', 'Compress_Factor', 'Compress. Factor (Z)', 11);
14 
INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME, "Order") VALUES ('06599f97-7940-475b-840c-d876660acae7', 'HMB', 'Nominal_Pipe_Size', 'Pipe Nominal Diameter', 12);
15 
INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME, "Order") VALUES ('0c9ceb14-0f21-4eba-8b83-3f63ca958f9f', 'HMB', 'Inside_Pipe_Size', 'Pipe Inside Diameter', 13);
16 
INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME, "Order") VALUES ('8965a13c-a27d-4fa8-882a-8343f634e293', 'HMB', 'Schedule_No', 'Sch. No.', 14);
17 
INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME, "Order") VALUES ('345c92bd-7fba-49ff-9a3b-654ab4c0a102', 'HMB', 'Straight_Length', 'Straight Length', 15);
18 
INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME, "Order") VALUES ('1a2f69f0-3961-4236-8782-ddbbea8ba50e', 'HMB', 'Equivalent_Length_Input', 'Equivalent Length (Input)', 16);
19 
INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME, "Order") VALUES ('870dfd2f-4b1c-4668-945e-10ccb62b40d3', 'HMB', 'Fitting_Length', 'Fitting Length', 17);
20 
INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME, "Order") VALUES ('02cade27-b08f-4fa8-a339-517a5bcb5033', 'HMB', 'Fitting_K', 'Fitting K', 18);
21 
INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME, "Order") VALUES ('517a1db2-498d-40c4-9661-602c39566810', 'HMB', 'Equivalent_Length_Cal', 'Equivalent Length (Cal''d)', 19);
22 
INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME, "Order") VALUES ('1a122a93-79b5-484c-b0a6-804a723068f1', 'HMB', 'Roughness', 'Roughness', 20);
23 
INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME, "Order") VALUES ('7b2301e2-345e-49eb-b2e3-0642e718adfa', 'HMB', 'Limitation_Velocity', 'Limitation of Velocity', 21);
24 
INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME, "Order") VALUES ('f28ce2e0-330c-445a-bb89-30be8a3e3760', 'HMB', 'Limitation_Pressure_Drop', 'Limitation of Pressure Drop', 22);
25 
INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME, "Order") VALUES ('face50fe-546f-4ed1-87a3-18734bb5c644', 'HMB', 'Velocity', 'Velocity', 23);
26 
INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME, "Order") VALUES ('922f3431-e339-4ee9-a6f8-02344b838032', 'HMB', 'Reynolds', 'Mach No.', 24);
27 
INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME, "Order") VALUES ('91f2a3e5-91d7-4ddf-9a87-8e733a3a48b7', 'HMB', 'Friction_Factor', 'Friction Factor', 25);
28 
INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME, "Order") VALUES ('c5a7b8c3-9360-40ce-84a4-0d0e2af1394b', 'HMB', 'Pressure_Drop', 'Pressure Drop', 26);
29 
INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME, "Order") VALUES ('3ffd7be4-cd37-4d80-8c37-45e0bb214b6a', 'HMB', 'Pressure_Drop_Friction', 'Pressure Drop (Friction)', 27);
30 
INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME, "Order") VALUES ('23c9d872-09c8-4e9f-a835-61a80fbb7c0e', 'HMB', 'Pressure_Drop_Static', 'Pressure Drop (Static)', 28);
31 
INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME, "Order") VALUES ('c9ed3327-ea90-4120-a471-d57edcd5eae7', 'HMB', 'Pressure_Pipe_End_Point', 'Pressure @ Pipe end point', 29);
32 
INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME, "Order") VALUES ('339227fd-03e9-44b3-8ca1-b6d585783964', 'HMB', 'Power', 'Power', 30);
33 
--
34 
INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME, "Order") VALUES ('a38b4759-656c-458a-8033-784d671f856d', 'Nozzles', 'Pressure', 'Pressure', 1);
35 
INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME, "Order") VALUES ('02fc05ea-ec79-4dda-8f78-1622bbd2619b', 'Nozzles', 'Pressure_Drop', 'Pressure Drop', 2);
36 
INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME, "Order") VALUES ('05d85742-f37d-456c-acc2-844bed4ad3bb', 'Nozzles', 'Elevation', 'Elevation', 3);
37 
INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME, "Order") VALUES ('9f17f500-98f3-4c77-9d32-bb1e27d4eae5', 'Nozzles', 'Over_Design_CV', 'Over_Design_CV', 4);
38 
INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME, "Order") VALUES ('c70efa69-8ff7-4cb9-90b4-f89e6da1ac1c', 'Nozzles', 'CV_Type', 'CV_Type', 5);
39 
INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME, "Order") VALUES ('f9b21ecc-6aab-414b-9479-706310fddcaa', 'Nozzles', 'Total_Discharge_Loss', 'Total_Discharge_Loss', 6);
40 
INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME, "Order") VALUES ('5d9c471c-4929-4979-920a-4063945f06f6', 'Nozzles', 'Total_Suction_Loass', 'Total_Suction_Loass', 7);
41 
INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME, "Order") VALUES ('d51474fa-6355-48e9-9ba7-8855b953ed37', 'Nozzles', 'Total_Loss', 'Total_Loss', 8);
42 
INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME, "Order") VALUES ('4e67ab73-9ca2-4e11-8f58-8e520d916731', 'Nozzles', 'Discharge_Device_Loss', 'Discharge_Device_Loss', 9);
43 
INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME, "Order") VALUES ('8b1a96ff-ef68-4ea1-ad2e-05681c2af372', 'Nozzles', 'Suction_Device_Loss', 'Suction_Device_Loss', 10);
44 
INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME, "Order") VALUES ('1159a010-84dc-42f5-9ae6-c73bb417a7ee', 'Nozzles', 'Total_Device_Loss', 'Total_Device_Loss', 11);
45 
INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME, "Order") VALUES ('63897149-bcf1-4533-9a20-5bc904d019a2', 'Nozzles', 'Discharge_Line_Friction_Loss', 'Discharge_Line_Friction_Loss', 12);
46 
INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME, "Order") VALUES ('ad8408af-47fc-4d8e-ae60-8db1f6e08c50', 'Nozzles', 'Suction_Line_Friction_Loss', 'Suction_Line_Friction_Loss', 13);
47 
INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME, "Order") VALUES ('4d3f65f5-29bb-4e7b-a43a-2e44cd51ce3d', 'Nozzles', 'Line_Total_Frictoin_Loss', 'Line_Total_Frictoin_Loss', 14);
2 
INSERT INTO DisplayNames (UID, Table_Name, Column_Name, Display_Name, "Order") VALUES ('99baa4fc-bc4d-46bb-be9a-6e4f8802b991', 'HMB', 'UID', 'UID', 0);
3 
INSERT INTO DisplayNames (UID, Table_Name, Column_Name, Display_Name, "Order") VALUES ('2007be94-56a4-48ac-b7df-df380f162e91', 'HMB', 'Components_UID', 'Components_UID', 1);
4 
INSERT INTO DisplayNames (UID, Table_Name, Column_Name, Display_Name, "Order") VALUES ('2c73d94e-1fb1-49e7-9eb3-7e05f5d925dc', 'HMB', 'Stream_No', 'Stream No.', 2);
5 
INSERT INTO DisplayNames (UID, Table_Name, Column_Name, Display_Name, "Order") VALUES ('7682cd15-b3c2-4b7d-8f43-858e2c153f30', 'HMB', 'Phase_Type', 'Phase (L/V/Mixed)', 3);
6 
INSERT INTO DisplayNames (UID, Table_Name, Column_Name, Display_Name, "Order") VALUES ('fd749994-95d3-40ae-98d3-6cf050646868', 'HMB', 'Flowrate_Mass', 'Flowrate (Mass)', 4);
7 
INSERT INTO DisplayNames (UID, Table_Name, Column_Name, Display_Name, "Order") VALUES ('4e3837b5-0d93-466e-a00f-5be0a5a17a2b', 'HMB', 'Flowrate_Volume', 'Flowrate (Volume)', 5);
8 
INSERT INTO DisplayNames (UID, Table_Name, Column_Name, Display_Name, "Order") VALUES ('f17d7a86-bb29-41d7-8c6b-401f0d1bce7a', 'HMB', 'Density', 'Density', 6);
9 
INSERT INTO DisplayNames (UID, Table_Name, Column_Name, Display_Name, "Order") VALUES ('9e60de3e-95eb-46d5-b66a-fa9955e2c0f5', 'HMB', 'Viscosity', 'Viscosity', 7);
10 
INSERT INTO DisplayNames (UID, Table_Name, Column_Name, Display_Name, "Order") VALUES ('5ba88856-1c83-4fe2-b7fa-371256cab217', 'HMB', 'Temperature', 'Temperature', 8);
11 
INSERT INTO DisplayNames (UID, Table_Name, Column_Name, Display_Name, "Order") VALUES ('70a04a4c-d393-438f-8a5f-a156192debb7', 'HMB', 'Molecular_Weight', 'Molecular Weight', 9);
12 
INSERT INTO DisplayNames (UID, Table_Name, Column_Name, Display_Name, "Order") VALUES ('5376f061-5588-4348-abd8-cbe757007534', 'HMB', 'Specific_Heat_Ratio', 'Specific heat ratio (Cp/Cv)', 10);
13 
INSERT INTO DisplayNames (UID, Table_Name, Column_Name, Display_Name, "Order") VALUES ('3fbde097-cdd0-490b-8e91-1ffe5a508a19', 'HMB', 'Compress_Factor', 'Compress. Factor (Z)', 11);
14 
INSERT INTO DisplayNames (UID, Table_Name, Column_Name, Display_Name, "Order") VALUES ('06599f97-7940-475b-840c-d876660acae7', 'HMB', 'Nominal_Pipe_Size', 'Pipe Nominal Diameter', 12);
15 
INSERT INTO DisplayNames (UID, Table_Name, Column_Name, Display_Name, "Order") VALUES ('0c9ceb14-0f21-4eba-8b83-3f63ca958f9f', 'HMB', 'Inside_Pipe_Size', 'Pipe Inside Diameter', 13);
16 
INSERT INTO DisplayNames (UID, Table_Name, Column_Name, Display_Name, "Order") VALUES ('8965a13c-a27d-4fa8-882a-8343f634e293', 'HMB', 'Schedule_No', 'Sch. No.', 14);
17 
INSERT INTO DisplayNames (UID, Table_Name, Column_Name, Display_Name, "Order") VALUES ('345c92bd-7fba-49ff-9a3b-654ab4c0a102', 'HMB', 'Straight_Length', 'Straight Length', 15);
18 
INSERT INTO DisplayNames (UID, Table_Name, Column_Name, Display_Name, "Order") VALUES ('dd27c84d-6b63-4e49-90e7-81eb34d3144c', 'HMB', 'Equivalent_Length', 'Equivalent Length', 16);
19 
INSERT INTO DisplayNames (UID, Table_Name, Column_Name, Display_Name, "Order") VALUES ('1a2f69f0-3961-4236-8782-ddbbea8ba50e', 'HMB', 'Equivalent_Length_Input', 'Equivalent Length (Input)', 17);
20 
INSERT INTO DisplayNames (UID, Table_Name, Column_Name, Display_Name, "Order") VALUES ('870dfd2f-4b1c-4668-945e-10ccb62b40d3', 'HMB', 'Fitting_Length', 'Fitting Length', 18);
21 
INSERT INTO DisplayNames (UID, Table_Name, Column_Name, Display_Name, "Order") VALUES ('02cade27-b08f-4fa8-a339-517a5bcb5033', 'HMB', 'Fitting_K', 'Fitting K', 19);
22 
INSERT INTO DisplayNames (UID, Table_Name, Column_Name, Display_Name, "Order") VALUES ('517a1db2-498d-40c4-9661-602c39566810', 'HMB', 'Equivalent_Length_Cal', 'Equivalent Length (Cal''d)', 20);
23 
INSERT INTO DisplayNames (UID, Table_Name, Column_Name, Display_Name, "Order") VALUES ('1a122a93-79b5-484c-b0a6-804a723068f1', 'HMB', 'Roughness', 'Roughness', 21);
24 
INSERT INTO DisplayNames (UID, Table_Name, Column_Name, Display_Name, "Order") VALUES ('7b2301e2-345e-49eb-b2e3-0642e718adfa', 'HMB', 'Limitation_Velocity', 'Limitation of Velocity', 22);
25 
INSERT INTO DisplayNames (UID, Table_Name, Column_Name, Display_Name, "Order") VALUES ('f28ce2e0-330c-445a-bb89-30be8a3e3760', 'HMB', 'Limitation_Pressure_Drop', 'Limitation of Pressure Drop', 23);
26 
INSERT INTO DisplayNames (UID, Table_Name, Column_Name, Display_Name, "Order") VALUES ('30c4b19e-758d-422f-9626-f845a1d5eae5', 'HMB', 'Separator', NULL, 24);
27 
INSERT INTO DisplayNames (UID, Table_Name, Column_Name, Display_Name, "Order") VALUES ('face50fe-546f-4ed1-87a3-18734bb5c644', 'HMB', 'Velocity', 'Velocity', 25);
28 
INSERT INTO DisplayNames (UID, Table_Name, Column_Name, Display_Name, "Order") VALUES ('922f3431-e339-4ee9-a6f8-02344b838032', 'HMB', 'Reynolds', 'Mach No.', 26);
29 
INSERT INTO DisplayNames (UID, Table_Name, Column_Name, Display_Name, "Order") VALUES ('91f2a3e5-91d7-4ddf-9a87-8e733a3a48b7', 'HMB', 'Friction_Factor', 'Friction Factor', 27);
30 
INSERT INTO DisplayNames (UID, Table_Name, Column_Name, Display_Name, "Order") VALUES ('c5a7b8c3-9360-40ce-84a4-0d0e2af1394b', 'HMB', 'Pressure_Drop', 'Pressure Drop', 28);
31 
INSERT INTO DisplayNames (UID, Table_Name, Column_Name, Display_Name, "Order") VALUES ('3ffd7be4-cd37-4d80-8c37-45e0bb214b6a', 'HMB', 'Pressure_Drop_Friction', 'Pressure Drop (Friction)', 29);
32 
INSERT INTO DisplayNames (UID, Table_Name, Column_Name, Display_Name, "Order") VALUES ('23c9d872-09c8-4e9f-a835-61a80fbb7c0e', 'HMB', 'Pressure_Drop_Static', 'Pressure Drop (Static)', 30);
33 
INSERT INTO DisplayNames (UID, Table_Name, Column_Name, Display_Name, "Order") VALUES ('c9ed3327-ea90-4120-a471-d57edcd5eae7', 'HMB', 'Pressure_Pipe_End_Point', 'Pressure @ Pipe end point', 31);
34 
INSERT INTO DisplayNames (UID, Table_Name, Column_Name, Display_Name, "Order") VALUES ('339227fd-03e9-44b3-8ca1-b6d585783964', 'HMB', 'Power', 'Power', 32);
48 35 

  		




  49
  36
  
    

  		




  50
  37
  
    

  		




  ......




  214
  201
  
    
INSERT INTO HMBUnits (UID, Column_Name, Units_Expression) VALUES ('5128a4d4-dbe7-44fd-97b6-f2f242229636', 'Nominal_Pipe_Size', '{Pipe_Diameter}');


  		




  215
  202
  
    
INSERT INTO HMBUnits (UID, Column_Name, Units_Expression) VALUES ('d398b4c5-0ff0-4140-bb64-e4aebc6aa7fd', 'Inside_Pipe_Size', '{Pipe_Diameter}');


  		




  216
  203
  
    
INSERT INTO HMBUnits (UID, Column_Name, Units_Expression) VALUES ('a32e623e-5f35-42b9-9d0c-723e401fa1d3', 'Straight_Length', '{Length}');


  		




  
  204
  
    
INSERT INTO HMBUnits (UID, Column_Name, Units_Expression) VALUES ('5ee50fbb-3604-4f14-bef4-d888a705988e', 'Equivalent_Length', '{Length}');


  		




  217
  205
  
    
INSERT INTO HMBUnits (UID, Column_Name, Units_Expression) VALUES ('4a383abc-4f4d-4607-9e20-d0896b45059b', 'Equivalent_Length_Input', '{Length}');


  		




  218
  206
  
    
INSERT INTO HMBUnits (UID, Column_Name, Units_Expression) VALUES ('39aa82e0-ed0d-4edf-aafe-4fd3be2ceb5f', 'Fitting_Length', '{Length}');


  		




  219
  207
  
    
INSERT INTO HMBUnits (UID, Column_Name, Units_Expression) VALUES ('f8819aca-747a-4a43-b871-6875335340c6', 'Equivalent_Length_Cal', '{Length}');


  		












내보내기  Unified diff




        
        

    















   



  

  
  클립보드 이미지 추가
  (최대 크기: 500 MB)