프로젝트

일반

사용자정보

개정판 ef530805

IDef5308056665a2a158723b72cbc36f87b8885135
상위 a4555e41
하위 d21025cf

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

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

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