개정판 ef530805
issue #1043 : 시스템분석/설계 : Loops 테이블 변경, Nozzles 테이블 변경
Change-Id: I5534441f6a693516c34f727cb4d01fdfbf511a74
HYTOS/HYTOS/Scripts/CreateTables.sql | ||
---|---|---|
290 | 290 |
CREATE TABLE IF NOT EXISTS Loops ( |
291 | 291 |
UID TEXT NOT NULL, |
292 | 292 |
Name TEXT NOT NULL, |
293 |
From_Nozzles_UID TEXT NOT NULL,
|
|
294 |
Stream_No INTEGER NOT NULL,
|
|
295 |
To_Nozzles_UID TEXT NOT NULL,
|
|
293 |
From_Points_UID TEXT NOT NULL,
|
|
294 |
Stream_Line_UID TEXT NOT NULL,
|
|
295 |
To_Points_UID TEXT NOT NULL,
|
|
296 | 296 |
CONSTRAINT PK_Loops PRIMARY KEY ( |
297 | 297 |
UID |
298 | 298 |
), |
299 |
CONSTRAINT FK_From_Nozzles_UID FOREIGN KEY (
|
|
300 |
From_Nozzles_UID
|
|
299 |
CONSTRAINT FK_From_Points_UID FOREIGN KEY (
|
|
300 |
From_Points_UID
|
|
301 | 301 |
) |
302 |
REFERENCES Nozzles (UID),
|
|
303 |
CONSTRAINT FK_Stream_No FOREIGN KEY (
|
|
304 |
Stream_No
|
|
302 |
REFERENCES Points (UID),
|
|
303 |
CONSTRAINT FK_Stream_Line_UID FOREIGN KEY (
|
|
304 |
Stream_Line_UID
|
|
305 | 305 |
) |
306 |
REFERENCES HMB (Stream_No),
|
|
307 |
CONSTRAINT FK_To_Nozzles_UID FOREIGN KEY (
|
|
308 |
To_Nozzles_UID
|
|
306 |
REFERENCES Components (UID),
|
|
307 |
CONSTRAINT FK_To_Points_UID FOREIGN KEY (
|
|
308 |
To_Points_UID
|
|
309 | 309 |
) |
310 |
REFERENCES Nozzles (UID)
|
|
310 |
REFERENCES Points (UID)
|
|
311 | 311 |
); |
312 | 312 |
|
313 | 313 |
CREATE TABLE IF NOT EXISTS NominalDiameter ( |
... | ... | |
321 | 321 |
); |
322 | 322 |
|
323 | 323 |
CREATE TABLE IF NOT EXISTS Nozzles ( |
324 |
UID TEXT NOT NULL, |
|
325 | 324 |
Points_UID TEXT NOT NULL, |
326 | 325 |
Pressure REAL, |
327 | 326 |
Pressure_Drop REAL, |
... | ... | |
338 | 337 |
Suction_Line_Friction_Loss REAL, |
339 | 338 |
Line_Total_Frictoin_Loss REAL, |
340 | 339 |
CONSTRAINT PK_Nozzles PRIMARY KEY ( |
341 |
UID |
|
340 |
Points_UID
|
|
342 | 341 |
), |
343 | 342 |
CONSTRAINT FK_Points_UID FOREIGN KEY ( |
344 | 343 |
Points_UID |
내보내기 Unified diff